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
Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship:Commodity Tons Available Volume per Ton (cu.ft.) Profit per Ton ($)1 4,000 40 702 3,000 25 503 2,000 60 604 1,000 50 80You can elect to load any or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions:
Cargo Hold Weight Capacity (tons) Volume Capacity (cu.ft.)Forward 3,000 100,000Center 5,000 150,000Rear 2,000 120,000More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold…
Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship:Commodity Tons Available Volume per Ton (cu.ft.) Profit per Ton ($)1 4,000 40 702 3,000 25 503 2,000 60 604 1,000 50 80You can elect to load any or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions:
Cargo Hold Weight Capacity (tons) Volume Capacity (cu.ft.)Forward 3,000 100,000Center 5,000 150,000Rear 2,000 120,000More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold…
A seafood distribution company specializes in delivering fresh lobsters from their harvesting sites to various restaurants across the coastline. The company operates a fleet of sailing vessels, each with different capacities and operational costs. Due to the perishable nature of lobsters, the company aims to optimize its distribution network to minimize total costs while meeting the demand of each restaurant.
Given Data:
Sailing Vessels (with capacities and fixed operational costs):
Vessel 1 (V1): Capacity = 300 kg, Fixed Cost = $1,000
Vessel 2 (V2): Capacity = 200 kg, Fixed Cost = $900
Vessel 3 (V3): Capacity = 400 kg, Fixed Cost = $1,200
Vessel 4 (V4): Capacity = 100 kg, Fixed Cost = $600
Restaurants (with lobster demand):
Restaurant A: Demand = 250 kg
Restaurant B: Demand = 150 kg
Restaurant C: Demand = 300 kg
Restaurant D: Demand = 100 kg
Transportation Costs (per kg) from Harvesting Sites to Restaurants:
Restaurant A…
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
- The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.arrow_forward3.4-15* A cargo plane has three compartments for storing cargo: front, center, and back. These compartments have capacity limits on both weight and space, as summarized below: Weight Саpacity (Tons) Space Сapacity (Cubic Feet) Compartment Front 7,000 9,000 5,000 12 Center 18 Back 10 Furthermore, the weight of the cargo in the respective compart- ments must be the same proportion of that compartment's weight capacity to maintain the balance of the airplane.arrow_forward4. Companies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice. Set up the solution in Excel and solve with Solver. What are total costs?arrow_forward
- Companies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice. What is the objective function? Group of answer choices Max Z = $3AD + $3AE + $4BD + $3BE + $5CD + $3CE + $4DF + $4DG + $4DH + $10EF + $9EG + $8EH Min Z = $3AD + $3AE + $4BD + $3BE + $5CD + $3CE + $4DF + $4DG + $4DH + $10EF + $9EG + $8EH Min Z = $3AD + $3BE + $5CD + $3CE…arrow_forwardThe Canadian government has built a large grain-shipping port at Churchill, Manitoba, on the Hudson Bay. Grain grown in southern Manitoba is carried by rail to Churchill during the open-water shipping season. Unfortunately the port is open only 50 days per year during July and August. This leads to some critical crew staffing decisions by management. The port has the capacity to load up to 7 ships simultaneously, provided that each loading bay has an assigned crew. The remote location and short shipping season results in a very high labor cost for each crew assigned, and management would like to minimize the number of crews. Ships arrive in a random pattern that can be modeled using the Poisson probability model. If a ship arrives and all available loading bays are filled, the ship will be delayed, resulting in a large cost that must be paid to the owner of the ship. This penalty was negotiated to encourage ship owners to send their ships to Churchill.Results of an initial analysis…arrow_forwardThe Tubular Ride Boogie Board Company has manufacturing plants in Tucson, Arizona and Toronto, Ontario. You have been given the job of coordinating distribution of the latest model, the Gladiator, to outlets in Honolulu and Venice Beach. The Tucson plant, when operating at full capacity, can manufacture 620 Gladiator boards per week, while the Toronto plant, beset by labor disputes, can produce only 410 boards per week. The outlet in Honolulu orders 500 Gladiator boards per week, while Venice Beach orders 530 boards per week. Transportation costs are as follows. Tucson to Honolulu: $10 per board; Tucson to Venice Beach: $5 per board. Toronto to Honolulu: $20 per board; Toronto to Venice Beach: $10 per board. (a) Assuming that you wish to fill all orders and ensure full capacity production at both plants, is it possible to meet a total transportation budget of $9,900? O Yes O No If so, how many Gladiator boards are shipped from each manufacturing plant to each distribution outlet? (If…arrow_forward
- Sarasota Go Karts (SGK) is a firm that manufactures racing go-karts (fictitious) in Sarasota Florida. They produce a low-volume, premium product used by those who race go-karts. In total, they produce and sell around 300 go-karts per year. They offer five different models, although some further customization can be added upon request. They sell their products directly to the consumer, who can visit their small showroom at their manufacturing plant if they are in the area. However, the majority of go-kart orders are placed via their website or the phone, and are then shipped to the customer. Over the years, SGK has ran into a number of problems. First is their inventory levels. Their finished goods inventory is substantial, at any one time they have between 250-300 finished go-karts on hand. This is because they want to have an inventory of all five go-kart models on hand at any point in time, and they produce each model in a batch of 50 units at a time. They also have substantial work…arrow_forward1.arrow_forwardThe Gorilla Oil Company near Pittsburg transports gasoline to its distributors by truck. The company recently contracted to supply gasoline distributors in Kansa, and it has $1,000,000 available to spend on the necessary expansion of its fleet of gasoline tank trucks. Three models of gasoline tank trucks are available. II. Truck Model Capacity (gallons) Purchase Cost Monthly Operating Cost Super Tanker Regular Line Econo-Tanker 5,000 3,000 2,000 $50,000 $40,000 $25,000 $1,000 $ 800 $ 600 The company estimates that the monthly demand for the region will be 500,000 gallons of gasoline. Because of the size and speed differences of the trucks, the number of deliveries or round trips possible per month for each truck model will vary. Trip capacities are estimated at 10 trips per month for the Super Tanker, 20 trips per month for the Regular Line, and 30 trips per month for the Econo-Tanker. Based on maintenance and driver availability, the firm does not want to add more than 30 new vehicles…arrow_forward
- Situation: The Sure To Peal Paint Company stores all its metal compressed gas containers in a warehouse. These long cylindrical metal tanks contain various gases used in manufacturing cans of spray paint. The gas tanks are delivered to the warehouse by truck. Two receiving dockworkers unload the containers from the delivery trucks and place them on four wheel trucks. Two materials handlers are responsible for pushing the loaded trucks into the warehouse, unloading the tanks and setting them up on end. The two materials handlers spend a major portion of their day moving loads of the gas tanks into the warehouse and placing them into the proper storage locations. In total, there are five different types of gases that in equal proportion make up 98% of all gas handled. Question: Management would like to identify a better way to handle these gas tanks. How can the handling operation be improved? Situation: The Rosemarie Cosmetic company has a warehouse of 20 high pallet racks serviced by…arrow_forwardQL (“Quebec Lumber”) is a logging and wood processing firm in a remote part of the Canadian province of Quebec. They have recently acquired a remote track of timber that is located ten miles from their processing facility. Normally, this is not a problem as they are able to simply cut the timber and haul it using trucks to their processing facility. However, this track of forestland is ten miles to their north, and there are no roads connecting the tract of land to their facility. They have also acquired a narrow (120 foot wide) ten-mile strip of land connecting this tract of timber to their processing facility. QL considered building their own road between the two points, and have log trucks haul the logs to the processing facility. However, they have decided instead to go with a less expensive option, a narrow gauge railroad. The narrow gauge railroad would require the laying of ties and steel tracks, and will require a custom-built locomotive and rolling stock (train cars that will…arrow_forwardABC Apple Juice Company produces and markets fresh fruit juice. During the apple harvest season, trucks bring apples from the fields to the process plant during a workday that runs long hours from 7AM. On peak days, approximately 3,000 kg of apples are trucked in per hour. Trucks dump their contents in a holding bin with a storage capacity of 9,000 kg. When the bin is full, incoming trucks must wait until it has sufficient available space. A conveyor moves apples from bin to the processing plant. The plant is configured to process apples at the rate of 2,000 kg per hour. Trucks arrive uniformly between 7:00AM to 5:00PM. Each truck holds about 1,000 kg of apples. The truck drivers are paid at the rate of $10 per hour. As ABC makes fresh juice, it does not store apples. Processing plant starts at 10:00AM and ends when all the apples received during the day have been processed. It takes 2 hours to clean the empty plant that must be kept ready for the next day production. Trucks are owned…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,