Specialized in selling electrical vehicles-hybrid vehicles

Assignment Help Operation Management

Reference no: EM131126534

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)

Reference no: EM131126534

Questions Cloud

Constitute reasonable approach to patient scheduling : Doctors' and Dentists' offices frequently schedule patient visits at regularly spaced intervals. What problems can this create? Can you suggest an alternative approach to reduce these problems? Under what circumstances would regularly spaced appointm..

They are limited to reasonable uses : Nestlé holds a 99-year lease for the land that the Sanctuary Spring sits on. While lease-holders are generally understood to be able to make full use of their land, when public resources are involved, they are limited to “reasonable uses.” Review the..

Economics and quantitative analysis : The main aim of undertaking this study was to undergo economic and quantitative analysis. Under this report calculation of the elasticity of demand for the university courses has been undertaken.

Specialized in selling electrical vehicles-hybrid vehicles : 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. Clearly define your decision variables, constraints a..

Student is planning to perform bending operation : A student is planning to perform a bending operation as shown in the schematic below. The upper and bottom die will close to bend the sheet metal. Prior to the operation, the student performed a tensile test using the same material. Estimate the larg..

Evaluation of education system : Write a Research Proposal on Topic "Evaluation of Education System", A common goal of all educational institutes worldwide is to provide a foundation of set of courses, skills and knowledge base to their student which helps them to get empowered.

Statements concerning production and staffing plans : Which one of the following statements concerning production and staffing plans is FALSE?

Hospital schedule such that over admission is minimized : During the 4-day planning period of a hospital it is known that 30,25, and 20 patients will require l-,2-, or 3-day stays, respectively. However, the beds available during the same period are estimated at 20, 30, 30 and 30. Use goal programming to de..

User Account

All Pages