The Demand for the 50 Kg Maize meal bag at Shoprite is 4000 units per month, Shoprite incurs a fixed order placement, transportation, and receiving cost of N$ 10 000 each time an order is placed. Each Bag of Maize meal cost Shoprite N$ 800 and the Shoprite has a holding cost of 20 percent as a fraction of unit cost. Calculate the following: (a)EOQ (b)Average Inventory

The Demand for the 50 Kg Maize meal bag at Shoprite is 4000 units per month, Shoprite incurs a fixed order placement, transportation, and receiving cost of N$ 10 000 each time an order is placed. Each Bag of Maize meal cost Shoprite N$ 800 and the Shoprite has a holding cost of 20 percent as a fraction of unit cost. Calculate the following: (a)EOQ (b)Average Inventory

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

EOQ, reorder point, and safety stock Alexis Company uses 916 units of a product per year on a continuous basis. The product has a fixed cost of $60 per order, and its carrying cost is $3 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days' usage in inventory as a safety stock. a. Calculate the EOQ. b. Determine the average level of inventory. (Note: Use a 365-day year to calculate daily usage.) c. Determine the reorder point. d. Indicate which of the following variables change if the firm does not hold the safety stock: (1) order cost, (2) carrying cost, (3) total inventory cost, (4) reorder point, (5) economic order quantity. a. Alexis' EOQ is units. (Round to the nearest whole number.)
Define each of the following in your own words and as a formula:a. Annual ordering cost.b. Annual carrying cost.c. Total annual cost.
Describe the difference between a fixed-quantity (Q) anda fixed-period (P) inventory system.
A company purchases special metal parts to make office furniture in lots of 100 units to satisfy an annual demand of 1600 parts. Holding cost for the parts is 0.3 dollars per unit per month and ordering cost is 40 dollars per order. Answer the following questions: Formulas: a) What is the EOQ? b) What are the costs previously (with 100 units per order) and now with EOQ. Hint: Calculate total holding cost and ordering cost for 100 units, and then same costs with EOQ. Which one (100 units or EOQ) is better in terms of costs? EOQ = SQRT(2Ds/h) THC=h*(Q/2) TOC=s*(D/Q) TC=THC+TOC please answer in excel
A videoke bar buys draft beer by the barrel from a local distributor. The bar has an annual demand of 9,000 barrels, which it purchases at a price of P205 per barrel. The annual carrying cost is 12% of the average inventory and the cost per order is P160. The distributor has offered the bar owner a reduced price to P190 per barrel if the owner will order a minimum of 300 barrels per order. What is the EOQ without a discount ? What is the EOQ with discount? Should the bar owner take the offer? What is the net benefit?
Coffee Company uses 800 units of a product per year on a continuous basis. The product has a Fixed Cost of $50 per order, and its carrying cost is $2 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days’ usage in inventory as a safety stock. Show Computations and Explanations. The EOQ = 200 Units The Average Level of Inventory = 92 Units The Reorder Point = 33 Units A. Indicate if the Variable Change if the firm does not hold the Safety Stock. Variable: Ordering Cost (Format: Change or Do not Change) B. Indicate if the Variable Change if the firm does not hold the Safety Stock. Variable: Carrying Cost (Format: Change or Do not Change) C. Indicate if the Variable Change if the firm does not hold the Safety Stock. Variable: Total Inventory Cost (Format: Change or Do not Change)
A local TV repairs shop uses 36,000 units of a part each year (A maximum consumption of 100 units per working day). It costs RM20 to place and receive an order. The shop orders in lots of 400 units. It cost RM4 to carry one unit per year of inventory. Calculate total annual ordering cost Calculate total annual carrying cost Calculate total annual inventory cost Calculate the Economic Order Quantity Calculate the total annual cost inventory cost using EOQ inventory Policy How much is the saving if using EOQ? Compute re-ordering point assuming the lead time is 3 days.
Peach Company uses 800 units of a product per year on a continuous basis. The product has a Fixed Cost of $50 per order, and its carrying cost is $2 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days’ usage in inventory as a safety stock. Show Computations and Explanations. The EOQ = 200 Units The Average Level of Inventory = 121.92 Units The Reorder Point = 33 Units A. Indicate if the Variable Change if the firm does not hold the Safety Stock. Variable: Reorder Point (Format: Change or Do not Change) B. Indicate if the Variable Change if the firm does not hold the Safety Stock. Variable: Economic Order Quantity (Format: Change or Do not Change)
b) The Elite Cafe serves purified bottles of "Wata" to its customers. The daily demand for Wata is normally distributed, with an average demand of 18 bottles and a standard deviation of 4 bottles. The lead time to receive an order of Wata from the local supplier is 3 days. Determine the safety stock and reorder point if the Cafe wants to maintain: i) 90% service level ii) 95% service level
A microbrewery purchases malt for production. The supplier charges $35 for delivery (no matter how much is delivered) and $1.20 per gallon. Annual holding cost is 35% of the price per gallon. Usage is 250 gallons/week. d) If order quantity is 2500 gallons, what is the sum of the ordering and holding costs PER GALLON? e) If orders are for EOQ amount, what is the annual cost of the inventory system as a percentage of the annual purchase cost?
Scotch Pub bar sells Speylachie high-end whiskey among other beverages. The demand for Speylachie is normally distributed. The inventory related information at Scotch Pub is as follows: Average Annual Demand = 2,500 liters Standard deviation of weekly demand = 22 liters One-liter bottle cost = bought at £112.50 per bottle from a brewery in Scotland Ordering cost = £144.00 per order Lead time = 3 weeks Annual inventory-holding cost estimate = 4% of the bottle cost Required service level = 95% Scotch Pub works 50 weeks a year. Note: The approximate z values are: for 0.9 ≈ 1.28, for 0.92 ≈ 1.405, for 0.95 ≈ 1.645, for 0.98 ≈ 2.05. Suppose the bar management practices the fixed-PERIOD ordering system with the review period equal to the “economic time interval”. Answer the following questions: (i) When do they place an order? (ii) If at the time of review there are 333 bottles are available in the stock, how many bottles of Speylachie they will order? (iii) What is the…
Maira Hijab Enterprise (MHE) is a supplier that sells Exclusive Embroidery Silk Hijabs to boutique and online resellers. The annual demand is approximately 360 hijabs. MHE pays RM50 for each hijab and estimates that the annual holding cost is 2 percent of the hijab's value. It costs approximately RM100 to place an order (managerial and clerical costs). Required: Determine the economic order quantity (EOQ) (Round up your answers to the nearest figure). а. b. Assuming a 300-day work year, how many orders should be processed per year and what is the expected time between orders? С. Calculate the total cost for the order. d. After several months of the introduction of the Exclusive Hijab, MHE decides to all costs related to their product due to the increment of hijab’s costs by the supplier. MHE currently orders 1000 hijabs per month. The new information as regards to the Exclusive Hijab is as follows: i. The ordering cost for these is RM100 per order and ii. The carrying cost is assumed…