Question

In: Accounting

The company has two revenue centers: Retail Services and Commercial Services. There are also three service...

The company has two revenue centers: Retail Services and Commercial Services. There are also three service centers: Maintenance, Office Support, and Facility Support. The maintenance center supplies support to all four other centers. The Maintenance area is allocated based on maintenance work orders (Office Support: 10 work orders, Facility Support: 20 work orders, Retail Services: 25 work orders, Commercial Services: 75 work orders). The Office Support is allocated based on hours (Facility Support: 40 hours of Office Support, Retail Services: 50 hours of Office Support, Commercial Services: 200 hours of Office Support). The Facility Support is allocated based on number of customers (Retail Services: 150 customers, Commerical Services: 75 customers). Overhead rates are calculated based on the number of invoices generated (Retail Services: 40,000 invoices, Commercial Services: 10,000 invoices).
Allocate overhead to the two revenue centers based on the direct method, and calculate the departmental overhead rates.
Maintenance Office Support Facility Support Retail Services Commercial Services
Center Costs $300,000 $125,000 $100,000 $75,000 $50,000
Maintenance
Office Support
Facility Support
Total
Overhead Rate
Allocate overhead to the two revenue centers based on the step method, and calculate the departmental overhead rates.
Maintenance Office Support Facility Support Retail Services Commercial Services
Center Costs $300,000 $125,000 $100,000 $75,000 $50,000
Maintenance
Office Support
Facility Support
Total
Overhead Rate

Solutions

Expert Solution

Answer a.
Service Department Cost Allocation Statement
Under Direct Method
Service Revenue
Maintenance Office Support Facility Support Retail Services Commercial Services
Budgeted Overhead Costs                   300,000               125,000               100,000                  75,000                     50,000
Allocation of Maintenace                 (300,000)                  75,000                  225,000
Allocation of Office Support             (125,000)                  25,000                  100,000
Allocation of Facility support             (100,000)                  66,667                     33,333
Total Allocated Costs                               -                             -                             -                  241,667                  408,333
No of Invoices                  40,000                     10,000
Overhead Rate (per Invoice)                       6.04                       40.83
Allocation of Maintenace
Retail Services - $300,000 X 25/100                     75,000
Commercial Services - $300,000 X 75/100                   225,000
Total                   300,000
Allocation of Office Support
Retail Services - $125,000 X 50/250                     25,000
Commercial Services - $125,000 X 200/250                   100,000
Total                   125,000
Allocation of Facility Support
Retail Services - $100,000 X 150/225                     66,667
Commercial Services - $100,000 X 75/225                     33,333
Total                   100,000
Answer a & C.
Support Department Cost Allocation Statement
Under Step Down Method
Service Revenue
Maintenance Office Support Facility Support Retail Services Commercial Services
Budgeted Overhead Costs                   300,000               125,000               100,000                  75,000                     50,000
Allocation of Maintenace                 (300,000)                 23,077                 46,154                  57,692                  173,077
Allocation of Office Support             (148,077)                 20,424                  25,531                  102,122
Allocation of Facility support             (166,578)                111,052                     55,526
Total Allocated Costs                               -                            (0)                            0                269,275                  380,725
No of Invoices            40,000.00               10,000.00
Overhead Rate (per Invoice)                       6.73                       38.07
Allocation of Maintenance:
Work Order Weighted Base Allocated Cost
Office Support                              10 7.69%                 23,077
Facility Support                              20 15.38%                 46,154
Retail Services                              25 19.23%                 57,692
Commercial Services                              75 57.69%               173,077
Total                           130 100.00%               300,000
Allocation of Office Support:
Hours Weighted Base Allocated Cost
Facility Support                              40 13.79%                 20,424
Retail Services                              50 17.24%                 25,531
Commercial Services                           200 68.97%               102,122
Total                           290 100.00%               148,077
Allocation of Facility Support:
No. of Customer   Weighted Base Allocated Cost
Retail Services                           150 66.67%               111,052
Commercial Services                              75 33.33%                 55,526
Total                           225 100.00%               166,578

Related Solutions

