EBK PRACTICAL MANAGEMENT SCIENCE
5th Edition
ISBN: 9780100655065
Author: ALBRIGHT
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 12.4, Problem 8P
Summary Introduction
To use: The solver table to find the impact of change in the annual fixed order cost and annual holding cost on the optimal order quantity.
Inventory and supply chain models:
The functions of inventory and supply chain are one of the most important business decision areas for an organization. The first important aspect of these concepts is to have adequate inventory on hand. The second important aspect is to carry a little amount of inventory as possible.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Vallie Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units. The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs the business $30 to place a single order.
The maximum number of units sold for any one week is 150 and minimum sales 80 units. The vendor takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. The EOQ model is appropriate.
i) What is the cost minimizing solution for this product each year?
ii) Determine the re-order level, minimum inventory level and maximum inventory level for the
product.
If annual sales for your product are 715, and the holding cost per unit is $5, and the cost to place an order is $350, then:
1. Calculate the EOQ, and round it to 2 decimal places.
2. Calculate the ordering and holding costs, per year, if you use the EOQ.
What is the Sum of Ordering and Holding costs (rounded to nearest dollar)?
Please solve using excel. Thank you.
Chapter 12 Solutions
EBK PRACTICAL MANAGEMENT SCIENCE
Ch. 12.4 - Prob. 1PCh. 12.4 - Prob. 2PCh. 12.4 - Prob. 3PCh. 12.4 - Prob. 4PCh. 12.4 - Prob. 5PCh. 12.4 - Prob. 6PCh. 12.4 - Prob. 7PCh. 12.4 - Prob. 8PCh. 12.4 - Prob. 9PCh. 12.4 - Prob. 10P
Ch. 12.4 - Prob. 11PCh. 12.5 - Prob. 12PCh. 12.5 - Prob. 13PCh. 12.5 - Prob. 14PCh. 12.5 - Prob. 15PCh. 12.5 - Prob. 16PCh. 12.5 - Prob. 17PCh. 12.5 - Prob. 18PCh. 12.5 - Prob. 19PCh. 12.5 - Prob. 20PCh. 12.5 - Prob. 21PCh. 12 - Prob. 27PCh. 12 - Prob. 28PCh. 12 - Prob. 29PCh. 12 - Prob. 30PCh. 12 - Prob. 31PCh. 12 - Prob. 32PCh. 12 - Prob. 33PCh. 12 - Prob. 34PCh. 12 - Prob. 35PCh. 12 - Prob. 36PCh. 12 - Prob. 38PCh. 12 - Prob. 39PCh. 12 - Prob. 40PCh. 12 - Prob. 42PCh. 12 - Prob. 43PCh. 12 - Prob. 44PCh. 12 - Prob. 45PCh. 12 - Prob. 46PCh. 12 - Prob. 47PCh. 12 - Prob. 48PCh. 12 - Prob. 49PCh. 12 - Prob. 53PCh. 12 - Prob. 54PCh. 12 - In terms of K, D, and h, what is the average...Ch. 12 - Prob. 56PCh. 12 - Prob. 57PCh. 12 - Prob. 58PCh. 12 - Prob. 59PCh. 12 - Prob. 60PCh. 12 - Prob. 61PCh. 12 - Prob. 62PCh. 12 - Prob. 63PCh. 12 - Prob. 64PCh. 12 - Prob. 65PCh. 12 - Prob. 66PCh. 12 - Prob. 67PCh. 12 - Prob. 68PCh. 12 - Prob. 69PCh. 12 - Prob. 70PCh. 12 - Prob. 71PCh. 12 - Prob. 1.1CCh. 12 - Prob. 1.2CCh. 12 - Prob. 1.3C
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
- Economic Order Quantity (EOQ) is a method used to calculate the ideal quantity to order. The underlying concepts of EOQ is the balance between ordering cost and holding cost. Q1. Using the data points given below, perform two calculations: Q2. Use an excel file to calculate the EOQ order. Make sure to use the formula bar to create the EQO formula. Make an excel file similar to the image attached. A = annual demand = 20,000 Cp = Cost of an order which includes preparing and following up the order = $100.00 Ch = Unit inventory cost per year or item cost (P) $100 times annual carrying cost rate (r) (25%)arrow_forwardPlease help me answer thisarrow_forwardA company has an annual demand of 16,000 products. The products cost $2 each. Ordering and transport costs amount to $200 per order. The annual cost of holding one product in stock is estimated to be $1.20 . Assume that the company adopts the EOQ as its order quantity and it has to have half of the EOQ as inventory on hand when an order is placed. How many weeks does it take for an order to be delivered to the company? (1 year = 52 weeks) A) PPE may be credited by 2 million dollarsB) Revaluation OCI may be credited by 3,3 million dollarsC) Accumulated depreciation may be debited by 4 million dollarsD) Accumulated depreciation may be credited by 1,3 million dollarsE) Other (Please Specify)arrow_forward
- Consider the basic EOQ model (no uncertainty). Annual holding cost (???AHC) is $2,400. Find annual ordering cost (???AOC). Group of answer choices Cannot be answered because there is missing information AOC=$2,400, since AHC=AOC at the economic order quantity AOC=$0, since there is no uncertainty $1,200, since AOC=AHC/2 at economic order quantity. $4,800, since AOC=2 x AHC at economic order quantityarrow_forwardSuppose in an EOQ model backorders are used, and the backorder cost has increased whereas all other costs/variables besides (Total costs) remained the same. Which of the following is true due to the increase in the backorder cost? O a) The Maximum Inventory Level will increase O b) The re-order point will increase O c) The Total Cost will decrease d) The intersection between the holding cost and setup cost is equal to the new backorder cost e) The optimal order quantity will increasearrow_forwardA health and nutrition store stocks a multivitamin with an annual demand of 1,000 bottles has Co = $24.50 and Ch = $7.The demand exhibits some variability such that the lead-time demand follows a normal probability distribution with ? = 25 and ? = 5. (a)What is the recommended order quantity? (Round your answer to the nearest integer.) (b)What are the reorder point and safety stock if the store desires at most a 4% probability of stock-out on any given order cycle? (Round your answers to the nearest integer.) reorder pointsafety stock (c)If a manager sets the reorder point at 30, what is the probability of a stock-out on any given order cycle? (Round your answer to four decimal places.) How many times would you expect a stock-out during the year if this reorder point were used? (Round your answer to the nearest integer.)arrow_forward
- A company would like to classify its inventory systems using ABC Inventory classification system. The rules for ABC dassification are STRICTLY applied such that 80% cumulative budget is assigned to A class inventory items. The next 15% cumulative budget is assigned to B class inventory items, and Only 5% of the cumulative budget is assigned to class inventory itemsThe inventory items are XYZ1, XYZ2, XYZ3and respectively. The Annual demands (units per year) for these items are 290,457159, and 577 respectively. Also, the corresponding per unit prices are 19 33, 126and respectively measured in OMR. Which items (among XYZ1, XYZ2, XYZ3, and XYZ4) are classified as Adass inventoryarrow_forwardIn the calculation of an optimal policy for an all-units discount schedule, you firstcompute the EOQ values for each of the three order costs, and you obtain: Q(0) =800, Q(1) =875, and Q(2) =925. The all-units discount schedule has breakpointsat 750 and 900. Based on this information only, can you determine what the optimal order quantity is? Explain your answer.arrow_forwardSuppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3,700 cases. A case of the soft drink costs R&B $4. Ordering costs are $20 per order and holding costs are 23% of the value of the inventory. R&B has 250 working days per year, and the lead time is 5 days. Identify the following aspects of the inventory policyarrow_forward
- Red Corporation uses the reorder point modelto plan its purchases. It sellsitssole productat the following daily amounts:Minimum=30,000; Average=40,000;Maximum=60,000. Its supplier takes 3 dayson average and 4 days maximum to deliverthe order. The-reorder point would be A. 240,000B. 160,000C. 120,000D. 90,000arrow_forwardUsing excel. Apply the EOQ model to the following quantity discountsituation for which D5 500 units per year, Co5 $40, and theannual holding cost rate is 20%. What order quantity do yourecommend?DiscountDiscountCategoryOrder Size(%)unit Cost10 to990$10.002100 or more3$9.70arrow_forwardA department store sells 10 000 cameras per year. The store orders cameras from a regional warehouse. Each time, an order is placed, an ordering cost of $ 5 is incurred. The store pays $ 100 for each camera, and the holding cost of $ 1 worth of inventory for a year is estimated to be the annual capital opportunity cost of 0.20 $. Determine EOQ (Economic Order Quantity)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