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
Chapter 3, Problem 35QP
a)
Summary Introduction
To develop: A spreadsheet model and solve using solver.
b)
Summary Introduction
To identify: The optimal solution.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 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. The Logistics Manager has come to you for help.
Answer the following question:
Which of these is not an element of the objective function?
Group of answer choices
4D-T1
600T1
9T2-G
3C-T2
Plz do fast asap
Valles Galactic Industries (VGI) owns a small company (VGI-Durango Sur) that manufactures various electronic products for original equipment manufacturers. Customer companies provide engineering designs, materials lists, and some unique materials. VGI-DS provides labor and space for the manufacturing and assembly operations and stocking a variety of inventory items for production, such as wire, cables, some electronic components, etc. Thus, VGI-DS orders a variety of components and raw materials by contract. The labor pool is primarily composed of about 100 retirees picking up extra cash by working four to six-hour shifts. Thus, the assembly operations must be simple and easy to teach. Skilled employees must do several raw material conversions for packaging—there are currently three such employees.
VGI-DS receives forecasts from VGI headquarters for planned production for two years on a rolling quarterly basis. Staff at VGI-DS develop schedules and inventory plans based on this…
Mark Ewing has decided to enter contract with uber service provider in his area. The driver offers a car variety of mileage or distance to be travelled to him. All contracts were to be signed for three years. The first option has a monthly rent of P3,000, with a total mileage allowance of 36,000 kilometers (an average of 12,000 kilometers per year) and a cost of P35 per kilometer for any kilometers over 36,000. The following table summarizes each of the Uber Service Contract offered to him:
3-Year Contract
Monthly Cost
Mileage Allowance
Cost Per Excess Kilometer
Option A
P3,000
30,000
P 35
Option B
P3,500
45,000
P 25
Option C
P4,000
54,000
P 15
Mark has estimated that, during the 3 years of the agreement, there is a 40% chance he will drive an average of 12,000 kilometers per year, a 30% chance he will drive an average of 15,000 miles per year, and a 30% chance that he will drive 18,000 miles per year. In evaluating the options, Mark would…
Chapter 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Refer to question 19 at the end of Chapter 2....Ch. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Prob. 17QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - Prob. 44QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
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
- Mount Isa Mines is one of the world’s great metal mines. Its main operations are at Mount Isa, in Queensland, Australia, where it mines adjacent deposits of copper and silver-lead-zinc ores. Production levels changes with world demand and prices, but in atypical year 7 million tonnes of ore are mined to give 150,000 tonnes of copper and lead (containing silver) and 200,000 tonnes of zinc. Mount Isa has serious transport problems. It produces huge quantities of ore in a remote area of Australia, while the main demand for finished metals is in the industrialised areas of the world, particularly Europe. The problem is to process the ores and move them to final markets as cheaply as possible. You can see the scope of the problem from an outline of the journey for copper, this starts with underground explosions to break up the ore body. The broken ore is collected by front-end loaders and put onto ore trains that carry it to underground crushers. The crushed ore is then hoisted to the…arrow_forwardMount Isa Mines is one of the world’s great metal mines. Its main operations are at Mount Isa, in Queensland, Australia, where it mines adjacent deposits of copper and silver-lead-zinc ores. Production levels changes with world demand and prices, but in atypical year 7 million tonnes of ore are mined to give 150,000 tonnes of copper and lead (containing silver) and 200,000 tonnes of zinc. Mount Isa has serious transport problems. It produces huge quantities of ore in a remote area of Australia, while the main demand for finished metals is in the industrialised areas of the world, particularly Europe. The problem is to process the ores and move them to final markets as cheaply as possible. You can see the scope of the problem from an outline of the journey for copper, this starts with underground explosions to break up the ore body. The broken ore is collected by front-end loaders and put onto ore trains that carry it to underground crushers. The crushed ore is then hoisted to the…arrow_forwardeBook Problem 10-31 A long-distance telephone company uses a fiber-optic network to transmit phone calls and other information between locations. Calls are carried through cable lines and switching nodes. A portion of the company's transmission network is shown here. The numbers above each arc show the capacity in thousands of messages that can be transmitted over that branch of the network. To keep up with the volume of information transmitted between origin and destination points, use the network to determine the maximum number of messages that may be sent from a city located at node 1 to a oty located at node 7. 3 Maximum number of messages -arrow_forward
- Sealy 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_forwardProblem 16-17 (Algo)The U.S. Airfilter company has hired you as a supply chain consultant. The company makes air filters for residential heating and air-conditioning systems. These filters are made in a single plant located in Louisville, Kentucky, in the United States. They are distributed to retailers through wholesale centers in 100 locations in the United States, Canada, and Europe. You have collected the following data relating to the value of inventory in the U.S. Airfilter supply chain: QUARTER 1(JANUARYTHROUGHMARCH) QUARTER 2(APRIL THROUGHJUNE) QUARTER 3(JULYTHROUGHSEPTEMBER) QUARTER 4(OCTOBERTHROUGHDECEMBER) All amounts in millions of U.S. dollarsSales (total quarter): United states 414 402 520 514Canada 135 96 126 117Europe 41 34 42 25 Cost of goods sold (total quarter) 384 347 453 434 Raw materials at the Louisville plant (end-of-quarter) 73 62…arrow_forwardMorton Corporation manufactures computers and wants to select a supplier to purchase chips for its computers. There are two major suppliers of chips – AirBoxChips and SoftChips. AirBoxChips is a relatively big company and has a good reputation in terms of reliability and delivery. As it is a big company, it provides supply guarantee and sells its products with a higher price. Specifically, it charges $1.20 for each chip that it sells. SoftChips is small company having limited capacity. Even though it charges $0.90 for each chip that it sells, it does not provide supply guarantee. If it is a low-demand year, Softchips is able to satisfy Morton’s demand fully. However, if it is a high-demand year, it allocates only 90,000 chips for the purchase of Morton. If Morton cannot purhcase chips from its contracted supplier, it buys chips on the spot market. Spot market prices for chips are $2.00 per unit in a low-demand year and $4.00 per unit in a high-demand year. Demand in chips has a 75%…arrow_forward
- The MaskMake Company manufactures a variety of masks for the healthcare professionals around Ireland. Company vans are used to deliver local orders directly to retail outlets. When their business was small, the drivers of the vans were free to take routes of their choice as they made the delivery rounds to the retail outlets. However, as the business has grown recently due to the outbreak, transportation and delivery costs have become significant. In an effort to improve the efficiency of the delivery operation, MaskMake management would like to determine the shortest delivery routes between retail outlets. For example, the following network shows the roads (distance in km) that may be taken between a retail outlet at node 1 and a retail outlet at node 11. 3 3 6 10 11 6 4 10 1 7 4 2 4 10 Determine the shortest route for a van that is currently at node 1 and must make a delivery to node 11. 2. 3.arrow_forwardA manufacturer has two shipments to make from Minneapolis to Chicago. Both shipments weigh 8500 pounds. The two shipments can be shipped separately to Chicago at a cost of $2.00 per mile for a total of 409 miles and will take one day for each shipment. The company has a warehouse in Milwaukee where they can consolidate the freight. It would take two LTL shipments at $2.00 per mile to get the freight to Milwaukee for 337 miles and then one full TL shipment from Milwaukee to Chicago at $1.50 per mile for 92 miles. The consolidation cost in Milwaukee is $200 and it takes two days for the trip through Milwaukee. What is the lowest cost to ship the freight and which approach would you select?arrow_forwardSmall Potatoes is a family-operated seed business that has grown rapidly. Small Potatoes specializes in supplying home gardeners with the finest seeds and gardening supplies. Until now, the firm has done all its business by placing ads in gardening and health magazines, and taking orders using a toll-free telephone number. Now, the family has decided to establish a website and sell online, but there is some disagreement about the best way to proceed. Some say it would be better to develop the site on their own, and Betty Lou Jones, a recent computer science graduate, believes she can handle the task. Others, including Sam Jones, Betty’s grandfather, feel it would be better to outsource the site and focus on the business itself. Suppose the family asked for your opinion. What approach would you take? What additional questions would you ask? Does this appear to identify diversity, equity and inclusion?arrow_forward
- Small Potatoes is a family-operated seed business that has grown rapidly. Small Potatoes specializes in supplying home gardeners with the finest seeds and gardening supplies. Until now, the firm has done all its business by placing ads in gardening and health magazines, and taking orders using a toll-free telephone number. Now, the family has decided to establish a website and sell online, but there is some disagreement about the best way to proceed. Some say it would be better to develop the site on their own, and Betty Lou Jones, a recent computer science graduate, believes she can handle the task. Others, including Sam Jones, Betty’s grandfather, feel it would be better to outsource the site and focus on the business itself. Suppose the family asked for your opinion. What would you say? What additional questions would you ask?arrow_forwardZara 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_forwardA company is considering four modes of transportationfor its shipments. It plans to ship 32 pallets weighing500 pounds each from Salt Lake City, Utah to Reno,Nevada at a distance of 518 miles. What is the best way tomake these shipments given the following information?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,
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning