Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

M9.7. The finished goods inventory of a small manufacturing company is shown below (available in data file for Module 9). Perform an ABC analysis on

image text in transcribed
image text in transcribed
M9.7. The finished goods inventory of a small manufacturing company is shown below (available in data file for Module 9). 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%).) SKU Code 1021 1204 1448 2144 2282 2456 2698 3129 3141 3310 3312 3712 3943 4351 4682 4683 4991 5231 5940 5995 6466 6912 7006 7060 Unit Value $ 125.00 $ 10.00 $ 12.00 $ 20.00 $ 17.00 $ 500.00 $ 25.00 $ 5.00 $ 2.00 S 1.00 $ 0.75 S 8.00 $ 1.50 $ 0.75 $ 3.00 $ 1.00 $1,500.00 $ 20.00 $ 110.00 S 50.00 $ 0.90 S 8.00 $ 45.00 S 3.00 Demand (units) 100 1,750 2,000 200 330 675 85 2,500 1,000 1,500 625 200 125 410 700 1,200 320 600 120 1,500 200 1,200 1,700 300 SMU > LZU 5995 6466 6912 7006 7060 7087 7670 8101 8447 8989 9034 s $ $ S $ $ $ S 50.00 0.90 8.00 45.00 3.00 4.00 2.00 10.00 7.00 6.00 4.00 1,500 200 1,200 1,700 300 800 75 6,000 S $ 800 500 1,500 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: 24567 59952 89897 9034? M9.8 Submit Excel file with solution for M9.7 using Inventory Calculations Template worksheet as demonstrated and formatted in videos. No credit for M9.7 unless this Excel file is submitted

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_2

Step: 3

blur-text-image_3

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

Corporate Fraud Prevention And Detection

Authors: Joseph T. Wells

5th Edition

1119351987, 9781119351986

More Books

Students also viewed these Accounting questions

Question

2. Prevent fights by avoiding crowded work spaces.

Answered: 1 week ago