Using machine-hours to allocate production overhead, complete the income statement for Ellis Equipment. Follow the controller's recommendation and do not attempt to allocate facility administration or miscellaneous fixed overhead. Complete the income statement using the bases recommended by the controller. How might activity-based costing result in better decisions by Ellis Equipment’s management?

Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter11: Cost-volume-profit Analysis
Section: Chapter Questions
Problem 11.2E: Identify cost graphs The following cost graphs illustrate various types of cost behavior: For each...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Ellis Equipment (EE), manufactures three models of lawn tractor: EE-1000, EE-1800, and EE-2800. Because of the different materials used, production processes for each model differ significantly in terms of machine types and time requirements. Once parts are produced, however, assembly time per unit required for each type of tractor is similar. For this reason, EE allocates overhead on the basis of machine-hours. Last quarter, the company shipped 8,000 EE-1000s, 3,200 EE-1800s, and 800 EE-2800s. The revenues and expenses for the last quarter were as follows:

ELLIS EQUIPMENT
Income Statement
For the Quarter Ended June 30
  EE-1000 EE-1800 EE-2800 Total
Sales revenue $ 12,800,000 $ 8,000,000 $ 3,520,000 $ 24,320,000
Direct costs        
Direct materials 4,800,000 3,200,000 1,120,000 9,120,000
Direct labor 1,680,000 768,000 230,400 2,678,400
Variable overhead        
Setting up machines       1,400,000
Quality testing       1,800,000
Painting       780,000
Operating equipment       155,000
Shipping       756,000
Contribution margin       $ 7,630,600
Fixed overhead        
Facility administration       1,430,000
Miscellaneous fixed overhead       3,300,000
Gross profit       $ 2,900,600

The plant manager asked the plant controller about the possibility of adopting ABC. After consulting with the production supervisors in the plant, the controller recommended the following:

Activity Cost Driver Activity Level
EE-1000 EE-1800 EE-2800
Setting up machines Number of production runs 154 238 308
Quality testing Number of tests 320 200 80
Painting Units shipped 8,000 3,200 800
Operating equipment Machine-hours 5,000 8,000 12,000
Shipping Number of units shipped 8,000 3,200 800

The controller also recommended that facility administration and miscellaneous fixed overhead costs not be applied to products, especially in the initial experiment with ABC.

Required:

  1. Using machine-hours to allocate production overhead, complete the income statement for Ellis Equipment. Follow the controller's recommendation and do not attempt to allocate facility administration or miscellaneous fixed overhead.

  2. Complete the income statement using the bases recommended by the controller.

  3. How might activity-based costing result in better decisions by Ellis Equipment’s management?

Sales revenue
Direct costs:
Direct material
Direct labor
Variable overhead:
Setting up
Quality testing
Painting costs
Operating equipment
Shipping
Contribution margin
Fixed overhead:
Plant administration
Other fixed overhead
Gross profit
ELLIS EQUIPMENT
Income Statement
EE-1000
EE-1800
EE-2800
Total
$ 12,800,000 $8,000,000 $3,520,000 $ 24,320,000
4,800,000
1,680,000
3,200,000
768,000
1,120,000
230,400
9,120,000
2,678,400
1,400,000
1,800,000
780,000
155,000
756,000
1,430,000
3,300,000
$ 2,900,600
Transcribed Image Text:Sales revenue Direct costs: Direct material Direct labor Variable overhead: Setting up Quality testing Painting costs Operating equipment Shipping Contribution margin Fixed overhead: Plant administration Other fixed overhead Gross profit ELLIS EQUIPMENT Income Statement EE-1000 EE-1800 EE-2800 Total $ 12,800,000 $8,000,000 $3,520,000 $ 24,320,000 4,800,000 1,680,000 3,200,000 768,000 1,120,000 230,400 9,120,000 2,678,400 1,400,000 1,800,000 780,000 155,000 756,000 1,430,000 3,300,000 $ 2,900,600
Sales revenue
Direct costs:
Direct material
Direct labor
Variable overhead
Contribution margin
Fixed overhead:
Plant administration
Other fixed overhead
Gross profit
ELLIS EQUIPMENT
Income Statement
EE-1000
EE-1800
Total
$ 12,800,000 $8,000,000 $ 3,520,000 $ 24,320,000
4,800,000
1,680,000
3,200,000
768,000
EE-2800
1,120,000
230,400
9,120,000
2,678,400
$ 6,320,000 $ 4,032,000 $ 2,169,600 $ 12,521,600
$
1,430,000
3,300,000
2,900,600
Transcribed Image Text:Sales revenue Direct costs: Direct material Direct labor Variable overhead Contribution margin Fixed overhead: Plant administration Other fixed overhead Gross profit ELLIS EQUIPMENT Income Statement EE-1000 EE-1800 Total $ 12,800,000 $8,000,000 $ 3,520,000 $ 24,320,000 4,800,000 1,680,000 3,200,000 768,000 EE-2800 1,120,000 230,400 9,120,000 2,678,400 $ 6,320,000 $ 4,032,000 $ 2,169,600 $ 12,521,600 $ 1,430,000 3,300,000 2,900,600
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College