One of PLE’s manufacturing facilities produces metal engine housings from sheet

One of PLE’s manufacturing facilities produces metal engine housings from sheet metal for both mowers and tractors. Production of each product consists of five steps: stamping, drilling, assembly, painting, and packaging to ship to its final assembly plant.
The production rates in hours per unit and the number of production hours available in each department are given in the following table:
Department
Mower Housings
Tractor Housings
Production Hours Available
Stamping
0.03
0.07
200
Drilling
0.09
0.06
300
Assembly
0.15
0.10
300
Painting
0.04
0.06
220
Packaging
0.02
0.04
100
In addition, mower housings require 1.2 square feet of sheet metal per unit and tractor housings require 1.8 square feet per unit, and 2,500 square feet of sheet metal is available.
Assignment:
The company would like to maximize the total number of housings they can produce during the planning period.
Formulate and solve a linear optimization model and recommend a production plan.
Illustrate the results visually to help explain them in a presentation to Ms. Burke. In addition, conduct whatever what-if analyses (e.g., run different scenarios and apply parameter analysis) you feel are appropriate to include.
Summarize your results in a well-written report.

You are the manager of an information technology (IT) team. Your employees go to

You are the manager of an
information technology (IT) team. Your employees go to training workshops and
national conferences to keep up-to-date in the field. You created a list of
expenses by category for each employee for the last six months. Now you want to
subtotal the data to review total costs by employee and then create a
PivotTable to look at the data from different perspectives.
You are to complete this assignment by downloading the instructions and the worksheet. There are 21 steps. Skip #19.

You are the digital marketing director for High West Fashions, a regional clothi

You are the digital marketing
director for High West Fashions, a regional clothing company that specializes
in custom t-shirts. Your company has decided to launch an online advertising
campaign that gives customers the ability to purchase heavily discounted
products. You have the task of determining the optimal amount of advertising to
purchase in order to maximize profit and most effectively utilize resources.
You are to complete this Assignment by downloading the instructions and the worksheet. There are 26 steps. Skip #25.

this part A of a excel project ,does anyone have a idea please accept this orde

this part A of a excel project ,does anyone have a idea please accept this order if you are able to work on excel you will do my excel project,
Use the attached Proposal Template to describe the purpose of your spreadsheet. Please give as much detail as you can about your project. (Some examples: sport stats, tracking sales for a fundraiser, event planner, etc…) Please be creative.
Instructor Note: Only one submission is permitted. Corrections will not be accepted. Please be sure to fill out all areas in the template for maximum points.
What problem does it solve for you?
How does it make your efforts to accomplish some tasks easier?
What would another user need to know about this sheet to keep it current?
Describe some of the features you have learned in this course that you think will help you in the

this part A of a excel project ,does anyone have a idea first we need idea for

this part A of a excel project ,does anyone have a idea first we need idea for this order then next order will be the project ,please accept this order if you are able to work on excel you will do my excel project,
Use the attached Proposal Template to describe the purpose of your spreadsheet. Please give as much detail as you can about your project. (Some examples: sport stats, tracking sales for a fundraiser, event planner, etc…) Please be creative.
Instructor Note: Only one submission is permitted. Corrections will not be accepted. Please be sure to fill out all areas in the template for maximum points.
What problem does it solve for you?
How does it make your efforts to accomplish some tasks easier?
What would another user need to know about this sheet to keep it current?
Describe some of the features you have learned in this course that you think will help you in the

Assessment Overview and Preparation For this assessment, analyze data using infe

Assessment Overview and Preparation
For this assessment, analyze data using inferential statistics for your previously defined survey questions. Before you begin your analysis, note the following:
When using the Inferential Statistics to Analyze Data Template, note that there are two pages. Be sure to review each one carefully. The first page is the blank template that you will complete, and the second page is a completed example. Try to model your results on the ones shown.
Enter the sample statistics (proportions and samples sizes for questions 1–4 as well as the sample means, standard deviations, and sample sizes for questions 5–6) in the respective fields of the template. The sample statistics were calculated for each survey question in Assessment 3. Use this prior work to complete this assessment. Note that the sample size must be the same for all six questions.
Generating the Inferential Statistics Results
Calculate a 95% confidence interval for each of your survey questions (1–6). Your final product should have six confidence intervals.
Perform a hypothesis test for each survey question (1–6). Your final product should have six hypothesis tests.
A few notes:
When determining the null and alternative hypotheses for each question, use the typical response values from Assessment 2.
You probably want to write the null hypothesis first. Then, the alternative hypothesis is the opposite of the alternative.
Use the same numerical value for the two hypotheses. You cannot put one value for the null and another for the alternative.
For questions 1–4, we are using the sample proportion to estimate the population proportion. For questions 5–6, we are using the sample mean to estimate the population mean. Thus, we use different formulas for their confidence intervals and for their test statistics in the hypothesis tests.

