MyLab Operations Management with Pearson eText -- Access Card -- for Operations Management: Processes and Supply Chains
12th Edition
ISBN: 9780134742366
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
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.
Eight Glasses A Day:
The EGAD Bottling Company has decided to introduce a new line of premium bottled water that will include several designer flavors. Marketing manager Georgianna is predicting an upturn in demand based on the new offerings and the increased public awareness of the health benefits of drinking more water. She has prepared aggregate forecasts for the next six months, as shown,
Month May June July Aug Sep Oct Total
Forecast 50 60 70 90 80 70 420
Production manager Mark Mercer, has developed the following information. (Note: Costs are in thousands of dollars).
Regular production cost: $1 per tankload
Regular production capacity: 60 tankloads
Overtime production cost: $1.6 per tankload
Subcontracting cost: $1.8 per tankload
Holding cost: $2 per tankload per month
Back ordering cost: $5 per month per tankload
Beginning inventory: 0 units
Among the strategies being considered are:
1. Level production supplemented by up to 10 tank loads a month from overtime
2. A…
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
MyLab Operations Management with Pearson eText -- Access Card -- for Operations Management: Processes and Supply Chains
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_forwardThe Silver Star Bicycle Company will be manufacturing both men's and women's models of its Easy-Pedal 10-speed 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: Production Labor Requirements (hours) Current Model Costs Manufacturing Assembly Inventory Men's $120 2.0 1.5 20 Women's $90 1.6 1.0 30 Last month the company used a total of 1000 hours of labor. The company's labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of…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_forward
- Don't mind the number i already wrotearrow_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_forwardOn Week a) Item: P24 hand 1 2 3 4 5 6 7 8 Forecast 30 30 30 40 40 40 45 45 Customer Orders 13 8 4 PAB 20 Available to Promise MPS b) Determine if each customer order will be accepted. Order Amount Week Accept (Y/N) 1 40 2 30 3 4 30 25 462M 3 Update the MPS time-phased record for accepted orders. Item: P24 Forecast Customer Orders Problem 3: The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item production. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. a) Complete the MPS time-phased record for product P24. Use the table on the left. b) Determine if Murphy Motors can accept each of the following customer orders. Update the MPS time- phased record for accepted orders. Order 1234 Amount 40 Desired Week 4 30 30 25 623 8 4 On Week hand 1 2 3 4 5 6 30 30 30 40 40 40 74 45 45 PAB 20 Available to Promise MPS On hand = 20arrow_forwardDeforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…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