# 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

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.