Solve with excel formulas, same format for cell numbers.

Name Husky Company operates a bike store with two departments, mountain bikes and road bikes. Calculate the departmental contribution to overhead and the departmental net income using a a contribution to overhead statement for Mountain Bikes and Road Bikes for the followin costs. Hint: Dorft forget Gross Profit Account Mountain Road 515,000 133,000 11 13 15 16 17 18 21 23 24 25 26 27 28 29 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Department costs Sales Cost of goods sold Direct expenses: Salaries Insurance Utilities Depreciation Maintenance Office expenses Indirect costs are allocated as follows: Mountain $910,330 Road Indirect 20,720 25,200 22,960 7,500 $512,000 332,540 90,720 12,320 27,440 14,000 5,600 o $32,400 7,160 1, 700 46,000 Salaries Insurance Depreciation Office expenses Department Mountain Bikes Road Bikes ndirect cost allocation base Basis of Sales Square footage Square footage Number of Employees Square footage 30,000 10,000 Number of employees 50 15