Integer linear programming model to assist park management

Assignment Help Financial Management
Reference no: EM13945385

Adventure Island

Adventure Island is a large theme park located in Tampa, Florida. The park hires high school and college students to work during the summer months of May, June, July, August, and September. The student employees operate virtually all the highly mechanized, computerized rides; perform as entertainers; perform most of the custodial work during park hours; make up the work-force for restaurants, food services, retail shops, and stores; drive trams; and park cars. Park management has assessed the park’s monthly needs based on previous summers’ attendance at the park and the expected available workforce. Park attendance is relatively low in May, until public schools are out, and then it increases through June, July, and August, and decreases dramatically in September, when schools reopen after Labor Day. The park is open 7 days a week through the summer, until September, when it cuts back to weekends only. Management estimates that it will require 20,000 hours of labor in each of the first 2 weeks of May, 23,000 hours during the third week of May, and 31,000 hours during the last week in May. During the first 2 weeks of June, it will require at least 35,000 hours of labor and 40,000 hours during the last 2 weeks in June. In July 45,000 hours will be required each week, and in August 45,000 hours will be needed each week. In September the park will need only 12,000 hours in the first week, 10,000 hours in each of the second and third weeks, and 8,000 hours the last week of the month.

The park hires new employees each week from the first week in May through August. A new employee mostly trains the first week by observing and helping more experienced employees; however, he or she works approximately 10 hours under the supervision of an experienced employee. An employee is considered experienced after completing 1 week on the job. Experienced employees are considered part- time and are scheduled to work 30 hours per week in order to eliminate overtime and reduce the cost of benefits, and to give more students the opportunity to work. However, no one is ever laid off or will be scheduled for fewer (or more) than 30 hours, even if more employees are available than needed. Management believes this is a necessary condition of employment because many of the student employees move to the area during the summer just to work in the park and live near the beach nearby. If these employees were sporadically laid off and were stuck with lease payments and other expenses, it would be bad public relations and hurt employment efforts in future summers. Although no one is laid off, 15% of all experienced employees quit each week for a variety of reasons, including homesickness, illness, and other personal reasons, plus some are asked to leave because of very poor job performance.

Park management is able to start the first week in May with 700 experienced employees who worked in the park in previous summers and live in the area. These employees are generally able to work a lot of hours on the weekends and then some during the week; however, in May attendance is much heavier on the week-ends, so most of the labor hours are needed then. The park expects to have a pool of 1,500 available applicants to hire for the first week in May. After the first week, the pool is diminished by the number of new employees hired the previous week, but each week through June the park gets 200 new job applicants, which decreases to 100 new applicants each week for the rest of the sum-mer. For example, the available applicant pool in the second week in May would be the previous week’s pool, which in week 1 is 1,500, minus the number of new employees hired in week 1 plus 200 new applicants. At the end of the last week in August, 75% of all the experienced employees will quit and go back to school, in addition the park will not hire any new employees in September. The park must operate in September, using experienced employees who live in the area, but the weekly attrition rate for these employees in September drops to 15%.

Formulate and solve an integer linear programming model to assist the park’s management to plan and schedule the number of new employees it hires each week in order to minimize the total number of new employees it must hire during the summer. It may be easier to solve the problem as a regular linear program then change it to integer linear program.

Reference no: EM13945385

Questions Cloud

What looping structure is being used : What variables are used this module? What are their data types?
Our foreign currency exposures were principally euros : At December 31, 2007, our foreign currency exposures were principally Euros, British pound sterling, Danish krone and Japanese yen.
How would you use these cash flows in valuation : Explain how derivative securities are used to find certainty equivalent cash flows. How would you use these cash flows in valuation?
What is your net gain or loss on this investment : You wrote ten call option contracts on JIG stock with a strike price of $41 and an option price of $.60. What is your net gain or loss on this investment if the price of JIG is $46.05 on the option expiration date?
Integer linear programming model to assist park management : Formulate and solve an integer linear programming model to assist the park’s management to plan and schedule the number of new employees it hires each week in order to minimize the total number of new employees it must hire during the summer. It may ..
Pharmacotherapy for endocrine and musculoskeletal disorders : Patients with endocrine and musculoskeletal disorders often require long-term treatment and care resulting in the need for extensive patient education. By appropriately educating patients, advanced practice nurses can assist patients with the mana..
What is the company unlevered cost of equity capital : Skillet Industries has a debt–equity ratio of 1.3. Its WACC is 7.1 percent, and its cost of debt is 6.6 percent. The corporate tax rate is 35 percent. What is the company’s unlevered cost of equity capital? What would the cost of equity be if the deb..
You work for a company that manufactures high tech : You work for a company that manufactures high tech electronic equipment. You are the project manager responsible for the development of a new type of Handset for 3G applications. The project life cycle is made up of the phases in the WBS below. Each ..
Company also has two bond issues outstanding : Dinklage Corp. has 7 million shares of common stock outstanding. The current share price is $73, and the book value per share is $8. The company also has two bond issues outstanding. Suppose the most recent dividend was $4.50 and the dividend growth ..

Reviews

Write a Review

Financial Management Questions & Answers

  Operating income and its tax rate all remain constant

The CFO of Daves Industries plans to have the company issue $300 million of a new common stock and use the proceeds to pay off some of its outstanding bonds that carry a 7% interest rate. Assume that the company, which does not pay any dividends, tak..

  Determine the modified internal rate of return for project

Determine the modified internal rate of return for a project that costs $75,000 and would yield after-tax cash flows of $12,000 the first year, $14,000 the second year, $17,000 the third year, $19,000 the fourth year, -$23,000 the fifth year, and $29..

  What is the probability range of returns

A stock had annual returns of 16 percent, 8 percent, -17 percent, and 21 percent for the past four years. Based on this information, what is the 95 percent probability range of returns for any one given year?

  Why the euros value could be expected to change

Explain how and why the euro's value could be expected to change against these currencies according to the PPP theory.

  Fair value information on crickets assets and liabilities

Horizon Communications bought all of Cricket Cable’s voting stock on January 1, 2017 for $42,000, when Cricket’s book value was $8,000. Fair value information on Cricket’s assets and liabilities at the date of acquisition is as follows: Property and ..

  Use the equivalent annual cost approach to evaluate

A company wishes to select the best of three possible computers, each expected to meet the University's growing need for computational and storage capacity. The three computers— A, B, and C—are equally risky. Calculate the NPV for each computer over ..

  Was petgo successful during its first month of operation

John Smith established an animal clinic (PetGo) on December 1, 2016, by purchasing all of its common stock for $125,000 (no par value). The same day PetGo paid $2,500 to an attorney who prepared its legal documents and filed incorporation documents (..

  Heavy use of off-balance sheet lease financing will tend to

In the lease versus buy decision, leasing is often preferable

  Bond equivalent yield is semi-annually compounded

What is the price of a T-Bond with exactly 24.5 years to maturity and coupons with rate 5.875% paid semi-annually? Its yield is 6.5% BEY (Bond Equivalent Yield is semi-annually compounded).

  Construct a pro forma income statement for the first year

Construct a pro forma income statement for the first year and second year for the assumptions - Price per unit increases to $11.50, and unit of sales increases by 5%, all other assumptions remain the same.

  Results of exchange rate changes

Early in September 1983, it took 255 Japanese yen to equal $1. Nearly 28 years later, in August 2011, that exchange rate had fallen to 115 yen to $1. Assume that the price of a Japanese-manufactured automobile was $11,000 in September 1983 and that i..

  Company achieve without having to raise funds externally

Maggie's Muffins, Inc., generated $2,000,000 in sales during 2013, and its year-end total assets were $1,400,000. Also, at year-end 2013, current liabilities were $1,000,000, consisting of $300,000 of notes payable, $500,000 of accounts payable, and ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd