Cost Management
Cost Management
8th Edition
ISBN: 9781259917028
Author: BLOCHER, Edward
Publisher: Mcgraw-hill Education,
Question
Book Icon
Chapter 8, Problem 49P

1.

To determine

Draw a graph of the data.

1.

Expert Solution
Check Mark

Explanation of Solution

Draw a graph of the data.

Cost Management, Chapter 8, Problem 49P , additional homework tip  1

Figure (1)

2.

To determine

Compute quarterly forecast by selecting two data point from part (1) using high-low method.

2.

Expert Solution
Check Mark

Explanation of Solution

High-low method:

The graph in part (1) shows that high and low points are last and second data points, so these points develop the estimate of high-low.

Calculate the variable cost.

Variable cost=(Return expense of 4th quarter 2018Return expense of 2nd quarter 2016)(Last data pointSecond data point)=$14,600$11,300122=$330

Calculate the fixed cost.

Fixed cost=(Return expense of 2nd quarter 2016(Variable cost×Second data point))=$11,300($330×2)=$10,640

Compute quarterly prediction for the year 2019.

2019 QuarterReturn Expenses
13$14,930
14$15,260
15$15,590
16$15,920

Table (1)

Note: Shown below is the formula to compute quarterly prediction.

Quarterly prediction=(2019 quarter×Variable cost+Fixed cost)

These predictions do not take into account the seasonal variation as shown in the data, it is always useful to take into considerationthe results for a regression analysis as shown in part (3).

3.

To determine

Compute the quarterly forecast for 2019 using the results of a regression analysis. Calculate the result of regression analysis and necessary changes to improve the model.

3.

Expert Solution
Check Mark

Explanation of Solution

Regression one:

Regression Statistics
Multiple R0.439734422
R Square0.193366362
Adjusted R Square0.112702998
Standard Error974.8928577
Observations12

Table (2)

ANOVA
 dfSSMSFSignificance F
Regression12278339.16122783392.3972020.152593037
Residual109504160.839950416.1
Total1111782500   

Table (3)

Cost Management, Chapter 8, Problem 49P , additional homework tip  2

Table (4)

Regression Predictions
    Intercept $11,855
    Coefficient $126.22

Table (5)

Quarterly Predictions
13 $13,496
14 $13,622
15 $13,748
16 $13,875

Table (6)

Note: Shown below is to compute rent expense.

Rent expense=(Intercept in regression 1+(Quarter of co-efficients×Quarter number))

Predicted expense for next four quarter using regression analysis:

QuarterRegression prediction 
13 ($11,855+(13×$126.2238))13,495.45
14 ($11,855+(14×$126.2238))13,621.68
15 ($11,855+(15×$126.2238))13,747.90
16 ($11,855+(16×$126.2238))13,874.13

Table (7)

This shows how the regression model’s prediction differ from that of high-low method.

The above regression one has relatively low R-Squared (0.19) and low t-value for the independent variable, a revision of the regression model is considered. Since, there is visible seasonality in the data, by adding dummy variable it is possible to improve on the regression model with 1s in the periods 4,8, and 12, and 0s in the left-over periods. For the dummy variable the below given regression analysis indications a much higher R-Squared, improved SE and a substantial t-value.

Regression 2:

Regression Statistics
Multiple R0.873681599
R Square0.763319537
Adjusted R Square0.710723879
Standard Error556.6454641
Observations12

Table (8)

ANOVA
 dfSSMSFSignificance F
Regression28993812.4454496906.22314.512976160.00152662
Residual92788687.555309854.1728  
Total1111782500   

Table (9)

Cost Management, Chapter 8, Problem 49P , additional homework tip  3

Table (10)

Equation for the above regression are:

Expenses=($11,252.65118+($1,589,00876×Dummy variable for season)+($137.33567×Quarter number))

Regression Predictions
Intercept $11,252.65
Coefficient Qtr. $137.34
Coefficient Season $1,589

Table (11)

The regression prediction for the revised regression:

Quarterly Predictions
13 $14,627
14 $13,175
15 $13,313
16 $15,039

Table (12)

The management accountant should depend on the above shown prediction because the second regression has better statistical measures.

4.

To determine

Explain how the analysis of costs change, if L Incorporation produces its products in multiple global production facilities to serve the global market.

4.

Expert Solution
Check Mark

Explanation of Solution

If L Incorporation produces its products in multiple global production facilities, then the expenses incurred from returns has to be studied by the production facility. Due to various equipment used in manufacturing the DVD players, the cost incurred are likely to differ among the production facility.

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!
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education