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 | |||||||||
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
