Yton wes Income werend WMALE ONLY Food & Barsales Food wales Bars Totd F&B sales 78935.10 450.00 68.565.05 35 78 540 S 22004024 S 1.24150 Cool Food only January February February Consumo March-05 Consumption March Yton January-os Consumption 20 Yton Cost Total sales Food Groene 15170 MEGI 15777 OBS US 15771931 UBUYU 33.67% on Hoe 26.77 2300 LEA 50 US R125 77,5655 087 2000 DO 2125 75,5555 28 5.770.38 0.94% 097 . ale contre months Bed Cont At Rebels Mrs Credits adjustments 26217.11 2.30.12 33.72 39 015 30% 22.498. 2.150.22 666 67 2351642 2.160.12 32 3 15% Totud food cout 2002 . 20.220 30 29.50 21720.30 20. 8.779.50 2. 26. Bar cool (Beer Liquor 35.5 TAS $ 52415.01 120.25 53.6.20 628% 543095.14 1.5 1745 543% 5 40.840.64 68.5 553150 1458 25 68.9% $ 5677134 875 15.524 1313 607% $ 10.2724 Gross Margin on sales All COGS) Lotorevenue Total income Wiego Benefits 15.5% dl wages Total lour costs ICEPAND COCOS SUEQUR 1758% 1724.00 2.68.00 19.77.00 3.22 1501250 2325.00 173370 17,100.00 285000 19750.00 20 48% 4.33150 3.175 S 7.663.00 S. 2077% 2. 3337 BENS 4208 35 53% Occupancy costs Rent Mortgage Utilities Propane Insurance Total Occupancy cout 4208 35 58025 3.217.00 345.00 5.04% 0.00% 3.8% 5. 0. 58% OS 3.5% 420835 580.00 3170.75 34500 01.10 283.0 346.00 8.020.55 12.505 1.7035 9.2385 1.00500 21.64.25 0.es 11.10% 0.11 32 2.864.70 32% 2.054.70 1.205.10 15.25 323 2.15 024 8,08410 3,86620 0.1% 0.8% 0. 07 3.0 10% 1.275.00 200470 1.505.70 14875 560.45 235020 BODO 100150 18500 124200 23445 25025 1280 550.60 22170 870 20 3.00 1.540.00 123.00 321.00 220.0 690.00 02% 0.8% 3.1% 124 13% 2.15 17% 0.4% 0.3% 70450 2.620.72 3.36 50 5.4250 3.73516 14 Operating Expenses Management salaries Employee and promo discounts Supplies & smallwares Chanical cost-Gen Cleaning & Dishwasher Bank & Credit card charges Interest on long term loan Professionale Advertising Telephone & cable Office supplies Travel & entertainment Miscellaneous Municiple taxes Equipment rent Repairs & maintenance Depreciation Uniforms Delivery se Clube promotion Tot operating expenses Net income (ons) 23 1.237.5 233.11 27 1.5% 0.3% 0.0% 0.8% 15% 175 0.3% 0.3% 700.12 1.624.00 131.00 1.360.00 2.262.00 2.75 4045 1.800.12 4.872.00 3300 223 025 0.24 0.7% 18% 27% 0.5% 20% 0.4% 25.9% 131.00 23.00 2870.00 120.00 224 024 0.4% 40% 024 20% 26.25 152400 13100 148.00 301000 135.00 147000 325.00 19,851.00 8.172.00 67500 4.580 1.000.00 0.3% 1.630.00 0.2% 20% 0:49 20% 315.00 193 18.00 2139.95 S 281645 3.4% 3 47% 3 7.400 SS 13.636.14 57% Using the provided Income Statement worksheet and create a one-page analysis of what the data presented shows. Address the following questions in your analysis: What data is provided? What does the data show us? Can you identify any trends? Is there any data that could have been added to make a stronger report? Do you have any recommendations to the business owners? Yton wes Income werend WMALE ONLY Food & Barsales Food wales Bars Totd F&B sales 78935.10 450.00 68.565.05 35 78 540 S 22004024 S 1.24150 Cool Food only January February February Consumo March-05 Consumption March Yton January-os Consumption 20 Yton Cost Total sales Food Groene 15170 MEGI 15777 OBS US 15771931 UBUYU 33.67% on Hoe 26.77 2300 LEA 50 US R125 77,5655 087 2000 DO 2125 75,5555 28 5.770.38 0.94% 097 . ale contre months Bed Cont At Rebels Mrs Credits adjustments 26217.11 2.30.12 33.72 39 015 30% 22.498. 2.150.22 666 67 2351642 2.160.12 32 3 15% Totud food cout 2002 . 20.220 30 29.50 21720.30 20. 8.779.50 2. 26. Bar cool (Beer Liquor 35.5 TAS $ 52415.01 120.25 53.6.20 628% 543095.14 1.5 1745 543% 5 40.840.64 68.5 553150 1458 25 68.9% $ 5677134 875 15.524 1313 607% $ 10.2724 Gross Margin on sales All COGS) Lotorevenue Total income Wiego Benefits 15.5% dl wages Total lour costs ICEPAND COCOS SUEQUR 1758% 1724.00 2.68.00 19.77.00 3.22 1501250 2325.00 173370 17,100.00 285000 19750.00 20 48% 4.33150 3.175 S 7.663.00 S. 2077% 2. 3337 BENS 4208 35 53% Occupancy costs Rent Mortgage Utilities Propane Insurance Total Occupancy cout 4208 35 58025 3.217.00 345.00 5.04% 0.00% 3.8% 5. 0. 58% OS 3.5% 420835 580.00 3170.75 34500 01.10 283.0 346.00 8.020.55 12.505 1.7035 9.2385 1.00500 21.64.25 0.es 11.10% 0.11 32 2.864.70 32% 2.054.70 1.205.10 15.25 323 2.15 024 8,08410 3,86620 0.1% 0.8% 0. 07 3.0 10% 1.275.00 200470 1.505.70 14875 560.45 235020 BODO 100150 18500 124200 23445 25025 1280 550.60 22170 870 20 3.00 1.540.00 123.00 321.00 220.0 690.00 02% 0.8% 3.1% 124 13% 2.15 17% 0.4% 0.3% 70450 2.620.72 3.36 50 5.4250 3.73516 14 Operating Expenses Management salaries Employee and promo discounts Supplies & smallwares Chanical cost-Gen Cleaning & Dishwasher Bank & Credit card charges Interest on long term loan Professionale Advertising Telephone & cable Office supplies Travel & entertainment Miscellaneous Municiple taxes Equipment rent Repairs & maintenance Depreciation Uniforms Delivery se Clube promotion Tot operating expenses Net income (ons) 23 1.237.5 233.11 27 1.5% 0.3% 0.0% 0.8% 15% 175 0.3% 0.3% 700.12 1.624.00 131.00 1.360.00 2.262.00 2.75 4045 1.800.12 4.872.00 3300 223 025 0.24 0.7% 18% 27% 0.5% 20% 0.4% 25.9% 131.00 23.00 2870.00 120.00 224 024 0.4% 40% 024 20% 26.25 152400 13100 148.00 301000 135.00 147000 325.00 19,851.00 8.172.00 67500 4.580 1.000.00 0.3% 1.630.00 0.2% 20% 0:49 20% 315.00 193 18.00 2139.95 S 281645 3.4% 3 47% 3 7.400 SS 13.636.14 57% Yton wes Income werend WMALE ONLY Food & Barsales Food wales Bars Totd F&B sales 78935.10 450.00 68.565.05 35 78 540 S 22004024 S 1.24150 Cool Food only January February February Consumo March-05 Consumption March Yton January-os Consumption 20 Yton Cost Total sales Food Groene 15170 MEGI 15777 OBS US 15771931 UBUYU 33.67% on Hoe 26.77 2300 LEA 50 US R125 77,5655 087 2000 DO 2125 75,5555 28 5.770.38 0.94% 097 . ale contre months Bed Cont At Rebels Mrs Credits adjustments 26217.11 2.30.12 33.72 39 015 30% 22.498. 2.150.22 666 67 2351642 2.160.12 32 3 15% Totud food cout 2002 . 20.220 30 29.50 21720.30 20. 8.779.50 2. 26. Bar cool (Beer Liquor 35.5 TAS $ 52415.01 120.25 53.6.20 628% 543095.14 1.5 1745 543% 5 40.840.64 68.5 553150 1458 25 68.9% $ 5677134 875 15.524 1313 607% $ 10.2724 Gross Margin on sales All COGS) Lotorevenue Total income Wiego Benefits 15.5% dl wages Total lour costs ICEPAND COCOS SUEQUR 1758% 1724.00 2.68.00 19.77.00 3.22 1501250 2325.00 173370 17,100.00 285000 19750.00 20 48% 4.33150 3.175 S 7.663.00 S. 2077% 2. 3337 BENS 4208 35 53% Occupancy costs Rent Mortgage Utilities Propane Insurance Total Occupancy cout 4208 35 58025 3.217.00 345.00 5.04% 0.00% 3.8% 5. 0. 58% OS 3.5% 420835 580.00 3170.75 34500 01.10 283.0 346.00 8.020.55 12.505 1.7035 9.2385 1.00500 21.64.25 0.es 11.10% 0.11 32 2.864.70 32% 2.054.70 1.205.10 15.25 323 2.15 024 8,08410 3,86620 0.1% 0.8% 0. 07 3.0 10% 1.275.00 200470 1.505.70 14875 560.45 235020 BODO 100150 18500 124200 23445 25025 1280 550.60 22170 870 20 3.00 1.540.00 123.00 321.00 220.0 690.00 02% 0.8% 3.1% 124 13% 2.15 17% 0.4% 0.3% 70450 2.620.72 3.36 50 5.4250 3.73516 14 Operating Expenses Management salaries Employee and promo discounts Supplies & smallwares Chanical cost-Gen Cleaning & Dishwasher Bank & Credit card charges Interest on long term loan Professionale Advertising Telephone & cable Office supplies Travel & entertainment Miscellaneous Municiple taxes Equipment rent Repairs & maintenance Depreciation Uniforms Delivery se Clube promotion Tot operating expenses Net income (ons) 23 1.237.5 233.11 27 1.5% 0.3% 0.0% 0.8% 15% 175 0.3% 0.3% 700.12 1.624.00 131.00 1.360.00 2.262.00 2.75 4045 1.800.12 4.872.00 3300 223 025 0.24 0.7% 18% 27% 0.5% 20% 0.4% 25.9% 131.00 23.00 2870.00 120.00 224 024 0.4% 40% 024 20% 26.25 152400 13100 148.00 301000 135.00 147000 325.00 19,851.00 8.172.00 67500 4.580 1.000.00 0.3% 1.630.00 0.2% 20% 0:49 20% 315.00 193 18.00 2139.95 S 281645 3.4% 3 47% 3 7.400 SS 13.636.14 57% Using the provided Income Statement worksheet and create a one-page analysis of what the data presented shows. Address the following questions in your analysis: What data is provided? What does the data show us? Can you identify any trends? Is there any data that could have been added to make a stronger report? Do you have any recommendations to the business owners? Yton wes Income werend WMALE ONLY Food & Barsales Food wales Bars Totd F&B sales 78935.10 450.00 68.565.05 35 78 540 S 22004024 S 1.24150 Cool Food only January February February Consumo March-05 Consumption March Yton January-os Consumption 20 Yton Cost Total sales Food Groene 15170 MEGI 15777 OBS US 15771931 UBUYU 33.67% on Hoe 26.77 2300 LEA 50 US R125 77,5655 087 2000 DO 2125 75,5555 28 5.770.38 0.94% 097 . ale contre months Bed Cont At Rebels Mrs Credits adjustments 26217.11 2.30.12 33.72 39 015 30% 22.498. 2.150.22 666 67 2351642 2.160.12 32 3 15% Totud food cout 2002 . 20.220 30 29.50 21720.30 20. 8.779.50 2. 26. Bar cool (Beer Liquor 35.5 TAS $ 52415.01 120.25 53.6.20 628% 543095.14 1.5 1745 543% 5 40.840.64 68.5 553150 1458 25 68.9% $ 5677134 875 15.524 1313 607% $ 10.2724 Gross Margin on sales All COGS) Lotorevenue Total income Wiego Benefits 15.5% dl wages Total lour costs ICEPAND COCOS SUEQUR 1758% 1724.00 2.68.00 19.77.00 3.22 1501250 2325.00 173370 17,100.00 285000 19750.00 20 48% 4.33150 3.175 S 7.663.00 S. 2077% 2. 3337 BENS 4208 35 53% Occupancy costs Rent Mortgage Utilities Propane Insurance Total Occupancy cout 4208 35 58025 3.217.00 345.00 5.04% 0.00% 3.8% 5. 0. 58% OS 3.5% 420835 580.00 3170.75 34500 01.10 283.0 346.00 8.020.55 12.505 1.7035 9.2385 1.00500 21.64.25 0.es 11.10% 0.11 32 2.864.70 32% 2.054.70 1.205.10 15.25 323 2.15 024 8,08410 3,86620 0.1% 0.8% 0. 07 3.0 10% 1.275.00 200470 1.505.70 14875 560.45 235020 BODO 100150 18500 124200 23445 25025 1280 550.60 22170 870 20 3.00 1.540.00 123.00 321.00 220.0 690.00 02% 0.8% 3.1% 124 13% 2.15 17% 0.4% 0.3% 70450 2.620.72 3.36 50 5.4250 3.73516 14 Operating Expenses Management salaries Employee and promo discounts Supplies & smallwares Chanical cost-Gen Cleaning & Dishwasher Bank & Credit card charges Interest on long term loan Professionale Advertising Telephone & cable Office supplies Travel & entertainment Miscellaneous Municiple taxes Equipment rent Repairs & maintenance Depreciation Uniforms Delivery se Clube promotion Tot operating expenses Net income (ons) 23 1.237.5 233.11 27 1.5% 0.3% 0.0% 0.8% 15% 175 0.3% 0.3% 700.12 1.624.00 131.00 1.360.00 2.262.00 2.75 4045 1.800.12 4.872.00 3300 223 025 0.24 0.7% 18% 27% 0.5% 20% 0.4% 25.9% 131.00 23.00 2870.00 120.00 224 024 0.4% 40% 024 20% 26.25 152400 13100 148.00 301000 135.00 147000 325.00 19,851.00 8.172.00 67500 4.580 1.000.00 0.3% 1.630.00 0.2% 20% 0:49 20% 315.00 193 18.00 2139.95 S 281645 3.4% 3 47% 3 7.400 SS 13.636.14 57%