Display characteristics of both variable cost and fixed cost

Assignment Help Financial Accounting

Reference no: EM13180058

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.
- 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

Reference no: EM13180058

Questions Cloud

How would the information affect the optimal length : Under the contract, they would ship to you 2,000 titanium bolts per month at a price of $1,000 per bolt. Your assistant has just brought you an article from a trade publication that indicates another company has developed a new technology that red..

How much could the tanker hold when it is full : A tanker that delivers gasoline to gas stations had 1400 gal of gasoline when it was. 7. 8 full. How much could the tanker hold when it is full?

Determine the margin of error if 99% confidence is desired : Explain what assumption the researcher should be willing to make if a margin of error is desired.

Define the production function specified : Using the equation in (c) show that if the capital/labor ratio K/L is a constant k, the elasticity of output with respect to labor is b + c. (e) Why are relationships expressed like those in (c) important for doing econometrics? (f) Show that the ..

Display characteristics of both variable cost and fixed cost : Understand how fixed and variable costs behave and how to use them to predict costs, analyze a mixed cost using the high-low method and prepare an income statement using the contribution format.

Sketch a graph of distance versus time : You are driving to Columbia, SC and due to a traffic jam can only go 30 Mph for the first 20 miles. After that you drive the remaining 90 miles at 60 mph. Sketch a graph of distance versus time and one of speed versus time.

State what is the bubble point temperature : What is the bubble point temperature at 2 atm. What is the dew point at 2 atm. What is the temperature if 50mole % is vapor?

Which salary plan should jim select : Suppose that during the past year the following is Jim's distribution of home sales. If one assumes that this a typical distribution for Jim's monthly sales, which salary plan should Jim select?

Compute the ratios for 2012 and earnings per share : Compute the ratios for 2012 and earnings per share - return on common stockholders' equity

User Account

All Pages