ACC – Inventory Analysis Test

Question # 1:

You have to buy 5000 pieces of a part that costs $50 per hundred.
The price quoted to your customer is a 100 piece minimum at $37.50 each.

Your total cost is: __________________________

Your total sell is: ___________________________

Your markup based on total cost and total sell is: ____________________

Question # 2:

You are quoted a 10,000 piece minimum at a price of $20.00 per hundred.
The price to the customer is: $500 per thousand.
The total schedules you see for the year are 1,000.

Based on this information should you place the order for this part? __________________________

Why? ____________________________________________________________________________

Question # 3:

You have an overseas part you are analyzing. You have to keep 90,000 pieces of safety stock.
You buy the complete part and want it to come in 1 month before we have to ship it. The part has a 4 month lead time. You currently have 250,000 pieces in stock. Below are the schedules:

1/13/2010 10,000
2/13/2010 20,000
3/13/2010 40,000
4/12/2010 10,000
5/13/2010 20,000
6/13/2010 20,000
7/13/2010 20,000
8/13/2010 40,000
9/13/2010 10,000
10/13/2010 20,000
11/13/2010 10,000

What date do you need to buy this part? ________________________________________________

Question # 4:
QTY Cost Per Ext Cost

100 $10.00 1000

250 $250.00 100

500 $50.00 1

Question # 5:
On hand 450

26-Jul 50
1-Aug 100
4-Aug 300
5-Sep 50
1-Oct 100
1-Nov 200
15-Nov 300
30-Dec 400
1-Feb 100
20-Mar 300
27-Mar 50
28-Mar 100
5-Apr 200
7-Jun 300
9-Aug 400

Based on the above information, when do you run out of parts?

“If you want to cover demand through the end of November and
not further, how many do you need to buy?”

Question # 6:
49 days = how many Calendar weeks?