solution

The ABC analysis is used to help determine critical inventory and replenishment rates. This week we are going to 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 (use food items for this analysis). 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.