The last time I posted this question, the answers were wrong, as the person copy pasted from a an aleeady uploaded document with different numbers.
Enable Home Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View AI Ohin und wames Month Ending Mwy 2021 Month Ending hune, 2021 Month Inding 2021 Mshing February 2010 HD 38.000 16.000 10 LODO Town ON 41.100 240 ON 40 Total 30.GO 62.040 GON 11.910 12 16 4N 15.568 155 115 1.030 IN on AS ON 100 ON 28.0LYNN Sheet Type here to search o Premise: After a stellar February performance, your Chix and Waffles food truck sat in the garage for the duration of the lockdown. You will slowly re-start your business on May 16 and plan on increasing volume by June and July but still not at February levels. In February, you did 550 covers/day at an average of $8/plate. You operated the truck or weekdays at a FiDi location (5 days/wk) and did special events one day per weekend, 250 covers each at $15/plate. Assumptions: I 1. For the second half of May, only 1/3 of the February daily covers will be achievable. No special events are anticipated. 2. The operation had 4 employees: Chef/owner at an annual salary of $45,000 (that's you), 3 cooks/assistants at $17/hr and 40 hrs/wk 3. In May, only you, the chef and an assistant will re-start. Another cook will be added in June and by July, you will be staffed at pre-pandemic levels. 4. The truck is fully depreciated. 5. Food cost is anticipated to be at 45% in May and 42% for the months of June and July. This is attributed to the Increase in prices across the board. 6. Special events will be resumed in July. 7. Conservative forecast for May sales is 1/3 of February daily covers. June sales will be at 75% of February. July daily sales will be at February levels. 8. Paper supplies/disposables are budgeted at $1/cover. 9. Cleaning supplies may rise .5% due to more stringent sanitizing protocols. 10. Laundry is peeged at $2.75/day per employee. 11. Employee benefits are at 24% of salaries and wages + $140/mo per employee for Health Insurance and employee meals at $2.50 a day per employee. 12. Licenses and Miscellaneous Expenses are fixed. Enable Home Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View AI Ohin und wames Month Ending Mwy 2021 Month Ending hune, 2021 Month Inding 2021 Mshing February 2010 HD 38.000 16.000 10 LODO Town ON 41.100 240 ON 40 Total 30.GO 62.040 GON 11.910 12 16 4N 15.568 155 115 1.030 IN on AS ON 100 ON 28.0LYNN Sheet Type here to search o Premise: After a stellar February performance, your Chix and Waffles food truck sat in the garage for the duration of the lockdown. You will slowly re-start your business on May 16 and plan on increasing volume by June and July but still not at February levels. In February, you did 550 covers/day at an average of $8/plate. You operated the truck or weekdays at a FiDi location (5 days/wk) and did special events one day per weekend, 250 covers each at $15/plate. Assumptions: I 1. For the second half of May, only 1/3 of the February daily covers will be achievable. No special events are anticipated. 2. The operation had 4 employees: Chef/owner at an annual salary of $45,000 (that's you), 3 cooks/assistants at $17/hr and 40 hrs/wk 3. In May, only you, the chef and an assistant will re-start. Another cook will be added in June and by July, you will be staffed at pre-pandemic levels. 4. The truck is fully depreciated. 5. Food cost is anticipated to be at 45% in May and 42% for the months of June and July. This is attributed to the Increase in prices across the board. 6. Special events will be resumed in July. 7. Conservative forecast for May sales is 1/3 of February daily covers. June sales will be at 75% of February. July daily sales will be at February levels. 8. Paper supplies/disposables are budgeted at $1/cover. 9. Cleaning supplies may rise .5% due to more stringent sanitizing protocols. 10. Laundry is peeged at $2.75/day per employee. 11. Employee benefits are at 24% of salaries and wages + $140/mo per employee for Health Insurance and employee meals at $2.50 a day per employee. 12. Licenses and Miscellaneous Expenses are fixed
