We can state a capital budget constraint requiring the total fixed warehouse cost not to exceed $2,000,000 as i=16whFiXi$2,000,000. State this constraint using EXCEL formulas and type below:

File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Queries & Connections + ?, Solver Recent Sources L Existing Connections NN 17 From Text/CSV Le From Web Get Data E From Table/Range E 7 clear B: Properties PN N Reapply BE E Group Ungroup E Subtotal - Stocks Refresh All Currencies Sort Filter Text to Columns EDG Advanced What-If Forecast Analysis Sheet LS Edit Links Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analyze C12 fix D E G H J L M N Q R 6 7 8 K $46,221.30 $0.00 3,064,908 Objective 3,481,440 total fixed and variable costs, inbound and outbound 9 Demand-j 2,870,000 572.000 8,450,000 350,000 901,000 333,000 Total Facilites P-min P-max X-i (use = 1) capacity fixed cost 7,000,000 $1,000,000 6,000,000 $700,000 10,000,000 $2,200,000 6,000,000 $600,000 6,000,000 $1,000,000 1 6,000,000 $600,000 2 1