Cost Estimation: Simple and Multiple Regression Using a Spreadsheet (Appendix A) Recall the analysis for Davis Stores in Exercises 5-39, 5-40, and 5-41. During a discussion of those results, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected information on the number of employees and combined it with their original data. Required a. Use the high-low method to estimate the fixed and variable portions of store costs based on employees. b. Use the results of your high-low analysis to estimate the cost for a store with 30 employees. c. Prepare a scattergraph between store cost and employees. d. Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees. e. Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees. f. Comment on the results of the regression analyses in parts d and e. ( Hint: Consider how the managers of Davis Stores might staff their stores and what this might mean for the data being used in the multiple regression analysis.)

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 5, Problem 60P

Cost Estimation: Simple and Multiple Regression Using a Spreadsheet (Appendix A)

Recall the analysis for Davis Stores in Exercises 5-39, 5-40, and 5-41. During a discussion of those results, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected information on the number of employees and combined it with their original data.

Chapter 5, Problem 60P, Cost Estimation: Simple and Multiple Regression Using a Spreadsheet (Appendix A) Recall the analysis

Required

a. Use the high-low method to estimate the fixed and variable portions of store costs based on employees.
b. Use the results of your high-low analysis to estimate the cost for a store with 30 employees.
c. Prepare a scattergraph between store cost and employees.
d. Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees.
e. Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees.
f. Comment on the results of the regression analyses in parts d and e. (Hint: Consider how the managers of Davis Stores might staff their stores and what this might mean for the data being used in the multiple regression analysis.)

a.

Expert Solution

To determine

Use the high-low method to estimate the fixed and variable portions of store costs based on employees.

Explanation of Solution

High-low cost method:

High-low cost method helps in separating the fixed and variable cost from the total cost. It is calculated by comparing the highest and lowest level of activities and the cost of these activities.

Show the cost equation of fixed and variable cost with the overhead cost:

Store cost = Fixed cost + Variable cost= ($91) (1) + ($94.82(2) × Number of employees)

Thus, the cost equation is: Store cost = $232 + ($94.82 × Number of employees).

Working note 1:

Calculate the fixed cost:

Fixed cost = Total cost - Variable cost= $5029 - $5,120 (3)= ($91)

Calculate the highest and lowest activity:

Particular	Employees	Cost
Highest activity	54	$5,029
Lowest activity	26	$2,374

Table: (1)

Working note 2:

Calculate the variable cost (unit) with the help of high-low cost method:

Variable cost = Cost of highest activity − Cost of lowest activityHighest activity units − Lowest activity units= $5,029 − $2,37454 −26= $94.82

Working note 3:

Calculate the variable cost ($) with the help of high-low cost method:

Variable cost ($) = Number of employees× Rate per unit= 54 × $94.82(2)= $5,120

b.

Expert Solution

To determine

Use the results of your high-low analysis to estimate the cost for a store with 30 employees.

Explanation of Solution

Total cost of store:

Total cost of the store includes the fixed and variable cost of the production. It is calculated by the cost equation.

Estimate the cost for the store:

Store cost = $232 + ($8 × number of employees)= ($232) + (94.82 × 30)= $2,753

Thus, the estimated cost for the store is $2,753.

c.

Expert Solution

To determine

Prepare a scatter graph between store cost and employees.

Explanation of Solution

Scatter graph:

Scatter graph shows the relationship between the cost and the activity. It shows the cost at various level of activity. It helps in finding the outlier in the data. So the management can eliminate it to make more effective decisions.

Prepare the scatter graph for store cost and employee:

FUND. OF COST ACCOUNTING ACCESS >I<, Chapter 5, Problem 60P

The scatter plot represents number of employees on the horizontal axis and the store cost on the vertical axis. The points on the scatter plot do not seem to form the linear pattern and there is not a healthy relationship as well.

d.

Expert Solution

To determine

Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees.

Answer to Problem 60P

The store cost is $2,930.

Explanation of Solution

Cost equation:

Cost equation is a mathematical representation of the cost estimation at various level of activity. It is used by defining the fixed cost and variable cost per unit and then the variable cost per unit is multiplied by the given variable to calculate the relative cost.

Store cost = ($162.9) + 103.1 × Employees= ($162.9) + 103.1 × 30= $2,930

