Concept explainers
a
Interpretation:Economic Order quantity is to be calculated.
Concept Introduction:
Economic Order Quantity (EOQ) model aims at minimizing the cost of a production unit of a business facility. It aims to define the optimal quantity so that there is a balance between order and carrying cost. This model gives an approximate result rather than guaranteeing it. Carrying cost is determined by management of business unit.
a
Answer to Problem 10PA
Economic Order quantity is 114 units.
Explanation of Solution
Given information:
Average demand,
Lead Time,
Order cost, O
Unit
Carrying charge rate = 0.25
Number of weeks,
Standard deviation of weekly demand,
SKU service level,
Current on hand inventory,
Schedule receipts,
Back orders,
Following is the formula to calculate economic order quantity.
D = Annual demand
S = cost per order
H = Holding cost
Annual demand is calculated as follows:
Where,
d= Average demand per week
n= number of weeks
Holding cost is calculated as follows:
Where,
I = Unit cost
C = carrying cost
Substituting values in formula:
b
Interpretation:Total annual order and inventory holding cost needs to be calculated.
Concept Introduction:
Economic Order Quantity (EOQ) model aims at minimizing the cost of a production unit of a business facility. It aims to define the optimal quantity so that there is a balance between order and carrying cost. This model gives an approximate result rather than guaranteeing it. Carrying cost is determined by management of business unit.
b
Answer to Problem 10PA
Annual order cost is 114.03 and inventory holding cost is $114
Explanation of Solution
Given information:
Average demand,
Lead Time,
Order cost, O
Unit
Carrying charge rate = 0.25
Number of weeks,
Standard deviation of weekly demand,
SKU service level,
Current on hand inventory,
Schedule receipts,
Back orders,
Following is the formula for calculating total cost.
Total cost = Annual ordering cost + Annual holding cost
D = Annual demand
Q= Order Size
S= Cost per order
H = Holding cost
Annual order cost is 114.03 and inventory holding cost is $114
c
Interpretation:Reorder point without safety stock needs to be determined.
Concept Introduction:
Reorder point is point at which level of inventory has fallen upto that level. It measures the level of inventory which is kept as stock. As the firm reaches the reorder point, firm repurchase its inventory.
c
Answer to Problem 10PA
Reorder point without safety stock is 38 units
Explanation of Solution
Given information:
Average demand,
Lead Time,
Order cost, O
Unit
Carrying charge rate = 0.25
Number of weeks,
Standard deviation of weekly demand,
SKU service level,
Current on hand inventory,
Schedule receipts,
Back orders,
Following is the formula to calculate reorder point.
Where d= Average demand
LT = Lead Time
Reorder point without safety stock is 38 units
d
Interpretation:Reorder point with safety stock needs to be calculated.
Concept Introduction:
Reorder point is point at which level of inventory has fallen upto that level. It measures the level of inventory which is kept as stock. As the firm reaches the reorder point, firm repurchase its inventory.
d
Answer to Problem 10PA
Reorder point with safety is 48 units.
Explanation of Solution
Given information:
Average demand,
Lead Time,
Order cost, O
Unit
Carrying charge rate = 0.25
Number of weeks,
Standard deviation of weekly demand,
SKU service level,
Current on hand inventory,
Schedule receipts,
Back orders,
Following is the formula to calculate reorder point.
Where,
LT is lead time
d is average demand
z is 95% confidence interval value
Substituting values in the formula:
Reorder point with safety is 48 units.
e
Interpretation:Whether fixed quantity of calculators to be purchased is to be determined along with its quantity.
Concept Introduction:
Economic Order Quantity (EOQ) model aims at minimizing the cost of a production unit of a business facility. It aims to define the optimal quantity so that there is a balance between order and carrying cost. This model gives an approximate result rather than guaranteeing it. Carrying cost is determined by management of business unit.
e
Explanation of Solution
Fixed quantity of calculators can be purchased up to 38 units. This is the minimum quantity which can be held as stock. Reorder point without safety stock measures this stock as it can readily be sold. To be on safer side, 38 units can be considered as inventory.
Want to see more full solutions like this?
- The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.arrow_forwardA pharmacist is trying to determine the inventory order and stock levels for a particular drug. The following information is available about the drug. Demand (D) 85 tablets/week Working weeks per year 52 weeks Unit holding cost per year (H) $6 Order cost (S) $44/order Standard deviation of weekly demand (sd) 15 tablets Lead time (L) 2 weeks Desired cycle service level 95% If the pharmacist uses the continuous review (Q) system to control the inventory of the drug, what would be the order quantity and reorder point? If the pharmacist uses the periodic review (P) system to control the inventory of the drug, what would be the review interval and target inventory level? (Hint: Use the EOQ model to derive the review interval P)arrow_forwardABC Corporation is a large manufacturing company that has been using an outdated inventory management system for the past 10 years. The system has become slow and unreliable, causing delays in production and shipping. The IT department has recommended replacing the system with a modern cloud-based solution that can be accessed from anywhere and has the potential to integrate with other business systems.After a thorough evaluation of several vendors and their products, the IT team has recommended the purchase of a system called "InventoryPro". The system has a user-friendly interface, robust reporting capabilities, and is scalable to accommodate future growth.The CEO has approved the project, and the IT team has started working on the implementation plan. The project team includes a project manager, business analyst, database administrator, software developer, and testing specialist.As part of the project plan, the team will need to migrate the data from the old system to the new one,…arrow_forward
- 1(a). Weekly demand for EPSON printers at a WALMART store is normally distributed with a mean of 280 and a standard deviation of 180. The store manager continuously monitors inventory and currently orders 1,100 printers each time the inventory drops to 700 printers. EPSON currently takes two weeks to fill an order. How much safety inventory should WALMART carry? What is the Cycle Service Level (CSL)? What is the expected shortage per replenishment cycle (ESC)? What is the fill rate (fr)?arrow_forwardWhat would be the relationship (one-to-one, one-to-many, or many-to-many) relationship between: Sales and inventory Inventory and Order form Order and Vendorarrow_forwardWholemark is an Internet order business that sells one popular New Year's greeting card. The cost of the paper on which the card is printed is $0.10 per card, and the cost of printing is $0.42 per card. The company receives $2.40 per card sold. Since the cards have the current year printed on them, unsold cards have no salvage value. Based on past data, the number of customers from Los Angeles is normally distributed with a mean of 2,500 and a standard deviation of 600. What is the optimal production quantity for the card for Los Angeles, if Wholemark only makes a one-time production for this area? Round to the nearest integer.arrow_forward
- Alina Limited is a manufacturer of widgets orders components for use in manufacturing. The estimated demand for the components during the coming year is 15,000. Order costs are $100 per order; carrying costs are $12 per component. Using the economic order quantity model What is Alina Ltd’s optimum order quantity? If the supplier guarantees a three (3) day delivery on any order that is placed, What is the re-order point?arrow_forwardEarthbound Corporation is a manufacturer and distributor of air conditioning systems. You have been engaged to install an accounting system for Earthbound period among the inventory control features earthbound desires as part of the system are indicators of how much to order and when period. The following information is furnished for a product called “Hydronix” which is carried in inventory: Hydronix are sold by the gross (12 dozen) at a list price of P800 per gross FOB shipper. John receives a 40% trade discount off list price on purchases in gross lots. Freight cost is P20 gross from the shipping point to John's plant John uses about 5,000 Hydronix during 259-day production year and must purchase a total of 36 gross per year to allow for normal breakage. Minimum and maximum usages are 12 and 28, respectively. It takes 20 working days (normal delivery time) to receive an order from the date the purchase request is initiated. A rush order in full gross lots can be received by air…arrow_forward“The ABC Supply company is currently experiencing with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates.” Required: Explain the DMAIC methodology that can be used by the “ABC” company to implement Six Sigma Process for the above scenario. 800 wordsarrow_forward
- GameStop has maintained 75% service level for inventory of PlayStation 5. Mean demand during lead time is 166 PlayStations, and the standard deviation during lead time is 58 PlayStations. The annual cost of carrying one PlayStation in inventory is $12. The store’s operations analyst recently told GameStop's management that they could expect a $550 improvement in profit (based on current figures of cost per PlayStation) if the service level were increased to 97.5%. Is it worthwhile for GameStop to make this change?arrow_forward“The ABC Supply company is currently experiencing with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates.” Required: Explain the DMAIC methodology that can be used by the “ABC” company to implement Six Sigma Process for the above scenario.arrow_forwardA major automobile manufacturer located in Georgetown, Kentucky, has two certified vendors that produce brake pads with the information shown below. New Albany Manufacturing is located in Columbus, Ohio, and LaPlaya Manufacturing is located in Monterrey, Mexico. The automobile assembly factory is assumed to operate 250 days per year. CertifiedSupplier OrderSize (Q) Price per Unit (P) OversightCostper Unit (O) TransportCost perUnit (Ct) Order Cost(Co) Cost to StoreOne UnitOne Year (Ch) Order LeadTime inDays (L) New Albany Mfg. 59,000 $11.74 $0.00 $0.37 $255 $1.70 51 LaPlaya Mfg. 118,000 $11.08 $0.42 $0.87 $290 $1.35 99 Use the Total Supply Chain Cost Excel template to compute the supply chain costs associated with each supplier if the annual demand is 1,180,000 brake pads. Do not round intermediate calculations. Round your answer to the nearest dollar. Order quantity: 59,000 units 118,000 units Total procurement cost: $ $ Total management oversight…arrow_forward
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning