Income Statement in Contribution format
Not what you're looking for?
The company's CEO just returned from a seminar on management accounting and some new tools that can be used to assist in management of the business. One of the new tools she learned about is referred to as contribution format income statements.
It is time for the accounting department to prepare the month-end income statement. In the past, the standard format income statement, as shown below, has been used. But for the first time, the CEO has asked that the contribution format be used instead.
While most of the different expense categories are easy to analyze, the utility expense seems to display characteristics of both variable costs and fixed costs. To help prepare this income statement format, the accounting department collected data from the past 12 months. This data included actual utility costs as compared to each month's business volume. Some of it is shown below.
History of Utility Expenses
Utility Costs Comment
January $10,000 closed the entire month for repairs
February $11,000 produced 5,000 widgets
March $10,600 produced 3,000 widgets
April $11,600 produced 8,000 widgets
Submit 1 Excel file including the following information:
• Even when the plant was shut down for a month, what was the utility expense that month?
• In February, what was the amount of utilities that was fixed, and what portion was variable?
• Based on the rest of the data, what is the variable portion of utility costs per unit in February?
• If June's expected units produced are 9,000, what would the expected utility costs be? Show your calculations.
o Prepare a contribution format income statement:
o use this month's standard formatted income statement below
o use the History of Utility Expenses provided
o show as many calculations as possible
Purchase this Solution
Solution Summary
This solution illustrates how to allocate mixed costs between their fixed and variable elements, how to write a cost formula, and how to prepare a contribution format income statement.
Purchase this Solution
Free BrainMass Quizzes
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Lean your Process
This quiz will help you understand the basic concepts of Lean.