For this assignment, create an Excel spreadsheet to evaluate the two options. The comparison should
compare:
(a) the annual holding cost of safety stock for the “no aggregation” option, where all 40 final product
configurations are held in inventory, and (b) the annual holding cost of safety stock plus the increased printing
cost for the “aggregation” option, where inventory is held by color so that only 5 different items are held in
inventory. When analyzing the two alternatives, use a target product fill rate of 99%.