Thus, the store cost is $2,930.

e.

Expert Solution

To determine

Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees.

Explanation of Solution

Multiple regressions:

Multiple regressions use two or more activities (variables) to establish the relationship between cost and activities:

Store cost = ($204.2) + (0.01) × Revenues + 105.5 × Employees= ($204.2) +(0.01) × 2,500 + 105.5 × 30= $2,935.8

Thus, the store cost is $2,935.8.

f.

Expert Solution

To determine

Comment on the results of the regression analyses in parts d and e.

Explanation of Solution

Regression analysis:

Regression analysis is used to show the relationship between the cost and the activity. It is used to estimate the cost at various level of activity.

The most important step in the calculation of regression analysis is to establish a logical relationship between the cost and the activity. The activity (independent variable) is placed on the right-hand-side and the cost (dependant variable) is placed on the left-hand-side of the graph.

Comment on the results of the regression analyses:

In case of simple and multiple regressions, the both of the coefficients are not very significant. But the both the R² are similar and significant. This kind of problem arises when two or more independent variables in a multiple regression analyses are related to each other.

In the given case, the number of employees and revenue are closely related.

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

Using Multiple Regression Results to Construct and Apply a Cost Formula The controller for Dohini Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring an overseas supplier) took more time and effort. He collected data on the number of nonstandard orders for the past 12 months and added that information to the data on purchasing cost and total number of purchase orders. Month Purchasing Cost Number of Purchase Orders Number of Nonstandard Orders January $18,860 370 53 February 18,065 330 35 March 19,250 370 61 April 18,050 410 14 May 19,345 400 73 June 19,500 450 55 July 19,670 460 30 August 20,940…

The manager of the West store has concerns relating to the store’s financial performance and has asked for help analyzing transfer costs. After calculating the operating income in dollars and the operating income percent, analyze the following financial information to determine costs that may need further investigation. It may be helpful to perform a vertical analysis (i.e., perform a vertical analysis). warehouse west store sales $18,920 $43,860 cost of goods sold 9,082 21,053 gross profit $9,838 $22,807 selling expenses 860 2,752 wages expense 4,730 15,351 costs allocated from corporate 2,838 4,386 Total expenses $8,428 $22,489 operating income/(loss) $ ? ? Operating Income/(loss) % ? ?

Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Company’s purchasing cost and number of purchase orders.The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Intercept 15,021 (rounded to the nearest dollar)X variable 1 9.74 (rounded to the nearest cent) Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the vari-able rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchaseorders, what is the total estimated purchasing cost for that month? (Round your answer tothe nearest dollar.)3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year andexpects 5,340 purchase orders? What will estimated total purchasing cost be? (Round youranswer to the nearest dollar.) What is the total fixed purchasing cost? Why doesn’t it equalthe fixed cost calculated in Requirement 1?

Answer 2

Textbook Question

Chapter 5, Problem 60P

Cost Estimation: Simple and Multiple Regression Using a Spreadsheet (Appendix A)

Recall the analysis for Davis Stores in Exercises 5-39, 5-40, and 5-41. During a discussion of those results, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected information on the number of employees and combined it with their original data.

Chapter 5, Problem 60P, Cost Estimation: Simple and Multiple Regression Using a Spreadsheet (Appendix A) Recall the analysis

Required

a. Use the high-low method to estimate the fixed and variable portions of store costs based on employees.
b. Use the results of your high-low analysis to estimate the cost for a store with 30 employees.
c. Prepare a scattergraph between store cost and employees.
d. Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees.
e. Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees.
f. Comment on the results of the regression analyses in parts d and e. (Hint: Consider how the managers of Davis Stores might staff their stores and what this might mean for the data being used in the multiple regression analysis.)

a.

Expert Solution

To determine

Use the high-low method to estimate the fixed and variable portions of store costs based on employees.

Explanation of Solution

High-low cost method:

High-low cost method helps in separating the fixed and variable cost from the total cost. It is calculated by comparing the highest and lowest level of activities and the cost of these activities.

Show the cost equation of fixed and variable cost with the overhead cost:

Store cost = Fixed cost + Variable cost= ($91) (1) + ($94.82(2) × Number of employees)

Thus, the cost equation is: Store cost = $232 + ($94.82 × Number of employees).

