A bus company believes that it will need the following numbers of bus drivers during each of the next five years: 60 drivers in year 1; 70 drivers in year 2; 50 drivers in year 3; 65 drivers in year 4; and 75 drivers in year 5. At the beginning of each year, the bus company must decide how many drivers to hire or fire. It costs $4000 to hire a driver and $2000 to fire a driver. A driver’s salary is $10,000 per year. At the beginning of year 1, the company has 50 drivers. A driver hired at the beginning of a year can be used to meet the current year’s requirements and is paid full salary for the current year. a. Determine how to minimize the bus company’s salary, hiring, and firing costs over the next five years. b. Use SolverTable to determine how the total number hired, total number fired, and total cost change as the unit hiring and firing costs each increase by the same percentage.

A bus company believes that it will need the following numbers of bus drivers during each of the next five years: 60 drivers in year 1; 70 drivers in year 2; 50 drivers in year 3; 65 drivers in year 4; and 75 drivers in year 5. At the beginning of each year, the bus company must decide how many drivers to hire or fire. It costs $4000 to hire a driver and $2000 to fire a driver. A driver’s salary is $10,000 per year. At the beginning of year 1, the company has 50 drivers. A driver hired at the beginning of a year can be used to meet the current year’s requirements and is paid full salary for the current year. a. Determine how to minimize the bus company’s salary, hiring, and firing costs over the next five years. b. Use SolverTable to determine how the total number hired, total number fired, and total cost change as the unit hiring and firing costs each increase by the same percentage.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section: Chapter Questions

Problem 54P

See similar textbooks

Similar questions

During an eight-hour shift, 750 non-defective parts are desired as a result of a manufacturing operation. The default operation time is 15 minutes. As the operators of machine are inexperienced, the actual time they take to perform the operation is 20 minutes, and, on average, a fifth of the parts that start to be manufactured are lost. Assuming that each one of the machines used in this operation will not be available for one hour in each shift, determine the number of machines needed.
In an oil company, its south refinery produces per day 300 barrels of high grade oil, 200 barrels of medium grade oil and 150 barrels of low grade oil. The cost of operation of this refinery amounts to P 600,000 per day. The north refinery of the company produces each day 100 barrels of high grade oil and 100 barrels of medium-grade oil and 150 of low-grade oil. Which has a total of P500,000 operational costs. If the company’s production requirement is at least 900 barrels for high-grade oil, 800 barrels for medium-grade oil, and 750 for low-grade oil, how many days, are required for each refinery to operate to obtain the minimum cost?
A group of students organizes a bake sale in which they sell hundreds of cookies at$1 per piece. They set up a table on campus and wait for students to come and purchasetheir cookies. Consider the following variables in this bake sale operation:1. Size of the cookies2. Weather conditions on campus3. Organization of the table4. Number of cookies sold5. Competition from other fund-raisers coinciding on campus6. Amount of advertising and shouting of the students at the bake sale table7. Number of students on campus that dayWhich of these variables are input variables?a. 1 and 2b. 1 and 3c. 1, 3, and 5d. 1, 3, and 6
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.
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.
An 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.
A political party is planning a half-hour television show. The show will have at least 3 minutos of direct requests for money from viowers 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 y the congresswoman Based on a pre-show survey, it is believed that 33, 38, and 43 (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, x, be the total number of minutes allottod to the congresswoman, and x,…
Mr. Ajit currently serves at a senior director with BSNL Mumbai. In his brigade of staff there are 10 supervisors and more than 200 telephone assistance operators. If any resident wants to call 197 for directory assistance ,he would be speaking with one of the employees from BSNL. Within this organisation the position of a telephone assistance operator requires high standards of communication ,a pleasant tone, good voice quality and familiarity with the company’s computer operator directories and software. The assistant also needs to be proactive in answering other queries asked by the caller. A major issue that is seen is that a lot of telephone assistance operators tend to leave the organisation , that turnover rates are high and people look unwilling. Mr. Ajit has noticed that upon joining, these telephone operators do not receive any detailed training. Being that it's a very busy workplace, these operators are given a short tour of the office and a five-page printed sheet that…
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).
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 $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem.
The Decision Sciences Department is tyring to determine whether to rent a slow or fast copier. The department believes that an employee's time is worth $15/hour. The slow copier rents for $4/hr, and it takes an employee an average of 10 minutes to complete copying. The fast copier rents for $15/hr, and it takes an employee an average of 6 minutes to complete copying. On average, four employees per hour need to use the copying machine. (Assume the copying times and interarrival times to the copying machine are exponentially distributed.) Which machine should the department rent to minimize expected total cost per hour? Please note this class revolves around Microsoft Excel so the answer I need needs to show the formulas in Excel, along with any corresponding graphs, etc. Thank you in advance!