[Solved]Question 10 Wvtu Please Show Part B Inputs Analytic Solver Would Excel Q37023323
The question is #10 WVTU. Please show for part b, what theinputs into analytic solver would be in Excel.credited s $50,000 an annuity contract. Assume investment earnings are eet model for this problem that computes the profit Hometown ometown expect to make on average on the contract? in such at the end of the year amd thi problem t con a. Build a spreadsheet b. c. What is the probability would make on the contract. How uch mo can H Supposehtrt Hometown would lose money on the contract? What at provides a 2% chance of the company losing money on the con- station that has 20 thirty-second advertising slots during their rn that etown wants to identify the minimum guaranteed annual rate 10. the minimum a television mm guaranteed annual rate of return be? ularly scheduled programming each evening. The station is now selling advertis- each, butbi ovember. They could sell all the slots immediately for y be able to sell slots at the last minute to political candidates in tight as follows: ice of $8,000 each. The demand for these last-minute slots is estimated knows she moDecause November 7 will be an election day, the station manager races for a of $8,000 Demand 8 9 10 11 12 13 14 15 16 17 18 19 ility 0.03 0.05 0.10 0.15 0.20 015 0.10 0.05 0.05 0.05 0.05 0.02 ts not sold in advance and not sold to political candidates at the last minute can the station manager sells all the advertising slots in advance, how much rev- b. How many advertising slots should be sold in advance if the station manager If the station manager sells in advance the number of slots identified in the previ- Slo be sold to local advertisers at a price of $2,000 a. If enue will the station receive? wants to maximize expected revenue? c. ous question, what is the probability that the total revenue received will exceed the amount identified in part a where all slots are sold in advance? July regarding the number of ski jackets to order for the following ski season. Each ski jacket costs $54 each and can be sold during the ski season for $145. Any unsold jackets at the end of the season are sold for $45. The demand for jackets is expected 11. The owner of a ski apparel store in Winter Park, Colorado, must make a decision in Show transcribed image text credited s $50,000 an annuity contract. Assume investment earnings are eet model for this problem that computes the profit Hometown ometown expect to make on average on the contract? in such at the end of the year amd thi problem t con a. Build a spreadsheet b. c. What is the probability would make on the contract. How uch mo can H Supposehtrt Hometown would lose money on the contract? What at provides a 2% chance of the company losing money on the con- station that has 20 thirty-second advertising slots during their rn that etown wants to identify the minimum guaranteed annual rate 10. the minimum a television mm guaranteed annual rate of return be? ularly scheduled programming each evening. The station is now selling advertis- each, butbi ovember. They could sell all the slots immediately for y be able to sell slots at the last minute to political candidates in tight as follows: ice of $8,000 each. The demand for these last-minute slots is estimated knows she moDecause November 7 will be an election day, the station manager races for a of $8,000 Demand 8 9 10 11 12 13 14 15 16 17 18 19 ility 0.03 0.05 0.10 0.15 0.20 015 0.10 0.05 0.05 0.05 0.05 0.02 ts not sold in advance and not sold to political candidates at the last minute can the station manager sells all the advertising slots in advance, how much rev- b. How many advertising slots should be sold in advance if the station manager If the station manager sells in advance the number of slots identified in the previ- Slo be sold to local advertisers at a price of $2,000 a. If enue will the station receive? wants to maximize expected revenue? c. ous question, what is the probability that the total revenue received will exceed the amount identified in part a where all slots are sold in advance? July regarding the number of ski jackets to order for the following ski season. Each ski jacket costs $54 each and can be sold during the ski season for $145. Any unsold jackets at the end of the season are sold for $45. The demand for jackets is expected 11. The owner of a ski apparel store in Winter Park, Colorado, must make a decision in
Expert Answer
Answer to The question is #10 WVTU. Please show for part b, what the inputs into analytic solver would be in Excel. … . . .
OR
