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.
In inventory management, economic order quantity (EOQ) is the order quantity that minimizes the total holding...
In inventory management, economic order quantity (EOQ) is the order quantity that minimizes the total holding costs and ordering costs. It is one of the oldest classical production scheduling models. Requirements: Discuss the EOQ Model using an quantitative example computation with interpretation of the solution. 2. The B. N. Thayer and D. N. Thaht Computer Company sells a desktop computer that is popular among gaming enthusiasts. In the past few months, demand has been relatively consistent, although it does fluctuate...
Economic Order Quantity (EOQ) is the order quantity that minimizes the total holding costs and ordering...
Economic Order Quantity (EOQ) is the order quantity that minimizes the total holding costs and ordering costs. 1) What's the impact of a positive lead time on EOQ? 2) Can supply chain managers in fast-fashion industries apply the EOQ model to manage their inventories? If yes, how? If no, why?
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
Given the following MRP record and an EOQ of 200 units, calculate the planned order receipts...
Given the following MRP record and an EOQ of 200 units, calculate the planned order receipts using the economic order quantity. Next, calculate the period order quantities and the planned order receipts. In both cases, calculate the ending inventory and the total inventory carried over the 10 weeks. Please show all work Week 1 2 3 4 5 6 7 8 9 10 Total Net Requirements 75 70 60 0 100 80 70 65 0 80 Planned Order Receipt Ending...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT