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?