I need help!! some is completed i just need help with the rest. thank you

Exercise 22-6 Departmental expense allocation spreadsheet LO P2 Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2017 Department Direct Expenses Square Feet Sales Advertising $ 14,000 1,350 Administrative 30, ece Shoes 116,000 7,200 $100,800 Clothing 17,880 5,700 109,200 750 The advertising department developed and distributed 140 advertisements during the year of these, 28 promoted shoes and 112 promoted clothing. Utilities expense of $42,000 is an indirect expense to all departments Complete a departmental expense allocation spreadsheet for Marathon Running Shop. The spreadsheet should assign (1) direct expenses to each of the four departments, (2) the $42,000 of utilities expense to the four departments on the basis of floor space occupied, (3) the advertising department's expenses to the two operating departments on the basis of the number of ads placed that promoted a department's products, and (4) the administrative department's expenses to the two operating departments based on the amount of sales 750 Department Advertising Administrative Shoes Clothing Totals Advertising Department Shoes Clothing Totals Arrocon base PETROLITOS Da ROU LOSE Allocated Floor space occupied Numerator Denominator% of Total 1,350 1,350 15,000 9.00 $ 42,000 $ 3,780 750 15,000 5.00 42,000 2,100 7200 7,200 15,000 48.00 42.000 20,160 5,700 5,700 15,000 38.00 42.000 15,960 15,000 100.00 $ 42,000 Allocation Base Cost to be Percent of Allocation Base Allocated Cost Allocated Number of ads Numerator Denominator% of Total 28 28 140 20.00 17,780 $ 3,556 112 112 140 80.00 17.780 14,224 140 100.00 $ 17,780 Allocation Base Percent of Allocation Base Cost to be Allocated Cost Allocated Sales Numerator Denominator% of Total S 100,800 $ 100,800 $210,000 48.00 109,200 109,200 210,000 52.00 S 210,000 100.00 Administrative Department Shoes Clothing Totals Totals 740 100.00 17.780 Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Administrative Department Shoes Clothing Totals Sales Numerator Denominator% of Total 100,800 $ 100,800 $210,000 48.00 109,200 109,200 210,000 52.00 $ 210,000 100.00 MARATHON RUNNING SHOP Departmental Expense Allocation Spreadsheet For Year Ended December 31, 2017 Expense Totals Advertising AdministrativBhoes Clothing 0 0 0 0 0 0 Direct expense Indirect utilities expenses Total dept. exp. Service Dept. Expenses Advertising Dept. Administrative Dept. Total expenses allocated 0 0 $ 0 $ 0 $ 0 $ 0 $ 0 Required information Use the following information for the Exercises below. [The following information applies to the questions displayed below) Megamart, a retailer of consumer goods, provides the following information on two of its departments (each considered an investment center) Investment Center Electronics Sporting goods Sales Income 543,000,000 $2,752,000 19,000,000 1,980,000 Average Invested Assets $17,209,000 15,200,000 Exercise 22-10 Computing return on investment and residual income; investing decision LO A1 1 Compute return on investment for each department Using return on investment, which department is most efficient at using assets to generate returns for the company? 2. Assume a target income level of 10% of average invested assets. Compute residual income for each department which department generated the most residual income for the company? 3. Assume the Electronics department is presented with a new investment opportunity that will yield a 15% return on investment Should the new investment opportunity be accepted? Complete this question by entering your answers in the tabs below. Required : Required 2 Required 3 Compute return on investment for each department. Using return on investment, which department is most efficient at using assets to generate returns for the company? Choose Numerator Return on investment Choose Denominator Return on investment Return on Investment 1 Electronics Sporting Goods Which department is most efficient at using assets to generate returns for the company? Roured Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Assume a target income level of 10% of average invested assets. Compute residual income for each department. Which department generated the most residual income for the company? Investment Center Electronics Sporting Goods Net income Target net income Residual income Which department is most officient at using assets to generate returns for the company? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Assume the Electronics department is presented with a new investment opportunity that will yield a 15% return on investment. Should the new investment opportunity be accepted? Should the now investment opportunity be accepted?