ACC - Inventory Analysis Test

profileKnowledgeCats
 (Not rated)
 (Not rated)
Chat

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?   

    • 12 years ago
    ACC - Inventory Analysis Test Solution
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      acc_-__inventory_analysis_test_solution.xls