Managerial Decision Modeling With Spreadsheets 3rd Edition Barry Render - Solutions

5 A furniture maker sells three different styles of cabinets, including an Italian model, a French Country model, and a Caribbean model. Each cabinet produced must go through three departments: carpentry, painting, and finishing.The table at the top of this page contains all relevant information
6 An electronics manufacturer has an option to produce six styles of cell phones. Each of these devices requires time, in minutes, on three types of electronic testing equipment, as shown in the table at the bottom of this page. The first two test devices are each available for 120 hours per week.
7 A company produces three different types of wrenches:W111, W222, and W333. It has a firm order for 2,000 W111 wrenches, 3,750 W222 wrenches, and 1,700 W333 wrenches. Between now and the order delivery date, the company has only 16,500 fabrication hours and 1,600 inspection hours. The time that
8 A gear manufacturer is planning next week’s production run for four types of gears. If necessary, it is possible to outsource any type of gear from another gear company located nearby. The following table and the table at the bottom of this page show next week’s demand, revenue per unit,
11 A grocery chain wants to promote the sale of a new flavor of ice cream by issuing up to 15,000 coupons by mail to preferred customers. The budget for this promotion has been limited to $12,000.The following table shows the expected increased sales per coupon and the probability of coupon usage
12 A political candidate is planning his media budget for an upcoming election. He has $90,500 to spend.His political consultants have provided him with the following estimates of additional votes as a result of the advertising effort:• For every small sign placed by the roadside, he will garner
13 A brokerage firm has been tasked with investing$500,000 for a new client. The client has asked that the broker select promising stocks and bonds for investment, subject to the following guidelines:• At least 20% in municipal bonds• At least 10% each in real estate stock and pharmaceutical
14 An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commercial lender. The types of investments, the expected interest per year, and the maximum allowed percentage investment he will consider are shown on the following table. He wants at least 35%
15 A finance major has inherited $200,000 and wants to invest it in a diversified portfolio. Some of the investments she is considering are somewhat risky.These include international mutual funds, which should earn 12.25% over the next year, and U.S.stocks, which should earn 11.5% over the next
17 A hospital emergency room is open 24 hours a day.Nurses report for duty at 1 a.m., 5 a.m., 9 a.m., 1 p.m., 5 p.m. , or 9 p.m. , and each works an 8-hour shift. Nurses are paid the same, regardless of the shift they work. The following table shows the minimum number of nurses needed during the
18 A nursing home employs attendants who are needed around the clock. Each attendant is paid the same, regardless of when his or her shift begins. Each shift is 8 consecutive hours. Shifts begin at 6 a.m., 10 a.m., 2 p.m., 6 p.m., 10 p.m., and 2 a.m. The following table shows the nursing home’s
19 A hospital is moving from 8-hour shifts for its lab techs to 12-hour shifts. Instead of working five 8-hour days, the lab techs would work three days on and four days off in the first week followed by four days on and three days off in the second week, for a total of 84 hours every two
20 An airline with operations in San Diego, California, must staff its ticket counters inside the airport.Ticket attendants work 6-hour shifts at the counter.There are two types of agents: those who speak English as a first language and those who are fully bilingual (English and Spanish). The
21 A small trucking company is determining the composition of its next trucking job. The load master has his choice of seven different types of cargo, which may be loaded in full or in part. The specifications of the cargo types are shown in the following table.The goal is to maximize the amount of
22 The load master for a freighter wants to determine the mix of cargo to be carried on the next trip.The ship’s volume limit for cargo is 100,000 cubic meters, and its weight capacity is 2,310 tons.The master has five different types of cargo from which to select and wishes to maximize the value
23 A cargo transport plane is to be loaded to maximize the revenue from the load carried. The plane may carry any combination and any amount of cargoes A, B, and C. The relevant values for these cargoes are shown in the table at the top of the next page .CARGO TYPE TONS AVAILABLE REVENUE PER TON
25 A farmer is making plans for next year’s crop. He is considering planting corn, tomatoes, potatoes and okra. The data he has collected, along with the availability of resources, are shown in the table at the bottom of this page. He can plant as many as 60 acres of land. Determine the best mix
27 A family farming concern owns five parcels of farmland broken into a southeast sector, north sector, northwest sector, west sector, and southwest sector. The farm concern is involved primarily in growing wheat, alfalfa, and barley crops and is currently preparing the production plan for next
28 A farmer has subdivided his land into three plots and wants to plant three crops in each plot: corn, rice, and soy. Plot sizes, crop acreage, profit per acre, and manure needed (pounds per acre) are given in the table at the bottom of this page.The maximum acreage for each crop denotes the total
30 A chemical company wishes to mix three elements (E, F, and G) to create three alloys (X, Y, and Z). The costs of the elements are as shown in the following table.ELEMENT COST PER TON E $3.00 F $4.00 G $3.50 To maintain the required quality for each alloy, it is necessary to specify certain
31 An animal feed company is developing a new puppy food. Their nutritionists have specified that the mixture must contain the following components by weight: at least 16% protein, 13% fat, and no more than 15% fiber. The percentages of each nutrient in the available ingredients, along with their
32 A boarding stable feeds and houses work horses used to pull tourist-filled carriages through the streets of a historic city. The stable owner wishes to strike a balance between a healthy nutritional standard for the horses and the daily cost of feed.This type of horse must consume exactly 5
33 Clint Hanks has decided to try a new diet that promises enhanced muscle tone if the daily intake of five essential nutrients is tightly controlled. After extensive research, Clint has determined that the recommended daily requirements of these nutrients for a person of his age, height, weight,
34 A steel company is producing steel for a new contract.The contract specifies the information in the following table for the steel.MATERIAL MINIMUM MAXIMUM Manganese 2.10% 3.10%Silicon 4.30% 6.30%Carbon 1.05% 2.05%The steel company mixes batches of eight different available materials to produce
35 A meat packing house is creating a new variety of hot dog for the low-calorie, low-fat, low-cholesterol market. This new hot dog will be made of beef and pork, plus either chicken, turkey, or both. It will be marketed as a 2-ounce all-meat hot dog, with no fillers.Also, it will have no more than
37 A paint company has two types of bases from which it blends two types of paints: Tuffcoat and Satinwear.Each base has a certain proportion of ingreditheir ents X, Y, and Z, as shown in table 37, along with costs.INGREDIENT X INGREDIENT Y INGREDIENT Z COST/GALLON Paint base A 25% 34% 10% $4.50
38 The military has requested a new ready-to-eat meal(MRE) that will provide to troops in the field a very high-protein, low-carbohydrate instant canned breakfast. The can will contain 11 fluid ounces, or 325 mL, of the product. The design specifications are as follows: The drink should have at
40 A power company has just announced the August 1 opening of its second nuclear power-generation facility. The human resources department has been directed to determine how many nuclear technicians will need to be hired and trained over the remainder of the year. The plant currently employs 350
41 A manufacturer of integrated circuits is planning production for the next four months. The forecast demand for the circuits is shown in the following table.CIRCUIT SEP OCT NOV DEC IC341 650 875 790 1,100 IC256 900 350 1,200 1,300 At the beginning of September, the warehouse is expected to be
42 A woman inherited $356,000. As she had no immediate need for the money at the time she inherited, she decided to invest some or all of it on January 1, 201 n , with a goal of making the money grow to$500,000 by December 31, 201n + 5. She is considering the investments in the following table.RATE
44 A paper mill sells rolls of paper to newspapers, which usually place orders for rolls of different widths. The mill has just received a large order for 1.5 million feet of 4-foot-wide paper, 6 million feet of 9-foot-wide paper, and 3 million feet of 12-footwide paper. It produces rolls of two
45 A company that manufactures products in two plants ships locally using its own transportation system, but it has orders that must be sent to customers too far away to be serviced by the local fleet. It therefore contracts with a middle-distance carrier to complete its shipping. The locations of
46 A school district must determine which students from each of the four attendance zones will attend which of the three high schools. The north attendance zone is 8 miles from Central High School, 4 miles from Northwestern High School, and 16 miles from Southeastern High School. All of the
47 The school district in Problem 46 wishes to impose an additional constraint on the problem: It wants to enroll the same number of students in each of the three schools. Solve for the revised allocation of students to schools that will minimize the number of miles necessary to transport the
1. Structure special LP network flow models.
2. Set up and solve transportation models, using Excel’s Solver.
3. Set up and solve transportation models with Max-Min and Min-Max objectives.
4. Extend the basic transportation model to include transshipment points.
5. Set up and solve maximal-flow network models, using Excel’s Solver.
6. Set up and solve shortest-path network models, using Excel’s Solver.
7. Connect all points of a network while minimizing total distance, using the minimal-spanning tree model.
3 What is the enumeration approach to solving assignment models? Is it a practical way to solve a 5 row * 5 column model? a 7 * 7 model? Why?
5 Give several examples of problems that can be solved using the maximal-flow model.
6 Describe a problem that can be solved by using the shortest-path model.
8 How can we manipulate a maximal-flow network model in order to set it up as a linear program?
12 The Oconee County, South Carolina, superintendent of education is responsible for assigning students to the three high schools in his county. A certain number of students have to travel to and from school by bus, as several sectors of the county are beyond walking distance from a school. The
13 Marc Hernandez’s construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits available to provide for Hernandez’s needs, but shipping costs differ from location to location. The following table summarizes the
15 The Piedmont Investment Corporation has identified four small apartment buildings in which it would like to invest. The four banks generally used by Piedmont have provided quotes on the interest rates they would charge to finance each purchase. The banks have also advised Piedmont of the maximum
16 The manager of the O’Brian Glass Company is planning the production of automobile windshields for the next four months. The demand for the next four months is projected to be as shown in the following table.MONTH DEMAND FOR WINDSHIELDS 1 130 2 140 3 260 4 120 O’Brian can normally produce 100
17 Maurice’s Pump Manufacturing Company currently maintains plants in Atlanta and Tulsa that supply major distribution centers in Los Angeles and New York. Because of an expanding demand, Maurice has decided to open a third plant and has narrowed the choice to one of two cities—New Orleans or
22 A supply chain consists of three plants (A, B, and C), three distributors (J, K, and L), and three stores(X, Y, and Z). The relevant supply, demand, and unit shipping cost information are given in the table at the bottom of this page. Set up and solve the transshipment model to minimize total
23 In a job shop operation, four jobs can be performed on any of four machines. The hours required for each job on each machine are presented in the following table:MACHINE JOB W X Y Z A 16 14 10 13 B 15 13 12 12 C 12 12 9 11 D 18 16 14 16 The plant supervisor would like to assign jobs so that
24 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.
25 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, Richards,
26 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.POPULATION
27 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
30 The city of Six Mile, South Carolina, is considering making several of its streets one way. What is the maximum number of cars per hour that can travel from east (node 1) to west (node 8)? The network is shown in Figure 20 .
32 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 maximum
38 In Problem 37, all roads leading into and out of nodes 4 and 9 (see Figure 26 ) have been closed because of bridge repairs. What impact (if any) will this have on the shortest route between Port Huron and Dearborn?
39 Solve the minimal-spanning tree model in the network shown in Figure 27 . Assume that the numbers in the network represent distance in hundreds of yards.
41 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
1. Formulate integer programming (IP) models.
2. Set up and solve IP models using Excel’s Solver.
3. Understand the difference between general integer and binary integer variables.
4. Understand the use of binary integer variables in formulating problems involving fixed costs.
5. Formulate goal programming (GP) problems and solve them using Excel’s Solver.
6. Formulate nonlinear programming (NLP) problems and solve them using Excel’s Solver.
1 Compare the similarities and differences of LP and GP.
2 Provide your own examples of five applications of IP.
6 If you were the president of the college you are attending and were employing GP to assist in decision making, what might your goals be? What kinds of constraints would you include in your model?
10 Explain the difference between assigning weights to goals and ranking goals.
11 What does the term quadratic programming mean?
12 Which of the following are NLP models, and why?Are any of these quadratic programming models?(a) Maximize profit = 3X1 + 5X2 + 99X3 subject to the contraints X1 Ú 10 X2 … 5 X3 Ú 18(b) Maximize profit = 25X1 + 30X2 + 8X1X2 subject to the contraints X1 Ú 8 X1 + X2 Ú 12 X1 - X2 = 11(c)
16 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
17 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
18 Stockbroker Susan Drexler has advised her client as shown in the following table.INVESTMENT COST(thousands)EXPECTED RETURN(thousands)Andover municipal bonds$ 400 $ 35 Hamilton city bonds $1,000 $100 East Power & Light Co. $ 350 $ 30 Nebraska Electric Service$ 700 $ 65 Southern Gas and Electric$
19 Porter Investments needs to develop an investment portfolio for Mrs. Singh from the following list of possible investments:INVESTMENT COST EXPECTED RETURN A $ 10,000 $ 700 B $ 12,000 $ 1,000 C $ 3,500 $ 390 D $ 5,000 $ 500 E $ 8,500 $ 750 F $ 8,000 $ 640 G $ 4,000 $ 300 Mrs. Singh has a total of
20 A truck with the capacity to load 2,200 cubic feet of cargo is available to transport items selected from the following table.ITEM VALUE VOLUME (cu. ft.)A $1,800 700 B $1,400 600 C $1,100 450 D $ 900 400 E $1,600 650 F $1,100 350 G $1,200 600 If selected, an item must be shipped in its
21 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
22 Allied Products has six R&D projects that are potential candidates for selection during the upcoming fiscal year. The table at the bottom of the page provides the expected net present value (NPV) and capital requirements over the next five years for each project.The table also indicates the
24 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
25 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.WAREHOUSE
27 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
28 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
29 Rollins Publishing needs to decide what textbooks from the table at the top of the next column to publish.Table for Problem 29 DEMAND FIXED COST VARIABLE COST SELLING PRICE Book 1 9,000 $12,000 $19 $40 Book 2 8,000 $21,000 $28 $60 Book 3 5,000 $15,000 $30 $52 Book 4 6,000 $10,000 $20 $34 Book 5
33 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
34 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.
35 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.INVESTMENT DESCRIPTION EXPECTED RETURN A IRA (retirement) 3.5%B Employer’s retirement plan 4.5%C Deferred income
36 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.FRUIT TYPE VITAMIN A(units/lb.)VITAMIN C(units/lb.)COST PER LB.MAXIMUM AVAILABLE(lb.)Apple 330 36 $1.49 No
37 Consider the following NLP problem:Maximize 10X1 + 15X2 + 25X3 subject to the constraints X1 + X2 + X3 … 12 X1 2 + X2 2 … 32 2X1 + X3 3 … 44 X1, X2, X3 Ú 0(a) Set up and solve the model by using Solver .Use a starting value of zero for each decision variable.(b) Is the solution obtained a
38 Consider the following NLP problem:Maximize 2X1 + X2 - 2X3 + 3X1X2 + 7X3 3 subject to the constraints 2X1 + 4X2 + 3X3 Ú 34 3X1+ X2 Ú 10 X1 + X2 + X3 … 12 X1, X2, X3 Ú 0(a) Set up and solve the model by using Solver .Use a starting value of zero for each decision variable.(b) Is the solution
40 A snowmobile manufacturer produces three models, the XJ6, the XJ7, and the XJ8. In any given productionplanning 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
41 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
42 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
43 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
1. Understand how to plan, monitor, and control projects using PERT/CPM.
2. Determine earliest start, earliest finish, latest start, latest finish, and slack times for each activity.
3. Understand the impact of variability in activity times on the project completion time.
4. Develop resource loading charts to plan, monitor, and control the use of various resources during a project.
5. Use LP to find the least-cost solution to reduce total project time and solve these LP models using Excel’s Solver.

Showing 300 - 400 of 545

Managerial Decision Modeling With Spreadsheets 3rd Edition Barry Render - Solutions

Step by Step Answers