Each year Joe reviews the financial information for all the CWWR stores. This past year was a
Question:
Each year Joe reviews the financial information for all the CWWR stores. This past year was a relatively good year; company profits were up despite the huge July Fourth fire in Las Vegas, Nevada, that shut down the store for four months and required replacements of all inventory. Joe did notice however that purchasing department costs varied considerably between stores. The minimum was $575, 000 and the maximum was $2.2 Billion. This was perplexing, and he thought this be an area where efficiencies could be achieved. Currently each store has its own purchasing department with full autonomy. In the western wear industry, regional customers have regional tastes and desires. Local purchasing agents are thought to be best able to understand the desires of local customers and to those needs.
On his management team, Joe has a managerial cost specialist with skills in data analytics. Together they discussed the purchase department cost problem and identified three potential cost drivers: merchandise purchased, number of purchase orders, and number of suppliers. To verify these ideas, Joe contracted purchasing managers from three different stores who agreed that these were potentially good cost drivers and they no others were readily apparent. The managerial cost specialist gathered the data for four variables from last year’s financial information and reported in Table 1. The data was also entered into an Excel spreadsheet (See appendix) By the team’s administrative assistant.
1. Prepare a statistical analysis of the costs provided.
A). Plot the purchase department cost vs. each cost driver (Graph per page)
B). Analyze the data for the potential problems, correct data problems if necessary and report any changes made.
C). Use the regression analysis to develop cost model for all potential cost drivers.
D). Identify the best model and explain why.
E). Explain what the model means from an economic perspective.
2. Use the model to make two recommendation to the CWWR management team for improving the efficiency of the purchasing operations Be specific with the details of the recommendations Estimate the cost saving from the implementation of your recommendations. Consider the secondary implications, quantitative and/or qualitative. Indicate how these changes (recommendations) should be implemented.
Discuss
1. What cost drivers are useful for predicting the purchasing departments costs? What is the recommended model? What does it mean? How can this model be used to reduce costs?
2. Does CWWR use a centralized or decentralized purchasing system? Why would the company use this strategy? Under what circumstances would a decentralized strategy be more valuable?
3. You developed recommendations, which are essentially are changes to human behavior. Is change in an organization easy? How can human behaviors be changed in a management setting?
Expert Answer:
X Variable Independent Variable Y VariableDependent variable X Variables Y Variable Merchandise Purchased Number of Purchase orders Number of supplier... View the full answer
