Question: do in excel and show how you got the numbers Problem 4A-2: The newspaper seller's problem A classical inventory problem concerns the purchase and sale

do in excel and show how you got the numbers do in excel and show how you got the numbers
Problem 4A-2: The newspaper seller's problem A classical inventory problem concerns the purchase and sale of newspapers. The paper seller buys the papers for 33 cents each and sells them for 50 cents each. Newspapers not sold at the end of the day are sold as scrap for 5 cents each. Newspapers can be purchased in bundles of 10. Thus, the paper seller can buy 50, 60, and so on. There are three types of news days, "good," "fair," and "poor," with probabilities of 0.35, 0.45, and 0.20, respectively. The distribution of papers demanded on each of these days is given in Table 1 below. The problem is to determine the optimal number of papers the newspaper seller should purchase. This will be accomplished by simulating demands for 40 days and recording profits from sales each day. Table 1. Distribution of Newspapers Demanded Demand Probability Distribution Demand Good Fair Poor 40 0.03 0.10 0.44 50 0.05 0.18 0.22 60 0.15 0.40 0.16 70 0.20 0.20 0.12 80 0.35 0.08 0.15 0.04 0.00 0.07 0.00 0.00 0.06 90 100

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!