Reference no: EM133274723
Case: You are the General Manager of Northern Virginia Motors that specializes in the sales of station wagons and light trucks. Your company has a strong reputation in the market but customer demand remains somewhat sensitive to price. Based on historical data analysis, your marketing team has come up with the demand curves for trucks and for wagons as follows:
Truck Demand (in unit) = 500 - 18 x (Truck Price in thousands)
Wagon Demand (in unit) = 400 - 11 x (Wagon Price in thousands)
Your purchasing prices from automakers are respectively $20,000 per truck and $25,000 per wagon. Before you sell your vehicles in the market, you need to prepare them. It takes 3 hours to prepare truck and 2 hours for a wagon. You currently have a staff with a total of 250 hours labor hours that you can deploy for the prep work. Also, you have a line of loans of $2,000,000 from the bank available for you to finance your vehicle purchases.
(1) In the below space, write out the mathematical formulation of the optimization problem that can help you decide the optimal price for each type of vehicle. Clearly state your decision variables, objective function and all necessary constraints if any.
(2) Implement the above optimization model in Excel. Label your workbook/worksheet that contains your implementation of the model as "Problem 3".
(3) What are the optimal prices that maximize profit?
(4) Under the optimal pricing, how many vehicles will you be able to sell? (Note: fraction is acceptable)
(5) If your labor cost is $30 per hour, should you expand your staff to 260 hours?
(6) If the bank loan has an interest rate of 10%, should you borrow $200,000 more to finance your vehicle purchase to sell more and make more money?
How does this regulation influence the nurses role
: Describe at least one state regulation related to general nurse scope of practice. How does this regulation influence the nurse's role?
|
What would your decision be? beyond the rational decision
: what would your decision be? Beyond the rational decision making process, what biases and other factors might try to impact your decision?
|
Essay about economic standing of the philippines
: Essay about economic standing of the Philippines. The report may cover the area of your choice including but not limited to: agriculture, education, industriali
|
Themes of ability and disability
: 1. Summarize on a finding from at least one professional or scholarly resource focusing on themes of ability and disability.
|
What are the optimal prices that maximize profit
: OR 531 George Mason University What are the optimal prices that maximize profit - If the bank loan has an interest rate of 10%, should you borrow $200,000 more
|
Positive present value of net benefits
: 1. In their article "Eye on the Future," Lawrence Goulder and Robert Stavins argue that an environmental project with a positive Present Value of Net Benefits (
|
Explain the position of christopher stone
: Explain the position of Christopher Stone. Under his theory, what has ethical status and why?
|
What would you expect to see on mr w g ekg
: What would you expect to see on Mr. W.G. EKG and which findings described in the case are compatible with the acute coronary event
|
Contrast the positions of peter singer and joel feinberg
: 1. Explain, compare, and contrast the positions of Peter Singer and Joel Feinberg. What are their positions, and how do they justify them?
|