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.

MANAGERIAL ACCOUNTING W/ACCESS, 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

h6

Serial Problem Business Solutions LO P3 Santana Rey has found that Business Solutions's line of computer desks and chairs has become very popular, and she is finding it hard to keep up with demand. She knows that she cannot fill all of her orders for both items, so she decides she must determine the optimal sales mix given the resources she has available. Information about the desks and chairs follows. Selling price per unit. Variable costs per unit Contribution margin per unit Direct labor hours per unit Expected demand for next quarter Contribution per direct labor hour Maximum number of units to be sold Hours required to produce maximum units For most profitable sales mix Desks $1,203.50 Santana has determined that she only has 1,167 direct labor hours available for the next quarter and wants to optimize her contribution margin given the limited number of direct labor hours available. Hours dedicated to the production of each product 410.00 $ 793.50 Required: Determine the optimal…

5 Revenue mix, new and upgrade customers. Zapo 1-2-3 is a top-selling spreadsheet product. Zapo is about to release Version 5.0. It groups its customers into two groups new customers and upgrade customers (those who previously purchased Zapo 1-2-3 Version 4.0 or earlier). Although the same physical product is provided to each customer group, sizable differences exist in their selling prices and variable marketing costs: Selling price Variable cost: Manufacturing Marketing New Customers $25 65 $210 90 a. New 50%/upgrade 50%. b. New 90% / upgrade 10% Upgrade Customers $120 $25 15 40 The fixed costs of Zapo 5.0 are $14,000,000. The planned revenue mix in units is 60% new customers and 40% upgrade customers. REQUIRED 1. What is the Zapo 1-2-3 Version 5.0 breakeven point in units, assuming that the planned 60/40 mix is maintained? 2. If the mix is maintained, what is the operating income when 200,000 units are sold? 3. Show how the breakeven point in units changes with the following…

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.

MANAGERIAL ACCOUNTING W/ACCESS, 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.

MANAGERIAL ACCOUNTING W/ACCESS, 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.

MANAGERIAL ACCOUNTING W/ACCESS, 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.

MANAGERIAL ACCOUNTING W/ACCESS, 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.

MANAGERIAL ACCOUNTING W/ACCESS, 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.

MANAGERIAL ACCOUNTING W/ACCESS, 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