Reference no: EM13924873
Linear Programming (LP) and Sensitivity Analysis
Cycle City Inc., a large bicycle store is placing an order for bicycles with its supplier. Four models can be ordered: the adult racer, the adult Mountain bike, the girl's Sea Sprite, and the boy's Trail Blazer. It is assumed that every bike ordered will be sold, and their profits, respectively, are 32, 28, 25, and 20. The LP model should maximize profit. There are several conditions that the store needs to worry about. One of these is space to hold the inventory. An adult's bike needs two feet, but a child's bike needs only one foot. The store has 500 feet of space. There are 1200 hours of assembly time available. The child's bike need 4 hours of assembly time; the racer needs 5 hours and the mountain bike needs 6 hours. The store would like to place an order for at least 275 bikes.
1. Formulate a model for this problem. Specifically, do the following: Identify the decision variables (make sure that you specify the units for these variables). Specify the objective function and the relevant constraints.
2. The production manager uses a DSS to make decisions about what to do. The maximum attainable profit is required. Develop a simple DSS prototype to solve this problem.
a. How many of each kind of bike should be ordered?
b. What is the total profit realized?
c. What is the profit contribution for each bike?
3. Perform sensitivity analysis to determine: (Remember to change back to original value after each change below).
a. What would the profit be if the store had 100 hours of assembly time?
b. If the profit on the Mountain bike increases to $35, how many of those bikes should be ordered?
c. If we require 5 more bikes in inventory, what will happen to the value of the optimal solution?
4. Write a short memo to the management of Cycle City Inc., explaining
a. Over what range of assembly hours is the dual price applicable?
b. Which resource should the company work to increase, inventory space or assembly time? Explain.
|
What is the call price of a bond
: What is the call price of a bond? Is it usually higher or lower than the face amount of the bond? Explain.
|
|
Dividends that each stock paid during the year
: The table below shows your stock positions at the beginning of the year, the dividends that each stock paid during the year, and the stock prices at the end of the year. Company Shares Beginning of Year Price Dividend Per Share End of Year Price John..
|
|
What are the limitations of applying modern portfolio theory
: Explain how the main tenets of the Markowitz Portfolio Theorem are applied in credit risk management. What are the limitations of applying Modern Portfolio Theory (MPT), especially in credit portfolios?
|
|
What is target fixed assets and sales ratio
: Walter Industries has $4 billion in sales and $1.7 billion in fixed assets. Currently, the company's fixed assets are operating at 95% of capacity. What is Walter's target fixed assets/Sales ratio? What level of sales could Walter Industries have obt..
|
|
Identify the decision variables
: Formulate a model for this problem. Specifically, do the following: Identify the decision variables (make sure that you specify the units for these variables). Specify the objective function and the relevant constraints.
|
|
Assuming that the selling price of the bond
: Assuming that the selling price of the bond and the face value are the same, would the issuer of a bond rather make annual or semiannual interest payments? Why?
|
|
Job description for a retail sales associate
: Create a job description for a retail sales associate, which includes the most significant components necessary to describe the job both internally and externally.
|
|
Using both capm and the constant-growth model
: You have assigned the following values to these three firms: Price Upcoming Dividend Growth Beta US Bancorp $ 39.30 $ 1.90 7.20 % 1.76 Praxair 35.55 1.65 13.00 3.14 Eastman Kodak 38.10 2.00 5.50 1.19 Assume that the market portfolio will earn 15.20 p..
|
|
Not all companies are viewed as equal alcohol industry
: In the land of free trade the public does not view all industries as equal. Do you believe that is ethical Do you believe that some industries are unfairly targeted? Should it not be consumers' choice to partake in products that are not healthy fo..
|