Question: please answer above questions by using excel and show the work! 13.1. AV City stocks and sells a particular brand of laptop. It costs the


please answer above questions by using excel and show the work!
13.1. AV City stocks and sells a particular brand of laptop. It costs the firm $625 each time it places an order with the manufacturer for the laptops. The cost of carrying one laptop in inventory for a year is $130. The store manager estimates that total annual demand for the laptops will be 1500 units, with a constant demand rate through- out the year. Orders are received within minutes after placement from a local warehouse maintained by the manufacturer. The store policy is never to have stockouts of the laptops. The store is open for business every day of the year except Christmas Day. Determine the following: a. Optimal order quantity per order b. Minimum total annual inventory costs c. The number of orders per year d. The time between orders (in working days) units Demand = 1500 Inventory Carrying cost = $130.00 Ordering cost = $625.00 (a) Q* 120 units per order (b) Total cost = Total ordering cost = Total holding cost = (d) Time between orders = (order cycle)Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