Working note 1:

Calculate the fixed cost:

Fixed cost = Total cost - Variable cost= $5029 - $5,120 (3)= ($91)

Calculate the highest and lowest activity:

Particular	Employees	Cost
Highest activity	54	$5,029
Lowest activity	26	$2,374

Table: (1)

Working note 2:

Calculate the variable cost (unit) with the help of high-low cost method:

Variable cost = Cost of highest activity − Cost of lowest activityHighest activity units − Lowest activity units= $5,029 − $2,37454 −26= $94.82

Working note 3:

Calculate the variable cost ($) with the help of high-low cost method:

Variable cost ($) = Number of employees× Rate per unit= 54 × $94.82(2)= $5,120

b.

Expert Solution

To determine

Use the results of your high-low analysis to estimate the cost for a store with 30 employees.

Explanation of Solution

Total cost of store:

Total cost of the store includes the fixed and variable cost of the production. It is calculated by the cost equation.

Estimate the cost for the store:

Store cost = $232 + ($8 × number of employees)= ($232) + (94.82 × 30)= $2,753

Thus, the estimated cost for the store is $2,753.

c.

Expert Solution

To determine

Prepare a scatter graph between store cost and employees.

Explanation of Solution

Scatter graph:

Scatter graph shows the relationship between the cost and the activity. It shows the cost at various level of activity. It helps in finding the outlier in the data. So the management can eliminate it to make more effective decisions.

Prepare the scatter graph for store cost and employee:

FUND. OF COST ACCOUNTING ACCESS >I<, Chapter 5, Problem 60P

The scatter plot represents number of employees on the horizontal axis and the store cost on the vertical axis. The points on the scatter plot do not seem to form the linear pattern and there is not a healthy relationship as well.

d.

Expert Solution

To determine

Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees.

Answer to Problem 60P

The store cost is $2,930.

Explanation of Solution

Cost equation:

Cost equation is a mathematical representation of the cost estimation at various level of activity. It is used by defining the fixed cost and variable cost per unit and then the variable cost per unit is multiplied by the given variable to calculate the relative cost.

Store cost = ($162.9) + 103.1 × Employees= ($162.9) + 103.1 × 30= $2,930

Thus, the store cost is $2,930.

e.

Expert Solution

To determine

Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees.

Explanation of Solution

Multiple regressions:

Multiple regressions use two or more activities (variables) to establish the relationship between cost and activities:

Store cost = ($204.2) + (0.01) × Revenues + 105.5 × Employees= ($204.2) +(0.01) × 2,500 + 105.5 × 30= $2,935.8

Thus, the store cost is $2,935.8.

f.

Expert Solution

To determine

Comment on the results of the regression analyses in parts d and e.

Explanation of Solution

Regression analysis:

Regression analysis is used to show the relationship between the cost and the activity. It is used to estimate the cost at various level of activity.

The most important step in the calculation of regression analysis is to establish a logical relationship between the cost and the activity. The activity (independent variable) is placed on the right-hand-side and the cost (dependant variable) is placed on the left-hand-side of the graph.

Comment on the results of the regression analyses:

In case of simple and multiple regressions, the both of the coefficients are not very significant. But the both the R² are similar and significant. This kind of problem arises when two or more independent variables in a multiple regression analyses are related to each other.

In the given case, the number of employees and revenue are closely related.

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

Textbook Question

Chapter 5, Problem 60P

Cost Estimation: Simple and Multiple Regression Using a Spreadsheet (Appendix A)

Recall the analysis for Davis Stores in Exercises 5-39, 5-40, and 5-41. During a discussion of those results, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected information on the number of employees and combined it with their original data.

Chapter 5, Problem 60P, Cost Estimation: Simple and Multiple Regression Using a Spreadsheet (Appendix A) Recall the analysis

Required

a. Use the high-low method to estimate the fixed and variable portions of store costs based on employees.
b. Use the results of your high-low analysis to estimate the cost for a store with 30 employees.
c. Prepare a scattergraph between store cost and employees.
d. Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees.
e. Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees.
f. Comment on the results of the regression analyses in parts d and e. (Hint: Consider how the managers of Davis Stores might staff their stores and what this might mean for the data being used in the multiple regression analysis.)

a.

Expert Solution

To determine

Use the high-low method to estimate the fixed and variable portions of store costs based on employees.

Explanation of Solution

High-low cost method:

High-low cost method helps in separating the fixed and variable cost from the total cost. It is calculated by comparing the highest and lowest level of activities and the cost of these activities.

Show the cost equation of fixed and variable cost with the overhead cost:

Store cost = Fixed cost + Variable cost= ($91) (1) + ($94.82(2) × Number of employees)

Thus, the cost equation is: Store cost = $232 + ($94.82 × Number of employees).

Working note 1:

Calculate the fixed cost:

Fixed cost = Total cost - Variable cost= $5029 - $5,120 (3)= ($91)

Calculate the highest and lowest activity:

Particular	Employees	Cost
Highest activity	54	$5,029
Lowest activity	26	$2,374

Table: (1)

Working note 2:

Calculate the variable cost (unit) with the help of high-low cost method:

Variable cost = Cost of highest activity − Cost of lowest activityHighest activity units − Lowest activity units= $5,029 − $2,37454 −26= $94.82

Working note 3:

Calculate the variable cost ($) with the help of high-low cost method:

Variable cost ($) = Number of employees× Rate per unit= 54 × $94.82(2)= $5,120

b.

Expert Solution

To determine

Use the results of your high-low analysis to estimate the cost for a store with 30 employees.

Explanation of Solution

Total cost of store:

Total cost of the store includes the fixed and variable cost of the production. It is calculated by the cost equation.

Estimate the cost for the store:

Store cost = $232 + ($8 × number of employees)= ($232) + (94.82 × 30)= $2,753

Thus, the estimated cost for the store is $2,753.

c.

Expert Solution

To determine

Prepare a scatter graph between store cost and employees.

Explanation of Solution

Scatter graph:

Scatter graph shows the relationship between the cost and the activity. It shows the cost at various level of activity. It helps in finding the outlier in the data. So the management can eliminate it to make more effective decisions.

Prepare the scatter graph for store cost and employee:

FUND. OF COST ACCOUNTING ACCESS >I<, Chapter 5, Problem 60P

The scatter plot represents number of employees on the horizontal axis and the store cost on the vertical axis. The points on the scatter plot do not seem to form the linear pattern and there is not a healthy relationship as well.

d.

Expert Solution

To determine

Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees.

Answer to Problem 60P

The store cost is $2,930.

Explanation of Solution

Cost equation:

Cost equation is a mathematical representation of the cost estimation at various level of activity. It is used by defining the fixed cost and variable cost per unit and then the variable cost per unit is multiplied by the given variable to calculate the relative cost.

Store cost = ($162.9) + 103.1 × Employees= ($162.9) + 103.1 × 30= $2,930

Thus, the store cost is $2,930.

e.

Expert Solution

To determine

Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees.

Explanation of Solution

Multiple regressions:

Multiple regressions use two or more activities (variables) to establish the relationship between cost and activities:

Store cost = ($204.2) + (0.01) × Revenues + 105.5 × Employees= ($204.2) +(0.01) × 2,500 + 105.5 × 30= $2,935.8

Thus, the store cost is $2,935.8.

f.

Expert Solution

To determine

Comment on the results of the regression analyses in parts d and e.

Explanation of Solution

Regression analysis:

Regression analysis is used to show the relationship between the cost and the activity. It is used to estimate the cost at various level of activity.

The most important step in the calculation of regression analysis is to establish a logical relationship between the cost and the activity. The activity (independent variable) is placed on the right-hand-side and the cost (dependant variable) is placed on the left-hand-side of the graph.

Comment on the results of the regression analyses:

In case of simple and multiple regressions, the both of the coefficients are not very significant. But the both the R² are similar and significant. This kind of problem arises when two or more independent variables in a multiple regression analyses are related to each other.

In the given case, the number of employees and revenue are closely related.

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

Textbook Question

Chapter 5, Problem 60P

Cost Estimation: Simple and Multiple Regression Using a Spreadsheet (Appendix A)

Recall the analysis for Davis Stores in Exercises 5-39, 5-40, and 5-41. During a discussion of those results, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected information on the number of employees and combined it with their original data.

Chapter 5, Problem 60P, Cost Estimation: Simple and Multiple Regression Using a Spreadsheet (Appendix A) Recall the analysis

Required

a. Use the high-low method to estimate the fixed and variable portions of store costs based on employees.
b. Use the results of your high-low analysis to estimate the cost for a store with 30 employees.
c. Prepare a scattergraph between store cost and employees.
d. Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees.
e. Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees.
f. Comment on the results of the regression analyses in parts d and e. (Hint: Consider how the managers of Davis Stores might staff their stores and what this might mean for the data being used in the multiple regression analysis.)

a.

Expert Solution

To determine

Use the high-low method to estimate the fixed and variable portions of store costs based on employees.

Explanation of Solution

High-low cost method:

High-low cost method helps in separating the fixed and variable cost from the total cost. It is calculated by comparing the highest and lowest level of activities and the cost of these activities.

Show the cost equation of fixed and variable cost with the overhead cost:

Store cost = Fixed cost + Variable cost= ($91) (1) + ($94.82(2) × Number of employees)

Thus, the cost equation is: Store cost = $232 + ($94.82 × Number of employees).

Working note 1:

Calculate the fixed cost:

Fixed cost = Total cost - Variable cost= $5029 - $5,120 (3)= ($91)

Calculate the highest and lowest activity:

Particular	Employees	Cost
Highest activity	54	$5,029
Lowest activity	26	$2,374

Table: (1)

Working note 2:

Calculate the variable cost (unit) with the help of high-low cost method:

Variable cost = Cost of highest activity − Cost of lowest activityHighest activity units − Lowest activity units= $5,029 − $2,37454 −26= $94.82

Working note 3:

Calculate the variable cost ($) with the help of high-low cost method:

Variable cost ($) = Number of employees× Rate per unit= 54 × $94.82(2)= $5,120

b.

Expert Solution

To determine

Use the results of your high-low analysis to estimate the cost for a store with 30 employees.

Explanation of Solution

Total cost of store:

Total cost of the store includes the fixed and variable cost of the production. It is calculated by the cost equation.

Estimate the cost for the store:

Store cost = $232 + ($8 × number of employees)= ($232) + (94.82 × 30)= $2,753

Thus, the estimated cost for the store is $2,753.

c.

Expert Solution

To determine

Prepare a scatter graph between store cost and employees.

Explanation of Solution

Scatter graph:

Scatter graph shows the relationship between the cost and the activity. It shows the cost at various level of activity. It helps in finding the outlier in the data. So the management can eliminate it to make more effective decisions.

Prepare the scatter graph for store cost and employee:

FUND. OF COST ACCOUNTING ACCESS >I<, Chapter 5, Problem 60P

The scatter plot represents number of employees on the horizontal axis and the store cost on the vertical axis. The points on the scatter plot do not seem to form the linear pattern and there is not a healthy relationship as well.

d.

Expert Solution

To determine

Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees.

Answer to Problem 60P

The store cost is $2,930.

Explanation of Solution

Cost equation:

Cost equation is a mathematical representation of the cost estimation at various level of activity. It is used by defining the fixed cost and variable cost per unit and then the variable cost per unit is multiplied by the given variable to calculate the relative cost.

Store cost = ($162.9) + 103.1 × Employees= ($162.9) + 103.1 × 30= $2,930

Thus, the store cost is $2,930.

e.

Expert Solution

To determine

Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees.

Explanation of Solution

Multiple regressions:

Multiple regressions use two or more activities (variables) to establish the relationship between cost and activities:

Store cost = ($204.2) + (0.01) × Revenues + 105.5 × Employees= ($204.2) +(0.01) × 2,500 + 105.5 × 30= $2,935.8

Thus, the store cost is $2,935.8.

f.

Expert Solution

To determine

Comment on the results of the regression analyses in parts d and e.

Explanation of Solution

Regression analysis:

Regression analysis is used to show the relationship between the cost and the activity. It is used to estimate the cost at various level of activity.

The most important step in the calculation of regression analysis is to establish a logical relationship between the cost and the activity. The activity (independent variable) is placed on the right-hand-side and the cost (dependant variable) is placed on the left-hand-side of the graph.

Comment on the results of the regression analyses:

In case of simple and multiple regressions, the both of the coefficients are not very significant. But the both the R² are similar and significant. This kind of problem arises when two or more independent variables in a multiple regression analyses are related to each other.

