A car dealership is specialized in selling electrical


A car dealership is specialized in selling Electrical Vehicles (EVs) and Hybrid Vehicles (HV). The demand for each vehicle type is sensitive to its price as well as to the price of the other type. In other words, there is an interaction between the EV and HV markets. An expert introduced the following demand curves: EV demand = 300 – 0.014(EV price) + 0.003 (HV price) HV demand = 325 – 0.018 (HV price) + 0.005 (EV price) The dealership’s unit costs are $17000 and $14000 per EV and HV respectively. Each HV requires 2 hours of labor for preparing the car and each EV requires 3 hours of preparation labor. The current staff can supply 320 hours of labor. 1. Develop a mathematical model to maximize the dealership’s total profit. Clearly define your decision variables, constraints and objective function 2. Implement your model in Excel and use Solver to find the optimal prices and optimal profits. Include a snapshot of your Excel answer 3. What sales levels will result from the prices in part (2) (you can ignore fractional values)

Request for Solution File

Ask an Expert for Answer!!
Operation Management: A car dealership is specialized in selling electrical
Reference No:- TGS01510928

Expected delivery within 24 Hours