Question: 1. Given the data prepare a ABC classification. Fill in the two tabular columns provided. PART UNIT COST ANNUAL USAGE 1 60 90 2 350

1. Given the data prepare a ABC classification.

1. Given the data prepare a ABC classification. Fill in the two tabular columns provided. PART UNIT COST ANNUAL USAGE 1 60 90 2 350 40 3 30 130 4 80 60 5 30 100 6 20 180 7 10 170 8 320 50 9 510 60 10 20 120 PART % CUMULATIVE TOTAL VALUE % OF TOTAL VALUE % OF TOTAL QUANTITY CLASS ITEMS % OF % OF TOTAL VALUE TOTALQUANTITY ECONOMIC QUANTITY ORDER EXAMPLE 2DS = EOQ H opt EO

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!

Perform an ABC analysis for the data provided below: PART UNIT COST ANNUAL USAGE 1 60 90 2 350 40 3 30 130 4 80 60 5 30 100 6 20 180 7 10 170 8 320 50 9 510 60 10 20 120 Clearly explain why you...

Project 2 A maintenance department for a small company has responsibility for maintaining an inventory of spare parts for the machinery it services. The parts inventory, unit cost and annual usage...

3. Compute the ABC Analysis with following data and classify the part as ABC: Part Unit Cost ($) Annual Usage (Demand) Total ($) Value % of Total Value Cumulative % value Class A1 510 60 A2 320 50 A3...

The Welsh Corporation uses 13 key components in one of its manufacturing plants. The data are provided in the table below. SKU Item Cost Annual Demand WC007 $1.25 650 WC008 $0.45 10,200 WC219 $4.05...

F1 fx Cengage Learning B C D E F G H 1 j K NOTE: This worksheet is not loc Be careful not to change any fos F ABC Inventory Analysis Cengage Llarning 2 Not for commercial use. 3 Enter data only in...

Spreadsheet The Welsh Corporation uses 13 key components in one of its manufacturing plants. The data are provided in the table below. SKU Item Cost Annual Demand WC007 $0.80 850 WC008 $1.40 WC219...

8.15. Calculate the deseasonalized demands for the following: Quarter Actual Demand Seasonal Index Deseasonalized Demand 1 130 0.62 2 170 1.04 3 375 1.82 4 90 0.52 Total 8.18. Given the following...

uantitative Analysis BA 452 Homework 3 Questions Homework 3 covers the theory and applications in Lessons I-6 and I-7. This document has four parts: Objectives of doing your homework. Assignment of...

Beauville Furniture Corporation produces sofas, recliners, and lounge chairs. Beauville is located in a medium-sized community in the southeastern part of the United States. It is a major employer in...

i have an assignment of financial aacounting and it has 2 questions in 2 parts and one part has to be done in quickbooks. STUDENT NAME(S) STUDENT NO.(S) (PLEASE UNDERLINE YOUR FAMILY NAME ) FOR GROUP...

f 15.) Booble, Inc. has a contribution margin ratio of 47%. This month, sales revenue was $211,000, and profit was $46,300. How much are Booble's fixed costs? $21,761 $49,585 $52,870 $99,170 16.)...

Michael and Sally are ages 54 and 52 respectively. They currently have $600,000 in total saved in their RRSPs and they are currently adding a combined amount of $800 per month to them. They make...

Everything else equal, which of the following would decrease the beta of a company?Group of answer choicesShift towards more high - end / luxury product lineIncrease capital expenditure on equipment...

Which one of these represents an opportunity cost? Multiple choice question. Conducting market research to determine if a new product is feasible Buying some new equipment for use in a new project...