For this project you are planning the 10 day trip to Bali, Indonesia of a lifeti

For this project you are planning the 10 day trip to Bali, Indonesia of a lifetime or a family vacation; plan this trip for two people; you will have to calculate for two people. Please read carefully, here are the instructions:
Most people like to keep track of their expenses.
Create your own Daily Expense Tracking Spreadsheet Project that will be helpful for you to control your expense habits.
This vacation planner from Excel will help you to plan vacation costs and compare them with your total. Please set up your own realistic total budget for vacation expenses ahead of time so you’ll know exactly how much you can spend in key categories using your own family vacation budget template. (expenses like traveling, eating, internet bill, few categories of entertainment, gifts, categories for family expenses per member, taxi, bike/car rental, and a lot more.)
Your Excel file should contain:
– a summary master first tab and supporting tabs:
a) for each type of expense with all details of Daily Expense Tracking; b) data to be linked between tabs; c) visual data representations (charts); d) analysis /outcome optional: feel free to use/add any visual aids/pictures.
I like this article for places to go on the trip but you don’t necessarily have to use it: https://balicheapesttours.com/bali-tour-10D-9N.html
Good luck with vacation planning!

You must use every tool at your disposal. You must use clear, concise and appro

You
must use every tool at your disposal. You must use clear,
concise and appropriate formulas.
The
first page should be a cover page with hyperlinks to the other pages and a
picture in the background.
The
second page should be a dashboard (4+ charts on a sheet).
Include relative, absolute and mixed cell reference
use all the summary statistics (sum, average, min, max,
count, etc.)
use at least two different instances of date and time
functions
use at least three different formats such as number, date,
custom etc.
use at least three different instances of nested if functions
use vlookup and index/match functions
create and use range names and use them in formulas
use at least three instances of conditional formatting, one
of which needs to be custom formatted
design at least 2 tables
design at least 4 pivot tables
freeze panes
text boxes to explain
name your sheets and give them colors
sort the table at two levels or more
use the subtotal function
have at least four relevant pivot tables with at least two
calculated fields (measures) and a calculated item
have a slicer available for the pivot table
create a variable data table.

HEIGHT 1) Download the HEIGHT excel table filled by the class on the google driv

HEIGHT
1) Download the HEIGHT excel table filled by the class on the google drive. (See the link on
Canvas)
2) Using the do-file “importing and saving data.do”, import the data from Excel to Stata and save
them as a stata data set.
3) Using “setup.do”, open the HEIGHT.dta and set up a log file for your records.
4) Explore the distribution of the height using summarize and kdensity commands.
5) Generate a new variable representing a log transformation of the height.
gen ln_height = ln(height)
Explore the relationship between the original scales in feet and cm and the new scale in log
points.
6) Use describe command to get description of the variable. What is format of the gender variable?
Convert the gender variable into numeric format. To do so, generate a new variable F taking the
value of 0 for male students and 1 for female students. This can be done in two ways:
a)
gen F = 0
replace F = 1 if gender==”F”
b) The same job can be simply performed by just one command. Drop F before regenerating
it once again, and use another way:
drop F
gen F = (gender==”F”)
7) Explore the gender distribution in our class by using the tab command.
tab F
What are fractions of men and women in the class?
2
8) Explore the gender distribution in our class by using the sum command:
sum F
Compare the mean value with the percentage of women reported by the tab output. What do you
learn from the mean value of the binary variable F?

HEIGHT 1) Download the HEIGHT excel table filled by the class on the google driv

HEIGHT
1) Download the HEIGHT excel table filled by the class on the google drive. (See the link on
Canvas)
2) Using the do-file “importing and saving data.do”, import the data from Excel to Stata and save
them as a stata data set.
3) Using “setup.do”, open the HEIGHT.dta and set up a log file for your records.
4) Explore the distribution of the height using summarize and kdensity commands.
5) Generate a new variable representing a log transformation of the height.
gen ln_height = ln(height)
Explore the relationship between the original scales in feet and cm and the new scale in log
points.
6) Use describe command to get description of the variable. What is format of the gender variable?
Convert the gender variable into numeric format. To do so, generate a new variable F taking the
value of 0 for male students and 1 for female students. This can be done in two ways:
a)
gen F = 0
replace F = 1 if gender==”F”
b) The same job can be simply performed by just one command. Drop F before regenerating
it once again, and use another way:
drop F
gen F = (gender==”F”)
7) Explore the gender distribution in our class by using the tab command.
tab F
What are fractions of men and women in the class?
2
8) Explore the gender distribution in our class by using the sum command:
sum F
Compare the mean value with the percentage of women reported by the tab output. What do you
learn from the mean value of the binary variable F?