Homework #1. industrial engineering class

Homework #1

Don't use plagiarized sources. Get Your Custom Essay on
Homework #1. industrial engineering class
Just from $13/Page
Order Essay

IE 151 Spring 2015

Instructions: For each problem, create a new spreadsheet/worksheet (unless stated differently) in one Excel File.  When finished, submit the file on Canvas.

1)      Enter the following values in the appropriate reference cells

Number

Reference Cell

125

B4

35

B8

849

D4

20

D8

7

C10

 

2)      Using the same spreadsheet as problem one, conduct the following calculations into the appropriate cell.

Formula

Reference Cell

B4+B8

G4

B4/C10

G5

D8*D4

G6

B8^2+D8*C10

G7

D8*C10/D4

G8

 

3)      We are working for a company that makes automobiles.  The names of each of their models are named after the planets in the solar system.  The models that are made with their statistics, which consist of MPG, engine size (in Liters), fuel tank size (in Gallons), and horsepower, are presented below:

·         Jupiter –25 MPG, 2.7L, 21.1 Gal., 159 hp

·         Earth – 25 MPG, 3.5L, 23 Gal., 282 hp

·         Saturn – 25 MPG, 3.6L, 22 Gal., 305 hp

·         Mercury – 27 MPG, 2.5L, 21 Gal., 200 hp

·         Venus – 29 MPG, 2.2L, 18 Gal., 185 hp

·         Mars – 19 MPG, 4.2L, 28 Gal., 350 hp

The EPA wants to use a new system for rating the environmental impact from a vehicle.  The new rating is calculated with the information given, and is the impact is calculated with 25% from the MPG, 25% from the engine size, 30% from the horsepower, and 20% from the fuel tank size.

Create a table, with the car models in alphabetical order and determine their new EPA ratings.  Also find the average value, minimum value, and maximum value for each of the vehicle statistics, including the new EPA rating.

4)      Using the following information, create a Pareto Chart.  We are working at a facility that produces candy.  When the candy is made, there are possible defects that can occur.  The defects that have been found include:

·         50 from the candy not having color added

·         75 from the candy having the wrong weight (in the package)

·         20 from flavoring not added to the candy

·         25 from the candy not forming correctly

·         30 are due to the candy not having the right consistency

·         25 from the candy being made with the wrong recipe

·         25 other reasons

After creating the Pareto Chart, by using the Pareto Principle, what are the defects that are causing most of the problems? You can type your answer under the chart in the Excel File.

5)      We are working for a company that wants to establish charts to monitor their process.  The following table is their observations:

Calculate the UCL, CL, and LCL for an chart and R chart.

 

Also provide the graphs associated with an chart and R chart.

Looking for a Similar Assignment? Let us take care of your classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Use Code FREE20