Chat with us, powered by LiveChat 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 - Writingforyou

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

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