Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve using excel solver only. thanks Tractor Land is Sault St. Marie's premier tractor dealer. This is the place to shop for one of

please solve using excel solver only. thanks

image text in transcribed
Tractor Land is Sault St. Marie's premier tractor dealer. This is the place to shop for one of the three models of powerful machines - Diggy, Lifty, and Pushy. The cost to the Dealer for every Diggy is $20,000, every Lifty is $15,000, and each Pushy is $21,500. A Diggy sells for $25,000, a Lifty for $22,000, and a Pushy for $30,000. Space is limited at the Dealer, so only up to 50 tractors can be in stock at once. A Pushy takes up the space of two of the other tractors (A Diggy and a Lifty are the same size). The Dealer has a budget of $1,000,000 for stock, and three employees to prepare tractors for sale. It takes 5 hours to prepare a Pushy for sale, 4.5 hours to prepare a Lifty, and 3.5 hours to get a Diggy ready for sale. The three employees have a total of 200 hours available for this prep work. What mix of tractors is optimal for Tractor Land to stock under these constraints, if optimizing profits is the objective. Prepare and solve a Linear Programming model with an integer solution

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management A Systems Approach to Planning Scheduling and Controlling

Authors: Harold Kerzner

10th Edition

978-047027870, 978-0-470-5038, 470278706, 978-0470278703

More Books

Students also viewed these General Management questions

Question

=+ a. A change in consumer preferences increases the saving rate.

Answered: 1 week ago