Using the spreadsheet found below,compute an allocation of costs using the two different methods we worked on in class.The data has already been provided in the attached excel file, using the area designated compute the costs as instructed below, with the goal to complete the table marked "RESULTS USING CASES".

A.Using the data found inthe worksheet, compute the allocation of costs using the Direct Method as follows:

1. Allocate Administration on the basis of cases.
2. Allocate Facilities on the basis of square footage.
3. Allocate Finance on the basis of direct cost.