Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How would I solve this using Microsoft excel? M93. The finished goods inventory of a small manufacturing company is shown below [available in data file

How would I solve this using Microsoft excel?

image text in transcribed
M93. The finished goods inventory of a small manufacturing company is shown below [available in data file for Module 9]. Perform an ABC analysis on the data [Assign A items to a maximum of 70 % of the cumulative value and B items to a maximum of the next 20% of the cumulative value (a total of 90%).} Value units 5 125.00 mu 5 mm a} How many items are assigned as "A\" items? b] How many items are assigned as \"B\" items? c] How many items are assigned as \"C\" items? d] What assignment was made to the following items: 2456? 5995? 8989? 9034

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary & Intermediate Algebra Functions And Authentic Applications

Authors: Jay Lehmann

2nd Edition

0321923456, 9780321923455

More Books

Students also viewed these Mathematics questions

Question

2. The purpose of the acquisition of the information.

Answered: 1 week ago

Question

1. What is the meaning of the information we are collecting?

Answered: 1 week ago