Equivalent Units and Related Costs; Cost of Production Report; Entries
Dover Chemical Company manufactures specialty chemicals by a series of three processes, all materials being introduced in the Distilling Department. From the Distilling Department, the materials pass through the Reaction and Filling departments, emerging as finished chemicals.
The balance in the account Work in Process—Filling was as follows on January 1:
| Work in Process—Filling Department | ||
| (1,900 units, 60% completed): | ||
| Direct materials (1,900 x $10.70) | $20,330 | |
| Conversion (1,900 x 60% x $6.90) | 7,866 | |
| $28,196 | ||
The following costs were charged to Work in Process—Filling during January:
| Direct materials transferred from Reaction | ||
| Department: 24,500 units at $10.50 a unit | $257,250 | |
| Direct labor | 87,660 | |
| Factory overhead | 84,231 | |
During January, 24,300 units of specialty chemicals were completed. Work in Process—Filling Department on January 31 was 2,100 units, 50% completed.
Required:
1. Prepare a cost of production report for the Filling Department for January. If an amount is zero, enter "0". If required, round your cost per equivalent unit answers to two decimal places.
| Dover Chemical Company | |||
| Cost of Production Report-Filling Department | |||
| For the Month Ended January 31 | |||
| Unit Information | |||
| Units charged to production: | |||
| Inventory in process, January 1 | |||
| Received from Reaction Department | |||
| Total units accounted for by the Filling Department | |||
| Units to be assigned costs: | |||
| Equivalent Units | |||
| Whole Units | Direct Materials | Conversion | |
| Inventory in process, January 1 | |||
| Started and completed in January | |||
| Transferred to finished goods in January | |||
| Inventory in process, January 31 | |||
| Total units to be assigned costs | |||
| Cost Information | |||
| Costs per equivalent unit: | |||
| Direct Materials | Conversion | ||
| Total costs for January in Filling Department | $ | $ | |
| Total equivalent units | |||
| Cost per equivalent unit | $ | $ | |
| Costs charged to production: | |||
| Direct Materials | Conversion | Total | |
| Inventory in process, January 1 | $ | ||
| Costs incurred in January | |||
| Total costs accounted for by the Filling Department | $ | ||
| Cost allocated to completed and partially completed units: | |||
| Inventory in process, January 1 balance | $ | ||
| To complete inventory in process, January 1 | $ | $ | |
| Cost of completed January 1 work in process | $ | ||
| Started and completed in January | |||
| Transferred to finished goods in January | $ | ||
| Inventory in process, January 31 | |||
| Total costs assigned by the Filling Department | $ | ||
2. Journalize the entries for (1) costs transferred from Reaction to Filling and (2) the costs transferred from Filling to Finished Goods.
| (1) | |||
| (2) | |||
3. Determine the increase or decrease in the cost per equivalent unit from December to January for direct materials and conversion costs. If required, round your answers to two decimal places.
| Increase or Decrease | Amount | |
| Change in direct materials cost per equivalent unit | $ | |
| Change in conversion cost per equivalent unit |
4. The cost of production report may be used as the basis for allocating product costs between and . The report can also be used to control costs by holding each department head responsible for the units entering production and the costs incurred in the department. Any differences in unit product costs from one month to another, such as those in part (3), can be studied carefully and any significant differences investigated.
Check My Work
In: Accounting
question
please analyze that comparison of the overhead allocation to each service unit under both methods, traditional and Activity-Based Costing (ABC), which method is better for this company?
| DATA FOR TASK B: | ? | ? | ? | ? |
| 2018 BUDGETED DATA FOR THE ADVISORY SERVICE | ? | ? | ? | ? |
| Budgeted billable hours | 5000 | hours of billable work | ? | ? |
| Charge out rate per hour | $210.00 | per billable hour | ? | ? |
| Professional labour | $95.00 | per billable hour | ? | ? |
| Variable overhead | $60,000 | see 'overhead' note below | ? | |
| Fixed overhead | $142,000 | ? | ||
| Overhead costs: Budgeted Variable and Fixed overhead rates are determined by dividing the budgeted (fixed or variable) overhead by the budgeted billable hours. This rate is used to apply overhead to each job as it is performed and eventually billed to the client. | ? | |||
| ? | ||||
| ? | ||||
| ? | ? | ? | ? | ? |
| 2018 ACTUAL COSTS FOR THE ADVISORY SERVICE | ? | ? | ? | ? |
| Actual billable hours | 5900 | ? | ? | ? |
| Charge out rate per hour | $210.00 | per hour | ? | ? |
| Actual professional hours worked | 6000 | ? | ? | ? |
| Actual professional hours paid | $97.00 | per hour | ? | ? |
| Actual variable overhead | $56,000 | ? | ? | ? |
| Actual fixed overheads | $162,000 | ? | ? | ? |
| ? | ? | ? | ? | ? |
| ? | ? | ? | ? | ? |
| ADDITIONAL DATA COLLECTED ON OVERHEAD COSTS FOR ABC CALCULATIONS | ? | ? | ? | ? |
| 2019 Budgeted Overhead costs for T&K Solutions have been assigned to the following activity related cost pools: | ? | ? | ? | ? |
| Overhead Cost Pool: | Budgeted Overhead Costs $ | Cost (activity) driver | Total Expected Activity | |
| Facility related | 96,000 | Floor Space | 380 | sqm |
| Technical Support | 24,000 | # of IT requests | 136 | requests |
| Administrative | 160,000 | Billable hours | 14,130 | billable hours |
| Client Travel | 82,000 | Km's travelled | 2320 | km |
| Advertising | 48,000 | # clients | 200 | clients |
| ? | ? | ? | ? | ? |
| Expected usage by division: | Tax | Bookkeeping | Advisory | ? |
| Billable hours | 5,600 | 1,830 | 6,700 | ? |
| Floor Space | 130 | 55 | 195 | ? |
| # IT requests | 46 | 15 | 75 | ? |
| Km's travelled | 330 | 80 | 1,910 | ? |
| # clients | 73 | 19 | 108 | ? |
| CALCULATIONS FOR SCHEDULE 3: 2019 Budgeted Overhead Calculations | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
| ACTIVITY BASED COSTING ALLOCATION OF OVERHEAD COSTS | ? | ? | ? | ? | Activity by service | Cost per service | ||||
| Activity | Cost | Cost driver | Total cost driver | Cost per cost driver | Tax | Bookkeeping | Advisory | Tax | Bookkeeping | Advisory |
| facility related | $96,000 | floor space | 380 | $252.63 | 130 | 55 | 195 | $32,842.11 | $13,894.74 | $49,263.16 |
| technical support | $24,000 | # of IT request | 136 | $176.47 | 46 | 15 | 75 | $8,117.65 | $2,647.06 | $13,235.29 |
| adminstrative | $160,000 | billiable hours | 14136 | $11.32 | 5,600 | 1,830 | 6,700 | $63,384.27 | $20,713.07 | $75,834.75 |
| client travel | $82,000 | km's travelled | 2320 | $35.34 | 330 | 80 | 1,910 | $11,663.79 | $2,827.59 | $67,508.62 |
| advertising | $48,000 | # clients | 200 | $240.00 | 73 | 19 | 108 | $17,520.00 | $4,560.00 | $25,920.00 |
| ? | ? | ? | ? | ? | ? | ? | Total | $133,527.81 | $44,642.45 | $231,761.82 |
| Total overhead | $410,000 | ? | ? | ? | ? | ? | ? | ? | ? | ? |
| Total Billable hours | 14,130 | ? | ? | ? | ? | ? | ? | ? | ? | ? |
| OH rate= | $29.02 | ? | ? | ? | ? | ? | ? | ? | ? | ? |
| OH COST ADVISORY | $194,409.06 | ? | ? | ? | ? | ? | ? | ? | ? | ? |
| OH Cost Bookkeeping | $53,099.79 | ? | ? | ? | ? | ? | ? | ? | ? | ? |
| OH Cost Tax | $162,491.15 | ? | ? | ? | ? | ? | ? | ? | ? | ? |
| TASK B SCHEDULE 4: | Prepare a comparison of overhead allocation : | ||
| ? | ? | ? | ? |
| Existing OH Allocation | ? | ABC Allocation | ? |
| OH Rate: | ? | OH Rates: | ? |
| Per Billable hour | ? | Per Activity | ? |
| $29.02 | Facility related | $252.63 | |
| ? | ? | Technical Support | $176.47 |
| ? | ? | Administrative | $11.32 |
| ? | ? | Client Travel | $35.34 |
| ? | ? | Advertising | $240.00 |
| OH costs by service (total $) | ? | OH costs by service (total $) | ? |
| Tax | ? | Tax | $133,527.81 |
| Bookkeeping | ? | Bookkeeping | $44,642.45 |
| Advisory | 194,409.09 | Advisory | $231,762 |
In: Accounting
Equivalent Units and Related Costs; Cost of Production Report; Entries
Dover Chemical Company manufactures specialty chemicals by a series of three processes, all materials being introduced in the Distilling Department. From the Distilling Department, the materials pass through the Reaction and Filling departments, emerging as finished chemicals.
The balance in the account Work in Process—Filling was as follows on January 1:
| Work in Process—Filling Department | ||
| (3,000 units, 20% completed): | ||
| Direct materials (3,000 x $13.10) | $39,300 | |
| Conversion (3,000 x 20% x $8.40) | 5,040 | |
| $44,340 | ||
The following costs were charged to Work in Process—Filling during January:
| Direct materials transferred from Reaction | ||
| Department: 38,700 units at $12.80 a unit | $495,360 | |
| Direct labor | 171,580 | |
| Factory overhead | 164,852 | |
During January, 38,400 units of specialty chemicals were completed. Work in Process—Filling Department on January 31 was 3,300 units, 40% completed.
Required:
1. Prepare a cost of production report for the Filling Department for January. If an amount is zero, enter "0". If required, round your cost per equivalent unit answers to two decimal places.
| Dover Chemical Company | |||
| Cost of Production Report-Filling Department | |||
| For the Month Ended January 31 | |||
| Unit Information | |||
| Units charged to production: | |||
| Inventory in process, January 1 | |||
| Received from Reaction Department | |||
| Total units accounted for by the Filling Department | |||
| Units to be assigned costs: | |||
| Equivalent Units | |||
| Whole Units | Direct Materials | Conversion | |
| Inventory in process, January 1 | |||
| Started and completed in January | |||
| Transferred to finished goods in January | |||
| Inventory in process, January 31 | |||
| Total units to be assigned costs | |||
| Cost Information | |||
| Costs per equivalent unit: | |||
| Direct Materials | Conversion | ||
| Total costs for January in Filling Department | $ | $ | |
| Total equivalent units | |||
| Cost per equivalent unit | $ | $ | |
| Costs charged to production: | |||
| Direct Materials | Conversion | Total | |
| Inventory in process, January 1 | $ | ||
| Costs incurred in January | |||
| Total costs accounted for by the Filling Department | $ | ||
| Cost allocated to completed and partially completed units: | |||
| Inventory in process, January 1 balance | $ | ||
| To complete inventory in process, January 1 | $ | $ | |
| Cost of completed January 1 work in process | $ | ||
| Started and completed in January | |||
| Transferred to finished goods in January | $ | ||
| Inventory in process, January 31 | |||
| Total costs assigned by the Filling Department | $ | ||
Feedback
2. Journalize the entries for (1) costs transferred from Reaction to Filling and (2) the costs transferred from Filling to Finished Goods.
| (1) | Work in Process-Filling Department | ||
| Work in Process-Reaction Department | |||
| (2) | Finished Goods | ||
| Work in Process-Filling Department |
Feedback
3. Determine the increase or decrease in the cost per equivalent unit from December to January for direct materials and conversion costs. If required, round your answers to two decimal places.
| Increase or Decrease | Amount | |
| Change in direct materials cost per equivalent unit | Decrease | $ |
| Change in conversion cost per equivalent unit | Increase |
4. The cost of production report may be used as the basis for allocating product costs between Work in Process and Finished Goods . The report can also be used to control costs by holding each department head responsible for the units entering production and the costs incurred in the department. Any differences in unit product costs from one month to another, such as those in part (3), can be studied carefully and any significant differences investigated.
In: Accounting
4A. Consider two rubber companies, Firestone and Goodyear. Both companies create air pollution when they produce rubber. The air pollution can be reduced by the firm, but the abatement comes at a cost. Specifically,
MACF = 800 – 4eF, where eF =
tons of emissions produced by Firestone
MACG = 200 – eG, where eG = tons
of emissions produced by Goodyear
the government wants to use an effluent tax to reduce emissions to 200 tons. What is the optimal number of emissions for Goodyear (firm G) under this policy?
Using the information from question 4A, what is the optimal number of emissions for Firestone (firm F) under this policy?
Given the information from question 4A, what tax level reduces emissions in the most cost-effective way for the firms when they operating at their optimal number of emissions under this policy?
Using the information from question 4A, calculate the total cost (tax cost + abatement cost) for firm F under this effluent tax policy?
Using the information from question 4A, calculate the total cost (tax cost + abatement cost) for firm G under this effluent tax policy
In: Economics
Dotsero Technology, Inc., has a job-order costing system. The company uses predetermined overhead rates in applying manufacturing overhead cost to individual jobs. The predetermined overhead rate in Department A is based on machine-hours, and the rate in Department B is based on direct labor hours. At the beginning of the most recent year, the company's management made the following estimates for the year.
Dept. A Dept. B
Machine-hours. . . . . . . . . . . . . . . 30,000 60,000
Direct labor-hours. . . . . . . . . . . . .70,000 20,000
Manufacturing overhead cost. . . . $420,000 $600,000
Job 243 entered into production on April 1 and was completed on May 12. The company's actual cost records show the following information about the job.
Dept. A Dept. B
Machine-hours. . . . . . . . . . . . . . . . . . . 250 60
Direct labor-hours. . . . . . . . . . . . . . . . 70 120
Direct materials cost. . . . . . . . . . . . . . . $840 $1,100
Direct labor cost. . . . . . . . . . . . . . . . . . $610 $880
Compute the total manufacturing cost of Job 243. Note: “Total manufacturing cost” is the sum of direct materials, direct labor, and applied manufacturing overhead cost in both Department A and Department B.
$11,170
$10,240
$7,100
$5,580
$10,530
$4,950
$7,770
$10,630
In: Accounting
Hannibal Steel Company has a Transport Services Department that provides trucks to haul ore from the company’s mine to its two steel mills—the Northern Plant and the Southern Plant. Budgeted costs for the Transport Services Department total $192,500 per year, consisting of $0.24 per ton variable cost and $142,500 fixed cost. The level of fixed cost is determined by peak-period requirements. During the peak period, the Northern Plant requires 65% of the Transport Services Department’s capacity and the Southern Plant requires 35%. During the year, the Transport Services Department actually hauled 130,000 tons of ore to the Northern Plant and 56,900 tons to the Southern Plant. The Transport Services Department incurred $362,000 in cost during the year, of which $53,200 was variable cost and $308,800 was fixed cost.
Required: 1. How much of the Transport Services Department’s variable costs should be charged to each plant?
2. How much of the $308,800 in fixed cost should be charged to each plant?
3. Should any of the Transport Services Department’s actual total cost of $362,000 be treated as a spending variance and not charged to the plants?
In: Accounting
The controller of Blossom Production has collected the following monthly expense data for analyzing the cost behavior of electricity costs.
| Total Electricity Costs |
Total Machine Hours |
|||||||
| January | $2,660 | 230 | ||||||
| February | 3,050 | 330 | ||||||
| March | 3,520 | 460 | ||||||
| April | 4,770 | 690 | ||||||
| May | 3,190 | 420 | ||||||
| June | 4,960 | 790 | ||||||
| July | 4,030 | 650 | ||||||
| August | 3,870 | 590 | ||||||
| September | 5,040 | 670 | ||||||
| October | 4,270 | 610 | ||||||
| November | 3,260 | 330 | ||||||
| December | 8,460 | 810 | ||||||
(a)
Determine the fixed- and variable-cost components using the
high-low method.
| Fixed-costs | $ | |
| Variable-costs | $ |
eTextbook and Media
(b)
What electricity cost does the cost equation estimate for a level
of activity of 460 machine hours?
| Electricity costs | $ |
By what amount does this differ from March’s observed cost for 460
machine hours?
| Amount differ | $ |
eTextbook and Media
(c)
What electricity cost does the cost equation estimate for a level
of activity of 790 machine hours?
| Electricity costs | $ |
By what amount does this differ from June’s observed cost for 790
machine hours?
| Amount differ | $ |
In: Accounting
CH 11.4 HW
Hannibal Steel Company has a Transport Services Department that provides trucks to haul ore from the company’s mine to its two steel mills—the Northern Plant and the Southern Plant. Budgeted costs for the Transport Services Department total $337,800 per year, consisting of $0.24 per ton variable cost and $287,800 fixed cost. The level of fixed cost is determined by peak-period requirements. During the peak period, the Northern Plant requires 53% of the Transport Services Department’s capacity and the Southern Plant requires 47%.
During the year, the Transport Services Department actually hauled 117,000 tons of ore to the Northern Plant and 57,000 tons to the Southern Plant. The Transport Services Department incurred $360,000 in cost during the year, of which $52,400 was variable cost and $307,600 was fixed cost.
1. How much of the Transport Services Department’s variable costs should be charged to each plant?
2. How much of the $307,600 in fixed cost should be charged to each plant?
3. Should any of the Transport Services Department’s actual total cost of $360,000 be treated as a spending variance and not charged to the plants?
In: Accounting
Off RoadOff Road manufactures auto roof racks in a? two-stage process that includes shaping and plating. Steel alloy is the basic raw material of the shaping process. The steel is moulded according to the design specifications of automobile manufacturers? (Ford and General? Motors). The Plating Department then adds an anodized finish. At March? 31, before recording the transfer of cost from the Plating Department to Finished Goods? Inventory, the Off RoadOff Road general ledger included the following? account:
1. Fill in the time line for the Plating Department.
| start | complete | complete | |
2. Prepare the March production cost report for the Plating Department. Before we can start the production cost report we must first compute the Plating? Department's equivalent units. ?(For entries with a zero? balance, make sure to enter? "0" in the appropriate? cell.)
|
Off Road |
||||
|
Plating Department |
||||
|
Equivalent Unit Computations (Weighted-Average) |
||||
|
Flow of |
Equivalent Units |
|||
|
Physical |
Transferred- |
Direct |
Conversion |
|
|
Flow of Production |
Units |
in |
Materials |
Costs |
|
Units accounted for: |
||||
|
Total equivalent units |
||||
Now we will begin the production cost report by completing the first half of the report. Compute the cost per equivalent unit. ?(For entries with a zero? balance, make sure to enter? "0" in the appropriate? column.)
|
Off Road |
||||
|
Plating Department |
||||
|
Production Cost Report (Weighted-Average) |
||||
|
Transferred- |
Direct |
Conversion |
||
|
in |
Materials |
Costs |
Total |
|
|
Cost per equivalent unit |
||||
Complete the March production cost report by assigning the costs to units completed and transferred out and to ending inventory. ?(Enter quantities? first, then the cost per equivalent unit amounts in the same order as calculated in the preceding step. For entries with a zero? balance, make sure to enter? "0" in the appropriate? cell(s). Round your answers to the nearest whole? dollar.)
???
|
Off Road |
|||||||||||
|
Plating Department |
|||||||||||
|
Production Cost Report (Weighted-Average Method) |
|||||||||||
|
Transferred- |
Direct |
Conversion |
Total |
||||||||
|
in |
Materials |
Costs |
Costs |
||||||||
|
Assignment of total costs: |
|||||||||||||
|
x ( |
+ |
+ |
) |
||||||||||
|
x |
|||||||||||||
|
x |
|||||||||||||
|
x |
|||||||||||||
|
Total cost accounted for |
|||||||||||||
Requirement 3. Journalize all transactions affecting the Plating Department during? March, including the entries that have already been posted.
Record the journal entry for the cost of the units transferred in from the Shaping Department. ?(Record debits? first, then credits. Explanations are not? required.)
|
Journal Entry |
||||
|
Date |
Accounts |
Debit |
Credit |
|
Record the direct? materials, direct? labour, and manufacturing overhead assigned to the Plating Department.
??
|
Journal Entry |
||||
|
Date |
Accounts |
Debit |
Credit |
|
Prepare the journal entry to record the cost of units completed and transferred out.
|
Journal Entry |
||||
|
Date |
Accounts |
Debit |
Credit |
|
| Work in Process Inventory -Plating | |
| March 1 balance | 26,370 |
| Transferred-in from Shaping | 28,800 |
| Direct materials | 28,600 |
| Direct labour | 20,867 |
| Manufacturing overhead | 36,763 |
In: Accounting
|
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 9%. For example, if a hospital buys supplies from Worley that had cost Worley $100 to buy from manufacturers, Worley would charge the hospital $109 to purchase these supplies. |
|
For years, Worley believed that the 9% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits Worley decided to implement an activity-based costing system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities as shown below: |
| Activity Cost Pool (Activity Measure) | Total Cost | Total Activity | |||
| Customer deliveries (Number of deliveries) | $ | 435,000 | 5,000 | deliveries | |
| Manual order processing (Number of manual orders) | 312,000 | 4,000 | orders | ||
| Electronic order processing (Number of electronic orders) | 338,000 | 13,000 | orders | ||
| Line item picking (Number of line items picked) | 967,500 | 430,000 | line items | ||
| Other organization-sustaining costs (None) | 650,000 | ||||
| Total selling and administrative expenses | $ | 2,702,500 | |||
|
Worley gathered the data below for two of the many hospitals that it serves—University and Memorial (both hospitals purchased a total quantity of medical supplies that had cost Worley $36,000 to buy from its manufacturers): |
|
Activity |
||
| Activity Measure | University | Memorial |
| Number of deliveries | 11 | 29 |
| Number of manual orders | 0 | 46 |
| Number of electronic orders | 12 | 0 |
| Number of line items picked | 140 | 260 |
| Required: | |
| 1. |
Compute the total revenue that Worley would receive from University and Memorial. |
| 2. |
Compute the activity rate for each activity cost pool. (Round your answers to 2 decimal places.) |
| 3. |
Compute the total activity costs that would be assigned to University and Memorial. (Round your intermediate calculations and final answers to 2 decimal places.) |
| 4. |
Compute Worley’s customer margin for University and Memorial. (Hint: Do not overlook the $36,000 cost of goods sold that Worley incurred serving each hospital.) (Loss amount should be indicated with a minus sign. Round your intermediate calculations and final answers to 2 decimal places.) |
In: Accounting