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
Question
Chapter 3, Problem 1QP
Summary Introduction
To explain: The reason why some other value or formula are not placed in the cells and what would be the difference if it is done so.
Expert Solution & Answer
Explanation of Solution
Generally, it is immaterial of what is placed in the changing variable cells. The use of solver will ultimately determine the optimal value for the concerned cells automatically. It is the general principle used in linear optimization problems.
But in nonlinear optimization problems, there is an exception where the values placed in the changing variable cells represent the initial starting points for the optimizer. Apart from this, there is no difference between placing a value or some other formula in the changing variable cells.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Subject: FUNDAMENTALS OF BUSINESS ANALYTICS
Problem: The Supermarket contains over 14,000 transactions made by supermarket customers over a period of approximately two years. (The data are not real, but real supermarket chains have huge data sets just like this one.) A small sample of the data appears in in the Figure below, Column B contains the date of the purchase, column C is a unique identifier for each customer, columns D–H contain information about the customer, columns I–K contain the location of the store, columns L–N contain information about the product purchased (these columns have been hidden to conserve space), and the last two columns indicate the number of items purchased and the amount paid.
Question: Based on the given problem and picture provided, determine which variables are categorical and numerical?
(a) Determine the amount of potatoes and green beans Maria should purchase each week for the casserole to
minimize the ingredient costs while meeting nutritional, taste, and demand requirements. Before she makes
her final decision, Maria plans to explore the following questions independently except where otherwise
indicated.
(b) Maria is not very concerned about the taste of the casserole; she is only concerned about meeting
nutritional requirements and cutting costs. She therefore forces Edson to change the recipe to allow for only at
least a one to two ratio in the weight of potatoes to green beans. Given the new recipe, determine the amount
of potatoes and green beans Maria should purchase each week.
(c) Maria decides to lower the iron requirement to 65 mg since she determines that the other ingredients, such
as the onions and cream of mushroom soup, also provide iron. Determine the amount of potatoes and green
beans Maria should purchase each week given this new iron…
Snyder’s of Hanover, which sells about 80 million bags of pretzels, snack chips, and organic snack items each year, had its financial department use spreadsheets and manual processes for much of its data gathering and reporting. Hanover’s financial analyst would spend the entire final week of every month collecting spreadsheets from the heads of more than 50 departments worldwide. She would then consolidate and reenter all the data into another spreadsheet, which would serve as the company’s monthly profit-and-loss statement. If a department needed to update its data after submitting the spreadsheet to the main office, the analyst had to return the original spreadsheet and wait for the department to resubmit its data before finally submitting the updated data in the consolidated document. Assess the impact of this situation/problem on business performance and management decision-making. What are the choices of solutions? Which one is the net fit for this problem?
Chapter 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
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
- Problem 3: Let L(x, y) be the statement “x loves y”, where the domain for both x and y consists of all people in the world. Use quantifiers to express each of the following statements.1. Everybody loves Jerry.2. Everybody loves somebody.3. There is somebody whom everybody loves.4. Nobody loves everybody.5. There is somebody whom Lydia does not love.6. There is somebody whom no one loves.7. There is exactly one person whom everybody loves.8. There are exactly two people whom Lynn loves.9. Everybody loves himself or herself.10. There is someone who loves no one besides himself or herself.arrow_forwardConsider Bruno who manages an underwriting team in an insurance firm. Recently, the management of Bruno’s firm informed him of their decision to create a new risk assessment team, consisting of data scientists with machine learning expertise, and reduce the size of Bruno’s underwriting team. Bruno’s underwriting team will now work with the new risk assessment team in order to determine whether to provide insurance to applicants Use the model of a firm’s technology choice and graphically illustrate the management’s restructuring decision in a diagram with isocost curves. Your diagram should have the amount of human intelligence on the horizontal axis and the amount of artificial intelligence on the vertical axis. Fully label your diagram. Note that there are no actual numbers given in this question: you may make them up or simply use appropriate notations. Briefly explain the key information of your diagram.arrow_forwardUse the Huntington-Hill numbers listed in the table to assign seats as indicated. (REVIEW UNIT 5 - CHAPTER 4) Eleven seats on a hospital board are to be apportioned between doctors, nurses, and administrators. Use the given table of Huntington-Hill numbers to list the order in which the seats on the board will be apportioned. Begin by apportioning one seat to each group. Current Representation 1 (D)octors (N)urses (A)dministrators 7,200 2,812 11,250 3,750 1,875 1,125 750 937 2,400 468 281 1,200 720 3 4 5. 187 480 O D. N, A, A, N, A, D, N, A, N, A O D. N. A, A. N, D. A, N, D. A, N O D, N, A, N, A, A, D, N, A, A, N O D, N, A, A, D, A, N, N, A, N, Darrow_forward
- 1. Construct a 2-by2 contingency table to determine the total number of people who fail the screening test and will be referred for diagnostic testing in the hearing centers. 2. Construct a 2-by-2 contingency table to determine the total number of people who fail the diagnostic test, which represents the target market for hearing aid sales.arrow_forwardHow can we execute the Solver and interpret results from the reports provided by the programarrow_forwardScenario You are going to plant a rectangular flower bed consisting of tulips in the middle surrounded by daisies on the outside. You have the same amount of each flower and will need an equal area for each. You want the border of daisies to be uniform around the tulips in the middle, as shown in the diagram below:arrow_forward
- 3. (Note: This is a variation of problem 6 of chapter 16 in your textbook.) Kenya and Dionne live on adjacent plots of land. Each has two potential uses for their land, the present values of each of which depend on the use adopted by the other, as summarized in the table. All the values in the table are known to both parties. Dionne Rental housing Bee keeping Kenya Apple growing A: $200 B: $700 A: $400 B: $650 Pig farming A: $450 B: $400 A: $450 B: $500 a. What is the efficient outcome? b. If there are negotiation costs of $150, what activities will the two pursue on their land? c. If there are no negotiation costs and the two negotiate, what activities will the two pursue on their land? How might a benevolent planner help reduce the costs of negotiating to encourage the optimal combination of land uses?arrow_forwardCan you please help in solving the linear equation graphically with clear stepsarrow_forwardPlease do not give solution in image format thanku Susana manages inventory at fashion apparel retailer Orange Republic. In January, Suasana is determining order quantity for swimsuit for coming summer season. Each swimsuit is purchased at $50 and sold at retail price of $105. All the swimsuits that remain unsold at the end of summer, are sold to discount retailer TJ-Minn for $22 at the beginning of fall. The demand for swimsuits during summer is Normally distributed with mean of 200 and standard deviation of 50. If Susana order 250 swimsuits, what is the expected profit from Swimsuits?arrow_forward
- The manager wants to forecast the month 6's sales using the following historical data: Months Month 1 Month 2 Month 3 Month 4 Month 5 Sales 20 25 32 35 38 Please use the weight 0.45 for Month 5, weight 0.25 for Month 4, weight 0.2 for Month 3, and weight 0.1 for Month 2 to use the weighted moving average to forecast the demand of Month 6. Month 5 = 0.1*(25) +0.2*(32) + .25* (35) divided by 0.1 +0.2 +1.25 -17.65/0.55 = 32.09 Month 6= 0.1* (25) +0.2* (32) +0.25 (35) +0.45* (38) divided by 0.1 +0.2+0.45 = 34.75arrow_forwardHarvesting Fruit Toward the middle of the harvesting sea-son, peaches for canning come in three types, early, late, and extra late, depending on the expected date of ripening. During a certain week, the following data were recorded at a fruit delivery station:34 trucks went out carrying early peaches;61 carried late peaches;50 carried extra late;25 carried early and late;30 carried late and extra late;8 carried early and extra late;6 carried all three;9 carried only fgs (no peaches at all).(a) How many trucks carried only late variety peaches?(b) How many carried only extra late?(c) How many carried only one type of peach?(d) How many trucks (in all) went out during the week?arrow_forward(b) A company produces 3 products A, B and C processed on 3 machines P, Q, R before completion. Machine P can process 25 units of A or 50 unit of B or 75 units of C per hour. Machine Q can process 50 units of any of the products per hour. Machine R can process 50 units of A or 25 unit of B or 100 units of C per hour. The processing hours available on machines P, Q and R are 12, 12 and 13 respectively. Use matrix method, find (i) How many units of each of the three products can be produced per day (ii) The production cost per unit, if cost per hour of operating machines A,B and C are N$500, N$1,000 and N$1,500 respectively. (iii) The total cost of production.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,