MindTap Business Statistics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition, [Instant Access], 2 terms (12 months)
8th Edition
ISBN: 9781337274876
Author: Cliff Ragsdale
Publisher: Cengage Learning US
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_forward2. 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_forward
- 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 $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_forwardEarth 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_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
- The Seaside Hotel is a three-star hotel in Newquay, Cornwall. It contains 108 rooms and employs 30 fulltime and 40 parttime personnel. Between May and August, the hotel's workforce is nearly doubled by casual and temporary workers. Cornwall is a difficult place to do business, especially in the tourism industry. Business is highly seasonal with hotels experiencing very low occupancy during the offseason and many hotels choose not to operate during this time. The Seaside Hotel operates all year round by supplementing its tourism trade during the off-season by offering discounted conferencing facilities for local businesses and as a cheap base for corporate events and activities, such as team building weekends. Tourism is, however, vitally important for the region and its businesses and provides a significant proportion of all jobs in the South West. Cornwall can, however, be a difficult place in which to work. For instance, Newquay – Cornwall’s most popular holiday destination – is one…arrow_forwardhelp pleasearrow_forwardState University has decided to reconstruct the sidewalks throughout the east side of its campus to provide wheelchair access. However, upgrading sidewalks is a very expensive undertaking, so for the first phase of this project, university administrators want to make sure they connect all buildings with wheelchair access with the minimum number of refurbished sidewalks possible.Following is a network of the existing sidewalks on the east side of campus, with the feet between each building shown on the branches: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,