Concept explainers
(a)
Interpretation:
Economic order quantity (EOQ) and total cost
Concept Introduction:
Economic order quantity refers to the number of unit that an organization added to its inventory in order to minimize inventory cost such as order cost, shortage cost and the holding cost.
(a)
Explanation of Solution
Given data, Annual demand =1200
Order cost=$40
Unit cost= $5
Carrying charge rate = 18% = .18
The economic order quantity is calculated by the following formula.
The total order cost is calculated by the following formula.
Purchase cost
Thus, the total cost is
Thus, the total cost is 6294.95
(b)
Interpretation:
Economic order quantity (EOQ) when disposal cost is incorporated into the model.
Concept Introduction:
Economic order quantity refers to the number of the unit that an organization added to its inventory to minimize inventory costs such as order cost, shortage cost, and the holding cost.
(b)
Explanation of Solution
The economic order quantity is calculated by the following formula.
The total order cost is calculated by the following formula.
Purchase cost
Thus, the total cost is
Thus, the total cost is 6294.95
(c)
Interpretation:
The outcome of the above calculation on the sustainability practice.
Concept Introduction:
Economic order quantity refers to the number of the unit that an organization added to its inventory to minimize inventory costs such as order cost, shortage cost, and the holding cost.
(c)
Explanation of Solution
From the part (a) and (b) it can be concluded that the total cost is a little higher. Thus, by adjusting the economic order quantity, an organization can save the additional cost while protecting the environment.
Want to see more full solutions like this?
- The campus bookstore sells 4,000 sets of graduation regalia each year. Placing an order from their supplier costs $25 regardless of order quantity, so they usually place a large order (a half year's supply) at a time. It costs $5 per year to hold a cap and gown in inventory, primarily insurance costs for the highly flammable material. What is their optimal order quantity, total cost using the optimal order quantity, and What is the difference in the total cost if they order at their optimal order quantity compared to their current policy?arrow_forwardA warehouse checks inventory and places an order from a supplier for a particular product once a month. The monthly demand for the product is independent and normally distributed with a mean of 500 and a standard deviation of 100. If the warehouse targets a 90% service level for this product, and the supplier’s lead time is one month, how much safety stock should be held? PLEASE SHOW CALCULATIONS/EXCEL WITH FORMULASarrow_forwardYou are a newsvendor selling the San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.25 a copy. You sell a copy of the San Pedro Times for $1.30. Daily demand is distributed normally with mean = 260 and standard deviation = 46. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of the San Pedro Times should you buy each morning? Note: Use Excel's NORM.S.INV() function to find the z value. Round your z value and service level to 2 decimal places and final answer to the nearest whole number. Optimal order quantity b. Based on a, what is the probability that you will run out of stock? Note: Round your answer to the nearest whole percent. Probability %arrow_forward
- Electronic village stocks and sells a particular brand of personal computer. It costs the store 60 OMR each time it places an order with the manufacturer for the personal computers. The annual cost of carrying the PCs in inventory is 22 OMR per PC. The store manager estimates that annual demand for the PCs will be 150 units. (i) Determine the optimum order quantity and the total inventory cost. (ii) If the store manager places an order for 30 PCs every time, how much total inventory cost?arrow_forwardAnnual demand for a product is 13,000 units; weekly demand is 250 units with a standard deviation of 40 units. The cost of placing an order is $100, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.65 per unit. To provide a 98 percent service probability, what must the reorder point be? Suppose the production manager is told to reduce the safety stock of this item by 100 units. If this is done, what will the new service probability be?arrow_forwardou are a newsvendor selling the San Pedro Times every morning. Before you get to work, you go to the printer and buy the day’s paper for $0.50 a copy. You sell a copy of the San Pedro Times for $1.25. Daily demand is distributed normally with mean = 335 and standard deviation = 67. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. How many copies of the San Pedro Times should you buy each morning and what is the probability that you will run out of stock? Use Excel's NORM.S.INV() function to find the z value.arrow_forward
- Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. Item cost $ 8.00 Standard deviation of weekly demand 25 per week Order cost $ 298.00 Lead time 4 weeks Annual holding cost (%) 29 % of item cost Service probability 98 % Annual demand 28,100 Average demand 562 per week a. Determine the order quantity and reorder point. (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Optimal order quantity units Reorder point units b. Determine the annual holding and order costs. (Round your answers to 2 decimal places.) Holding cost $ Ordering cost $ c. Assume a price break of $50 per order was offered for purchase quantities of 2,100 or more units per order. If…arrow_forwardDetermine the order quantity, reorder point, annual holding cost, and order cost, then assume a price break of $50 per order was offered for purchase quantities of 2,000 or more units per order. If you took advantage of this price break, how much would you save annually? When calculating the z-score, use the NORM.S.INV() function from excel.arrow_forwardA company targets a 97% service level for a product with independent weekly demand that is normally distributed with a mean of 50 and a standard deviation of 10. They use a continuous review policy and order from a supplier with a lead time of 3 weeks. What should their reorder point be? PLEASE SHOW CALCULATIONS/EXCEL WITH FORMULASarrow_forward
- A daily newspaper is stocked by a coffee shop so its patrons can purchase and read it while they drink coffee. The newspaper costs $1.14 per unit and sells for $1.55 per unit. If units are unsold at the end of the day, the supplier takes them back at a rebate of $1 per unit. Assume that daily demand is approximately normally distributed with µ = 150 and σ = 30. (a) What is your recommended daily order quantity for the coffee shop? (Round your answer to the nearest integer.) (b) What is the probability that the coffee shop will sell all the units it orders? (Round your answer to four decimal places.) (c) In problems such as these, why would the supplier offer a rebate as high as $1? For example, why not offer a nominal rebate? Find the recommended order quantity at 25¢ per unit. (Round your answer to the nearest integer.) What happens to the coffee shop's order quantity as the rebate is reduced? The higher rebate ---Select--- ▾ the quantity that the coffee shop should order.arrow_forwardA daily newspaper is stocked by a coffee shop so its patrons can purchase and read it while they drink coffee. The newspaper costs $1.16 per unit and sells for $1.75 per unit. If units are unsold at the end of the day, the supplier takes them back at a rebate of $1 per unit. Assume that daily demand is approximately normally distributed with ? = 150 and ? = 30. (a) What is your recommended daily order quantity for the coffee shop? (Round your answer to the nearest integer.) (b) What is the probability that the coffee shop will sell all the units it orders? (Round your answer to four decimal places.) (c) In problems such as these, why would the supplier offer a rebate as high as $1? For example, why not offer a nominal rebate? Find the recommended order quantity at 25¢ per unit. (Round your answer to the nearest integer.)arrow_forwardThe owner and manager of a hardware store reevaluates his inventory policy for hammers. sells an average of 50 hammers a month, so you have placed purchase orders for 50 hammers with a distributor at a cost of $20 each at the end of each month. But the owner does not place all the store orders and find that this takes much of your time. He estimates that the value of his time spent ordering hammers is $75. a) What must be the unit cost of maintaining hammers for the current policy of the hardware store to be Optimal according to the EOQ model? b) If the distributor delivers an order for hammers in 5 business days (out of an average of 25 per month), what should be the reorder point, according to the EOQ model?arrow_forward
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning