Question: Please solve this question using excel and show the steps of it! again please solve the question using excel! The manager of Computer-World, a store

Please solve this question using excel and show the steps of it! again please solve the question using excel! Please solve this question using excel and show
The manager of Computer-World, a store that sells computers and related equipment, is attempting to determine how many laptop PCs the store should order each week. A primary consideration in this decision is the average number of laptop computers that the store will sell each week and the average weekly revenue generated from the sale of laptop PCs. Alaptop sells for $4,000. The number of laptops demanded each week is a random variable (which we will define as x) that ranges from 0 to 5. From past sales records, the manager has determined the frequency of demand for laptop PCs for the past 200 weeks. From this frequency distribution, a probability distribution of demand can be developed, as shown in the table below. Demand 0 1 2 3 4 5 Total Frequency 20 50 40 50 20 20 200 If too few laptops are on hand to meet demand during the week, then not only will there be a loss of revenue, but there will also be a shortage cost of $400 per unit incurred because the customer will be unhappy. However, cach laptop still in stock at the end of each week that has not been sold will incur an inventory or storage cost of $100. Thus, it costs the store money to have either too few or too many laptops on hand each week. Given this scenario, the manager wants to order either two or three laptops, depending on which order size will result in the greatest average weekly revenue, Simulate the sales for 200 weeks and then compute the average weekly sales. Determine the best order quantity

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!