GIVE EXCEL SOLVER SOLUTION FOR THIS TO EITHER MINIMIZE THE COST OR inventory management or project management:

     

Transcribed Image Text:

Below is the historical 1st quarter sales for the past year. The future demand is expected to follow the same pattern Week Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Actual Graphics Cards Sales Category A (95%) 187 187 140 159 146 157 179 186 139 170 164 186 166.7 Category B (90%) 96 186 167 136 177 101 159 168 98 137 185 127 144.8 283 373 307 295 323 258 338 354 237 307 349 313 Below is the historical 1st quarter sales for the past year. The future demand is expected to follow the same pattern Week Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Actual Graphics Cards Sales Category A (95%) 187 187 140 159 146 157 179 186 139 170 164 186 166.7 Category B (90%) 96 186 167 136 177 101 159 168 98 137 185 127 144.8 283 373 307 295 323 258 338 354 237 307 349 313