OPERTATIONS MGMT:SUSTAINABILITY
2nd Edition
ISBN: 9781323751718
Author: HEIZER
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
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 solution
Students have asked these similar questions
. MBPF Inc. manufactures prefabricated garages. The manufacturing facility purchases sheet metal that is formed and assembled into finished products—garages. Each garage needs a roof and a base, and both components are punched out of separate metal sheets prior to assembly. Production and demand data for the past eight weeks are shown in Table below. Observe that both production and demand vary from week to week. Now, track the inventory at the end of each week, measured in number of finished garages. Also, construct the inventory build-up diagram. MBPF Inc. manufactures prefabricated garages. The manufacturing facility purchases sheet metal that is formed and assembled into finished products—garages. Each garage needs a roof and a base, and both components are punched out of separate metal sheets prior to assembly. Production and demand data for the past eight weeks are shown in Table
below. Observe that both production and demand vary from week to week. Now, track the inventory at…
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017.
(in millions)
2015
2016
2017
Beginning inventory
$ 2,100
$ 2,400
$ 2,300
Ending inventory
2,400
2,300
2,700
Cost of goods sold
18,227
20,071
20,478
Sales revenue
39,145
42,957
44,066
Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.)
2015
2016
2017
Days in inventory
days
i have found anther answer for this question on bartleby and it has a lot less working out and he didnt give answer to second question but the answer he gave for the first one is very different i am not sure which one to use below is his answer:
Step 1: Basic Information
The question is related to Economic order quantiy Economic Order Quantity is that level of inventory at which ordering cost and handling cost are minimum. It is calculated with the help of following formula
Economic Order Quantity = √2RO ÷ C
R = Annual Requirment
C = Carrying or Holding cost
O = Ordering Cost
Step 2: Solution
Economic Order Quantity = √2RO ÷ C
Economic Order Quantity = √2 × 3000 × 20 ÷ 4.25
Economic Order Quantity = √28,235.294117647
Economic Order Quantity = 168.0336100834 pounds
R = Annual Requirment i.e.250 × 12 = 3000 pounds per annum.
C = Carrying or Holding cost i.e. £4.25
O = Ordering Cost i.e. £20
Quantity to be ordered = 168.03 pounds.
Supplier = Vendor 1 should be used as the cost…
Chapter 14 Solutions
OPERTATIONS MGMT:SUSTAINABILITY
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
- Bob loves clothes. His favorite activity is to go shopping at the mall and try on new clothes. He looks forward to the day when he has a job so he can buy all the clothes he wants. Next week is Bob’s birthday and he will receive RM100.00 for his present. He saw a pair of jeans at the mall that was RM95.00; however, he also needs new shirts, new shorts, and some sports shorts. His RM100.00 could purchase all of these things or it could purchase one pair of designer jeans. All the students at the college wear these jeans. Bob states, “If only I had a pair of these jeans, I would be popular. How could Bob make a wise decision? Consider All Factors – List the different issues Bob should consider in making this difficult decision.arrow_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_forwardWith example (attached) explain how I can use RFID to manage inventory?arrow_forward
- The table below provides demand data for 6 weeks (weeks 31-36 for the current year) for one product. Inventory is managed with a periodic review system where T = 5 weeks and M = 280. The previous order was for 120 units at the end of week 28. The lead time is a constant 4 weeks. At the beginning of week 31 the inventory level is 130 units. Orders are made at the end of a week. 1. When is the next order? end of week __________ 2. How large is the next order? ___________ Week Demand Inventory 31 30 32 40 33 45 34 30 35 30 36 30arrow_forwardWhat is the underlying principle of the square-root rule? How do inventories change as the number of warehouses in a logistics network changes?arrow_forwardDOGGE Ltd has annual demand of 50,000 desks and the purchase price of each desk is K250. There are ordering costs of K200 for each order placed. Inventory holding costs amount to 10% per year of inventory value. Calculate the inventory costs p.a. for the following order quantities, and plot them on a graph: 500 units, 750 units, 1000 units, 1250 units b) Using the information in (a) above calculate i) Economic Order Quantity and the total inventory costs for this order quantity.arrow_forward
- A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based onc. Part period balancingarrow_forwardA single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based ond. Which lot-sizing method resulted in the lowest cost for the 12 periods?arrow_forwardA initially assume that Phi wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using a lot-for-lot (L4L). Gear box requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Input shaft requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order releasearrow_forward
- A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a servicelevel of .98. The order interval is 14 days, and lead time is 2 days. Average demand for one itemis 40 units per day, and the standard deviation of demand is 3 units per day. Given the on-handinventory at the reorder time for each order cycle shown in the following table, determine theorder quantities for cycles 1, 2, and 3.Cycle On Hand1 422 83 103arrow_forwardAverage Inventory Calculation—Fixed–Order Quantity ModelSuppose the following item is being managed using a fixed–order quantity model with safety stock.Annual demand (D) = 1,000 unitsOrder quantity (Q) = 300 unitsSafety stock (SS) = 40 unitsWhat are the average inventory level and inventory turn for the item?arrow_forwardThe base for inventory in a vertical analysis is:________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,
Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill Education
Operations 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 Learning
Production 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