Impact of Deploying
Labor Planning at
Hi-Tech
04:00 pm– 04:30 pm
Presenter:
Michael Gurick
(Hi-Tech)
Background
• Hi-Tech has been in business for 20 Years
• Go Live Date – JULY 2003
• 3 Sites
• Atlanta
• Orlando
• Las Vegas
• Labor Module Go Live – January 2007
Operations Structure
• Warehouse Operations
• Show Operations
• Order Scrubbing
• Labor Resource Fulfillment
– Labor Coordinator per Site
• Internal & External Labor
Prior to Labor Module
• Excel Database – Resource List
– Contact Information
– Business License / Insurance
– Skill Set / Level
– Rate per Position
• Excel Template – Call Sheet
Challenges with Excel
• Creation of Excel templates cumbersome
• Large opportunity for Error
• Disconnect from Resource Database & R2
• No solid way to track Resource availability
• Waste of Paper
• Multiple Locations – No Central Database
– Sharing Information a Problem
The Benefits
• Pre Show Benefits
– Centralized Database – Increased Efficiency
– Multiple Coordinators can look at one location,
order at the same time
– Filter Capability
• City
• Position
• Rate
• Rank
– Resource Availability very easy to determine
– Job History easy to obtain
• Same Crew
• Job performance
– Multiple Rates for a Resource (Per Skill set)
The Benefits
• Post Show Benefits
– Contract Labor verification
much easier
– Travel costs captured with
each job
– Profitability Reports
– Labor Accruals for unbilled
Labor easy to generate
Pre Show Procedure
• Search By Date Range For Unfilled
Orders (Example)
• Place Full Time Staff First
• Search by Position using Database
• Confirm and Assign the Resource
Electronically
– Non-availability is noted in the
Resource Profile
• Once Labor is completely booked:
– Call Sheet printed and sent to show
site with P.M.
• Travel Cost entered in to UDF’s.
Post Show
• Labor Logs are returned from show
completed and signed off by the Project
Manager.
• Any onsite labor additions are placed
into Labor Module by Show Operations.
• Information forwarded to Accounting for
Invoicing.
• Billing Coordinator enters Actual
hours/Travel Expenses.
• B.C. prints “Labor Schedule by Order”
– Used to verify Labor Billing is complete
and accurate
– Used to verify Margin meets Hi-Tech goal
(Example).
Post Show - Continued
• Travel Report printed and used to
verify accuracy.
• Accounts Payable:
– Verification of Labor Invoices against
actual hours entered
– AP Coordinator notates lines
completed with Payment Date (Show
Example)
– Month End Accruals generated for
Accounting based on this
information.
Business Requirements
• Rate Improvement
• Actual Hours - should be stored
• Contract Description – a
Searchable Field
• “Labor Requirements” tab should
include “Headers” and
“Comments” from Account
Module.
• Subtotal on Labor Order.
• Default Status for new Resources
– similar to New Customer Set Up.
Closing Remarks
Q&A
Thank You!