Scribd
Upload
24 views1 page

Production Efficiency Analysis

The document compares two work centers for repetitive production and their setup times. Work Center 1 is an old machine that runs slowly but has quick setup times, while Work Center 2 is a new high-speed machine but has longer setup times. A table shows the setup hours and units produced per hour for each work center and different products. Another table schedules the production of various products across the two work centers, calculating quantities, run times, total hours, and days to complete based on the setup and run rate data.

Uploaded by

sahilsahni20
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
24 views1 page

Production Efficiency Analysis

The document compares two work centers for repetitive production and their setup times. Work Center 1 is an old machine that runs slowly but has quick setup times, while Work Center 2 is a new high-speed machine but has longer setup times. A table shows the setup hours and units produced per hour for each work center and different products. Another table schedules the production of various products across the two work centers, calculating quantities, run times, total hours, and days to complete based on the setup and run rate data.

Uploaded by

sahilsahni20
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Repetitive Production and Setups

Product A. Work Centre 1 is an old machine which runs slowly, but is quick to set up, and Work Centre 2
is a new high speed machine, but the set ups take a long time. We would describe this in tables like this:

Units per hour


Set up
W/C hours Product W/C 1 W/C 2
1 1.25 Prod A 80 140
2 3.00 Prod B 55 105
Prod C 72 135
Prod D 65 110

The left hand side of the schedule would look like this

Set up Units per Run Total


W/C Seq Product Qty hours hour hours Hours Days
1 1 Prod D 200 1.25 65 3.08 4.33 0.180288
1 2 Prod B 350 1.25 55 6.36 7.61 0.317235
1 3 Prod A 450 1.25 80 5.63 6.88 0.286458
1 4 Prod B 300 1.25 55 5.45 6.70 0.279356
2 1 Prod C 1500 3.00 135 11.11 14.11 0.587963
2 2 Prod D 1100 3.00 110 10.00 13.00 0.541667

=VLOOKUP(A18,B$8:C$9,2) - look up the work centre, 2nd column


=VLOOKUP(C18,E$8:G$11,A18+1) - look up the product, 2nd column for W/C 1, and
3rd column for W/C 2
=D18/F18 - run hours is quantity divided by units per hour
=E18+G18 - total hour is set up plus run

You might also like