+1-415-670-9189
info@expertsmind.com
Use the history of utility expenses provided
Course:- Managerial Accounting
Reference No.:- EM13490656




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Managerial Accounting

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 ascontribution 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.
    • Prepare a contribution format income statement:
    • use this month's standard formatted income statement below
    • use the History of Utility Expenses provided
    • show as many calculations as possible

Standard Format Income Statement


Comment

Sales

100,000



(COGS)

-70,000


30% of these costs are fixed

Gross Profit

30,000




(S,G,A)

-20,000


80% of these costs are fixed


Net Income

10,000



 




Put your comment
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Managerial Accounting) Materials
Oasimi Company, which has only one product, has provided following data concerning its most recent month of operations: Find out the unit product cost for the month under vari
Prepare cost report that lists value-added costs, non-value-added costs, and actual costs for each activity. Which activities are non-value-added? Explain why. Explain why val
Prepare a contribution format income statement and compute the degree of operating leverage.c. If you were a member of top management, would you have been in favor of constr
What qualitative factors (that is, issues with vendors, customers, or within the product itself) should the Ski Pro Corporation consider in determining whether they should m
Prepare, in general journal form, all entries Roesch should have made in its accounting records during August 2008 relating to this lease. Give full explanations and show su
Explain why the cutting department should cut back production from 700 items per hour to 600. Further, explain why if the cutting department does cut back, as it should, it is
Janel Co acquired a building valued at $120,000 for property tax purpose in exchange for$8,000 shares of its 5 par common stock. The stock is selling for $15 per share. At w
You are the manager of an accounting department and would like to hire another managerial accountant to focus on internal accounting. The CEO is not convinced that a managin