subject
Business, 16.10.2020 09:01 multezemaleme

A large sporting goods store is placing an order for bicycles with its supplier. Four models can be ordered: the adult Open Trail, the adult Cityscape, 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 30, 25, 22, and 20. The LP model should maximize profit. The store needs to worry about several conditions. 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 bikes need 4 hours of assembly time, the Open Trail needs 5 hours, and the Cityscape needs 6 hours. The store would like to place an order for at least 275 bikes. Required:
a. Formulate a model for this problem.
b. Solve your model using Excel Solver.
c. How many of each kind of bike should be ordered and what will the profit be?
d. What would the profit be if the store had 100 more feet of storage space?
e. If the profit on the Cityscape increases to $35, will any of the Cityscape bikes be ordered?
f. Over what range of assembly hours is the shadow price applicable?
g. If we require 5 more bikes in inventory, what will happen to the value of the optimal solution?
h. Which resource should the company work to increase, inventory space or assembly time?

ansver
Answers: 3

Other questions on the subject: Business

image
Business, 21.06.2019 15:30, jayzelgaspar8441
Jen heard that the bank where she kept her money was going to close for good. jen said she wasn't worried
Answers: 3
image
Business, 21.06.2019 20:00, googoo4
Jorge is a manager at starbucks. his operational plan includes achieving annual sales of $4,000,000 for his store. with only one month left to end of the fiscal year, jorge realizes that he won't reach his annual sales goal. what are his options?
Answers: 2
image
Business, 22.06.2019 10:00, mayamabjishovrvq9
Suppose an economy has only two sectors: goods and services. each year, goods sells 80% of its outputs to services and keeps the rest, while services sells 62% of its output to goods and retains the rest. find equilibrium prices for the annual outputs of the goods and services sectors that make each sector's income match its expenditures.
Answers: 2
image
Business, 22.06.2019 19:30, Ruby2480
One of the benefits of a well designed ergonomic work environment is low operating costs is true or false
Answers: 3
You know the right answer?
A large sporting goods store is placing an order for bicycles with its supplier. Four models can be...

Questions in other subjects: