tema 6 Better Products

tema 6 Better Products - Product 3 Product 4 At Plant...

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 Unit Cost Product 1 Product 2 Product 3 Product 4 Range Name Cells Plant 1 $41 $27 $28 $24 Capacity I11:I13 Plant 2 $40 $29 - $23 DailyProduction C11:F13 Plant 3 $37 $30 $27 $21 ProducedAtPlant G11:G13 ProductsProduced C14:F14 RequiredProduction C16:F16 Produced TotalCost I16 Daily Production Product 1 Product 2
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Product 3 Product 4 At Plant Capacity UnitCost C4:F6 Plant 1 30 30 60 <= 75 Plant 2 15 15 <= 75 Plant 3 20 25 45 <= 45 Products Produced 20 30 30 40 = = = = Total Cost Required Production 20 30 30 40 $3,260 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...
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