Question: Unit 5 Homework 9-10 (40 points): Perform an ABC analysis for the data provided in the table below Item Annual Usage Unit Cost 1 3,650

Unit 5 Homework 9-10 (40 points): Perform an ABC analysis for the data provided in the table below Item Annual Usage Unit Cost 1 3,650 $64.25 2 2.350 $76.35 3 1,050 $21.23 4 890 $42.13 5 4,520 $26.32 6 3,900 $7.60 7 2.450 $26.30 8 1,860 $33.20 9 3,120 $43.20 10 2.500 $24.20 11 1.900 $0.64 12 5,400 $0.65 13 3,560 $2.36 14 1.850 $11.45 15 950 $6,50 16 2.000 $11.23 17 3.500 $29.30 18 6,000 $30.20 19 2.450 $1230 20 1,300 $9.50 1. Consider the ABC classification cutoffs provided in the table below. ABC classification cutoffs A 80% B 90% C 100% 1. Create a table similar to the one below. Do not round intermediate calculations. Round your answers to two decimal places. 2. Projected Cumulative Cumulative Cumulative Dollar Usage Dollar Percent Percent ABC Item Annual Usage of Total of Items Classification $ $ $ $ $ $ 90 $ 26 96 96 $

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!

Unit 5 Homework 9-10 (46 points): Perform an ABC analysis for the data provided in the table below. Annual Usage Unit Cost 3,650 $64.25 2,350 $76.35 1,050 $21.23 890 $42.13 4,520 $26.32 3,900 $7.60...

Perform an ABC analysis for the data provided in in the table below. Item Unit Cost 1 Annual Usage 1,250 3,120 $26.32 2 $46.20 $34.20 3 940 4 $95.30 $10.36 5 6 $6.52 7 2,350 3,500 1,000 2,600 1,350...

Consider the ABC classification cutoffs provided in the table below. ABC classification cutoffs A 70% B 88% C 100% Complete the table below. Do not round intermediate calculations. Round your answers...

Perform an ABC analysis for the data provided in in the table below. Item 1 2 3 4 5 6 7 . 9 10 Annual Usage 1,560 3,650 4,230 1,450 1,560 3,900 1,300 2.500 4,100 2,670 1.680 2,500 4,600 3,510 1,860...

Perform an ABC analysis for the data provided in in the table below. Item Annual Usage Unit Cost 1 2,350 $76.45 2 5,560 $24.45 3 1,700 $86.14 4 2,300 $76.00 5 1,800 $76.23 6 4,520 $95.36 7 3,900...

Perform an ABC analysis for the data provided in in the table below. Item Annual Usage Unit Cost 1 3,530 1,450 3,500 $46.25 $62.30 2 3 $12.36 4 860 $24.12 5 $85.60 $94.30 6 7 $42.30 8 6,500 2,560...

perform an ABC analysis for the data provided in the table below. ABC classification cutoffs: A - 70% B - 90% C - 100% complete the table below. Do not round intermediate calculations. Round your...

Perform an ABC analysis for the data provided in in the table below. Item 1 Unit Cost $65.25 $75.64 $15.55 2 3 4 5 6 7 8 Annual Usage 1,560 3,650 4,230 1,450 8,560 3,900 1,300 2,500 4,100 2,870 1.680...

Perform an ABC analysis for the data provided in in the table below. Item Annual Usage Unit Cost 1 3,200 $13.25 2 1,650 $43.10 3 560 $53.21 4 8,650 $86.35 5 7,360 $19.55 6 500 $42.30 7 3,100 $74.12 8...

Homework: Assignment #5 HW Score: 6.67%, 6 of 90 points O Points: 0 of 3 Save Barbara Flynn's company has compiled the data below on a small set of products. Based on the percentages of dollar...

(a) Using the information in the table, sketch the demand and supply curves for houses in Country A. (4) Prices of houses (R000's) 250 200 150 100 50 Quantity demanded (000's) 2 4 6 C COLLEGE -...

At the instant a ball rolls off a rooftop it has a horizontal velocity component of +10.0 m/s and a vertical component (downward) of 15.0 m/s. (a) Determine the angle of the roof. (b) What is the...

Which of the following formulas is correct for the settlement of interest payable? Multiple choice question. Beginning balance - interest expense on account - cash settlements of interest payable =...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...