Reciprocal Method Take Home Assignment Reciprocity Company has 2 operating departments (A & B), and three support departments, which are described below: Technical Support Janitorial Support Personnel # of tech-support hours used square footage of space occupied # of employees The usage of each department (support and operating) for the above cost drivers for the year is as follows Technical Technical Support Janitorial Personnel Oper. DeptA Oper. Dept B 200 150 1,550 2,100 3,500 580 1.600 1,300 4,850 12,600 35 26 Original costs incurred in each department this year are presented below Technical Support Janitorial Personne Oper. A Oper. B S 160,000 $ 95,000 150,000 S 720,000 S 900,000 Required: (10 pts) Due to D2L Assignments dropbox by the end of the day (11:59pm) on Mon., Apr 1". a) Write out the total cost formulas for each of the three support departments You must separately write this out at the top of your Excel spreadsheet to get credit for this requirement. (I will not award points for this requirement simply by looking at how your costs are calculating within Excel.) b) Using Excel to solve your equations from part 'a', above, determine what the total costs of cach Operating Department (A&B) would be after support department costs are allocated using the Reciprocal method. Please clearly label your final answers to this part. Please insert fractions into your Excel formulas (as opposed to decimal point relationships), thereby diminishing any rounding issues. Stll, have Excel round your dollar amounts to the nearest cent