Verified Document

Data Analysis Retail Case Essay

Management The five management programs have the same common dependent variables. These are the average turnover, the weekly profit and the monthly staff time cost. The independent variable for this experiment is the management system that is used. There are five different management systems that are being used at the company, and they differ in their methods. The data presented show the impact of the different management systems on the different output measures (dependent variables).

The wild card is the type of store data. The company investigated this using three store categories, and presented its findings, but they were not presented with statistical analysis. As such, they should not be considered to be an independent variable.

Outcome variables are the dependent variables.. Ultimately, for this company the variables should reflect a wider variety of output measures for each store. . The output variables should be related to the success measures. First, it is important to measure the different levels of profit, not just net profit. This will provide more refined data and will allow management to be sure that the net profit figures are related to the management system.

Turnover is already a dependent variable, and are staff time costs, but if turnover is higher that implies that there are more new employees who are working. They are less efficient, and having higher training costs. I would like to capture the full set of costs for this turnover. There may be a point where the decision is made weighing turnover versus sales, and management will need to know what a basis point of turnover is worth. So capturing things like recruiting and training costs is important for the company, to help make that sort of decision.

The weekly profit is something that has to be compared to a baseline. Thus, I would want to capture the change in weekly profit. Right now, the company reports the weekly profit, but it is also known that there are differences in store composition for the different management types. Thus, it is important to know whether the high performing stores are the ones that were always the high performing stores. The change in profit before and after the new management system is actually more important than just knowing the amount of profit, because the experiment needs to compare current results with prior results.

Other measures related to performance are also worth measuring. For example, in retail the sales per square foot is a critical output measure (Investopedia, 2015), and sales per employee is another. These both can be captured with the data that the company has available. By capturing this data, differences between the high profit stores and low profit stores can be smoothed out.

I would also want to know what stores were performing the best in terms of the high margin goods. There should be a way to operationalize this variable, though it may well be captured with an average ticket metric. The average ticket metric is another common retail metric -- knowing how much each customer buys, on average, helps to information management about whether it is capturing higher margin goods, and in particular the impulse goods that increase the average ticket. If the average profit/ticket can be determined, that might also shed light as to which stores are doing a better job on moving high margin items.

Inventory turnover metrics are also worth examining, and refined data on product categories would be important. Basically, once the successful stores have been identified, it is important for management to learn why those stores have become successful. The company is at the first stage -- trying to identify the successful stores -- but gathering more data, with more variables, will allow the company to apply the lessons that these stores are learning across stores. The reason that this is important is because right now there are many stores that are holding meetings and at each of these meetings they are brainstorming, then they test the ideas, and then at the end of all of this they find out what works. But each store is doing this independently. If head office starts to gather this information about what each store is doing right, and then sharing that information, then that will allow the organization to move more quickly to implement the best ideas system-wide. Otherwise, each store will have to learn each good idea on its own, which is haphazard, and does not leverage the benefit of being part of a large...

So to capture this data, management can do something like find out what its highest margin products are, and test what stores saw the biggest changes in turnover for those products. This may be one of the important keys to improving profitability.
An input measure has to be the economic growth rate in the region where the store is located. The stores using the different management systems tend to be located in different types of areas. For example, System I and II stores tend to perform poorly on the profit measures, but they are also in areas that are economically depressed. Their performances might actually be quite good relative to the poor economies in those areas, whereas stores that are in high growth areas might only see profit growth as a consequence of growing populations and incomes. In other words, management needs to understand whether the relative success or failure of a store is related to where it is located, rather than related to the management system that was put in place. The overall economy has to be controlled as an input variable, in order that the other input variable (the management system) is isolated.

The structure of the inquiry basically starts at the current level, but with more variables, especially outcome variables measured, the information becomes more refined so that not only is it understood which management system is better, but why it is better. The current level of inquiry is basically looking at correlations, but for management practice the above variables will help to identify causal factors.

3. There are two measures for each dependent variable -- the mean and the standard deviation. To determine which is best requires an understanding of which is more important, because there are trade-offs between these two. It is believed that a lower standard deviation is important because the company is working with tight margins. The standard deviation is important in that respect because companies with tight margins require a fair amount of cost and revenue certainty to ensure that they are consistently profitable. This is especially true in retail, where the company will typically have high fixed costs associated with operating a store.

For the average turnover, System V is the best. It has a mean of 20%, where System IV has a mean of 17%, but the standard deviation for System V is 12%, versus 20% for System IV. What this means is that while the mean is slightly higher, that figure is more reliable. If the company is considering whether or not a store can be reliably profitable, then it will need to have a higher level of cost certainty. As a manager looking at a go/no-go decision, the certainty afforded by System V would be beneficial. That said, if the store is assuming that all stores are going to remain open, then the lower average is probably the more important variable, which would mean that System IV is better.

It is worth considering that System IV and System V share some common elements. They both have brainstorming, and it is likely that since they are both among the best systems for having a lower turnover that the brainstorming is correlated with a generally low average turnover. The relationship between sharing information and turnover is one that is less clear, but a reasonable hypothesis is that sharing information is going to result in higher turnover, as such a system may not be popular with some employees.

The method that is the less effective at lowering the average turnover is System III. This method has the highest average turnover and the highest standard deviation. As such, its results are poor and in some cases they are exceptionally poor. Management oriented towards consistent profitability cannot take the risk of having a store with turnover rates of 57%, which is what is implied to be a part of System III. As such, System III delivers unacceptably poor results in terms of average turnover. At issue here is the fact that System III is most likely to be implemented at urban stores where the workers are younger. This would hint at the likelihood that turnover was always higher in those stores. This is why it was recommended above to capture the change in turnover, rather than just the turnover rates. Stores with younger workers are much more likely to have high turnover rates than stores with older workers. Indeed, System III may still have had the greatest reduction in turnover rates of any store -- but the company does not know this, given the data that…

Sources used in this document:
References

Investopedia (2015). Sales per square foot. Investopedia. Retrieved December 10, 2015 from http://www.investopedia.com/terms/s/sales-per-square-foot.asp

Taylor, C. (2015). What is a simple random sample? About.com. Retrieved December 10, 2015 from http://statistics.about.com/od/HelpandTutorials/a/What-Is-A-Simple-Random-Sample.htm

Baldwin, S. (2006). Organisational justice. Institute for Employment Studies. Retrieved December 10, 2015 from http://www.employment-studies.co.uk/system/files/resources/files/mp73.pdf

Hannan, M. & Freeman, J. (1984). Structural inertia and organizational change. American Sociological Review. Vol. 49 (2) 149-164.
Cite this Document:
Copy Bibliography Citation

Related Documents

Business Data Analysis - Writing
Words: 1089 Length: 4 Document Type: SWOT

3. SWOT Analysis The SWOT analysis reveals the strengths, weaknesses, opportunities and threats which are likely to affect the outcome of launching the electronic commerce at Blue Cut Fashion. The strengths and weaknesses derive from internal features and amongst others, may refer to financial highlights and previous expertise. The opportunities and threats are generated by the external environment and may refer to commercial trends and technological advancements. All these are presented

Data Warehouse Case Study VF
Words: 1268 Length: 5 Document Type: Case Study

From Supply Chain Efficiency to Customer Segmentation Focus Because of this focus on supply chain forecasting accuracy and efficiency, the need for capturing very specific customer data becomes critical. The case study portrays the capturing of segmentation data as focused on growing each of the brands mentioned that VF relies on this data to base marketing, location development and store introductions, and pricing strategies on. In reality, the data delivered for

Data Warehouse a Strategic Weapon of an Organization
Words: 10375 Length: 38 Document Type: Term Paper

Data Warehousing: A Strategic Weapon of an Organization. Within Chapter One, an introduction to the study will be provided. Initially, the overall aims of the research proposal will be discussed. This will be followed by a presentation of the overall objectives of the study will be delineated. After this, the significance of the research will be discussed, including a justification and rationale for the investigation. The aims of the study are to

Data and Retail a Case Study With Amazon
Words: 889 Length: 3 Document Type: Research Paper

Measures Targets Initiatives Profitable Growth Return on Invested Capital Return on Equity Only accept strong NPV projects 15% ROIC 20% ROE Simplify the organization structure Provide an open environment for idea generation and brainstorming Industry leading innovation Update product upgrade cycle. Refresh or introduce a product at least once every two years. Highest Quality products and services Higher Gross Margin Invest heavily in R and D with excess Free Cash Flow Establish strong customer and brand loyalty Adopt the net promoter score and customer satisfaction rating survey 4%

Data Warehouse a Strategic Weapon of an Organization
Words: 19027 Length: 50 Document Type: Term Paper

Growth Aided by Data Warehousing Adaptability of data warehousing to changes Using existing data effectively can lead to growth Uses of data warehouses for Public Service Getting investment through data warehouse Using Data Warehouse for Business Information Ongoing changes in Data Warehousing The Origin of Data Warehousing and its current importance Relationship between new operating system and data warehousing Developing Organizations through Data Warehousing Telephone and Data Warehousing Choose your own partner Data Warehousing for Societal Causes Updating inaccessible data Data warehousing for investors Usefulness

MCDONALD'S CASE ANALYSIS REPORT Case
Words: 2309 Length: 8 Document Type: Case Study

These core competencies are the focus of the recommendations given to McDonald's for the resolution of the described problems. By striving to improve their core competencies, McDonald's will be able to improve the customer service they offer to customers considerably as well as to satisfy their customers better Hammer & Stanton, 1999() Improving production consistency The big secret behind the success of McDonald's is that the company has long strived to

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now