Smith_Kyle_8E_Seafood_Inventory_Instructions

2ff57819bbb29d97cdf2bc0d47de2b77852176f2.xlsx Projected Income Statement: Dallas, TX July August September October November December January February March April May June Sales $ 178,270 $ 196,097 $ 215,707 $ 237,277 $ 261,005 $ 287,106 $ 315,816 $ 347,398 $ 382,138 $ 420,351 $ 462,386 $ 508,625 Expenses: Salaries and wages 155,814 170,715 187,778 206,940 227,214 249,953 274,938 301,824 332,674 365,446 402,528 442,654 Advertising 9,200 9,200 9,200 9,200 9,200 9,200 9,200 9,200 9,200 9,200 9,200 9,200 Rent and insurance 31,000 31,000 31,000 31,000 31,000 31,000 31,000 31,000 31,000 31,000 31,000 31,000 Total Expenses 196,014 210,915 227,978 247,140 267,414 290,153 315,138 342,024 372,874 405,646 442,728 482,854 Gross Profit/Loss $ (17,744) $ (14,818) $ (12,271) $ (9,863) $ (6,409) $ (3,047) $ 678 $ 5,374 $ 9,264 $ 14,705 $ 19,658 $ 25,771 Required Sales Growth 10% July August September October November December January February March April May June $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 $500,000 Expected Break-Even Point Sales Total Expenses