Question
Purchasing department cost drivers, activity-based costing, simple regression analysis. Perfect Fit operates a chain of 10 retail department stores. Each department store makes its own
Purchasing department cost drivers, activity-based costing, simple regression analysis. Perfect Fit operates a chain of 10 retail department stores. Each department store makes its own purchasing decisions. Carl Hart, assistant to the president of Perfect Fit, is interested in better understanding the drivers of purchasing department costs. For many years, Perfect Fit has allocated purchasing department costs to products on the basis of the dollar value of merchandise purchased. A $100 item is allocated 10 times as many overhead costs associated with the purchasing department as a $10 item.
Hart recently attended a seminar titled Cost Drivers in the Retail Industry. In a presentation at the seminar, Kaliko Fabrics, a leading competitor that has implemented activity-based costing, reported number of purchase orders and number of suppliers to be the two most important cost drivers of purchasing department costs. The dollar value of merchandise purchased in each purchase order was not found to be a significant cost driver. Hart interviewed several members of the purchasing department at the Perfect Fit store in Miami. They believed that Kaliko Fabrics conclusions also applied to their purchasing department.
Hart collects the following data for the most recent year for Perfect Fits 10 retail department stores:
10.5-11 Full Alternative Text
Hart decides to use simple regression analysis to examine whether one or more of three variables (the last three columns in the table) are cost drivers of purchasing department costs. Summary results for these regressions are as follows:
Regression 1: PDC=a+(bMP$)
Variable | Coefficient | Standard Error | t-Value |
---|---|---|---|
Constant | $1,041,421 | $346,709 | 3.00 |
Independent variable 1: MP$ | 0.0031 | 0.0038 | 0.83 |
r2=0.08; Durbin-Watson statistic=2.41 |
Regression 2: PDC=a+(bNo. of POs)
Variable | Coefficient | Standard Error | t-Value |
---|---|---|---|
Constant | $722,538 | $265,835 | 2.72 |
Independent variable 1: No. of POs | $159.48 | $64.84 | 2.46 |
r2=0.43; Durbin-Watson statistic=1.97 |
Regression 3: PDC=a+(bNo. of Ss)
Variable | Coefficient | Standard Error | t-Value |
---|---|---|---|
Constant | $828,814 | $246,571 | 3.36 |
Independent variable 1: No. of Ss | $3,816 | $1,698 | 2.25 |
r2=0.39; Durbin-Watson statistic=2.01 |
Compare and evaluate the three simple regression models estimated by Hart. Graph each one. Also, use the format employed in Exhibit 10-19 (page 399) to evaluate the information.
Do the regression results support the Kaliko Fabrics presentation about the purchasing departments cost drivers? Which of these cost drivers would you recommend in designing an ABC system?
How might Hart gain additional evidence on drivers of purchasing department costs at each of Perfect Fits stores?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started