Description
The ABC analysis is used to help determine critical inventory and replenishment rates. Use Excel to build an ABC analysis and create a cycle counting program to determine replenishment rates. The steps for the assignment are below.
Perform an ABC analysis for a kitchen of an upscale restaurant in Excel. If you can't get that data, do it for your own kitchen at home. Create a cycle counting program for it.
Assignment format: Use an Excel sheet to build the ABC analysis and create the cycle counting program. No need to do a written analysis. Just do the worksheet.

Explanation & Answer

Attached.
Product
Freezer
Dessert plates
Salad plates
Oven
Range
Coffee brewer
Deep-Frier
chef's knives
Soup pots
Forks
Spoons
Shelving
Steam table
Spatulas
Tongs
Baking sheets
Mixing bowls
Sauce pans
Pizza peek
Whisks
cleaning buckets
Cleaning rags
Cost per u...
