Need help with this case study. I just don't have time. There isn't a specific page limit - just answers to the questions on the attached Word document.
Questions for Case Study III 1. Per the average product sales demographic per store outlined on page 2 of the case study, how was the Ban Boredom strategy intended to enhance financial performance of each store? Analytically, using the data in Exhibit 4, perform a single regression analysis between Future Controllable Contribution and the Ban Boredom Score? In terms of gauging the intended financial performance of the strategy what should be your expectation for such an analysis? Did your analysis meet this expectation? If not, what might be some of the financial reasons why the strategy is not effective? 2. How was the Companies implementation strategy different between the Ban Boredom Strategy and the Cause You Just Can’t Wait Strategy? (See page 3). Do you feel the companies approach was appropriate for each? Based on the high reliance on Crew and Mgr. Skill in successfully implementing the Ban Boredom Strategy, perform a regression analysis and compare each against the Ban Boredom strategy, does your analysis support the company expectation? How does Cause You Just Can’t Wait Strategy influence Crew Skill and the success of Ban Boredom? 3. Prepare a multiple regression analysis using the data in Exhibit 4 and split the stores based on those stores with a Crew Skill above the Median, and those below. How do the results differ and what may this indicate regarding the success of the strategy? For those stores with a relatively low Crew Skill what might you implement to enhance these skills? 4. Comment on the company’s use of the balance scorecard to evaluate employee performance and identify operational improvements. How was the variable compensation of store management linked to financial performance, do you feel this is a solid plan, what might you do to enhance it? 5. Perform a regression analysis comparing Future Controllable Contribution with population, per captia income and number of competitors. What does this analysis indicate? Given the fact that 30 of the 75 stores are located in urban areas and the average rent on a 2,100 square foot store is $49,000, how might this analysis influence how the company negotiates with landlords, and how changing geographic store locations could enhance performance? Due Date: Sheet1 Store #Futrure Controllable ContributionCYJCW ScoreBan Boredom ScoreCrew SkillManager SkillPopulationIncome CompetitorsY^YY^ 1510$23,00084.9371.432.352.217,754$27,0846 1711$25,41988.875.002.872.528,966$47,7122 1514$21,16495.41117.862.933.8521,550$22,9354 1507$24,63795.4285.713.094.2316,926$25,7445 1513$22,69583.2892.863.102.4116,381$38,2521Y^ = b0 + b1*X1 + b2*X2+b3*X3+b4*X4+B5*X5+b6*X6 1709$22,31491.3778.573.103.6313,297$17,3087 1710$22,27396.36117.863.204.1619,808$34,3333 1573$22,73478.6367.863.234.0414,859$8,1825 1579$18,87192.85121.432.802.5910,532$8,1817 1577$18,00783.93121.432.853.283,747$18,0363 1586$17,87490.59135.712.883.123,014$22,3843 1544$20,20096.56135.712.893.0710,923$32,0423 1515$17,89788.93128.573.102.8111,160$14,5897 1704$20,88696.65125.003.113.523,151$18,1983 1537$21,37395.86125.003.163.951,116$23,0562 1598$38,57387.1467.863.343.2119,809$23,5506 1512$44,14192.2114.293.372.8526,519$29,4116 1543$43,36485.91119.933.633.578,177$10,7464 1558$40,40390.5882.143.643.4320,624$18,8507 1702$43,22290.14110.714.053.713,265$18,1976 1570$46,30892.19110.714.203.173,126$55,4161 1568$40,57681.7478.574.382.6914,653$52,8213 1560$47,45396.19135.713.273.617,808$21,0343 1503$42,77682.14128.573.283.49,695$15,0914 1546$44,59988.75125.003.443.553,218$18,4674 1516$45,93695.48128.573.633.9114,186$14,1535 1547$44,05490.63125.003.653.338,870$15,2794 1542$42,12879.67128.573.683.079,697$12,2585 1517$45,48191.28135.713.803.666,898$15,7496 1566$46,28094.79128.574.403.428,491$12,3884 Questions for Case Study III 1. Per the average product sales demographic per store outlined on page 2 of the case study, how was the Ban Boredom strategy intended to enhance financial performance of each store? Analytically, using the data in Exhibit 4, perform a single regression analysis between Future Controllable Contribution and the Ban Boredom Score? In terms of gauging the intended financial performance of the strategy what should be your expectation for such an analysis? Did your analysis meet this expectation? If not, what might be some of the financial reasons why the strategy is not effective? 2. How was the Companies implementation strategy different between the Ban Boredom Strategy and the Cause You Just Can’t Wait Strategy? (See page 3). Do you feel the companies approach was appropriate for each? Based on the high reliance on Crew and Mgr. Skill in successfully implementing the Ban Boredom Strategy, perform a regression analysis and compare each against the Ban Boredom strategy, does your analysis support the company expectation? How does Cause You Just Can’t Wait Strategy influence Crew Skill and the success of Ban Boredom? 3. Prepare a multiple regression analysis using the data in Exhibit 4 and split the stores based on those stores with a Crew Skill above the Median, and those below. How do the results differ and what may this indicate regarding the success of the strategy? For those stores with a relatively low Crew Skill what might you implement to enhance these skills? 4. Comment on the company’s use of the balance scorecard to evaluate employee performance and identify operational improvements. How was the variable compensation of store management linked to financial performance, do you feel this is a solid plan, what might you do to enhance it? 5. Perform a regression analysis comparing Future Controllable Contribution with population, per captia income and number of competitors. What does this analysis indicate? Given the fact that 30 of the 75 stores are located in urban areas and the average rent on a 2,100 square foot store is $49,000, how might this analysis influence how the company negotiates with landlords, and how changing geographic store locations could enhance performance? Due Date: