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.

# Category Archives: Excel

# 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?