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…
Joburg Logistics (JL), a distributor of various products in
Polokwane receives their products from suppliers in
Durban, Cape Town, and Johannesburg. The company's
management is concerned with the supply cost of a
certain product that is supplied by a manufacturer in
Durban. Currently JL has a contract with Transnet Freight
Rail (TFR) for the transport of the orders from Durban. The
following are the rail rate and transit time:
Transit time (rail)
Rail rate
5 days
R2.75/unit
The impact on the transport and inventory carrying cost
because of this arrangement is a concern of the logistics
director, Mrs Micky. As a result, Mrs Micky has requested
the logistics manager to evaluate the option to use a 3PL
service provider for the shipment from Durban to
Johannesburg. The logistics manager has identified a
certain 3PL company that has the capacity to perform this
contract. However, in order to provide a transport rate, the
3PL company required the size and frequency of orders.
JL currently…
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_forwardPlease help me with part barrow_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_forward
- 2. As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem solving costs $8000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem solving that should be offered in order to minimize total cost. b. Determine the optimal…arrow_forwardAs part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem-solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem-solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem-solving costs $8,000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem-solving that should be offered in order to minimize total cost.b. Graph the feasible…arrow_forwardProblem-solving is a critical technique used in many businesses to overcome challenges and improve services.In the case of CoffeeVille, they faced a limitation in their delivery service which was affecting their business operations. The problem-solving process was used to find a solution to this issue.Possible solutions could have included hiring more delivery personnel, optimizing delivery routes, or implementing a delivery scheduling system. After evaluating these solutions, they might have chosen to hire more delivery personnel and optimize delivery routes as the most feasible and impactful solution. After implementing these changes, they would have reviewed their delivery service to ensure that the problem was effectively solved. This is a simplified example, but it illustrates how problem-solving can be used to overcome challenges and improve services in a business context. Perform a self evaluation of the critical thinking skills. This must include writing and responding to five…arrow_forward
- Earth Resources Corporation is a multinational company engaged in steamfield development and power plant construction through the government's use of build-operate- transfer (BOT) contracts. Recently, the company has been awarded contracts and has to start drilling operations at four (4) new geothermal sites in the Philippines. In order to ensure that drilling operations are on schedule and in accordance with the provisions of the contract, Earth Resources must send a team of two (2) drilling engineers to each site. Currently, they have eight (8) drilling engineers at various sites where the drilling is almost completed. The chief executive officer (CEO) wants to mobilize all the eight engineers to the four new sites in such a way that the total costs involved is minimized. The CEO requested the company's chief accountant, Ms. Debbie Castro, to prepare a summary of the estimated mobilization costs from the engineer's present locations to their probable new assignments. accomplished…arrow_forwardQuantum Ltd. (QL) was created by a group of university students who completed film school and wanted to create feature films using Canadian locations and Canadian film crews. QL’s management team knows that there may be difficulties working in some locations due to terrain, weather, and availability of personnel trained to work in the film industry. As a result, QL is going to set up training programs to allow interested Canadians to take unpaid internships to shadow QL’s film crews and learn the trade so on a future film individuals can obtain paid positions. QL believes this will also give it an advantage in the film industry, as it will be creating an effective and efficient film-making team. QL’s office staff is working to prepare a film schedule including film topics, locations, and available film workers. QL feels it can pay competitive salaries to qualified personnel working on its films. The average feature film takes 90 days to complete, from storyboard creation to the final…arrow_forwardProblem 2 The University of South Wisconsin has had steady enrollments over the past five years. The school has its one bookstore, called University Book Store, but there are also three private bookstores in town: Bill’s Book Store, College Book Store, and Battle’s Book Store. The university is concerned about the large number of students who are switching to one of the private stores. As a result, South Wisconsin’s president, Andy Lange, has decided to give a student three hours of university credit to look into the problem. The following matrix of transition probabilities was obtained: University Bill’s College Battle’s University 0.5 0.2 0.2 0.1 Bill’s 0.1 0.6 0.2 0.1 College 0.1 0.1 0.7 0.1 Battle’s 0.05 0.1 0.1 0.75 At the present time, market shares for University, College, Battle’s and Bill’s book stores are 0.3, 0.3, 0.2, 0.2. What will the market share…arrow_forward
- Trips Logistics, a third-party logistics firm that provides warehousing and other logistics services, is facing a decision regarding the amount of space to lease for the upcoming three-year period. The general manager has forecast that Trips Logistics will need to handle a demand of 100,000 units for each of the next three years. Historically, Trips Logistics has required 1,000 square feet of warehouse space for every 1,000 units of demand. For the purposes of this discussion, the only cost Trips Logistics faces is the cost for the warehouse. Trips Logistics receives revenue of $1.22 for each unit of demand. The general manager must decide whether to sign a three-year lease or obtain warehousing space on the spot market each year. The three-year lease will cost $1 per square foot per year, and the spot market rate is expected to be $1.20 per square foot per year for each of the three years. Trips Logistics has a discount rate of k = 0.1.arrow_forwardPROBLEM B As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem-solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem-solving should be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs P10,000 and each training program on problem-solving costs P8,000. 1. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem-solving that should be offered in order to minimize total cost. 2. Graph…arrow_forwardThe MidLands Trucking Company based in Louisvillehas eight trucks located throughout the Mideast that havedelivered their loads and are available for shipments. Through their Internet logistics site MidLands has re-ceived shipping requests from 12 customers. The follow-ing table shows the mileage for a truck to travel to a customer location, pick up the load, and deliver it. Determine the optimal assignment of trucks to customersthat will minimize the total mileage. Customers Truck A B C D E F G H I J K L1 500 730 620 410 550 600 390 480 670 710 440 5902 900 570 820 770 910 660 650 780 840 950 590 6703 630 660 750 540 680 750 810 560 710 1200 490 6504 870 1200 810 670 710 820 1200 630 700 900 540 6205 950 910 740 810 630 590 930 650 840 930 460 5606 1100 860 800 590 570 550 780 610 1300 840 550 7907 610 710 910 550 810 730 910 720 850 760 580 6308 560 690 660 640 720 670 830 690 880 1000 710 680arrow_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,