ABC Analysis Cycle Counting Program and Replenishment Rates Assignment

User Generated

ununf123

Business Finance

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...

Related Tags