In the given case, the number of employees and revenue are closely related.

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

Textbook Question

Answer 6

Textbook Question

Answer 7

a.

Expert Solution

To determine

Use the high-low method to estimate the fixed and variable portions of store costs based on employees.

Explanation of Solution

High-low cost method:

High-low cost method helps in separating the fixed and variable cost from the total cost. It is calculated by comparing the highest and lowest level of activities and the cost of these activities.

Show the cost equation of fixed and variable cost with the overhead cost:

Store cost = Fixed cost + Variable cost= ($91) (1) + ($94.82(2) × Number of employees)

Thus, the cost equation is: Store cost = $232 + ($94.82 × Number of employees).

Working note 1:

Calculate the fixed cost:

Fixed cost = Total cost - Variable cost= $5029 - $5,120 (3)= ($91)

Calculate the highest and lowest activity:

Particular	Employees	Cost
Highest activity	54	$5,029
Lowest activity	26	$2,374

Table: (1)

Working note 2:

Calculate the variable cost (unit) with the help of high-low cost method:

Variable cost = Cost of highest activity − Cost of lowest activityHighest activity units − Lowest activity units= $5,029 − $2,37454 −26= $94.82

Working note 3:

Calculate the variable cost ($) with the help of high-low cost method:

Variable cost ($) = Number of employees× Rate per unit= 54 × $94.82(2)= $5,120

b.

Expert Solution

To determine

Use the results of your high-low analysis to estimate the cost for a store with 30 employees.

Explanation of Solution

Total cost of store:

Total cost of the store includes the fixed and variable cost of the production. It is calculated by the cost equation.

Estimate the cost for the store:

Store cost = $232 + ($8 × number of employees)= ($232) + (94.82 × 30)= $2,753

Thus, the estimated cost for the store is $2,753.

c.

Expert Solution

To determine

Prepare a scatter graph between store cost and employees.

Explanation of Solution

Scatter graph:

Scatter graph shows the relationship between the cost and the activity. It shows the cost at various level of activity. It helps in finding the outlier in the data. So the management can eliminate it to make more effective decisions.

Prepare the scatter graph for store cost and employee:

FUND. OF COST ACCOUNTING ACCESS >I<, Chapter 5, Problem 60P

The scatter plot represents number of employees on the horizontal axis and the store cost on the vertical axis. The points on the scatter plot do not seem to form the linear pattern and there is not a healthy relationship as well.

d.

Expert Solution

To determine

Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees.

Answer to Problem 60P

The store cost is $2,930.

Explanation of Solution

Cost equation:

Cost equation is a mathematical representation of the cost estimation at various level of activity. It is used by defining the fixed cost and variable cost per unit and then the variable cost per unit is multiplied by the given variable to calculate the relative cost.

Store cost = ($162.9) + 103.1 × Employees= ($162.9) + 103.1 × 30= $2,930

Thus, the store cost is $2,930.

e.

Expert Solution

To determine

Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees.

Explanation of Solution

Multiple regressions:

Multiple regressions use two or more activities (variables) to establish the relationship between cost and activities:

Store cost = ($204.2) + (0.01) × Revenues + 105.5 × Employees= ($204.2) +(0.01) × 2,500 + 105.5 × 30= $2,935.8

Thus, the store cost is $2,935.8.

f.

Expert Solution

To determine

Comment on the results of the regression analyses in parts d and e.

Explanation of Solution

Regression analysis:

Regression analysis is used to show the relationship between the cost and the activity. It is used to estimate the cost at various level of activity.

The most important step in the calculation of regression analysis is to establish a logical relationship between the cost and the activity. The activity (independent variable) is placed on the right-hand-side and the cost (dependant variable) is placed on the left-hand-side of the graph.

Comment on the results of the regression analyses:

In case of simple and multiple regressions, the both of the coefficients are not very significant. But the both the R² are similar and significant. This kind of problem arises when two or more independent variables in a multiple regression analyses are related to each other.

In the given case, the number of employees and revenue are closely related.

Answer 8

a.

Expert Solution

To determine

Use the high-low method to estimate the fixed and variable portions of store costs based on employees.

Explanation of Solution

High-low cost method:

High-low cost method helps in separating the fixed and variable cost from the total cost. It is calculated by comparing the highest and lowest level of activities and the cost of these activities.

Show the cost equation of fixed and variable cost with the overhead cost:

Store cost = Fixed cost + Variable cost= ($91) (1) + ($94.82(2) × Number of employees)

Thus, the cost equation is: Store cost = $232 + ($94.82 × Number of employees).

Working note 1:

Calculate the fixed cost:

Fixed cost = Total cost - Variable cost= $5029 - $5,120 (3)= ($91)

Calculate the highest and lowest activity:

Particular	Employees	Cost
Highest activity	54	$5,029
Lowest activity	26	$2,374

Table: (1)

Working note 2:

Calculate the variable cost (unit) with the help of high-low cost method:

Variable cost = Cost of highest activity − Cost of lowest activityHighest activity units − Lowest activity units= $5,029 − $2,37454 −26= $94.82

Working note 3:

Calculate the variable cost ($) with the help of high-low cost method:

Variable cost ($) = Number of employees× Rate per unit= 54 × $94.82(2)= $5,120

Answer 9

a.

Expert Solution

Answer 10

a.

Expert Solution

Answer 11

Expert Solution

Answer 12

To determine

Use the high-low method to estimate the fixed and variable portions of store costs based on employees.

Answer 13

Explanation of Solution

High-low cost method:

High-low cost method helps in separating the fixed and variable cost from the total cost. It is calculated by comparing the highest and lowest level of activities and the cost of these activities.

Show the cost equation of fixed and variable cost with the overhead cost:

Store cost = Fixed cost + Variable cost= ($91) (1) + ($94.82(2) × Number of employees)

Thus, the cost equation is: Store cost = $232 + ($94.82 × Number of employees).

Working note 1:

Calculate the fixed cost:

Fixed cost = Total cost - Variable cost= $5029 - $5,120 (3)= ($91)

Calculate the highest and lowest activity:

Particular	Employees	Cost
Highest activity	54	$5,029
Lowest activity	26	$2,374

Table: (1)

Working note 2:

Calculate the variable cost (unit) with the help of high-low cost method:

Variable cost = Cost of highest activity − Cost of lowest activityHighest activity units − Lowest activity units= $5,029 − $2,37454 −26= $94.82

Working note 3:

Calculate the variable cost ($) with the help of high-low cost method:

Variable cost ($) = Number of employees× Rate per unit= 54 × $94.82(2)= $5,120

Answer 14

b.

Expert Solution

To determine

Use the results of your high-low analysis to estimate the cost for a store with 30 employees.

Explanation of Solution

Total cost of store:

Total cost of the store includes the fixed and variable cost of the production. It is calculated by the cost equation.

Estimate the cost for the store:

Store cost = $232 + ($8 × number of employees)= ($232) + (94.82 × 30)= $2,753

Thus, the estimated cost for the store is $2,753.

Answer 15

b.

Expert Solution

Answer 16

b.

Expert Solution

Answer 17

Expert Solution

Answer 18

To determine

Use the results of your high-low analysis to estimate the cost for a store with 30 employees.

Answer 19

Explanation of Solution

Total cost of store:

Total cost of the store includes the fixed and variable cost of the production. It is calculated by the cost equation.

Estimate the cost for the store:

Store cost = $232 + ($8 × number of employees)= ($232) + (94.82 × 30)= $2,753

Thus, the estimated cost for the store is $2,753.

Answer 20

c.

Expert Solution

To determine

Prepare a scatter graph between store cost and employees.

Explanation of Solution

Scatter graph:

Scatter graph shows the relationship between the cost and the activity. It shows the cost at various level of activity. It helps in finding the outlier in the data. So the management can eliminate it to make more effective decisions.

Prepare the scatter graph for store cost and employee:

FUND. OF COST ACCOUNTING ACCESS >I<, Chapter 5, Problem 60P

The scatter plot represents number of employees on the horizontal axis and the store cost on the vertical axis. The points on the scatter plot do not seem to form the linear pattern and there is not a healthy relationship as well.

Answer 21

c.

Expert Solution

Answer 22

c.

Expert Solution

Answer 23

Expert Solution

Answer 24

To determine

Prepare a scatter graph between store cost and employees.

Answer 25

Explanation of Solution

Scatter graph:

