Using an excel spreadsheet Analytic Solver how could i figure this out:

Bruce currently has $100,000$ cf of gas in storage at Henry. Industrial customers in Joliet are offering $$4\mathrm{.}35$ per

thousand cf for up to $35,000$ cf of gas. Buyers in Leidy are offering $$4\mathrm{.}63$ per thousand cf for up to $60,000$ cf of gas.

Develop model$($s$)$ to help Bruce answer below items. Summarize each model decision variables and objective

function. Create spreadsheet model$($s$)$ for below items.

$$ Given the available capacity in the network, how much gas can be shipped from Henry

to Leidy? From Henry to Joliet?

$$ How much gas should Bruce offer to sell to Joliet and Leidy if he wants to maximize

profits?

$$ Is Bruce able to meet all the demand from both customers? If not, why not?

$$ If Bruce wanted to try to pay more to obtain additional capacity on some of the

pipelines, which ones should he investigate and why?