Dollar amounts must be rounded to 2 decimal places and include a dollar sign. You may include the first chart in your submission.

Student ID : 152289195

1. Complete the following chart. The number of Chicken Wings sold is the last 3 digits of your student ID number. The menu price of the Brisket, Back Ribs, Smoked Turkey and Chicken Wings are the first 4 digits of your student number. Divide the first 4 digits by 100 to convert it into a dollar amount. (12 Marks)

Menu Item	Number Sold	Menu Mix %	Menu Price $	Item Food Cost	Item CM	Gross Margin	CM Category	MM% Category	Classification
Brisket	403		$	$ 2.96
Back Ribs	597		$	$ 5.17
Smoked Chicken	310		$14.25	$ 3.84
Fish Tacos	456		$16.25	$ 4.78
Smoked Turkey	398		$	$ 2.90
Chicken Wings			$	$ 2.42
Total
		Average Menu Mix % = (1/#items) x 70%				Avg CM =

2. Once you have classified each menu item from part 1, explain what actions should be taken with each item and why. I recommend graphing each item (as was shown in the week 7 session) to help you. (18 Marks)