Question

In: Finance

Admin overhead costs are allocated based on each department’s revenues, what is the allocation rate? Engineering...

Admin overhead costs are allocated based on each department’s revenues, what is the allocation rate? Engineering costs are to be allocated based on sq ft, what is the allocation rate? How much of the Admin & Engineer costs would be allocated to cancer & how much to pharmacy? What would be the total profit for cancer and pharmacy?

Cancer

Rev - $700,000

Exp - $250,000

Sq Ft - 2,500

Pharmacy

Rev - $300,000

Exp - $125,000

Sq Ft - 1,000

Overhead Costs

Admin - $40,000

Engineering - $60,000

Solutions

Expert Solution

Admin cost allocation rate = Total Admin costs/ Total Revenue
= 40000/(700,000+300,000)
= $0.04 per $
Engineering cost allocation rate = Total engineering costs/ Total Sft
= 60,000/(2,500+1000)
=$17.143 per Sft
Allocation of overhead cost
Activity Cost Pools Allocation Rate Cancer Pharmacy
Activity Overhead cost allocated Activity Overhead cost allocated
Admin 0.04 per $ 700,000 $ of revenue       28,000 300,000 $ of revenue       12,000
Engineering 17.143 per Sft       2,500 Sft       42,858       1,000 Sft       17,143
Amount of Overhead allocated       70,858        29,143
Cancer Pharmacy
Revenue        700,000      300,000
Expenses        250,000      125,000
Overhead cost
Admin           28,000         12,000
Engineering           42,858         17,143
Total profit        379,143      145,857

Note: Due to round of enginerring cost per sft to 3 decimals, there difference of $1 in engineering costs same can be adjusted from any of the profits.


Related Solutions

The predetermined overhead allocation rate for Lemke, Inc., is based on estimated direct labor costs of...
The predetermined overhead allocation rate for Lemke, Inc., is based on estimated direct labor costs of $250,000 and estimated factory overhead of $550,000. Actual costs incurred were: Direct materials…………………………….. $250,000 Direct labor………………………………….. 300,000 Indirect materials……………………………             155,000 Indirect labor……………………………….. 225,000 Sales commissions…………………………. 50,000 Factory depreciation………………………… 170,000 Property taxes, factory……………………...    115,000 Advertising………………………………..... 62,500 (a)    Calculate the predetermined overhead rate and calculate the overhead applied during the year. (b)   Determine the amount of over- or underapplied overhead and state whether it was under or...
What is over-allocated overhead? and What is under-allocated overhead?
What is over-allocated overhead? and What is under-allocated overhead?
Young's Manufacturing Plant uses a predetermined overhead allocation rate to allocate overhead to individual jobs, based...
Young's Manufacturing Plant uses a predetermined overhead allocation rate to allocate overhead to individual jobs, based on machine hours required. At the beginning of 2018, the company expected to incur the following: Manufacturing overhead costs $840,000 Direct labor costs $1,480,000 Machine hours 70,000 hours At the end of 2018, the company actually incurred: Direct labor costs $1,230,000 Depreciation on manufacturing equipment $620,000 Property taxes on plant $35,500 Sales salaries $26,000 Delivery drivers' wages $22,500 Plant janitor's wages $17,000 Machine hours...
What are the difficulties in determining appropriate cost allocation of a firms overhead costs?
What are the difficulties in determining appropriate cost allocation of a firms overhead costs?
Using Activity based costing, why are indirect costs allocated while direct costs are not allocated?
Using Activity based costing, why are indirect costs allocated while direct costs are not allocated?
CJ’s Motorcycle Store has two service departments: Maintenance and Personnel. The maintenance department’s costs are allocated...
CJ’s Motorcycle Store has two service departments: Maintenance and Personnel. The maintenance department’s costs are allocated on the basis of maintenance hours. The personnel department’s costs are allocated based on the number of employees. CJ has two production departments: Assembly and Repairs. The following data is provided to you for review: Support Departments Production Departments Maintenance Personnel Assembly Repairs Budgeted costs Support Departments Support Departments Production Departments Production Departments Maintenance Personnel Assembly Repairs Budgeted cost $320,000 $80,000 $160,000 $240,000 Budgeted...
Mirabile Corporation uses activity-based costing to compute product margins. Overhead costs have already been allocated to...
Mirabile Corporation uses activity-based costing to compute product margins. Overhead costs have already been allocated to the company's three activity cost pools--Processing, Supervising, and Other. The costs in those activity cost pools appear below:       Processing $ 5,945 Supervising $ 19,680 Other $ 11,300   Processing costs are assigned to products using machine-hours (MHs) and Supervising costs are assigned to products using the number of batches. The costs in the Other activity cost pool are not assigned to...
Mirabile Corporation uses activity-based costing to compute product margins. Overhead costs have already been allocated to...
Mirabile Corporation uses activity-based costing to compute product margins. Overhead costs have already been allocated to the company's three activity cost pools--Processing, Supervising, and Other. The costs in those activity cost pools appear below: Processing $ 5,945 Supervising $ 19,680 Other $ 11,300 Processing costs are assigned to products using machine-hours (MHs) and Supervising costs are assigned to products using the number of batches. The costs in the Other activity cost pool are not assigned to products. Activity data appear...
Mirabile Corporation uses activity-based costing to compute product margins. Overhead costs have already been allocated to...
Mirabile Corporation uses activity-based costing to compute product margins. Overhead costs have already been allocated to the company's three activity cost pools--Processing, Supervising, and Other. The costs in those activity cost pools appear below: Processing $ 5,170 Supervising $ 31,640 Other $ 11,900 Processing costs are assigned to products using machine-hours (MHs) and Supervising costs are assigned to products using the number of batches. The costs in the Other activity cost pool are not assigned to products. Activity data appear...
Mirabile Corporation uses activity-based costing to compute product margins. Overhead costs have already been allocated to...
Mirabile Corporation uses activity-based costing to compute product margins. Overhead costs have already been allocated to the company's three activity cost pools--Processing, Supervising, and Other. The costs in those activity cost pools appear below: Processing $ 4,025 Supervising $ 30,420 Other $ 10,700 Processing costs are assigned to products using machine-hours (MHs) and Supervising costs are assigned to products using the number of batches. The costs in the Other activity cost pool are not assigned to products. Activity data appear...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT