Reference no: EM131111230
Multiple regression is used by accountants in cost analysis to shed light on the factors that cause costs to be incurred and the magnitudes of their effects. The independent variables of such a regression model are the factors believed to be related to cost, the dependent variable. In some instances, however, it is desirable to use physical units instead of cost as the dependent variable in a cost analysis. This would be the case if most of the cost associated with the activity of interest is a function of some physical unit, such as hours of labor. The advantage of this approach is that the regression model will provide estimates of the number of labor hours required under different circumstances and these hours can then be costed at the current labor rate (Horngren, Foster. and Datar, 1994). The sample data shown in the table below have been collected from a firm's accounting and production records to provide cost information about the firm's shipping department. The EXCEL computer printout for fitting the model 
is provided on page 592.
a. Find the least squares prediction equation.
b. Use an F-test to investigate the usefulness of the model specified in part a. Use a = .01, and state your conclusion in the context of the problem
c. Test H0: ß2 = 0 versus Ha: ß2 ≠ 0 using α = .05. What do the results of your test suggest about the magnitude of the effects of x2 on labor costs?
d. Find R2, and interpret its value in the context of the problem.
e. If shipping department employees are paid $7.50 per hour, how much less, on average, will it cost the company per week if the average number of pounds per shipment increases from a level of 20 to 21 7 Assume that x1 and x2 remain unchanged. Your answer is an estimate of what is known in economics as the expected marginal cost associated with a one pound increase in x3.
f. With what approximate precision can this model be used to predict the hours of labor'? [Note: The precision of multiple regression predictions is discussed in Section 10.6.1]
g. Can regression analysis alone indicate what factors cause costs to increase? Explain.
|
Study of street vendors in the city of puebla
: Refer to the World Development (Feb. 1998) study of street vendors' earnings, y, Exercises 10.7 and 10.20 (pp. 573,586).The STATISTIX printout below shows both a 95% prediction interval for y (left side) and a 95% confidence interval for E(y) ..
|
|
How is the future value of a mixed stream of cash flows
: How is the future value of a mixed stream of cash flows calculated? How is the present value of a mixed stream of cash flows calculated?
|
|
Difference between a pretest loop and a posttest loop
: Describe the difference between a pretest loop and a posttest loop.
|
|
Calculate the elasticity of demand for joy beer
: 1. Should PJ be increased or decreased to maximize revenue? How do you know? 2. Calculate the elasticity of demand for Joy's beer with respect to PC, T, and AC. 3. Calculate the price range over which the demand for Joy's beer is price elastic.
|
|
Accountants in cost analysis to shed light
: Multiple regression is used by accountants in cost analysis to shed light on the factors that cause costs to be incurred and the magnitudes of their effects. The independent variables of such a regression model are the factors believed to be relat..
|
|
Why is the present value of a perpetuity
: What is a perpetuity? Why is the present value of a perpetuity equal to the annual cash payment divided by the interest rate?
|
|
Refer to the journal of applied ecology study
: Refer to the Journal of Applied Ecology study of the feeding habits of baby snow geese, Exercise 10.11 (p. 577).The MINITAB printout for the model relating weight change (y) to digestion efficiency (x1) and acid detergent fiber (x2) is reproduced ..
|
|
Ppf and gain from trade
: Which theory explains that if countries specialize in the production of the good/service in which they have a comparative advantage, then all countries can move outside their PPF and gain from trade.
|
|
Illinois managers using a regression analysis
: Much research-and much litigation-has been conducted on the disparity between the salary levels of men and women. Research reported in Work and Occupations (Nov. 1992) analyzes the salaries for a sample of 191 Illinois managers using a regression ..
|