50.1K

Verified Solution

Link Copied!

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 $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

Answer & Explanation Solved by verified expert

See Answer