Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve using excel solver only. thanks Marcel has been watching the price of older American muscle cars rise significantly over the past two years,

please solve using excel solver only. thanks

image text in transcribed
Marcel has been watching the price of older American muscle cars rise significantly over the past two years, and he has decided to start a dealership selling these cars in a small town in Canada. His bank has given his company financing to purchase up $500,000 of cars. At a large auction next month, Marcel plans to buy a mix of cars for his business - Pontiacs, Chryslers, and Fords. He wants to buy at least twice as many Pontiacs as Chryslers and Fords combined. Studying recent data, the cost per car is expected to be $35,000 per Pontiac, $28,000 per Chrysler and $26,000 per ford. Selling prices, he expects, will be $43,500 per Pontiac, $37,000 per Chrysler and $34,000 per Ford. Marcel's dealership can store no more than 15 cars. Lastly, he must prepare the cars for sale with a wash and service per car. Pontiacs will need 4 hours, Chryslers 3 hours, and Fords 5 hours each. With 1 employee, there are only 40 hours available for the prep work. Prepare a Linear Programming Model reflecting this information to determine the optimal mix of cars he should purchase with the objective of maximizing his profits. Prepare and solve an integer only 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

Step: 3

blur-text-image

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

The Restaurant From Concept To Operation

Authors: John R Walker

5th Edition

0471740578, 9780471740575

More Books

Students also viewed these General Management questions

Question

Explain all drawbacks of application procedure.

Answered: 1 week ago

Question

1. What is the meaning of the information we are collecting?

Answered: 1 week ago

Question

3. How much information do we need to collect?

Answered: 1 week ago

Question

2. What types of information are we collecting?

Answered: 1 week ago