New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
mathematics
statistics
Managerial Decision Modeling With Spreadsheets 3rd Edition Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair - Solutions
The distribution system for the Smith Company consists of three plants (A, B, and C), two warehouses (D and E), and four customers (W, X, Y, and Z). The relevant supply, demand, and unit shipping cost information are given in the table for Problem 5-21 near the top of the next page. Set up and
Greg Pickett, coach of a little-league baseball team, is preparing for a series of four games against four good opponents. Greg would like to increase the probability of winning as many games as possible by carefully scheduling his pitchers against the teams they are each most likely to defeat.
Cindy Jefferson, hospital administrator at Anderson Hospital must appoint head nurses to four newly established departments: urology, cardiology, orthopedics, and pediatrics. Believing in the decision modeling approach to problem solving, Cindy has interviewed four nurses€”Morris,
A trauma center keeps ambulances at locations throughout the east side of a city in an attempt to minimize the response time in the event of an emergency. The times, in minutes, from the ambulance locations to the population centers are given in the table at the top of the next column.Find the
The Central Police Department has five detective squads available for assignment to five open crime cases. The chief of detectives wishes to assign the squads so that the total time to conclude the cases is minimized. The average number of days, based on past performance, for each squad to complete
Kelly Spaugh, course scheduler of a technical college€™s business department, needs to assign instructors to courses next semester. As a criterion for judging who should teach each course, Kelly reviews the student evaluations of teaching for the past two years. Because each of the four
Coogan Construction is in the process of installing power lines to a large housing development. Rob Coogan wants to minimize the total length of wire used, which will minimize his costs. The housing development is shown as a network in Figure 5.19. Each house has been numbered, and the distance
Two Chaps and a Truck Movers have been hired to move the office furniture and equipment of Wray Properties to the company€™s new headquarters. What route do you recommend? The network of roads is shown in Figure 5.21.
A security firm needs to connect alarm systems to the firm€™s main control site from five potential trouble locations. Since the systems must be fail-safe, the cables must be run in special pipes. These pipes are very expensive but large enough to simultaneously handle five cables (the
Figure 5.23 shows a network of nodes. Any sequence of activities that takes a flow of one unit from node 1 to node 6 will produce a widget. For example, one unit flowing from node 1 to node 4 to node 6 would create a widget. Other paths are possible. Quantities given are numbers of widgets per
The road system around the hotel complex (node 1) near a large amusement park (node 11) is shown in Figure 5.24. The numbers by the nodes represent the traffic flow in hundreds of cars per hour. What is the maximum flow of cars from the hotel complex to the park?
The network in Figure 5.25 shows the pipeline transportation system for treated water from the treatment plant (node 1) to a city water supply system (node 14). The arc capacities represent millions of gallons per hour. How much water can be transported per hour from the plant to the city using
In Problem 5-35, two of the terminals in the water supply network (see Figure 5.25), represented by nodes 10 and 11, are to be taken offline for routine maintenance. No material can flow in to or out of these nodes. What impact does this have on the capacity of the network? By how much, if any,
The network shown in Figure 5.26 represents the major roads between Port Huron (node 1) and Dearborn (node 14). The values on the arcs represent the distance, in miles. Find the shortest route between the two cities.
In Problem 5-37, all roads leading into and out of nodes 4 and 9 (see Figure 5.26) have been closed because of bridge repairs. What impact (if any) will this have on the shortest route between Port Huron and Dearborn?€ƒ
Solve the minimal-spanning tree model in the network shown in Figure 5.27. Assume that the numbers in the network represent distance in hundreds of yards.
What is the minimal-spanning tree model? What types of problems can be solved using this type of model?
A secure facility needs to run a hard-wired local area network to connect each of nine sectors. The possible routes the network could utilize, along with the expenses of running the cable between the sectors, in thousands of dollars, are shown in the table at the bottom of this page. Determine the
The Kimten Manufacturing Company needs to process 18 jobs. Kimten can process each job on any of the six machines it has available. Iqbal Ahmed, production supervisor at Kimten, wants to allocate jobs to machines in such a manner that all machines have total loads that are as close as possible to
What is a flow balance constraint? How is it implemented at each node in a network model?
Why might it be more convenient to set up network models in Excel by using a tabular form?
Compare the similarities and differences of LP and GP.
Explain the difference between assigning weights to goals and ranking goals.
What does the term quadratic programming mean?
A cleaning crew currently spends 6 hours per house cleaning eight houses every day, for a profit of $15 per hour. The crew now wants to offer its services to other houses, as well as small professional offices. The crew believes it will take 7 hours to clean the office of a lawyer and that the
An airline is preparing to replace its old planes with three new styles of jets. The airline needs 17 new planes to service its current routes. The decision regarding which planes to purchase should balance cost with capability factors, including the following: (1) The airline can finance up to
The Gaubert Marketing Company needs the following number of telemarketers on the phones during the upcoming week: Monday 23, Tuesday 16, Wednesday 21, Thursday 17, Friday 20, Saturday 12, and Sunday 15. Each employee works five consecutive days followed by 2 days off per week. How many
A hospital is planning an $8 million addition to its existing facility. The architect has been asked to consider the following design parameters: (1) There should be at least 10 and no more than 20 intensive care unit (ICU) rooms; (2) there should be at least 10 and no more than 20 cardiac care
A vending machine is programmed to count out the correct change for each transaction. Formulate and solve an IP model that will determine how change is to be made for a purchase of $4.43, when a $10 bill is inserted into the machine. The model's solution should be based on the availability of coins
Stockbroker Susan Drexler has advised her client as shown in the following table.The client agrees to this list but provides several conditions: (1) No more than $3,000,000 can be invested, (2) the money is to be spread among at least five investments, (3) no more than one type of bond can be
Porter Investments needs to develop an investment portfolio for Mrs. Singh from the following list of possible investments:Mrs. Singh has a total of $60,000 to invest. The following conditions must be met: (1) If investment F is chosen, then investment G must also be part of the portfolio, (2) at
A truck with the capacity to load 2,200 cubic feet of cargo is available to transport items selected from the following table.If selected, an item must be shipped in its entirety (i.e., partial shipments are not allowed). Of items B, C, and D, at least two items must be selected. If item B is
The Greenville Ride have $19 million available to sign free agent pitchers for the next season. The following table provides the relevant information for eight pitchers who are available for signing, such as whether each throws right or left handed, whether each is a starter or reliever, the cost
I-Go Airlines has operations in eight cities throughout the United States. It is searching for the best location(s) to designate as a hub, which would then serve other cities within a 1,400-mile radius. For economic reasons, I-Go would like to operate no more hubs than necessary to cover all eight
Laurens County has six communities that need to be served by fire stations. The number of minutes it takes to travel between the communities is shown in the following table. The county would like to establish the minimum number of fire stations so that each community can get a response in five
Georgia Atlantic Corporation needs to decide on the locations for two new warehouses. The candidate sites are Philadelphia, Tampa, Denver, and Chicago. The following table provides the monthly capacities and the monthly fixed costs for operating warehouses at each potential site.The warehouses will
A manufacturer has acquired four small assembly plants, located in Charlotte, Tulsa, Memphis, and Buffalo. The plan is to remodel and keep two of the plants and close the other two. The table at the top of the next page provides the anticipated monthly capacities and the monthly fixed costs for
A hospital in a large city plans to build two satellite trauma centers to provide improved emergency service to areas, such as highways and high-crime districts, that have historically demonstrated an increased need for critical care services. The city council has identified four potential
The Columbia Furniture Mart manufactures desks, tables, and chairs. In order to manufacture these products, Columbia must rent the appropriate equipment at a weekly cost of $2,000 for desks, $2,500 for tables, and $1,500 for chairs. The labor and material requirements for each product are shown in
Rollins Publishing needs to decide what textbooks from the table at the top of the next column to publish.For each book, the maximum demand, fixed cost of publishing, variable cost, and selling price are provided. Rollins has the capacity to publish a total of 20,000 books. Which books should be
What is the difference between pure and mixed IP models? Which do you think is most common, and why?
Sandy Edge is president of Edge File Works, a firm that manufactures two types of metal file cabinets. The demand for the two-drawer model is 650 cabinets per week; demand for the three- drawer cabinet is 400 per week. Edge has a weekly operating capacity of 1,600 hours, with the two- drawer
Eric Weiss, marketing director for Charter Power and Light, is about to begin an advertising campaign promoting energy conservation. Each TV ad costs $10,000, while each newspaper ad costs $4,000. Weiss has set the following goals, in rank order: Rank 1: The total advertising budget of $240,000
Consider the staffing situation faced by the Gaubert Marketing Company in Problem 6-15. Ignore the salary and part-time information given in part (b) of that problem. Develop a schedule that meets the daily employee requirements and satisfices the following three weighted goals: Goal 1: Use at most
White & Becker Tools (W&B) requires 2,000 electric motors next month for its product line of weed trimmers. Each motor is composed of three components: a coil, a shaft, and housing. W&B has the capability to produce these components or purchase them from an outside vendor. The costs of producing
Pendelton County plans to develop several new recreational facilities that must be completed within the $3.5 million budget. A survey of county residents has resulted in information about the types of facilities that county residents would like to see built, as described in the following table. The
Theo Harris earns $55,000 a year and has $9,000 to invest in a portfolio. His investment alternatives and their expected returns are shown in the table at the top of the next column.Theo€™s investment goals are as follows and can be ranked according to the weights shown in parenthesis.
A hospital kitchen needs to make a fruit salad that contains at least 6,500 units of vitamin A and 1,800 units of vitamin C. Data on five available fruits are shown in the following table.It is estimated that at least 24 pounds, but no more than 32 pounds, of fruit salad will be necessary. The
Consider the following NLP problem:Maximize 10X3 + 15X2 + 25X3Subject to the constraints(a) Set up and solve the model by using Solver. Use a starting value of zero for each decision variable.
Consider the following NLP problem:Maximize 2Xi + X2 - 2X3 + 3XiX2 + 1X subject to the constraints(a) Set up and solve the model by using Solver. Use a starting value of zero for each decision variable.
Hinkel Rotary Engine, Ltd., produces four-, six-, and eight-cylinder models of automobile engines. The firm's profit for each four-cylinder engine sold during its quarterly production cycle is $1,800 - $50X1; where X, is the number of four- cylinder engines sold. Hinkel makes a profit of $2,400 -
A snowmobile manufacturer produces three models, the XJ6, the XJ7, and the XJ8. In any given production-planning week, the company has 40 hours available in its final testing bay. Each XJ6 requires 1 hour of testing, each XJ7 requires 1.5 hours, and each XJ8 takes 1.6 hours. The revenue (in
Susan Jones would like her investment portfolio to be selected from a combination of three stocks— Alpha, Beta, and Gamma. Let variables A, B, and G denote the percentages of the portfolio devoted to Alpha, Beta, and Gamma, respectively. Susan’s objective is to minimize the variance of the
Ashworth Industries would like to make a price and production decision on two of its products. Define QA and QB as the quantities of products A and B to produce and PA and PB as the price for products A and B. The weekly quantities of A and B that are sold are functions of the price, according to
The Kimten Manufacturing Company needs to process 18 jobs. Kimten can process each job on any of the six machines it has available, but each job must be allocated to only one machine. Iqbal Ahmed, production supervisor at Kimten, wants to allocate jobs to machines in such a manner that all machines
Provide your own examples of problems where (a) the objective is nonlinear and (b) one or more constraints are nonlinear.
Explain in your own words why IP problems are more difficult to solve than LP problems.
What are some of the questions that can be answered with project management?
Why is LP useful in project crashing?
A certification program consists of a series of activities that must be accomplished in a certain order. The activities, their immediate predecessors, and estimated durations appear in the following table.(a) Develop a project network for the certification program. (b) Determine the EST, EFT, LST,
A local political campaign must coordinate a number of necessary activities to be prepared for an upcoming election. The following table describes the relationships between these activities that need to be completed, as well as estimated times.(a) Develop a project network for this problem. (b)
The Pickett Marketing Firm is developing a new Web-based media campaign for a client. The following table describes the relationships between the activities that need to be completed.(a) Develop a project network for this problem. (b) Determine the EST, EFT, LST, LFT, and slack for each activity.
The activities required to design a prototype of an experimental machine are listed in the following table, along with their immediate predecessors and estimated durations.(a) Develop a project network for this problem. (b) Determine the EST, EFT, LST, LFT, and slack for each activity. Also
An office complex is to be renovated. Before the job can be completed, various trades people and skilled workers must install their materials. The table at the top of the next page describes the relationships between the activities that need to be completed.(a) Develop a project network for this
An electrical contractor is examining the amount of time his crews take to complete wiring jobs. Some crews seem to take longer than others. For an upcoming job, a list of activities and their optimistic, most likely, and pessimistic completion times are given in the following table.(a) Develop a
A plant engineering group needs to set up an assembly line to produce a new product. The table in the next column describes the relationships between the activities that need to be completed for this product to be manufactured.(a) Develop a project network for this problem.(b) Determine the
A plant is acquiring new production machinery. Before the machinery can be fully functional, a number of activities must be performed, including roughing out for power, placing the machinery, installing the equipment that will feed product to the machinery, etc. The activities, their precedence
A series of activities must be completed in a coordinated fashion to complete a landscaping overhaul. The following table shows the activities; their optimistic, most likely, and pessimistic durations; and their immediate predecessors.(a) Determine the expected times and variances for each
LeBron Woods is responsible for developing a leadership training program for his organization. The following table describes the relationships between the activities that need to be completed.(a) Determine the expected times and variances for each activity. (b) Construct a project network for this
The Coogan Construction Company has determined that the expected completion time for its most popular model home follows the normal probability distribution with a mean of 25 weeks and a standard deviation of 4 weeks.(a) What is the probability that the next home will be completed within 30
The General Foundry air pollution project discussed in this chapter has progressed over the past several weeks, and it is now the end of week 8. Lester Harky would like to know the value of the work completed, the amount of any cost overruns or underruns for the project, and the extent to which the
Fred Ridgeway€™s project (see Problem 7-25) has progressed over the past several months, and it is now the end of month 16. Fred would like to know the current status of the project with regard to schedule and budget by developing an appropriate table. The relevant data are shown in the
Susan Roger needs to coordinate the opening of a new office for her company in the city of Denver. The activity time and relationships for this project, as well as the total budgeted cost for each activity, are shown in the following table.(a) Develop a weekly budget for this project, using the
Susan Roger€™s project (see Problem 7-27) has progressed over the past several weeks, and it is now the end of week 8. Susan would like to know the current status of the project with regard to schedule and budget by developing an appropriate table. Assume that all activities follow their
General Foundry’s project crashing data are shown in Table 7.10 on page 294. Crash this project by hand to 10 weeks. What are the final times for each activity after crashing, and what is the total cost associated with reducing the duration of this project from 15 to 10 weeks?
What is an activity? What is an immediate predecessor?
The table on the next page describes the various activities of a construction project in a chemical plant.(a) Set up and solve an LP model using Excel to crash this project to 22 days. What is the total crashing cost?(b) Assuming each activity can only be crashed in whole days, what is the earliest
A new order filling system needs to be installed as soon as possible. The table on the next page lists the project€™s activities and their predecessors. Also provided is the cost information to reduce the standard activity times.Set up and solve an LP model using Excel to crash this
Bradshaw Construction is involved in constructing municipal buildings and other structures that are used primarily by city and state municipalities. The construction process involves developing legal documents, drafting feasibility studies, obtaining bond ratings, and so forth. Recently, Bradshaw
Sager Products has been in the business of manufacturing and marketing toys for toddlers for the past two decades. Jim Sager, president of the firm, is considering the development of a new manufacturing line to allow it to produce high-quality plastic toys at reasonable prices. The development
What are the EST and LST? How are they computed?
Briefly describe how project budgets can be monitored.
In the environment of increased competition, a fitness club executive is considering the purchase of additional equipment. His alternatives, outcomes, and payoffs (profits) are shown in the following table:(a) If the executive is an optimistic decision maker, which alternative will he likely
Steve’s Mountain Bicycle Shop is considering three options for its facility next year. Steve can expand his current shop, move to a larger facility, or make no change. With a good market, the annual payoff would be $76,000 if he expands, $90,000 if he moves, and $40,000 if he does nothing. With
Steve (see Problem 8-14) has gathered some additional information. The probabilities of good, average, and poor markets are 0.25, 0.45, and 0.3, respectively. (a) Using EMVs, what option should Steve choose? What is the maximum EMV? (b) Using EOL, what option should Steve choose? What is the
Debbie Gibson is considering three investment options for a small inheritance that she has just received€”stocks, bonds, and money market. The return on her investment will depend on the performance of the economy, which can be strong, average, or weak. The returns for each possible
After reading about economic predictions, Debbie Gibson (see Problem 8-16) has assigned the probability that the economy will be strong, average, and weak at 0.2, 0.35, and 0.45, respectively. (a) Using EMYs, what option should Debbie choose? What is the maximum EMV? (b) Using EOL, what option
A hospital administrator in Portland is trying to determine whether to build a large wing onto the existing hospital, a small wing, or no wing at all. If the population of Portland continued to grow, a large wing could return $225,000 to the hospital each year. If the small wing were built, it
Shaq Bryant sells newspapers on Sunday mornings in an area surrounded by three busy churches. Assume that Shaq’s demand can either be for 100, 300, or 500 newspapers, depending on traffic and weather. Shaq has the option to order 100, 300, or 500 newspapers from his supplier. Shaq pays $1.25 for
Describe what is involved in the decision-making process.
Shaq (see Problem 8-19) has done some research and discovered that the probabilities for demands of 100, 300, and 500 newspapers are 0.4, 0.35, and 0.25, respectively. (a) Using EMVs, how many papers should Shaq order? (b) Using EOL, how many papers should Shaq order? (c) Compute Shaq’s EVwPI and
The Boatwright Sauce Company is a small manufacturer of several different sauces to use in food products. One of the products is a blended sauce mix that is sold to retail outlets. Joy Boatwright must decide how many cases of this mix to manufacture each month. The probability that the demand will
After researching the market, Waldo Books (see Problem 8-21) has concluded that the probabilities of selling 50, 100, 150, and 200 books next month are 0.2,0.35, 0.25, and 0.2, respectively. (a) Using EMVs, how many books should Waldo order? (b) Using EOL, how many books should Waldo order? (c)
A souvenir retailer has an opportunity to establish a new location inside a large airport. The annual returns will depend primarily on the size of the space she rents and if the economy will be favorable. The retailer has worked with the airport concession commission, and has projected the
An ambulance driver has three major routes from the hospital base station to the university, to which he makes several trips weekly. The traffic patterns are, however, very complex. Under good conditions, Broad Street is the fastest route. When Broad is congested, one of the other routes, either
A group of medical professionals is considering constructing a private clinic. If patient demand for the clinic is high, the physicians could realize a net profit of $100,000. If the demand is low, they could lose $40,000. Of course, they don’t have to proceed at all, in which case there is no
In Problem 8-26, you helped a group of medical professionals analyze a decision, using EMV as the decision criterion. This group has also assessed its utility for money: U(-$45,000) = 0,U(-$40,000) = 0.1, U(-$5,000) = 0.7, 17($0) = 0.9, U($95,000) = 0.99, and l/($ 100,000) = 1.(a) Are the medical
Jerry Young is thinking about opening a bicycle shop in his hometown. Jerry loves to take his own bike on 50-mile trips with his friends, but he believes that any small business should be started only if there is a good chance of making a profit. Jerry can open a small shop, a large shop, or no
A manufacturer buys valves from two suppliers. The quality of the valves from the suppliers is as follows:For example, the probability of getting a batch of valves that are 1 % defective from supplier A is 0.60. Because the manufacturer orders 10,000 valves per order, this would mean that there is
What is an alternative? What is an outcome?
Showing 52000 - 52100
of 88243
First
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
Last
Step by Step Answers
Get 50% OFF
Claim Now
.png)
-1.png){kind=small}
-2.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
-1.png)
-2.png)
.png)
.png)
.png)
.png)
-1.png)
-2.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
