1. Formulate a LP model as mentioned in picture.
2. Solve using Excel Model. Please show spreadsheet (Formulas, Solution)

Thank you!

3. Julie North is starting her new business, Queen of the North Vehicle Rental specializing in winter fun machines for use on the snow and ice of northern Minnesota. She has a budget of $1,000,000. She plans to buy snowmobiles, tankchairs, and Track and Go trucks to satisfy client's demands. The estimated costs are as follows: Price of a snowmobile: $12,000 Price of a tankchair: $22,000 Price of a Track and Go truck: $45,000 She expects to earn $2,000 profit from a snowmobile, $3,600 from a tankchair and $4,500 from a Track and Go truck per month during the winter season. She wants to buy at least two vehicles of each type. In addition, because tankchairs and Track and Go trucks can be used year round, snowmobiles should comprise at most 1/3 of her fleet. Formulate a linear program model to help Queen of the North maximize their monthly winter profit. (Define decision variables and write the objective function and constraints.)