Assign trucks to delivery routes so that total costs are
minimized, given the cost data shown. What is the total cost?
(Leave no cells blank - be certain to enter "0" wherever
required. Omit the "$" sign in your response.)
ROUTE | ||||||
A | B | C | D | E | ||
1 | 4 | 5 | 9 | 8 | 7 | |
2 | 6 | 4 | 8 | 3 | 5 | |
Truck | 3 | 7 | 3 | 10 | 4 | 6 |
4 | 5 | 2 | 5 | 5 | 8 | |
5 | 6 | 5 | 3 | 4 | 9 | |
Optimal Table | |||||
A | B | C | D | E | |
1 | |||||
2 | |||||
3 | |||||
4 | |||||
5 | |||||
Total cost $
______?
The problem is formulated in excel as below. The below 2 images show the formulation as well as the formulas used
Post these the solver parameters need to be entered as per the below image.
Once this is done, click on solve. The solver will solve the problem and show the message stating the same. Click on ok. The excel will now have the final solution as per below image.
Hence we can see that the total cost is 18 with below assignment
Truck 1 - A
Truck 2 - E
Truck 3 - D
Truck 4 - B
Truck 5 - C
Assign trucks to delivery routes so that total costs are minimized, given the cost data shown....
Problem 16-3 Assign trucks to delivery routes so that total costs are minimized, given the cost data shown. What is the total cost? (Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) W D TO ROUTE B C 59 4 8 3 10 2 5 5 3 Truck min 3 4 5 4 in 000 Optimal Table up www Total cost $0
Yoshi Company completed the following transactions and events involving its delivery trucks Year 1 Jan. 1 Poid $22,015 cash plus $1,785 in sales tax for a new delivery truck estimated to have a five-year life and a $2,000 salvage value. Delivery truck costs are recorded in the Trucks, account. Dec. 31 Recorded annual straight-line depreciation on the truck. Year 2 Dec. 31 The truck's estimated useful life was changed from five to four years, and the estimated salvage value was...
Manager Chris Channing of Fabric Mills, Inc., has developed the forecast shown in the table for bolts of cloth. The figures are in hundreds of bolts. The department has a normal capacity of 275(00) bolts per month, except for the seventh month, when capacity will be 250(00) bolts. Normal output has a cost of $40 per hundred bolts. Workers can be assigned to other jobs if production is less than normal. The beginning inventory is zero bolts. Month 1 2...
Problem 10-7 The postmaster of a small western town receives a certain number of complaints each day about mail delivery. 1 4 2 10 3 15 4 8 5 9 6 6 7 5 DAY 8 13 9 15 10 7 11 6 Number of complaints a.Determine two-sigma control limits using the above data. (Round your intermediate calculations to 4 decimal places and final answers to 3 decimal places. Leave no cells blank - be certain to enter "0" wherever...
Problem 10-7 The postmaster of a small western town receives a certain number of complaints each day about mail delivery. 6 1 4 Number of complaints 2 10 3 14 4 8 5 9 DAY 8 13 7 5 9 13 10 7 11 6 12 4 13 2 14 9 6 a.Determine three-sigma control limits using the above data. (Round your intermediate calculations to 4 decimal places and final answers to 3 decimal places. Leave no cells blank -...
1- (20 pts) Office Depot is open from 7:00 AM to 6:00 PM and it receives 200 calls per day for delivery orders. It costs Office Depot $25 to send out its trucks to make deliveries. The company estimates that each minute a customer spends waiting for an order costs Office Depot S0.20 in lost sales. 1- How frequently should Office Depot send out its delivery trucks each day? 2- Indicate the total daily cost of deliveries. 3- If a...
The postmaster of a small western town receives a certain number of complaints each day about mail delivery. 2 1 4 Number of complaints 3 14 4 8 5 9 6 6 DAY 8 13 7 5 9 14 10 7 11 6 12 4 13 2 14 11 11 a.Determine two-sigma control limits using the above data. (Round your intermediate calculations to 4 decimal places and final answers to 3 decimal places. Leave no cells blank - be certain...
Yoshi Company completed the following transactions and events involving its delivery trucks. Year 1 Jan. 1 Paid $22,015 cash plus $1,635 in sales tax for a new delivery truck estimated to have a five-year life and a $2,300 salvage value. Delivery truck costs are recorded in the Trucks account. Dec. 31 Recorded annual straight-line depreciation on the truck. Year 2 Dec. 31 The truck's estimated useful life was changed from five to four years, and the estimated salvage value was...
Chech Yoshi Company completed the following transactions and events involving its delivery trucks. Year 1 Jan. 1 Paid $23,515 cash plus $1,785 in sales tax for a new delivery truck estimated to have a five-year life and a $2,300 salvage value. Delivery truck costs are recorded in the Trucks account. Dec. 31 Recorded annual straight-line depreciation on the truck. Year 2 Dec. 31 The truck's estimated useful life was changed from five to four years, and the estimated salvage value...
Yoshi Company completed the following transactions and events involving its delivery trucks. Year 1 Jan. 1 Paid $25,015 cash plus $1,935 in sales tax for a new delivery truck estimated to have a five-year life and a $2,150 salvage value. Delivery truck costs are recorded in the Trucks account. Dec. 31 Recorded annual straight-line depreciation on the truck. Year 2 Dec. 31 The truck's estimated useful life was changed from five to four years, and the estimated salvage value was...