A bus company believes that it will need the follow- ing 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 driv- ers 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 sal- ary, 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 follow- ing 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 driv- ers 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 sal- ary, 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

Beeson Co. is experiencing a decrease in sales and operating income for the fiscal year ending December 31st. Julia Faure, controller of Beeson Co., has suggested that all orders received before the end of the fiscal year be shipped by midnight, December 31st even if shipping department must work overtime. Since Beeson Co. ships all merchandise FOB shipping point, it would record all such shipments as sales for the year ending December 31st, thereby offsetting some of the decreases in sales and operating income.Discuss whether Julia Faure is behaving in a professional manner and what are the implications of her actions?
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.
fi Auto mobile company manufactures cars and trucks. Each vehicle must be processed in the paint shop and body assembly shop. If the paint shop were only painting trucks, then 80 per day could be painted. If the paint shop were only painting cars, then 120 per day could be painted. If the body shop were only producing cars, then it could process 100 per day. If the body shop were only producing trucks, then it could process 100 per day. Each truck contributes GHS60,000 to profit, and each car contributes GHS40,000 to profit. Use linear programming to determine a daily production schedule that will maximize the company’s profits.
A large building may require an automated alarm system which monitors and controls all fire and security alarms in the building. Normally, the building is divided into zones and a number of alarms are associated with each zone. Alarms alert a central manned control area who may pass these on to the emergency services or may respond personally.Factors which have to be taken into account in building such a system are:Ø If the control area is unmanned and an alarm is activated this alarm should not be ignored if it is potentially serious. Emergency services should be automatically called.Ø Some but not all parts of the building may be equipped with sprinkler systems or systems to shut down electrical equipment. These should be activated if a fire alarm is confirmed. They should not be activated if there are people in the same room.Ø The building may be equipped with direction indicators which illuminate the route to the nearest exit. These should be activated when a fire alarm is…
Solve the question below using the attached excel templates with formulas for renting both slow and fast copies (labeled in the excel tabs). Question: The Decision Sciences Department is trying to determine whether to rent a slow or a fast copier. The department believes that an employee’s time is worth $15 per hour. The slow copier rents for $4 per hour, and it takes an employee an average of 10 minutes to complete copying. The fast copier rents for $15 per hour, and it takes an employee an average of six 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?
The Decision Sciences Department is trying todetermine whether to rent a slow or a fast copier. Thedepartment believes that an employee’s time is worth$15 per hour. The slow copier rents for $4 per hour,and it takes an employee an average of 10 minutes tocomplete copying. The fast copier rents for $15 per hour,and it takes an employee an average of six minutes tocomplete copying. On average, four employees per hourneed to use the copying machine. (Assume the copyingtimes and interarrival times to the copying machineare exponentially distributed.) Which machine shouldthe department rent to minimize expected total cost perhour?
A machine tool company conducts a job-training programme at a ratio of one for everyten trainees. The training programme lasts for one month. From past experience it has been found thatout of 10 trainees hired, only seven complete the programme successfully. (The unsuccessful traineesare released). Trained machinists are also needed for machining. The company's requirement for thenext three months is as follows:January: 100 machinists, February: 150 machinists and March: 200 machinists.In addition, the company requires 250 trained machinists by April. There are 130 trained machinistsavailable at the beginning of the year. Pay roll cost per month is:Each trainee Rs. 400/- per month.Each trained machinist (machining or teaching): Rs. 700/- p.m.Each trained machinist who is idle: Rs.500/- p.m.(Labour union forbids ousting trained machinists). Build a l.p.p. for produce the minimum costhiring and training schedule and meet the company’s requirement.
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a minimum cost flow problem by showing the…
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i B 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a shortest-path problem by drawing a…
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!
establish the significance of random numbers in Monte Carlo simulations.
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?