Question

In: Accounting

Records at Hal’s Accounting Services show the following costs for year 1. Direct materials and supplies...

Records at Hal’s Accounting Services show the following costs for year 1.

Direct materials and supplies $ 43,000
Employee costs 2,700,000
Total overhead 1,390,000

Production was 25,000 billable hours. Fixed overhead was $800,000.

Assuming no change in billable hours in year 2, direct materials and supplies costs are expected to increase by 10 percent. Direct labor costs are expected to increase by 15 percent. Variable overhead per billable hour is expected to remain the same, but fixed overhead is expected to increase by 5 percent.


Required:

a. Year 2 production is expected to be 20,000 billable hours. What are the estimated direct materials, direct labor, variable overhead, and fixed overhead costs for year 2?

b. Determine the total costs per billable hour for year 1 and year 2.

Solutions

Expert Solution

Solution :-

a) Calculation of estimated direct materials, direct labor, variable overhead, and fixed overhead costs for year 2 :-

Year 1

Direct materials and supplies = $ 43000

Employee costs ( Direct Labor ) = $ 2700000

Total overhead = $ 1390000

Fixed overhead = $ 800000

Variable Overhead = $ 1390000 - $ 800000 = $ 590000

Variable overhead per billable hour = Variable Overhead / Total Billable Hours

= $ 590000 / 25000 = $ 23.6 per Billable hour

Year 2

Direct materials and supplies costs are expected to increase by 10 percent.

Therefore, Estimated Direct Material Costs = $ 43000 * 110% = $ 47300

Direct labor costs are expected to increase by 15 percent

Therefore, Expected Direct labor Costs = $ 2700000 * 115% = $ 3105000

Variable overhead per billable hour is expected to remain the same.

Variable overhead per billable hour =$ 23.6 per Billable hour

Total Billable hours produced = 20000

Total Variable Overhead = 20000 * 23.60 = $ 472000

Fixed overhead is expected to increase by 5 percent.

Fixed Overhead = $ 800000 * 105% = $ 840000

Year 2

Estimated Direct Material Costs $ 47300
Expected Direct labor Costs $ 3105000
Total Variable Overhead $ 472000
Fixed Overhead $ 840000

b.) Calculation of Total costs per billable hour for Year 1 and Year 2 :-

Particulars Year 1 Year 2
Billable Hours 25000 20000
Estimated Direct Material Costs (A) $ 43000 $ 47300
Expected Direct labor Costs (B) $ 2700000 $ 3105000
Total Variable Overhead (C) $ 590000 $ 472000
Fixed Overhead (D) $ 800000 $ 840000
Total Costs (E = A+B+C+D)   $ 4133000 $ 4464300
Billable Hours Produced (F) 25000 20000
Total costs per billable hour $ 165.32 Per Billable Hour $ 223.22 Per Billable Hour

Related Solutions

