Month# Forecast# Starting inv.# Net requirement# Prod. rate# Ending inv.# Stockout Jan 1200 239 0 Feb 2000 0 571 Mar 1000 0 381 Apr 500 309 0 May 1500 1 0 249 239 0 0 309 951 1761 XI 881 1191 1190 1190 1190 1190 1190 The table above provides the aggregate plan of Onyx Note Air tablet produced by a Chinese firm. It is known that the firm uses a level plan with backorders. Given this information, what is the number in the cell with xx? (If needed, round your final answer to nearest whole number (c)Orsdemir. Copyrighted material.)

Month# Forecast# Starting inv.# Net requirement# Prod. rate# Ending inv.# Stockout Jan 1200 239 0 Feb 2000 0 571 Mar 1000 0 381 Apr 500 309 0 May 1500 1 0 249 239 0 0 309 951 1761 XI 881 1191 1190 1190 1190 1190 1190 The table above provides the aggregate plan of Onyx Note Air tablet produced by a Chinese firm. It is known that the firm uses a level plan with backorders. Given this information, what is the number in the cell with xx? (If needed, round your final answer to nearest whole number (c)Orsdemir. Copyrighted material.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

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.
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.
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
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 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.
How does the Wilson approach handle demand forecasting and inventory planning for new product launches?
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…
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…
Prepare a Master Schedule like that shown in Figure 11.11 given the following information:The forecast for each week of an eight-week schedule is 50 units. The MPS tule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are as follows:Week 1.2.3.4Customer Orders 52.35.20.12Use a production lot size of 75 units and no beginning inventory.
A 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…
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.
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?