1 Given the following inventory information, perform an ABC analysis for the ten items shown Fill in the blank spaces in the charts below (Round your calculations to 2 decimal places ) Please show all of your calculations This way you may receive partial marks even though your answers may be incorrect Item No Unit Cost ($) Annual Usage Annual Dollar Usage of Total Annual $ Usage Inventory Class T604 65 00 400 J125 5 40 4600 Y321 31 50 600 Y633 3 50 3500 X221 1 65 5500 M455 5 25 1500 L242 1 05 1400 K966 0 29 3800 B886 6 43 118 W985 0 73 810 Totals XXXXXX XXXXXX XXXXXXX of Total Annual $ usage by class Class A items Class B items Class C items

The Answer is in the image, click to view ...

Question: 1.Given the following inventory information, perform an ABC analysis for the ten items shown. Fill in the blank spaces in the charts below. (Round your

1.Given the following inventory information, perform an ABC analysis for the ten items shown. Fill in the blank spaces in the charts below. (Round your calculations to 2 decimal places.) Please show all of your calculations. This way you may receive partial marks even though your answers may be incorrect.

Item No.	Unit Cost ($)	Annual Usage	Annual Dollar Usage	% of Total Annual $ Usage	Inventory Class
T604	65.00	400
J125	5.40	4600
Y321	31.50	600
Y633	3.50	3500
X221	1.65	5500
M455	5.25	1500
L242	1.05	1400
K966	0.29	3800
B886	6.43	118
W985	0.73	810
Totals:	XXXXXX	XXXXXX			XXXXXXX

	% of Total Annual $ usage by class
Class A items
Class B items
Class C items

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!

Between 2008 and 2018 more than 420,000 runners have completed the Chicago Marathon. The attached data file contains a sample of 500 runners selected from this time period. Based on this data answer...

Hi! I need help with this exercise... how I can resolve this exercise step by step. thanks! 1. Given the following inventory information, perform an ABC analysis for the ten items shown. Fill in the...

Case Study MGTS - 3 5 2 ( CC 0 1 ) Instructions 1 . Answer questions 1 , 2 , 3 , 4 , and 5 . 2 . Present your answers as a 3 - page ( maximum ) report explaining what you did and why. 3 . Include...

Task 1 - Inventory Management & Control Frank's Fasteners a leading company based in UK, which makes industrial fasteners has the following average annual inventory level, as given in Table T1a. To...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

An Investigation into obesity rates Researchers have been interested in studying the obesity trends worldwide over the past 25 years. In 2014 the World Health Organization (WHO) declared there were....

Could you finish this for me? I made it to page 5, but I am running short on time and my conceptualization is lacking. If not, maybe help me figure it out? Annual Report Project Lowe's Companies,...

Top Detergent (M) Sdn. Bhd. has produced the Original budget for its new product, Blooming Pleasure, to be launched in 2022. The customer that product targets is rich or affluent segment. Based on...

Calm Ltd is preparing to set up business on 01/07/2016 and has made the following forecast for the first six months of trading: July 420,000 444,000 580,000 Purchases 180,000 220,000 260,000 August...

A bond's coupon rate will change as interest rates change so the bond price stays the same. True R False

Using the concepts of efficiency, effectiveness, invention, and innovation, why the following technology prediction missed the mark? 1. "Nuclear powered vacuum cleaners will probably be a reality...