answer the following questions in 4-5 excel sheets

NOTE – PLEASE FOLLOW ALL THE INSTRUCTIONS AND GIVE A PROPER BREAKDOWN OF EACH SORT OF COST THAT IS USED

Include all the variable,fixed,indirect and direct costs in detail in order to run a food truck in New york city that sells coffee. Write about the different types of food truck related costs too and divide them up as per product or period costs. Write the per cup cost of all the items as well. Include things such as parking permits, inspections etc. It has to be on excel.

1. Account for fluctuations due to location, seasonality, etc.
2. Include a detailed work schedule for employees, depreciation schedules
3.Budget 30% for employer taxes & benefits for full-time employees, 20% for part-time employees
4.All staff must be paid minimum wage for the state where the business resides Overtime must be paid as dictated by state law. Salaried compensation is permitted
5.Payroll can be paid every other week or 2x per month (the calculations are different). Budget $50 per payroll run for processing
6. Include links to major purchases
7.If the business accepts credit cards, the processing fee is 2%
8.All startup costs must be financed at 8% for 12 months
9. Capital expenditures are financed at 12%, with varied terms. Food trucks should be financed for 5 years.
10.Do not finance purchases under $200 (capitalization threshold/policy)
11. The venture can be seasonal. However, the plan is for a full calendar year, and fixed expenses need to be paid for the entire year
12.write recipes used for the following products as it is a mushroom/chaga coffee.

Weekly basis

Chaga Cold Brew 180 drinks/ week
Chaga Matcha 90 drinks/ week
Chaga Chai 90 drinks/ week
Total 540 drinks/ week