Question

Alexis Company uses 800 units of a product per year on a continuous basis. The product...

Alexis 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 Calculate the EOQ Determine the average level of inventory. (Note: Use a 365 day year to calculate daily usage) Determine the reorder point Indicate which of the following variable 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. Explain.

Homework Answers

Answer #1

Solution:

a)Calculation of EOQ

EOQ=SQRT[2*annual demand*cost per order/carrying cost]

=SQRT[(2*800*$50)/$2]

=SQRT(40,000)

=200 units

b)Average inventory level

=(EOQ+2*safety stock)/2

Safety stock=(800 units/365)*10=22 units

Average inventory level=(200+2*22)/2

=122 units

c)Calculation of reorder point

=(Days of lead time*consumption in lead time)+safety stock

=11+22

=33 units

d)1.Order cost will not change as the firm will need to place same no. of order

2.carrying cost will decrease as the average level of inventory will decrease.

3.Total inventory cost will decrease due to decrease in carrying cost.

4.Reorder point will reduced as there is no safety stock.

5.Economic order quantity will decrease as the annual carrying cost per unit will decrease.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Brown Manufacturing uses 2,400 units of a product per year on a continuous basis. The product...
Brown Manufacturing uses 2,400 units of a product per year on a continuous basis. The product carrying costs are RM60 per year and ordering costs are RM250 per order. It takes 20 days to receive a shipment after an order is placed and the firm requires a safety stock of 8 days of usage in inventory. Required: Calculate the economic order quantity (round up to the nearest whole unit. Calculate the total cost per year to order and carry this...
Sharon Ltd has in the past ordered raw material T in quantities of 3,000 units which...
Sharon Ltd has in the past ordered raw material T in quantities of 3,000 units which is half a year’s supply. Management has instructed you, an inventory cost consultant, to advise them as to the most desired order quantities. The factory closes for 4 weeks annual leave per annum. You are given the following data: Inventory usage rate: 125 per week, Lead time: 3 weeks Unit price: $1.50, Annual requirement: 6,000 units Order cost: $9.00 per order, Carrying cost: $0.30...
COST ACCOUNTING - COST ESTIMATION AND MATERIALS CONTROL Pluto Company has developed the following data to...
COST ACCOUNTING - COST ESTIMATION AND MATERIALS CONTROL Pluto Company has developed the following data to assist in controlling one of its materials inventory items EOQ 1,000 liters Average daily use 100 liters Maximum daily use 120 liters Working days per year 250 days Safety stock 140 liters Cost of carrying inventory P1 per liter per year Lead time 7 days What is the reorder point? What is the average inventory? what is the maximum inventory assuming normal lead time...
Mama Leone's Frozen Pizzas uses 59,000 pounds of cheese per year. Each pound costs $5.50. The...
Mama Leone's Frozen Pizzas uses 59,000 pounds of cheese per year. Each pound costs $5.50. The ordering cost for the cheese is $657.90 per order, and its carrying cost is $1.29 per pound per year. Calculate the firm's economic order quantity (EOQ) for the cheese. Mama Leone's operates 260 days per year and maintains a minimum inventory level of 55 days' worth of cheese. Assuming that the lead time to receive orders of cheese is 33 days, calculate the reorder...
Mama​ Leone's Frozen Pizzas uses 41,000 pounds of cheese per year. Each pound costs​ $5.50. The...
Mama​ Leone's Frozen Pizzas uses 41,000 pounds of cheese per year. Each pound costs​ $5.50. The ordering cost for the cheese is ​$1357.30 per​ order, and its carrying cost is ​$2.77 per pound per year. Calculate the​ firm's economic order quantity​ (EOQ) for the cheese. Mama​ Leone's operates 220 days per year and maintains a minimum inventory level of 4 ​days' worth of cheese. Assuming that the lead time to receive orders of cheese is 3 ​days, calculate the reorder...
16) For supply item ABC, Andrews Company has been ordering 125 units based on the recommendation...
16) For supply item ABC, Andrews Company has been ordering 125 units based on the recommendation of the salesperson who calls on the company monthly. 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 250 Days used per year 250 Lead time, in days 10 Ordering costs $100 Annual unit carrying costs $20 Required: Determine the...
Hershey Company uses quantitative models for inventory control. For canned syrup, the annual demand is 8,000...
Hershey Company uses quantitative models for inventory control. For canned syrup, the annual demand is 8,000 cases. The supplier is 500 miles away, and it usually takes three days to get an order filled. The average order costs $16 to process and the carrying cost per case is $40 per year. The store is open 300 days a year. A. Determine the economic order quantity. B. Determine the reorder point if a safety stock of 24 cases is desired.
XYZ purchases 20,000 unit of a product each year in lots of 1,000 units per order....
XYZ purchases 20,000 unit of a product each year in lots of 1,000 units per order. The cost of placing an order is $20 and the cost of carrying one unit of product in inventory is $30 per year. Required: How many orders is placed per year? What is the total ordering costs per year? What is the total carrying cost of the inventory per year? What is the total cost of carrying and ordering for the year? What is...
15. A store has an ordering cost of $250, a carrying cost of $4 per unit,...
15. A store has an ordering cost of $250, a carrying cost of $4 per unit, annual product demand of 6,000 units, and it purchases product from a supplier for $500 per unit, however, the supplier has offered the store a discount price of $400 if it will purchase 1,200 units; the store’s minimum total inventory cost is a. $2,407,300 b. $3,607,200 c. $3,464,000 d. $2,987,400 16. If a store has annual demand (365 days per year) of 6,000 units...
MNO has an average annual demand for red, medium polo shirts of 100,000 units. The cost...
MNO has an average annual demand for red, medium polo shirts of 100,000 units. The cost of placing an order is $500 and the cost of carrying one unit in inventory for one year is $20. Required: a. Use the economic-order-quantity model to determine the optimal order size. b. Determine the reorder point assuming a lead time of 12 days and the store is open 250 days in the year. c. Determine the safety stock required to prevent stockouts assuming...