Week 9
shemariea
HW9_answer_sheet171.xlsxP1
| TOTAL ANNUAL INVENTORY COST | |
| SUMMARY | |
| Q = ORDER QUANTITY = | |
| AVERAGE INVENTORY = | |
| NUMBER OF ORDERS = | |
| CARRYING COST = | |
| ORDERING COST = | |
| TOTAL COST | |
| OPTIMAL TIME BETWEEN ORDERS = | |
P2
| TOTAL ANNUAL INVENTORY COST | |
| SUMMARY | |
| Q = ORDER QUANTITY = | |
| AVERAGE INVENTORY = | |
| NUMBER OF ORDERS = | |
| CARRYING COST = | |
| ORDERING COST = | |
| TOTAL COST | |
| OPTIMAL TIME BETWEEN ORDERS = |
P3
| SUMMARY | ||
| Q = ORDER QUANTITY = | ||
| AVERAGE INVENTORY = | ||
| NUMBER OF ORDERS = | ||
| CARRYING COST = | ||
| ORDERING COST = | ||
| TOTAL COST = | ||
| DEMAND PER DAY = | ||
| REORDER POINT = | ||
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 = |
