Question: Can someone explain the excel commands for this problem? Acomputer products store stocks color graphics monitors. The store is open 7 days/week. They sell 10,000

Can someone explain the excel commands for this problem?
Acomputer products store stocks color graphics monitors. The store is open 7 days/week. They sell 10,000 monitors/year. The order cost is $150/order and the inventory holding cost is $2.20/monitor. The daily demand is normally distributed with a standard deviation of 0.65 monitor. The lead time receive an order from the manufacturer is 20 days. Determine the optimum order quantity, the reorder point that ensures a probability of 94% of not running out of inventory. Order Cost Annual Demand Daily Demand monitors (no decimals) round to 2 decimals Optimum Order Quantity Z-factor for 94% probability Std Dev during Lead Time Reorder Point with Safety Stock Lead Time Holding Cost daily Std Dev Probability days monitors (no decimals) monitors (no decimals) Acomputer products store stocks color graphics monitors. The store is open 7 days/week. They sell 10,000 monitors/year. The order cost is $150/order and the inventory holding cost is $2.20/monitor. The daily demand is normally distributed with a standard deviation of 0.65 monitor. The lead time receive an order from the manufacturer is 20 days. Determine the optimum order quantity, the reorder point that ensures a probability of 94% of not running out of inventory. Order Cost Annual Demand Daily Demand monitors (no decimals) round to 2 decimals Optimum Order Quantity Z-factor for 94% probability Std Dev during Lead Time Reorder Point with Safety Stock Lead Time Holding Cost daily Std Dev Probability days monitors (no decimals) monitors (no decimals)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
