T Home Draw Page Layout insert Formulas Data Review View Help Analytic Solver e Wrap Test General Merge & Center S- Xcut Anal - 12 A A Pa Copy - Paste DA- format Painter Clipboard 5 Font SECURITY WARNING Maces have been disabled Enable Content Algement Number 5 F29 fo B C D E G H Shop Home 1 2 3 4 5 Through month 2 4 5 Leased in month 1 2 3 4 5 Total Total Available Needed 20000 30000 40000 35000 50000 1111 $55 $95 $55 Leasing costs $130 $95 $55 $155 $130 $95 $55 $185 $155 $130 $95 $55 Total leasing cost 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Storage Plan to Solver X > Objective (Pick the cell to optimize) > Variables (Pick input cells to change) > Constraints (Add formula cells with limits) > Model (Type: Click to Diagnose) > Engines Insert Example Login for Upgrade Help, Examples, Upgrades T Home Draw Page Layout insert Formulas Data Review View Help Analytic Solver e Wrap Test General Merge & Center S- Xcut Anal - 12 A A Pa Copy - Paste DA- format Painter Clipboard 5 Font SECURITY WARNING Maces have been disabled Enable Content Algement Number 5 F29 fo B C D E G H Shop Home 1 2 3 4 5 Through month 2 4 5 Leased in month 1 2 3 4 5 Total Total Available Needed 20000 30000 40000 35000 50000 1111 $55 $95 $55 Leasing costs $130 $95 $55 $155 $130 $95 $55 $185 $155 $130 $95 $55 Total leasing cost 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Storage Plan to Solver X > Objective (Pick the cell to optimize) > Variables (Pick input cells to change) > Constraints (Add formula cells with limits) > Model (Type: Click to Diagnose) > Engines Insert Example Login for Upgrade Help, Examples, Upgrades