Please solve by LINGO or Excel Solver and provide a screen capture and a short written version of your solution

A)

B)

a If you solve the models in Excel Solver, you will have to write them in standard form, ie, all variables on the left-hand side, and a number of the right-hand side. If you use LINGO, you are not bound by this restriction. For each question, do the following When you attempt to solve these models, you might receive a message about the solution being infeasible. While this is a theoretical possibility, it won't happen for any of these questions. It means that a mistake has been made in formulating the model. a A company blends two gasolines from Avalon Energy and Bonavista Petroleum (in- puts) into two commercial products, Premium and Regular gasoline (outputs). For the inputs, the octane ratings, the vapour pressures in kilopascals, and the amounts available in cubic metres (m) and their prices are known. These are: Input Octane Vapour Amount Gasoline Rating Pressure (kPa) Available (m) Avalon 105 35 25,000 Bonavista 82 66 38,000 Buying Price ($ per m) 310 240 For the Premium and Regular gasolines the requirements are: Output Gasoline Minimum Octane Rating 95 Maximum Minimum Selling Vapour Amount Price Pressure (kPa) Required (m) ($ per m) 43 19,000 350 58 27,000 290 Premium Regular 87 We define the variables as follows: A and B are respectively the amount of gasoline in m' purchased from Avalon Energy/Bonavista Petroleum. P and R are respec- Lively the amount of Premium/Regular gasoline in m blended and sold. AP, AR, BP, and BR are respectively the amounts in m of Avalon/Bonavista gasoline used to make Premium/Regular gasoline. A machine shop makes pipes for the oil and gas industry in lengths of 250 cm and 400 cm. The shorter pipes give a profit of $140 each, while each long pipe gives a profit of $270. They can sell at most 900 of the 250 cm pipes and at most 300 of the longer ones. Each pipe spends time on three machines as follows: Machine Lathe Polisher Grinder Minutes per Pipe Minutes Short Long Available 5 7 6300 8 2 4000 10 8 8100 In addition to the minutes available given in the above table, they can purchase up to 500 minutes (all, none, or any fraction of this amount) of additional polishing time at a cost of $2 per minute, and can purchase an unlimited amount of extra grinding time at a cost of $3 per minute. For every long pipe made, there must be at least two short pipes made. For every pair of long pipes made, there can be at most seven short pipes made