Need help with excel solver. Step by step

C D G 1 the month 2 5 Total Available Total Needed 20000 30000 40000 Homework 3 35000 The Shop at Home Network sells various household goods during live television broadcasts. The 50000 company owns several warehouses to hold many of the goods if 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 spaces Month 2 3 Leasing Costs aft Needed 20,060 30.000 40 000 35 090 $0.000 655 $130 $155 $195 At the beginning of any month, the company can lease extra space for one of more months at the $55 SRS $130 $155 following costs: $55 $130 Lease term 1 (months) $95 Cost per soft $55 $195 $55 So. for instance, of the start of month I the company can lease as much space it wants for four months at a cost of $155 per sqft. Similarly, at the start of month 3, the company can lease any Total Leasing cost amount of space for two months at a cost of $09 per agft. 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. (20 points) b. Create a spreadsheet model for this problem and solve it using Solver (4 points) c. What is the optimal solution? (20 points) d. How much would it cost the company to meet its space needs if in each month if leases for one month exactly the amount of space required for the month? (20 points)