Water Pursuits operates a chain of 10 retail surf and water sport apparel stores in Western Australia. Each store makes its own purchasing decisions. Vijay Krishnan, Chief Operating Officer of Water Pursuits, is interested in better understanding the drivers of the Purchasing Departments costs. For many years, the Purchasing Departments' costs have been allocated to products on the basis of the dollar value of merchandise purchased. Vijay recently attended a training seminar conducted by Retail Traders Association of WA and CPA Australia, titled "Cost Drivers in the Retail Industry". In a presentation at the seminar, Top Hat Clothiers, a high fashion retailer 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. Enthralled, Vijay interviewed several members of the Purchasing Department at the Water Pursuits store in Fremantle. They believed that Top Hať's conclusions also applied to their Purchasing Department. Vijay collected the following data for the most recent year for Water Pursuits' 10 retail stores: Purchasing Department Costs Dollar Value of Number of Number Department Store merchandise purchase orders of purchased 2$ suppliers $ 1,523,000 $ 1,100,000 $ 298,315,000 2$ 4,457 4,550 2,333 5,944 4,196 2,127 5,286 Albany Margaret River Mandurah 132 122 173,456,000 $ 2$ 547,000 $ 2,049,000 $ 1,056,000 $ 81,160,000 68 Fremantle 219,566,000 2$ 255 Esperance 163,505,000 2$ 113 Broome 529,000 $ 1,538,000 $ 1,754,000 $ 1,612,000 $ 1,257,000 129,854,000 2$ 65 Mindarie 352,875,000 2$ 104 Jurien Bay 238,674,000 2$ 4,081 4,707 4,331 195 Geraldton 239,312,000 2$ 144 Exmouth 180,944,000 133 REQUIRED: Using EXCEL, estimate the simple regression equation for (i) Dollar Value of Merchandise Purchased, (ii) Number of Purchase Orders and (i) Number of Suppliers. а. b. From your results above, determine which is the most appropriate cost driver and explain your answer by referencing the appropriate statistical outputs.

Water Pursuits operates a chain of 10 retail surf and water sport apparel stores in Western Australia. Each store makes its own purchasing decisions. Vijay Krishnan, Chief Operating Officer of Water Pursuits, is interested in better understanding the drivers of the Purchasing Departments costs. For many years, the Purchasing Departments' costs have been allocated to products on the basis of the dollar value of merchandise purchased. Vijay recently attended a training seminar conducted by Retail Traders Association of WA and CPA Australia, titled "Cost Drivers in the Retail Industry". In a presentation at the seminar, Top Hat Clothiers, a high fashion retailer 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. Enthralled, Vijay interviewed several members of the Purchasing Department at the Water Pursuits store in Fremantle. They believed that Top Hať's conclusions also applied to their Purchasing Department. Vijay collected the following data for the most recent year for Water Pursuits' 10 retail stores: Purchasing Department Costs Dollar Value of Number of Number Department Store merchandise purchase orders of purchased 2$ suppliers $ 1,523,000 $ 1,100,000 $ 298,315,000 2$ 4,457 4,550 2,333 5,944 4,196 2,127 5,286 Albany Margaret River Mandurah 132 122 173,456,000 $ 2$ 547,000 $ 2,049,000 $ 1,056,000 $ 81,160,000 68 Fremantle 219,566,000 2$ 255 Esperance 163,505,000 2$ 113 Broome 529,000 $ 1,538,000 $ 1,754,000 $ 1,612,000 $ 1,257,000 129,854,000 2$ 65 Mindarie 352,875,000 2$ 104 Jurien Bay 238,674,000 2$ 4,081 4,707 4,331 195 Geraldton 239,312,000 2$ 144 Exmouth 180,944,000 133 REQUIRED: Using EXCEL, estimate the simple regression equation for (i) Dollar Value of Merchandise Purchased, (ii) Number of Purchase Orders and (i) Number of Suppliers. а. b. From your results above, determine which is the most appropriate cost driver and explain your answer by referencing the appropriate statistical outputs.

Water Pursuits operates a chain of 10 retail surf and water sport apparel stores in Western Australia. Each store makes its own purchasing decisions. Vijay Krishnan, Chief Operating Officer of Water Pursuits, is interested in better understanding the drivers of the Purchasing Departments costs. For many years, the Purchasing Departments' costs have been allocated to products on the basis of the dollar value of merchandise purchased. Vijay recently attended a training seminar conducted by Retail Traders Association of WA and CPA Australia, titled "Cost Drivers in the Retail Industry". In a presentation at the seminar, Top Hat Clothiers, a high fashion retailer 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. Enthralled, Vijay interviewed several members of the Purchasing Department at the Water Pursuits store in Fremantle. They believed that Top Hať's conclusions also applied to their Purchasing Department. Vijay collected the following data for the most recent year for Water Pursuits' 10 retail stores: Purchasing Department Costs Dollar Value of Number of Number Department Store merchandise purchase orders of purchased 2$ suppliers $ 1,523,000 $ 1,100,000 $ 298,315,000 2$ 4,457 4,550 2,333 5,944 4,196 2,127 5,286 Albany Margaret River Mandurah 132 122 173,456,000 $ 2$ 547,000 $ 2,049,000 $ 1,056,000 $ 81,160,000 68 Fremantle 219,566,000 2$ 255 Esperance 163,505,000 2$ 113 Broome 529,000 $ 1,538,000 $ 1,754,000 $ 1,612,000 $ 1,257,000 129,854,000 2$ 65 Mindarie 352,875,000 2$ 104 Jurien Bay 238,674,000 2$ 4,081 4,707 4,331 195 Geraldton 239,312,000 2$ 144 Exmouth 180,944,000 133 REQUIRED: Using EXCEL, estimate the simple regression equation for (i) Dollar Value of Merchandise Purchased, (ii) Number of Purchase Orders and (i) Number of Suppliers. а. b. From your results above, determine which is the most appropriate cost driver and explain your answer by referencing the appropriate statistical outputs.

MATLAB: An Introduction with Applications

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

How do I solve (a) & (b)?

Water Pursuits operates a chain of 10 retail surf and water sport apparel stores in
Western Australia. Each store makes its own purchasing decisions. Vijay Krishnan,
Chief Operating Officer of Water Pursuits, is interested in better understanding the
drivers of the Purchasing Departments costs. For many years, the Purchasing
Departments' costs have been allocated to products on the basis of the dollar value
of merchandise purchased.
Vijay recently attended a training seminar conducted by Retail Traders Association
of WA and CPA Australia, titled "Cost Drivers in the Retail Industry". In a
presentation at the seminar, Top Hat Clothiers, a high fashion retailer 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.
Enthralled, Vijay interviewed several members of the Purchasing Department at the
Water Pursuits store in Fremantle. They believed that Top Hat's conclusions also
applied to their Purchasing Department.
Vijay collected the following data for the most recent year for Water Pursuits' 10
retail stores:
Purchasing
Department
Costs
Dollar Value of
Number of
Number
Department
Store
merchandise
purchase
orders
of
purchased
$
suppliers
132
$ 1,523,000
$ 1,100,000
$
298,315,000
173,456,000
81,160,000
4,457
4,550
2,333
5,944
Albany
Margaret River
122
Mandurah
547,000
68
$ 2,049,000
$ 1,056,000
2$
Fremantle
$
219,566,000
$
255
163,505,000
129,854,000
352,875,000
$
Esperance
4,196
113
529,000
$ 1,538,000
$ 1,754,000
$ 1,612,000
$ 1,257,000
Broome
65
2,127
5,286
4,081
4,707
4,331
Mindarie
104
Jurien Bay
238,674,000
$
195
239,312,000
$
Geraldton
144
Exmouth
180,944,000
133
REQUIRED:
Using EXCEL, estimate the simple regression equation for (i) Dollar Value of
Merchandise Purchased, (ii) Number of Purchase Orders and (iii) Number of
Suppliers.
а.
b.
From your results
and explain your answer by referencing the appropriate statistical outputs.
determine which is the most appropriate cost driver

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Blurred answer

Similar questions

Recommended textbooks for you

MATLAB: An Introduction with Applications

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS