Problem 4. Considered a (s,S) system, with s = 80 and S = 200. The forecasted demand for the next 12 months is given in the following table. Initial inventory is 180, lead time is zero, and review is done at the end of every month. Find the order quantity. Mes, t 1 2 3 4 5 6 7 8 9 10 11 12 Demanda, D 65 110 80 150 120 90 50 170 140 125 55 80

Problem 4. Considered a (s,S) system, with s = 80 and S = 200. The forecasted demand for the next 12 months is given in the following table. Initial inventory is 180, lead time is zero, and review is done at the end of every month. Find the order quantity. Mes, t 1 2 3 4 5 6 7 8 9 10 11 12 Demanda, D 65 110 80 150 120 90 50 170 140 125 55 80

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

21. Given the forecast and booked orders shown in the table below, and a beginning inventory of 45, what is the master production schedule quantity for period 4 if you want to end period 4 with 0 inventory? Period 1 2 3 4 Forecasted Demand 70 65 60 55 Booked Orders 80 60 30 50 Projected ending inventory Master production schedule 70 60 65 Available to Promise 0 Group of answer choices 35 30 20 25
Over the past 12 months, Super Toy Mart hasexperienced a demand variance of 10,000 units and has produced an order variance of 12,000 units.a) What is the bullwhip measure for Super Toy Mart?b) If Super Toy Mart had made a perfect forecast of demandover the past 12 months and had decided to order 1/12 ofthat annual demand each month, what would its bullwhipmeasure have been?
Transcribed Image Text On hand: 35 Planning time fence: 10 Lot size: 200 Demand time fence: 2 Period 2 4 6. 7 9. 10 11 12 Forecast 30 40 40 50 40 40 30 40 40 50 40 40 Customer Orders 31 35 29 21 17 14 33 11 5 2 Projected Available Available to Promise MPS 200 200 3. a. Given the following master schedule, fill in the projected available and availableto promise rows: b. A customer wants an order of 100 in period 4. What can you tell him?c. The customer from part (b) cancels his request, but then says he wants 120 in period 5.What do you tell him now?d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs for a sales promotion. What do you tell them and why?e. What action (if any) should be taken in period 11? Why is it okay to take theaction? I only need question D and E answered
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…
Q2) Eagle Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. Quarter Demand Previous quarter's output 1500 units 1 1400 Beginning inventory 200 units 2 1000 Stockout cost $50 per unit 3 1500 Inventory holding cost $8 per unit at end of quarter 4 1300 Hiring workers $5 per unit Laying off workers $10 per unit Unit cost $30 per unit Overtime $10 extra per unit Which of the following production plans is better: Plan A—chase demand by hiring and layoffs; or Plan B—produce at a constant rate of 1200 and obtain the remainder from overtime? Finish the calculation. image
Musa's Cashmere Sweaters has authorized the following MPS for her exclusive line of cashmere sweaters. She wants to use the MPS record for promising future orders. Current order promises are included. The MPS order quantity is 60 units. Beginning Inventory is 0. Complete the following MPS record. Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 15 15 15 15 20 20 20 20 25 25 25 25 Customer orders 12 10 8 25 40 0 15 30 30 0 0 40 Projected available Available-to-promise MPS 60
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: demand forecast. Quarter Forecast 1 1,900 2 1,200 3 1,600 4 800 Costs/Other Data Previous quarter's output=1,200 cases Beginning inventory=0 cases Stockout cost of backorders=$160 per case Inventory holding cost=$40 per case at end of quarter Hiring employees=$35 per case Terminating employees=$80 per case Subcontracting cost=$65 per case Unit cost on regular time=$30 per case Overtime cost=$20 extra per case Capacity on regular time=1,900 cases per quarter 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…
1. The Kintampo Tourist Resort (KTR) is one of Ghana’s best holiday centers and sells a special type of souvenir called Expensive. As you might expect, the demand for Expensive is highly seasonal as tourist centers exhibit a highly seasonal attraction pattern, with peaks during the summer months. The following forecasts are available for Expensive.Inventory carrying cost = GH¢3 per piece per quarter Production per employee = 1000 piece per quarter Regular workforce = 50 workersCost of regular production = GH¢50 per piece Hiring cost per employee = GH¢75Firing cost per employee = GH¢100 The management of KTR does not wish to use Level production nor Chase Demand but wants to adopt one of the following strategies:Strategy I: Produce 71,000 pieces in Quarter 1, Produce 151,000pieces in Quarter 2, Produce 200,000 pieces in Quarter 3,and Produce 30,000 pieces in Quarter 4.Strategy II: Produce 51,000 pieces in Quarter 1, Produce 161,000pieces in Quarter 2, Produce 210,000 pieces in Quarter…
Using the information in Problem (The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct a netmaterial requirements plan using the following on-hand inventory.
manager 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…
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.
Jose Martinez of El Paso had developed a polished stainless-steel tortilla machine that makes it a “showpiece” for display in Mexican restaurants. He needs to develop a 5-month aggregate plan. His forecast of capacity and demand follows: Month 1 2 3 4 5 Demand 150 160 130 200 210 Regular capacity 150 150 150 150 150 Overtime capacity 20 20 10 10 10 Subcontracting: 100 units available over the 5-month period (NOT 100 units each month) Beginning inventory: 0 units Ending inventory required at the last month (i.e. month 5): 20 units. Costs Regular-time cost per unit $100 Overtime cost per unit $125 Subcontracting cost per unit $135 Inventory holding cost per unit per month $3 Assume that backorders are not permitted. a) Find an aggregate production plan using the intuitive lowest cost approach. (i.e. Develop an aggregate plan using the transportation method). b) State the corresponding…