Question
You have a food truck and sell tacos. Build a budget for 1 year. Use Excel to create the budget; include all direct and indirect
You have a food truck and sell tacos.
Build a budget for 1 year. Use Excel to create the budget; include all direct and indirect costs for expenses. Include all revenue of sales. Create a special section in the budget for the direct costs associated with Tacos for Teachers. Have totals for your expenses (direct and indirect), Tacos for Teachers (direct) and revenue. Did you make any money this year?
Some considerations:
You owe $450 per month on your loan from Bank of America for the food truck.
CNM lets you park for free (worth $50 per month) and pays your electricity ($150 per month). These are in-kind contributions.
You pay $75 per month on a rental space to park your food truck at night.
You employ 1 person for 30 hours per week as a cook/server. They receive minimum wage. You must add 25% for taxes, unemployment, etc.
You work for 60 hours a week. 40 hours a week you work in the food truck. 20 hours a week you do paperwork, ordering, pay bills, and manage your employee. You pay yourself for 40 hours a week as a cook/server. You also receive minimum wage. You must add 25% for taxes, unemployment, etc.
You pay a bookkeeper $75 per month.
Your regular menu includes 3 types of tacos (1 vegetarian); beans and rice. You offer a variety of canned soft drinks. You serve 200 tacos a day Each taco is $2.50. Soft drinks are $2.00.
You are at the campus 4 days a week for 45 weeks per year.
You travel once every month to Santa Fe to pick up a specialty can drink only available at that outlet.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started