v3.0 - Lots of Changes & Refinements
Because of the massive overhaul of this sheet, a new one was created. Here is the link to the v3.0 sheet: https://docs.google.com/spreadsheets/d/1psBl0IG6LSXII8Jdse3gBICNWnIbLRMloiqHptOWD3g/edit?usp=sharing
What's Changed?
The main "Products" sheet:
- Batch Products & Product have been combined into one sheet. So the "Qty on Plate" must at least be "1" Otherwise you will get errors.
- Large Multiplier was removed
- Item Profit & %Profit Columns were added to help you determine individual item profit (not just the entire plate) and then the % profit to make sure you are making money
- %Profit Column has conditional coloring that you can change, but 100%+ is dark green, 70-99% is green, 21-69% is yellow & under 20% is red.
- After Commission column was removed. Was told it wasn't used. 🤷♀️
The "Settings" Sheet
- Larger Multiplier removed to match the Products Sheet
- Commission Fee removed to march Products Sheet
- Column titles were renamed for clarification
- Labor Cost/Hr added will be used in a future update