Search for project
More than 2000 projects issued through our platform and this
amount increases very fast.
Excel -Macro (ID:6607)
| Project Creator: |
joev
FC Member For 6044 Days
Credits 20 Completed Proj. Num. 0 / 3 Total payment USD 0.00 Avg Daily Online 0.00 h (From 21/5/2007) Available on MSN/Skype No Last Login 8/5/2010 Peers Rating 0.00% 
|
|---|---|
| Budget: | Not Sure/Confidential |
| Created: | 8/4/2010 10:39:53 PM EST |
| Bidding Ends: | 8/7/2010 10:39:53 PM EST ( Expired ) |
| Development Cycle: | 3 Days |
| Bid Count: | 2
|
| Average Bid: | 900.00 |
| Project Description:
We need a formula that will generate a standard schedule based on the forecasted hourly covers, per meal period. No employee can work more that 7.5 hours. Several need to be identified as Part-time, working 4 hours per shift for each category of employee as mentioned above. The problem is related to scheduling and productivity. The Assumption is that one Server (waitperson) can sufficiently serve 10 customers per hour. A Busser 20 customers per hour, A cook 15 per hour and dishwasher 25 customers per hour, Expediter, etc using a Sunday thru Saturday schedule with daily hours from 5:00 AM to 11:00 PM with customers coming in at various times for breakfast, lunch and dinner. The Standard should have the ability to be changed which would automatically reflect in a new schedule. The goal is to create a Standards Based work schedule based on average number of customers to the restaurant per hour using the Standard of X for how many customers one worker can service per hour. Specifically, the requirement is to calculate the standard hours per person for a restaurant meal periods, Breakfast Lunch and Dinner with the assumption the restaurant is open 7 days a week. The data should automatically generate a weekly schedule. I can provide Employee Roster, Estimated Covers Per Hour, a Schedule, the Staffing Chart (which will allow the user to edit the Number of Covers Per Hour. |
|
| Job Type | Other |
| Attached Files: | 20100804223939.zip |
