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

Another question on Business

question
Business, 21.06.2019 21:30
The beach dude (bd) employs a legion of current and former surfers as salespeople who push its surfing-oriented products to various customers (usually retail outlets). this case describes bd's sales and collection process. each bd salesperson works with a specific group of customers throughout the year. in fact, they often surf with their customers to try out the latest surf gear. the bd salespeople act laid-back, but they work hard for their sales. each sale often involves hours of surfing with their customers while the customers sample all the latest surf wear. because bd makes the best surfing products, the customers look forward to the visits from the bd salespeople. and they often buy a lot of gear. each sale is identified by a unique invoice number and usually involves many different products. customers pay for each sale in full within 30 days, but they can combine payments for multiple sales. bd manages its clothing inventory by item (e.g., xl bd surfer logo t-shirts), identified by product number, but it also classifies the items by clothing line (the lines are differentiated by price points as well as the intended use of the clothing, e.g., surfing products, casual wear, . draw a uml class diagram that describes the beach dudes sales and collection process.b. using microsoft access, implement a relational database from your uml class diagram. identify at least three fields per table.c. describe how you would use the relational database to determine the beach dude’s accounts receivable.
Answers: 3
question
Business, 22.06.2019 21:00
China's new 5 percent tax on disposable wooden chopsticks, reflecting concerns about deforestation, has been praised by environmentalists. the move is hitting hard at the japanese, who consume 25 billion set of wooden chopsticks annually. almost all of the chopsticks used in japan come from china. the reuirements for chinese manufacturers of wooden chopsticks to pay the 5 percent tax is a factor in their external environment.
Answers: 3
question
Business, 23.06.2019 07:40
In the short-run, marginal costs are equal to the change in variable costs as output changes. ( mc = change in variable cost / change in quantity) assume that capital is fixed in the short-run. (a) start with the equation for marginal cost and derive an equation that relates marginal cost of production to the cost and productivity of labor. (b) draw a standard looking short-run marginal cost curve and use the equation you derived to explain its shape.
Answers: 2
question
Business, 23.06.2019 07:50
Discuss the positive and negative effects of the north american free trade agreement on the united states. support your conclusions with examples and evidence from the lesson.
Answers: 2
You know the right answer?
A large sporting goods store is placing an order for bicycles with its supplier. Four models can be...
Questions
question
English, 25.03.2021 20:40
question
Biology, 25.03.2021 20:40
question
Mathematics, 25.03.2021 20:40
Questions on the website: 13722361