Scatter graph shows the relationship between the cost and the activity. It shows the cost at various level of activity. It helps in finding the outlier in the data. So the management can eliminate it to make more effective decisions.

Prepare the scatter graph for store cost and employee:

FUND. OF COST ACCOUNTING ACCESS >I<, Chapter 5, Problem 60P

The scatter plot represents number of employees on the horizontal axis and the store cost on the vertical axis. The points on the scatter plot do not seem to form the linear pattern and there is not a healthy relationship as well.

Answer 26

d.

Expert Solution

To determine

Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees.

Answer to Problem 60P

The store cost is $2,930.

Explanation of Solution

Cost equation:

Cost equation is a mathematical representation of the cost estimation at various level of activity. It is used by defining the fixed cost and variable cost per unit and then the variable cost per unit is multiplied by the given variable to calculate the relative cost.

Store cost = ($162.9) + 103.1 × Employees= ($162.9) + 103.1 × 30= $2,930

Thus, the store cost is $2,930.

Answer 27

d.

Expert Solution

Answer 28

d.

Expert Solution

Answer 29

Expert Solution

Answer 30

To determine

Prepare an estimate of the cost of a store with 30 employees using the results from a simple regression of store cost on employees.

Answer 31

Answer to Problem 60P

The store cost is $2,930.

Answer 32

Explanation of Solution

Cost equation:

Cost equation is a mathematical representation of the cost estimation at various level of activity. It is used by defining the fixed cost and variable cost per unit and then the variable cost per unit is multiplied by the given variable to calculate the relative cost.

Store cost = ($162.9) + 103.1 × Employees= ($162.9) + 103.1 × 30= $2,930

Thus, the store cost is $2,930.

Answer 33

e.

Expert Solution

To determine

Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees.

Explanation of Solution

Multiple regressions:

Multiple regressions use two or more activities (variables) to establish the relationship between cost and activities:

Store cost = ($204.2) + (0.01) × Revenues + 105.5 × Employees= ($204.2) +(0.01) × 2,500 + 105.5 × 30= $2,935.8

Thus, the store cost is $2,935.8.

Answer 34

e.

Expert Solution

Answer 35

e.

Expert Solution

Answer 36

Expert Solution

Answer 37

To determine

Prepare an estimate of the cost of a store with revenues of $2.5 million and 30 employees using the results of a multiple regression of store costs on store revenues and employees.

Answer 38

Explanation of Solution

Multiple regressions:

Multiple regressions use two or more activities (variables) to establish the relationship between cost and activities:

Store cost = ($204.2) + (0.01) × Revenues + 105.5 × Employees= ($204.2) +(0.01) × 2,500 + 105.5 × 30= $2,935.8

Thus, the store cost is $2,935.8.

Answer 39

f.

Expert Solution

To determine

Comment on the results of the regression analyses in parts d and e.

Explanation of Solution

Regression analysis:

Regression analysis is used to show the relationship between the cost and the activity. It is used to estimate the cost at various level of activity.

The most important step in the calculation of regression analysis is to establish a logical relationship between the cost and the activity. The activity (independent variable) is placed on the right-hand-side and the cost (dependant variable) is placed on the left-hand-side of the graph.

Comment on the results of the regression analyses:

In case of simple and multiple regressions, the both of the coefficients are not very significant. But the both the R² are similar and significant. This kind of problem arises when two or more independent variables in a multiple regression analyses are related to each other.

In the given case, the number of employees and revenue are closely related.

Answer 40

f.

Expert Solution

Answer 41

f.

Expert Solution

Answer 42

Expert Solution

Answer 43

To determine

Comment on the results of the regression analyses in parts d and e.

Answer 44

Explanation of Solution

Regression analysis:

Regression analysis is used to show the relationship between the cost and the activity. It is used to estimate the cost at various level of activity.

The most important step in the calculation of regression analysis is to establish a logical relationship between the cost and the activity. The activity (independent variable) is placed on the right-hand-side and the cost (dependant variable) is placed on the left-hand-side of the graph.

Comment on the results of the regression analyses:

In case of simple and multiple regressions, the both of the coefficients are not very significant. But the both the R² are similar and significant. This kind of problem arises when two or more independent variables in a multiple regression analyses are related to each other.

In the given case, the number of employees and revenue are closely related.