Questions and Answers of Managerial Decision Modeling Business Analytics With Spreadsheet

38 The production department for an aluminum valve plant is scheduling its work for next month. Each valve must go through three separate machines during the fabrication process. After fabrication,
41 An electronics corporation manufactures four highly technical products that it supplies to aerospace firms. Each of the products must pass through the following departments before being
43 An investor is considering three different television news stocks to complement his portfolio: British Broadcasting Company (BBC), Canadian Broadcasting Company (CBC), and Australian Broadcasting
1. What recommendations should Ron Garcia make, with what justification? Provide a detailed analysis, with charts, graphs, and Excel printouts included.Ron Garcia felt good about his first week as a
2. Discuss the need for temporary workers in the drawing department.Ron Garcia felt good about his first week as a management trainee at Mexicana Wire Winding, Inc. He had not yet developed any
3. Discuss the plant layout.Ron Garcia felt good about his first week as a management trainee at Mexicana Wire Winding, Inc. He had not yet developed any technical knowledge about the manufacturing
1. Formulate an LP problem to determine what blend of the four chemicals will allow Golding to minimize the cost of a 50-pound bag of the fertilizer.Kenneth and Patricia Golding spent a career as a
2. Solve by using Excel to find the best solution.Kenneth and Patricia Golding spent a career as a husband-andwife real estate investment partnership in Washington, DC.When they finally retired to a
1. Model a wide variety of linear programming (LP)problems.
2. Understand major business application areas for LP problems, including manufacturing, marketing, finance, employee staffing, transportation, blending, and multiperiod planning.
3. Gain experience in setting up and solving LP problems using Excel’s Solver.
1 A small backpack manufacturer carries four different models of backpacks, made of canvas, plastic, nylon, and leather. The bookstore, which will exclusively sell the backpacks, expects to be able
2 A contestant on the hit reality television show Top Bartender was asked to mix a variety of drinks, each consisting of 4 fluid ounces. No other ingredients were permitted. She was given the
3 A manufacturer of travel pillows must determine the production plan for the next production cycle. He wishes to make at least 300 of each of the three models that his firm offers and no more than
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:
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
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
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
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
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
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
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
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,
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
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
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
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
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
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
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
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
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
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)
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
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
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
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
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%
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
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,
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
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
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
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
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
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
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
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
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
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 $
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 $
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
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)
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
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
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
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,
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
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

Showing 200 - 300 of 459