What is formula for total cost line and total revenue line

Assignment Help Financial Management

Reference no: EM131487447

This corporation transports products in the western states of the United States. The cooperation has gathered the following costs regarding the freight miles driven by the cooperations trucks as well as the cooperations operating costs.

Operating costs Freight Miles

January 942 1710

February 1008 2655

March 1218 2705

April 1380 4220

May 1484 4660

June 1548 4455

July 1568 4435

August 1972 4990

September 1190 2490

October 1302 2610

November 962 2240

December 772 1490

Assume the company charges a price per mile of $.35.

Please use excel to perform the following

Perform a regression using the regression data analysis tool. As part of your output, Provide a line fit plot. On the graph, superimpose a total revenue line.

2) Basics-

a) What is the formula for the total cost line?

b) What is the formula for the total revenue line?

c) How is the level of total Fixed cost?

d) What is the breakeven point units?

e) What is the breakeven point in dollars?

3) What is the new break even points(units) if total fixed costs increase by $1000?

4) What is the new breakeven point(Units) if the sales price is raised to .40 per mile?

5) If the sales price is raised to .40 per mile, what is the profit(loss) at 1600 Miles?

Reference no: EM131487447

Questions Cloud

Compute the coefficient of variation : Shack Homebuilders Limited is evaluating a new promotional campaign that could increase home sales. Compute the coefficient of variation.

Take advantage of store policies for returns : Are customers that try to take advantage of store policies for returns etc., actually worth keeping loyal in the long run? Why or why not?

What is weighted average cost of capital : The Black Bird Company plans an expansion. If the company is in the 34 percent tax bracket, what is the weighted average cost of capital?

Current portfolio will be sufficient for them to retire : Rachel and Richard want to know when their current portfolio will be sufficient for them to retire.

What is formula for total cost line and total revenue line : This corporation transports products in the western states of the United States. What is the formula for total cost line and total revenue line?

Preferred stock always has the right to vote : Corporate dividends, Preferred stock always has the right to vote, The owner of preferred stock:

What is the required rate of return on the stock : Juggernaut Satellite Corporation earned $23 million for the fiscal year ending yesterday. What is the required rate of return on the stock?

What was variance of the company returns over this period : What was the variance of the company’s returns over this period? The standard deviation?

What is the dividend yield for each of these four stocks : Consider four different stocks, What is the dividend yield for each of these four stocks? What is the expected capital gains yield?

User Account

All Pages