Question

1 Approved Answer

Posted on Jul 29, 2024

is westlake a viable busines? what is the required number of customers per day for westlake lanes ti achieve breakeven in March 2010 (base on

is westlake a viable busines? what is the required number of customers per day for westlake lanes ti achieve breakeven in March 2010 (base on January and Febuary Data)? how does this compare to 2008 breakeven? image text in transcribed

1 Westlake Lanes 2 2010 Income Statement 2010 January 2010 February YTD Projected Annual 5 Income 6 Lane Rental 7 Food Sale 8 Liquor Sale 9 Total 39,885 5,692 6,989 52,566 $ S $ $ 38,975.00 $ 5,741.00 $ 6,725.00 $ 51,441.00 $ 78,860 $ 473,160 11,433 $ 68,598 13,714 $ 82,284 104,007 $ 624,042 10 1,708 1,398 1,268 4,374 $ $ $ $ 1.722 1,345 1,247 4,314 $ $ $ $ 3,430 $ 2,743 $ 2,515 $ 8,687 $ 20,579 16,457 15,088 52,124 11 Variable Cost of Sales 12 Food Purchased 13 Liquor Purchased 14 Food & Beverage Supplies 15 Total 16 17 General Overhead Expenses 18 Advertisement 19 Salaries: Full Time 20 Salaries: Part Time 21 Coupons 22 Legal and Audit 23 License & Permits 24 Office Supplies 25 Rent 26 Repair & Maintenance Labor 27 Repair & Maintenance Supplies 28 Utilities 29 Travel & Promotion 30 Insurance 31 Miscellaneous 32 Depreciation & Amortization 33 Total Operating Expenses 925 9,800 $ 3,080 $ 709 $ 704 147 $ 274 S 8,983 2,470 $ 6,750 $ 2,377 $ 955 $ 9,800 $ 3,080 $ 850 S 704 $ 147 $ 255 $ 8,983 $ 6,755 $ 9,820 $ 2,377 $ 175 $ 4,900 $ 150 $ 700 $ 49,651 $ 1,880 $ 11,280 19,600 $ 117,600 6,160 $ 36,960 1,559 S 9,354 1,408 $ 8,448 293 $ 1,758 529 $ 3,174 17,966 $ 107,796 9,225 $ 55,350 16,570 $ 99,420 4,754 $ 28,524 175 $ 1,050 9,800 $ 58,800 300 $ 1,800 1,400 $ 8,400 91,619 $ 549,714 s 4,900 S 150 700 $ 41,969 $ 19 Salaries: Full Time 20 Salaries: Part Time 21 Coupons 22 Legal and Audit 23 License & Permits 24 Office Supplies 25 Rent 26 Repair & Maintenance Labor 27 Repair & Maintenance Supplies 28 Utilities 29 Travel & Promotion 30 Insurance 31 Miscellaneous 32 Depreciation & Amortization 33 Total Operating Expenses 34 35 Operating Income (Loss) 9,800 $ 3,080 $ 709 .$ 704 $ 147 $ 274 $ 8,983 $ 2,470 $ 6,750 $ 2,377. $ 9,800 $ 3,080 $ 850 $ 704 $ 147 $ 255 - $ 8,983 $ 6,755 $ 9,820 $ 2,377 $ 175 $ 4,900 $ 150 $ 700 $ 49,651 $ 19,600 $ 117,600 6,160 $ 36,960 1,559 $. 9,354 1,408 $ 8,448 293 $ 1,758 529 $ 3,174 17,966 $ 107,796 9,225 $ 55,350 16,570 $ 99,420 4,754 $ 28,524 175 $ 1,050 9,800 $ 58,800 300 $ 1,800 1,400 $ 8,400 91,619 $ 549,714 4,900 $ 150 $ 700 $ 41,969 $ 6,224 $ (2,523) $ 3,701 $ 22,204 37 Interest 632 $ 632 $ 1,265 $ 7,588 38 39 Income Before Taxes 40 Tax 5,592 $ 1,957 $ (3,156) $ (1,105) $ 2,436 853 $ $ 14,616 5,115 42 Net Income 3,635 $ (2,051) $ 1,583 $ 9,500 in B 2004 2005 2006 2007 2009 D Income 5 Lane and Shoe Rentals 5 Food & Soda Sales 7 Beer Sales B Total $ 708,765,00 $ 191,366.55 S 134,624.00 S 1034 755,55 $ - 637,888.50 $ $ 159.472.13 $ $ 165,851.01 $ S 963.211.64 $ 548,584.11 $ 153,603.55 $ 120.688.50 $ 822.876.17 $ 521,154.90 145,923.37 114,654.08 781,732.36 $ $ $ $ 2008 489,705.00 $ 137,889.00 $ 126,456,00 S 754,050.00 S 417,533.00 87,681.93 83,506.60 588,721.53 10 Cost of Sales 11 Food 12 Alcohol 13 Supplies 14 Coupons and Discounts 15 Total Cost of Sales $ $ S $ S 66,978.29 $ 30,963.52 $ 98,301.78 $ 31,042.67 $ 227,286.26 $ 55,815.24 $ 38,145.73 $ 91,505.11 $ 28,896.35 $ 214,362 43 S 53,761.24 $ 27.758.36 $ 78,173.24 $ 24,686.28 $ 184,379.12 $ 51,073.18 $ 26,370.44 $ 78,173.24 $ 23.451.97 $ 179,068.83 $ 48,261.15 S 29,084.88 $ 90,486.00 $ 22.621.50 $ 190,453.53 $ 26,304.58 16.701.32 47,097.72 17,661.65 107,765.27 17 Gross Proft 807 469.29 $ 748,849.20 S 638,497.05 S 602,663,53 S 563,596.47 $ 480,956.26 19 General Expenses . 20 Employee Wages $ 231,960.00 $ 236,599.20 $234233.21 S 21 Advertising $ 31,042,67 $ 31,973.95 $ 32,293.69 $ 22 Legal and Audit S 8,898.90 $ 8,453.95 $ 8,623.03' 23 Licenses and Permits $ 2.276.46 $ 2.299.23 $ 2,345.21 $ 24 Office Expenses $ 3,104.27 $ 3,414.69 $ 3.482.99 $ 25 Repairs and Maintenance 5 77,606.67 $ 100,888.67 $ 70,622.07 $ 26 Utilities $ 51,737.78 $ 52,255.16 $ 53,822.81 $ 27 Insurance S 50,000.00 $ 54,000.00 $ 58,320.00 $ 28 Rent $ 107,800.00 $ 107,800.00 $ 107.800.00 $ 29 Miscellaneous S 3,104.27 $ 3,166.35'$ 2,374.76 $ 30 Depreciation & Amortization $ 1.200.00 $ 1,200.00 $ 1,200.00 $ 31 Total Operating Expenses S 568.73100 S 602.051.19 $ 575.117.76 $ 32 33 Operating Income (Loss) S 238,738.29 $ 146.798.01 $ 63,379.28 S 34 EX 1 Monthly Income 2010 EX 2 Annual Income Statements 231,890.88 $ 32,616.62 $ 10,951.25 $ 2,368.66 $ 4.702.03 $ 115,447.00 $ 54,899.27 $ 62,985.60 $ 107,800.00 $ 2.422.26 $ 1.782.23 $ 627,865 80S 219,390.00 $ 29,354.90 $ 24,648.96 $ 2,392.35 $ 6,112.64 $ 76,974.00 $ 55,448.26 $ 68,024.45 $ 107,800.00 $ 3.148.94 $ 4359.40 $ 597 653.96 $ 205,390.00 15,865.00 15.900.00 2,416.27 3,346.00 86,432.00 36.672.00 63,412.00 107,800.00 3,510.00 6.076.01 546,819 29 25,202 275 34,05749) S (65,863.02) EX 3 Balance Sheet EX 4 Attendance Sna 21 Advertising 22 Legal and Audit 23 Licenses and Permits 24 Office Expenses 25 Repairs and Maintenance 26 Utilities S S $ $ 2010. 31,042.67 $ 8,898.90 $ 2,276.46 $ 3,104.27 S 77,606.67 $ 51,737.78 $ 50,000.00 $ 107,800.00 $ 3,104.27 $ 1,200.00 $ 568,731.00 $ D U . ZZZ 31,973.95 $ 32,293.69 $ 8,453.95 $ 8,623.03 2.299.23' 2.345 21 S 3.414.69S 3,482.99 $ 100.888.67 $ 70,622.07 $ 52,255.16 $ 53,822.81 $ 54,000.00 $ 58,320.00 S 107,800.00 $ 107,800.00 $ 3.166.35 S. 2,374.76 $ 1.200.00 $ 1.200.00 $ 602.051.19 $ 575, 117.76 $ E LUTVU.UU 32,616.62 $ 10,951.25 $ 2,368.66 S 4,702.03 $ 115.447.00 $ 54,899.27 $ 62.985.60 $ 107,800.00 $ 2.422.26 $ 1,782.23 $ 627,865.80 $ T ve 29,354.96 $ 24,648.96 $ 2,392.35 $ 6.112.64 $ 76,974.00 $ 55,448.26 '$ 68,024.45 $ 107,800.00 $ 3.148.94 $ 4,359.40 $ 597,653.96 $ 15,865,00 15,900.00 2,416.27 3,346.00 86,432.00 36,672.00 63,412.00 107,800.00 3,510.00 6.076.01 546,819.29 $ $ $ $ 28 Rent 29 Miscellaneous 30 Depreciation & Amortization 31 Total Operating Expenses 32 . 33 Operating Income (Loss) 34 35 Interest / $ 238,738.29 S 146.798.01 $ 63,379.28 $ 125,202.27) $ (34,057.49) $ (65,863:02) 1 2,400.00 $ 2,800.00 $. 3,200.00 $ 3,200.00 S 9,725.36 S 7,588.00 236,338.29 82,718.40 $ $ 143,998.01 $ 50,399.30 $ 60,179.28 21,062.75 : / / $ 153,619.89 $ 93,598.71 $ 39,116.53 $ 28,402.27) $ (43,782.85 $ 73,451.02 37 Income Before Taxes 38 Tax 39 40 Net Income (Loss) 41 42 Dividend 43 44 1 $ 153,619.89 $ 93,598.71 $ 39,116.53 Balance Sheet 2006 2007 - 2008 2009 45,488 $ 30,412 $ 29,491 $ 21,571 $ 20,600 $ 17,943 $ 4,578 4,200 $ $ $ 54,007 $ 129,907 $ 132,103 $ 183,165 $ 184,122 222,665 $ 178,046 $ 186,824 December 31, 2006-2009 7 ASSETS 8 Current Assets 9 Cash 10 Inventory 11 Fixed Assets 12 Property, Plant & Equipment 13 Total Assets 14 15 LIABILITIES 16 Accounts Payable 17 Debt 18 Total Liabilities 19 20 EQUITY 21 Common Stock 22 Retained Eamings 23 Total Equity 14,907 $ 40,000 $ 54,907 $ 15,000 $. 121,567 $ 136,567 $ 25,000 $ 33,252 94,850 $ 124,208 119,850 $ 157,460 $ 30,000 45,000 75,000 $ $ $ 30,000 $ 16,598 $ 46,598 $ 130,000 $ 130,000 (27,185) $ (100,636) 102,815 $ 29,364 $ 25 3 Weekly Attendance Snapshot 4 Week 1 February Monday Tuesday Wed Thursday Friday Saturday Veekly 430 146 Time of day 12pm-6pm Bpm - 9 Total 12pm-6pm Opm - 9 Total 236 576 1006 6 7 Week 1 August 8 Vacation Week) 68 SS 284 188 673 100 TB 265 364 1599 10 11 Averages 12 Average # Customers: 12pm-6pm 13 Average # Customers: 6pm - 9pm Weekly 467 630 Annually 24,304 32.752 Customer Spending Averages Lane & Shoe Weekday 12-6 Lane & Shoe Eve/Wind Average Food Spend 12pm-6pm Average Food Spond 6pm-9pm Average Beverage Spend 12pm-6pm Average Beverage Spend Spm pm $5.80 $6.10 $1.20 $2.75 $1.20 $3.50 D 2010 Weekly Attendance Snapshot 2 Week 1 February 350 Time of day 2pm - 6pm pm - 9 9pm - 12am Total Monday Tuesday Wed Thursday Friday Saturday Sunday Weekly 101220436611584 20 - 35 4456 146156115 572 139 154 293 3047 64 99 212 271199 1215 SON 1 Westlake Lanes 2 2010 Income Statement 2010 January 2010 February YTD Projected Annual 5 Income 6 Lane Rental 7 Food Sale 8 Liquor Sale 9 Total 39,885 5,692 6,989 52,566 $ S $ $ 38,975.00 $ 5,741.00 $ 6,725.00 $ 51,441.00 $ 78,860 $ 473,160 11,433 $ 68,598 13,714 $ 82,284 104,007 $ 624,042 10 1,708 1,398 1,268 4,374 $ $ $ $ 1.722 1,345 1,247 4,314 $ $ $ $ 3,430 $ 2,743 $ 2,515 $ 8,687 $ 20,579 16,457 15,088 52,124 11 Variable Cost of Sales 12 Food Purchased 13 Liquor Purchased 14 Food & Beverage Supplies 15 Total 16 17 General Overhead Expenses 18 Advertisement 19 Salaries: Full Time 20 Salaries: Part Time 21 Coupons 22 Legal and Audit 23 License & Permits 24 Office Supplies 25 Rent 26 Repair & Maintenance Labor 27 Repair & Maintenance Supplies 28 Utilities 29 Travel & Promotion 30 Insurance 31 Miscellaneous 32 Depreciation & Amortization 33 Total Operating Expenses 925 9,800 $ 3,080 $ 709 $ 704 147 $ 274 S 8,983 2,470 $ 6,750 $ 2,377 $ 955 $ 9,800 $ 3,080 $ 850 S 704 $ 147 $ 255 $ 8,983 $ 6,755 $ 9,820 $ 2,377 $ 175 $ 4,900 $ 150 $ 700 $ 49,651 $ 1,880 $ 11,280 19,600 $ 117,600 6,160 $ 36,960 1,559 S 9,354 1,408 $ 8,448 293 $ 1,758 529 $ 3,174 17,966 $ 107,796 9,225 $ 55,350 16,570 $ 99,420 4,754 $ 28,524 175 $ 1,050 9,800 $ 58,800 300 $ 1,800 1,400 $ 8,400 91,619 $ 549,714 s 4,900 S 150 700 $ 41,969 $ 19 Salaries: Full Time 20 Salaries: Part Time 21 Coupons 22 Legal and Audit 23 License & Permits 24 Office Supplies 25 Rent 26 Repair & Maintenance Labor 27 Repair & Maintenance Supplies 28 Utilities 29 Travel & Promotion 30 Insurance 31 Miscellaneous 32 Depreciation & Amortization 33 Total Operating Expenses 34 35 Operating Income (Loss) 9,800 $ 3,080 $ 709 .$ 704 $ 147 $ 274 $ 8,983 $ 2,470 $ 6,750 $ 2,377. $ 9,800 $ 3,080 $ 850 $ 704 $ 147 $ 255 - $ 8,983 $ 6,755 $ 9,820 $ 2,377 $ 175 $ 4,900 $ 150 $ 700 $ 49,651 $ 19,600 $ 117,600 6,160 $ 36,960 1,559 $. 9,354 1,408 $ 8,448 293 $ 1,758 529 $ 3,174 17,966 $ 107,796 9,225 $ 55,350 16,570 $ 99,420 4,754 $ 28,524 175 $ 1,050 9,800 $ 58,800 300 $ 1,800 1,400 $ 8,400 91,619 $ 549,714 4,900 $ 150 $ 700 $ 41,969 $ 6,224 $ (2,523) $ 3,701 $ 22,204 37 Interest 632 $ 632 $ 1,265 $ 7,588 38 39 Income Before Taxes 40 Tax 5,592 $ 1,957 $ (3,156) $ (1,105) $ 2,436 853 $ $ 14,616 5,115 42 Net Income 3,635 $ (2,051) $ 1,583 $ 9,500 in B 2004 2005 2006 2007 2009 D Income 5 Lane and Shoe Rentals 5 Food & Soda Sales 7 Beer Sales B Total $ 708,765,00 $ 191,366.55 S 134,624.00 S 1034 755,55 $ - 637,888.50 $ $ 159.472.13 $ $ 165,851.01 $ S 963.211.64 $ 548,584.11 $ 153,603.55 $ 120.688.50 $ 822.876.17 $ 521,154.90 145,923.37 114,654.08 781,732.36 $ $ $ $ 2008 489,705.00 $ 137,889.00 $ 126,456,00 S 754,050.00 S 417,533.00 87,681.93 83,506.60 588,721.53 10 Cost of Sales 11 Food 12 Alcohol 13 Supplies 14 Coupons and Discounts 15 Total Cost of Sales $ $ S $ S 66,978.29 $ 30,963.52 $ 98,301.78 $ 31,042.67 $ 227,286.26 $ 55,815.24 $ 38,145.73 $ 91,505.11 $ 28,896.35 $ 214,362 43 S 53,761.24 $ 27.758.36 $ 78,173.24 $ 24,686.28 $ 184,379.12 $ 51,073.18 $ 26,370.44 $ 78,173.24 $ 23.451.97 $ 179,068.83 $ 48,261.15 S 29,084.88 $ 90,486.00 $ 22.621.50 $ 190,453.53 $ 26,304.58 16.701.32 47,097.72 17,661.65 107,765.27 17 Gross Proft 807 469.29 $ 748,849.20 S 638,497.05 S 602,663,53 S 563,596.47 $ 480,956.26 19 General Expenses . 20 Employee Wages $ 231,960.00 $ 236,599.20 $234233.21 S 21 Advertising $ 31,042,67 $ 31,973.95 $ 32,293.69 $ 22 Legal and Audit S 8,898.90 $ 8,453.95 $ 8,623.03' 23 Licenses and Permits $ 2.276.46 $ 2.299.23 $ 2,345.21 $ 24 Office Expenses $ 3,104.27 $ 3,414.69 $ 3.482.99 $ 25 Repairs and Maintenance 5 77,606.67 $ 100,888.67 $ 70,622.07 $ 26 Utilities $ 51,737.78 $ 52,255.16 $ 53,822.81 $ 27 Insurance S 50,000.00 $ 54,000.00 $ 58,320.00 $ 28 Rent $ 107,800.00 $ 107,800.00 $ 107.800.00 $ 29 Miscellaneous S 3,104.27 $ 3,166.35'$ 2,374.76 $ 30 Depreciation & Amortization $ 1.200.00 $ 1,200.00 $ 1,200.00 $ 31 Total Operating Expenses S 568.73100 S 602.051.19 $ 575.117.76 $ 32 33 Operating Income (Loss) S 238,738.29 $ 146.798.01 $ 63,379.28 S 34 EX 1 Monthly Income 2010 EX 2 Annual Income Statements 231,890.88 $ 32,616.62 $ 10,951.25 $ 2,368.66 $ 4.702.03 $ 115,447.00 $ 54,899.27 $ 62,985.60 $ 107,800.00 $ 2.422.26 $ 1.782.23 $ 627,865 80S 219,390.00 $ 29,354.90 $ 24,648.96 $ 2,392.35 $ 6,112.64 $ 76,974.00 $ 55,448.26 $ 68,024.45 $ 107,800.00 $ 3.148.94 $ 4359.40 $ 597 653.96 $ 205,390.00 15,865.00 15.900.00 2,416.27 3,346.00 86,432.00 36.672.00 63,412.00 107,800.00 3,510.00 6.076.01 546,819 29 25,202 275 34,05749) S (65,863.02) EX 3 Balance Sheet EX 4 Attendance Sna 21 Advertising 22 Legal and Audit 23 Licenses and Permits 24 Office Expenses 25 Repairs and Maintenance 26 Utilities S S $ $ 2010. 31,042.67 $ 8,898.90 $ 2,276.46 $ 3,104.27 S 77,606.67 $ 51,737.78 $ 50,000.00 $ 107,800.00 $ 3,104.27 $ 1,200.00 $ 568,731.00 $ D U . ZZZ 31,973.95 $ 32,293.69 $ 8,453.95 $ 8,623.03 2.299.23' 2.345 21 S 3.414.69S 3,482.99 $ 100.888.67 $ 70,622.07 $ 52,255.16 $ 53,822.81 $ 54,000.00 $ 58,320.00 S 107,800.00 $ 107,800.00 $ 3.166.35 S. 2,374.76 $ 1.200.00 $ 1.200.00 $ 602.051.19 $ 575, 117.76 $ E LUTVU.UU 32,616.62 $ 10,951.25 $ 2,368.66 S 4,702.03 $ 115.447.00 $ 54,899.27 $ 62.985.60 $ 107,800.00 $ 2.422.26 $ 1,782.23 $ 627,865.80 $ T ve 29,354.96 $ 24,648.96 $ 2,392.35 $ 6.112.64 $ 76,974.00 $ 55,448.26 '$ 68,024.45 $ 107,800.00 $ 3.148.94 $ 4,359.40 $ 597,653.96 $ 15,865,00 15,900.00 2,416.27 3,346.00 86,432.00 36,672.00 63,412.00 107,800.00 3,510.00 6.076.01 546,819.29 $ $ $ $ 28 Rent 29 Miscellaneous 30 Depreciation & Amortization 31 Total Operating Expenses 32 . 33 Operating Income (Loss) 34 35 Interest / $ 238,738.29 S 146.798.01 $ 63,379.28 $ 125,202.27) $ (34,057.49) $ (65,863:02) 1 2,400.00 $ 2,800.00 $. 3,200.00 $ 3,200.00 S 9,725.36 S 7,588.00 236,338.29 82,718.40 $ $ 143,998.01 $ 50,399.30 $ 60,179.28 21,062.75 : / / $ 153,619.89 $ 93,598.71 $ 39,116.53 $ 28,402.27) $ (43,782.85 $ 73,451.02 37 Income Before Taxes 38 Tax 39 40 Net Income (Loss) 41 42 Dividend 43 44 1 $ 153,619.89 $ 93,598.71 $ 39,116.53 Balance Sheet 2006 2007 - 2008 2009 45,488 $ 30,412 $ 29,491 $ 21,571 $ 20,600 $ 17,943 $ 4,578 4,200 $ $ $ 54,007 $ 129,907 $ 132,103 $ 183,165 $ 184,122 222,665 $ 178,046 $ 186,824 December 31, 2006-2009 7 ASSETS 8 Current Assets 9 Cash 10 Inventory 11 Fixed Assets 12 Property, Plant & Equipment 13 Total Assets 14 15 LIABILITIES 16 Accounts Payable 17 Debt 18 Total Liabilities 19 20 EQUITY 21 Common Stock 22 Retained Eamings 23 Total Equity 14,907 $ 40,000 $ 54,907 $ 15,000 $. 121,567 $ 136,567 $ 25,000 $ 33,252 94,850 $ 124,208 119,850 $ 157,460 $ 30,000 45,000 75,000 $ $ $ 30,000 $ 16,598 $ 46,598 $ 130,000 $ 130,000 (27,185) $ (100,636) 102,815 $ 29,364 $ 25 3 Weekly Attendance Snapshot 4 Week 1 February Monday Tuesday Wed Thursday Friday Saturday Veekly 430 146 Time of day 12pm-6pm Bpm - 9 Total 12pm-6pm Opm - 9 Total 236 576 1006 6 7 Week 1 August 8 Vacation Week) 68 SS 284 188 673 100 TB 265 364 1599 10 11 Averages 12 Average # Customers: 12pm-6pm 13 Average # Customers: 6pm - 9pm Weekly 467 630 Annually 24,304 32.752 Customer Spending Averages Lane & Shoe Weekday 12-6 Lane & Shoe Eve/Wind Average Food Spend 12pm-6pm Average Food Spond 6pm-9pm Average Beverage Spend 12pm-6pm Average Beverage Spend Spm pm $5.80 $6.10 $1.20 $2.75 $1.20 $3.50 D 2010 Weekly Attendance Snapshot 2 Week 1 February 350 Time of day 2pm - 6pm pm - 9 9pm - 12am Total Monday Tuesday Wed Thursday Friday Saturday Sunday Weekly 101220436611584 20 - 35 4456 146156115 572 139 154 293 3047 64 99 212 271199 1215 SON