Answered step by step
Verified Expert Solution
Link Copied!

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

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

image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting Volume 1

Authors: Thomas H. Beechy, Joan E. Conrod, Elizabeth Farrell, Ingrid McLeod Dick

7th Edition

1260306747, 978-1260306743

More Books

Students also viewed these Accounting questions

Question

45. A policeman is responsible for covering his territory.

Answered: 1 week ago

Question

When should you avoid using exhaust brake select all that apply

Answered: 1 week ago

Question

1 / ( s ^ 2 ( s - 1 ) )

Answered: 1 week ago