Markdown Pricing Model, 4 questions on excel help

Please do problems # 8, 9, 15 and 20 from Pages 118-121 onwards of your Module 2 textbook. Use the attached datafile for # 15. You can use the same Excel file.

Some Notes: For # 8 assume number of solicitations to be 500 calls. For # 9 assume 20 purchased copies and demand of 15 copies. For # 20, create 2 scenarios (optimistic and pessimistic) for these 3 variables (expected crowd, ave concession expenditure and fixed cost) and calculate with scenario manager what the band profit will be in those 2 scenarios

I believe that you have to solve question number 4 in order to do question number 20. so i uploaded the question number 4 too