Please show work in excel with formulas shown

PROBLEM 1 (Direct and Reciprocal Methods) Secure R US specializes in the assembly and installation of high-quality security systems for the home and business segmonts of the market. The four departments at its highly automated state-of-the-art assembly plant are as follows: The budgeted level of service relationships at the start of the year was I he actual level of service relationships for the year was Secure R Us collects tixed cnsts and variable costs of cach department in separate cost pools. The actual costs (in thousands) in each pool for the year werc Fixed costs are allocated on the basis of the budgeted level of service. Variable costs are allocated on the basis of the actual level of service. The support department costs allocated to each assembly department are allocated to products on the basis of units assembled. The units assembled in each department during the year were PROBLEM 1 (Direct and Reciprocal Methods) Secure R US specializes in the assembly and installation of high-quality security systems for the home and business segmonts of the market. The four departments at its highly automated state-of-the-art assembly plant are as follows: The budgeted level of service relationships at the start of the year was I he actual level of service relationships for the year was Secure R Us collects tixed cnsts and variable costs of cach department in separate cost pools. The actual costs (in thousands) in each pool for the year werc Fixed costs are allocated on the basis of the budgeted level of service. Variable costs are allocated on the basis of the actual level of service. The support department costs allocated to each assembly department are allocated to products on the basis of units assembled. The units assembled in each department during the year were