Question: The items used in a small restaurant are given in the Inventory Data Download Inventory Data file. Perform an ABC analysis on the data
- The items used in a small restaurant are given in the "Inventory DataDownload Inventory Data" file. Perform an ABC analysis on the data (Assign A items to a maximum of 70 % of the cumulative value and B items to a maximum of the next 20% of the cumulative value (a total of 90%).)
a) How many items are assigned as "A" items?
b) How many items are assigned as "B" items?
c) How many items are assigned as "C" items?
d) What assignment was made to the following items: Chicken, Lobster tail, Pasta, and Tablecloths.


INVEHtDl'f Item SValue per case lDrdered per week Napkins 12 164 Lobster tail 245 156 Rib eye steal-c 135 156 Lettuce {case} 35 1246 Eggs {case} 22 364 Oil 26 1 64 Tomato sauce 23 5?2 Chickens T5 ?26 Tablecloths 32 266I Sugar 4 164 Salt 3 1 64 French fries 43 1664 Bacon 56 266| Trash can liners 12 156 Garlic powder 11 156 Fish lets 143 526I Order pad s 1 2 1 64 Pepper 3 156 Pasta 23 624 Prime rib 166 312 W
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
