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. Used Car Lots L2 300 a. Repair Shops S2 500 LI SI S2 L3 550 250 Auction 1 Auction 2 500 600 450 350 650 450 b. Formulate this problem as a transshipment linear programming model. с. Report the optimal solution using excel solver.

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. Used Car Lots L2 300 a. Repair Shops S2 500 LI SI S2 L3 550 250 Auction 1 Auction 2 500 600 450 350 650 450 b. Formulate this problem as a transshipment linear programming model. с. Report the optimal solution using excel solver.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

The tables below are actitvites slack times and number of workers required respectively. A-B B-D D-E A-D T1. (slack) A-D B-E B-C C-E 8 6 4 1 T2. (workers) B-E B-C C-E 3 2 3 4 3 2 2 Q2. In the above table, the completion times of the activities BD and DE are on average 6 hours and 8 hours, respectively, and if the variances of the completion times of the same activities are 16 and 9 hours, respectively. a. What is the expected total completion time of the project? b. What is the probability that the project will be completed in 20 hours in total?
Just post is a new courier service company which services all provinces in the South Africa. They charge their customers based on the weight of the parcel as indicated in the table below. However, if kilograms are above 50, the cost is charged according to the number of hours it took to deliver. Although the time is entered in minutes but they are charged R95.00 per hour. Clients may also add some extras to the delivery such as insurance which is charged 8.5% and priority is charged at 5% of the charge.Table 1:Distance Weight Cost (R)Local Under 5 kg R125.00Local 5 kg up to 20 kg R175.00Local Over 20 Kg R250.00Long Under 5 kg R390.00Long 5 kg up to 20 kg R450.00Write a program that will assist with calculating the postage amount.
The stand rental system is going to be used by any company to search for stands, either by prices, by prices, or by types. If there is any interest then the company will request a quotation through the system. This request will be assessed by a salesman of INSIGHTS. The salesman will issue a quotation accordingly. In the case the prices are convenient, the company will reserve the stands that it is interested in. The company has three days to pay the costs of the stands. The costs are obtained from the invoice generated by the salesman. The company can cancel its reservation any time. Furthermore, before the starting of the event, an employee of INSIGHTS with the role of supervisor will generate a report about the companies that paid the fees and the current setup of the exhibition. The supervisor will also issue the necessary reminders to the companies to bring their equipment as well as bring their promotion documents to the site of the exhibition. In order to implement the expected…
GENERATE THE DECISION VARIABLE SOLUTION AND GENERATE AN ANSWER REPORT 2. During the winter WeeMow Lawn Service contracts with customers for cutting lawns starting in the spring. WeeMow provides service to residential and commercial customers. The service has identified 50 possible residential customers and 15 potential commercial customers it has contacted. WeeMow services a customer once every 2 weeks during the growing season. A residential lawn on average takes 1.2 hours to cut, and a commercial property requires 5 hours to cut; the service's available work time is 8 hours, 6 days per week. The profit for a residential lawn is $23, and the profit for a commercial property is $61. The service has established a weekly budget of $350 for management, gas, and other materials, plus equipment repair. A residential lawn averages $12 in management, gas, material, and repair costs, and a commercial property averages $20 in costs. WeeMow wants to know how many residential and commercial jobs…
3G R 4G O 53% D 17:57 CMPG 121 Final... Loyalty points are awarded by a company based on the amount a customer spend. Loyalty points can be used immediately with the current transaction or can be accumulated. The number of loyalty points per transaction is calculated as follows: For purchases of R 500.00 or less, 1 loyalty point will be awarded per R 50.00 spent. For purchases of more than R 500.00 the following applies: • For the first R 500.00, 1 loyalty point will be awarded per R 50.00 spent For the remainder of the amount, 2 loyalty points will be awarded per R50.00 spent. Examples: For purchases of R 460.00, 9 loyalty points will be awarded. For purchases of R 660.00, 10 loyalty points will be awarded for the first R 500.00 and 6 loyalty points for the remaining R 160.00 = 16 loyalty points For purchases of R 1250.00, 10 loyalty points will be awarded for the first R 500.00 and 30 loyalty points for the remaining R 750.00 = 40 loyalty points The monetary value of the loyalty…
Due to COVID-19 pandemic which has caused high surge of patients at hospital, patients who diagnosed COVID-19 with no symptoms or mild symptoms are instructed to home quarantine and self-monitoring. Table 5 below shows an example of continuous monitoring of a patient's body temperature (TEMP) in 5 hours consecutively using a wearable thermometer. Table 5: Body Temperature Reading example within 5 hours continuous monitoring t (hour) TEMP (°C) 2 3 4 36.9 37.6 37.9 37.0 39.6 You are instructed to design a C program with the following specification: i. Read a 5 hours body temperature measurement result to obtain hour-by-hour value as shown in Table 5 using pre-defined function. ii. Scan through the body temperature value one by one and trigger the auto alarm system using pre-defined function in case any incident is detected as below: • Any TEMP value exceeds the threshold value of 39.5°C (e.g. t = 5 when ТЕMP - 39.6°C). • When TEMP value shows an increasing trend for 3 hours consecutively…