i need some help on this excel hw! please and thank you!

AutoSave Ch 34 Excel Activity - Bocel Page Layout Formulas Data A Juhan Chang Home Insert Draw Review View Help Share Comments X In Calibri - 28 General S- 2 O BIU- nur - Delete- Format $ -% Ideas Sensitivity Conditional formatas Cell Formatting Table Styles Styles Clipboard Feet Sort find a Fitte Select Editing Alg Number Cets Ideas B1 . K M N Mountain Road G H 2 Husky Company operates a bike store with two departments, mountain bikes and road bikes. 3 Calculate the departmental contribution to overhead and the departmental net income using a 4 a contribution to overhead statement for Mountain Bikes and Road Bikes for the following 5 Department costs Mountain Hoad Indirect 6 Sales $812,300 $457,200 7 Cost of goods sold 460,000 297,180 8 Direct expenses Salaries 119,000 81,000 $29,000 10 Insurance 18,500 11,000 6.400 31 Utilities 22.500 24,500 12 Depreciation 20.500 12.500 1.500 13 Maintenance 6.700 5.000 Office 0 0 41,000 14 expenses 15 16 Indirect costs are allocated as follows: 17 Salaries Basis of Sales 18 Insurance Square footage 19 Depreciation Square footage 20 office expenses Number of Employees 21 22 Department Square footage Number of employees 23. Mountain Bikes 35.000 70 Road Bikes 15,000 30 Department Income Statement E acer