In Progress

Schedule Productivity Formula in Excel

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.

Thanks,

JoeV

## 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.

Skills: Statistics

See more: productivity formula excel, where to hire employees, we cook your dinner, the daily meal, statistics problem, statistics algorithm, staff requirement, restaurant staff requirement, reasons to hire me, problem statistics, problem of statistics, problem in statistics, problem and statistics, logic algorithm, i need part time worker, how to hire employees, how to hire employee, how to hire a part time employee, how to hire a new employee, how to hire a employee, hire person per hour, hire a cook, excel hourly rate, delphi a rate, cook for hire

About the Employer:
( 25 reviews ) United States

Project ID: #3633924

Awarded to:

vw747117

See private message.

$195.5 USD in 10 days
(1 Review)
2.6

5 freelancers are bidding on average $141 for this job

ionutleonte

See private message.

$195.5 USD in 10 days
(1 Review)
1.3
MariusRO

See private message.

$84.15 USD in 10 days
(0 Reviews)
0.0
pharaox

See private message.

$59.5 USD in 10 days
(0 Reviews)
0.0
LogixSmith

See private message.

$170 USD in 10 days
(0 Reviews)
0.0