Question

In: Finance

​(EOQ calculations​) A downtown bookstore is trying to determine the optimal order quantity for a popular...

​(EOQ

calculations​)

A downtown bookstore is trying to determine the optimal order quantity for a popular novel just printed in paperback. The store feels that the book will sell at four times its hardback figures. It​ would, therefore, sell approximately

4 comma 0004,000

copies in the next year at a price of​ $1.50. The store buys the book at a wholesale figure of​ $1. Costs for carrying the book are estimated at

​$0.250.25

a copy per​ year, and it costs

​$1010

to order more books.a. Determine the

EOQ.

b. What would be the total costs for ordering the books​ 1, 4,​ 5, 10, and 15 times a​ year?

c. What questionable assumptions are being made by the EOQ ​model?

Solutions

Expert Solution

a) EOQ formula= ((2*Annual demand*order cost)/Carrying cost per order p.a)) ^ (1/2)

= 565 units per order (approx)

b)

No.of orders Copies per order (Annual demand/No. of orders) Average inventory (copies per order/2) Total Ordering Cost (no. of orders*10) Total Carrying Cost(avg inventory*0.25) Total Purchase Cost (annual demand* $1/copy) Total Cost (Order +Carrying+Purchase Cost)
1 4000/1 =4000 2000 10 500 4000 4510
4 1000 500 40 125 4000 4165
5 800 400 50 100 4000 4150
10 400 200 100 50 4000 4150
15 266.67 133.33 150 33.33 4000 4183.33

c) Questionable assumptions made by EOQ Model:

1. The model assumes that replenishment of stock is very easy, i.e, prompt deliveries by the supplier

2. The purchase price stays the same throughout the year which might not be true incase the supplier wishes to change the same

3. The annual demand for the product stays constant all over the year, incase it changes, all EOQ calculations have to be revised which is again a tedious task


Related Solutions

(EOQ calculations​) A downtown bookstore is trying to determine the optimal order quantity for a popular...
(EOQ calculations​) A downtown bookstore is trying to determine the optimal order quantity for a popular novel just printed in paperback. The store feels that the book will sell at four times its hardback figures. It​ would, therefore, sell approximately 3 comma 000 copies in the next year at a price of​ $1.50. The store buys the book at a wholesale figure of​ $1. Costs for carrying the book are estimated at ​$0.30 a copy per​ year, and it costs...
A downtown bookstore is trying to determine the optimal order quantity for a popular novel just...
A downtown bookstore is trying to determine the optimal order quantity for a popular novel just printed in paperback. The store feels that the book will sell at four times its hardback figures. It would,therefore, sell approximately 6,000 copies in the next year at a price of $1.50. The store buys the book at a wholesale figure of $1. Costs for carrying the book are estimated at $0.15 a copy per year, and it costs $25 to order more books....
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...
1. Consider the basic EOQ model (no uncertainty). Optimal order quantity (Q ∗) is 1,800 units....
1. Consider the basic EOQ model (no uncertainty). Optimal order quantity (Q ∗) is 1,800 units. What is the average inventory level (I ∗)? a. 900 units b. 1,800 units c. 600 units d. 1,000 units e. 3,600 units 2. Consider the basic EOQ model (no uncertainty). Annual holding cost (AHC) is $2,400. Find annual ordering cost (AOC). a. Cannot be answered because there is missing information b. AOC=$0, since there is no uncertainty c. $1,200, since AOC=AHC/2 at economic...
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...
A company GPro, uses EOQ logic to determine the order quantity for its various components and is planning its orders.
A company GPro, uses EOQ logic to determine the order quantity for its various components and is planning its orders.The Annual consumption is 80,000 units, Cost to place one order is 1,200 dollars, Cost per unit is 50 dollars and carrying cost is 6% of Unit cost.Calculate:- EOQ- Number of orders per year- The ordering cost- The carrying cost- Total Inventory cost
Barney’s Bookstore Barney’s Bookstore plans to order a popular new hardback novel. It can purchase any...
Barney’s Bookstore Barney’s Bookstore plans to order a popular new hardback novel. It can purchase any number of this book from the publisher, but the unit cost of the book depends on the number ordered as shown below: Order Qty Cost/Unit 1000+ $15 2000+ $14 3000+ $13 4000+ $12 Barney’s believes that demand for the book will depend on price. The lower the price, the higher the demand. Based on past data it estimates the following demand: Price Demand $30...
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
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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT