Nathan and Gurleen Actual Actual Actual Actual North South Total Budget Budget Budget Actual Vs Budget Actual 2021 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 Yr Over North North South Total Common size North South Total Common size North South Total North Sales 1,237,521 1,225,740 1,264,961 2,490,701 100% 100% 100% 1,161,784 1,200,000 2,361,784 100% 100% 100% 63,956 64,961 128,917 99% Sales Discount 43,067 39,202 48,447 87,649 3% 4% 1% 30,110 19,000 49,110 3% 2% 2% 9,092 29,447 38,539 91% Net Sales 1,194,454 1,186,538 1,216,514 2,403,052 97% 96% 96% 1,131,674 1,181,000 2,312,674 97% 98% 98% 54,864 35,514 90,378 99% COGS 401,408 406,583 408,387 814,970 33% 32% 33% 368,961 540,000 908,961 32% 45% 38% 37,622 (131,613) (93,991) 101% Gross Margin 793,046 779,955 808,127 1,588,082 64% 64% 64% 762,713 641,000 1,403,713 66% 53% 59% 17,242 167,127 184,369 98% Expenses (list below) Wages 289,538 275,222 278,622 553,844 22% 22% 22% 275,076 168,000 443,076 24% 14% 19% 146 110,622 110,768 95% Fringe benefits 35,698 33,972 35,852 69,824 3% 3% 3% 31,042 21,000 52,042 3% 2% 2% 2,930 14,852 17,782 95% Rent 87,606 86,891 86,614 173,505 7% 7% 7% 79,443 90,000 169,443 7% 8% 7% 7,448 (3,386) 4,062 99% Depreciation 37,399 39,533 38,601 78,134 3% 3% 3% 40,514 30,000 70,514 3% 3% 3% (981) 8,601 7,620 106% Utilities 48,697 49,335 48,672 98,007 4% 4% 4% 58,332 48,000 106,332 5% 4% 5% (8,997) 572 (8,325) 101% Freight 49,601 51,808 49,439 101,247 4% 4% 4% 41,390 26,400 67,790 4% 2% 3% 10,418 23,039 33,457 104% Phone & Internet 8,231 8,343 8,429 16,772 1% 1% 1% 6,490 9,000 15,490 1% 1% 1% 1,853 (571) 1,282 101% Packaging 21,793 22,203 21,411 43,614 2% 2% 2% 15,478 14,763 30,241 1% 1% 1% 6,725 6,648 13,373 102% Bank and Moneris 41,678 43,604 43,931 87,535 4% 3% 4% 37,562 27,000 64,562 3% 2% 3% 6,042 16,931 22,973 105% Marketing 48,483 44,417 49,523 93,940 4% 4% 4% 42,549 48,000 90,549 4% 4% 4% 1,868 1,523 3,391 92% Other Exp 54,645 52,350 52,632 104,982 4% 4% 4% 49,640 18,306 67,946 4% 2% 3% 2,710 34,326 37,036 96% Total Expenses 723,369 707,678 713,729 1,421,407 58% 56% 57% 677,512 500,468 1,177,980 58% 42% 50% 30,166 213,261 243,427 98% Op Income 69,677 72,277 94,398 166,675 6% 7% 7% 85,201 140,532 225,733 7% 12% 10% (12,924) (46,134) (59,058) 104% nterest Expense 48,382 47,510 47,644 95,154 4% 4% 4% 48,467 57,600 106,067 1% 5% 4% 957 (9,956 (10,913) 98% Net Income 21,295 24,767 46,734 71,501 2% 4% 3% 36,734 82,932 119,666 3% 7% 5% (11,967) (36,198) (48,165) 116% 2. Use common size and specific ratios to analysize year over year results and to compare to budget data. (only 5 ratios)
