Pls type it I can't open files

Macmillan Launchp.. BM Excel 2019 L1_. M Question 10 - Chapt. Mary Roberts 11/16/23 12:17 AM Question 6 of 6 > This quiz: 10 point(s) possible This question: 5 point(s) possible Submit quiz Mountain Point operates a Rocky Mountain ski resort. The company is planning its lift ticket pricing for the coming ski season. View the information. Read the requirements. Requirement 1. If Mountain Point cannot reduce its costs, what profit will it earn? State your answer in dollars and as a percent of assets. Will investors be happy with the profit level? Complete the following table to calculate Mountain Point's projected income. X Revenue at market price Information Less: Total costs Operating income Investors would like to earn a 15% return on investment on the company's $148,500,000 of assets. The company primarily incurs fixed costs to groom the runs (Round the percentage to the nearest hundredth percent, X.XX%. Do not enter the % symbol into the input field.) and operate the lifts. Mountain Point projects fixed costs to be $35,000,000 for the ski season. The resort serves about 725,000 skiers and snowboarders each season. Mountain Point's projected operating income (profit) as a percent of assets amounts to %. Variable costs are about $9 per guest. Last year, due to its favorable reputation, Mountain Point was a price-setter and was able to charge $3 more per lift ticket than Will investors be happy with this profit level? its competitors without a reduction in the number of customers it received. Assume that Mountain Point's reputation has diminished and other resorts in the vicinity are charging only $85 per lift ticket. Mountain Point has become a price-taker and will not be able to charge more than its competitors. At the market price, Requirement 2. Assume Mountain Point has found ways to cut its fixed costs to $33,000,000. What is its new target variable cost per skier/snowbo Mountain Point managers believe they will still serve 725,000 skiers and snowboarders each season. Complete the following table to calculate Mountain Point's new target variable cost per customer. (Round your final answer to the nearest cent.) Revenue at market price Less: Desired profit Print Done Target full cost Less: Reduced level of fixed costs Target total variable costs Divided by number of skiers / snowboarders Submit quiz