Question: Use the data in the table below to determine the ABC classification by the cost of items. Use the criterion of 80% cumulative for category

Use the data in the table below to determine the

Use the data in the table below to determine the ABC classification by the cost of items. Use the criterion of 80% cumulative for category A, over that and up to 95% cumulative for category B, and the remainder for category C. a) Which are the first 3 items in each category? (Value: 15% of total grade). b) How many items belong to each category? (Value: 15% of total grade). Cost Demand [$/u] [u/year] Demand Item Cost [$/u] [u/year] Item 1 28.48 811 11 17.02 658 2 14.8 1134 12 9.19 746 3 6.36 881 13 36.94 494 4 6.72 854 14 36.44 669 5 2.92 823 15 16.16 724 6 83.02 350 16 3.33 825 7 61.83 680 17 19.54 1036 8 90.36 929 18 58.56 874 9 83.74 1058 19 26.53 557 10 58.53 467 20 92.95 499

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

At t = 0 a sealed test tube containing a chemical is immersed in a liquid bath. The initial temperature of the chemical in the test tube is 80 F. The liquid bath has a controlled temperature...

please use excel and show how to do The table below contains supply chain data for a batch of parts from a warehouse. They need to be classified into three buckets: High Sales Value (A), Medium Sales...

I want you to summerize these 7 items. !Please be different from other answers! !Please get a little quick! Thanks. You should summarize the 7 items in the photo. Max 125 words! reading 1....

45 Problem 5: (15 points) The warehouse manager at Malik's Library is interested in studying their inventory more carefully. Therefore, this manager is asking for your help to determine an ABC...

Spend Analysis Item List Appendix A Item Description Annual Usage Qty / unit Unit Price Syringes, disposable, 1 0 cc 7 0 0 cs / 4 0 0 $ 1 4 0 . 0 0 / cs Needle, single sample, 2 1 G 2 , 2 0 0 cs / 1...

I need help for those question . E4.16 E18.4 E19.7 P22.4 E23.4 E18.10 E22.10 CHAPTER 4 EXERCISES: SET B E4-1B The trial balance columns of the worksheet for Lamar Company at June 30, 2017, are as...

Chapter 12 - Inventory Management (Part 1) Determine an A-B-C classification for these items: Which items are A, B, and C - explain how you derive the answers? Use a table or excel spreadsheet to...

Please explain steps!? Chapter 12 - Inventory Management Determine an A-B-C classification for these items: Which items are A, B, and C - explain how you derive the answers? Use a table or excel...

Determine an A-B-C classification for these items: Which items are A, B, and C - explain how you derive the answers? Use a table or excel spreadsheet to illustrate your work. Item Unit Cost Annual...

Chapter 1 2 - Inventory Management ( Part 1 ) Determine an A - B - C classification for these items: Which items are A , B , and C - explain how you derive the answers? Use a table or excel...

Determine an A - B - C classification for these items: Which items are A , B , and C - explain how you derive the answers? Use a table or excel spreadsheet to illustrate your work. \ table [ [ Item...

In trying to move across a slippery icy surface, a 175-lb man uses two ropes AB and AC. Knowing that the force exerted on the man by the icy surface is perpendicular to that surface, determine the...

A stock has an expected return of 17 percent, its beta is 1.45 and the risk-free rate is 5.5 percent. What must the expected return on the market be?

Which of the following is a criteria used for classifying a lease as a finance lease? Select one: a . The agreement contains a purchase option for the underlying asset that the lessee is not...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...