Operations Management: Processes and Supply Chains (11th Edition)
11th Edition
ISBN: 9780133872132
Author: Lee J. Krajewski, Manoj K. Malhotra, Larry P. Ritzman
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 11, Problem 5P
Tabard Industries forecasted the following demand for one of its most profitable products for the next 8 weeks: 120, 120, 120, 100, 100, 100, 80, and 80 units. The booked customer orders for this product, starting in week 1 are: 100, 80, 60, 40, 10, 10, 0, and 0 units. The current on-hand inventory is 150 units, the order quantity is 200 units, and the lead time is 1 week.
- Develop a MPS for this product.
- The marketing department revised its
forecast. Starting with week 1, the new forecasts are: 120, 120, 120, 150, 150, 150, 100, and 100 units. Assuming that the prospective MPS you developed in part (a) does not change, prepare a revised MPS record. Comment on the situation that Tabard now faces. - Returning to the original forecasted demand level and the MPS record you developed in part (a), assume that marketing accepted a new customer order for 200 units in week 2, and thereby booked orders in week 2 is now 280 units. Assuming that the prospective MPS you developed in part (a) does not change, prepare a revised MPS record. Comment on the situation that Tabard now faces.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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…
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…
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
Chapter 11 Solutions
Operations Management: Processes and Supply Chains (11th Edition)
Ch. 11 - Consider the master flight schedule of a major...Ch. 11 - For an organization of your choice, such as where...Ch. 11 - Consider a service provider that is in the...Ch. 11 - Complete the MPS record in Figure 11.29 for a...Ch. 11 - Complete the MPS record in Figure 11.30 for a...Ch. 11 - Prob. 3PCh. 11 - Figure 11.31 shows a partially completed MPS...Ch. 11 - Tabard Industries forecasted the following demand...Ch. 11 - Figure 11.32 shows a partially completed MPS...Ch. 11 - The forecasted requirements for an electric hand...
Ch. 11 - A forecast of 240 units in January, 320 units in...Ch. 11 - An end items demand forecasts for the next 6 weeks...Ch. 11 - An end items demand forecasts for the next 10...Ch. 11 - Consider the bill of materials (BOM) in Figure...Ch. 11 - Product A is made from components B, C, and D....Ch. 11 - What is the lead time (in weeks) to respond to a...Ch. 11 - Product A is made from components B and C. Item B,...Ch. 11 - Refer to Figure 11.23 and Solved Problem 1. If...Ch. 11 - The partially completed inventory record for the...Ch. 11 - The partially completed inventory record for the...Ch. 11 - The partially completed inventory record for the...Ch. 11 - Figure 11.38 shows a partially completed inventory...Ch. 11 - A partially completed inventory record for the...Ch. 11 - The BOM for product A is shown in Figure 11.40,...Ch. 11 - The BOMs for products A & B and data from the...Ch. 11 - Figure 11.42 illustrates the BOM for product A....Ch. 11 - The following information is available for three...Ch. 11 - Figure 11.44 shows the BOMs for two products, A...Ch. 11 - The BOM for product A is shown in Figure 11.45....Ch. 11 - Refer to Solved Problem 1 (Figure 11.23) for the...Ch. 11 - The bill of materials and the data from the...Ch. 11 - The bill of materials and the data from the...Ch. 11 - The McDuff Credit Union advertises their ability...Ch. 11 - Suppose that the POQ for item B is changed from 3...Ch. 11 - As the on-hand inventory for item C increases from...Ch. 11 - As the fixed order quantity (FOQ) for item D...Ch. 11 - As the lead time for item C changes, what happens...
Additional Business Textbook Solutions
Find more solutions based on key concepts
Feeding America Each year, the Feeding America network helps provide food to more than 46 million people facing...
Operations and Supply Chain Management 9th edition
What are the three major business functions, and how are they related to one another? Give specific examples.
Operations Management, Binder Ready Version: An Integrated Approach
Many companies including Company OM tried to implement dynamic pricing in their ticketing system. The dynamic p...
Principles of Operations Management: Sustainability and Supply Chain Management (10th Edition)
The flowchart for the process at the local car wash. Introduction: Flowchart: A flowchart is a visualrepresenta...
Principles Of Operations Management
There is a huge demand in the United States and elsewhere for affordable women’s clothing. Low-cost clothing re...
Operations Management
There is a huge demand in the United States and elsewhere for affordable women’s clothing. Low-cost clothing re...
Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.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?arrow_forwardScenario 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?arrow_forwardAn end item’s demand forecasts for the next 6 weeks are 30 units, followed by forecasts of 25 units for weeks 7 through 10. The current on-hand inventory is 60 units. The order policy is to produce in lots of 100. The booked customer orders for the item, starting with week 1, are 22, 30, 15, 11, 0, 0, 9, 0, 0, and 0 units. The lead time is 2 weeks.a. Develop an MPS for this end item.b. The marketing department has received six orders for this item in the following sequence:Order 1 is for 40 units to be delivered in period 3Order 2 is for 60 units to be delivered in period 4Order 3 is for 70 units to be delivered in period 6Order 4 is for 40 units to be delivered in period 3Order 5 is for 20 units to be delivered in period 5Order 6 is for 115 units to be delivered in period 9Assuming that the prospective MPS you developed in part (a) does not change, which orders would you be able to accept based on the available to promise (ATP)?arrow_forward
- please answer within 30 minutes.arrow_forwardAn end item’s demand forecasts for the next 10 weeks are30, 30, 30, 30, 20, 20, 30, 30, 30, and 30 units. The current on-hand inventory is 100 units. The order policy is to produce inlots of 75. The booked customer orders for the item, startingwith week 1, are 15, 38, 7, 5, 0, 3, 10, 0, 0, and 0 units. The leadtime is 2 weeks.a. Develop an MPS for this end item.b. The marketing department has received five orders forthis item in the following sequence:Order 1 is for 20 units to be delivered in period 1Order 2 is for 75 units to be delivered in period 4Order 3 is for 90 units to be delivered in period 6 Order 4 is for 75 units to be delivered in period 7Order 5 is for 90 units to be delivered in period 10 Assuming that the prospective MPS you developed in part (a)does not change, which orders would you be able to acceptbased on the available to promise (ATP)?arrow_forwardDon't mind the number i already wrotearrow_forward
- How does the Wilson approach handle demand forecasting and inventory planning for new product launches?arrow_forwardPrepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 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 1 2 3 Customer Orders 54 38 25 20 Use a production lot size of 73 units and no beginning inventory. (In the ATP row, enter a value of 0 (zero) In any perlods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required.) June July MPS ATP Forecast Customer Orders Projected On-Hand Inventory 60 54 2 60 38 3 60 25 4 60 20 5 60 0 6 60 0 7 60 0 8 60 0arrow_forward1. Develop an aggregate plan for the following forecast Period 3 4 5 6 7 Total 1 2 8 Forecast 190 230 260 280 210 170 160 260 180 1,940 There are 20 workers who can produce 10 units per period at a cost of P6.00 per unit. There is no beginning invetory and the cost of carrying inventory is P5.00 per unit per period. Backlog cost is P10.00 per unit per period. Will the present workforce able to produce the forecast? b. What is the total cost of the plan? a.arrow_forward
- Crystal Clear Health Drinks: A health drink production company, Crystal Clear Health Drinks, decides to introduce a new line of health drink that will include several flavours. The marketing team forecasts an increase in demand for the new line of product; this is due to the growing popularity of the idea of living healthier lifestyles. They prepare the following aggregate forecasts (tank loads of several flavours) for the next six-month planning horizon: May: 50 June: 60 July: 70 August: 90 September: 80 October: 70 The operations team prepared the following information: 1. The production line has the capacity to produce 60 tank loads per month in regular time at the cost of R10,000 per tank load. 2. Overtime production and subcontracting to the available suppliers cost R16,000 and R18,000 per tank load, respectively. 3. The cost to hold one tank load for one month is R2,000. 4. Demand can also be back-ordered at the cost of R5,000 per month. 5. The company has no starting inventory…arrow_forwardAn end item’s demand forecasts for the next 10 weeks are 30,20, 35, 50, 25, 25, 0, 40, 0, and 50 units. The current on-handinventory is 80 units. The order policy is to produce in lots of100. The booked customer orders for the item, starting withweek 1, are 22, 30, 15, 9, 0, 0, 5, 3, 7, and 0 units. At present,no MPS quantities are on-hand for this item. The lead time is2 weeks. Develop an MPS for this end item.arrow_forwardAggregate Planning and Master Scheduling Planners of the company are about to prepare the aggregate plan that will cover 6 months. Assuming that the company identified the following forecast for the next 6 months: Period Jan Feb March April May June Forecast 270000 275000 245000 255000 335000 270000 They now want to evaluate a plan that calls for a steady rate of regular output (250000 boxes/month). Mainly using inventory, regular time and overtime, and backorders. They intend to start with zero inventory on hand in the first period. The maximum amount of overtime output per period is 30,000 box per month. The regular production cost per box is 30 LE while the overtime cost per box is 35 LE. The holding cost is 5 LE per box per month and the backorder cost is 10 LE per box per month. Then, prepare a master schedule to identify the available to promise amounts, knowing that the policy calls for a fixed order quantity of 350000 units, and currently there are 276000 units in inventory. 5…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY