Finding optimal restaurant server sections?

rman893

New Member
Joined
Oct 27, 2020
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
I'm a restaurant manager with intermediate Excel skills. I'm trying to use Excel to find the optimal daily server floor charts with certain parameters: the tables need to be somewhat close together, each server should have a maximum of three tables and a minimum of two, and the number of customers at a table needs to be somewhat balanced. I put together a crude blueprint of the restaurant (first screenshot) that provides the table names and it shows the basic distance between tables. The second screenshot is in a different sheet with the table names replaced by the number of customers that can fit at the table. The third sheet is the daily roster with servers' names on there--in column B there are skill levels for each of them (ranging from 1 to 7), which could theoretically affect how much they can handle (I'd like someone with a higher skill level to get priority treatment when it comes to having three tables vs. two, for instance). Since the number of servers varies each day (and they have different skill levels), I'd like to be able to paste my roster into one sheet and then have a list of those servers appear in another sheet with the optimal section next to their names.

Basically, I don't know where to start this project. I've done a little bit of reading and I think I'll need to use Solver. But if anyone can point me in the direction of what I should start reading in order to accomplish this (if it's even possible!), I'd be really grateful.

19B1483F-662A-402B-9229-45DF5C70E51D.jpeg

033BBA8A-8019-4911-A3DF-0A3837F93AF4.jpeg

0EA481EA-067F-4BC2-9024-04F06F66F53D.jpeg
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top