Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need a toutor to correct my work/ help with changes. TOTAL=55,180 .20$11,036 10.Direct Operating expenses are $6200.00 per month 11. Gas and Electric are

I need a toutor to correct my work/ help with changes. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
TOTAL=55,180 .20$11,036 10.Direct Operating expenses are $6200.00 per month 11. Gas and Electric are $700.00 per month 12. Linen expenses are 2% of sales 13.Janitorial expenses are $175.00 per day 14. Repairs are 1% of sales 15. Rent is $5,000.00 per month 16. Depreciation is $840,00 per year 17. Advertising is 3% of sales 18. Insurance is $50,000.00 per year \begin{tabular}{|c|c|c|} \hline LABOR & x & x \\ \hline Management Salary & $65,000 & 6.2% \\ \hline Regular Payroll & $1,946,856 & \\ \hline & $ & + \\ \hline & $455,313 & 1.45% \\ \hline Unemployment Compensation Ins. & $251,279 & .8% \\ \hline Workers Compensation Ins. & +2 & 2.01% \\ \hline TOTAL LABOR EXPENSES & & - \\ \hline PRIME COSTS & 58 & +8 \\ \hline & x & x \\ \hline \( \begin{array}{l}\text { CONTROLL_ABLE AND } \\ \text { NON-CONTROLLABLE EXPENSES }\end{array} \) & x & x \\ \hline Direct Operating $6,200 a month & $74,400 & + \\ \hline Gas/Electric $700 a month & $8,400 & \\ \hline Linen 2% of sales & $523 & 2% \\ \hline Janitorial \$175 a day & $63,875 & \\ \hline Repairs 1% of sales & $262 & 1% \\ \hline Rent $5,000 per month & 560,000 & \\ \hline Depreciation & $840 & \\ \hline Advertising & $785 & 3% \\ \hline Insurance & $50,000.00 & \\ \hline TOTAL CONTROLLABLE AND & $259,085 & 100% \\ \hline NON-CONTROLLABBLE EXPENSES & 6 & \\ \hline & x & \\ \hline & x & x \\ \hline & & \\ \hline \end{tabular} PROFIT and LOSS (35pts.) Total Year Labor Hours =32,920 Total Weekly Labor Hours Avg =37.5 DINING ROOM: Calculate Food sales and Beverage sales based on (21pts.): 1. Number of available days for dining 2. Dining room seats 50 people a. Average 1 seating at lunch =50 b. Average 2 seating's at dinner =100 3. Check average is: a. $15,00 at lunch ( food =90% beverage =10% of sales) i. $750= total sales SALES INFORMATION DINING ROOM: Calculate Food sales and Beverage sales based on (21pts.): 1. Number of available days for dining 2. Dining room seats 50 people a. Average 1 seating at lunch =50 DIRECTIONS: Please use the following directions to complete the budget project. Placepll of the figures in the Year / BUDGET and \% column of the P/L. Round the cents up or down to whole dollars. Calculate the percent's for each category. Sales/Income: 1. Determine Catering Food and Beverage sales for the year. 2. Determine the Dining Room Food and Beverage sales for the year. 3. Total the sales income for the year. Food and Beverage Expenses: 1. Determine the expenses in each food category and beverages. 2. Determine total food and beverage expenses. Labor Expenses: 1. Complete the Manning Table: a. Hours per year b. Yearly compensation c. Do totals at bottom of the page 2. Determine regular payroll. 3. Determine total taxes for each category. 4. Determine total labor expenses. Prime Costs Expenses General Fxpenses: 1. Determine each of the general expense categories as listed on the facts sheet. 2. Determine total general expenses. Anticipated Food Costs: Anticipated Beverages Selected and Costs: General Expenses: 1. Direct Operating expenses are $6200.00 per month 2. Gas and Electric are $700.00 per month 3. Linen expenses are 2% of sales 4. Janitorial expenses are $175.00 per day 5. Repairs are 1% of sales 6. Rent is $5,000.00 per month 7. Depreciation is $840.00 per year 8. Advertising is 3% of sales 9. Insurance is $50,000.00 per year TOTAL=55,180 .20$11,036 10.Direct Operating expenses are $6200.00 per month 11. Gas and Electric are $700.00 per month 12. Linen expenses are 2% of sales 13.Janitorial expenses are $175.00 per day 14. Repairs are 1% of sales 15. Rent is $5,000.00 per month 16. Depreciation is $840,00 per year 17. Advertising is 3% of sales 18. Insurance is $50,000.00 per year \begin{tabular}{|c|c|c|} \hline LABOR & x & x \\ \hline Management Salary & $65,000 & 6.2% \\ \hline Regular Payroll & $1,946,856 & \\ \hline & $ & + \\ \hline & $455,313 & 1.45% \\ \hline Unemployment Compensation Ins. & $251,279 & .8% \\ \hline Workers Compensation Ins. & +2 & 2.01% \\ \hline TOTAL LABOR EXPENSES & & - \\ \hline PRIME COSTS & 58 & +8 \\ \hline & x & x \\ \hline \( \begin{array}{l}\text { CONTROLL_ABLE AND } \\ \text { NON-CONTROLLABLE EXPENSES }\end{array} \) & x & x \\ \hline Direct Operating $6,200 a month & $74,400 & + \\ \hline Gas/Electric $700 a month & $8,400 & \\ \hline Linen 2% of sales & $523 & 2% \\ \hline Janitorial \$175 a day & $63,875 & \\ \hline Repairs 1% of sales & $262 & 1% \\ \hline Rent $5,000 per month & 560,000 & \\ \hline Depreciation & $840 & \\ \hline Advertising & $785 & 3% \\ \hline Insurance & $50,000.00 & \\ \hline TOTAL CONTROLLABLE AND & $259,085 & 100% \\ \hline NON-CONTROLLABBLE EXPENSES & 6 & \\ \hline & x & \\ \hline & x & x \\ \hline & & \\ \hline \end{tabular} PROFIT and LOSS (35pts.) Total Year Labor Hours =32,920 Total Weekly Labor Hours Avg =37.5 DINING ROOM: Calculate Food sales and Beverage sales based on (21pts.): 1. Number of available days for dining 2. Dining room seats 50 people a. Average 1 seating at lunch =50 b. Average 2 seating's at dinner =100 3. Check average is: a. $15,00 at lunch ( food =90% beverage =10% of sales) i. $750= total sales SALES INFORMATION DINING ROOM: Calculate Food sales and Beverage sales based on (21pts.): 1. Number of available days for dining 2. Dining room seats 50 people a. Average 1 seating at lunch =50 DIRECTIONS: Please use the following directions to complete the budget project. Placepll of the figures in the Year / BUDGET and \% column of the P/L. Round the cents up or down to whole dollars. Calculate the percent's for each category. Sales/Income: 1. Determine Catering Food and Beverage sales for the year. 2. Determine the Dining Room Food and Beverage sales for the year. 3. Total the sales income for the year. Food and Beverage Expenses: 1. Determine the expenses in each food category and beverages. 2. Determine total food and beverage expenses. Labor Expenses: 1. Complete the Manning Table: a. Hours per year b. Yearly compensation c. Do totals at bottom of the page 2. Determine regular payroll. 3. Determine total taxes for each category. 4. Determine total labor expenses. Prime Costs Expenses General Fxpenses: 1. Determine each of the general expense categories as listed on the facts sheet. 2. Determine total general expenses. Anticipated Food Costs: Anticipated Beverages Selected and Costs: General Expenses: 1. Direct Operating expenses are $6200.00 per month 2. Gas and Electric are $700.00 per month 3. Linen expenses are 2% of sales 4. Janitorial expenses are $175.00 per day 5. Repairs are 1% of sales 6. Rent is $5,000.00 per month 7. Depreciation is $840.00 per year 8. Advertising is 3% of sales 9. Insurance is $50,000.00 per year

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started