04 Jun PREPARE A CONTRIBUTION FORMAT INCOME STATEMENT
Assignment Type:Individual ProjectDeliverable Length:1 Excel file
Points Possible:125Due Date:5/19/2013 11:59:59 PM CT
APA formatted References Due: 05/08 3:00 a.m.
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
Please submit your assignment.
The following grading criteria will be used:
Grading Guidelines
15% Even when the plant was shut down for a month, what was the utility expense that month?
15% In February, what was the amount of utilities that was fixed, and what portion was variable?
15% Based on the rest of the data, what is the variable portion of utility costs per unit in February?
15% If June’s expected units produced are 9,000, what would the expected utility costs be? Show your calculations.
40% 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
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.