The Dylap Corporation has two service centers: IS (information systems) and accounting. The service centers provide...
The Dylap Corporation has two service centers: IS (information systems) and accounting. The service centers provide services to one another as well as to the three operating divisions: Dysap, Dynap and Dycap. The distribution of each service center’s output as well as its costs (in millions) is given as follows:                                         Fraction of Service Center Output Used Dysap Dynap Dycap Total IS Accounting Division Division Division Cost IS 0.15 0.22 0.23 0.15 0.25 $17.3 Accounting 0.04 0.16 0.38 0.27 0.15...
Northern Medical Clinic (NMC) has two service departments – Building Services and Energy. NMC also has...
Northern Medical Clinic (NMC) has two service departments – Building Services and Energy. NMC also has three operating departments – Pediatrics, Geriatrics and Surgery. NMC allocates the Building Services department costs on the basis of square metres and the Energy department costs on the basis of kilowatt hours. Pediatrics applies overhead based on the number of children seen. Geriatrics applies overhead based on the number of seniors seen. Surgery applies overhead based on the number of operations performed. The following...
19) Christina Company has two service departments, Maintenance and Human Resources. Christina Company also has two...
19) Christina Company has two service departments, Maintenance and Human Resources. Christina Company also has two production departments, Mixing and Finishing. Maintenance costs are allocated based on square footage while Human Resources costs are allocated based on number of employees. The following information has been gathered for the current year:                                                                        Human                                          Maintenance         Resources              Mixing          Finishing Direct costs                                $50,400             $33,600              $42,000             $70,000 Square footage                              1,600                   800                 3,200                 2,400 Number of employees                       16                     24                     48                     64 Assume the step-down method is used to allocate service department costs and the Human Resources Department is allocated first. Then the...
a.) Annapolis Company has two service departments (Computer Operations & Maintenance Services). Annapolis has two production...
a.) Annapolis Company has two service departments (Computer Operations & Maintenance Services). Annapolis has two production departments (Mixing Department & Packaging Department.) Annapolis uses a direct allocation method where service departments are allocated only to production departments. All allocations are based on total employees. Computer Operations has costs of $195,000 and Maintenance Services has costs of $130,000 before any allocations. What amount of Maintenance Services total cost is allocated to the Packaging Department? (round to closest whole dollar) Employees are:...
Zachary Trust Corporation has two service departments: actuary and economic analysis. Zachary also has three operating...
Zachary Trust Corporation has two service departments: actuary and economic analysis. Zachary also has three operating departments: annuity, fund management, and employee benefit services. The annual costs of operating the service departments are $668,200 for actuary and $1,002,300 for economic analysis. Zachary uses the direct method to allocate service center costs to operating departments. Other relevant data follow. Operating Costs* Revenue Annuity $ 690,000 $ 681,000 Fund management 1,090,000 1,380,000 Employee benefit services 790,000 1,280,000 *The operating costs are measured...
Annapolis Company has two service departments (Computer Operations & Maintenance Services). Annapolis has two production departments...
Annapolis Company has two service departments (Computer Operations & Maintenance Services). Annapolis has two production departments (Mixing Department & Packaging Department.) Annapolis uses a step allocation method where the Computer Operations Department is allocated to all departments and Maintenance Services is allocated to the production departments.  All allocations are based on total employees. Computer Operations has costs of $160,000 and Maintenance Services has costs of $165,000 before any allocations. What amount of Maintenance Services total cost is allocated to the Mixing...
Annapolis Company has two service departments (Computer Operations & Maintenance Services). Annapolis has two production departments...
Annapolis Company has two service departments (Computer Operations & Maintenance Services). Annapolis has two production departments (Mixing Department & Packaging Department.) Annapolis uses a step allocation method where the Computer Operations Department is allocated to all departments and Maintenance Services is allocated to the production departments. All allocations are based on total employees. Computer Operations has costs of $185,000 and Maintenance Services has costs of $185,000 before any allocations. What amount of Maintenance Services total cost is allocated to the...
Frederick Company has two service departments (Cafeteria Services & Maintenance). Frederick has two production departments (Assembly...
Frederick Company has two service departments (Cafeteria Services & Maintenance). Frederick has two production departments (Assembly Department & Packaging Department.) Frederick uses a step allocation method where Cafeteria Services is allocated to all departments and Maintenance Services is allocated to the production departments. All allocations are based on total employees. Cafeteria Services has costs of $250,000 and Maintenance has costs of $280,000 before any allocations. What amount of Maintenance total cost is allocated to the Packaging Department? (round to closest...
Annapolis Company has two service departments (Computer Operations & Maintenance Services). Annapolis has two production departments...
Annapolis Company has two service departments (Computer Operations & Maintenance Services). Annapolis has two production departments (Mixing Department & Packaging Department.) Annapolis uses a step allocation method where the Computer Operations Department is allocated to all departments and Maintenance Services is allocated to the production departments.  All allocations are based on total employees. Computer Operations has costs of $195,000 and Maintenance Services has costs of $155,000 before any allocations. What amount of Maintenance Services total cost is allocated to the Mixing...
Annapolis Company has two service departments (Computer Operations & Maintenance Services). Annapolis has two production departments...
Annapolis Company has two service departments (Computer Operations & Maintenance Services). Annapolis has two production departments (Mixing Department & Packaging Department.) Annapolis uses a step allocation method where the Computer Operations Department is allocated to all departments and Maintenance Services is allocated to the production departments.  All allocations are based on total employees. Computer Operations has costs of $165,000 and Maintenance Services has costs of $155,000 before any allocations. What amount of Maintenance Services total cost is allocated to the Mixing...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT