I cannot figure out the correct formulas to solve Question 25C

I have Cell F19 as =SUMPRODUCT(C6:G10,C13:G17)

Cell H6 as =SUM(G6:G10)

Cell H7 as =SUM(G7:G10)+SUM(F6:F9)

Cell H8 as =SUM(G8:G10)+SUM(F7:F9)+SUM(E6:E8)

Cell H9 as =SUM(D6:D7)+SUM(E7:E8)+SUM(F8:F9)+SUM(G9:G10)

Cell H10 as =C6+D7+E8+F9+G10

My solver page is also shown below

Solver Parameters x Set Objective: $F$19 To: Max Min Value Of 0 By Changing Variable Cells: $G$6:$G$10,$F$6:$F$9,$E$6:$E$8,SD$6:$D$7.$C$6 Subject to the Constraints: $H$6:5H$10 >= $1$6:$1$10 Add Change Delete Reset All Load/Save Make Unconstrained variables Non-Negative Select a Solving Simplex LP Method: Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close F19 X fax =SUMPRODUCT(C6:G10,013:617) A B D E F G . 1 N Shop @ Home Through month 3 1 2 4 6 5 Leased in month 1 2 3 4 5 - Total Total Available Needed 0 20000 0 30000 0 40000 0 35000 0 50000 - -- 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 $55 $95 $55 Leasing costs $130 $95 $55 - $155 $130 $95 $55 $185 $155 $130 $95 $55 -- -- - -- -- Total leasing cost $0 25. The Shop at Home Network sells various household goods during live television broadcasts. The company owns several warehouses to hold many of the goods it sells but also leases extra warehouse space when needed. During the next five months, the company expects it will need to lease the following amounts of extra warehouse space: Month 1 2 3 5 Square Feet Needed 20,000 30,000 40,000 35,000 50,000 At the beginning of any month, the company can lease extra space for one or more months at the following costs: Lease term (months) 1 2 3 4 5 Cost per Sq. Ft. Leased $55 $95 $130 $155 $185 So, for instance, at the start of month 1 the company can lease as much space as it wants for four months at a cost of $155 per square foot. Similarly, at the start of month 3, the company can lease any amount of space for two months at a cost of $95 per square foot. The company wants to determine the least costly way of meeting its warehousing needs over the coming five months. a. Formulate an LP model for this problem. b. Create a spreadsheet model for this problem, and solve it using Solver. c. What is the optimal solution? d. How much would it cost the company to meet its space needs if in each month it leases for one month exactly the amount of space required for the month