Question: ALSO, PLEASE PROVIDE CALCULATIONS' STEPS (Excel preferable) Hobby Mart Hobby Mart is a regional retailer focusing on serving hobby enthusiasts in the Mountain West region
ALSO, PLEASE PROVIDE CALCULATIONS' STEPS (Excel preferable)
Hobby Mart Hobby Mart is a regional retailer focusing on serving hobby enthusiasts in the Mountain West region of the U.S. The retail chain has 65 stores spread throughout 8 states. The chain prides itself as being a one-stop shop for hobbies such as woodworking, models, arts, and crafts. It also employs hobby specialists who can advise and instruct customers on products and techniques. Each store is run by a manager, who reports to the VP of operations in the central headquarters. Managers make most of the decisions for each store, including employee scheduling, inventory ordering, and most pricing decisions. Therefore, each store is operated as a profit center for evaluation purposes. Its mission statement is: "We will be an outstanding retailer serving the needs of the hobby enthusiast with both merchandise and expertise."
Hobby Mart operates 65 stores throughout its region. While individual store results change regularly, company-wide averages have been remarkably stable for the past several years. The company-wide averages are as follows:
| Company Average | |
| Profit Margin | 18% |
| Mystery Shopper | 90 |
| Inventory Turnover | 3.5 times |
| Rev/Employee Hr | $108.00 |
Past Performance for Store #17
| Profit Margin | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Target | 13% | 14% | 15% | 16% | 17% |
| Actual | 14% | 16% | 17% | 20% | 18% |
1) Profit Margin target for store #17 for Year 6?
Past Performance for Store #17
| Mystery Shopper | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Target | 82 | 83 | 84 | 85 | 86 |
| Actual | 85 | 84 | 86 | 88 | 87 |
2) Mystery Shopper target for store #17 for Year 6?
Past Performance for Store #17
| Inventory Turnover | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Target | 2.8 times | 2.9 times | 3.0 times | 3.1 times | 3.2 times |
| Actual | 2.9 times | 3.1 times | 3.0 times | 3.3 times | 3.3 times |
3) Inventory Turnover target for store #17 for Year 6?
Past Performance for Store #17
| Rev/Employee Hr | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Target | $96.00 | $98.00 | $100.00 | $102.00 | $104.00 |
| Actual | $97.50 | $99.75 | $104.00 | $103.50 | $106.00 |
4) Rev/Employee Hour target for store #17 for Year 6?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help