Suppose, instead of planning only for two products to be made at one plant, LOGO has to plan production volumes for ten products. Furthermore, LOGO now operates two different factories, and it has the option to make any product on either or both (or neither) of the two plants. The necessary input data is available on the spreadsheet “LOGO Production Expanded.xlsx Download LOGO Production Expanded.xlsx.” Similar to the two-product, one-plant problem discussed in class, we are given the following information about each of the ten products: the maximum demand that LOGO can sell, selling price, raw material cost, and the number of molding and packing machine-hours required to produce per unit. For each of the two plants, we are given information on the number of molding and packing machine-hours available, and the operating costs per machine hour. Using this information, build an optimization model to determine LOGO’s optimal production plan for its ten products in the two plants.
Sheet1
Input Parameters | ||||||||||
Product Name | Santa's Grotto | Advent Calendar | Fire Station | Princess' Castle | White House | Rose Bouquet | Friendship Boat | Mona Lisa | Race Car | Planet Explorer |
Maximum Demand | 20000 | 60000 | 110000 | 110000 | 35000 | 70000 | 45000 | 30000 | 17000 | 35000 |
Selling Price | $55 | $35 | $80 | $80 | $65 | $45 | $65 | $75 | $150 | $50 |
Material Cost | $15 | $8 | $30 | $30 | $23 | $10 | $30 | $10 | $45 | $20 |
Molding machine-hours required | 0.01 | 0.002 | 0.007 | 0.01 | 0.01 | 0.007 | 0.005 | 0.003 | 0.03 | 0.006 |
Packing machine-hours required | 0.005 | 0.003 | 0.01 | 0.007 | 0.005 | 0.006 | 0.005 | 0.013 | 0.025 | 0.004 |
Machine-hours available | Cost per machine-hour | |||||||||
Molding at Plant 1 | 2000 | $500 | ||||||||
Packing at Plant 1 | 2200 | $800 | ||||||||
Molding at Plant 2 | 2200 | $400 | ||||||||
Packing at Plant 2 | 1700 | $650 | ||||||||
Decisions | ||||||||||
Santa's Grotto | Advent Calendar | Fire Station | Princess' Castle | White House | Rose Bouquet | Friendship Boat | Mona Lisa | Race Car | Planet Explorer | |
Production Quantity at Plant 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Production Quantity at Plant 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Objective | ||||||||||
Profit | To be filled in | |||||||||