Variable costs and Fixed costs: Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc. Least square regression method: The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx Where Y is Total cost A is the total fixed cost B is the variable cost X is the activity level To prepare: a scatter plot graph.

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 2A, Problem 2A.2E

1.

To determine

Introduction:

Variable costs and Fixed costs:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To prepare: a scatter plot graph.

1.

Expert Solution

Answer to Problem 2A.2E

This is the scatterplot graph for the B rental car.

MANAG ACCT F/MGRS-CONNECT+PROCTORIO PLUS, Chapter 2A, Problem 2A.2E

Explanation of Solution

According to the given information the rental returns and car wash costs of B rental cars have been given and we have to prepare a scatter graph plot where the car wash cost should be on the vertical axis and the rental returns on the horizontal axis. To prepare the scatter graph first we have to go to insert option and select scatter graph from charts. The next step is to enter the X values and Y values and then we will get the graph. Now we can add trend line and axis title by clicking on the + symbol next to the graph. After adding the trend line we can click on the arrow button next to the trend line and select more options and then in that we have to checkmark display equation and display R squared value on the chart. The following is the data for plotting the graph:

Rental returns	Car wash costs ($)
2380	10825
2421	11865
2586	11332
2725	12422
2968	13850
3281	14419
3353	14935
3489	15738
3057	13563
2876	11889
2735	12683
2983	13796

2.

To determine

Introduction:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To calculate: the variable cost per rental return and the monthly fixed washing cars using least square regression method.

2.

Expert Solution

Answer to Problem 2A.2E

Thus, the variable cost per unit is $4.04 and the fixed cost per unit is $145583 for Bargain rental car.

Explanation of Solution

To calculate the variable cost per rental return and the monthly fixed washing cars using the least square regression method first we have to calculate the X, Y, X² and XY. In the given data the rental return is taken as X and car wash costs is taken as Y, let us now calculate the X² and XY:

Months	X	Y	X²	XY
January	2380	10825	5664400	25763500
February	2421	11865	5861241	28725165
March	2586	11332	6687396	29304552
April	2725	12422	7425625	33849950
May	2968	13850	8809024	41106800
June	3281	14419	10764961	47308739
July	3353	14935	11242609	50077055
August	3489	15738	12173121	54909882
September	3057	13563	9345249	41462091
October	2876	11889	8271376	34192764
November	2735	12683	7480225	34688005
December	2983	13796	8898289	41153468
Total	34854	157317	102623516	462541971

Now let us calculate the variable cost using following formula:

Variable cost per unit

