Phase-2 Build a restaurant Production/exit dashboard on google sheets.

We want to build a calculation/dashboard where we can input order information (for example) headcount of people ordering, protein selections and it will calculate according to our formulas a combined number of proteins, starches:( rice, breads, etc...), drinks etc.. according to the portions we have set. Ideal there should be three sheets:
- Housespread calculation sheet
- Lunchboxes calculation sheet ( need to come up with random distribution formula)
- Combined dashboard (a better version of the gameplan that is built by hand)

reports it will yield:
- Kitchen prep list
- Combined assembly table
- Individual order driver-checklist

This is specifically for the restaurant industry so prior industry knowledge will be helpful.

The links below are for the calculator we currently use and the report/gameplan we build manually.

https://docs.google.com/spreadsheets/d/1-7M4N-_vberpY_xJo150pV4K3wMAAfBx2L3HAv6vAwU/edit?usp=sharing

examples of the gameplan we make manually:
https://docs.google.com/document/d/1HWzhGMo8I-YCaJNFeV0bQLuaFOyrs5tA3J6isqYs97A/edit?usp=sharing

https://docs.google.com/document/d/1K3AIhZqavP8pDjVKc7ZaNcQzOfHK-Uk7RUI5gP2D-g8/edit?usp=sharing