Question: please use excel and do not copy from other answers they are all different numbers. thanks. Given the following inventory information, construct an (a) ABC

please use excel and do not copy from other answers they are all different numbers. thanks.

Given the following inventory information, construct an (a) ABC analysis by annual dollar usage, (b) ABC analysis by current inventory value, and (c) an ABC inventory matrix. Is the firm stocking the correct inventories? UNIT COST ITEM NUMBER ANNUAL USAGE (UNITS) CURRENT INVENTORY (UNITS) ($) B8867 6.00 100 8,000 J1252 5.25 6,500 120 K9667 0.25 4,000 1,000 L2425 1.00 1,500 375 M4554 5.50 2,000 500 T6334 70.00 500 800 W9856 0.75 800 20,000 X2215 1.50 8,000 2,000 Y3214 32.00 1,000 500 Y6339 4.00 3,500 125

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!

No hand written answers and provide the formulas/calculations, as to how you got your numbers please. (Show work). Course is Principles of Supply Chain Man (BSM-430) 18. Given the following inventory...

Solve the following problems: Show all work on back page or separate attached sheet This assignment must be uploaded on CANVAS. I will only accept Word, PDF or Excel upload. Please answer all the...

please show work in excel wirh formulas 18. Given the following inventory information, construct an (a) ABC analysis by annual dollar usage, (b) ABC analysis by current inventory value, and (c) ABC...

Given the following inventory information, construct an ( a ) ABC analysis by annual dollar usage, ( b ) ABC analysis by current inventory value, and ( c ) an ABC inventory matrix. Is the firm...

a. Construct: i. ABC analysis by annual dollar usage ii. ABC analysis by current inventory value (Performing the tables and charts in excel) b. Based on these analyses, do you think the firm is...

How do I create a scatter chart for the following data in excel? Given the following inventory information, construct an (a) ABC analysis by annual dollar usage, (b) ABC analysis by current inventory...

Having difficulty with this lab :/ any kind of help would be useful and very much appreciated! Learning Objectives: Deeper understanding about the costs associated with an Ordering policy (i.e. an...

Please Use Excel to calculate the following Mr. Milligan asks you to determine for each inventory item the: Cost of average inventory Annual sales Cost of goods sold Annual gross profit Gross margin...

help needed on lab please and thank you If annual demand is 1739 , holding costs are $9 per unit per year, and setup costs are $89 per order, what is the economic order quantity? Answer: What is the...

Please see attachment. Please use excel. Also, under the "Requirements"seperate part A and part B on excel. Thank you. Budgeting Project TO THE STUDENT Fantastic, Inc. is a case study which allows...

You are an analyst at Oil Patch Semiconductors Inc. (OPS), a small high-tech firm specializing in the design of proprietary chips used by oil companies to help find new sources of oil and natural...

Foley Company is considering purchasing new equipment for $300,000. It is expected that the equipment will produce annual net income of $10,000 over its 10-year useful life. Annual depreciation will...

E17.2 (LO 1) (Fundamentals of Revenue Recognition) Respond to the questions related to the following statements. 1. A wholly unperformed contract is one in which the company has neither transferred...

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...