Question: Solve problem in excel and show formauls Weekly demand for Canon printers at a BestBuy store is normally distributed with a mean of 250 and

Solve problem in excel and show formauls

Weekly demand for Canon printers at a BestBuy store is normally distributed with a mean of 250 and a standard deviation of 80. Inventory is continuously monitored and an order of 1,000 printers is placed each time the inventory drops to 950 printers. The replenishment lead-time is three weeks.

How much safety inventory does the store carry? What is the CSL?
Assume that the supply lead-time from Canon is normally distributed with a mean of 3 weeks and a standard deviation of 2 weeks. How much safety inventory should BestBuy carry if it wants to provide a CSL of 97 percent?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Weekly demand for Canon printers at a BestBuy store is normally distributed with a mean of 250 and a standard deviation of 80. Inventory is continuously monitored and an order of 1,000 printers is...

Walmart sells 30,000 units of LG TVs every month. Each TV costs $350 and Walmart has a holding cost of 20 percent. The fixed cost for each order Walmart places with LG is $4,000. What is the optimal...

3. Weekly demand for Canon printers at a BestBuy store is normally distributed with a mean of 250 and a standard deviation of 80. Inventory is continuously monitored and an order of 1,000 printers is...

Weekly demand for Canon printers at a BestBuy store is normally distributed with a mean of 250 and a standard deviation of 80. Inventory is continuously monitored and an order of 1,000 printers is...

Weekly demand for Canon printers at a BestBuy store is normally distributed with a mean of 750 and a standard deviation of 180. Inventory is continuously monitored and an order of 4500 printers is...

STATISTICS FOR DECISION MAKING Dr. Azar Abizada HOMEWORK 4 Due Date: Wednesday, March 11th class time Problem 1 (26 points): Be careful, each part of this question is independent of one another. a)...

COMM 215: BUSINESS STATISTICS REVIEW PROBLEMS 1 Descriptive Statistics 1. The listing below gives the service window of A&W: 4.91 0.85 0.52 2.51 1.92 2.66 1.94 5.19 2.33 3.51 2.95 2.62 service times...

ECON 1203 Tutorial Workshop Questions Semester 1 2016 ***This document will be periodically updated with questions to be discussed in succeeding tutorials, and re-posted to Moodle every fortnight.***...

1 Weekly demand for HP printers at Sam's Club store is normally distributed with a mean of 250 and standard deviation of 150. The store manager continuously monitors inventory and currently orders...

Specify the magnitude of F 3 and its coordinate direction angles ? 3 , ? 3 , ? 3 so that the resultant force F R = {9j} kN. F= 10 kN 13 12 30 F 12 kN

Use data you find online to respond to the following items. Cite the page or pages where you obtain this information by including a citation list at the end of your presentation which includes the...

Which of the following is not true regarding the Statement of Cash Flours for nongovemmenta 2 . 5 points Multiple Choice 0 1 : 5 8 : 1 9 If a not - for - profit organization received s restricted...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...