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?

**ELLIS EQUIPMENT**

**Income Statement**

|      | EE-1000      | EE-1800    | EE-2800     | Total        |
|------|--------------|------------|-------------|--------------|
| **Sales revenue**     | $12,800,000 | $8,000,000 | $3,520,000  | $24,320,000 |
| **Direct costs:**     |              |            |             |              |
| Direct material       | 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            |              |            |             | 1,400,000    |
| Quality testing       |              |            |             | 1,800,000    |
| Painting costs        |              |            |             | 780,000      |
| Operating equipment   |              |            |             | 155,000      |
| Shipping              |              |            |             | 756,000      |
| **Contribution margin** |              |            |             |              |
| **Fixed overhead:**   |              |            |             |              |
| Plant administration  |              |            |             | 1,430,000    |
| Other fixed overhead  |              |            |             | 3,300,000    |
| **Gross profit**      |              |            |             | $2,900,600   |

---
The table shows a detailed income statement for Ellis Equipment. It breaks down sales revenue, direct costs, variable overhead, and fixed overhead for three product lines (EE-1000, EE-1800, EE-2800) as well as a total column. The gross profit is calculated at the bottom of the table.
Transcribed Image Text:**ELLIS EQUIPMENT** **Income Statement** | | EE-1000 | EE-1800 | EE-2800 | Total | |------|--------------|------------|-------------|--------------| | **Sales revenue** | $12,800,000 | $8,000,000 | $3,520,000 | $24,320,000 | | **Direct costs:** | | | | | | Direct material | 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 | | | | 1,400,000 | | Quality testing | | | | 1,800,000 | | Painting costs | | | | 780,000 | | Operating equipment | | | | 155,000 | | Shipping | | | | 756,000 | | **Contribution margin** | | | | | | **Fixed overhead:** | | | | | | Plant administration | | | | 1,430,000 | | Other fixed overhead | | | | 3,300,000 | | **Gross profit** | | | | $2,900,600 | --- The table shows a detailed income statement for Ellis Equipment. It breaks down sales revenue, direct costs, variable overhead, and fixed overhead for three product lines (EE-1000, EE-1800, EE-2800) as well as a total column. The gross profit is calculated at the bottom of the table.
**ELLIS EQUIPMENT**

**Income Statement**

|                      | EE-1000       | EE-1800     | EE-2800    | Total         |
|----------------------|---------------|-------------|------------|---------------|
| **Sales revenue**       | $12,800,000   | $8,000,000   | $3,520,000  | $24,320,000   |
| **Direct costs:**       |               |             |            |               |
| - Direct material   | $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**  |               |             |            |               |
| **Contribution margin**| $6,320,000    | $4,032,000  | $2,169,600  | $12,521,600   |
| **Fixed overhead:**    |               |             |            |               |
| - Plant administration|               |             |            | $1,430,000    |
| - Other fixed overhead|               |             |            | $3,300,000    |
| **Gross profit**        |               |             |            | $2,900,600    |

**Explanation:**
- **Sales revenue** is the total income from sales for each product type (EE-1000, EE-1800, EE-2800) as well as the overall total.
- **Direct costs** include expenses directly tied to production, such as materials and labor.
- **Variable overhead** is not detailed for individual products but contributes to the contribution margin.
- **Contribution margin** represents the sales revenue minus direct costs and variable overhead, indicating the amount available to cover fixed overhead and profit.
- **Fixed overhead** includes plant administration and other overhead expenses, which are constant regardless of production volume.
- **Gross profit** is the remaining profit after subtracting fixed overhead from the contribution margin.
Transcribed Image Text:**ELLIS EQUIPMENT** **Income Statement** | | EE-1000 | EE-1800 | EE-2800 | Total | |----------------------|---------------|-------------|------------|---------------| | **Sales revenue** | $12,800,000 | $8,000,000 | $3,520,000 | $24,320,000 | | **Direct costs:** | | | | | | - Direct material | $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** | | | | | | **Contribution margin**| $6,320,000 | $4,032,000 | $2,169,600 | $12,521,600 | | **Fixed overhead:** | | | | | | - Plant administration| | | | $1,430,000 | | - Other fixed overhead| | | | $3,300,000 | | **Gross profit** | | | | $2,900,600 | **Explanation:** - **Sales revenue** is the total income from sales for each product type (EE-1000, EE-1800, EE-2800) as well as the overall total. - **Direct costs** include expenses directly tied to production, such as materials and labor. - **Variable overhead** is not detailed for individual products but contributes to the contribution margin. - **Contribution margin** represents the sales revenue minus direct costs and variable overhead, indicating the amount available to cover fixed overhead and profit. - **Fixed overhead** includes plant administration and other overhead expenses, which are constant regardless of production volume. - **Gross profit** is the remaining profit after subtracting fixed overhead from the contribution margin.
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
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