Schedule Productivity Formula in Excel

This project was awarded to vw747117 for $195.5 USD.

Get free quotes for a project like this
Project Budget
$100 - $230 USD
Total Bids
Project Description

I need a formula that will generate a standard schedule based on the forecasted hourly covers, per meal period. Assumptions, No employee can work more that 7.5 hours, Several employees are identified as Part-time, working 4 hours per shift for each category.

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.

Attached is a Workbook with Worksheets named Empl_Roster, Staff_Guide_Chart, Drm_Cvrs_Per_HR, and Drm_Schedule. The Staff Guide needs to be adjusted from time to time as the tasks change for various reasons. This is where the User will change the Number of Customers Per Hour. The User will manually enter Hourly Rate on Dining Room Schedule, Hours of Operation, Actual Hours. Ideally, the algorithm should fill the schedule for the Standard Hours using Employees by Position.

We can discuss the workflow and logic and how the data will be used.

Let me know if you have any questions. How much your bid is and How long for completion.



## Deliverables

1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).

## Platform

The application should function on all existing Windows platforms, XP/Vista/7 and the ability to be intergrated in Delphi software application by the Buyer or his representatives.

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online