Bikes.com is a web-based company that sells bicyles on the Internet. Its distinctive feature is that...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Bikes.com is a web-based company that sells bicyles on the Internet. Its distinctive feature is that it allows customers to customize the design when they order and then to receive quick delivery. Bikes.com gives customers choices for frame size (34, 36, 38), suspensions (standard or heavy duty), and gear speeds (5,10,15). As a result, customers can order 1 of 18 possible combinations (3 2 3) which are presented in Table 1. 2223 9 10 11 12 72 2 2222 22 13 8212 721L 6123 512 2 1 1 41215 3113 12 Model A 1 2 1 1 B C 1 Orders 4 5 0 1 7 0 4 8 13 B3LL5 1 0 Table 1: Bikes.com product portfolio 14 15 16 17 18 13 3126 3 2 3 3 3 1 4 0 1 235 22 The company shorthand refers to frame size as option A (A1 is the 34 inch model, A2 is the 36 inch model, and A3 is the 38-inch model). Similarly, the standard suspension is option B1, and the heavy-duty suspension is B2. The gear speeds are C1 (50), C2 (10) and C3 (15). Rather than stock 18 different types of bicycles, Bikes.com holds inventories of the eight major components, and then assembles the bikes once a customer order comes in. Orders are taken Mondays through Wednesdays, assemblies are done on Thursdays and shipments go out on Fridays. Thus, at the close of business on Wednesday, Bikes.com has an inventory of components and a list of orders and its task is to decide what demands to meet to maximize profit. Tables 1 and 2 describe customers orders for this week and the inventory status at the end of Wednesday. Component A1 A2 A3 B1 B2 C1 C2 C3 Inventory 59 87 93 15 97 76 54 42 Table 2: Bikes.com components inventory The profitability varies by model type, as shown in Table 3. Model 1 2 3 4 5 6 Profit 45 55 70 65 75 7 8 9 10 90 47 57 72 67 11 12 13 14 15 16 17 18 77 92 50 60 75 70 80 95 Table 3: Bikes.com product profits 1. Write a mathematical model to maximize the profit that can be achieved from this week's orders. 2. Implement this model in GAMS to obtain an optimal solution. Bikes.com is a web-based company that sells bicyles on the Internet. Its distinctive feature is that it allows customers to customize the design when they order and then to receive quick delivery. Bikes.com gives customers choices for frame size (34, 36, 38), suspensions (standard or heavy duty), and gear speeds (5,10,15). As a result, customers can order 1 of 18 possible combinations (3 2 3) which are presented in Table 1. 2223 9 10 11 12 72 2 2222 22 13 8212 721L 6123 512 2 1 1 41215 3113 12 Model A 1 2 1 1 B C 1 Orders 4 5 0 1 7 0 4 8 13 B3LL5 1 0 Table 1: Bikes.com product portfolio 14 15 16 17 18 13 3126 3 2 3 3 3 1 4 0 1 235 22 The company shorthand refers to frame size as option A (A1 is the 34 inch model, A2 is the 36 inch model, and A3 is the 38-inch model). Similarly, the standard suspension is option B1, and the heavy-duty suspension is B2. The gear speeds are C1 (50), C2 (10) and C3 (15). Rather than stock 18 different types of bicycles, Bikes.com holds inventories of the eight major components, and then assembles the bikes once a customer order comes in. Orders are taken Mondays through Wednesdays, assemblies are done on Thursdays and shipments go out on Fridays. Thus, at the close of business on Wednesday, Bikes.com has an inventory of components and a list of orders and its task is to decide what demands to meet to maximize profit. Tables 1 and 2 describe customers orders for this week and the inventory status at the end of Wednesday. Component A1 A2 A3 B1 B2 C1 C2 C3 Inventory 59 87 93 15 97 76 54 42 Table 2: Bikes.com components inventory The profitability varies by model type, as shown in Table 3. Model 1 2 3 4 5 6 Profit 45 55 70 65 75 7 8 9 10 90 47 57 72 67 11 12 13 14 15 16 17 18 77 92 50 60 75 70 80 95 Table 3: Bikes.com product profits 1. Write a mathematical model to maximize the profit that can be achieved from this week's orders. 2. Implement this model in GAMS to obtain an optimal solution.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these economics questions
-
Bikes.com is a web-based company that sells bicycles on the internet. Its distinctive feature is that it allows customers to customize the design when they order and then to receive quick delivery....
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Mike is a salesperson in a retail carpet store. He is paid $500 base salary per month plus 5% commission on sales over $10,000. His sales this month were $23,750. His total deductions were $152.75....
-
Find the best autoregressive model for each of the variables in the Excel file Retail Electricity Prices. a. Residentail b. Commercial c. Industrial
-
Give common and systematic names for each of the following compounds: a. CH3CH2CH2CH2CH2CH2NH2 b. CH3CH2CH2NHCH2CH2CH2CH3 c. d. e. CHCHCH2NHCHCH2CH3 CH3 CH3 CH CH2CH2NCH2CH3 CH2CH3 NH2
-
Analyze the relationship between women's rights, culture, and national prosperity.
-
The time between arrivals of cars at the Petroco Service Station is defined by the following probability distribution: Time Between Arrivals (min.) ......... Probability 1 ............... .15 2...
-
Two artifacts in a museum display are hung from vertical walls by very light wires, as shown in the figure. A. Find the tension in the horizontal wire if w=171N and m=33.0kg (T1) B. Find the tension...
-
In a study of pain relievers, 20 people were given product A, and all but 13 experienced relief. In the same study, 100 people were given product B, and all but 80 experienced relief. Fill in the...
-
Have you had experience in which an improvement plan and budget items clash with traditions or common ways of doing things in the school? What happened in that circumstance?
-
Identify and discuss possible effects of the various psychological factors on the outcome of Nutrition Therapy
-
Did Walmart's organizational culture have anything to do with its failure in Germany? What aspects of Germany's macroeconomy impacted Walmart's failure? What could Walmart have done better as an...
-
What are examples of well-written financial goals? Multiple select question. Investing $250 per month for retirement in 40 years Purchasing new movie tickets at the early bird rates Developing a...
-
Vicente currently has $24,300.00 saved. He plans to save $74,500.00 per year for 5 years, with his first annual savings contribution expected in 1 year. He then plans to withdraw $150,000.00 per year...
-
Read "establishing and developing strategic relationships the role for operations managers." using your online research skills, identify at least one other scholarly resource on this topic. For your...
-
Will the prediction interval always be wider than the estimation interval for the same value of the independent variable? Briefly explain.
-
Compare different cooling schedule of simulated annealing.
-
Discuss the perturbation mechanism of simulated annealing.
-
What are the pros and cons of GA and SA? Can we conceive of a framework that combines the best of both worlds?
Study smarter with the SolutionInn App