Question: i have the solution but I need it with formulas Overhead assigned to each cost pool Cost pools Wages & Salaries Machine Maintance Material handling




i have the solution but I need it with formulas
| Overhead assigned to each cost pool | |||||
| Cost pools | Wages & Salaries | Machine Maintance | Material handling | R & D | Factory Utility |
| Overhead Costs |
|
|
|
|
|
| A | 449920 |
| 393680 |
| 562400 |
| B |
| 595500 | 119100 | 79400 |
|
| C | 1083600 |
|
| 1496400 |
|
| D | 74460 |
| 144540 |
| 219000 |
| E |
| 194875 | 194875 |
| 389750 |
| F |
|
|
| 1400000 |
|
| G | 74880 | 93600 | 39520 |
|
|
| Total | 1682860 | 883975 | 891715 | 2975800 | 1171150 |
| Cost driver | 157000 | 69000 | 11000 | 22880 | 525000 |
| Cost pool rate | 10.71885 | 12.8112 | 81.065 | 130.6012 | 2.3076 |
|
| per direct labor hr | per machine hr | per production period | per R & D time | per gallon |
| Overhead assigned to each cost pool | |||||
| Cost pools | Wages & Salaries | Machine Maintance | Material handling | R & D | Factory Utility |
| Overhead Costs |
|
|
|
|
|
| A | 449920 |
| 393680 |
| 562400 |
| B |
| 595500 | 119100 | 79400 |
|
| C | 1083600 |
|
| 1496400 |
|
| D | 74460 |
| 144540 |
| 219000 |
| E |
| 194875 | 194875 |
| 389750 |
| F |
|
|
| 1400000 |
|
| G | 74880 | 93600 | 39520 |
|
|
| Total | 1682860 | 883975 | 891715 | 2975800 | 1171150 |
| Cost driver | 157000 | 69000 | 11000 | 22880 | 525000 |
| Cost pool rate | 10.71885 | 12.8112 | 81.065 | 130.6012 | 2.3076 |
|
| per direct labor hr | per machine hr | per production period | per R & D time | per gallon |
| Allocated overhead for each product line | |||
| Overhead Allocated | Primeshield | Plantguard | Fullfix |
| Wages & Salaries | 807772 | 572172 | 302915 |
| Machine Maintance | 406628 | 327071 | 150276 |
| Material handling | 445857 | 294266 | 151591 |
| R & D | 1339110 | 1071314 | 565376 |
| Factory Utility | 221519 | 327922 | 620709 |
|
|
|
|
|
| Total Overhead Allocated | 3220886 | 2592745 | 1790869 |
| Cost per unit for each product line | |||
|
| Primeshield | Plantguard | Fullfix |
| Direct Material cost per unit | 72 | 40 | 16 |
| Direct labor cost per unit | 65 | 52 | 27 |
| allocated overhead per unit | 32.29 | 17.64 | 6.44 |
| Total Cost per unit | 169.29 | 109.64 | 49.44 |
i have the solution but I need it with formulas
RHC Chemical Company makes three types of herbicide: PrimeShield, PlantGuard, and FullFix. There are quality and cost differences among the three products. The company is concerned about the cost associated with PrimeShield. While they know the direct material and direct labor costs, they think that allocating all of their overhead using one cost driver may be a problem. They have asked you to determine the cost per unit of each of their products under two separate assumptions: 1. overhead is allocated based on gallons 2. overhead is allocated based on Activity Based Costing techniques. Information related to their products and costs is as follows: Required: Single Cost Driver 1) Calculate an allocation rate for the total overhead using gallons as the single cost driver. Determine the total overhead to be allocated to each product line. Determine the cost per unit of each product, allocating overhead using gallons. ABC 2) Calculate the overhead assigned to each ABC cost pool, and calculate a rate for each cost pool using the designated cost driver. Determine the total overhead to be allocated to each product line using ABC techniques (the use of separate cost drivers for each cost pool). Determine the cost per unit of each product using ABC. Allocation rate combining all overhead using gallons as the cost driver Total overhead Total gallons Overhead rate per gallon Overhead to be allocated to each product line: Cost per unit for each product line: Allocation of overhead using ABC Overhead assigned to each cost pool: Cost per unit for each product line: \begin{tabular}{|l|l|l|l|} \hline & PrimeShield & PlantGuard & FullFix \\ \hline Direct material cost per unit & & & \\ \hline Direct labor cost per unit & & & \\ \hline Allocated overhead per unit & & & \\ \hline Total cost per unit & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
