Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 45P
a)
Summary Introduction
To determine: The way to minimize the bus company’s costs over the period of next five years.
Linear programming:
It is a mathematical modeling procedure where a linear function is maximized or minimized subject to certain constraints. This method is widely useful in making a quantitative analysis which is essential for making important business decisions.
a)
Expert Solution
Explanation of Solution
Model:
Solver input:
The solver input is selected from under the “Data” tab in Excel and the input is given as shown below:
Formula:
The total cost is $3,420,000.
b)
Summary Introduction
To use: The solver table to determine the .change in the total number of hired, fired, total cost change due to the change in unit hiring, firing where each of them increases by the same percentage.
Linear programming:
It is a mathematical modeling procedure where a linear function is maximized or minimized subject to certain constraints. This method is widely useful in making a quantitative analysis which is essential for making important business decisions.
b)
Expert Solution
Explanation of Solution
One-way solver table:
The one-way solver table is selected and the input is given as shown below:
Output:
In the given range of percent increases, the total of hired and fired does not change. But, the cost increases.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
There are two companies manufacturing drones. Company A manufactures mass market drones, while company B manufactures customised drones according to customers’ requirements. In 2020, company A produces 3,200 drones, 3% of which were found to be defective and cannot pass the quality check. Company A employs 5 workers working an average of 8 hours a day in the drone production, and they worked 200 working days in 2020.In contrast, company B produces 900 drones, 10% of which were found to be defective and cannot pass the quality check. Company B employs 3 workers working an average of 6 hours a day in the drone production, and they worked 170 days in 2020.
(a) If the drone manufacturing is seen as a process, what is considered as the output of the production processes of companies A and B and why?
(b) Measure the single-factor manpower productivity for the two companies.
(c) Is it reasonable to compare the manpower productivity of the two companies and reach a conclusion that one company…
A company has one machine which can be used to make product Alpha and product Beta.
Each unit of product Alpha requires 45 minutes of machine time, while
each unit of product Beta requires 37 minutes of machine time.
The machine can be used for 8 hours per day and 5 days per week.
Next week the company will produce 23 units of product Alpha.
After completing the production of Alpha, the company will produce product Beta.
How many units of product Beta can be produced next week?
Use at least 4 decimals.You must showm your calculation steps and brief explanation on your Excel spreadsheets.
A roller coaster is being designed for a new theme park. Two "trains" are on the track
at any given time. One train is being unloaded/reloaded while the other is moving
along the track. The track itself takes 10 minutes to complete. The train being loaded
should depart before the arriving train is no closer than one minute away.
Each car of a train accommodates four people. Loading a car is estimated to take 6
seconds per passenger. Unloading is estimated to take 6 seconds per passenger.
Suppose that (unlike actual roller coasters), only one car can be loaded or unloaded
at a time. Unloading can NOT occur at the same time as loading.
In order to maximize the number of potential passengers, how many cars should the
train be made up of? Round your answer to the nearest whole car.
Chapter 4 Solutions
Practical Management Science
Ch. 4.2 - Prob. 1PCh. 4.2 - Prob. 2PCh. 4.2 - Prob. 3PCh. 4.2 - Prob. 4PCh. 4.2 - Prob. 5PCh. 4.2 - Prob. 6PCh. 4.3 - Prob. 7PCh. 4.3 - Prob. 8PCh. 4.3 - Prob. 9PCh. 4.3 - Prob. 10P
Ch. 4.3 - Prob. 11PCh. 4.3 - Prob. 12PCh. 4.4 - Prob. 13PCh. 4.4 - Prob. 14PCh. 4.4 - Prob. 15PCh. 4.4 - Prob. 16PCh. 4.4 - Prob. 17PCh. 4.4 - Prob. 18PCh. 4.4 - Prob. 19PCh. 4.5 - Prob. 20PCh. 4.5 - Prob. 21PCh. 4.5 - Prob. 22PCh. 4.5 - Prob. 23PCh. 4.5 - Prob. 24PCh. 4.5 - Prob. 25PCh. 4.6 - Prob. 26PCh. 4.6 - Prob. 27PCh. 4.6 - Prob. 28PCh. 4.6 - Prob. 29PCh. 4.7 - Prob. 30PCh. 4.7 - Prob. 31PCh. 4.7 - Prob. 32PCh. 4.7 - Prob. 33PCh. 4.7 - Prob. 34PCh. 4.7 - Prob. 35PCh. 4.7 - Prob. 36PCh. 4.7 - Prob. 37PCh. 4.7 - Prob. 38PCh. 4.7 - Prob. 39PCh. 4.7 - Prob. 40PCh. 4.8 - Prob. 41PCh. 4.8 - Prob. 42PCh. 4.8 - Prob. 43PCh. 4.8 - Prob. 44PCh. 4 - Prob. 45PCh. 4 - Prob. 46PCh. 4 - Prob. 47PCh. 4 - Prob. 48PCh. 4 - Prob. 49PCh. 4 - Prob. 50PCh. 4 - Prob. 51PCh. 4 - Prob. 52PCh. 4 - Prob. 53PCh. 4 - Prob. 54PCh. 4 - Prob. 55PCh. 4 - Prob. 56PCh. 4 - Prob. 57PCh. 4 - Prob. 58PCh. 4 - Prob. 59PCh. 4 - Prob. 60PCh. 4 - Prob. 61PCh. 4 - Prob. 62PCh. 4 - Prob. 63PCh. 4 - Prob. 64PCh. 4 - Prob. 65PCh. 4 - Prob. 66PCh. 4 - Prob. 67PCh. 4 - Prob. 68PCh. 4 - Prob. 69PCh. 4 - Prob. 70PCh. 4 - Prob. 71PCh. 4 - Prob. 72PCh. 4 - Prob. 73PCh. 4 - Prob. 74PCh. 4 - Prob. 75PCh. 4 - Prob. 76PCh. 4 - Prob. 77PCh. 4 - Prob. 78PCh. 4 - Prob. 79PCh. 4 - Prob. 80PCh. 4 - You want to take out a 450,000 loan on a 20-year...Ch. 4 - Prob. 82PCh. 4 - Prob. 83PCh. 4 - Prob. 84PCh. 4 - Prob. 85PCh. 4 - Prob. 86PCh. 4 - Prob. 87PCh. 4 - Prob. 88PCh. 4 - Prob. 89PCh. 4 - Prob. 90PCh. 4 - Prob. 91PCh. 4 - Prob. 92PCh. 4 - Prob. 93PCh. 4 - Prob. 94PCh. 4 - Prob. 95PCh. 4 - Prob. 96PCh. 4 - Prob. 97PCh. 4 - Prob. 98PCh. 4 - Prob. 99PCh. 4 - Prob. 100PCh. 4 - Prob. 101PCh. 4 - Prob. 102PCh. 4 - Prob. 103PCh. 4 - Prob. 104PCh. 4 - Prob. 105PCh. 4 - Prob. 106PCh. 4 - Prob. 107PCh. 4 - Prob. 108PCh. 4 - Prob. 109PCh. 4 - Prob. 110PCh. 4 - Prob. 111PCh. 4 - Prob. 112PCh. 4 - Prob. 113PCh. 4 - Prob. 114PCh. 4 - Prob. 115PCh. 4 - Prob. 116PCh. 4 - Prob. 117PCh. 4 - Prob. 118PCh. 4 - Prob. 119PCh. 4 - Prob. 120PCh. 4 - Prob. 121PCh. 4 - Prob. 122PCh. 4 - Prob. 123PCh. 4 - Prob. 124PCh. 4 - Prob. 125PCh. 4 - Prob. 126PCh. 4 - Prob. 127PCh. 4 - Prob. 128PCh. 4 - Prob. 129PCh. 4 - Prob. 130PCh. 4 - Prob. 131PCh. 4 - Prob. 132PCh. 4 - Prob. 133PCh. 4 - Prob. 134PCh. 4 - Prob. 135P
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- FRUIT COMPUTER COMPANY Fruit Computer Company manufactures memory chips in batches of ten chips. From past experience, Fruit knows that 80% of all batches contain 10% (1 out of 10) defective chips, and 20% of all batches contain 50% (5 out of 10) defective chips. If a good (that is, 10% defective) batch of chips is sent to the next stage of production, processing costs of $4000 are incurred, and if a bad batch (50% defective) is sent on to the next stage of production, processing costs of $16000 are incurred. Fruit also has the alternative of reworking a batch at a cost of $4000. A reworked batch is sure to be a good batch. Alternatively, for a cost of $400, Fruit can test one chip from each batch in an attempt to determine whether the batch is defective. QUESTIONS 1.Determine a strategy so Fruit can minimize the expected total cost per batch. 2.Compute the EVSI and EVPI.arrow_forwardAn experiment that involves learning in animals requires placing white mice and rabbits into separate, controlled environments: environment I and environment II. The maximum amount of time available in environment I is 420 minutes, and the maximum amount of time available in environment II is 624 minutes. The white mice must spend 10 minutes in environment I and 24 minutes in environment II, and the rabbits must spend 12 minutes in environment I and 16 minutes in environment II. (a) Write a system of inequalities that describes the constraints on the number of each type of animal used in the experiment. (Let x represent the number of mice, and let y represent the number of rabbits.) environment I time constraint environment II time constraint x ≥ 0 experiment constraint, mice y ≥ 0 experiment constraint, rabbits (b) Graph the solution of the system of inequalities and find the corners of the solution region.arrow_forwardA political party is planning a ninety-minute television show. The show will have at least 9 minutes of direct requests for money from viewers. Three of the party's politicians will be on the show- a senator, a congresswoman, and a governor. The senator, a party "elder statesman," demands that he be on screen for at least twice as long as the governor. The total time taken by the senator and the governor must be at least twice the time taken by the congresswoman. Based on a pre-show survey, it is believed that 37, 41, and 45 (in thousands) viewers will watch the program for each minute the senator, congresswoman, and governor, respectively, are on the air. Find the time that should be allotted to each politician in order to get the maximum number of viewers. Find the maximum number of viewers. The quantity to be maximized, z, is the number of viewers in thousands. Let x, be the total number of minutes allotted to the senator, × be the total number of minutes allotted to the…arrow_forward
- Apply Linear Programming to the Folling Question: Dan Reid, chief engineer at New Hampshire Chemical, Inc., has to decide whether to build a new state-of-art processing facility. If the new facility works, the company could realize a profit of $200,000. If it fails, New Hampshire Chemical could lose $150,000. At this time, Reid estimates a 60% chance that the new process will fail. The other option is to build a pilot plant and then decide whether to build a complete facility. The pilot plant would cost $10,000 to build. Reid estimates a fifty-fifty chance that the pilot plant will work. If the pilot plant works, there is a 90% probability that the complete plant, if it is built, will also work. If the pilot plant does not work, there is only a 20% chance that the complete project (if it is constructed) will work. Reid faces a dilemma. Should he build the plant? Should he build the pilot project and then make a decision? Help Reid by analyzing this problemarrow_forwardA college student works in both the school cafeteria and library. She works no more than 12 hours per week at the cafeteria, and no more than 16 hours per week at the library. She must work at least 20 hours each week. Write a system of inequalities that describes all the given conditions. Write a system of inequalities letting x= number of hours worked at the cafeteria per week and y = number of hours worked at the library per week. x+yz x≤ ysarrow_forwardA catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem.arrow_forward
- A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of S0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem. Part B: Solve the problem (provide exact values for all variables and the optimal objective function).arrow_forwardLong-Life Insurance has developed a linear model that it uses to determine the amount of term life Insurance a family of four should have, based on the current age of the head of the household. The equation is: y=150 -0.10x where y= Insurance needed ($000) x = Current age of head of household b. Use the equation to determine the amount of term life Insurance to recommend for a family of four of the head of the household is 40 years old. (Round your answer to 2 decimal places.) Amount of term life insurance thousandsarrow_forwardA trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize the annual return. Bond Annual Return Maturity Risk Tax Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0% Long High Yes E 9.0% Short High No The officer wants to invest at least 40% of the money in short-term issues and no more than 20% in high-risk issues. At least 25% of the funds should go in tax-free investments, and at least 45% of the total annual return should be tax free. Formulate the LP model for this problem. Create the spreadsheet model and use Solver to solve the problem. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forward
- KAPC, a pharmaceutical company located in rural Kansas, is finding it difficult to retain its employees, who frequently leave after just six months of working at KAPC for jobs at pharmaceutical companies paying higher wages in Chicago. To address its problem with labor turnover, human resource officers at KAPC decide to run an experiment. Of their next 100 newly hired employees, 25 will randomly be selected to receive a housing voucher worth up to $4,000 per year to offset property taxes. To take advantage of this program, the employee must not only be randomly selected into the program but she must also purchase a home. Of the 25 employees selected into the housing voucher program, 7 leave KAPC within 12 months of starting. Of the 75 employees not selected into the program, 37 leave KAPC within 12 months of starting.a. Provide a difference-in-differences estimate of the effect the housing voucher program has on retention at KAPC.b. Suppose KAPC spends $10,000 in hiring costs each time…arrow_forwardA trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the total annual return (before tax). Bond Annual Return Maturity Risk Tax-Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0% Long High Yes E 9.0% Short High No The officer wants to invest as least 50% of the money in short-term issues and no more than 50% in high-risk issues. At least 30% of the funds should go in tax-free investments, and at least 40% of the total annual return should be tax free. Suppose the decision variable represents the amount of money invested in bond for . Formulate a linear programming (LP) model to solve the optimal strategy. 1. Write down the constraint using the defined decision variables requiring “invest as least 50% of the money in short-term issues”. 2. Write down the constraint using the defined decision…arrow_forwardA farm consists of 600 acres of land, of which 500 acres will be planted with corn, soybeans, and wheat, according to these conditions: At least half of the planted acreage should be in corn No more than 200 acres should be soybeans The ratio of corn to wheat planted should be 2:1 It costs $20 an acre to plant corn, $15 an acre to plant soybeans, and $12 an acre to plant wheat Formulate this problem as an LP model that will minimize planting cost while achieving the specified conditions.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,