Will you be able to solve the attched problem using his step by step instructions?

I cant understand how to do it and its due tomorrow 12am...

See notes below

Notes on using Excel for matrix inversion1. Using the mouse, highlight the range for the inverted matrix2. Press the equal key.3. Select MINVERSE from the function list4. Highlight the coefficient matrix5. Press Ctrl-Shift-Enter simultaneously to fill in the inverted matrixNotes on using Excel for matrix multiplication1. Using the mouse, highlight the range for the output2. Press the equal key.3. Select MMULT from the function list.4. Highlight the inverted matrix and the cost vector5. Press Ctrl-Shift-Enter simultaneously to get the allocated costs

Supplemental\tQuiz\ton\tthe\tReciprocal\tMethod Prepare your answer in a single spreadsheet file. Use Excel's formula functions to compute your answers. Show your work. Clearly label each answer. Submit the file using the Assignments Tool to Canvas. Davy Company has three products. Product 1 is manufactured entirely in Department P1. Product 2 is manufactured entirely in Department P2. Product 3 is manufactured entirely in Department P3. To produce these products, Davy has three support departments: S1 (materials handling), S2 (milling), and S3 (power). Davy is considering buying its power from an external supplier for $130.00 per kilowatt hour (KWH). The budgeted variable costs and the allocation bases for each support department appear below. The budgeted fixed costs of S3 are $200,000. Support Department S1 (materials handling) S2 (milling) S3 (power) Variable costs a. b. c. S1 245 950 400 112,000 S2 585 1,050 250 420,000 S3 600 700 350 468,000 P1 805 600 2,000 P2 1,250 400 1,250 P3 1,515 300 750 Allocation Base 5,000 4,000 5,000 1,000,000 (5 points) What are the costs allocated to P1, P2, and P3 using the reciprocal method? (5 points) Assuming that only the variable costs of S3 are avoidable, should Davy accept the supplier's offer? Explain. (Tip: Refer to my lecture on this topic.) (5 points) Assuming that all costs of S3 are avoidable, what are the total avoidable costs if S3 is shut down? (Tip: Refer to my lecture and \"Notes on Using the Reciprocal Method in Make-versus-Buy Decisions\" in the Learning Modules tool) EXCELLENCE\tWITH\tPERSEVERANCE\tAND\tINTEGRITY