Assume that owners decided to go ahead with the Canmore expansion (first introduced in question 4). The junior accountant has prepared the following report to compare the static budget (from question 4) to the actual results. The owners have asked you to complete a variance analysis. Required: Part A (4 marks)- Create a Static Budget Report Variance Analysis, indicating whether variances are favorable (F) or unfavorable (U). All variance amounts should be shown as positive numbers. Static Budget Amount Actual Results Variance Amount Favorable or Unfavorable Sales in Units 4,136 4,610 $ 517,000 $ 553,200 218,000 217,000 Sales Less: Variable costs: Cost of Goods Sold Sales Commissions Total Variable costs Contribution Margin Less: Fixed Costs: 77,448 62,040 280,040 236,960 294,448 258,752 The president feels very strongly that Mountain Sports should expand operations to a second location. She has even found a prime location in Canmore, Alberta, One of the great things about Canmore is its proximity to the mountains, and its only about 10 minutes away from this beautiful, vibrant and internationally known Banff tourist town. Research indicates that the Canmore market is well suited to both cross-country skis and bikes that competition is fairly The investment in assets (cash, inventory, equipment) required for the new location $ 205,000 Minimum required return on investments 13% Actual 2019 return on investment of the original location 20% Management has provided the following income statement to the bank manager the expected net Static Budget Amount Sales in Units 4,136 Sales 517,000 100% Less: Variable costs: Cost of Goods Sold 218,000 42% Sales Commissions 62,040 12% Total Variable Costs 280,040 54% Contribution Margin 236,960 46% Less: Fixed Costs: Advertising 21,000 Property Taxes 10,000 Rent 44,000 Salaries & Wages Total Fixed Costs Net Operating Income 108,000 183,000 53.960 Part A: (4 marks) Calculate the following performance measurements for the proposed Canmore expansion: Margin (see Chapter 11 notes) 10% Turnover (use investment in assets in equation) 2.5 Return on Investment 26% Residual Income UH $ 27,310