EMBA 630 – Individual Assignment 3SLOP Becomes Hearty GLOP

Individual Assignment 3SLOP Becomes Hearty GLOPAnn is a plant manager at Private Foods. Her plant makes Hearty Glop, a microwaveable dinner that is particularly popular in winter. Ann has to minimize her total annual cost while meeting demand each month. Monthly demand for Glop for the next year is forecasted as shown in the table below and in the GlopData.xlsx.The plant can make at most 2,500 units of Glop in any month.The main raw material for making Glop is an ingredient called Slop. Each unit of Glop requires 8 units of Slop. Private Foods purchases Slop from a number of different vendors. The price of Slop is fairly volatile. The accompanying table shows Ann’s forecasts of the monthly prices per unit for Slop for the next year.Each unit of Glop also requires 2 units of labor. Unit labor costs for the next year are forecasted as shown in the table. The plant can change the labor employed from month to month without additional costs.Up to 2,500 units of unsold Glop can be stored in the plant at a monthly cost of $20 per unit. Unused Slop cannot be stored because it congeals into an inedible form.The plant has 50 units of Glop available at the beginning of the first month.Note that the sequence of events in each period is: production, then sales, then storage.MonthGlop DemandSlop PriceLabor Price11100$60$1521200$60$1631300$65$1741000$70$185800$50$196500$40$197200$20$198200$10$189400$25$1710700$35$1711900$45$16121000$50$16Individual Assignment 3Prepare a lineardecision model to help Ann develop her production plan.Note:In answering questions a. – c., use the guidelines used during live sessions and from the memo above. In particular, the reader should be able to write out all formulations using your answers on these pages only (without referring to the Excel exhibit).Specify the decision variables.Specify the objective. This must be based on the inputs specified in the problem (the parameters), the decision variables specified in (a), and/or intermediate variables/values that you choose to specify.Specify the constraints. These must be based on the input numbers specified in the problem (the parameters), the decision variables specified in (a), and/or intermediate variables/values that you choose to specify.Include a picture/print of your spreadsheet formulation as Exhibit 1. Please note that in order to receive credit, your spreadsheet must be sufficiently annotated so that it is readable. Fit it to one page; if necessary, use landscape orientation to print. Ensure that row and column labels are visible and show formulas. What is the optimal production schedule?Ann would like to investigate the impact of the monthly unit storage cost on the optimal monthly production schedule, total annual cost, annual storage cost, annual Slop cost, and annual labor cost. Use SolverTable to exhibit this impact by varying the monthly storage cost from $0 per unit to $140 per unit in steps of $20. Include well-formatted, well-labeled table as Exhibit 2. Fit to one page; use landscape orientation if needed. How would you describe the impact of storage costs on the production schedule?

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Essay Fountain
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Advanced Technical Writing
Excellent service as always, Thank you!
Customer 452995, January 20th, 2022
Tourism
thank you
Customer 452933, November 20th, 2021
Sociology
I have never experienced receiving a paper past the due date and time. That is the only thing that displeases. I don't have time o Overall, your team does a great job.
Customer 452919, November 18th, 2021
Sociology
Thank you
Customer 452919, March 23rd, 2022
Communications
Thank you.
Customer 452723, April 22nd, 2021
Nutrition, Hospitality & Human Services
Thank you for your assistance.
Customer 452919, April 13th, 2024
Health Care
Thank you for getting this paper done in a timely manner
Customer 452641, February 20th, 2021
Criminal Justice
Very well and a good paper. Well worded and organized. I would like to know where the references come from
Customer 452519, June 13th, 2020
Sociology
Thank you
Customer 452919, February 16th, 2024
Marketing
Excellent and thank you!
Customer 452591, December 12th, 2020
Education
Very well written thank you
Customer 452667, April 8th, 2021
Psychology
Thank you so much!! Very much appreciated!
Customer 452717, April 20th, 2021
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat