NowJuice, Inc. produces bottled pickle juice. A planner has developed an aggregate forecast for demand (in cases) for the next four months. Use the following information to develop an aggregate plan using the LEVEL strategy. Inventory holding cost is $1 per month per case and backlog cost is $5 per month per case. Beginning inventory is zero. Month May June July August Forecast 452 520 600 719 Cost Per Unit Monthly Capacity Regular Production 19.40 400 Overtime Production 1.5 x Regular Prod Cost 400 What is the TOTAL cost of the LEVEL plan over the planning horizon

NowJuice, Inc. produces bottled pickle juice. A planner has developed an aggregate forecast for demand (in cases) for the next four months. Use the following information to develop an aggregate plan using the LEVEL strategy. Inventory holding cost is $1 per month per case and backlog cost is $5 per month per case. Beginning inventory is zero. Month May June July August Forecast 452 520 600 719 Cost Per Unit Monthly Capacity Regular Production 19.40 400 Overtime Production 1.5 x Regular Prod Cost 400 What is the TOTAL cost of the LEVEL plan over the planning horizon

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

Deb 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?
Manager T. C. Downs of Plum Engines, a producer of lawn mowers and leaf blowers, must develop an aggregate plan given the forecast for engine demand shown in the table. The department has a regular output capacity of 135 engines per month. Regular output has a cost of $60 per engine. The beginning inventory is zero engines. Overtime has a cost of $100 per engine. a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Regular production can be less than regular capacity. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) b. Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $2 per engine per month. Backlog cost is $120 per engine per month. There should not be a backlog in the last month. Set regular production equal to the monthly average of total forecasted demand. Assume that using overtime is not an option. (Negative amounts…
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…
. Manager T. C. Downs of Plum Engines, a producer of lawn mowers and leaf blowers, must developan aggregate plan given the forecast for engine demand shown in the table. The department has aregular output capacity of 130 engines per month. Regular output has a cost of $60 per engine. Thebeginning inventory is zero engines. Overtime has a cost of $90 per engine.a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Regularproduction can be less than regular capacity. b. Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carryingcost is $2 per engine per month. Backlog cost is $90 per engine per month. There should not bea backlog in the last month.MONTH1 2 3 4 5 6 7 8 TotalForecast 120 135 140 120 125 125 140 135 1,040
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 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 (enter your responses as whole…
A manager is attempting to put together an aggregate production plan for the coming nine months. She has obtained forecasts of aggregate demand for the planning horizon. The plan must deal with highly seasonal demand; demand is relatively high in months 3 and 4, and again in month 8, as can be seen below: The company has 20 permanent employees, each of whom can produce 10 units of output per month at a cost of $6 per unit. Inventory holding cost is $5 per unit per month, and back-order cost is $10 per unit per month. The manager is considering a plan that would involve hiring two people to start working in month 1, one on a temporary basis who would work until the end of month 5. The hiring of these two would cost $500. Beginning inventory is 0.Start with 20 permanent workers. Prepare a minimum cost plan that may use some combination of hiring ($250 per worker), subcontracting ($8 per unit, maximum of 20 units per month, must use for at least three consecutive months), and overtime…
Southeast Soda Pop, Inc., has a new fruit drink forwhich it has high hopes. John Mitten thai, the production planner,has assembled the fo llowing cost data and demand forecast: John's job is to develop an aggregate plan. The three initialoptions he wants to evaluate are:• Plan A: a strategy that hires and fires personnel as necessaryto meet the forecast.• Plan B: a level strategy.• Plan C: a level strategy that produces 1,200 cases per quarterand meets the fo recast demand with inventory and subcontracting.a) Which strategy is the lowest-cost plan?b) If you are John's boss, the VP for operations, which p lan doyou implement and why?
Forecast 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)…
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.
Planners for a company that makes several models of skateboards are about toprepare the aggregate plan that will cover six periods. They now want toevaluate a plan that calls for a steady rate of regular output, mainly usinginventory to absorb the uneven demand but allowing some backlog. Overtimeand subcontracting are not used because they want a steady output. They intendto start with zero inventory on hand in the first period. Prepare an aggregate planand determine its cost using the following information. Assume a level of outputrate of 300 units per period with regular time. Note that the planned endinginventory is zero. There are 15 workers, and each can produce 20 units per Period 1 2 3 4 5 6 Total Forecast 200 200 300 400 500 200 1800 Cost Information:Regular time = $2 per skateboardOvertime = $3 per skateboardSubcontract = $6 per skateboardInventory = $1 per skateboard per period on average inventoryBack orders = $5 per skateboard per period
Assume an initial starting Ft of 200 units, a trend (Tt ) of 8 units, an alpha of 0.30, and a delta of 0.40. If actual demand turned out to be 288, calculate the forecast including trend for the next period.
Why do operations planning require that a forecast be expressed in terms of physical units for an individual goods and services?