Complete the below problem using "EXCEL", as well as using formulas through "EXCEL". Explain part 2 giving reason as to how you concluded that.

Problem 22-4B Departmental contribution to income P3 Sadar Company operates a store with two departments: videos and music. Information about those departments follows. Sales .. Cost of goods sold Direct expenses Videos Department $370,500 320,000 Music Department $279,500 175,000 Salaries Maintenance. Utilities. Insurance 35,000 2,000 5,000 4,200 25,000 10,000 4,500 3,700 The company also incurred the following indirect costs Advertising Salaries Office expenses .$15,000 .27,000 3,200 Indirect costs are allocated as follows: advertising on the basis of sales; salaries on the basis of number of employees; and office expenses on the basis of square footage. Additional information about the departments follows. Square footage 5,000 3,000 Department Number of employees Videos Music Required 1. For each department, determine the departmental contribution to overhead and the departmental net income. 2. Should the video department be eliminated? Explain. Check (1) Music dept. net income, $42,850