RVW (Restored Volkswagens) buys 15 used VW's at each of two car auctions each week held at different locations. It then transports the cars to repair shops it contracts with. When they are restored to RVW's specifications, RVW sells 10 each to three different used car lots. There are various costs associated with the average purchase and transportation prices from each auction to each repair shop. Also there are transportation costs from the repair shops to the used car lots. RVW is concerned with minimizing its total cost given the costs in the table below. Given the costs below, draw a network representation for this problem. a. Repair Shops S2 500 Used Car Lots L1 L2 300 L3 550 600 sI 250 Auction 1 Auction 2 500 450 S2 350 650 450 b. Formulate this problem as a transshipment linear programming model. с. Report the optimal solution using excel solver.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter10: Short-term Decision Making
Section: Chapter Questions
Problem 3PB: Cinnamon Depot bakes and sells cinnamon rolls for $1.75 each. The cost of producing 500,000 rolls in...
icon
Related questions
Question
RVW (Restored Volkswagens) buys 15 used VW's at each of two car auctions each week held at different
locations. It then transports the cars to repair shops it contracts with. When they are restored to RVW's
specifications, RVW sells 10 each to three different used car lots. There are various costs associated with
the average purchase and transportation prices from each auction to each repair shop. Also there are
transportation costs from the repair shops to the used car lots. RVW is concerned with minimizing its
total cost given the costs in the table below.
a. Given the costs below, draw a network representation for this problem.
Used Car Lots
L2
Repair Shops
si
550
600
S2
500
LI
L3
500
Auction 1
sI
250
300
Auction 2
450
S2
350
650
450
b. Formulate this problem as a transshipment linear programming model.
Report the optimal solution using excel solver.
с.
Transcribed Image Text:RVW (Restored Volkswagens) buys 15 used VW's at each of two car auctions each week held at different locations. It then transports the cars to repair shops it contracts with. When they are restored to RVW's specifications, RVW sells 10 each to three different used car lots. There are various costs associated with the average purchase and transportation prices from each auction to each repair shop. Also there are transportation costs from the repair shops to the used car lots. RVW is concerned with minimizing its total cost given the costs in the table below. a. Given the costs below, draw a network representation for this problem. Used Car Lots L2 Repair Shops si 550 600 S2 500 LI L3 500 Auction 1 sI 250 300 Auction 2 450 S2 350 650 450 b. Formulate this problem as a transshipment linear programming model. Report the optimal solution using excel solver. с.
A
B
D
F
G
J
K
L
1
2
4.
X1
X2
X3
Х4
X5
X6
X7
X8
คำตอบ
Optimal Target
เป้าหมายต่อหน่วย
7
8
Existing Remaining
9.
Constraints
Used
10
CS1
11
CS2
12
CS3
13
CS4
14
C5
15
CS6
16
CS7
17
CS8
18
19
Transcribed Image Text:A B D F G J K L 1 2 4. X1 X2 X3 Х4 X5 X6 X7 X8 คำตอบ Optimal Target เป้าหมายต่อหน่วย 7 8 Existing Remaining 9. Constraints Used 10 CS1 11 CS2 12 CS3 13 CS4 14 C5 15 CS6 16 CS7 17 CS8 18 19
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Asset replacement decision
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning