Product A is an assemble-to-order product. It has a lot size of 150, and currentlyhas an on-hand inventory of 110 units. There is a 2-week demand time fence and a12-week planning time fence. The following table gives the original forecast and theactual customer orders for the next 12 weeks:Week 1 2 3 4 5 6 7 8 9 10 11 12Forecast 80 80 80 70 70 70 70 70 70 70 70 70Demand 83 78 65 61 49 51 34 17 11 7 0 0a. Given this information, develop a realistic master schedule, complete with ATPlogic.b. Tell how you would respond to each of the following customer order requests.Assume these are independent requests, and do not have cumulative effects.■ 20 units in week 3■ 40 units in week 5■ 120 units in week 7

Product A is an assemble-to-order product. It has a lot size of 150, and currentlyhas an on-hand inventory of 110 units. There is a 2-week demand time fence and a12-week planning time fence. The following table gives the original forecast and theactual customer orders for the next 12 weeks:Week 1 2 3 4 5 6 7 8 9 10 11 12Forecast 80 80 80 70 70 70 70 70 70 70 70 70Demand 83 78 65 61 49 51 34 17 11 7 0 0a. Given this information, develop a realistic master schedule, complete with ATPlogic.b. Tell how you would respond to each of the following customer order requests.Assume these are independent requests, and do not have cumulative effects.■ 20 units in week 3■ 40 units in week 5■ 120 units in week 7

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter12: Queueing Models

Section: Chapter Questions

Problem 59P

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Given the following forecast and cost information, determine Production Coststhe total cost of a chase plan that uses regular time production Regular $ 50.00output of 400 units per month, overtime is used when needed Overtime $ 65.00up to a maximum of 40 units per month, and subcontracting Subcontracting $ 75.00is used if additional units are needed to meet the forecast.Month Forecast1 4302 4003 4404 4505 4806 480Total
Create a minimum cost chase plan for the forecast shown in the table. There is no beginning inventory and regular production capacity is 350 units and costs $8 per unit. Overtime costs $19 and is limited to 50 units per month and subcontracting is limited to 100 units per month and costs $14 per unit. What is the total plan cost? Hint: In a chase production plan, production is changed each time period to match the demand. Use regular production, overtime, and subcontracting to create the plan. Month Forecast Regular Overtime Subcontracting January 250 February 400 March 500 April 350
A manager is attempting to put together an agregate 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 forecast. Period 1 2 3 4 5 6 7 8 9 TotalForecast 190 230 260 280 210 170 160 260 180 1,940 The department now has 20 ful-time employees, each of whom produces 10 units of output per period at cost of $6 per unit. Beging inventory for period 1 is zero. Inventory carrying cost is $5 per unit per period, and backlog cost is $10 per unit per period. a. Will the current work force be able to handle the forecast demand? b. Determine the total cost of the plan, including production, inventory, and backorder cost.
The schedular at ZamTech uses MPS time-phased records for planning and item production. The planner is currently working on a schedule for a strut assembly, one of ZamTechs top-selling spare parts.The planner uses a production lot size of 170 and a safety stock of 15 for the strut assembly. The planner has the following forecasts (Ft) and orders (Dt) for the next 8 weeks, as shown in Table 1. Table 1 Week 1 2 3 4 5 6 7 8 Ft 130 130 130 140 140 140 145 145 Dt 45 38 18 Required: a) Help the master production scheduler to fill in the MPS time-phased record shown in Table 2 for the strut assembly. There are 120 units on hand. Table 2 1 2 3 4 5 6 7 8 Ft Dt EIt-1 Pt EIt ATPt b) Can the planner accept the following orders? Update the MPS time-phased record for accepted orders, in Table 3. Table 3 Order Quantity Desired week 1 120 4 2 144 6 3 100 2…
Silver Star Bicycle Company will be manufacturing both men’s and women’s models of its Easy-Pedal bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men’s and 125 women’s models to be shipped during the first month and 200 men’s and 150 women’s models to be shipped during the second month. Additional data are shown: Model Production Costs Current Inventory Men’s $120 20 Women’s 90 30 The company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. Formulate this problem as a linear programming model so that a production schedule can be established in order to minimize production and inventory costs and satisfies the labor-smoothing,…
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?
Prepare a Master Production Schedule (MPS) for an Agri-Chemical company given the following information: The forecast for each week of an eightweek schedule is 50 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are as follows:Week Customer Orders1 522 353 204 12Use a production lot size of 75 units and no beginning inventory.
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.
minco inc is a small manufaturer of fused magnesia and silica. Minco's continuous improvement efforts led to a capacity and production planning software. to prepare for the use of software, a spreadsheet was first used to determine the capacity requirements for the main equipment (the fusion furnances) and the production schedule for the main products. A major product had the following forecast and committed orders (all in thousand dollars): January Feburary Week 2 3 4 1 2 3 4 Forecast 56 56 56 66 66 66 66 Committed order 44 0 18 The initial inventory was 119,000 pounds and the minimum stock at the end week was to be 83,000 pounds. Calculate the economic production quantity (EPQ) if the annual demand is 3,000,000 pounds, setup cost is $350 per setup, inventory holding cost rate is 20 percent per year, unit cost is $2 per pound, demand rate is 500 pounds per hour, and production…
Cotton Island Fashions, a clothing producer, has generated a forecast for the next eightweeks. Demand is expected to be fairly steady, except for periods 3 and 4, which havehigher demands.Month 1 2 3 4 5 6 7 8 TotalForecast 1200 1200 1400 3000 1200 1200 1200 1200 11600The company typically hires seasonal workers to handle the extra workload in periods 3and 4. The cost for hiring and training a seasonal worker is $50 per worker, and thecompany plans to hire two additional workers and train them in period 3, for work in period4, and then lay them off (no cost for layoff). Develop an aggregate plan that uses steadyoutput from regular workers with added output from the two seasonal workers in period 4.The output rate for the seasonal workers is slightly less than that of regular workers, sotheir cost per unit is higher. The cost per unit for regular workers is $4 per unit, while costper unit for the seasonal workers is $5 per unit. Backlog cost is $1 per unit per period.