Can you show me how to work this in excel 8. Nowjuice, Inc., produces Shakewell® fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next sixmonths.MonthMayJunJulAugSepOctForecast 4,000 4,800 5,600 7,200 6,400 5,000Use the following information to develop aggregate plans.Regular production cost$10 per caseRegular production capacity 5,000 casesOvertime production cost$16 per caseSubcontracting cost$20 per caseHolding cost$1 per case per monthBeginning inventoryDevelop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the Page 499lowest 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) tohandle variations in demand.c. Use overtime up to 750 cases per period and inventory to handle variations in demand.

Answered: Image /qna-images/answer/095620a9-3144-4a5b-86f7-fe85396818ba.jpg

Answered: . Nowjuice, Inc., produces Shakewell®…

. Nowjuice, Inc., produces Shakewell® fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months.

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

. 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
A forecast of 320 units in January, 400 units in February,and 240 units in March has been approved for the seismic-sensory product family manufactured at the Rockport facilityof Maryland Automated, Inc. Three products, A, B, and C,comprise this family. The product mix ratio for products A,B, and C for the past 2 years has been 35 percent, 40 percent,and 25 percent, respectively. Management believes that themonthly forecast requirements are evenly spread over the4 weeks of each month. Currently, 15 units of product C areon hand. The company produces product C in lots of 40, andthe lead time is 2 weeks. A production quantity of 40 unitsfrom the previous period is scheduled to arrive in week 1. Thecompany has accepted orders of 25, 9, 11, 5, 4, and 9 unitsof product C in weeks 1 through 6, respectively. Prepare aprospective MPS for product C and calculate the available-to-promise inventory quantities
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…
Sales for Pandora’s Jewellery for the past three months have been 200,350, and 287. Usea three-month moving average to calculate a forecast for the fourth month. If the actual demandfor month 4 turns out to be 300, calculate the forecast for month 5.
Problem 11-11 (Static) A manager is attempting to put together an aggregate plan for the coming nine months. She has obtained a forecast of expected demand for the planning horizon. The plan must deal with highly seasonal demand; demand is relatively high in periods 3 and 4, and again in period 8, as can be seen from the following forecasts. Period 1 2 3 4 5 6 7 8 9 Total Forecast 190 230 260 280 210 170 160 260 180 1,940 The department now has 20 full-time employees, each of whom produces 10 units of output per period at a cost of $6 per unit. Beginning inventory for period 1 is zero. Inventory carrying cost is $5 per unit per period, and backlog cost is $10 per unit per period. The manager has decided to use part-time workers to assist during seasonal peaks. The cost per unit, including hiring and training, is $11. The output rate is 10 units per worker per period for all workers. A maximum of 10 part-time workers can be used, and the same number of part-time workers…
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?
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?
A forecast of 240 units in January, 320 units in February, and 240 units in March has been approved for the seismic-sensory product family manufactured at the Rockport facility of Maryland Automated, Inc. Three products, A, B, and C, comprise this family. The product mix ratio for products A, B, and C for the past 2 years has been 35 percent, 40 percent,and 25 percent, respectively. Management believes that the monthly forecast requirements are evenly spread over the 4 weeks of each month. Currently, 10 units of product C are on hand. The company produces product C in lots of 40, and the lead time is 2 weeks. A production quantity of 40 units from the previous period is scheduled to arrive in week 1. Thecompany has accepted orders of 25, 12, 8, 10, 2, and 3 units of product C in weeks 1 through 6, respectively. Prepare a prospective MPS for product C and calculate the availableto-promise inventory quantities.
Develop a chase aggregate plan for Draper using apermanent workforce of 12 employees supplemented by overtime.All demand must be met each period.(a) Show what would happen if this plan were implemented.(b) Calculate the costs associated with this plan.(c) Evaluate the plan in terms of cost, customer service,operations, and human resources.
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.
Capacity planning requires a demand forecast for an extended period of time into thefuture. What concerns would you have regarding an extended forecast as a capacityplanner?