Prepare spreadsheet-based abc analysis of usage value

Assignment Help Operation Management

Reference no: EM133961433

Questions

1. Prepare spreadsheet-based abc analysis of usage value. classify as follows:

a. items: top 20 per cent of usage value

b. items: next 30 per cent of usage value

c. items: remaining 50 per cent of usage value

2. Calculate the inventory weeks for each item, for each classification, and for all the items in total. Does this suggest that the Operations Manager's estimate of inventory weeks is correct? If so, what is your estimate of the overall inventory at the end of the base year, and how much might that have increased during the year?

3. Based on the sample, analyse the underlying causes of the availability problem described in the text.

Reference no: EM133961433

Questions Cloud

BestBuy recently changed their return policy : BestBuy recently changed their return policy, and returns can only be made on the same day of purchase during Black Friday.

What product is best to take to market is intensive : Heleads new product development at his company. His process for deciding what product is best to take to market is intensive.

Airlines frequent flier program : What is an example of an Airlines Frequent Flier Program. What are 3 benefits of joining this program that a passenger may recieve?

What fraction of customers sees zero people upon arrival : What fraction of customers sees zero people upon arrival? For what fraction of time does the manager of the system observe zero people in the system

Prepare spreadsheet-based abc analysis of usage value : Prepare spreadsheet-based abc analysis of usage value. Calculate the inventory weeks for each item, for each classification, and for all the items in total.

Prescribed antibiotics with average daily demand : Tetracycline is one of the most prescribed antibiotics, with average daily demand of 2,200 capsules. How many capsules should be ordered?

Component parts in heating and cooling ventilation systems : Airflow industries is a maker of component parts in heating and cooling ventilation systems.

Sales estimates with low cost as goal : Develop level, chase, and mixed plans on excel for meeting the sales estimates with low cost as a goal.

Name the types of fee schedules and fee discounts : Name the types of fee schedules and fee discounts. State the importance of aging accounts and dun message

User Account

All Pages