Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 6.4, Problem 21P
Summary Introduction
To determine: Whether solver can be able to handle the model.
Introduction: The variation between the present value of the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Hi... I'm having trouble with the following:
Min Jee wants to combine the sales data from each of the art fairs. Switch to the Combined Sales worksheet, and then update the worksheet as follows:
In cell A5, enter a formula without using a function that references cell A5 in the Madison
Copy the formula from cell A5 to the range A6:A8 without copying the formatting.
In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the Chicago:Madison
Copy the formula from cell B5 to the range B6:B8 without copying the formatting.
Copy the formulas and the formatting from the range B5:B8 to the range C5:E8. (Hint: You can ignore the error about empty cells because Min Jee will enter the Madison sales data later.)
Please do not give solution in image format thanku
Let xi = 1 if Project i is selected, i = 1,2,3,4,5; and 0 otherwise:
Which answer below indicates that if Project 2 is selected, then Project 4 must be selected?
Group of answer choices
None of the above
x2 + x4 = 1
x2 + x4 ≤ 1
x4 ≤ x2
x2 ≤ x4
You are required to create the following tables in a database named STUDENT_REGISTRATIONS.
Ensure that you create the database and table objects exactly as depicted below.
STUDENTS
STUDENT_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
STUDENT_NAME
VARCHAR(40) NOT NULL
STUDENT_SURNAME VARCHAR(40) NOT NULL
MODULES
MODULE_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
MODULE_NAME
VARCHAR(40) NOT NULL
MODULE_CREDIT SMALLINT NOT NULL
STUDENT_MODULES
STUDENT_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
FOREIGN KEY REFERENCES
STUDENTS(STUDENT_ID)
MODULE ID
VARCHAR(8) NOT NULL
PRIMARY KEY
FOREIGN KEY REFERENCES
MODULES(MODULE_ID)
LECTURERS
LECTURER_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
LECTURER_NAME
VARCHAR(40) NOT NULL
LECTURER_SURNAME VARCHAR(40) NOT NULL
O The Independent Institute of Education (Pty) Ltd 2021
Page 3 of 10
19, 20; 21
2021
LECTURER_MODULES
MODULE_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
FOREIGN KEY REFERENCES
MODULES(MODULE_ID)
LECTURER_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
FOREIGN KEY REFERENCES
LECTURERS(LECTURER_ID)
Chapter 6 Solutions
Practical Management Science
Ch. 6.3 - Prob. 1PCh. 6.3 - Prob. 2PCh. 6.3 - Solve Problem 1 with the extra assumption that the...Ch. 6.3 - Prob. 4PCh. 6.3 - Prob. 5PCh. 6.3 - Prob. 6PCh. 6.3 - Prob. 7PCh. 6.3 - Prob. 8PCh. 6.3 - Prob. 9PCh. 6.3 - Prob. 10P
Ch. 6.4 - Prob. 11PCh. 6.4 - Prob. 12PCh. 6.4 - Prob. 13PCh. 6.4 - Prob. 14PCh. 6.4 - Prob. 15PCh. 6.4 - Prob. 16PCh. 6.4 - Prob. 17PCh. 6.4 - Prob. 18PCh. 6.4 - Prob. 19PCh. 6.4 - Prob. 20PCh. 6.4 - Prob. 21PCh. 6.4 - Prob. 22PCh. 6.4 - Prob. 23PCh. 6.5 - Prob. 24PCh. 6.5 - Prob. 25PCh. 6.5 - Prob. 26PCh. 6.5 - Prob. 28PCh. 6.5 - Prob. 29PCh. 6.5 - Prob. 30PCh. 6.5 - In the optimal solution to the Green Grass...Ch. 6.5 - Prob. 32PCh. 6.5 - Prob. 33PCh. 6.5 - Prob. 34PCh. 6.5 - Prob. 35PCh. 6.6 - Prob. 36PCh. 6.6 - Prob. 37PCh. 6.6 - Prob. 38PCh. 6 - Prob. 39PCh. 6 - Prob. 40PCh. 6 - Prob. 41PCh. 6 - Prob. 42PCh. 6 - Prob. 43PCh. 6 - Prob. 44PCh. 6 - Prob. 45PCh. 6 - Prob. 46PCh. 6 - Prob. 47PCh. 6 - Prob. 48PCh. 6 - Prob. 49PCh. 6 - Prob. 50PCh. 6 - Prob. 51PCh. 6 - Prob. 52PCh. 6 - Prob. 53PCh. 6 - Prob. 54PCh. 6 - Prob. 55PCh. 6 - Prob. 56PCh. 6 - Prob. 57PCh. 6 - Prob. 58PCh. 6 - Prob. 59PCh. 6 - Prob. 60PCh. 6 - Prob. 61PCh. 6 - Prob. 62PCh. 6 - Prob. 63PCh. 6 - Prob. 64PCh. 6 - Prob. 65PCh. 6 - Prob. 66PCh. 6 - Prob. 67PCh. 6 - Prob. 68PCh. 6 - Prob. 69PCh. 6 - Prob. 70PCh. 6 - Prob. 71PCh. 6 - Prob. 72PCh. 6 - Prob. 73PCh. 6 - Prob. 74PCh. 6 - Prob. 75PCh. 6 - Prob. 76PCh. 6 - Prob. 77PCh. 6 - Prob. 78PCh. 6 - Prob. 79PCh. 6 - Prob. 80PCh. 6 - Prob. 81PCh. 6 - Prob. 82PCh. 6 - Prob. 83PCh. 6 - Prob. 84PCh. 6 - Prob. 85PCh. 6 - Prob. 86PCh. 6 - Prob. 87PCh. 6 - Prob. 88PCh. 6 - Prob. 89PCh. 6 - Prob. 90PCh. 6 - Prob. 91PCh. 6 - Prob. 92PCh. 6 - This problem is based on Motorolas online method...Ch. 6 - Prob. 94PCh. 6 - Prob. 95PCh. 6 - Prob. 96PCh. 6 - Prob. 97PCh. 6 - Prob. 98PCh. 6 - Prob. 99PCh. 6 - Prob. 100PCh. 6 - Prob. 1CCh. 6 - Prob. 2CCh. 6 - Prob. 3.1CCh. 6 - Prob. 3.2CCh. 6 - Prob. 3.3CCh. 6 - Prob. 3.4CCh. 6 - Prob. 3.5CCh. 6 - Prob. 3.6C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- I mentioned that I need the answer in solver. also the answer provided is not readable at all. this is waste of time and money Please provide solution in excel solverarrow_forwardIn the spreadsheet model shown below, an analyst makes the following data entries. Cell B3 B4 B5 B6 Value 110,000 83,000 82,000 92,000 A 1 Revenue 2 Month Change (%) n/a Revenue 3 January 4 February 5 March =(B4-B3)/B3 =(B5-B4)/B4 6 April =(B6-B5)/B5 What values will be shown in the following cells? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Cell Value C4 C5 % C6 %arrow_forwardPLEASE USE SIMPLEX METHOD. Thank you! Suppose a company manufactures different electronic components for computers. Component A requires 2 hours of fabrication and an hour of assembly. Component B requires 3 hours of fabrication and an hour of assembly, and component C requires 2 hours of fabrication and 2 hours of assembly. The company has upto 1,000 labor-hours for fabrication, 800 labor-hours of assembly time each work. If the profit on each component A, B, and C is $7, $8, and $10 respectively, how many of each should be produced to maximize profit?arrow_forward
- Can you show how to put it in Excel? XYZ store sells regular and premium nut mixes. Premium mix contains three quarters pound of cashews and one quarter of peanuts, and the regular mix has half pound of cashews and half pound peanuts per bag. The shop has 200 pounds of cashews and 300 pounds of peanuts to work with. Cashews cost $1.50 per pound, and peanuts cost 60 cents per pound. Premium mix will sell for $2.90 per pound, and the standard mix will sell for $2.55 per pound. The owner esimtes that no more than 200 bags of one types can be sold. What is the best combinations of products that maximizes profits? Make sure to create a feasible solution with countable number of products (no partials)arrow_forwardWhat are some common properties of LP models? What is the three-step process for solving LP models? How are constraints modeled graphically? What is the corner point property? How is it useful in solving LP models?arrow_forwardBelow you will find the LP code for the Dakota furniture company making tables, desks, and chairs but Missing the rule that if more than 10 tables are made, then at least 5 desks must be made. (there are spots for this in the constraints) Find the optimal profit: [a] var x1 integer >= 0; /*tables */ var x2 integer >= 0; /* desks */ var x3 integer >= 0; /* chairs */ var y binary; maximize z: 60*x1+30*x2+20*x3; c1: 8*x1+6*x2+x3 10 */ /* then x2 >= 5 */arrow_forward
- I need help with d, e, and f. I already did a, b, and c. You do not need to use Solver or solve the problems. Just respond to the problem questions using the outputs provided in the problem. A picture in the attach image is a complete question. 1. Recall the Innis Investments problem (Chapter 2, Problem 39). Letting S= units purchased in the stock fund M= units purchased in the money market fund leads to the following formulation: Min 8S + 3M s.t. 50S + 100M≤ 1,200,000 funds available 5S + 4M≥ 60,000 Annual income M≥ 3,000 Units in money market S, M≥ 0 a. What is the optimal solution, and what is the minimum total risk? Already did this part b. Specify the objective coefficient ranges. Already did this part c. How much annual income will be earned by the portfolio? I also did this part too d. What is the rate of return for the portfolio? e. What is the dual value for the funds available constraint? f. What is the marginal rate of…arrow_forward(Need both parts a and b) During the next four months, a customer requires, respectively, 500, 650, 1000, and 700 units of a commodity, and no backlogging is allowed (that is, the customer’s requirements must be met on time). Production costs are $50, $80, $40, and $70 per unit during these months. The storage cost from one month to the next is $20 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of month 4 can be sold for $60. Assume there is no beginning inventory. A. What is the objective function in this problem? B. What are the constraints in this problem? Write algebraic expressions for eacharrow_forwardNice-Fit is a (fictional) small business producing outfits for costume parties and specialoccasions. Custom designs can be tailored to a customer’s request. Tom and Ann are theowners of the company and source all the fabric, design the outfits and make the costumesthemselves. Tom and Ann keep spreadsheets with information on the material purchased andcostumes made, but they find it difficult to keep track of their products, raw materials, andsales. The raw materials are supplied from a fabric company in India, and the production takesplace in a manufacturing company in China. The clothing is sold at local weekend markets,sold, or rented through costume hire shops, and sold at their physical store. Tom and Annreceive a small percentage of the sales and rentals of their costumes from the hire shops.They have no information on customers other than those who request custom designsdirectly from them. In 2020, the Covid-19 pandemic had a major impact on global economies,businesses and how we…arrow_forward
- please sole this using solver with clear steps. please attach your excel filearrow_forwardn using Excel to solve linear programming problems, the objective cell represents the a. value of the objective function. b. constraints. c. decision variables. d. total cost of the model.arrow_forwardGiven below is an LP for a furniture manufacturing company. Maximize Z = 5 x, + 6 x, (profit, RM) 2 x, + x, 0 Based on the sensitivity analysis results obtained using Excel Solver for the above LP model, answer questions (a) to (c). Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$10 X1 = 30 7 1 $B$11 X2 = 60 1.5 3.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SE$6 Constraint 1 Usage SE$7 Constraint 2 Usage 120 0.75 120 120 40 240 1.75 240 120 120 a) At the optimal solution, how much labour hours was utilized? b) Suppose that the available wood is increased by 50%, what will happen to the optimal solution? c) Suppose that the manager receives an offer from a supplier to get 5 meter of wood at the cost of RM2.50 per meter, should he/she take the offer? Justify your answer.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,