Concept explainers
Nowjuice, Inc., produces Shakewell® fruit juice. A planner has developed an aggregate
Use the following information to develop aggregate plans.
Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? Note: Backlogs are not allowed.
a. Use level production. Supplement using overtime as needed.
b. Use a combination of overtime (500 cases per period maximum), inventory, and subcontracting (500 cases per period maximum) to handle variations in demand.
C. Use overtime up to 750 cases per period and inventory to handle variations in demand.
a)
To determine: The total cost using level strategy of aggregate planning.
Introduction: Level production strategy is a production strategy used to produce at a constant rate. This strategy keeps constant level of workforce and backlog of demand.
Answer to Problem 8P
Explanation of Solution
Given information:
Regular production cost is $10, overtime production cost is $16, subcontracting cost is $20, holding cost is $1, regular capacity is 5,000 units, and beginning inventory is given as 0 units. In addition to this forecast for 6 months is given as follows:
Month | July | June | July | August | September | October | Total |
Forecast | 4,000 | 4,800 | 5,600 | 7,200 | 6,400 | 5,000 | 33,000 |
Determine the total cost of the plan:
It is given that regular productions should be used. No backlogs are allowed. Supplements can be satisfied using overtime.
Supporting explanation:
Calculate the difference for the month of May:
It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is 1,000 units.
Calculate the difference for the month of June:
It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is 1,000 units.
Calculate the difference for the month of July:
It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is -600 units.
Note: The calculation repeats for all the months.
Beginning inventory:
The initial inventory is given as 0. For the remaining months, ending inventory of previous month would be the beginning inventory of present month.
Ending inventory for the month of May:
Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 1,000 units.
Ending inventory for the month of June:
Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 1,200 units.
Ending inventory for the month of July:
Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 600 units.
Note: The calculation repeats for all the months.
Average inventory for the month of May:
It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 500 units.
Average inventory for the month of June:
It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 1,100 units.
Average inventory for the month of July:
It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 900 units.
Note: The calculation repeats for all the months.
Calculate the regular time cost for the month of May:
Regular time cost per unit is given as $10 and regular time unit is given as 5,000. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $50,000.
Calculate the regular time cost for the month of June:
Regular time cost per unit is given as $10 and regular time unit is given as 5,000. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $50,000.
Calculate the regular time cost for the month of July:
Regular time cost per unit is given as $10 and regular time unit is given as 5,000. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $50,000.
Note: The calculation repeats for all the months.
Calculate the total regular time cost:
It is calculated by adding the regular time cost of all the months.
Hence, the total regular time cost is $300,000.
Calculate the overtime cost for the month of May:
Overtime cost per unit is given as $16 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.
Calculate the overtime cost for the month of June:
Overtime cost per unit is given as $16 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.
Calculate the overtime cost for the month of July:
Overtime cost per unit is given as $16 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.
Calculate the overtime cost for the month of August:
Overtime cost per unit is given as $16 and overtime unit is given as 1,600. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $25,600.
Note: The calculation repeats for all the months.
Calculate the total overtime cost:
It is calculated by adding the overtime cost of all the months.
Hence, the total overtime cost is 48,000.
Calculate the subcontract cost for the month of May:
Subcontract cost per unit is given as $20 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.
Calculate the subcontract cost for the month of June:
Subcontract cost per unit is given as $20 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.
Calculate the subcontract cost for the month of July:
Subcontract cost per unit is given as $20 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.
Note: The calculation repeats for all the months.
Calculate the total subcontract cost:
It is calculated by adding the subcontract cost of all the months.
Hence, the total subcontract cost is $0.
Calculate the inventory cost for the month of May:
It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $500.
Calculate the inventory cost for the month of June:
It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $1,100.
Calculate the inventory cost for the month of July:
It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $900.
Note: The calculation repeats for all the months.
Calculate the total inventory cost:
It is calculated by adding the inventory cost of all the months.
Hence, the total inventory cost is $2,800.
Calculate the total cost of the plan:
It is calculated by adding the total regular time cost, overtime cost, subcontract cost, and inventory cost.
Hence, the total cost of the plan is $350,800.
b)
To determine: The total cost using level strategy of aggregate planning.
Introduction: Level production strategy is a production strategy used to produce at a constant rate. This strategy keeps constant level of workforce and backlog of demand.
Answer to Problem 8P
Explanation of Solution
Given information:
Regular production cost is $10, overtime production cost is $16, subcontracting cost is $20, holding cost is $1, regular capacity is 5,000 units, and beginning inventory is given as 0 units. Maximum subcontract capacity is 500 units and maximum overtime capacity is 500 units. In addition to this forecast for 6 months is given as follows:
Month | July | June | July | August | September | October | Total |
Forecast | 4,000 | 4,800 | 5,600 | 7,200 | 6,400 | 5,000 | 33,000 |
Determine the total cost of the plan:
It is given that regular productions should be used. No backlogs are allowed. Supplements can be satisfied using overtime.
Supporting explanation:
Calculate the difference for the month of May:
It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is 1,500 units.
Calculate the difference for the month of June:
It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is 700 units.
Calculate the difference for the month of July:
It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is -100 units.
Note: The calculation repeats for all the months.
Beginning inventory:
The initial inventory is given as 0. For the remaining months, ending inventory of previous month would be the beginning inventory of present month.
Ending inventory for the month of May:
Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 1,500 units.
Ending inventory for the month of June:
Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 2,200 units.
Ending inventory for the month of July:
Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 2,100 units.
Note: The calculation repeats for all the months.
Average inventory for the month of May:
It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 750 units.
Average inventory for the month of June:
It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 1,850 units.
Average inventory for the month of July:
It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 2,150 units.
Note: The calculation repeats for all the months.
Calculate the regular time cost for the month of May:
Regular time cost per unit is given as $10 and regular time unit is given as 5,000. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $50,000.
Calculate the regular time cost for the month of June:
Regular time cost per unit is given as $10 and regular time unit is given as 5,000. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $50,000.
Calculate the regular time cost for the month of July:
Regular time cost per unit is given as $10 and regular time unit is given as 5,000. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $50,000.
Note: The calculation repeats for all the months.
Calculate the total regular time cost:
It is calculated by adding the regular time cost of all the months.
Hence, the total regular time cost is $300,000.
Calculate the overtime cost for the month of May:
Overtime cost per unit is given as $16 and overtime unit is given as 500. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $8,000.
Calculate the overtime cost for the month of June:
Overtime cost per unit is given as $16 and overtime unit is given as 500. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $8,000.
Calculate the overtime cost for the month of July:
Overtime cost per unit is given as $16 and overtime unit is given as 500. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $8,000.
Note: The calculation repeats for all the months.
Calculate the total overtime cost:
It is calculated by adding the overtime cost of all the months.
Hence, the total overtime cost is 40,000.
Calculate the subcontract cost for the month of May:
Subcontract cost per unit is given as $20 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.
Calculate the subcontract cost for the month of June:
Subcontract cost per unit is given as $20 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.
Calculate the subcontract cost for the month of July:
Subcontract cost per unit is given as $20 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.
Note: The calculation repeats for all the months.
Calculate the total subcontract cost:
It is calculated by adding the subcontract cost of all the months.
Hence, the total subcontract cost is $10,000.
Calculate the inventory cost for the month of May:
It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $750.
Calculate the inventory cost for the month of June:
It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $1,850.
Calculate the inventory cost for the month of July:
It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $2,150.
Note: The calculation repeats for all the months.
Calculate the total inventory cost:
It is calculated by adding the inventory cost of all the months.
Hence, the total inventory cost is $6,200.
Calculate the total cost of the plan:
It is calculated by adding the total regular time cost, overtime cost, subcontract cost, and inventory cost.
Hence, the total cost of the plan is $356,200.
c)
To determine: The total cost using aggregate planning.
Introduction: Level production strategy is a production strategy used to produce at a constant rate. This strategy keeps constant level of workforce and backlog of demand.
Answer to Problem 8P
Explanation of Solution
Given information:
Regular production cost is $10, overtime production cost is $16, subcontracting cost is $20, holding cost is $1, regular capacity is 5,000 units, overtime capacity is 750 units, and beginning inventory is given as 0 units. In addition to this forecast for 6 months is given as follows:
Month | July | June | July | August | September | October | Total |
Forecast | 4,000 | 4,800 | 5,600 | 7,200 | 6,400 | 5,000 | 33,000 |
Determine the total cost of the plan:
It is given that regular productions should be used. No backlogs are allowed. Supplements can be satisfied using overtime.
Supporting explanation:
Calculate the difference for the month of May:
It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is 1,000 units.
Calculate the difference for the month of June:
It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is 950 units.
Calculate the difference for the month of July:
It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is 150 units.
Note: The calculation repeats for all the months.
Beginning inventory:
The initial inventory is given as 0. For the remaining months, ending inventory of previous month would be the beginning inventory of present month.
Ending inventory for the month of May:
Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 1,000 units.
Ending inventory for the month of June:
Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 1,950 units.
Ending inventory for the month of July:
Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 2,100 units.
Note: The calculation repeats for all the months.
Average inventory for the month of May:
It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 500 units.
Average inventory for the month of June:
It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 1,475 units.
Average inventory for the month of July:
It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 2,025 units.
Note: The calculation repeats for all the months.
Calculate the regular time cost for the month of May:
Regular time cost per unit is given as $10 and regular time unit is given as 5,000. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $50,000.
Calculate the regular time cost for the month of June:
Regular time cost per unit is given as $10 and regular time unit is given as 5,000. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $50,000.
Calculate the regular time cost for the month of July:
Regular time cost per unit is given as $10 and regular time unit is given as 5,000. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $50,000.
Note: The calculation repeats for all the months.
Calculate the total regular time cost:
It is calculated by adding the regular time cost of all the months.
Hence, the total regular time cost is $300,000.
Calculate the overtime cost for the month of May:
Overtime cost per unit is given as $16 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.
Calculate the overtime cost for the month of June:
Overtime cost per unit is given as $16 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.
Calculate the overtime cost for the month of July:
Overtime cost per unit is given as $16 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.
Calculate the overtime cost for the month of August:
Overtime cost per unit is given as $16 and overtime unit is given as 1,600. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $25,600.
Note: The calculation repeats for all the months.
Calculate the total overtime cost:
It is calculated by adding the overtime cost of all the months.
Hence, the total overtime cost is 48,000.
Calculate the subcontract cost for the month of May:
Subcontract cost per unit is given as $20 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.
Calculate the subcontract cost for the month of June:
Subcontract cost per unit is given as $20 and subcontract unit is given as 750. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $12,000.
Calculate the subcontract cost for the month of July:
Subcontract cost per unit is given as $20 and subcontract unit is given as 750. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $12,000.
Note: The calculation repeats for all the months.
Calculate the total subcontract cost:
It is calculated by adding the subcontract cost of all the months.
Hence, the total subcontract cost is $48,000.
Calculate the inventory cost for the month of May:
It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $500.
Calculate the inventory cost for the month of June:
It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $1,475.
Calculate the inventory cost for the month of July:
It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $2,025.
Note: The calculation repeats for all the months.
Calculate the total inventory cost:
It is calculated by adding the inventory cost of all the months.
Hence, the total inventory cost is $5,700.
Calculate the total cost of the plan:
It is calculated by adding the total regular time cost, overtime cost, subcontract cost, and inventory cost.
Hence, the total cost of the plan is $350,800.
Conclusion: Plan from Part (a) should be selected, as it has the lowest cost ($350,800).
Want to see more full solutions like this?
Chapter 11 Solutions
Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences)
Additional Business Textbook Solutions
Operations Management
OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
Business in Action
Business in Action (8th Edition)
Operations Management: Sustainability and Supply Chain Management (12th Edition)
Principles of Operations Management: Sustainability and Supply Chain Management (10th Edition)
- Deb Bishop Health and Beauty Products has developed a new shampoo and you need to develop its aggregate schedule. The cost accounting department has supplied you the cost relevant to the aggregate plan and the marketing department has provided a four-quarter forecast. the four-quarter forecast. Quarter Forecast 1 1,400 2 1,100 3 1,700 4 1,300 the costs relevant to the aggregate plan. Costs Previous quarter's output 1,600 units Beginning inventory 0 units Stockout cost for backorders $55 per unit Inventory holding cost $11 per unit for every unit held at the end of the quarter Hiring workers $50 per unit Layoff workers $75 per unit Unit cost $35 per unit Overtime $20 extra per unit Subcontracting Not available Your job is to develop an aggregate plan for the next four quarters. Part 2 a) Try hiring and layoffs (to meet the forecast) as necessary…arrow_forwardPlease help me obtain the answer of this question. Please provide me the solution/computation.arrow_forwardmanager has prepared a forecast of expected aggregate demand for the next six months. Develop an aggregate plan to meet this demand given this additional information: A level production rate of 1000 units per month can be used. Backorders are allowed, and they are charged at the rate of $8 per unit per month. Inventory holding costs are $1 per unit per month based on maximum inventory. Determine the cost of this plan if regular time cost is $20 per unit, beginning inventory is zero, and initial backlog from previous plan is 100. Month Forecast 1 800 2 100 3 1200 4 1100 5 1000 6 900 a. Prepare an aggregate plan.b. Prepare an aggregate plan if the management decided to switch to chase…arrow_forward
- 1. Develop an aggregate plan for the following forecast Period 3 4 5 6 7 Total 1 2 8 Forecast 190 230 260 280 210 170 160 260 180 1,940 There are 20 workers who can produce 10 units per period at a cost of P6.00 per unit. There is no beginning invetory and the cost of carrying inventory is P5.00 per unit per period. Backlog cost is P10.00 per unit per period. Will the present workforce able to produce the forecast? b. What is the total cost of the plan? a.arrow_forwardDeb Bishop Health and Beauty Products has developeda new shampoo, and you need to develop its aggregate schedule.The cost accounting department bas supplied you the costsrelevant to the aggregate plan, and the marketing department hasprovided a four-quarter forecast. All are shown as follows: Your job is to develop an aggregate plan for the next four quarters.a) First, try hiring and layoffs (to meet the forecast) as necessary.b) Then try a plan that holds employment steady.c) Which is the more economical plan for Deb Bishop Healthand Beauty Products?arrow_forwardDeb Bishop Health and Beauty Products has developed a new shampoo and you need to develop its aggregate schedule. The cost accounting department has supplied you the cost relevant to the aggregate plan and the marketing department has provided a four-quarter forecast. Click the icon to view the four-quarter forecast. Click the icon to view the costs relevant to the aggregate plan. Your job is to develop an aggregate plan for the next four quarters. a) Try hiring and layoffs (to meet the forecast) as necessary (enter your responses as whole numbers). More Info Hiring and Layoff Plan Hire Layoff Quarter Forecast Production (Units) (Units) 1,600 1 1,400 1400 0 200 2 1,000 1,000 0 400 3 1,600 1,600 600 0 4 1,200 ☑ More Info Previous quarter's output Beginning inventory Stockout cost for backorders Inventory holding cost Hiring workers Layoff workers Unit cost Overtime Subcontracting Costs 1,600 units $45 per unit O units $11 per unit for every unit held at the end of the quarter $50 per…arrow_forward
- The forecast demand for fudge for the next four months is 120, 160, 20, and 60 pounds. a. What is the recommended production rate if a level strategy is adopted with no backorders or stock outs? b. What is the ending inventory for Month 4 under this plan? c. What is the level production rate with no ending inventory in month 4.arrow_forwardForecast Data is given within problem. Cost Data is attached Southeast Soda Pop, Inc., has a new fruit drink for which it has high hopes. John Mittenthal, the production planner, has assembled the following cost data and demand forecast: LOADING... Click the icon to view the demand forecast. LOADING... Click the icon to view the cost data. John's job is to develop an aggregate plan. The three initial options he wants to evaluate are: • Plan A: a strategy that hires and fires personnel as necessary to meet the forecast. • Plan B: a level strategy. • Plan C: a level strategy that produces 1,000 cases per quarter and meets the forecast demand with inventory and subcontracting. Part 2 a) Which strategy is the lowest-cost plan? Try hiring and layoffs (to meet the forecast) as necessary (enter your responses as whole numbers). Hiring and Layoff Plan Quarter Forecast Production Hire (Units) Layoff (Units)…arrow_forwardDeb Bishop Health and Beauty Products has developed a new shamp0o and you need to develop its aggregate schedule. The cost accounting department has supplied you the cost relevant to the aggregate plan and the marketing department has provided a four-quarter forecast. Click the icon to view the four-quarter forecast. Click the icon to view the costs relevant to the aggregate plan. Your job is to develop an aggregate plan for the next four quarters. a) Try hiring and layoffs (to meet the forecast) as necessary (enter your responses as whole numbers). Hiring and Layoff Plan Hire Layoff (Units) Quarter Forecast Production (Units) 1,500 1 1,400 Costs Previous quarter's output Beginning inventory 1,500 units O units $45 per unit $9 per unit for every unit held at the end of the quarter $40 per unit $70 per unit $35 per unit $20 extra per unit Stockout cost for backorders Inventory holding cost Quarter Forecast Hiring workers Layoff workers 1 1,400 2 1,000 Unit cost 3 1,600 Overtime 4 1,300…arrow_forward
- help:) thank you!! two partsarrow_forward7-3. Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next eight months. month Apr forecast 4500 May 4400 Jun 6200 Jul 6400 Aug 5800 Sep 6600 Oct 7200 Nov 6900 Use the following information to develop aggregate plans. Regular production cost: $10.00 per case Regular production capacity: 5,000 cases Overtime production cost: $16 per case Subcontracting cost: $20 per case Holding cost: $1 per case per month Beginning inventory: 0 Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? (a) Use level production of 5,000 case per month. Supplement using overtime as needed (b) Use a combination of overtime (500 cases per month for the first five months), inventory, and subcontracting (500 cases per month from September to November, if necessary) to handle variations in demand. Note that suitable amounts of overtime for the last…arrow_forwardA Pizza Company has a demand forecast for the next 12 months that is shown in Table 1 The current workforce of 100 staff can produce 1500 cases of pizzas per month. (a) Prepare a production plan that keeps the output level. How much warehouse space would the company need for this plan? (b) Prepare a demand chase plan. What implications would this have for staffing levels, assuming that the maximum amount of overtime would result in production levels of only 10 per cent greater than normal working hours? Table 1 demand forecast Month Demand (cases per month) January 600 February 800 March 1000 April 1500 May 2000 June 1700 July…arrow_forward