MAT 54 CH 16 Wek 9 Homework
candiceaj79
HW9_answer_sheet171.xlsxP1
| TOTAL ANNUAL INVENTORY COST | |
| SUMMARY | |
| Q = ORDER QUANTITY = | 10,000 |
| AVERAGE INVENTORY = | 35,000 |
| NUMBER OF ORDERS = | 4 |
| CARRYING COST = | $ 0.35 |
| ORDERING COST = | $ 500.00 |
| TOTAL COST | $ 3,500.00 |
| OPTIMAL TIME BETWEEN ORDERS = | 91 days |
P2
| TOTAL ANNUAL INVENTORY COST | |
| SUMMARY | |
| Q = ORDER QUANTITY = | 190,919 |
| AVERAGE INVENTORY = | 1,215,000 |
| NUMBER OF ORDERS = | 6 |
| CARRYING COST = | $ 0.08 |
| ORDERING COST = | $ 1,200.00 |
| TOTAL COST | $ 15,274.00 |
| OPTIMAL TIME BETWEEN ORDERS = | 61 days |
P3
| SUMMARY | |
| Q = ORDER QUANTITY = | 456 |
| AVERAGE INVENTORY = | 2000 |
| NUMBER OF ORDERS = | |
| CARRYING COST = | $ 50.00 |
| ORDERING COST = | $ 2,600.00 |
| TOTAL COST = | $ 22,803.50 |
| DEMAND PER DAY = | 2000 |
| REORDER POINT = | 64.5 |
P4
| ORDERING | ORDERING |
| EOQ | 5,000 |
| = | |
| Average inventory = Q/2 = | |
| Annual carrying cost = | |
| Number of orders = | |
| Annual order cost = | |
| Total inventory purchase cost = | |
| Total inventory cost = | |
P5
| ORDERING | ORDERING | ORDERING | ORDERING |
| EOQ | 1,000 | 3,000 | 6,000 |
| = | |||
| Average inventory = | |||
| Annual carrying cost = | |||
| Number of orders = | |||
| Annual order cost = | |||
| Total inventory purchase cost | |||
| Total inventory cost = |
