need to do just the corrections on the wrong ones.
Task 2a Draft Sales Budget Monday Tuesday - Friday Saturday Sunday Total $ Lunch Maximum Seats 150 150 150 450 Seat Turnover 65% 95% 120% 2.8 Number of Days 19 4 4 27 Average Spend $35 $35 $35 105 Revenue $64,838 $19,950 $25,200 $109,988 Dinner Maximum Seats 150 150 150 150 600 Seat Turnover 70% 70% 90% 60% 2.8 Number of Days 4 19 4 4 31 Average Spend $55 $55 $55 $55 220 Revenue $23,100 $109,725 $29,700 $19,800 $182,325 Total Food Revenue 63% $184,157 Total Beverage Revenue 37% $108,156 Total $292,313 Task 2b Draft COGS Budget % of Total Revenue Total $ Food COGS 32% $58,930 Beverage COGS 25% $27,039 Total COGS $85,969 1.1 1.2 Task 2c Draft Wages Budget Permanent Staff Annual Salary $ Monthly Salary $ No. of Staff Total Monthly Salaries $ Super. 9.5% Workers Comp. 4% Total Labour Cost $ Head Chef -$ 90,000- -$ 7,500- 1 -$ 7,500- -$ 713- -$ 300- -$ 8,513- Chef de partie -$ 60,000- -$ 5,000- 1 -$ 5,000- -$ 475- -$ 200- -$ 5,675- Commis Chef -$ 45,000- -$ 3,750- 3 -$ 11,250- -$ 1,069- -$ 450- -$ 12,769- Apprentice -$ 26,000- -$ 2,167- 2 -$ 4,333- -$ 412- -$ 173- -$ 4,918- Head waiter -$ 32,000- -$ 2,667- 2 -$ 5,333- -$ 507- -$ 213- -$ 6,053- Total 253,000 -$ 21,083- 9 -$ 33,417- -$ 3,175- -$ 1,337- -$ 37,928- Casual Staff Rate per Hour $ No. of Staff Weekly Rostered Hours per Staff Total Weekly Hours Total Monthly Hours Total Weekly Wages $ Super. 9.5% Workers Comp. 4% Total Labour Cost $ Kitchen Hand -$ 21.00- 2 18 36 - 144- -$ 3,024- -$ 287- -$ 121- -$ 3,432- Wait Staff -$ 26.50- 6 24 144 - 576- -$ 15,264- -$ 1,450- -$ 611- -$ 17,325- Bar Staff -$ 24.00- 4 18 72 - 288- -$ 6,912- -$ 657- -$ 276- -$ 7,845- Total -$ 71.50- 12 60 252 - 1,008- -$ 25,200- -$ 2,394- -$ 1,008- -$ 28,602- Draft Expenses Budget Total Revenue -$ 400,468- Fixed $ Per Month Rent -$ 14,000- Telephone/internet -$ 250- Insurance -$ 1,800- Electicity -$ 900- Variable % Marketing 3% -$ 8,769- Bad debts 1% - 2,923.13- Other 8% -$ 23,385- -$ 52,028- 3.1 Task 2e Draft Profit and Loss Budget The Restaurant Month of July 20XX Sale Draft Budget $ Revenue $ Food -$ 184,157- Beverage -$ 108,156- Total Revenue -$ 292,313- COGS COGS - Food -$ 58,930- COGS - Beverage -$ 27,039- Total COGs -$ 85,969- Gross Profit -$ 206,343- Expenses Wages – Permanent -$ 37,928- Wages - Casual -$ 27,039- Rent -$ 14,000- Telephone & internet -$ 250- Insurance -$ 1,800- Electricity -$ 900- Marketing -$ 8,769- Bad debts -$ 2,923- Other -$ 23,385- Total Expenses -$ 116,994- Operating Profit -$ 89,349- Operating Profit Margin 30.6% 4.1 Task 4a Final Sales Budget Monday Tuesday - Friday Saturday Sunday Total $ Lunch Maximum Seats 150 150 150 Seat Turnover 67% 97% 122% Number of Days 19 4 4 Average Spend $37 $37 $37 Revenue $70,652 $21,534 $27,084 $119,270 Dinner Maximum Seats 150 150 150 150 Seat Turnover 72% 72% 92% 62% Number of Days 4 19 4 4 Average Spend $57 $57 $57 $57 Revenue $24,624 $116,964 $31,464 $21,204 $194,256 Total Food Revenue 63% $197,521 Total Beverage Revenue 37% $116,004 Total $313,526 Task 4b Final COGS Budget % of Total Revenue Total $ Food COGS 24% #REF! Beverage COGS 23% $26,681 Total COGS #REF! 5.1 5.2 Task 4c Final Profit and Loss Budget The Restaurant Month of July 20XX Sales Final Budget $ Revenue $ Food -$ 197,521- Beverage -$ 116,004- Total Revenue -$ 313,526- COGS COGS - Food #REF! COGS - Beverage -$ 26,681-