COMM29011590 Q 1

COMM29011590 Q 1 - Question 1 Problem#30 Input Data Beg Inv...

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

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Question 1 Problem #30 Input Data Beg Inv = 0 Demand Costs I0=0 50 $ 5.00 $ Month 1 I1 Month2 I2 65 8.00 Month3 I3 100 $ 4.00 Month4 I4 0 $ 70 7.00 /unit Action Plan # to make Units Supplied Units Demanded On Hand After Production Month 1 115 115 >= 50 65 Month2 0 65 >= 65 0 Month3 170 170 >= 100 70 Month4 0 70 >= 70 0 units units >= Costs Production Costs Inventory Costs Total Costs $ $ $ Month 1 575.00 130.00 705.00 $ $ $ Month2 Month3 $ 680.00 $ 140.00 $ 820.00 $ $ $ Month4 $ $ $ Total 1,255.00 270.00 1,525.00 Target Cell Changing Cells Constraints: G23 C12:F12 C13:F13>=C15:F15 C17:F17>=H17  ­ Min  ­ Assume Linear  ­ Assume Non ­Neg The opBmal soluBon is to, for months 1, 2, 3, and 4, produce 115, 0, 170, and 0 units respecBvely. $ Costs Selling Price 2.00 $ 6.00 /unit = End Inv 0 units ...
View Full Document

This note was uploaded on 06/08/2010 for the course COMM 296 taught by Professor Dasgupta during the Winter '08 term at UBC.

Ask a homework question - tutors are online