tema 6 Revised Better Products

tema 6 Revised Better Products - C4:F6 Plant 2 $800...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Better Products Co. Production Planning Problem (Revised) Unit Cost Product 1 Product 2 Product 3 Product 4 Range Name Cells Plant 1 $41 $27 $28 $24 Assignment C19:F21 Plant 2 $40 $29 - $23 Cost C12:F14 Plant 3 $37 $30 $27 $21 Demand C24:F24 RequiredProduction C8:F8 Required Production 20 30 30 40 Supply I19:I21 TotalAssigned C22:F22 TotalAssignments G19:G21 Cost ($/day) Product 1 Product 2 Product 3 Product 4 TotalCost I24 Plant 1 $820 $810 $840 $960 UnitCost
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: C4:F6 Plant 2 $800 $870-$920 Plant 3 $740 $900 $810 $840 Total Assignment Product 1 Product 2 Product 3 Product 4 Assignments Supply Plant 1 1 1 2 <= 2 Plant 2 1 1 <= 2 Plant 3 1 1 = 1 Total Assigned 1 1 1 1 = = = = Total Cost Demand 1 1 1 1 $3,290 A B C D E F G H I J K L 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24...
View Full Document

This note was uploaded on 08/13/2011 for the course OPRES 206 taught by Professor Nea during the Spring '11 term at De La Salle University.

Ask a homework question - tutors are online