For inventory purposes, Heavenly Spices must produce at least 125boxes of each variety of Spice Mix. This holds for both Parts 1 and 2.
Project Part 1:
A. Set up a Linear Programming model to maximize profit. Identify the objective function and the formulas for all constraints.
B. Run the model, and provide a copy of your answer report.
C. In a summary, identify how many boxes of each spice mixes will be produced (does it make sense to make .65 of a box?) and how much of each ingredient will be left over in inventory.
D. For each type of spice mix, identify the limiting factor(s) which prevented Heavenly Spices from making more of that spice mix.
Project Part 2:
A. With the exception ofMarket Pantry, Heavenly Spices is able to sell no more than 400 boxes of each spice mixes. Heavenly Spicesis able to sell no more than 500 boxes of Market Pantry. Re-run your model and provide a copy of your answer report.
• Identify how many boxes of each spice mix will be produced and how much of each ingredient will be left over in inventory.
B. Continuing with demand constraints above, maintenance problems have limited today's production to no more than1600 units total. Re-run your model and provide a copy of your answer report.
• Identify how many boxes of each spice mix will be produced and how much of each ingredient will be left over in inventory.
Assignment Deliverables:
Create a spreadsheet that helps to answer these questions. Create a tab for each Project Part and produce an answer report within each tab.
Clearly answer each question that is part of the project. Most importantly, create a dashboard with instructions on how to use the optimization you have created.
It should have instructions on what things you could change (Recipes? Costs? Inventories? Other things?). It should have instructions on how to maximize profits. It should be well organized, well labeled, easy to use, and easy to understand.
Attachment:- Project File.rar