Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Based on the Teaching case Store24 (A): Managing Employee Retention by Frei and Campbell (2005). Please read the case (available on Blackboard) and analyse the

Based on the Teaching case Store24 (A): Managing Employee Retention by Frei and Campbell (2005). Please read the case (available on Blackboard) and analyse the given dataset. Notice that the dataset is different from the original dataset provided by the authors.

  1. Consider just the people factors (i.e., the tenures of manager and crew), what will be the dashboard summary (numerical and/or visual) of the data to highlight the possible relationship between tenures of manager and crew and store financial performance. What do you find?

  1. Conduct a multiple regression analysis with both people and locational factors (Eight independent variables in total). Show and interpret the regression results.

  1. Do you want to keep Visibility in your model? Why or why not? Refine your model if needed and show your results.

  1. Are the regression results consistent with your findings in Question 1 about people factors? Explain why the regression approach provides more reliable results comparing to the dashboard summary.

  1. Can we conclude that people factors lead to a store's financial success? What are some potential problems of your regression analysis?As the top management of Store24, what can you do to help your analytics team to solve these problems?

  1. Based on your latest regression model, estimate the annual profit of a store with the following attributes:

MTenure 6 months
CTenure 25 months
Pop 12,500
Comp 3
PedCount 3
Res Residential area
Hr24 No
Visibility 3

For this particular store, it is estimated that the cost will increase by roughly $50,000 per year if it opens 24/7. Will you advise the store to switch to 24/7? Why?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray Garrison, Eric Noreen, Peter Brewer

16th edition

1259307417, 978-1260153132, 1260153134, 978-1259307416

Students also viewed these General Management questions