Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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:

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 Equipments management?

image text in transcribed

image text in transcribed

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{9}{|c|}{ ELLIS EQUIPMENT } \\ \hline \multicolumn{9}{|c|}{ Income Statement } \\ \hline & \multicolumn{2}{|r|}{ EE-1000 } & \multicolumn{2}{|c|}{ EE-1800 } & \multicolumn{2}{|c|}{ EE-2800 } & \multicolumn{2}{|r|}{ Total } \\ \hline Sales revenue & $ & 12,800,000 & $ & 8,000,000 & $ & 3,520,000 & $ & 24,320,000 \\ \hline \multicolumn{9}{|l|}{ Direct costs: } \\ \hline Direct material & & 4,800,000 & & 3,200,000 & & 1,120,000 & & 9,120,000 \\ \hline Direct labor & & 1,680,000 & & 768,000 & & 230,400 & & 2,678,400 \\ \hline \multicolumn{9}{|l|}{ Variable overhead } \\ \hline \multicolumn{9}{|l|}{ Contribution margin } \\ \hline \multicolumn{9}{|l|}{ Fixed overhead: } \\ \hline Plant administration & & & & & & & & 1,430,000 \\ \hline Other fixed overhead & & & & & & & & 3,300,000 \\ \hline Gross profit & & & & & & & $ & 2,900,600 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ ELLIS EQUIPMENT } \\ \hline \multicolumn{6}{|c|}{ Income Statement } \\ \hline & EE-1000 & EE-1800 & EE-2800 & & Total \\ \hline Sales revenue & $12,800,000 & $8,000,000 & $3,520,000 & & 24,320,000 \\ \hline \multicolumn{6}{|l|}{ Direct costs: } \\ \hline Direct material & 4,800,000 & 3,200,000 & 1,120,000 & & 9,120,000 \\ \hline Direct labor & 1,680,000 & 768,000 & 230,400 & & 2,678,400 \\ \hline \multicolumn{6}{|l|}{ Variable overhead: } \\ \hline Setting up & & & & & 1,400,000 \\ \hline Quality testing & & & & & 1,800,000 \\ \hline Painting costs & & & & & 780,000 \\ \hline Operating equipment & & & & & 155,000 \\ \hline Shipping & & & & & 756,000 \\ \hline \multicolumn{6}{|l|}{ Contribution margin } \\ \hline \multicolumn{6}{|l|}{ Fixed overhead: } \\ \hline Plant administration & & & & & 1,430,000 \\ \hline Other fixed overhead & & & & & 3,300,000 \\ \hline Gross profit & & & & $ & 2,900,600 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Complete Guide To Spotting Accounting Fraud And Cover-Ups

Authors: Martha Maeda

1st Edition

160138212X, 978-1601382122

More Books

Students also viewed these Accounting questions

Question

Describe probability/impact risk analysis.

Answered: 1 week ago

Question

What are the outcomes the client wants?

Answered: 1 week ago

Question

What has been done before?

Answered: 1 week ago