Question 10 A News Carrier Sells Newspapers And Tries To Maximize Profit The Exact Number Of Papers Purchased Daily By 1 (72.29 KiB) Viewed 23 times
Question 10 A News Carrier Sells Newspapers And Tries To Maximize Profit The Exact Number Of Papers Purchased Daily By 2 (23.27 KiB) Viewed 23 times
QUESTION 10 A news carrier sells newspapers and tries to maximize profit. The exact number of papers purchased daily by customen can be pelicula probability distribution for demand/day was developed. The following ordering policy was used by the news carrier: the amount ordered each day is equal to the quantity demanded the proming lang A paper costs the carrier 15 cents, the carrier sells it for 30 cents. Unsold papers are returned and the carrier is credited 8 cents per paper returned. An unsatisfied customer is estimated to cost 7 cents in good will. Demand for day 0 was assumed to be 18. The problem has been set up in an EXCEL spreadsheet in order to simulate sales for the new currice. The prende SETUP G H E F C D Cost per paper A B Demand Probability 15 0.08 16 0.16 17 0.34 18 0.25 19 0.09 20 0.08 1 2 3 4 5 6 7 0.15 0.08 0.07 0.30 Unsold credit Lost goodwill cost Revenue per paper مدام به Sales Reverse Prati 21 Cost of Lost Simulated Papers Cost of Credit demand sold ordered for unsold goodwill 8 9 Day Amount ordered 20 18 10 11 12 13 14 التها منه به با اهم 3 4 Write the formulas that would be used and the numerical results for the following celle Macbook a cell E10 b. cell F10 c. cell G10 del HIO Prir to score and submit. Click Save All stor de
13 4 145 Write the formulas that would be used and the numerical results for the following cells a. cell E10 b. cell F10 c. cell G10 d. cell H10 e. cell 110 f. cell J10 8. cell B11 f 12 For formulas, include references only to cells on the worksheet, not to specific numbersfor example -B11 F2 Note: the model must be a general and flexible as possible. If statements are Clearly label answers as a, b,c,... ALT+F10 (PC) or ALT+FN-F10 (Mac). Arial 10
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!