Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Suppose that you have a fleet of dry bulk, tanker and combined carriers. You should determine a chartering strategy for the vessels in accordance with the changes in the freight market.
A supplier ships goods from Richmond, VA to three market places in 3 cities (Chicago, IL; Athens, GA;
St. Luis, MO). The supplier can ship every day, every other day, or every third day.
There is a penalty of $0.30/cwt for each day delayed.
Consolidating shipments allows for lower transportation costs from larger loads, but incurs penalty
costs due to the delay.
Transportation Rate
(S/cwt)
Shipment
City
Weight/day
LTL
50,000 lb
50000 Ib
Chicago, IL
18,000 lb (180 cwt)
1.50
1.25
Athens, GA
15,000 lb (150 cwt)
1.35
1.00
St. Luis, MO
12,000 lb (120 cwt)
2.00
1.50
Total
45,000 lb = 450 cwt
!3!
Find what is the cost for the following:
Shipping Every Day
Shipping on the alternate Day (every two days)
Shipping every three Day
A supplier ships goods from Richmond, VA to three market places in 3 cities (Chicago, IL; Athens, GA;
St. Luis, MO). The supplier can ship every day, every other day, or every third day.
There is a penalty of $0.30/cwt for each day delayed.
Consolidating shipments allows for lower transportation costs from larger loads, but incurs penalty
costs due to the delay.
Transportation Rate
(S/cwt)
Shipment
City
Weight/day
LTL
50,000 lb
50000 lb
Chicago, IL
18,000 lb (180 cwt)
1.50
1.25
Athens, GA
15,000 lb (150 cwt)
1.35
1.00
St. Luis, MO
12,000 lb (120 cwt)
2.00
1.50
Total
45,000 Ib = 450 cwt
Find what is the cost for the following:
Shipping Every Day
Shipping on the alternate Day (every two days)
Shipping every three Day
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- 2. Metropolitan Manila has four incinerator sites for processing solid waste. There are five garbage collection areas within the metropolis. The city wants to determine the least-cost method of disposing of its trash. Each incinerator is characterized by an operating cost for processing each ton of waste and also a cost for transporting each ton of waste is summarized in the table below: Collection Incinerator Site Area 1 2 3 4 50 120 110 60 B 100 55 90 70 60 40 80 65 90 75 85 110 80 100 95 65 Incinerator sites 1 and 2 have a weekly capacity of 6,000 tons each, site 3 has a capacity of 8,000 tons and site 4 has a capacity of 10,000 tons. There are 4,000 tons of waste generated at area A, 8,000 tons at area B and 5,000 tons each at areas C and D, each week. A total of 25,000 tons of waste each week are generated from all five areas.arrow_forwardCleveland Area Rapid Delivery (CARD) operates a delivery service in the Cleveland metropolitan area. Most of CARD's business involves rapid delivery of documents and parcels between offices during the business day. CARD promotes its ability to make fast and on-time deliveries anywhere in the metropolitan area. When a customer calls with a delivery request, CARD quotes a guaranteed delivery time. The following network shows the street routes available. The numbers above each arc indicate the travel time in minutes between the two locations. Min s.t. Node 1 Flows Node 2 Flows Node 3 Flows Node 4 Flows Node 5 Flows Node 6 Flows 35 For all X;; = 0, 1. (a) Develop a linear programming model that can be used to find the minimum time required to make a delivery from location 1 to location 6. (Express your answers in the form where each Xij represents the arc from node i to node j as either 1 or Xijr 0.) 30 12 p.m. 3 Need Help? Read It 18 15 39 12 16 5 (b) How long (in minutes) does it take to…arrow_forwardDiscuss the use of event-driven architectures in enhancing fleet management and logistics in the transportation industry.arrow_forward
- Morgan Trucking Company operates a special pickup and delivery service between Chicago and six other cities located in a four-state area. When Morgan receives a request for service, it dispatches a truck from Chicago to the city requesting service as soon as possible. With both fast service and minimum travel costs as objectives for Morgan, it is important that the dispatched truck take the shortest route from Chicago to the specified city. Assume that the following network (not drawn to scale) with distances given in miles represents the highway network for this problem. Chicago 1 36 31 21 2 3 9 10 11 21 4 13 Find the shortest-route distance from Chicago to node 6. 6 5 6 16 6 21 7arrow_forwardes Problem 11-4 (LO2) An appliance manufacturer has a plant near Toronto that receives small electric motors from a manufacturer located in Winnipeg. The demand for motors is 118,000 units per year. The cost of each motor is $125. The motors are purchased in lots of 3.400 units. The ownership of motors transfers to the appliance manufacturer in Winnipeg. The question is which mode of transportation, truck or train, the appliance manufacturer should use to bring the motors from Winnipeg to Toronto. The railroad company charges $3 per motor. and it takes approximately seven days by train. The trucking company charges $5 per motor, but it takes only three days. The appliance manufacturer will keep 1,400 units as safety stock if a truck is used and 2.500 units as safety stock if a train is used for transportation. Assume 365 days per year. If the holding cost rate is 25 percent of unit cost per year, which mode of transportation will minimize total transportation and in-transit and safety…arrow_forwardSealy Ltd. is a newly established mattress factory that has calibrated its operations towards supplying high quality mattresses to the hotel trade as well as to the general public. The company intends to maximize it supply chains operations by ensuring that the three macro processes that manage the flow of information, product and funds required to generate, receive and fulfill a customer order is optimized in its operations. The company’s transportation network is also being designed but is being analyzed in terms of possible trade-offs that may have to be made in order to optimize the operation. Additionally, another far reaching decision that the company has to make is regarding the sourcing of raw material for their operations in particular whether to source in house or to outsource the supply chain function. As a new company in the 21st Century it is expected that information technology will play a pivotal role in the operations of the company Describe the functioning of the…arrow_forward
- Zara is a global clothing company based in Spain and it gives utmost importance to customer value, hence it tries to catch customer satisfaction in transportation. Zara expects the following points to be fulfilled by transport companies: The products must be reached to desired places on time, the products must be shipped without any damage or unwanted condition, the products must be carried to next channel level in a good condition. Additionally, Zara gives less weight to freight costs while determining product prices. Which of the followings is less important in transportation policy of Zara? Select one: a. Condition of goods b. Pricing c. Delivery performance d. Customer satisfactionarrow_forwardUse the appropriate strategy to assign joint costs of an LTL route to each of the following shipments. Show your calculations and the assigned cost below. [1] A PUD truck driver works ten hours serving local customers for an LTL carrier. On the route, the driver makes 12 stops at area industries. The driver averaged 25 miles per hour while driving and drove 150 miles. During the trip, the driver handled 80 separate shipments, filling 70% of his truck by weight and 65% by the cube. The route cost a total of $2450. Using the time strategy for PUD cost assignment, determine the costs to be assigned to Shipper A and each shipment if the driver handled 4 shipments (3 delivered, 1 picked up) at the stop, and took 40 minutes to serve the Shipper. Total Assigned Cost for Shipper A Assigned Cost for Each Shipment [2] An LTL linehaul truck route takes 15 hours to complete. During the move, the truck moved an average of 36,500 pounds of freight, which filled 3200 cubic feet of the trailer. The…arrow_forwardDescribe situations in which the single-period model is appropriate and solve typical problems.arrow_forward
- Explain: Peak load pricing, Preprocessing strategy, Arrival process, Unstable queuearrow_forwardThe Awesome Skis Company has manufacturing plants in Portland, Oregon and Toronto, Ontario. You have been given the job of coordinating distribution of the latest model, the Superslide, to outlets in Lake Tahoe and Whistler. The Portland plant, when operating at full capacity, can manufacture 620 pairs Superslide skis per week, while the Toronto plant, beset by labor disputes, can produce only 410 pair of skis per week. The outlet in Lake Tahoe orders at least 500 pairs Superslide skis per week, while Whistler orders at least 530 pairs of skis per week. Transportation costs are as follows: Portland to Lake Tahoe: $10 per pair of skis; Portland to Whistler: $5 per pair of skis. Toronto to Lake Tahoe: $20per pair of skis; Toronto to Whistler: $10 per pair of skis. (a) You want to ship as many skis as you can filling all the orders and yet, you want to minimize your costs. If so, how many skis should be shipped from each manufacturing plant to each…arrow_forwardThe Superior Manufacturing Company wants to make two shipments from Dallas, Texas to Los Angeles, California. The first shipment weighs 10,000 pounds and the second shipment weighs 15,000 pounds. The carrier charges $10 per hundredweight (cwt) if the goods are shipped separately and they arrive in two days. If the goods can be consolidated into one shipment the cost would be $8 per cwt to ship them in a truckload lot, but it would cost $500 to consolidate the shipments at the carrier’s warehouse and it would take three days. Which is the lowest cost approach and which approach would you select?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,