An assembly plant produces three models of their Ride-on Lawn Mower: Model A, Model B, and Model…

An assembly plant produces three models of their Ride-on Lawn Mower: Model A, Model B, and Model C. The “planning horizon” of their aggregate production plan (APP) is 12 months, combining all three models together in total monthly production quantities. The forecast of demand for the aggregate quantities of the three models is provided in the table below. You have the responsibility to choose the best APP approach between the “Level strategy” and the “Chase strategy”, based on one criterion: minimization of the total cost of the plan. Specifically, you must determine, for each of the two production approaches (strategies): ? The month-by-month production volume for each of the two strategies – Level and Chase ? The capacity needed, as applicable (for example, number of workers9 and number of labour hours) ? The number of units in inventory at the end of each month for each strategy ? The total cost of the plan for each strategy. AGGREGATE PLANNING INPUT INFORMATION Forecast Demand PERIOD FORECAST DEMAND (UNITS)
January 106
February 94
March 325
April 422
May 607
June 733
July 724
August 624
September 597
October 401
November 214
December 133
Round up to the next integer (do not use decimals for the number of workers)
Beginning and ending inventory.
The beginning inventory: 109 units.
Ending inventory: the firm desires to end the year with inventory on hand of 118 units.
Cost information o Average inventory cost per unit: $3,700.
o Holding cost rate for finished goods inventory: 18%. The holding cost for raw materials and for WIP is omitted for this planning task o
On average, 1 mower unit requires 14 hours of labour to produce, and one worker contributes 160 hours per month (this is an approximation calculated as: 8 hours x 5 days x 4 weeks) o The average cost of the labour hour: $35 o Cost of hiring additional workers (to increase the daily production rate): $1080 per mower unit o Cost of laying off workers (to decrease the daily production rate): $1010 per mower unit.
Policy information o
The company DOES NOT subcontract under any circumstances o
The company DOES NOT use overtime/idle time under any circumstances.
DELIVERABLES FOR THIS ASSIGNMENT
An Excel workbook containing: 1. Comprehensive tables identifying the input info and the results obtained for the four requirements specified above (separately for each strategy). For example, for the “level” strategy: a table that includes the forecast demand, the production volume, the capacity needed in hours and number of workers, and the ending inventory – all of which on a monthly basis as well as for the entire planning period.
2. Graphs (separately for each strategy) illustrating the fluctuating Ending Inventory levels month by month (include in the graphs the lines for Production and for Demand).
3. The calculation of the “total cost of the plan” for each strategy (if both strategies are feasible). Include only the relevant cost components that allow the comparison between the two Aggregate Plan approaches (for example, there is no need to include the cost of materials or the overhead)

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 MyhomeworkGeeks
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.
English 101
very good paper thank you.
Customer 453083, February 18th, 2022
Management
It was gotten well after time I needed to make needed additions, but it is something that did help me. I could not get the concept of ho to start such a project but now reading this, I was over thinking the project it seems.
Customer 452801, July 19th, 2021
Professions and Applied Sciences
Thanks. This helps a lot. Was a bit late but some cushion was given.
Customer 453015, February 10th, 2022
Other
Thank you , Excellent work
Customer 453201, June 2nd, 2022
Nursing
thank you so much
Customer 452749, June 10th, 2021
Social Work and Human Services
Although it took 2 revisions I am satisfied but I did receive it late because of that.
Customer 452603, March 25th, 2021
Psychology
quick, fast and exact!
Customer 453027, May 24th, 2022
Nursing
Thank you so much for your help! :)
Customer 453167, May 11th, 2022
Nursing
The writer was timely and proficient. I had to ask for a revision, but I got it back quickly with no other issues. Would use this essay writing service again
Customer 452441, November 14th, 2021
Emergency Management
Overall, I think it's a great service. I have yet to submit the assignment, so I don't know what kind of grade I'll get. But customer service was excellent. Reviews were made and the assignment proofed for satisfaction.
Customer 453015, December 15th, 2021
Humanities
Thank youuuu
Customer 452729, May 30th, 2021
Nursing
Thank you
Customer 453087, March 5th, 2022
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
Live ChatWhatsApp

Are You Looking For Assignment Help? We Can Certainly Assist You