tema 6 Nifty - 7,000 1,000 8,000 = 8,000 UnitProfit C4:F6...

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

View Full Document Right Arrow Icon
Nifty Co. Product-Distribution Problem Unit Profit Customer 1 Customer 2 Customer 3 Customer 4 Range Name Cells Plant 1 $55 $42 $46 $53 MaxPurchase C19:F19 Plant 2 $37 $18 $32 $48 MinPurchase C15:F15 Plant 3 $29 $59 $51 $35 ProductionQuantity I11:I13 Shipment C11:F13 TotalProduction G11:G13 Total Production TotalProfit I17 Shipment Customer 1 Customer 2 Customer 3 Customer 4 Production Quantity TotalShipped C17:F17 Plant 1
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 7,000 1,000 8,000 = 8,000 UnitProfit C4:F6 Plant 2 5,000 5,000 = 5,000 Plant 3 6,000 1,000 7,000 = 7,000 Min Purchase 7,000 3,000 2,000 <= <= <= <= Total Profit Total Shipped 7,000 6,000 2,000 5,000 $1,076,000 <= <= <= <= Max Purchase 7,000 9,000 6,000 8,000 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...
View Full Document

Ask a homework question - tutors are online