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?

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 17:10

Four analysts cover the stock of fluorine chemical. one forecasts a 6% return for the coming year. the second expects the return to be negative 6%. the third predicts a return of 8%. the fourth expects a 2% return in the coming year. you are relatively confident that the return will be positive but not large, so you arbitrarily assign probabilities of being correct of 35 % comma 8 %, 17 %, and 40%, respectively, to the analysts' forecasts. given these probabilities, what is fluorine chemicals expected return for the coming year

Answers: 3

Answer

Business, 22.06.2019 02:30

Acompany factory is considered which type of resource a.land b.physical capital c.labor d.human capital

Answers: 2

Answer

Business, 22.06.2019 08:30

Which of the following is an example of search costs? a.) driving to a faraway place to find available goods b.) buying goods in some special way that is outside the normal channels c.) paying a premium cost for goods d.) selling extra goods for a discount price

Answers: 1

Answer

Business, 22.06.2019 11:10

Yowell company granted a sales discount of $360 to a customer when it collected the amount due on account. yowell uses the perpetual inventory system. which of the following answers reflects the effects on the financial statements of only the discount? assets = liab. + equity rev. − exp. = net inc. cash flow a. (360 ) = na + (360 ) (360 ) − na = (360 ) (360 ) oa b. na = (360 ) + 360 360 − na = 360 na c. (360 ) = na + (360 ) (360 ) − na = (360 ) na d. na = (360 ) + 360 360 − na = 360 na

Answers: 1

Answer

You know the right answer?

A large sporting goods store is placing an order for bicycles with its supplier. Four models can be...

Questions