You work as a planner in the supply chain department for AFIA co. Given the monthly gross requirements for one of the items (Carton). Your job is to develop an ordering plan and costs for: a) Lot-for-lot. b) ЕOQ. c) Which plan should we select ? Calculate the total cost of each plan. Please use the following information : Holding Cost per month = $ 0.75 Set Up Cost = $ 150 Lead time = 0 Master Production Schedule : Month 1 3 4 7 Gross requireme 100 150 200 150 100 150 250 nts Attach your solutions (Answer the total cost of EOQ plan in field)

You work as a planner in the supply chain department for AFIA co. Given the monthly gross requirements for one of the items (Carton). Your job is to develop an ordering plan and costs for: a) Lot-for-lot. b) ЕOQ. c) Which plan should we select ? Calculate the total cost of each plan. Please use the following information : Holding Cost per month = $ 0.75 Set Up Cost = $ 150 Lead time = 0 Master Production Schedule : Month 1 3 4 7 Gross requireme 100 150 200 150 100 150 250 nts Attach your solutions (Answer the total cost of EOQ plan in field)

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

Question 1 For supply item ABC, Andrews Company has been ordering 400 units per week. A new purchasing agent has been hired by the company who wants to start using the economic-order- quantity method and its supporting decision elements. She has gathered the following information: Annual demand in units Lead time, in days Ordering costs Insurance and handling costs Purchase price per unit Return on cash investment 20,800 5 $22 $7 $15 15% Required
Please do not give solution in image format thanku Carousel Restaurant in Coquitlam is using perpetual inventory control method. Determine the reorder quantity of chickpeas cans if the par stock is 25 cans, delivery takes 5 days, the daily usage is 2 cans and the desired safety factor is 1.5 a. 10 b. 20 c. 25 d. 15
Huki is a distributor of 'Cotton Shirt,' with a weekly demand of 50 units. Each unit costs at $40 with reorder cost at $200 and holding cost at 25% of value a year.a. Determine the economic order quantity (EOQ), holding cost, ordering cost and total costs.a. If the provider could only deliver 50 units at a time, is there any additional expenses?
example 15.1 Economic Order Quantity and Reorder Point Find the eco- nomic order quantity and the reorder point, given Annual demand (D) = 1,000 units Average daily demand (d) = 1,000/365 Ordering cost (S)= $5 per order Holding cost (H) = $1.25 per unit per year Lead time (L) = 5 days Cost per unit (C) = $12.50 %3D %3D %3D What quantity should be ordered?
Thomas Kratzer is tbe purchasing manager for theheadquarters of a la rge insurance company chain with a centralinventory operation. Thomas's fas test-moving inventory itemhas a demand of 6,000 units per year. The cost of each unit is$ 100, and the inventory carrying cost is $10 per unit per year. The average ordering cost is $30 per order. It takes about 5 days for anorder to arrive, and the demand for I week is 120 units. (This is acorporate operation, and there are 250 working days per year.)a) What is the EOQ?b) What is the average inventory if the EOQ is used?c) What is the optimal number of orders per yea r?d) What is the optimal number of days in between any two orders?e) What is the annual cost of ordering and holding inventory?f) What is the total annual inventory cost, including the cost ofthe 6,000 units?
Economic Order Quantity and Reorder PointFind the economic order quantity and the reorder point, givenAnnual demand ( D )= 1, 000 unitsAverage daily demand ( d¯ ) = 1, 000 ∕365ordering cost ( S ) = $5 per orde rHolding cost ( H ) = $1.25 per unit per yearLead time ( L ) = 5 daysCost per unit ( C ) =$12.50What quantity should be ordered?
Thomas Kratzer is the purchasing manager for theheadquarters of a large insurance company chain with a centralinventory operation. Thomas’s fastest-moving inventory item hasa demand of 6,000 units per year. The cost of each unit is $100, and the inventory carrying cost is $10 per unit per year. The aver-age ordering cost is $30 per order. It takes about 5 days for an order to arrive, and the demand for 1 week is 120 units. (This is acorporate operation, and there are 250 working days per year.)a) What is the EOQ?b) What is the average inventory if the EOQ is used?c) What is the optimal number of orders per year?d) What is the optimal number of days in between any two orders?e) What is the annual cost of ordering and holding inventory?f ) What is the total annual inventory cost, including the cost ofthe 6,000 units?
Pls solve this question correctly in 5 min i will give u like for sure Question # 1 Teresa Cohan is attempting to perform an inventory analysis on one of her most popular products. Annual demand for this product is 5,000 units; unit cost $200; carrying cost is considered to be approximately 10% of the unit price. Order costs for her company typically run nearly $30 per order and lead time averages 10 days. Discounted unit cost of Rs. $150 (carrying cost remain the same) for more than 300 units is also being offered. (Assume a 50-week year. a)What is economic order quantity? b)What is the reorder point? c)What is the total carrying + ordering cost? d)What is optimal number of orders per year? e)Would you recommend availing the discount?
Use ABC analysis to determine the items deserving mostattention and tightest inventory control
10 Use the information presented in the graph to answer the following questions: Annual Cost C3 C2 Q1 You are also given the following information: Q1 =450 .Q2 = 700 C1 = 350 C2 = 750 1300 Q2 Order Quantity Which annual inventory cost component does the blue line represent? Total cost Which annual inventory cost component does the green line represent? Holding cost What is the Economic Order Quantity (EQ9) based on th Which annual inventory cost component does the red line represent? Ordering cost 220
Epworth Co. predicts that it will use 360,000 gallons of material during the year. It anticipates that it will cost $72 to place each order. The annual carrying cost is $4 per gallon. a. Determine the most economical order quantity by using the EOQ formula. b. Determine the annual order and carrying costs at the EOQ point.
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.)