Question: Please help me fix my mistake. Above is the question and my work on Excel. The end goal is to use solver to find optimal

Please help me fix my mistake.

Please help me fix my mistake. Above is the question and mywork on Excel. The end goal is to use solver to find

Above is the question and my work on Excel. The end goal is to use solver to find optimal solution. However my solver keeps saying The objective cell values do not converge. How do I fix this, please help!

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.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!