Question

In: Accounting

John's Shop demand for Clippers in San Deigo averages to 500 units per month (Note: there...

John's Shop demand for Clippers in San Deigo averages to 500 units per month (Note: there are 12 months in a year). John's Shop ordering costs is $2,000 per order. Ordering costs include order placement, transportation and receiving. The wholesale price John's Shop pays to its vendor is $250 per snow blower and John's Shop incurs a holding cost of 20 percent. Solve the problem in Excel and show formulas.

a) What is the optimal lot size John’s Shop procurement manager should order from its vendor?

b) What is the Total Annual Cost for John’s Shop optimal replenishment policy?

c) What are two (there are more, but only prodive two) assumptions of the model you used to solve this problem?

d) Do you believe the model you used to solve (a) and (b) is a good model given these assumptions? Please justify your answer.

Solutions

Expert Solution

1.       Economic order quantity(optimum lot size)=

Square root of (2*Annual demand*ordering cost per order)/carrying cost per unit)

                  = square root (2*6000*2000)/20% of $250)           

                = square root (480000)

                =693 units

2.       Ordering cost= total annual demand/Economic order quantity*ordering cost per order

Carrying cost = Economic order quantity/2* carrying cost per unit

Total annual costs= ordering cost+ carrying cost

                                                     = 6000/693*2000+ 693/2*50

                                                     = 17325+17325

                                                     =$34650

3.       Economic order quantity model assumptions:

1.       Cost of ordering remain constant throughout the year

2.       The lead time is not fluctuating.

4 Economic order quantity model   helps in minimizing inventory carrying costs. Economic order quantity is the lowest amount of inventory you must order to meet peak customer demand without going out of stock and without producing obsolete inventory


Related Solutions

6. The demand for cars at Delta Motors is 500 units per month. The company incurs...
6. The demand for cars at Delta Motors is 500 units per month. The company incurs P4,000 each time an order is placed. The cost of each cycle is P500 and the holding cost is 20%. Compute the number of cars that Delta Motors should order in each replenishment lot.                   7. You just signed a contract to receive P1000 at the end of one year. If the annual interest rate is 7%, what is this worth today?              8. As at...
The private marginal cost of throwing a party in the San Francisco is $500. The demand...
The private marginal cost of throwing a party in the San Francisco is $500. The demand for parties in SF is characterized by P = 2500 – 50*Q, where Q is the number of parties held per semester. Each party produces 150 decibels of noise, and each decibel generates $10 worth of pain and suffering among village residents. A) What is the efficient number of parties provided? B) The village taxes party hosts $10 for each decibel generated. Hosts respond...
Let us suppose the demand at a firm is 200 units per month. The firm orders...
Let us suppose the demand at a firm is 200 units per month. The firm orders 80 units each time. How many times does the firm place an order per year? What is the average inventory level at this firm?
The SCO Company sells desks that have a demand of 4 units per month and cost...
The SCO Company sells desks that have a demand of 4 units per month and cost $25 each, the annual carrying charge is 30 percent of the product value, and it costs $15 to place an order. The company is considering installing either a Q or a P system for inventory management. The standard deviation of demand has been 4 units per month, and the replenishment lead time is two months, a 90 percent service level is desired. For Parts...
1. If your salary is $ 1,500 per month and you save $ 500 per month,...
1. If your salary is $ 1,500 per month and you save $ 500 per month, your savings rate is 2. How much money should you invest today at 8% interest to get it to grow to $ 15,000 years? 3. What annual interest rate will make $ 500 increase to $ 1,948 in 12 years? 10 years
Demand for hotdogs is 500 units per week. Lead time is one week. When inventory level...
Demand for hotdogs is 500 units per week. Lead time is one week. When inventory level reached 1500 units, the regional director orders 8 weeks of demand. Compute the average inventory. A. 1000 B. 2000 C. 3000 D. 4000 E. None of the above Demand for hamburgers is 400 units per week. Lead time is one week. When inventory level reached 1000 units, the regional director orders 6 weeks of demand. Compute the flow time. A .1.5 weeks. B. 3.5...
Price Market Quantity Demanded Social Quantity Demanded ($) (units per month) (units per month) 20 10...
Price Market Quantity Demanded Social Quantity Demanded ($) (units per month) (units per month) 20 10 20 18 20 30 16 30 40 14 40 50 12 50 60 10 60 70 b. Does this product have external benefits or external costs? External benefits c. How large ($) is that externality? ? per unit
Ricky Orange’s annual demand is 12 500 units. Ordering cost is RO. 100 per order. Holding...
Ricky Orange’s annual demand is 12 500 units. Ordering cost is RO. 100 per order. Holding cost is estimated at 20% of product cost which is RO. 50 per unit. The firm works for 50 weeks per year and each week has 5 days. Calculate: a)   Economic order quantity.                                 b)   Number of orders to be placed per year.                    c)   Daily usage quantity.                      ...
If the average inventory is 4,000 units and the number of units ordered per month is...
If the average inventory is 4,000 units and the number of units ordered per month is 15,000​, compute the number of orders per month. Round to two decimals.
Annual demand for the notebook binders at Duncan’s Stationery Shop is 10,000 units.
Annual demand for the notebook binders at Duncan’s Stationery Shop is 10,000 units. Dana Duncan operates her business 300 days per year and finds that deliveries from her supplier generally take 5 working days.a) Calculate the reorder point for the notebook binders that she stocks.b) Why is this number important to Duncan?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT