Principles of Operations Management: Sustainability and Supply Chain Management (10th Edition)
10th Edition
ISBN: 9780134181981
Author: Jay Heizer, Barry Render, Chuck Munson
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 14, Problem 24P
Develop a POQ solution and calculate total relevant costs for the data in the preceding table.
Data Table for Problems 14.22 through 14.25*
* Holding cost = $2.50 Unit/week setup cost = $150; lead time = 1 week; beginning inventory = 40; stockout cost = $10.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Scatter Diagrams and High-Low Cost Estimation
Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs.
Month Sales Orders Order-Processing Costs
3,000
$ 165,400
1,500
100,750
4,400
241,400
2,800
163,800
2,300
139,550
1,200
86,200
2,000
125,000
1
2
3
4
5
6
7
Required
(a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs.
$ 28,000
+ $48.5
X
(b.) Plot the data on a scatter diagram. Using the information from representative high-and low-volume months, develop a cost estimating equation for monthly order-processing costs. If needed, an Excel
worksheet is provided in the following link in order to create the scatter diagram: Scatter_Diagram
$ 15,000 X+ $53.14 X X
identified order processing time risk and purpose solution using Plan-Do-Check-Act cycle.
Shown below is a partially completed MPS record for ball bearings.
Part 2
a. Develop the MPS for ball bearings. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.)
Item: Ball bearings
Order Policy: 500 units
Lead Time: 1 week
Quantity
on Hand: 400
Week
1
2
3
4
5
6
7
8
9
10
Forecast
550
350
350
450
250
300
250
350
400
350
Customer orders (booked)
300
350
250
300
150
150
150
150
100
50
Projected on-hand inventory
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
MPS quantity
500
enter your response here
enter your response here
enter your response here
enter your…
Chapter 14 Solutions
Principles of Operations Management: Sustainability and Supply Chain Management (10th Edition)
Ch. 14 - Ethical Dilemma For many months your prospective...Ch. 14 - What is the difference between a gross...Ch. 14 - Prob. 2DQCh. 14 - What are the similarities between MRP and DRP?Ch. 14 - How does MRP II differ from MRP?Ch. 14 - Which is the best lot-sizing policy for...Ch. 14 - What impact does ignoring carrying cost in the...Ch. 14 - MRP is more than an inventory system; what...Ch. 14 - What are the options for the production planner...Ch. 14 - Master schedules are expressed in three different...
Ch. 14 - What functions of the firm affect an MRP system?...Ch. 14 - Prob. 11DQCh. 14 - Prob. 12DQCh. 14 - Prob. 13DQCh. 14 - Prob. 14DQCh. 14 - As an approach to inventory management, how does...Ch. 14 - Prob. 16DQCh. 14 - Use the Web or other sources to: a) Find stories...Ch. 14 - Prob. 18DQCh. 14 - Prob. 19DQCh. 14 - You have developed the following simple product...Ch. 14 - You are expected to have the gift bags in Problem...Ch. 14 - Prob. 3PCh. 14 - Your boss at Xiangling Hu Products, Inc., has just...Ch. 14 - The demand for subassembly S is 100 units in week...Ch. 14 - Prob. 6PCh. 14 - Prob. 7PCh. 14 - Prob. 8PCh. 14 - Prob. 9PCh. 14 - Prob. 10PCh. 14 - Prob. 11PCh. 14 - Prob. 12PCh. 14 - Prob. 13PCh. 14 - Prob. 14PCh. 14 - You are product planner for product A (in Problem...Ch. 14 - Prob. 16PCh. 14 - Heather Adams, production manager for a Colorado...Ch. 14 - Prob. 22PCh. 14 - Data Table for Problems 14.22 through 14.25 ...Ch. 14 - Develop a POQ solution and calculate total...Ch. 14 - Using your answers for the lot sizes computed in...Ch. 14 - M. de Koster, of Rene Enterprises, has the master...Ch. 14 - Grace Greenberg, production planner for Science...Ch. 14 - Prob. 29PCh. 14 - Prob. 30PCh. 14 - Courtney Kamauf schedules production of a popular...Ch. 14 - Using the data for the coffee table in Problem...Ch. 14 - Prob. 1.1VCCh. 14 - Prob. 1.2VCCh. 14 - Prob. 1.3VCCh. 14 - MRP at Wheeled Coach Wheeled Coach, the worlds...Ch. 14 - MRP at Wheeled Coach Wheeled Coach, the worlds...Ch. 14 - Prob. 2.3VC
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
- Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven assembly with a minimum cost possible. Following table show gross requirements of their product for twelve weeks. Develop a Part Period Balancing (PPB) solution and calculate the total relevant costs for the plan. Week Gross requirements 1 30 Week Gross requirements On-hand at beginning of week 40 On-hand at end of week Order receipt Order release Total relevant cost for this plan is = $ 2 3 30 1 30 4 2 5 40 70 20 Also, for this plan the Holding cost = $2.50/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 40 units. Use the table below to develop a PPB solution for MRP (enter your responses as whole numbers). 3 30 6 7 8 4 5 40 (enter your response as a whole number). 6 ॥ 70 9 10 70 7 20 10 11 8 D 12 50 9 10 11 12 10 70 50arrow_forwardComplete the MPS record below for an end item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Order Policy: 100 units Lead Time: 2 weeks Quantity on Hand: 80 Week 1 2 3 4 5 6 7 8 9 10 Forecast 25 25 35 45 25 20 45 55 Customer orders 25 30 7 11 (booked) Projected on-hand inventory MPS quantityarrow_forwardElectro Fans has just received an order for one thousand 20˝ fans due in week 7. Each fan consists of a housing assembly, two grills and a fan assembly. The housing assembly consists of a frame, two supports and a handle. The following table gives lead times, on-hand inventory, and scheduled receipts. Table 1.1: Lead time and quantity on hand Item Lead Time Qty on hand Lot size# Scheduled receipt 20˝ Fan Housing Frame Supports (2) Handle Grills (2) Fan Assembly 1 1 2 1 1 2 3 80 90 - 50 400 200* 150 - - - 100 400 450 - 50 fan assembly in week 2 * In week 3 it was found that 50% of the on hand inventory of the grills was damaged. # Items without any lot size given should be considered as lot-for-lot. (i) Construct a product structure. (ii) Construct a time-phased product structure. (iii) Prepare a net requirement plan.arrow_forward
- As a logistics specialist, you are responsible for meeting customer demand. One of your customers places orders for you to supply four products by the end of October. You have limited capacity for raw material and other facilities. You are required to satisfy customer demand by manufacturing the products and/or buying from a supplier. After consulting with the production department, you obtained the following information. Product A Product B Product C Product D Order quantity 2000 3500 1500 2500 Hours required on machine X per unit 2 4 5 3 Hours required on machine Y per unit 4 3 6 2 Raw material in kilos 5 1 4 6 Time needed for Packaging per unit 36 minutes 30 minutes 45 minutes 24 minutes Available monthly hours per month: 8,000 on machine X, 6000 on machine Y, and 3,000 hours for packaging. Purchased items from your supplier are already packaged. Available raw material per month: 5,000 kilos…arrow_forwardDemand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January February 4,100 4,200 March 3,900 April 4,300 May 4,900 June 4,600 July 5,200 August 4,800 September 5,300 October 5,600 November 6,200 December 5,900arrow_forwardAssume you are the manager of a shop that assembles power tools. You have just received an order for 55 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6arrow_forward
- E-Book break-even analysis. Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web site construction is estimated to be $160,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for $46. a. Build a spreadsheet model to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,500 copies? b. Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to assess the sensitivity of profit to demand. c. Use Goal Seek to determine the access price per copy that the publisher must charge to break even with a demand of 3,500 copies. d. Consider the following scenarios: Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Variable Cost/Book $6 $8 $12 $10 $11 Access Price $46 $50 $40 $50 $60…arrow_forward2) Life Cycle Assessment of Glass. Inventory Analysis Determine, as an example, the second phase (Inventory Analysis) of the Life Cycle Assessment of the glass used for the manufacture of soda bottles.arrow_forwardSubject: Logistic management Q): What are the 2 approaches of BPR for implementation, give example? Q): What are the types & category of inventory management?arrow_forward
- 14.26. Calculate the available-to-promise row in the following matrix: Period On Hand = 100 1 2 3 4 5 6 Forecast 50 100 50 100 50 100 Customer Orders 50 125 75 175 45 15 Master Production 200 200 Schedule Available-to-Promisearrow_forwardThe Bawl Corporation supplies alloy ball bearings to automanufacturers in Detroit. Because of its specialized manu-facturing process, considerable work-in-process and rawmaterials are needed. The current inventory levels are$2,470,000 and $1,566,000, respectively. In addition, fin-ished goods inventory is $1,200,000 and sales (at cost) forthe current year are expected to be about $48 million. Ex-press total inventory asa. Weeks of supplyb. Inventory turnsarrow_forwardProduct categories usually listed in the master production schedule contain all of the following except: Question 7 options: a. firm customer orders b. sales forecasts c. spare parts d. production ratesarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
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
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY