Question: Build a budget for one year. Use Excel to create the budget; include all direct and indirect costs for expenses. Include all revenue from sales.

Build a budget for one year. Use Excel to create

Build a budget for one year. Use Excel to create

Build a budget for one year. Use Excel to create the budget; include all direct and indirect costs for expenses. Include all revenue from sales. Have totals for your expenses (direct and indirect) 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 one person for 30 hours per week as a cook/server. They receive minimum wage, which is $9.00 per hour. 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, order, 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 three types of tacos (one vegetarian); beans and rice. You offer a variety of canned soft drinks. You serve 200 tacos a day. Each taco is $2.50. You sell 100 soft drinks a day. Soft drinks are $2.00. -You are at the CNM campus four days a week for 45 weeks per year. - You travel once every month to Santa Fe to pick up a specialty can drinks only available at that outlet. Upload your budget as an Excel attachment. Consider using color and design to make the budget more readable. And...did you make any money

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!