In: Operations Management
he manager of the O’Brian Glass Company is planning the production of automobile windshields for the next four months. The demand for the next four months is projected to be as shown in the following table.MonthDemand for Windshields1130214032604120 292 Chapter 5: Transportation, Assignment, and Network ModelsO’Brian can normally produce 100 windshields in a month. This is done during regular production hours at a cost of $100 per windshield. If demand in any one month cannot be satisfied by regular production, the production manager has three other choices: (1) He can produce up to 50 more windshields per month in overtime but at a cost of $130 per windshield; (2) he can purchase a limited number of windshields from a friendly competitor for resale at a cost of $150 each (the maximum number of outside purchases over the four-month period is 450 windshields); or (3) he can fill the demand from his on-hand inventory. The inventory carrying cost is $10 per windshield per month. Back orders are not permitted. Inventory on hand at the beginning of month 1 is 40 windshields. Set up and solve this “production smoothing” problem as a transportation model to minimize cost. Hint: Set the various production options (e.g., regular production, outside purchase, etc.) as supply nodes and the monthly demands as the demand nodes. MLA (Modern Language Assoc.) Balakrishnan, Nagraj, et al. Managerial Decision Modeling
Let the regular production per Month be
Month 1 = x1
Month 2 = x2
Month 3 = x3
Month 4 = x4
Let the overtime production per month be
Month 1 =x5
Month 2 = x6
Month 3 = x7
Month 4 = x8
Let the purchase from competitor per month be
Month 1 = x9
Month 2 = x10
Month 3 = x11
Month 4 = x12
Constraints:
Regular: x1, x2, x3, x4 ≤ 100
Overtime: x5,x6,x7,x8 ≤ 50
Purchase: x9 + x10 + x11 + x12 ≤ 450
Other constraints are Demand constraints, which are shown in excel
Ending inventory for each month cannot be less than zero.
The LP solution is presented in Excel.
Formulae: