Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Ben Hoyle, Thomas Schaefer, Timothy Doupnik

11th edition

78025400, 978-0078025402

More Books

Students also viewed these Accounting questions

Question

Bonus shares can be issued out of revenue reserves. True/False?

Answered: 1 week ago