Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 WStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started