Question: Consider a modification of the original Red Brand problem where there are N plants, M warehouses, and L customers. Assume that the only allowable arcs
Consider a modification of the original Red Brand problem where there are N plants, M warehouses, and L customers. Assume that the only allowable arcs are from plants to warehouses and from warehouses to customers. If all such arcs are allowable—all plants can ship to all warehouses and all warehouses can ship to all customers—how many changing cells are in the spreadsheet model? Keeping in mind that Excel’s Solver can handle at most 200 changing cells, provide some combinations of N, M, and L that barely stay within Solver’s limit.
Step by Step Solution
3.43 Rating (166 Votes )
There are 3 Steps involved in it
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGene... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
415-M-S-S-M (104).xlsx
300 KBs Excel File
