Phase-2 Build a restaurant Production/exit dashboard on google sheets. Must have advanced google sheets experience, -- 2

We want to build an interactive 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/1F4DoXp0xz9Bl4-V_CQBBe-JCo8CwhQ32fXIqOcfKceA/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

Example of a cool dashboard:
https://www.youtube.com/watch?v=bjLIA1vSqGs