Question: 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 %

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) Use Excel functions for all computations (i.e.,

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) VALUE (S/UNID 1289 400 3.75 2347 200 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!

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

Using financial statements for home depot and the 2 Excel template provided, you build a balance sheet and income statement, complete common size, common base year, and combined common size & base...

I would also need the New Price if YTM changes by amount in B13 A B C D E F H. 1 6.60% *Called on date in cell B8. 1*Put on the date in cell B10 8.38 8.11 -22.82 * Actual (not estimated by dur-n)...

Dong Lee Math-138 Professor Deshpande 10-16-16 Project Part 2 Research Proposal: Introduction: The first variables I plan to study are the hours you spend on the smartphone daily and the monthly...

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

I need with these problems/exercises listed below (chapters attached). You must use the chapters to fill out the guidance report which is attached. Using the data for March/April Column. Chapter...

I need some help with both Case 1 and Case 2 of this assignment. See attached document for full assignment. Here is an excerpt from each. Case 1: Purchase Point Media Corporation (PPMC) Media...

On January 1, 2010, Werth Corporation had these stockholders equity accounts. Common Stock ($10 par value, 80,000 shares issued and outstanding) .....$800,000 Paid-in Capital in Excess of Par Value...

Calculate the future value of an account after you've contributed $1,000 at the end of each year for 40 years, assuming you can earn 9 percent compounded annually and you don't make a withdrawal...

The names of stadiums in Long's second era ( 1 9 5 3 - 1 9 8 0 ) reflects the fact that.....a ) they relied partially on corporate naming rights for funding.b ) football had become more popular than...

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