How much of each ingredient will be left over in inventory

Assignment Help Management Information Sys

Reference no: EM131898289

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

Reference no: EM131898289

Questions Cloud

What is the breakeven point in volume of clinic visits : Variable costs are projected at $200 per clinic visit, and fixed costs for the agreement are $800,000. What is the breakeven point in volume of clinic visits?

What is the effective interest rate : What is the effective interest rate if the clinic pays on day 16? On day 30?

Describe an effective recruitment and selection process : Explain the importance of measuring key competencies and skills. Describe an effective recruitment and selection process.

Calculate the theoretical spot rate : Given the following table of spot and coupon rates for Treasury Securities. How do I Calculate the theoretical spot rate for the 2 years Treasury

How much of each ingredient will be left over in inventory : Identify how many boxes of each spice mix will be produced and how much of each ingredient will be left over in inventory.

Calculate the yield for portfolio : Calculate the yield for this portfolio. (assume that interest is paid in the same dates for the 3 bonds).

What events led to the healthsouth accounting scandal : What events led to the HealthSouth accounting scandal? What is your process for delivering unfavorable news of a project's performance?

Inherited an ordinary annuity : Today you inherited an ordinary annuity of $25000 paid at the end of the year for 15 years. You estimated a yield of 10% for this annuity.

What is the projected retained earnings : Assume the profit margin and dividend payout ratios are constant. What is the projected retained earnings on the Income Statement if sales increase by 7 percent

User Account

All Pages