Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Alaskan Railroad is an independent, stand-alone railroad opertaon not connected to any other railservice in North America. As a result, rail shipments between Alaska and the rest of North America mustbe shipped by truck for thousands of miles or loaded onto ocean-going vessels and transported by sea.Alaskan Railroad recently began talks with the naon of Canada about expanding its railroad lines toconnect with the North American railway system. Figure 1 summarizes the various rail segments(associated costs in millions of U.S. dollars) that could be built. The North American railroad systemcurrently provides service to New Hazelton and Chetwynd. Alaskan Railroad would like to expand itsrailway so as to be able to reach one of these cites from Skagway and Fairbanks.Part 1. Implement a network flow model to determine the least expensive way to connect the city ofFairbanks to either New Hazelton or Chetwynd. You should include Skagway and its connections in thenetwork model for Part 1, even…
Sinclair Plastics operates two chemical plants which produce polyethylene; the Ohio Valley plant which can produce up to 10,000 tons per month and the Lakeview plant which can produce up to 7,000 tons per month. Sinclair sells its polyethylene to three different auto manufacturing plants, Grand Rapids (demand = 3000 tons per month), Blue Ridge (demand = 5000 tons per month), and Sunset (demand = 4000 tons per month). The costs of shipping between the respective plants is shown in the table below:
Grand Rapids
Blue Ridge
Sunset
Ohio Valley
50
40
100
Lakeview
60
50
75
Implement the LP model in Solver and obtain the optimal shipping plan. What is the optimized cost?
Creative Robotics (CR) manufactures two lightweight robots designed for easier house-cleaning. The Alpha-ONE model is older, heavier, and is designed for carpet cleaning. The Alpha-TWO model is newer, lighter, and is designed primarily for wooden floor cleaning. The management team is trying to identify how to minimize the total costs of producing these two models. Their full-time workers consist of primarily manufacturing experts and about 3 people are required to commit themselves to manufacture the Alpha-ONE model and 4 for the Alpha-TWO model, per day. They have a total pool of 100 full-time workers now but are willing to hire more manufacturers if required. Similarly, the Alpha-TWO model is more complex and management has a pool of 20 part-time technical workers to help with the complexity, every day. Again, they are willing to hire more part-time workers if required to assist with the Alpha-TWO model. As far as staff allocations for additional assistance in manufacturing…
Chapter 5 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
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
- State University must purchase 1,100 computers from three vendors. Vendor 1 charges $500 per computer plus a delivery charge of $5,000. Vendor 2 charges $350 per computer pluse a delivery charge of $4,000. Vendor 3 chargest $250 per computer pluse a delivery charge of $6,000. Vendor 1 will sell the university at most 500 computers; vendor 2 at most 900; and vendor 3 at most 400. Formulate an IP to minimize the cost of purchasing the needed computers.arrow_forwardThe figure below shows the possible routes from city A to city M as well as the cost (in dollars) of a trip between each pair of cities (note that if no arc joins two cities it is not possible to travel non-stop between those two cities). A traveler wishes to find the lowest cost option to travel from city A to city M. Which type of network optimization problem is used to solve this problem? Multiple Choice: Minimum Flow Problem Average-Cost Flow problem Maximum Flow Problem Shortest Path Problem Maximum-Cost Flow problemarrow_forwardThe Auto Company of America (ACA) produces six types of vehicles; which includes four styles of cars: subcompacts, compact, intermediate, and luxury; as well as trucks and vans. Vendor capacities limit total production capacity to, at most, 1.2 million vehicles per year. Subcompacts and compacts are built together in a facility with a total annual capacity of 620,000 cars. Intermediate and luxury cars are produced in another facility with a capacity of 400,000; and the truck/van facility has a capacity of 275,000. ACA’s marketing strategy requires that subcompacts and compacts must constitute at least half of the product mix for the four car types. The Corporate Average Fuel Economy (CAFE) standards require an average fleet fuel economy of at least 27 MPG. Profit margins, market potential, and fuel efficiencies are summarized below. Profit Margin ($/vehicle) Market Potential(sales in ‘000) Fuel Economy(MPG) Subcompact 150 600 40 Compact 225 400 34 Intermediate 250 300…arrow_forward
- Sports of All Sorts produces, distributes, and sells high-quality skateboards. Its supply chain consists of three factories (located in Detroit, Los Angeles, and Austin) that produce skateboards. The Detroit and Los Angeles facilities can produce 350 skateboards per week, but the Austin plant is larger and can produce up to 700 skateboards per week. Skateboards must be shipped from the factories to one of four distribution centers, or DCs (located in Iowa, Maryland, Idaho, and Arkansas). Each distribution center can process (repackage, mark for sale, and ship) at most 500 skateboards per week. Factory/DCs Shipping Costs ($ per skateboard) Iowa 4 Maryland 5 Idaho 6 Arkansas 7 Detroit 1 25.00 25.00 35.00 40.00 Los Angeles 2 35.00 45.00 35.00 42.50 Austin 3 40.00 40.00 42.50 32.50 Skateboards are then shipped from the distribution centers to retailers. Sports of All Sorts supplies three major U.S. retailers: Just Sports, Sports 'N Stuff,…arrow_forwardDoug Turner Food Processors wishes to introduce a new brand of dog biscuits composed of chicken and liver flavored biscuits that meet certain nutritional requirements. The liver flavored biscuits contain 1 unit of nutrient A and 2 units of nutrient B; the chicken flavored biscuits contain 1 unit of nutrient A and 4 units of nutrient B. According to federal requirements, there must be at least 40 units of nutrient A and 60 units of nutrient B in a package of the new mix. In addition, the company has decided that there can be no more than 12 liver flavored biscuits in a package. It costs 1¢ to make 1 liver flavored biscuit and 2¢ to make 1 chicken flavored. Doug wants to determine the optimal product mix for a package of the biscuits to minimize the firm's cost. The aim of the objective function should be to (Maximize or Minimize) the objective value.arrow_forwardDoug Turner Food Processors wishes to introduce a new brand of dog biscuits composed of chicken and liver flavored biscuits that meet certain nutritional requirements. The liver flavored biscuits contain 1 unit of nutrient A and 2 units of nutrient B; the chicken flavored biscuits contain 1 unit of nutrient A and 4 units of nutrient B. According to federal requirements, there must be at least 40 units of nutrient A and 60 units of nutrient B in a package of the new mix. In addition, the company has decided that there can be no more than 16 liver flavored biscuits in a package. It costs 1¢ to make 1 liver flavored biscuit and 2¢ to make 1 chicken flavored. Doug wants to determine the optimal product mix for a package of the biscuits to minimize the firm's cost. The aim of the objective function should be to Minimize the objective value. The optimum solution is: Number of liver flavored biscuits in a package = nothing (round your response to two decimal places).arrow_forward
- A minimum-cost flow problem has 5 supply nodes, 2 transshipment nodes, and 5 demand nodes. Each supply node can ship to each transshipment node but cannot ship to any demand node or to any other supply node. Each transshipment node can ship to each demand node, but cannot ship to any supply node or to any other transshipment node. How many arcs will be included in the model?arrow_forwardDeluxe River Cruises operates a fleet of river vessels. The fleet has two types of vessels: a type A, x, vessel has 60 deluxe cabins and 160 standard cabins, whereas a type B vessel, y, has 80 deluxe cabins and 120 standard cabins. Under a charter agreement with the Odyssey Travel Agency, Deluxe River Cruises is to provide Odyssey with a minimum of 360 deluxe and 680 standard cabins for their 15-day cruise in May. It costs $44,000 to operate a type A vessel and $54,000 to operate a type B vessel for that period. (a) How many of each type of vessel should be used to keep the operating costs C to a minimum? The minimum is C = ______at (x, y) =(_____). (b) Suppose C = cx + 54,000y. Find the range of values that the cost of operating a type A vessel, the coefficient c of x, can assume without changing the optimal solution. _____≤ c ≤_____ (c) Find the range of values that Requirement 1 for deluxe cabins can assume. (Requirement 1 pertains to the deluxe cabin requirement.)_____ ≤…arrow_forwarda company possesses two manufacturing plants, each of which can produce three products: X,Y, and Z from common raw material. However, the proportions in which the products are produced are different in each plant and so are the plant’s operating costs per hour. Following are the data on the production per hour and costs together with current orders in hand for each product. a company possesses two manufacturing plants, each of which can produce three products: X,Y, and Z from common raw material. However, the proportions in which the products are produced are different in each plant and so are the plant’s operating costs per hour. Following are the data on the production per hour and costs together with current orders in hand for each product. Plant product operating cost per hour(birr) X YZ A 2 4 3 9 B 4 3 2 10 Orders on hand 54 24 60 You are required to use graphical method to find out the number of production hours needed to fulfill the orders on…arrow_forward
- Federated Oil has refineries in Los Angeles and Chicago. The Los Angeles refinery can refine up to two million barrels of oil per year, and the Chicago refinery up to three million. After the oil is refined, it is shippedto two distribution points, Houston and New York City. Federated Oil estimates that each distribution point can sell up to five million barrelsper year. Because of differences in shipping and refining costs, the profit earned (in dollars) per million barrels of oil shipped depends on where the oil was refined and on the point of distribution. This information is listed in the file P04_69.xlsx. The company is considering expanding the capacity of each refinery.Each million barrels of annual refining capacity that isadded will cost $120,000 for the Los Angeles refinery and $150,000 for the Chicago refinery. Determine how Federated Oil can maximize its profit (including expansion costs) over a 10-year period.arrow_forwardSmall motors for garden equipment are produced at four manufacturing facilities and need to be shipped to three plants that produce different garden items (lawn mowers, rototillers, leaf blowers). The company wants to minimize the cost of transporting items between the facilities, taking into account the demand at the three different plants, and the supply at each manufacturing site. The table below shows the cost to ship one unit between each manufacturing facility and each plant, as well as the demand at each plant and the supply at each manufacturing facility. Write the model formulation for this problem.arrow_forwardThe leading tire company in Indonesia has factories in Semarang and Purwokerto. The Semarang factory can make 600 Michelin and 100 Achilles tires per day. The Purwokerto factory can make 300 Michelin and 100 Achiles tires per day. It costs $20,000 per day to operate the Semarang plant and $15,000 per day to operate the Purwokerto plant. The company has a contract to manufacture at least 24,000 Michelin tires and 5,000 Achilles tires. How many days should each plant be scheduled to minimize operating costs? Formulate using the Big M Methodarrow_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,