Scribd
Upload
46 views1 page

Matrix Formulae

This document provides a schedule for producing different products on two work centers (W/C) with information on the quantity, setup times derived from matrices, run hours, total hours and days to complete each item. It includes a formula to look up setup times from matrices based on the work center and product. The document suggests trying different sequence numbers and sorting to reduce total setup hours.

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
46 views1 page

Matrix Formulae

This document provides a schedule for producing different products on two work centers (W/C) with information on the quantity, setup times derived from matrices, run hours, total hours and days to complete each item. It includes a formula to look up setup times from matrices based on the work center and product. The document suggests trying different sequence numbers and sorting to reduce total setup hours.

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

Applying the Set-up Matrix Formula

Here is the schedule from Section 13 again, but this time the set-up times are derived from the
matrixes:

Set-up Units per Run Total


W/C Seq Product Qty hours hour hours Hours Days
1 1 Prod D 200 0.00 65 3.08 3.08 0.128205
1 2 Prod B 350 1.75 55 6.36 8.11 0.338068
1 3 Prod A 450 2.00 80 5.63 7.63 0.317708
1 4 Prod B 300 0.50 55 5.45 5.95 0.248106
2 1 Prod C 1500 0.00 135 11.11 11.11 0.462963
2 2 Prod D 1100 1.75 110 10.00 11.75 0.489583

Totals: 6.00 41.63

=IF(A7=A6,VLOOKUP(C6,INDIRECT("Matrix_"&A7),MATCH(C7,INDIRECT("Top_row_"&A7))),0)

Try changing the sequence numbers and sorting to see if you can reduce the total set-up hours

You might also like