Records at Hal’s Accounting Services show the following costs for year 1: Direct materials and supplies...
Records at Hal’s Accounting Services show the following costs for year 1: Direct materials and supplies $ 47,000 Employee costs 2,900,000 Total overhead 1,300,000 Production was 25,000 billable hours. Fixed overhead was $760,000. Assuming no change in billable hours in year 2, direct materials and supplies costs are expected to increase by 10 percent. Direct labor costs are expected to increase by 15 percent. Variable overhead per billable hour is expected to remain the same, but fixed overhead is expected...
The accounting records for Portland Products report the following manufacturing costs for the past year: Direct...
The accounting records for Portland Products report the following manufacturing costs for the past year: Direct materials $ 360,000 Direct labor 266,000 Variable overhead 236,000 Production was 180,000 units. Fixed manufacturing overhead was $838,000. For the coming year, costs are expected to increase as follows: direct materials costs by 20 percent, excluding any effect of volume changes; direct labor by 4 percent; and fixed manufacturing overhead by 10 percent. Variable manufacturing overhead per unit is expected to remain the same....
The accounting records for Portland Products report the following manufacturing costs for the past year: Direct...
The accounting records for Portland Products report the following manufacturing costs for the past year: Direct materials $ 330,000 Direct labor 265,000 Variable overhead 235,000 Production was 190,000 units. Fixed manufacturing overhead was $727,000. For the coming year, costs are expected to increase as follows: direct materials costs by 20 percent, excluding any effect of volume changes; direct labor by 4 percent; and fixed manufacturing overhead by 10 percent. Variable manufacturing overhead per unit is expected to remain the same....
The accounting records for Portland Products report the following manufacturing costs for the past year. Direct...
The accounting records for Portland Products report the following manufacturing costs for the past year. Direct materials $ 310,000 Direct labor 269,000 Variable overhead 233,000 Production was 150,000 units. Fixed manufacturing overhead was $819,000. For the coming year, costs are expected to increase as follows: direct materials costs by 20 percent, excluding any effect of volume changes; direct labor by 4 percent; and fixed manufacturing overhead by 10 percent. Variable manufacturing overhead per unit is expected to remain the same....
The accounting records for Portland Products report the following manufacturing costs for the past year: Direct...
The accounting records for Portland Products report the following manufacturing costs for the past year: Direct materials $ 360,000 Direct labor 268,000 Variable overhead 233,000 Production was 180,000 units. Fixed manufacturing overhead was $843,000. For the coming year, costs are expected to increase as follows: direct materials costs by 20 percent, excluding any effect of volume changes; direct labor by 4 percent; and fixed manufacturing overhead by 10 percent. Variable manufacturing overhead per unit is expected to remain the same....
The following information comes from the accounting records for Chelsea, Inc., for May:      Direct materials...
The following information comes from the accounting records for Chelsea, Inc., for May:      Direct materials inventory, May 1 $ 17,000 Direct materials inventory, May 31 15,200 Work-in-process inventory, May 1 9,500 Work-in-process inventory, May 31 5,300 Finished goods inventory, May 1 54,500 Finished goods inventory, May 31 72,100 Direct materials purchased during May 83,800 Direct labor costs, May 59,300 Manufacturing overhead, May 79,700 Required: a. Compute the total prime costs for the month of May.    b. Compute the...
In the year, TGIT Inc. incurred the following costs: Direct materials $ 4.00 per unit Direct...
In the year, TGIT Inc. incurred the following costs: Direct materials $ 4.00 per unit Direct labour $ 5.00 per unit Variable manufacturing overhead $ 3.00 per unit Fixed manufacturing overhead $ 100,000 Variable selling expenses $ 1.00 per unit Fixed selling expenses $ 40,000 In the year, TGIT produced 40,000 units and sold 42,000 units. The company had no beginning or ending work-in-process inventory. However, there are 5,000 units in beginning finished goods inventory. The 5,000 units produced in...
The following data appeared in Dolphin Corporation’s records on December 31 of last year: Direct materials...
The following data appeared in Dolphin Corporation’s records on December 31 of last year: Direct materials inventory, December 31 $50,000 Direct materials purchased during the year 200,000 Finished goods inventory, December 31 50,000 Indirect labor 20,000 Direct labor 250,000 Accounts payable 75,000 Factory heat, light and power 30,000 Building depreciation (70% is for manufacturing) 50,000 Administrative salaries 30,000 Accounts receivables 65,000 Miscellaneous factory cost 20,000 Net plant and equipment 200,000 Marketing costs 25,000 Maintenance on factory machines 10,000 Insurance (50%...
The accounting records of Marin Inc. show the following data for 2017 (its first year of...
The accounting records of Marin Inc. show the following data for 2017 (its first year of operations). 1. Life insurance expense on officers was $9,500. 2. Equipment was acquired in early January for $307,000. Straight-line depreciation over a 5-year life is used, with no salvage value. For tax purposes, Marin used a 30% rate to calculate depreciation. 3. Interest revenue on State of New York bonds totaled $3,700. 4. Product warranties were estimated to be $50,900 in 2017. Actual repair...
The accounting records of Omar Company contained the following information for last year: Beginning Ending Direct...
The accounting records of Omar Company contained the following information for last year: Beginning Ending Direct materials inventory........................ $9,000 $7,000 Work in process inventory....................... $17,000 $31,000 Finished goods inventory........................ $10,000 $15,000 Manufacturing costs incurred Direct materials used............................... $72,000 Overhead applied..................................... $24,000 Direct labor cost (10,000 hours).............. $80,000 Depreciation............................................. $10,000 Rent......................................................... $12,000 Taxes........................................................ $8,000 Cost of goods sold................................... $157,000* * Selling and administrative costs incurred Advertising.............................................. $35,000 Rent......................................................... $20,000 Clerical..................................................... $25,000 *Does not include over- or underapplied overhead.         1.    The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT