Premium Essay

Questions for Store24 a and B Cases

In: Business and Management

Submitted By Witmaster2
Words 870
Pages 4
Questions for Store24 A and B Cases

The data required for these cases is in the file Store24AB.xls. You can find the data files at the bottom of the course website: http://www.buec.udel.edu/kherh/BUAD820_Class_15.html

Summary Statistics: Definitions of the different variables in the data are provided in the case itself. Briefly discuss the summary statistics presented in Exhibit 3 in Store24A and Exhibit 2 in Store24B. Use a maximum of 2 slides for this discussion. In your team’s opinion, what do the summary statistics tell us about Store24?

Doucette wants to decide whether or not to put an employee retention program in place. But first, he wants Sarah Jenkins to check whether manager tenure and crew tenure are related to store profit. Accordingly, run the three regression models per instructions given below; data for these 3 models is in the worksheet labeled Data for Case A.

Model 1: Run a full model for profit that includes both tenure and site location related variables. Tenure related variables are MTenure and CTenure. Site location related variables are population, number of competitors, street level visibility, pedestrian access, type of neighborhood, and whether a store stays open 24 hours. These variables are also defined on page 4 of the case Store24 (A). For categorical variables, be sure to use dummy variables for this and remaining models.

Question
Interpret the coefficients for MTenure and CTenure in model 1. Which of the two variables contributes more to profits (i.e. which one has a greater $ impact)?

A common way of determining the relative importance of two independent variables is by assessing the incremental r-squared attributable to that variable. The following two models (Models 2 and 3) allow us determine the relative importance of manager and crew tenure in predicting profits at Store24.

Model 2: Run a

Similar Documents

Premium Essay

Store 24

...Questions for Store24 A and B Cases The data required for these cases is in the file Store24AB.xls. Summary Statistics: Definitions of the different variables in the data are provided in the case itself. Briefly discuss the summary statistics presented in Exhibit 3 in Store24A and Exhibit 2 in Store24B. Use a maximum of 2 slides for this discussion. In your opinion, what do the summary statistics tell us about Store24? Doucette wants to decide whether or not to put an employee retention program in place. But first, he wants Sarah Jenkins to check whether manager tenure and crew tenure are related to store profit. Accordingly, run the three regression models per instructions given below; data for these 3 models is in the worksheet labeled Data for Case A. Important note: For all regression models, use a 5% significance level Model 1: Run a full model for profit that includes both tenure and site location related variables. Tenure related variables are MTenure and CTenure. Site location related variables are population, number of competitors, street level visibility, pedestrian access, type of neighborhood, and whether a store stays open 24 hours. These variables are also defined on page 4 of the case Store24 (A). Question Interpret the coefficients for MTenure and CTenure in model 1. Which of the two variables contributes more to profits (i.e. which one has a greater $ impact)? A common way of determining the relative importance of two independent...

Words: 782 - Pages: 4

Premium Essay

Store 24

...Case 2 Store 24 Maastricht University, School of Business and Economics Course: Management Control EBC 4154 Introduction Most of the executives of Store24, a New England based convenience store, were gathered for an important meeting to discuss a way to increase store level employees retention. Some of the suggestions were to increase wages and bonuses, training enhancements or career development programs. However, top management lacked sufficient information available that would explained the relationship between manager and crew tenure on store level financial performance. Hence, the purpose of this paper is to shed light on the “employee tenure-store level performance” relationship as well as to discover how managerial skill, service quality and profit are related. 1. The Relationship between Employee Tenure and Operating Performance Before exploring the relationship between store level financial performance and other relevant site factors, it is essential to establish a measure for store level performance. Internal analysis collected sales and profit data for 75 stores. Based on Appendix A, one can conclude that these variables are highly correlated and significant (i.e. r = 0,924, p-value = 0,000) Ultimately, profit is used as a proxy for store level performance, since it takes into account both, the costs as well as the revenues of making the sales. Despite the lack of objective evidence on the importance of employee tenure, Store24 has awarded managers...

Words: 2836 - Pages: 12

Premium Essay

Excel Errors

...spreadsheets b) Lack of disciplined development practices is one of the most common reasons why spreadsheet contains errors. Many organization has policies in general about end user development in general, much less spreadsheet development c) Many developers build the models and hardwire it to one end result they are working without considering the constraints or different possible scenarios. This ultimately leads to the fact that the model doesn’t work for any other input variables other than the one that is being used to. d) Another common reason of spreadsheet errors is due to the overconfidence of the developers in the accuracy of the spreadsheets. They don’t spend time to test the spreadsheet for any possible errors e) We could also say innocence (in a sense of not knowing the excel capabilities) as one of the common reasons why spreadsheets has errors, people tend to learn from friends and coworkers without any proper training on Excel and its capabilities which ultimately lead in unstructured spreadsheet development 2. Why these errors are typically not detected? a) Primary reason for missing out these errors is that there is no adoption of the standard development cycle phases, many developers directly jump in and do the development without putting any thoughts and scenarios and once the development is done there is very little or no effort put in to test what is developed with different decision parameters. b) Secondly since...

Words: 1657 - Pages: 7