For this assignment, fill in the attached Excel spreadsheet for ABC Restaurant using the information provided on the sheet and that you reviewed in the Par Stock module this week. Once you have completed the math portion, answer the following questions:

1. What value to the operation is the par stock information?
2. How often or under what circumstances should a par stock sheet be conducted?
3. What departments, other than the FOH need the information from the par stock sheet? Why would these additional departments need this information? What would these additional departments do with the information?

A B D E F G H L | Popularity Percentage Menu Item Total Covers ooooo Covers to Produce Plate Size Par Amount to Order Daily Use in cases Safety in Cases Actual Order Amount Amount on Hand Case Size wicker basket wicker basket wicker basket 5 inch plate 0 wooden bowl wooden bowl wooden bowl wooden bowl wooden bowl 0 0 O O o od 1 2 App 1 3 App 2 4 App 3 5 App 4 6 7 Salad 1 8 Salad 2 9 Salad 3 10 Salad 4 11 Salad 5 12 13 Soup 1 14 Soup 2 15 Soup 3 16 Soup 4 17 Soup 5 18 19 Entre 1 20 Entre 2 21 Entre 3 22 Entre 4 23 Entre 5 24 Entre 6 25 Entre 7 26 Entre 8 27 Entre 9 crock crock bowl bowl bowl 0 0 0 0 0 0 od 7 inch oval 7 inch oval 7 inch oval 8 inch round 9 inch oval 10 inch plate 10 inch plate 10 inch plate 11 inch plate OOOO 28 B D Menu Item 1 number 8o A sold Seats: 150 Tunrover: 3.1 Occ % = 87% 27 35 70 56 62 2 App 1 3 App 2 4 App 3 5 App 4 6 7 Salad 1 8 Salad 2 9 Salad 3 10 Salad 4 11 Salad 5 12 13 Soup 1 14 Soup 2 15 Soup 3 16 Soup 4 17 Soup 5 18 19 Entre 1 20 Entre 2 21 Entre 3 22 Entre 4 23 Entre 5 24 Entre 6 25 Entre 7 26 Entre 8 27 Entre 9 35 38 47 54 42 68 78 81 50 54 69 70 80 55 28 A B D E F G H L | Popularity Percentage Menu Item Total Covers ooooo Covers to Produce Plate Size Par Amount to Order Daily Use in cases Safety in Cases Actual Order Amount Amount on Hand Case Size wicker basket wicker basket wicker basket 5 inch plate 0 wooden bowl wooden bowl wooden bowl wooden bowl wooden bowl 0 0 O O o od 1 2 App 1 3 App 2 4 App 3 5 App 4 6 7 Salad 1 8 Salad 2 9 Salad 3 10 Salad 4 11 Salad 5 12 13 Soup 1 14 Soup 2 15 Soup 3 16 Soup 4 17 Soup 5 18 19 Entre 1 20 Entre 2 21 Entre 3 22 Entre 4 23 Entre 5 24 Entre 6 25 Entre 7 26 Entre 8 27 Entre 9 crock crock bowl bowl bowl 0 0 0 0 0 0 od 7 inch oval 7 inch oval 7 inch oval 8 inch round 9 inch oval 10 inch plate 10 inch plate 10 inch plate 11 inch plate OOOO 28 B D Menu Item 1 number 8o A sold Seats: 150 Tunrover: 3.1 Occ % = 87% 27 35 70 56 62 2 App 1 3 App 2 4 App 3 5 App 4 6 7 Salad 1 8 Salad 2 9 Salad 3 10 Salad 4 11 Salad 5 12 13 Soup 1 14 Soup 2 15 Soup 3 16 Soup 4 17 Soup 5 18 19 Entre 1 20 Entre 2 21 Entre 3 22 Entre 4 23 Entre 5 24 Entre 6 25 Entre 7 26 Entre 8 27 Entre 9 35 38 47 54 42 68 78 81 50 54 69 70 80 55 28