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

Result Not Found

Books FREE
Study Help
Tutors
AI Study Planner NEW
Sell Books

Search
Sign In
Register

study help
mathematics
statistics

Managerial Decision Modeling With Spreadsheets 3rd Edition Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair - Solutions

A furniture cabinet maker produces two types of cabinets that house and hide plasma televisions. The Mission-style cabinet requires $340 in materials and 15 labor hours to produce, and it yields a profit of $910 per cabinet. The Rustic-style cabinet requires $430 in materials and 20 hours to
Members of a book club have decided, after reading an investment book, to begin investing in the stock market. They would like to achieve the following: Their investment must grow by at least $6,000 in the long term (over three years) and at least $900 in the short term, and they must earn a
Treetops Hammocks produces lightweight nylon hammocks designed for campers, scouts, and hikers. The hammocks come in two styles: double and single. The double hammocks sell for $225 each. They incur a direct labor cost of $101.25 and a production cost of $38.75, and they are packed with hanging
A commuter airline makes lattes in the galley and sells them to passengers. A regular latte contains a shot of espresso, 1 cup of 2% milk, frothed, and 0.5 cup of whipped cream. The low-fat latte contains a shot of espresso, 1.25 cups of skim milk, frothed, and no whipped cream. The plane begins
A warehouse storage building company must determine how many storage sheds of each size—large or small—to build in its new 8,000-square-foot facility to maximize rental income. Each large shed is 150 square feet in size, requires $1 per week in advertising, and rents for $50 per week. Each
The workload in many areas of bank operations has the characteristics of a non-uniform distribution with respect to time of day. For example, at Chase Manhattan Bank in New York, the number of domestic money transfer requests received from customers, if plotted against time of day, would appear to
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 to sell between 15 and 40 of each model. The store has agreed to pay $35.50 for each canvas backpack,
The advertising director a large retail store in Columbus, Ohio, is considering three advertising media possibilities: (1) ads in the Sunday Columbus Dispatch newspaper, (2) ads in a local trade magazine that is distributed free to all houses in the city and northwest suburbs, and (3) ads on
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 bud-get 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
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
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 in-vestment, subject to the following guidelines:• At least 20% in municipal bonds• At least 10% each in real estate stock and
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% of
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
A couple has agreed to attend a “casino night” as part of a fundraiser for the local hospital, but they believe that gambling is generally a losing proposition. For the sake of the charity, they have decided to attend and to allocate $300 for the games. There are to be four games, each
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 six
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
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
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 following quantities of liquor:The contestant is considering making the following four drinks:• The New
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
A small trucking company is determining the com-position 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
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 p. 110.€ƒThe plane can carry as many as 32 tons of
The owner of a private freighter is trying to decide which cargo he should carry on his next trip. He has two choices of cargo, which he can agree to carry in any combination. He may carry up to 15 tons of cargo A, which takes up 675 cubic feet per ton and earns revenue of $85 per ton. Or, he may
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
The farmer in Problem 3-25 has an opportunity to take over the neighboring 80-acre farm. If he acquires this farm, he will be able to increase the amounts of time available to 1,600 hours for planting, 825 hours for tending, and 1,400 hours for harvesting. Between the two farms, there are 510 units
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
A farmer has subdivided his land into three plots and wants to plant three crops in each plot: com, 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
A fuel cell manufacturer can hire union, non-union permanent, or temporary help. She has a contract to produce at the rate of 2,100 fuel cells per day and would like to achieve this at minimum cost. Union workers work 7 hours per day and can make up to 10 fuel cells per hour. Their wages and
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 1,200 of any one model. The specifics for each model are shown in the following table. How many pillows
A chemical company wishes to mix three elements (E, F, and G) to create three alloys (X, Y, and Z). The costs ofThe elements are as shown in the following table.To maintain the required quality for each alloy, it is necessary to specify certain maximum or minimum percentages of the elements. These
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 cost
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 pounds
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, and
A steel company is producing steel for a new contract. The contract specifies the information in the following table for the steel.The steel company mixes batches of eight different available materials to produce each ton of steel according to the specification. The table at the bottom of this page
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 6
A distributor imports olive oil from Spain and Italy in large casks. He then mixes these oils in different proportions to create three grades of olive oil that are sold domestically in the United States. The domestic grades include (a) commercial, which must be no more than 35% Italian; (b) virgin,
A paint company has two types of bases from which it blends two types of paints: Tuffcoat and Satin- wear. Each base has a certain proportion of ingredients X, Y, and Z, as shown in the table at the top of p. 114, along with their costs.€ƒThe specifications for the two paints are shown in the
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 least
A commercial food for caged reptiles is made in 40-pound bags from five potential feeds. For labeling purposes, feed A must constitute at least 20% of each bag by weight, and each of feeds B to E must be at least 5% of the total weight. Further, feeds B and D must together constitute at least 30%
Students who are trying to raise funds have an agreement with a local pizza chain. The chain has agreed to sell them pizzas at a discount, which the students can then resell to families in the local community for a profit. It is expected that of the 500 families in the community, at most 70% will
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 fully
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.At the beginning of September, the warehouse is expected to be completely empty. There is room for no more than 1,800 integrated circuits to be
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, 20In, 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.She
The Transportation Security Administration (TSA) at a large airport has 175 agents hired and trained for the month of January. Agents earn an average of $3,300 per month and work 160 hours per month. The projection is that 26,400 agent-hours will be required in February, 29,040 agent hours will be
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-foot¬wide paper. It produces rolls of two
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 the
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 distances
The school district in Problem 3-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
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
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.
A company produces three different types of wrenches: Will, W222, and W333. It has a firm order for 2,0 will wrenches, 3,750 W222 wrenches, and 1,700W333 wrenches. Between now and the order delivery date, the company has only 16,500 fabrication hours and 1,600 inspection hours. The time that each
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,
A political polling organization is to conduct a poll of likely voters prior to an upcoming election. Each voter is to be interviewed in person. It is known that the costs of interviewing different types of voters vary due to the differences in proportion within the population. The costs to
In December 2005, Bill Stock, general manager for the Louisiana Division of Coastal States Chemicals and Fertilizers, received a letter from Fred McNair of the Cajan Pipeline Company, which notified Coastal States that priorities had been established for the allocation of natural gas. The letter
A graphical approach was used to solve the following LP model in Problem 2-14:Maximize profit = $4X + $5T Subject to the constraints
A graphical approach was used to solve the following LP model in Problem 2-16:Minimize cost = $4X + $7T Subject to the constraints
A graphical approach was used to solve the following LP model in Problem 2-15:Maximize profit = $4X + $3T Subject to the constraints
Use the Sensitivity Report for this LP model (shown in Screenshot 4-6) to answer the following questions. Each question is independent of the others.What is the impact on the audience coverage under the following scenarios?(a) Management approves spending $200 more on radio advertising each
Consider the MSA marketing research example discussed in Section 3.3 (page 74) of Chapter 3. Use the Sensitivity Report for this LP model (shown in Screenshot 4-7 on page 150) to answer the following questions. Each question is independent of the others. (a) What is the maximum unit cost that will
Consider the Whole Food Nutrition Center diet problem example discussed in Section 3.7 of Chapter 3. Use the Sensitivity Report for this LP model (shown in Screenshot 4-8 on page 150) to answer the following questions. Each question is independent of the others.(a) What is the impact if the daily
Consider the cell phone manufacturing problem presented in Chapter 3 as Problem 3-6 on page 105. Use Solver to create the Sensitivity Report for this LP problem. Use this report to answer the following questions. Each question is independent of the others.(a) Interpret the reduced costs for the
Use Solver to create the Sensitivity Report for this LP problem. Use this report to answer the following questions. Each question is independent of the others.
Consider the boarding stable feed problem presented in Chapter 3 as Problem 3-32 on page 112. Use Solver to create the Sensitivity Report for this LP problem. Use this report to answer the following questions. Each question is independent of the others.
Use Solver to create the Sensitivity Report for this LP problem.Use this report to answer the following questions.Each question is independent of the others.(a) Interpret the shadow prices for the carbohydrates and iron constraints.(b) What would happen to total cost if the dietitian chooses to use
Is sensitivity analysis a concept applied to LP only, or should it also be used when analyzing other techniques (e.g., break-even analysis)? Provide examples to prove your point.
Consider the following LP problem, in which X and Y denote the number of units of products X and Y to produce, respectively:Maximize profit = $4X + $5Tsubject to the constraintsFollowing situations. Each question is independent of the other questions.(a) You acquire 2 additional pounds of
Consider the following LP problem, in which X and Y denote the number of units of products X and Y to produce, respectively:Maximize profit = $5X + $5T subject to the constraintsThe Excel Sensitivity Report for this problem is shown in Screenshot 4-10 on page 152. Calculate and explain what happens
Suppose Good-to-Go (Problem 4-22) is considering the possible introduction of two new products to its line of suitcases: the Compact model (for teenagers) and the Kiddo model (for children). Market research suggests that Good-to-Go can sell the Compact model for no more than $30, whereas the Kiddo
The Strollers-to-Go Company makes lightweight umbrella-type strollers for three different groups of children. The TiniTote is designed specifically for newborns who require extra neck support. The ToddleTote is for toddlers up to 30 pounds. Finally, the company produces a heavy-duty model called
Consider the Strollers-to-Go production problem (Problem 4-24).a. Over what range of costs could the TiniTote materials vary and the current production plan remain optimal? (b) Suppose that Strollers-to-Go decided to polish each stroller prior to shipping. The process is fast and would require 10,
(a) Suppose that Strollers-to-Go could purchase additional fabrication time at a cost of $10.50 per hour. Should it be interested? Why or why not? What is the most that it would be willing to pay for an additional hour of fabrication time? (b) Suppose that Strollers-to-Go could only purchase
Suppose that Strollers-to-Go (Problem 4-24) is considering the production of TwinTotes for families who are doubly blessed. Each TwinTote would require $7.10 in materials, 4 hours of fabrication time, 2 hours of sewing time, and 2 hours to assemble. Would this product be economically attractive to
The Classic Furniture Company is trying to determine the optimal quantities to make of six possible products: tables and chairs made of oak, cherry, and pine. The products are to be made using the following resources: labor hours and three types of wood. Minimum production requirements are as
Consider the Classic Furniture product mix problem (Problem 4-28). For each of the following situations, what would be the impact on the production plan and profit? If it is possible to compute the new profit or production plan, do so. (a) The unit profit for oak tables increases to $83. (b) The
Explain how a change in resource availability can affect the optimal solution of a problem.
Consider the Classic Furniture product mix problem (Problem 4-28). For each of the following situations,€ƒ(a) The number of labor hours expands to 1,320. (b) The amount of cherry wood increases to 3,900. (c) The number of labor hours decreases to 950. (d) The company does not have a
Consider the Classic Furniture product mix problem (Problem 4-28). For each of the following situations, what would be the impact on the production plan and profit? If it is possible to compute the new profit or production plan, do so.(a) OFCs for oak tables and cherry tables each decreases by
Consider the Classic Furniture product mix problem (Problem 4-28). In answering each of the following questions, be as specific as possible. If it is possible to compute a new profit or production plan, do so.(a) A part-time employee who works 20 hours per week decided to quit his job. How would
The Tiger Catering Company is trying to determine the most economical combination of sandwiches to make for a tennis club. The club has asked Tiger to provide 70 sandwiches in a variety to include tuna, tuna and cheese, ham, ham and cheese, and cheese. The club has specified a minimum of 10 each of
Consider the Tiger Catering problem (Problem 4-33). For each of the following situations, what would beThe impact on the sandwich-making plan and total cost? If it is possible to compute the new cost or sandwich-making plan, do so. (a) The unit cost for tuna sandwiches decreases by $0.30. (b) The
For each of the following situations, what would be the impact on the sandwich-making plan and total cost? If it is possible to compute the new cost or sandwich-making plan, do so. (a) The quantity of tuna available decreases to 120 ounces. (b) The quantity of ham available increases to 115
For each of the following situations, what would be the impact on the sandwich-making plan and total cost? If it is possible to compute the new cost or sandwich-making plan, do so. (a) The cost of ham sandwiches and the cost of ham and cheese sandwiches each decreases by $0.35. (b) The cost of both
Consider the Tiger Catering problem (Problem 4-33). In answering each of the following questions, be as specific as possible. If it is possible to compute a new cost or sandwich-making plan, do so. (a) An additional pound of tuna can be obtained for a premium of $1.50. Should this tuna be
Explain how a change in an OFC can affect the optimal solution of a problem.
Are simultaneous changes in input data values logical? Provide examples to prove your point.
Explain the 100% rule and its role in analyzing the impact of simultaneous changes in model input data values.
How can a firm benefit from using the pricing out procedure?
How do we detect the presence of alternate optimal solutions from a Solver Sensitivity Report?
Why would a firm find information regarding the shadow price of a resource useful?
How can we manipulate a maximal-flow network model in order to specify all arcs between each pair of nodes (i.e., the entire table) as the changing variable cells in Solver?
How can we manipulate a shortest-path network model in order to specify all arcs between each pair of nodes (i.e., the entire table) as the changing variable cells in Solver?
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
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 Southern Rail Company ships coal by rail from three coal mines to meet the demand requirements of four coal depots. The following table shows the distances from the mines to the various depots and the availabilities and requirements for coal. Determine the best shipment of coal cars to minimize
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
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.O€™Brian can normally produce 100 windshields in a month. This is done
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
A food distribution company ships fresh spinach from its four packing plants to large East-coast cities. The shipping costs per crate, the supply and demand are shown in the table at the bottom of this page.(a) Formulate a model that will permit the company to meet its demand at the lowest possible
The Lilly Snack Company is considering adding an additional plant to its three existing facilities in Wise, Virginia; Humbolt, Tennessee; and Cleveland, Georgia to serve three large markets in the Southeast. Two locations€”Brevard, North Carolina, and Laurens, South
What is a balanced transportation model? Describe the approach you would use to solve an unbalanced model.
Meg Bishop, vice president of supply chain at the Lilly Snack Company (see Problem 5-19) has been able to secure shipping from the proposed plant in Brevard to its plants in Wise and Cleveland for $6 and $5 per pallet, respectively. If Lilly chooses to place a new plant in Brevard, what would be

Showing 51900 - 52000 of 88243

First
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
Last

Step by Step Answers

Services

Sitemap
Fun
Definitions
Become Tutor
Used Textbooks
Study Help Categories
Recent Questions
Expert Questions
Campus Wear
Sell Your Books

Company Info

Security
Copyrights
Privacy Policy
Terms & Conditions
SolutionInn Fee
Scholarship
Online Quiz
Give Feedback, Get Rewards

Get In Touch

About Us
Contact Us
Career
Jobs
FAQ
Student Discount
Campus Ambassador

Secure Payment

Download Our App

© 2026 SolutionInn. All Rights Reserved