Question: Perform an ABC Inventory Classification Analysis for approximate percent usage of 80% usage for Class A items, 15% usage for Class B items, and 5%

Perform an ABC Inventory Classification Analysis

Perform an ABC Inventory Classification Analysis for approximate percent usage of 80% usage for Class A items, 15% usage for Class B items, and 5% for Class C items. Also, perform a Cycle Counting Schedule where the cycle count is monthly for Class A items, quarterly for Class B items and 6 months for Class C items. Assume 20 days per month. # 1 2 3 4 5 6 7 8 9 SKU Units Unit Cost 12854 100 12649 500 12445 1000 12749 400 12028 640 12116 400 120 12323 1290 600 1210 920 10 129950 2400 4250 380 55 80 45 40 110 9 3 0.5 How many statements are correct? 0 1 2 3 (A) The usage for SKU-12854 is $4250. (B) The percent usage for SKU-12116 is approximately 2%. (C) The count/day for Class A items is 30, Class B items is 34, and Class C items is 37

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!

Need help with those please Assume the time standards and equivalent relationships. Year Quarter Month Week Day Equivalent Relationships 1 4 12 240 1 year 4 quarters - 12 months - 48 weeks = 240 days...

Question 4. Perform an ABC Inventory Classification Analysis for approximate percent usage of 80% usage for Class A items, 15% usage for Class B items, and 5% for Class C items. Also, perform a Cycle...

The ABC inventory classification method has been specifically proposed by researchers to help hospitals logistics managers to categorize inventory items so that effective managerial policies and...

1 Erica would like to perform an ABC inventory analysis. She has gathered the following annual figures for her jewelry design business: Metals (gold/silver), $25,000; Beads, 54,800; Clasps/closures,...

1. ABC Inventory Classification (Total: 1.5 points) Item No. 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 Unit Cost ($) 2.75 1.85 1.5 0.71 3.52...

Provide an example of ABC classification in a business you are familiar with. What would be the A inventory items versus B and C? What ordering policies would you use for each of these? Read below:...

Microsoft Excel Activity #1: Inventory Classification X Question 1 0110 Submit The data for 10 inventoried items ol a small company has been collected in the Microsoft Excel Online file below. Use...

Please solve all questions because this is my last chance to post the question. on 28 A certain type of computer costs RO 800, and the annual holding cost is 20% of the value of the item. Annual...

Barbara Fyn's company has come the data below on a small set of product percentages of dollar volume perform in ABC analysis on her data by completing the table below. Assume that class Aitor...

Question content area Part 1 Barbara Flynn's company has compiled the data below on a small set of products. Based on the percentages of dollar volume, perform an ABC analysis on her data by...

The new manager of the CPU Assembly Department was asked to estimate the incremental cost of processing an additional 1,000 units through the department. He took the unit cost for an equivalent whole...

Flexible budget. Sweeney Enterprises manufactures tires for the Formula I motor racing circuit. For August 2017, it budgeted to manufacture and sell 3,600 tires at a $71 per tire and total fixed...

The Val IT framework best aligns with and complements which of the following? Multiple Choice The Balanced Scorecard. The COBIT 5 framework. The COSO 2 0 1 3 internal control framework. The REA model.

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...