Connections 55 Web Text Sou Get External Data Get & Transform fx =(B4-B5)/B4 D m B A GLAGLER ICE CREAMERY 2 3 4 Profit and Loss Statement 2020 2021 $ 1,091,500 $ 1,690,000 $ $ 840,625 $ 1,291,000 $ $ 250,875 $ 399,000 $ 23% 24% Revenue Cost of Goods Sold Gross Profit Gross Profit Margin 2022 2,144,100 1,564,200 579,900 27% 5 6 7 8 9 Operating Expenses 10 Salary 11 Employee-related Expenses $ 12 Rent $ 13 Office Supplies $ 14 Utilities $ 15 Advertising and Promotion $ 16 Repairs, Maintenance, and Fees $ 17 Computer, Apps, and Internet $ 18 Insurance Expense $ 19 Total Operating Expenses $ 155,000 $ 31,000 $ 58,000 $ 2,100 $ 5,400 $ 46,300 $ 40,000 $ 27,500 $ 4,200 $ 369,500 $ 155,000 $ 31,000 $ 58,000 $ 1,000 $ 5,400 $ 11,300 $ $ 10,000 $ 4,200 $ 275,900 $ 165,500 33, 100 58,000 1,100 5,400 24,000 8,000 4,200 299,300 Income Statement Connections 55 Web Text Sou Get External Data Get & Transform fx =(B4-B5)/B4 D m B A GLAGLER ICE CREAMERY 2 3 4 Profit and Loss Statement 2020 2021 $ 1,091,500 $ 1,690,000 $ $ 840,625 $ 1,291,000 $ $ 250,875 $ 399,000 $ 23% 24% Revenue Cost of Goods Sold Gross Profit Gross Profit Margin 2022 2,144,100 1,564,200 579,900 27% 5 6 7 8 9 Operating Expenses 10 Salary 11 Employee-related Expenses $ 12 Rent $ 13 Office Supplies $ 14 Utilities $ 15 Advertising and Promotion $ 16 Repairs, Maintenance, and Fees $ 17 Computer, Apps, and Internet $ 18 Insurance Expense $ 19 Total Operating Expenses $ 155,000 $ 31,000 $ 58,000 $ 2,100 $ 5,400 $ 46,300 $ 40,000 $ 27,500 $ 4,200 $ 369,500 $ 155,000 $ 31,000 $ 58,000 $ 1,000 $ 5,400 $ 11,300 $ $ 10,000 $ 4,200 $ 275,900 $ 165,500 33, 100 58,000 1,100 5,400 24,000 8,000 4,200 299,300 Income Statement