PLEASE HELP ME OUT FIGURE OUT WITH RECIPROCAL METHOD

Download the Excel template and data file and complete the questions below. Ithacor Training Inc. started as a single facility for job retraining in Ithaca, New York. The company recently expanded to a new, much larger, second facility in Cortland. The company provides meals from the cafeteria in the Cortland facility to the employees at both locations. Ithacor Training also has a common cleaning crew, and an HR department that provides hiring and job placement for the retrained workers. The company is interested in how the support costs can best be assigned to the facilities which should be held responsible. Information about the costs for the support departments and the consumption of that support is provided here. Operating costs incurred by department Cost allocation bases and usage by department There are four parts to this problem. Use Excel to perform the following. (a) Your answer is partially correct. Set up the iterative formulas to compute the costs allocated to each support department using the reciprocal method. (Do not leave any answer field blank. Enter 0 for amounts. Enter negative amounts with either a - sign e.g. 15,000 or in parenthesis e.g. (15,000). Ithacor a new, to the providi best be depart Download the Excel template and data file and complete the questions below. Ithacor Training Inc. started as a single facility for job retraining in Ithaca, New York. The company recently expanded to a new, much larger, second facility in Cortland. The company provides meals from the cafeteria in the Cortland facility to the employees at both locations. Ithacor Training also has a common cleaning crew, and an HR department that provides hiring and job placement for the retrained workers. The company is interested in how the support costs can best be assigned to the facilities which should be held responsible. Information about the costs for the support departments and the consumption of that support is provided here. Operating costs incurred by department Cost allocation bases and usage by department There are four parts to this problem. Use Excel to perform the following. (a) Your answer is partially correct. Set up the iterative formulas to compute the costs allocated to each support department using the reciprocal method. (Do not leave any answer field blank. Enter 0 for amounts. Enter negative amounts with either a - sign e.g. 15,000 or in parenthesis e.g. (15,000). Ithacor a new, to the providi best be depart