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?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education