This corporation transports products in the western states, Ask an Expert

Finance

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?

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92296182

Have any Question?Write your Review or question?

Related Questions in Financial Management

Financial management assignment - estimation of cost of

Financial Management Assignment - Estimation of Cost of Capital 1. Introduction - In this section you are supposed to introduce the topic of the assignment; the cost of capital-the concept, its importance, various forms ...

Topic dash dietthere are many different diets weight loss

Topic: DASH DIET There are many different diets, weight loss treatments, and medications that proclaim to be the panacea for weight loss. For this discussion forum, you will be researching a diet or treatment approach fo ...

Rsearch paper issue identificationidentify your issue

Research Paper : Issue Identification Identify your issue: Clearly define the issue(s) and or crisis the company is facing. Identify the "triggering event:" This is a recent occurrence (or series of occurrences) that bro ...

Assignment objectives amp requirements1 to create a new

Assignment Objectives & Requirements: 1. To create a new E-commerce business, which is located in the Kingdom of Saudi Arabia, which include the followings: a. Introduction about your business. b. Product and type of ser ...

Question spirituality is a fundamental and universal

Question : Spirituality is a fundamental and universal aspect of human existence and is a critical component in working with clients, groups, communities, etc. There is a vast diversity in spiritual beliefs and religious ...

Corporate financial management questions -part a -q1 200

Corporate Financial Management Questions - Part A - Q1. $200 invested today and earning 8 per cent per annum compounded semi-annually will grow to what amount at the end of three years? (A) $158.80 (B) $251.94 (C) $380.7 ...

Introductionthroughout this course the focus has been on

Introduction Throughout this course, the focus has been on the problem-solving model and learning how to complete the steps. In addition, you learned how to utilize analysis tools to help you with some of the problem-sol ...

The following examination is due no later than 9 am monday

The following examination is due no later than 9 AM Monday, October 22nd. You are to email me the exam in an XLSX file named after yourself and containing your section. For example, if your name is Leslie King, the file ...

Company x is an american manufacturing company getting

Company X is an American manufacturing company getting ready to start selling its products in Mexico. You are the manager of a team tasked with assessing the potential risks to the company as it gets ready to expand to a ...

Special project -text book spreadsheet modeling for

Special project -text book: Spreadsheet modeling for business decisions - 2, 3 or 4th edition 1. A selected Forecast Model showed the lowest MAD at the beginning of the year with $60.5. If the following three quarters re ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert