Question: Please solve the question in excel so I give you thumb up 1 A retailer of computing products sells a variety of computer-related products. One

Please solve the question in excel so I give you thumb up Please solve the question in excel so I give you

1 A retailer of computing products sells a variety of computer-related products. One of her popular products is an 2 HP laser printer. Based on the historical sales record, the manager estimates that her weekly demand follows a 3 normal distribution with a mean of 220 and a standard deviation of 20 printers. Please solve the question 4 Using EXCEL \begin{tabular}{l|l|r|} \hline 5 & & \\ \hline 6 & Mean, = & 220 \\ \hline 7 & Stardard deviation, & 20 \end{tabular} a. What is the probability that the retailer will sell at most 200HP printers next week? b. What is the probability that the retailer sells between 180 and 250HP printers next week? c. The retailer understands that if a customer wants to buy an HP laser printer but she has none in stock, she will lose that sales and any possibly additional sales. Given this observation, she wants the probability of running short in any week to be no more than 9%. How many HP laser printers should she have in stock when she reorders from the manufacturer (Assume that the lead time for a new order from the manufacturer to arrive is exactly one week. Her reorder quantity is needed to cover the demand for one week)

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!