Question

In: Finance

1. A. (EOQ) Calculate the EOQ quantity given: a. Fixed cost per order of $40 b....

1. A. (EOQ) Calculate the EOQ quantity given:

a. Fixed cost per order of $40

b. holding cost per inventory unit of $2.00

c. estimated demand for inventory of 200,000

Solve EOQ using the information listed above:

                                                                 

B. Calculate the total cost associated the EOQ amount calculated in part A:

C. The company wants to keep Safety Stock of an additional; 8 units. Calculate the cost associated with the safety stock and the total cost of the EOQ amount with safety stock.

Cost of Safety stock:

Total cost with safety stock included:

D. It takes 2 days to get a delivery. Calculate the Reorder point when another order for the EOQ amount should be placed:

Solutions

Expert Solution

A. Economic Order Quantity ( EOQ ) =

Where :

D = total inventory units demanded over a planning period

P = fixed cost per purchase order

C = carrying or holding cost per inventory unit over the planning period

EOQ =

=

=

= 2828 Units

B. Total Cost = Annual Ordering Cost + Annual Holding Cost

= ( 40 * 200000) + ( 2 * 200000)

= 8000000+400000

= 8400000

C. Cost of safety stock = Ordering cost of safety stock + holding cost of safety stock

  = ( 40*8) + (2*8)

= 320 + 16

= 336

Total cost with safety stock = (40 * 200008) + ( 2 * 200008)

= 8000320+400016

= 8400336

D. Reorder point = (Usage rate * Lead time) + safety stock

  = ( 200000/365*2) + 8

= 1095.8 + 8

= 1103.8 that is , 1104 units

Here lead time is considered as 2 days over 365 days ( days in an year ) as delivery time over how many days is not given.

Therefore at 1104 units we want to place next order.


Related Solutions

For an EOQ ordering quantity of 750 units, an ordering cost of $5 per order, a...
For an EOQ ordering quantity of 750 units, an ordering cost of $5 per order, a holding cost of $10 per unit per year, and an annual demand of 900 units, what is the annual total cost for this value of Q?
For this item, you are asked to calculate the EOQ – Economic Order Quantity. A good...
For this item, you are asked to calculate the EOQ – Economic Order Quantity. A good place to start is by watching this week’s video. When determining the numbers for the variables needed to perform the calculation, be realistic. Research what the actual numbers could be and provide an explanation/rationale for choosing the numbers. Perform the calculation and explain what the result means to your business.
Find the EOQ, the total annual cost associated with the economic order quantity, the reorder point,...
Find the EOQ, the total annual cost associated with the economic order quantity, the reorder point, number of orders per year and the time between orders. Annual Demand 15,600 units Weeks Operating 52 weeks/year Set up Cost $60/order Holding rate 20% Unit cost $80 /unit Lead-Time 5 weeks
Given the following Selling Price: 50$ per unit Variable Cost: 40$ per unit Fixed Cost: 80,000$...
Given the following Selling Price: 50$ per unit Variable Cost: 40$ per unit Fixed Cost: 80,000$ per unit Calculate: A. Contribution margin as well as the contribution margin ratio B. Profit(loss) if 7,200 units are sold C. Margin of safety if 10,100 units are sold D. Break even point in dollars
Consider a basic economic order quantity (EOQ) model with the following characteristics: Item cost: $15 Item...
Consider a basic economic order quantity (EOQ) model with the following characteristics: Item cost: $15 Item selling price: $20 Monthly demand: 500 units (constant) Annual holding cost: $1.35 per unit Cost per order: $18 Order lead time: 5 working days Firm's work year: 300 days (50 weeks @ 6 days per week) Safety stock: 15% of monthly demand For this problem, determine the values of: Q* the optimal order quantity and reorder point. Select one: a. 400 and 100 b....
COST ACCOUNTING Companies can use the Economic Order Quantity (EOQ) method to maintain the existing inventory...
COST ACCOUNTING Companies can use the Economic Order Quantity (EOQ) method to maintain the existing inventory conditions within the company, especially to reduce the existing fixed costs that can arise from the purchase of goods using expedition services. For example, buying goods with Full Container Load (FCL) and Less Container Load (LCL), the LCL fixed cost will be greater because the goods purchased are small but the tariff for sending goods from the supplier to the factory requires no small...
1. From the figures given below, calculate Economic OrderQuantity (EOQ) and Total cost at E0Q? Total...
1. From the figures given below, calculate Economic OrderQuantity (EOQ) and Total cost at E0Q? Total consumption of material per year Unit cost of material10,000 kgsBuying cost per order $ 50$ 2 per kgCarrying and storage cost 8%2. The XR stocks carpet in its warehouse and sells it through anadjoining showroom. The store keeps several brands and styles of carpet in stock; however, its biggest seller is Super Shag carpet. The store wants to determine the optimal order size and...
Which of the following is NOT an assumption of the traditional economic order quantity (EOQ) model?...
Which of the following is NOT an assumption of the traditional economic order quantity (EOQ) model? a. Holding and ordering costs are stable and known. b. Demand is constant and known. c. Supply lead time is constant and known. d. Quantity discounts are possible. Kim’s Nail Salon uses a weighted moving average method to forecast demand. She assigns a weight of 5 to the previous month’s demand, 3 to demand two months ago, and 2 to demand three months ago....
the primary purpose of the Economic Order Quantity (EOQ) model is to: A. Maximize the customer...
the primary purpose of the Economic Order Quantity (EOQ) model is to: A. Maximize the customer service level B. Calculate the reorder point, so that replenishment take place at the proper time C. Calculate the optimum safety stock level D. None of these answers
Which of the following is true of the EOQ model? Note that the optimal order quantity,...
Which of the following is true of the EOQ model? Note that the optimal order quantity, Q*, will be called EOQ. If the annual sales, in units, increases by 10%, then EOQ will increase by 10%. If the average inventory increases by 10%, then the total carrying costs will increase by 10%. If the average inventory increases by 10% the total ordering costs will increase by 10%. At any order quantity below the EOQ, then total carrying costs increase, but...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT