1 / 20

Employee Network for Monterey Pines Golf Course

Employee Network for Monterey Pines Golf Course. LT William Bickel Capt Stephen Lantz. “ Golf is a game which you yell “Fore!”, shoot six, and write down five.” American radio broadcaster, Paul Harvey. Agenda. Problem Back-story Model Assumptions Data Network Description

alyssa
Download Presentation

Employee Network for Monterey Pines Golf Course

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Employee Network for Monterey Pines Golf Course LT William Bickel Capt Stephen Lantz

  2. “ Golf is a game which you yell “Fore!”, shoot six, and write down five.” • American radio broadcaster, Paul Harvey

  3. Agenda • Problem • Back-story • Model Assumptions • Data • Network Description • Building the model • Implementing the model • Analysis • Model Expansion/Utilization • Summary/Conclusion

  4. Problem • It’s not unfamiliar that with the changing times, everyone is trying to save money by cutting cost. • As shown by budget cuts and sequestration a big hit is being taken by MWR, and all associated programs within the MWR. • Monterey Pines, not feeling quite the pinch in the reduction of funds, still must compete with local courses that far exceed most amenities like a golf course like Monterey Pines can offer. • Optimization of some aspect of course in order to reduce the costs associated with the day to day operations. • Specific data provided limited us to explore the optimization of employee hours and the weekly tasks that must be performed.

  5. Back-Story • 1963 - Monterey Pines Golf Course originally designed by Robert Muir Graves as a 9-hole facility. • 1972 - Redesigned slightly, back-nine was added • 2006 – Current General Manager takes over course operations • 2009 - Latest redesign by golf architect Marc Messier, course layout changed, pro-shop and grill improvements • Present – Continue operations providing a quality golfing experience to civilian and military personnel of all ability levels at an affordable rate.

  6. Back-Story(Organization Breakdown) MWR Quality of Life Director MWR Function Monterey Pines General Manager MWR Function MWR Function Monterey Pines Asst GM Monterey Pines Grill Manager RV Park Manager Monterey Pines Course Maintenance Manager 16 Employees 2 Grill Employees Course Maintenance Asst Manager 8 Employees

  7. Model(Disclaimer/Assumptions) • All data provided from GM and 3 department managers (Grill, Maintenance, and RV Park) • Hours associated with each task were estimated • Pulls down model accuracy • Not all tasks were quantifiable • Every employee must work at least one day (8 hrs) per wk • Managers required to work 40 hrs per wk • Managers must be there to manage! • Not a tool for a specific employee schedule • Model provides total hrs an employee can work while still fulfilling weekly obligations

  8. Data(Employees) • 32 Total • 4 Managers • GM • Maintenance • Grill • RV Park • 2 Asst. Managers • AGM • AMM • 16 Pro-Shop Employees • 6 Front desk workers • 2 Grill Employees • 8 Maintenance Personnel • Mechanic • Irrigation Technician (“Water Boy”) Hrs/WkHrly Wage 40 $40.00 40 $30.00 40 $18.00 40 $18.00 40 $40.00 40 $25.00 30 $12.50 30 $12.78 30 $12.50 30 $19.00 30 $19.00

  9. Data(Weekly Tasks) • 29 Total • Front Desk • Starter • Marshall • Range • Carts • Mowing Greens • Mowing Fairways • Mowing Tee Boxes • Mowing Rough • Raking Bunkers • Food Preparation • Cashier • Cook • Bar • Machine Maintenance/Repair • RV Park Oversight Hrs/Wk to Perform 94.5 48 48 21 20 18 18 18 72 16 14 84 84 21 15 40

  10. Network Description • Bipartite Min-Cost Flow • Left-Hand Side: Employee (i) • Right-Hand Side: Required Task (j) • 61 Total Nodes • 219 Edges • An edge from i to j only if Employee (i) can perform task (j) • Supply on each node i • Max number of hrs an employee can work per wk • Demand on each node j: • Hourly estimation to perform each task per wk

  11. Building The Model Arcs (i,j) Cost(i,j) Employee (i) Task (j) Food Prep Grill Mgr 14 - 40 Cashier Grill Emp 24 - 30 Cook 24 Bar 14

  12. Building The Model GAMS • Min_cost_flow_sample • Started out Ambitious with CSV files • Restarted Small With The Grill • First Run Was Infeasible • Added Code To The Program: SUM(arcs(i,j),( arcdata(i,j,'Priority') *Y(i,j)) MINHOURS(i).. SUM(arcs(i,j), Y(i,j)) =g=nodedata(i,'MinHours')

  13. Analysis of Results

  14. Analysis of Results

  15. Analysis of Results

  16. Model ExpansionUtilization • Model is designed to fit not just any golf course, but any worker-job scenario • With more time we can first better quantify the hours required for jobs but also include more costs of the course for more granularity (Benefits, Utilities, etc.) • Survey other golfers to provide direction of analysis • Add in the revenues for the Grill, Range and RV park to see if they make money and should not be closed to cut costs

  17. Summary and Conclusion • Model provides input as to where cuts could and maybe should be made if budget cuts were to come down • The largest savings (Starter/Marshall) is probably the least recommended • Always start small!! • We need to go. Tee time is at 10

  18. Questions ?

More Related