In: Accounting
Cost allocation is often the centerpiece of conflict that is resolved in court cases. The litigation usually involves the dispute over how costs are allocated to a product or product line that is of interest to the plaintiff. This is particularly an issue when a company produces some products or services for a price-competitive market while other products or services are produced for a governmental unit on a cost-plus or reimbursement basis.
Nursing Care Inc., or NCI, operates both a small nursing home and retirement home. There is a single kitchen used to provide meals to both the nursing home and retirement home, meaning labor costs and utilities costs of the kitchen are shared by the two homes. There is also a centralized cleaning department that provides the cleaning services for both homes as well as the kitchen. The nursing home serves only indigent patients who are on Medicaid. The state Department of Health and Family Services (DHFS) reimburses NCI at Medicaid-approved cost reimbursement rates. The Medicaid reimbursement rates are based on cost information supplied by NCI. The relevant cost and allocation data for the most recent year appear in the following table.
Annual Operating Cost | |||||||||||||||||||
Cleaning department | $ | 102,000 | |||||||||||||||||
Central kitchen | $ | 138,000 | |||||||||||||||||
Allocation Base | Kitchen | Nursing Home | Retirement Home | ||||||||||||||||
Square feet of space | 1,000 | 2,000 | 3,000 | ||||||||||||||||
Number of residents | — | 6 | 4 | ||||||||||||||||
Required:
1. Management of NCI currently allocates the kitchen and cleaning department costs based on the number of residents in each home. Determine the amount of service department costs assigned to each of the homes using this allocation base. (Round percentages to two decimal places in your calculations.)
2. DHFS auditors believe the step method of allocation should be used by first assigning cleaning costs based on square feet and then kitchen costs based on number of residents. Determine the amount of service department costs assigned to each of the homes using this allocation method. (Do not round percentage answers.)
1. Kitchen cost for retirement home = (Central kitchen annual operating cost/ Total number of residents) * number of residents in retirement home
= ($ 138000/ 10) * 4 = $ 55200
% of kitchen cost allocated to retirement home = (Kitchen cost for retirement home / Central kitchen annual operating cost) * 100
= ($ 55200 / $ 138000) * 100
= 40.00 %
Cleaning department cost for retirement home = (Cleaning department annual operating cost/ Total number of residents) * number of residents in retirement home
= ($ 102000/ 10) * 4 = $ 40800
% of cleaning department cost allocated to retirement home = (cleaning department cost for retirement home / cleaning department annual operating cost) * 100
= ($ 40800 / $ 102000) * 100
= 40.00 %
- Amount of service department cost assingned to Retirement home = (Kitchen cost for retirement home + Cleaning department cost for retirement home)
= $ 55200 + $ 40800
= $ 96000
% of service department cost allocated to retirement home = (service department cost for retirement home / (central kitchen annual operating cost + cleaning department annual operating cost)) * 100
= ($ 96000 / ($ 138000 + $ 102000)) * 100
= 40.00 %
Kitchen cost for Nursing home = (Central kitchen annual operating cost/ Total number of residents) * number of residents in nursing home
= ($ 138000/ 10) * 6 = $ 82800
% of kitchen cost allocated to nursing home = (Kitchen cost for nursing home / Central kitchen annual operating cost) * 100
= ($ 82800 / $ 138000) * 100
= 60.00 %
Cleaning department cost for nursing home = (Cleaning department annual operating cost/ Total number of residents) * number of residents in nursing home
= ($ 102000/ 10) * 6 = $ 61200
% of cleaning department cost allocated to nursing home = (cleaning department cost for nursing home / cleaning department annual operating cost) * 100
= ($ 61200 / $ 102000) * 100
= 60.00 %
- Amount of service department cost assingned to Nursing home = (Kitchen cost for nursing home + Cleaning department cost for nursing home)
= $ 82800 + $ 61200
= $ 144000
% of service department cost allocated to nursing home = (service department cost for nursing home / (central kitchen annual operating cost + cleaning department annual operating cost)) * 100
= ($ 144000 / ($ 138000 + $ 102000)) * 100
= 60.00 %
2. Kitchen cost for retirement home = (Central kitchen annual operating cost/ Total number of residents) * number of residents in retirement home
= ($ 138000/ 10) * 4 = $ 55200
% of kitchen cost allocated to retirement home = (Kitchen cost for retirement home / Central kitchen annual operating cost) * 100
= ($ 55200 / $ 138000) * 100
= 40.00 %
Cleaning department cost for retirement home = (Cleaning department annual operating cost/ (Total square feet of space) * (space of retirement home + proportion of space of kitchen for retirement home)) = ($ 102000/ (1000 + 2000 + 3000)) * (3000 + 400) = $ 57800
% of cleaning department cost allocated to retirement home = (cleaning department cost for retirement home / cleaning department annual operating cost) * 100
= ($ 57800 / $ 102000) * 100
= 56.6667 %
- Amount of service department cost assingned to Retirement home = (Kitchen cost for retirement home + Cleaning department cost for retirement home)
= $ 55200 + $ 57800
= $ 113000
% of service department cost allocated to retirement home = (service department cost for retirement home / (central kitchen annual operating cost + cleaning department annual operating cost)) * 100
= ($ 113000 / ($ 138000 + $ 102000)) * 100
= 47.0833 %
Kitchen cost for Nursing home = (Central kitchen annual operating cost/ Total number of residents) * number of residents in nursing home
= ($ 138000/ 10) * 6 = $ 82800
% of kitchen cost allocated to nursing home = (Kitchen cost for nursing home / Central kitchen annual operating cost) * 100
= ($ 82800 / $ 138000) * 100
= 60.00 %
Cleaning department cost for nursing home = (Cleaning department annual operating cost/ (Total square feet of space) * (space of nursing home + proportion of space of kitchen for nursing home)) = ($ 102000/ (1000 + 2000 + 3000)) * (2000 + 600) = $ 44200
% of cleaning department cost allocated to nursing home = (cleaning department cost for nursing home / cleaning department annual operating cost) * 100
= ($ 44200 / $ 102000) * 100
= 43.3333 %
- Amount of service department cost assingned to Nursing home = (Kitchen cost for nursing home + Cleaning department cost for nursing home)
= $ 82800 + $ 44200
= $ 127000
% of service department cost allocated to nursing home = (service department cost for nursing home / (central kitchen annual operating cost + cleaning department annual operating cost)) * 100
= ($ 127000 / ($ 138000 + $ 102000)) * 100
= 52.9167 %
Working Note : i) proportion of space of kitchen allocated to retirement home = (Total space for kitchen / Total residents) * residents in retirement home
= (1000 / 10) * 4
= 400 square feet
ii) proportion of space of kitchen allocated to nursing home = (Total space for kitchen / Total residents) * residents in nursing home
= (1000 / 10) * 6
= 600 square feet