use LP solver in excel to solve please

A movie production company will be shooting on location in Atlanta, GA for five months. During this time period, the production company will require storage space for its sets, props and costumes, which it can lease from a local warehouse. The warehouse leases storage space by the square foot, at prices shown in Table 1 below, depending on the duration of the lease. The warehouse will allow the production company to have multiple leases for space in any particular month and to lease space starting in any month for any duration. For example, the production company could sign a 3 month lease for 30,000 sq ft in month 1 and then add 1 month lease for an additional 20.000 satin month 3 Table 1: Lease Cost Cost Per Sq Ft Lease cost Duration per SR mont th $ 861 month 65 $ 100 2 months 50 $ 135 3 months 45 160 4 months 40 190 5 months 38 Fomulate and solve a LP model to determine the optimalasing plan for the production company in order to have all the storage space it needs in each month at the minimum cont The production company has varying needs for storage space over the course of the five month shoot The space they estimate they will need in each month is shown in Table 2. Table 2: Space Required Morth Sq Ft 130.000 2 20,000 3 40.000 4 10,000 5 50,000 . A movie production company will be shooting on location in Atlanta, GA for five months. During this time period, the production company will require storage space for its sets, props and costumes, which it can lease from a local warehouse. The warehouse leases storage space by the square foot, at prices shown in Table 1 below, depending on the duration of the lease. The warehouse will allow the production company to have multiple leases for space in any particular month and to lease space starting in any month for any duration. For example, the production company could sign a 3 month lease for 30,000 sq ft in month 1 and then add 1 month lease for an additional 20.000 satin month 3 Table 1: Lease Cost Cost Per Sq Ft Lease cost Duration per SR mont th $ 861 month 65 $ 100 2 months 50 $ 135 3 months 45 160 4 months 40 190 5 months 38 Fomulate and solve a LP model to determine the optimalasing plan for the production company in order to have all the storage space it needs in each month at the minimum cont The production company has varying needs for storage space over the course of the five month shoot The space they estimate they will need in each month is shown in Table 2. Table 2: Space Required Morth Sq Ft 130.000 2 20,000 3 40.000 4 10,000 5 50,000