= ( n∑XY − ∑X×∑Y ) (n∑ X 2 − (∑X) 2 ) = ( 12×462541971 –( 34854×157317 ) ) ( 12×102623516 – ( 34854 ) 2 ) = (5550503652−5483126718 (1231482192−1214801316= 67376934 / 16680876 = $4.04

Now, let us calculate the fixed cost per unit using following formula:

Fixed cost per unit

= ∑Y – ( variable cost per unit× ∑X ) n = 157317−( 4.04×34854 ) 12 = 157317 – 11734.18 = $145583

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

Required information Exercise 5A-2 (Algo) Least-Squares Regression [LO5-11] [The following information applies to the questions displayed below.] Bargain Rental Car wants to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility that cleans each rental car before releasing it to another customer. Management believes the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Month January February March April May June July August September October November December Rental Returns 2,400 2,500 2,800 3,100 3,700 5,100 5,600 5,600 4,700 4,100 2,200 2,900 Exercise 5A-2 Part 2 (Algo) Car Wash Costs. $ 11,300 $ 13,300 $ 12,100 $ 14,700 $ 16,500 $ 23,900 $ 22,500 $ 22,900 $ 23,100 $ 22,000 $ 11,000 $ 15,300 2. Using least-squares regression, estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. Note: Round…

Required information Exercise 5A-2 (Algo) Least-Squares Regression [LO5-11] Skip to question [The following information applies to the questions displayed below.] Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Month Rental Returns Car Wash Costs January 2,400 $ 11,000 February 2,500 $ 13,100 March 2,700 $ 11,800 April 3,000 $ 14,300 May 3,600 $ 16,200 June 5,000 $ 23,300 July 5,500 $ 22,200 August 5,500 $ 22,200 September 4,700 $ 22,800 October 4,000 $ 21,100…

Required information Exercise 5A-2 (Algo) Least-Squares Regression [LO5-11] [The following information applies to the questions displayed below.] Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another. customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Month January February March April May June July August September October November December Rental Returns 2,400 2,500 2,800 3,100 Fixed cost per month Variable cost per rental return i 3,700 5,100 5,600 5,600 4,800 4,100. 2,200 3,000. Car Wash Costs $ 11,400 $ 13,300 $ 12,200 $ 14,900 $ 16,600 $ 24,100 $…

Answer 2

Question

Chapter 2A, Problem 2A.2E

1.

To determine

Introduction:

Variable costs and Fixed costs:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To prepare: a scatter plot graph.

1.

Expert Solution

Answer to Problem 2A.2E

This is the scatterplot graph for the B rental car.

MANAG ACCT F/MGRS-CONNECT+PROCTORIO PLUS, Chapter 2A, Problem 2A.2E

Explanation of Solution

According to the given information the rental returns and car wash costs of B rental cars have been given and we have to prepare a scatter graph plot where the car wash cost should be on the vertical axis and the rental returns on the horizontal axis. To prepare the scatter graph first we have to go to insert option and select scatter graph from charts. The next step is to enter the X values and Y values and then we will get the graph. Now we can add trend line and axis title by clicking on the + symbol next to the graph. After adding the trend line we can click on the arrow button next to the trend line and select more options and then in that we have to checkmark display equation and display R squared value on the chart. The following is the data for plotting the graph:

Rental returns	Car wash costs ($)
2380	10825
2421	11865
2586	11332
2725	12422
2968	13850
3281	14419
3353	14935
3489	15738
3057	13563
2876	11889
2735	12683
2983	13796

2.

To determine

Introduction:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To calculate: the variable cost per rental return and the monthly fixed washing cars using least square regression method.

2.

Expert Solution

Answer to Problem 2A.2E

Thus, the variable cost per unit is $4.04 and the fixed cost per unit is $145583 for Bargain rental car.

Explanation of Solution

To calculate the variable cost per rental return and the monthly fixed washing cars using the least square regression method first we have to calculate the X, Y, X² and XY. In the given data the rental return is taken as X and car wash costs is taken as Y, let us now calculate the X² and XY:

Months	X	Y	X²	XY
January	2380	10825	5664400	25763500
February	2421	11865	5861241	28725165
March	2586	11332	6687396	29304552
April	2725	12422	7425625	33849950
May	2968	13850	8809024	41106800
June	3281	14419	10764961	47308739
July	3353	14935	11242609	50077055
August	3489	15738	12173121	54909882
September	3057	13563	9345249	41462091
October	2876	11889	8271376	34192764
November	2735	12683	7480225	34688005
December	2983	13796	8898289	41153468
Total	34854	157317	102623516	462541971

Now let us calculate the variable cost using following formula:

Variable cost per unit

= ( n∑XY − ∑X×∑Y ) (n∑ X 2 − (∑X) 2 ) = ( 12×462541971 –( 34854×157317 ) ) ( 12×102623516 – ( 34854 ) 2 ) = (5550503652−5483126718 (1231482192−1214801316= 67376934 / 16680876 = $4.04

Now, let us calculate the fixed cost per unit using following formula:

Fixed cost per unit

= ∑Y – ( variable cost per unit× ∑X ) n = 157317−( 4.04×34854 ) 12 = 157317 – 11734.18 = $145583

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Question

Chapter 2A, Problem 2A.2E

1.

To determine

Introduction:

Variable costs and Fixed costs:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To prepare: a scatter plot graph.

1.

Expert Solution

Answer to Problem 2A.2E

This is the scatterplot graph for the B rental car.

MANAG ACCT F/MGRS-CONNECT+PROCTORIO PLUS, Chapter 2A, Problem 2A.2E

Explanation of Solution

According to the given information the rental returns and car wash costs of B rental cars have been given and we have to prepare a scatter graph plot where the car wash cost should be on the vertical axis and the rental returns on the horizontal axis. To prepare the scatter graph first we have to go to insert option and select scatter graph from charts. The next step is to enter the X values and Y values and then we will get the graph. Now we can add trend line and axis title by clicking on the + symbol next to the graph. After adding the trend line we can click on the arrow button next to the trend line and select more options and then in that we have to checkmark display equation and display R squared value on the chart. The following is the data for plotting the graph:

Rental returns	Car wash costs ($)
2380	10825
2421	11865
2586	11332
2725	12422
2968	13850
3281	14419
3353	14935
3489	15738
3057	13563
2876	11889
2735	12683
2983	13796

2.

To determine

Introduction:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To calculate: the variable cost per rental return and the monthly fixed washing cars using least square regression method.

2.

Expert Solution

Answer to Problem 2A.2E

Thus, the variable cost per unit is $4.04 and the fixed cost per unit is $145583 for Bargain rental car.

Explanation of Solution

To calculate the variable cost per rental return and the monthly fixed washing cars using the least square regression method first we have to calculate the X, Y, X² and XY. In the given data the rental return is taken as X and car wash costs is taken as Y, let us now calculate the X² and XY:

Months	X	Y	X²	XY
January	2380	10825	5664400	25763500
February	2421	11865	5861241	28725165
March	2586	11332	6687396	29304552
April	2725	12422	7425625	33849950
May	2968	13850	8809024	41106800
June	3281	14419	10764961	47308739
July	3353	14935	11242609	50077055
August	3489	15738	12173121	54909882
September	3057	13563	9345249	41462091
October	2876	11889	8271376	34192764
November	2735	12683	7480225	34688005
December	2983	13796	8898289	41153468
Total	34854	157317	102623516	462541971

Now let us calculate the variable cost using following formula:

Variable cost per unit

= ( n∑XY − ∑X×∑Y ) (n∑ X 2 − (∑X) 2 ) = ( 12×462541971 –( 34854×157317 ) ) ( 12×102623516 – ( 34854 ) 2 ) = (5550503652−5483126718 (1231482192−1214801316= 67376934 / 16680876 = $4.04

Now, let us calculate the fixed cost per unit using following formula:

Fixed cost per unit

= ∑Y – ( variable cost per unit× ∑X ) n = 157317−( 4.04×34854 ) 12 = 157317 – 11734.18 = $145583

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Question

Chapter 2A, Problem 2A.2E

1.

To determine

Introduction:

Variable costs and Fixed costs:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To prepare: a scatter plot graph.

1.

Expert Solution

Answer to Problem 2A.2E

This is the scatterplot graph for the B rental car.

MANAG ACCT F/MGRS-CONNECT+PROCTORIO PLUS, Chapter 2A, Problem 2A.2E

Explanation of Solution

According to the given information the rental returns and car wash costs of B rental cars have been given and we have to prepare a scatter graph plot where the car wash cost should be on the vertical axis and the rental returns on the horizontal axis. To prepare the scatter graph first we have to go to insert option and select scatter graph from charts. The next step is to enter the X values and Y values and then we will get the graph. Now we can add trend line and axis title by clicking on the + symbol next to the graph. After adding the trend line we can click on the arrow button next to the trend line and select more options and then in that we have to checkmark display equation and display R squared value on the chart. The following is the data for plotting the graph:

Rental returns	Car wash costs ($)
2380	10825
2421	11865
2586	11332
2725	12422
2968	13850
3281	14419
3353	14935
3489	15738
3057	13563
2876	11889
2735	12683
2983	13796

2.

To determine

Introduction:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To calculate: the variable cost per rental return and the monthly fixed washing cars using least square regression method.

2.

Expert Solution

Answer to Problem 2A.2E

Thus, the variable cost per unit is $4.04 and the fixed cost per unit is $145583 for Bargain rental car.

Explanation of Solution

To calculate the variable cost per rental return and the monthly fixed washing cars using the least square regression method first we have to calculate the X, Y, X² and XY. In the given data the rental return is taken as X and car wash costs is taken as Y, let us now calculate the X² and XY:

Months	X	Y	X²	XY
January	2380	10825	5664400	25763500
February	2421	11865	5861241	28725165
March	2586	11332	6687396	29304552
April	2725	12422	7425625	33849950
May	2968	13850	8809024	41106800
June	3281	14419	10764961	47308739
July	3353	14935	11242609	50077055
August	3489	15738	12173121	54909882
September	3057	13563	9345249	41462091
October	2876	11889	8271376	34192764
November	2735	12683	7480225	34688005
December	2983	13796	8898289	41153468
Total	34854	157317	102623516	462541971

Now let us calculate the variable cost using following formula:

Variable cost per unit

= ( n∑XY − ∑X×∑Y ) (n∑ X 2 − (∑X) 2 ) = ( 12×462541971 –( 34854×157317 ) ) ( 12×102623516 – ( 34854 ) 2 ) = (5550503652−5483126718 (1231482192−1214801316= 67376934 / 16680876 = $4.04

Now, let us calculate the fixed cost per unit using following formula:

Fixed cost per unit

= ∑Y – ( variable cost per unit× ∑X ) n = 157317−( 4.04×34854 ) 12 = 157317 – 11734.18 = $145583

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Chapter 2A, Problem 2A.2E

1.

To determine

Introduction:

Variable costs and Fixed costs:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To prepare: a scatter plot graph.

1.

Expert Solution

Answer to Problem 2A.2E

This is the scatterplot graph for the B rental car.

MANAG ACCT F/MGRS-CONNECT+PROCTORIO PLUS, Chapter 2A, Problem 2A.2E

Explanation of Solution

According to the given information the rental returns and car wash costs of B rental cars have been given and we have to prepare a scatter graph plot where the car wash cost should be on the vertical axis and the rental returns on the horizontal axis. To prepare the scatter graph first we have to go to insert option and select scatter graph from charts. The next step is to enter the X values and Y values and then we will get the graph. Now we can add trend line and axis title by clicking on the + symbol next to the graph. After adding the trend line we can click on the arrow button next to the trend line and select more options and then in that we have to checkmark display equation and display R squared value on the chart. The following is the data for plotting the graph:

Rental returns	Car wash costs ($)
2380	10825
2421	11865
2586	11332
2725	12422
2968	13850
3281	14419
3353	14935
3489	15738
3057	13563
2876	11889
2735	12683
2983	13796

2.

To determine

Introduction:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To calculate: the variable cost per rental return and the monthly fixed washing cars using least square regression method.

2.

Expert Solution

Answer to Problem 2A.2E

Thus, the variable cost per unit is $4.04 and the fixed cost per unit is $145583 for Bargain rental car.

Explanation of Solution

To calculate the variable cost per rental return and the monthly fixed washing cars using the least square regression method first we have to calculate the X, Y, X² and XY. In the given data the rental return is taken as X and car wash costs is taken as Y, let us now calculate the X² and XY:

Months	X	Y	X²	XY
January	2380	10825	5664400	25763500
February	2421	11865	5861241	28725165
March	2586	11332	6687396	29304552
April	2725	12422	7425625	33849950
May	2968	13850	8809024	41106800
June	3281	14419	10764961	47308739
July	3353	14935	11242609	50077055
August	3489	15738	12173121	54909882
September	3057	13563	9345249	41462091
October	2876	11889	8271376	34192764
November	2735	12683	7480225	34688005
December	2983	13796	8898289	41153468
Total	34854	157317	102623516	462541971

Now let us calculate the variable cost using following formula:

Variable cost per unit

= ( n∑XY − ∑X×∑Y ) (n∑ X 2 − (∑X) 2 ) = ( 12×462541971 –( 34854×157317 ) ) ( 12×102623516 – ( 34854 ) 2 ) = (5550503652−5483126718 (1231482192−1214801316= 67376934 / 16680876 = $4.04

Now, let us calculate the fixed cost per unit using following formula:

Fixed cost per unit

= ∑Y – ( variable cost per unit× ∑X ) n = 157317−( 4.04×34854 ) 12 = 157317 – 11734.18 = $145583

Answer 6

Chapter 2A, Problem 2A.2E

1.

To determine

Introduction:

Variable costs and Fixed costs:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To prepare: a scatter plot graph.

1.

Expert Solution

Answer to Problem 2A.2E

This is the scatterplot graph for the B rental car.

MANAG ACCT F/MGRS-CONNECT+PROCTORIO PLUS, Chapter 2A, Problem 2A.2E

Explanation of Solution

According to the given information the rental returns and car wash costs of B rental cars have been given and we have to prepare a scatter graph plot where the car wash cost should be on the vertical axis and the rental returns on the horizontal axis. To prepare the scatter graph first we have to go to insert option and select scatter graph from charts. The next step is to enter the X values and Y values and then we will get the graph. Now we can add trend line and axis title by clicking on the + symbol next to the graph. After adding the trend line we can click on the arrow button next to the trend line and select more options and then in that we have to checkmark display equation and display R squared value on the chart. The following is the data for plotting the graph:

Rental returns	Car wash costs ($)
2380	10825
2421	11865
2586	11332
2725	12422
2968	13850
3281	14419
3353	14935
3489	15738
3057	13563
2876	11889
2735	12683
2983	13796

Answer 7

Chapter 2A, Problem 2A.2E

1.

To determine

Introduction:

Variable costs and Fixed costs:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To prepare: a scatter plot graph.

Answer 8

1.

Expert Solution

Answer to Problem 2A.2E

This is the scatterplot graph for the B rental car.

MANAG ACCT F/MGRS-CONNECT+PROCTORIO PLUS, Chapter 2A, Problem 2A.2E

Answer 9

1.

Expert Solution

Answer 10

1.

Expert Solution

Answer 11

Expert Solution

Answer 12

Explanation of Solution

According to the given information the rental returns and car wash costs of B rental cars have been given and we have to prepare a scatter graph plot where the car wash cost should be on the vertical axis and the rental returns on the horizontal axis. To prepare the scatter graph first we have to go to insert option and select scatter graph from charts. The next step is to enter the X values and Y values and then we will get the graph. Now we can add trend line and axis title by clicking on the + symbol next to the graph. After adding the trend line we can click on the arrow button next to the trend line and select more options and then in that we have to checkmark display equation and display R squared value on the chart. The following is the data for plotting the graph:

Rental returns	Car wash costs ($)
2380	10825
2421	11865
2586	11332
2725	12422
2968	13850
3281	14419
3353	14935
3489	15738
3057	13563
2876	11889
2735	12683
2983	13796

Answer 13

2.

To determine

Introduction:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To calculate: the variable cost per rental return and the monthly fixed washing cars using least square regression method.

2.

Expert Solution

Answer to Problem 2A.2E

Thus, the variable cost per unit is $4.04 and the fixed cost per unit is $145583 for Bargain rental car.

Explanation of Solution

To calculate the variable cost per rental return and the monthly fixed washing cars using the least square regression method first we have to calculate the X, Y, X² and XY. In the given data the rental return is taken as X and car wash costs is taken as Y, let us now calculate the X² and XY:

Months	X	Y	X²	XY
January	2380	10825	5664400	25763500
February	2421	11865	5861241	28725165
March	2586	11332	6687396	29304552
April	2725	12422	7425625	33849950
May	2968	13850	8809024	41106800
June	3281	14419	10764961	47308739
July	3353	14935	11242609	50077055
August	3489	15738	12173121	54909882
September	3057	13563	9345249	41462091
October	2876	11889	8271376	34192764
November	2735	12683	7480225	34688005
December	2983	13796	8898289	41153468
Total	34854	157317	102623516	462541971

Now let us calculate the variable cost using following formula:

Variable cost per unit

= ( n∑XY − ∑X×∑Y ) (n∑ X 2 − (∑X) 2 ) = ( 12×462541971 –( 34854×157317 ) ) ( 12×102623516 – ( 34854 ) 2 ) = (5550503652−5483126718 (1231482192−1214801316= 67376934 / 16680876 = $4.04

Now, let us calculate the fixed cost per unit using following formula:

Fixed cost per unit

= ∑Y – ( variable cost per unit× ∑X ) n = 157317−( 4.04×34854 ) 12 = 157317 – 11734.18 = $145583

Answer 14

2.

To determine

Introduction:

Variable costs are those that increase or decrease with the general volume of work. Some of the examples of variable costs are sales commissions, labor costs, raw material costs, etc. Fixed costs are those costs that remain fixed irrespective of the volume of work. Some of the examples of fixed costs are office rent, administrative expenses, depreciation, etc.

Least square regression method:

The least-square regression method uses the regression line to classify the total cost into variable and fixed cost and thus minimizing the sum of squares of the errors and hence we can get the best line of fit with minimum variances. The least-square regression can be expressed as Y = a + bx

Where Y is Total cost

A is the total fixed cost

B is the variable cost

X is the activity level

To calculate: the variable cost per rental return and the monthly fixed washing cars using least square regression method.

Answer 15

2.

Expert Solution

Answer to Problem 2A.2E

Thus, the variable cost per unit is $4.04 and the fixed cost per unit is $145583 for Bargain rental car.

Answer 16

2.

Expert Solution

Answer 17

2.

Expert Solution

Answer 18

Expert Solution

Answer 19

Explanation of Solution

To calculate the variable cost per rental return and the monthly fixed washing cars using the least square regression method first we have to calculate the X, Y, X² and XY. In the given data the rental return is taken as X and car wash costs is taken as Y, let us now calculate the X² and XY:

Months	X	Y	X²	XY
January	2380	10825	5664400	25763500
February	2421	11865	5861241	28725165
March	2586	11332	6687396	29304552
April	2725	12422	7425625	33849950
May	2968	13850	8809024	41106800
June	3281	14419	10764961	47308739
July	3353	14935	11242609	50077055
August	3489	15738	12173121	54909882
September	3057	13563	9345249	41462091
October	2876	11889	8271376	34192764
November	2735	12683	7480225	34688005
December	2983	13796	8898289	41153468
Total	34854	157317	102623516	462541971

Now let us calculate the variable cost using following formula:

Variable cost per unit

= ( n∑XY − ∑X×∑Y ) (n∑ X 2 − (∑X) 2 ) = ( 12×462541971 –( 34854×157317 ) ) ( 12×102623516 – ( 34854 ) 2 ) = (5550503652−5483126718 (1231482192−1214801316= 67376934 / 16680876 = $4.04