Hmw10: Variance & Analysis1. Calculate the variance and variance percentages for each account2. Calculate the actual and standard in the summary of cost percentage table.3. Analyze the data below, summarize your findings, and make appropriate recommendations if necessary.Note: All of the yellow fields must be filled in.Operating BudgetActual2010Standard/BudgetedVarianceVariancePercent%$1,000,000$ 260,000###$ 200,000$ 40,000$ 240,00020%15%19%240,00018,000258,000$ 320,000$31,200$ 351,200-$80,000-$13,200-$93,200-25%-42%-27%###$ 908,800$ 333,20037%420,00018,000438,000$ 350,000$15,000$ 365,000$$$70,0003,00073,00020%20%20%$$$$$$$100,00012,0003,6001,8001,2001,44025,000###############$1,000$18,000$0.00$0.00$0.00$0.00$0.00$440.00$7,000.000%0%0%0%0%44%39%Total Other Expenses $145,040$ 137,600$658,960$ 406,200$ 252,760AccountSalesFood $ 1,200,000Beverage $300,000Total F&B Sales###Cost of SalesFood Cost $Beverage Cost $Total Cost of Sales $Gross ProfitExpensesSalaries and Wages $Employee Benefits $l Payroll and Related Expenses $Other ExpensesRentContract ServicesLaundry & Dry CleaningLicensesOperating SuppliesPhoneUtilitiesTotal Income of (Loss)FoodBeverageRentLabor$Summary of Cost PercentagesActualStandard/2010BudgetedPercentPercentCost Percent20%32%Cost Percent6%12%Cost Percent7%8%Cost Percent29%29%Analysis (Type your analysis below)7,440Variance-12%-6%-1%0%5%62%
Hmw10: Variance & Analysis1. Calculate the variance and variance percentages for each account2. Calculate the actual and standard in the summary of cost percentage table.3. Analyze the data below, summarize your findings, and make appropriate recommendations if necessary.Note: All of the yellow fields must be filled in.Operating BudgetActual2010Standard/BudgetedVarianceVariancePercent%$1,000,000$ 260,000###$ 200,000$ 40,000$ 240,00020%15%19%240,00018,000258,000$ 320,000$31,200$ 351,200-$80,000-$13,200-$93,200-25%-42%-27%###$ 908,800$ 333,20037%420,00018,000438,000$ 350,000$15,000$ 365,000$$$70,0003,00073,00020%20%20%$$$$$$$100,00012,0003,6001,8001,2001,44025,000###############$1,000$18,000$0.00$0.00$0.00$0.00$0.00$440.00$7,000.000%0%0%0%0%44%39%Total Other Expenses $145,040$ 137,600$658,960$ 406,200$ 252,760AccountSalesFood $ 1,200,000Beverage $300,000Total F&B Sales###Cost of SalesFood Cost $Beverage Cost $Total Cost of Sales $Gross ProfitExpensesSalaries and Wages $Employee Benefits $l Payroll and Related Expenses $Other ExpensesRentContract ServicesLaundry & Dry CleaningLicensesOperating SuppliesPhoneUtilitiesTotal Income of (Loss)FoodBeverageRentLabor$Summary of Cost PercentagesActualStandard/2010BudgetedPercentPercentCost Percent20%32%Cost Percent6%12%Cost Percent7%8%Cost Percent29%29%Analysis (Type your analysis below)7,440Variance-12%-6%-1%0%5%62%
Hmw10: Variance & Analysis1. Calculate the variance and variance percentages for each account2. Calculate the actual and standard in the summary of cost percentage table.3. Analyze the data below, summarize your findings, and make appropriate recommendations if necessary.Note: All of the yellow fields must be filled in.Operating BudgetActual2010Standard/BudgetedVarianceVariancePercent%$1,000,000$ 260,000###$ 200,000$ 40,000$ 240,00020%15%19%240,00018,000258,000$ 320,000$31,200$ 351,200-$80,000-$13,200-$93,200-25%-42%-27%###$ 908,800$ 333,20037%420,00018,000438,000$ 350,000$15,000$ 365,000$$$70,0003,00073,00020%20%20%$$$$$$$100,00012,0003,6001,8001,2001,44025,000###############$1,000$18,000$0.00$0.00$0.00$0.00$0.00$440.00$7,000.000%0%0%0%0%44%39%Total Other Expenses $145,040$ 137,600$658,960$ 406,200$ 252,760AccountSalesFood $ 1,200,000Beverage $300,000Total F&B Sales###Cost of SalesFood Cost $Beverage Cost $Total Cost of Sales $Gross ProfitExpensesSalaries and Wages $Employee Benefits $l Payroll and Related Expenses $Other ExpensesRentContract ServicesLaundry & Dry CleaningLicensesOperating SuppliesPhoneUtilitiesTotal Income of (Loss)FoodBeverageRentLabor$Summary of Cost PercentagesActualStandard/2010BudgetedPercentPercentCost Percent20%32%Cost Percent6%12%Cost Percent7%8%Cost Percent29%29%Analysis (Type your analysis below)7,440Variance-12%-6%-1%0%5%62%
Hmw10: Variance & Analysis1. Calculate the variance and variance percentages for each account2. Calculate the actual and standard in the summary of cost percentage table.3. Analyze the data below, summarize your findings, and make appropriate recommendations if necessary.Note: All of the yellow fields must be filled in.Operating BudgetActual2010Standard/BudgetedVarianceVariancePercent%$1,000,000$ 260,000###$ 200,000$ 40,000$ 240,00020%15%19%240,00018,000258,000$ 320,000$31,200$ 351,200-$80,000-$13,200-$93,200-25%-42%-27%###$ 908,800$ 333,20037%420,00018,000438,000$ 350,000$15,000$ 365,000$$$70,0003,00073,00020%20%20%$$$$$$$100,00012,0003,6001,8001,2001,44025,000###############$1,000$18,000$0.00$0.00$0.00$0.00$0.00$440.00$7,000.000%0%0%0%0%44%39%Total Other Expenses $145,040$ 137,600$658,960$ 406,200$ 252,760AccountSalesFood $ 1,200,000Beverage $300,000Total F&B Sales###Cost of SalesFood Cost $Beverage Cost $Total Cost of Sales $Gross ProfitExpensesSalaries and Wages $Employee Benefits $l Payroll and Related Expenses $Other ExpensesRentContract ServicesLaundry & Dry CleaningLicensesOperating SuppliesPhoneUtilitiesTotal Income of (Loss)FoodBeverageRentLabor$Summary of Cost PercentagesActualStandard/2010BudgetedPercentPercentCost Percent20%32%Cost Percent6%12%Cost Percent7%8%Cost Percent29%29%Analysis (Type your analysis below)7,440Variance-12%-6%-1%0%5%62%
