Question: Submit one Excel file for this assignment. Use Excel functions for all computations (i.e., do not input computation results manually) Discuss briefly your classification results

Submit one Excel file for this assignment.

Use Excel functions for all computations (i.e., do not input computation results manually)

Discuss briefly your classification results (i.e., what % of items and % of total values for each group)

Submit one Excel file for this assignment. Use

Problems 12.1-12.6 relate to Managing Inventory 12.1 L. Houts Plastics is a large manufacturer of injection- molded plastics in North Carolina. An investigation of the com- pany's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? PX L. Houts Plastics' Charlotte Inventory Levels ITEM CODE AVERAGE INVENTORY (UNITS) VAI UE (S/UNID 1289 400 3.75 2347 300 4.00 2349 120 2.50 2363 75 1.50 2394 60 1.75 2395 30 2.00 6782 20 1.15 7844 12 2.05 8210 8 1.80 8310 7 2.00 9111 6 3.00

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 the attached assignment. Required computation for direct material, manufacturing and performance overhead. Name There are 2 problems, which are set up on separate worksheets within...

I have attached three documents. I am working on a group case and I am stuck on the highlighted memo part. How do I proceed with the memo. Please assist. How should this part be written without being...

Use Excel functions for all computations (i.e., do not input computation results manually) Discuss briefly your classification results (i.e., what % of items and % of total values for each group)...

please do only part 3. the company name is tesla. all what you need is below Tesla, Inc. Notes to Consolidated Financial Statements Note 1 Overview Tesla, Inc. (Tesla, the Company, we, us or our) was...

I need you to do part 3 please and all what you need below Note 2 Summary of Significant Accounting Policies Principles of Consolidation The accompanying consolidated financial statements have been...

Case Study on Corporate Finance for FIN510/FIN205 This assignment consists of two parts, total marks 15, weights 15%. This assignment will be due at 11:59PM, Monday 7" October 2024. You will work on...

MKT572 Group Project2 There are several requirements for group project. Failure to meet the submission requirement will result in a deduction of 10 points from your grade. 1. In your cover page, list...

Cost Volume Profit Analysis Data: Recent Quarterly Data Budgeted Sales Units for 4th Quarter 385,000 Sales Manufacturing Selling Administrative Standard Deviation for Budgeted Sales Units 7,000 Units...

This is the first year of operations for the city 20X4. The following transactions are summarized for the city this year: The city levied $9,000,000 of general property taxes, $8,800,000 of which has...

Identify each factor influencing elasticity and give a specific example of how it affects the degree of elasticity in a good or service.

When these two metals are placed into contact, which of the following will take place? (a). Heat will flow from Al to Cu because Al has a larger specific heat. (b). Heat will flow from Cu to Al...

Which of the following is not an internal control the auditor would expect to find in place for all cash processing systems? a . Independent reconciliation. b . Prenumbered cash receipt documents. c...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...