Database includes 2 years worth of actual data and one year of budget data for a...

  
 
 

Transcribed Image Text:

Database includes 2 years worth of actual data and one year of budget data for a retail business with 2 locations. In 2017, there was just one location, North. In January 2018, a new location, South, opened. Budget data is based on best estimates of business activity. Actual data included: Some maintenance costs that were expensed in Q4 Other Expenses North location were unexpected and not budgeted for. Sales Discounts can be impacted by competition (more competition, more discounts must be offered). In retail, industry averages include the following: COGS Wages + Benefits Rent + Utilities Percentage of Total Sales 33% 25% 10% Requirements: 1. Create an Income Statement by location and in total for both budget and actual data (row format) for both 2017 and 2018. 2. Use common size and specific ratios to analysize year over year results and to compare to budget data. 3. Create a 2019 Income Statement budget by location and in total including the following: 1. provide reasons for values 2. Budget for improved results and explain how the improvement will be achieved. In particular, the Net Profit for the South location must be improved. Use ratios, common size analysis and trend analysis to support your budget estimates and improvements. Act/Bud Month Year Location Sales Discounts Net Sales COGS Gross Margin Wages Fringe benefits Rent Actual January 18,745 7,123 25,784 7,149 24,180 7,401 21,674 7,292 2017 North Actual February 2017 North Actual March 2017 North Actual April 2017 North Actual May 2017 North Actual June 2017 North Actual July 2017 North Actual August 2017 North Actual September 2017 North Actual October 84,797 28,563 106,501 33,632 111,687 36,845 98,050 33,028 116,526 40,056 110,522 35,689 93,004 31,640 104,760 33,829 92,383 33,681 97,860 31,933 102,373 36,939 90,753 29,614 80,169 24,542 95,834 33,941 112,096 38,533 118,316 41,049 112,116 38,143 2017 North Actual November 2017 North Actual December 2017 North Actual January 2018 North Actual February 2018 North Actual March 2018 North 2018 North 2018 North Actual April Actual May Actual June 2018 North 98,536 32,507 2018 North 86,190 30,211 Actual July Actual August Actual 66,029 55,979 87,090 30,527 56,564 88,349 31,620 56,729 103,513 35,216 68,297 81,032 120,924 39,892 58,493 65,958 59,097 61,960 56,144 53,723 17,908 75,817 30,086 Actual Actual 5 Budget 2018 North September 2018 North October 2018 North November 2018 North December 2018 North January 2018 North Budget February 2018 North Budget March Budget April Budget May Budget lune = Actual 2018 North 2018 North 2018 North 2018 North 4,463 5,605 3,454 5,161 4,855 4,605 2,876 4,365 3,849 5,151 3,166 4,776 1,636 3,993 4,671 2,415 3,468 3,047 2,666 2,694 4,650 3,201 3,740 2,742 4,122 2,646 1,936 2,674 3,256 4,814 88,653 30,160 98,937 32,979 85,559 26,462 94,877 32,916 86,443 30,300 78,142 24,419 115,530 39,714 56,234 72,869 74,842 65,023 76,470 74,833 61,363 70,931 58,702 65,927 65,434 61,139 21,972 55,627 16,361 61,893 20,964 73,563 77,268 73,974 24,521 24,146 26,584 25,396 19,548 19,752 18,600 23,477 28,673 20,107 25,765 19,405 22,267 19,606 25,490 25,328 19,176 21,825 19,246 20,602 24,274 2,062 3,094 2,660 2,167 2,804 2,786 2,685 2,183 2,502 2,266 3,156 2,417 1,636 2,516 3,433 3,380 2,924 2,540 2,737 2,173 2,232 2,348 3,727 2,413 2,834 2,329 2,227 2,353 1,970 3,309 7,075 7,230 7,180 7,327 7,281 7,013 7,226 7,153 7,321 7,182 7,260 7,076 7,083 7,317 7,281 7,259 7,298 7,276 7,077 7,279 6,912 6,826 6,175 6,881 6,644 6,581 Depreciation Utilities 2,675 3,579 3,539 3,522 3,199 3,818 3,701 3,905 2,887 3,303 3,455 3,302 2,793 2,857 3,208 2,537 3,648 2,839 2,805 2,725 3,384 2,693 3,827 2,774 3,958 2,685 3,736 3,668 3,293 3,245 3,378 4,414 4,480 3,152 4,927 3,509 3,902 4,316 4,004 4,305 4,022 4,834 3,133 3,399 3,463 3,019 3,890 4,957 3,369 4,594 3,212 4,738 3,583 3,281 5,894 5,444 5,154 4,592 4,474 4,300 Freight Phone Internet Packaging Bank and Moneris Marketing Other Exp Total Expenses 4,284 4,501 5,045 4,971 3,685 3,136 3,963 3,309 4,006 3,702 3,926 4,242 4,113 3,538 4,736 4,537 5,052 3,384 3,832 3,869 5,171 3,848 3,258 3,861 3,190 3,731 4,942 1,143 2,354 2,579 1,321 2,804 2,498 2,215 2,030 2,358 1,277 1,847 1,185 1,718 1,697 1,541 3,509 4,045 2,052 2,670 3,424 3,447 4,932 4,781 3,871 4,194 4,599 3,240 3,549 3,298 3,157 3,708 3,100 3,493 3,394 5,395 5,336 4,196 4,226 3,323 4,274 3,794 3,522 4,787 3,318 3,957 2,117 2,962 3,636 1,954 4,368 609 617 607 674 767 766 719 740 649 687 777 757 688 800 629 720 766 723 766 614 759 641 728 698 504 590 533 520 600 524 2,275 1,208 1,832 2,213 1,761 1,596 1,810 1,979 794 1,646 1,515 977 1,191 2,544 4,260 2,234 4,903 3,496 3,316 3,720 2,095 1,848 1,957 2,047 2,723 4,008 1,917 3,363 2,366 5,606 1,971 4,310 3,484 3,534 5,176 2,418 2,660 3,957 1,711 1,898 4,322 3,126 3,466 2,544 5,325 6,701 4,903 6,992 5,526 5,580 6,286 4,619 2,936 6,142 3,630 4,810 2,875 6,726 4,733 4,485 3,941 4,310 4,355 2,650 6,211 7,255 2,660 2,968 2,567 4,744 3,458 2,344 4,621 49,607 66,593 61,201 56,880 65,261 62,945 56,529 59,979 53,830 52,048 61,966 55,090 49,390 52,542 63,048 59,411 65,276 59,632 54,589 55,842 51,548 62,036 68,271 50,238 62,278 47,765 54,498 54,258 46,389 6.5,185 Op Income 6,626 6,276 13,641 8,143 11,209 11,888 4,834 10,952 4,871 13,879 3,468 6,048 6,237 9,351 10,516 17,856 8,698 6,397 1,391 722 5,181 6,261 12,761 8,255 3,680 11,332 7,462 1,885 7,334 10,631 Interest Exp Net Income 4,364 2,262 3,693 2,583 9,829 3,812 4,435 3,877 3,708 7,332 7,393 1,004 6,904 1,325 10,041 -870 1,729 2,193 5,644 6,128 13,446 4,516 2,455 -2,367 -3,697 994 2,572 8,308 4,413 -799 8,090 3,264 -3,113 3,691 6,002 4,495 3,830 4,048 3,546 3,838 4,338 4,319 4,044 3,707 4,388 4,410 4,182 3,942 3,758 4,419 4,187 3,689 4,453 3,842 4,479 3,242 4,198 4,998 3,643 4,629 Act/Bud Month Year Location Sales Discounts Net Sales COGS Gross Margin Wages Fringe benefits Rent buuget June ZUIO TVOTLIT 73,017 30,000 U, JOI 113,350 33,714 111,629 34,524 27,619 2018 North 2018 North 21,965 Budget July Budget August Budget September 2018 North Budget October 27,412 21,757 87,859 30,202 106,357 32,894 88,840 28,102 87,185 27,245 97,482 33,510 111,159 37,443 111,941 37,694 22,705 77,104 57,658 73,463 60,738 59,940 63,973 73,716 74,246 94,195 30,737 63,458 89,487 30,761 58,726 111,221 38,985 72,236 69,323 70,633 23,355 24,572 28,556 19,831 18,643 28,665 24,158 76,184 2018 North Budget November 2018 North Budget December 2018 North Actual January 2018 South Actual February 2018 South Actual March 2018 South Actual April 2018 South Actual May 2018 South Actual June 2018 South Actual July 2018 South Actual August 2018 South Actual September 2018 South Actual October 2018 South Actual November 2018 South Actual December 2018 South Budget January 2018 South Budget February 2018 South Budget March 2018 South Budget April 2018 South Budget May 2018 South Budget June 2018 South Budget July 2018 South Budget August 2018 South Budget September 2018 South Budget October 2018 South Budget November 2018 South Budget December 2018 South 101,884 32,561 103,315 32,681 110,297 34,112 117,782 37,258 87,589 29,494 94,438 29,873 104,357 34,053 99,000 45,000 99,000 45,000 99,000 45,000 99,000 45,000 99,000 45,000 4,014 3,452 3,661 3,289 1,813 3,633 4,062 5,850 2,285 4,958 3,729 3,440 3,151 2,108 3,411 2,404 1,788 1,927 5,492 1,000 1,000 1,000 1,000 1,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 98,000 45,000 98,000 45,000 98,000 45,000 98,000 45,000 98,000 45,000 98,000 45,000 98,000 45,000 80,525 58,095 64,565 70,303 54,000 54,000 54,000 54,000 54,000 53,000 53,000 53,000 53,000 53,000 53,000 53,000 26,356 26,153 25,239 21,450 19,273 24,167 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 5,505 3,038 2,196 3,015 2,393 2,270 2,336 3,440 4,283 2,776 2,610 3,726 2,416 2,636 3,138 2,776 2,360 2,505 3,625 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 6,463 6,285 6,083 6,931 6,296 6,280 7,342 7,442 7,137 7,357 7,399 7,032 7,476 7,216 7,290 7,240 7,070 7,014 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 Depreciation Utilities 3,24J 4,300 5,555 3,211 2,526 5,331 3,797 4,042 3,263 5,590 3,319 4,638 3,104 4,137 4,376 3,173 4,055 4,300 3,642 4,374 3,192 3,094 4,663 4,930 4,694 3,486 4,000 4,000 4,000 4,000 4,000 3,529 2,685 3,083 2,557 3,340 2,576 3,580 2,773 3,807 3,043 3,274 3,711 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 4,000 4,000 4,000 4,000 4,000 4,000 4,000 Freight Phone & Internet Packaging Bank and Moneris Marketing Other Exp Total Expenses 4,500 JZ4 4,UZI 4,143 506 2,416 530 1,151 2,071 906 1,645 1,405 1,090 3,618 533 557 545 546 633 704 605 667 625 718 756 679 630 762 5,400 3,349 4,393 5,318 4,442 4,359 3,899 2,223 5,597 4,710 2,685 4,449 1,675 2,621 1,508 1,229 1,846 2,729 1,302 2,288 2,388 3,435 3,071 3,913 3,699 3,905 3,387 3,581 4,771 3,891 3,900 4,150 4,146 3,169 4,920 3,774 4,043 4,076 3,177 3,349 2,636 3,191 3,554 2,616 2,924 5,558 6,716 2,826 4,474 4,449 5,094 4,133 4,412 5,889 5,255 2,833 5,218 1,535 1,535 1,535 1,535 4,075 3,099 5,515 2,356 UJ, 10J 62,376 53,097 62,352 57,450 53,677 55,189 63,184 68,325 53,841 52,673 67,069 59,799 63,010 63,576 63,772 56,463 51,808 62,526 41,722 41,722 41,722 41,722 41,722 41,694 41,694 41,694 41,694 41,694 41,694 41,694 2,628 3,778 4,174 3,567 723 753 750 750 2,250 4,000 2,250 4,000 750 2,250 4,000 750 2,250 4,000 750 4,000 750 4,000 750 4,000 750 4,000 1,535 1,519 1,519 1,519 1,519 1,519 1,519 1,519 4,000 4,000 4,000 4,000 3,653 2,452 3,351 4,119 3,769 3,688 3,384 3,898 4,884 4,575 4,435 4,843 2,949 3,286 4,767 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 750 750 750 750 2,235 1,770 1,195 2,043 1,238 1,238 1,238 1,238 1,238 1,225 1,225 1,225 1,225 1,225 1,225 1,225 2,250 2,250 2,250 2,250 2,250 2,250 2,250 2,250 Op Income 10,051 14,729 4,560 11,111 3,288 6,263 8,784 10,532 5,921 9,617 6,053 5,168 9,524 7,623 12,608 16,753 1,632 12,756 7,778 12,278 12,278 12,278 12,278 12,278 11,306 11,306 11,306 11,306 11,306 11,306 11,306 Interest Exp Net Income 0,00Z 10,287 4,023 4,442 3,126 1,434 4,460 6,651 4,149 -861 3,844 3,598 3,898 3,648 3,925 4,225 4,190 3,580 3,845 4,348 3,825 3,562 4,497 3,552 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 2,419 5,186 6,634 2,273 5,692 1,828 978 5,944 3,778 8,260 12,928 -1,930 8,259 4,226 7,478 7,478 7,478 7,478 7,478 6,506 6,506 6,506 6,506 6,506 6,506 6,506 Sales Sales Discounts Net Sales COGS Gross Margin Wages Fringe benefits Rent Depreciation Utilities Freight Phone & Internet Packaging Bank and Moneris Marketing Other Exp Total Expenses North Location 2017 2018 Actuals Actuals 2018 Budget South Location 2018 Actuals 2018 Budget Database includes 2 years worth of actual data and one year of budget data for a retail business with 2 locations. In 2017, there was just one location, North. In January 2018, a new location, South, opened. Budget data is based on best estimates of business activity. Actual data included: Some maintenance costs that were expensed in Q4 Other Expenses North location were unexpected and not budgeted for. Sales Discounts can be impacted by competition (more competition, more discounts must be offered). In retail, industry averages include the following: COGS Wages + Benefits Rent + Utilities Percentage of Total Sales 33% 25% 10% Requirements: 1. Create an Income Statement by location and in total for both budget and actual data (row format) for both 2017 and 2018. 2. Use common size and specific ratios to analysize year over year results and to compare to budget data. 3. Create a 2019 Income Statement budget by location and in total including the following: 1. provide reasons for values 2. Budget for improved results and explain how the improvement will be achieved. In particular, the Net Profit for the South location must be improved. Use ratios, common size analysis and trend analysis to support your budget estimates and improvements. Act/Bud Month Year Location Sales Discounts Net Sales COGS Gross Margin Wages Fringe benefits Rent Actual January 18,745 7,123 25,784 7,149 24,180 7,401 21,674 7,292 2017 North Actual February 2017 North Actual March 2017 North Actual April 2017 North Actual May 2017 North Actual June 2017 North Actual July 2017 North Actual August 2017 North Actual September 2017 North Actual October 84,797 28,563 106,501 33,632 111,687 36,845 98,050 33,028 116,526 40,056 110,522 35,689 93,004 31,640 104,760 33,829 92,383 33,681 97,860 31,933 102,373 36,939 90,753 29,614 80,169 24,542 95,834 33,941 112,096 38,533 118,316 41,049 112,116 38,143 2017 North Actual November 2017 North Actual December 2017 North Actual January 2018 North Actual February 2018 North Actual March 2018 North 2018 North 2018 North Actual April Actual May Actual June 2018 North 98,536 32,507 2018 North 86,190 30,211 Actual July Actual August Actual 66,029 55,979 87,090 30,527 56,564 88,349 31,620 56,729 103,513 35,216 68,297 81,032 120,924 39,892 58,493 65,958 59,097 61,960 56,144 53,723 17,908 75,817 30,086 Actual Actual 5 Budget 2018 North September 2018 North October 2018 North November 2018 North December 2018 North January 2018 North Budget February 2018 North Budget March Budget April Budget May Budget lune = Actual 2018 North 2018 North 2018 North 2018 North 4,463 5,605 3,454 5,161 4,855 4,605 2,876 4,365 3,849 5,151 3,166 4,776 1,636 3,993 4,671 2,415 3,468 3,047 2,666 2,694 4,650 3,201 3,740 2,742 4,122 2,646 1,936 2,674 3,256 4,814 88,653 30,160 98,937 32,979 85,559 26,462 94,877 32,916 86,443 30,300 78,142 24,419 115,530 39,714 56,234 72,869 74,842 65,023 76,470 74,833 61,363 70,931 58,702 65,927 65,434 61,139 21,972 55,627 16,361 61,893 20,964 73,563 77,268 73,974 24,521 24,146 26,584 25,396 19,548 19,752 18,600 23,477 28,673 20,107 25,765 19,405 22,267 19,606 25,490 25,328 19,176 21,825 19,246 20,602 24,274 2,062 3,094 2,660 2,167 2,804 2,786 2,685 2,183 2,502 2,266 3,156 2,417 1,636 2,516 3,433 3,380 2,924 2,540 2,737 2,173 2,232 2,348 3,727 2,413 2,834 2,329 2,227 2,353 1,970 3,309 7,075 7,230 7,180 7,327 7,281 7,013 7,226 7,153 7,321 7,182 7,260 7,076 7,083 7,317 7,281 7,259 7,298 7,276 7,077 7,279 6,912 6,826 6,175 6,881 6,644 6,581 Depreciation Utilities 2,675 3,579 3,539 3,522 3,199 3,818 3,701 3,905 2,887 3,303 3,455 3,302 2,793 2,857 3,208 2,537 3,648 2,839 2,805 2,725 3,384 2,693 3,827 2,774 3,958 2,685 3,736 3,668 3,293 3,245 3,378 4,414 4,480 3,152 4,927 3,509 3,902 4,316 4,004 4,305 4,022 4,834 3,133 3,399 3,463 3,019 3,890 4,957 3,369 4,594 3,212 4,738 3,583 3,281 5,894 5,444 5,154 4,592 4,474 4,300 Freight Phone Internet Packaging Bank and Moneris Marketing Other Exp Total Expenses 4,284 4,501 5,045 4,971 3,685 3,136 3,963 3,309 4,006 3,702 3,926 4,242 4,113 3,538 4,736 4,537 5,052 3,384 3,832 3,869 5,171 3,848 3,258 3,861 3,190 3,731 4,942 1,143 2,354 2,579 1,321 2,804 2,498 2,215 2,030 2,358 1,277 1,847 1,185 1,718 1,697 1,541 3,509 4,045 2,052 2,670 3,424 3,447 4,932 4,781 3,871 4,194 4,599 3,240 3,549 3,298 3,157 3,708 3,100 3,493 3,394 5,395 5,336 4,196 4,226 3,323 4,274 3,794 3,522 4,787 3,318 3,957 2,117 2,962 3,636 1,954 4,368 609 617 607 674 767 766 719 740 649 687 777 757 688 800 629 720 766 723 766 614 759 641 728 698 504 590 533 520 600 524 2,275 1,208 1,832 2,213 1,761 1,596 1,810 1,979 794 1,646 1,515 977 1,191 2,544 4,260 2,234 4,903 3,496 3,316 3,720 2,095 1,848 1,957 2,047 2,723 4,008 1,917 3,363 2,366 5,606 1,971 4,310 3,484 3,534 5,176 2,418 2,660 3,957 1,711 1,898 4,322 3,126 3,466 2,544 5,325 6,701 4,903 6,992 5,526 5,580 6,286 4,619 2,936 6,142 3,630 4,810 2,875 6,726 4,733 4,485 3,941 4,310 4,355 2,650 6,211 7,255 2,660 2,968 2,567 4,744 3,458 2,344 4,621 49,607 66,593 61,201 56,880 65,261 62,945 56,529 59,979 53,830 52,048 61,966 55,090 49,390 52,542 63,048 59,411 65,276 59,632 54,589 55,842 51,548 62,036 68,271 50,238 62,278 47,765 54,498 54,258 46,389 6.5,185 Op Income 6,626 6,276 13,641 8,143 11,209 11,888 4,834 10,952 4,871 13,879 3,468 6,048 6,237 9,351 10,516 17,856 8,698 6,397 1,391 722 5,181 6,261 12,761 8,255 3,680 11,332 7,462 1,885 7,334 10,631 Interest Exp Net Income 4,364 2,262 3,693 2,583 9,829 3,812 4,435 3,877 3,708 7,332 7,393 1,004 6,904 1,325 10,041 -870 1,729 2,193 5,644 6,128 13,446 4,516 2,455 -2,367 -3,697 994 2,572 8,308 4,413 -799 8,090 3,264 -3,113 3,691 6,002 4,495 3,830 4,048 3,546 3,838 4,338 4,319 4,044 3,707 4,388 4,410 4,182 3,942 3,758 4,419 4,187 3,689 4,453 3,842 4,479 3,242 4,198 4,998 3,643 4,629 Act/Bud Month Year Location Sales Discounts Net Sales COGS Gross Margin Wages Fringe benefits Rent buuget June ZUIO TVOTLIT 73,017 30,000 U, JOI 113,350 33,714 111,629 34,524 27,619 2018 North 2018 North 21,965 Budget July Budget August Budget September 2018 North Budget October 27,412 21,757 87,859 30,202 106,357 32,894 88,840 28,102 87,185 27,245 97,482 33,510 111,159 37,443 111,941 37,694 22,705 77,104 57,658 73,463 60,738 59,940 63,973 73,716 74,246 94,195 30,737 63,458 89,487 30,761 58,726 111,221 38,985 72,236 69,323 70,633 23,355 24,572 28,556 19,831 18,643 28,665 24,158 76,184 2018 North Budget November 2018 North Budget December 2018 North Actual January 2018 South Actual February 2018 South Actual March 2018 South Actual April 2018 South Actual May 2018 South Actual June 2018 South Actual July 2018 South Actual August 2018 South Actual September 2018 South Actual October 2018 South Actual November 2018 South Actual December 2018 South Budget January 2018 South Budget February 2018 South Budget March 2018 South Budget April 2018 South Budget May 2018 South Budget June 2018 South Budget July 2018 South Budget August 2018 South Budget September 2018 South Budget October 2018 South Budget November 2018 South Budget December 2018 South 101,884 32,561 103,315 32,681 110,297 34,112 117,782 37,258 87,589 29,494 94,438 29,873 104,357 34,053 99,000 45,000 99,000 45,000 99,000 45,000 99,000 45,000 99,000 45,000 4,014 3,452 3,661 3,289 1,813 3,633 4,062 5,850 2,285 4,958 3,729 3,440 3,151 2,108 3,411 2,404 1,788 1,927 5,492 1,000 1,000 1,000 1,000 1,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 98,000 45,000 98,000 45,000 98,000 45,000 98,000 45,000 98,000 45,000 98,000 45,000 98,000 45,000 80,525 58,095 64,565 70,303 54,000 54,000 54,000 54,000 54,000 53,000 53,000 53,000 53,000 53,000 53,000 53,000 26,356 26,153 25,239 21,450 19,273 24,167 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 5,505 3,038 2,196 3,015 2,393 2,270 2,336 3,440 4,283 2,776 2,610 3,726 2,416 2,636 3,138 2,776 2,360 2,505 3,625 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 1,750 6,463 6,285 6,083 6,931 6,296 6,280 7,342 7,442 7,137 7,357 7,399 7,032 7,476 7,216 7,290 7,240 7,070 7,014 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 Depreciation Utilities 3,24J 4,300 5,555 3,211 2,526 5,331 3,797 4,042 3,263 5,590 3,319 4,638 3,104 4,137 4,376 3,173 4,055 4,300 3,642 4,374 3,192 3,094 4,663 4,930 4,694 3,486 4,000 4,000 4,000 4,000 4,000 3,529 2,685 3,083 2,557 3,340 2,576 3,580 2,773 3,807 3,043 3,274 3,711 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 4,000 4,000 4,000 4,000 4,000 4,000 4,000 Freight Phone & Internet Packaging Bank and Moneris Marketing Other Exp Total Expenses 4,500 JZ4 4,UZI 4,143 506 2,416 530 1,151 2,071 906 1,645 1,405 1,090 3,618 533 557 545 546 633 704 605 667 625 718 756 679 630 762 5,400 3,349 4,393 5,318 4,442 4,359 3,899 2,223 5,597 4,710 2,685 4,449 1,675 2,621 1,508 1,229 1,846 2,729 1,302 2,288 2,388 3,435 3,071 3,913 3,699 3,905 3,387 3,581 4,771 3,891 3,900 4,150 4,146 3,169 4,920 3,774 4,043 4,076 3,177 3,349 2,636 3,191 3,554 2,616 2,924 5,558 6,716 2,826 4,474 4,449 5,094 4,133 4,412 5,889 5,255 2,833 5,218 1,535 1,535 1,535 1,535 4,075 3,099 5,515 2,356 UJ, 10J 62,376 53,097 62,352 57,450 53,677 55,189 63,184 68,325 53,841 52,673 67,069 59,799 63,010 63,576 63,772 56,463 51,808 62,526 41,722 41,722 41,722 41,722 41,722 41,694 41,694 41,694 41,694 41,694 41,694 41,694 2,628 3,778 4,174 3,567 723 753 750 750 2,250 4,000 2,250 4,000 750 2,250 4,000 750 2,250 4,000 750 4,000 750 4,000 750 4,000 750 4,000 1,535 1,519 1,519 1,519 1,519 1,519 1,519 1,519 4,000 4,000 4,000 4,000 3,653 2,452 3,351 4,119 3,769 3,688 3,384 3,898 4,884 4,575 4,435 4,843 2,949 3,286 4,767 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 750 750 750 750 2,235 1,770 1,195 2,043 1,238 1,238 1,238 1,238 1,238 1,225 1,225 1,225 1,225 1,225 1,225 1,225 2,250 2,250 2,250 2,250 2,250 2,250 2,250 2,250 Op Income 10,051 14,729 4,560 11,111 3,288 6,263 8,784 10,532 5,921 9,617 6,053 5,168 9,524 7,623 12,608 16,753 1,632 12,756 7,778 12,278 12,278 12,278 12,278 12,278 11,306 11,306 11,306 11,306 11,306 11,306 11,306 Interest Exp Net Income 0,00Z 10,287 4,023 4,442 3,126 1,434 4,460 6,651 4,149 -861 3,844 3,598 3,898 3,648 3,925 4,225 4,190 3,580 3,845 4,348 3,825 3,562 4,497 3,552 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 2,419 5,186 6,634 2,273 5,692 1,828 978 5,944 3,778 8,260 12,928 -1,930 8,259 4,226 7,478 7,478 7,478 7,478 7,478 6,506 6,506 6,506 6,506 6,506 6,506 6,506 Sales Sales Discounts Net Sales COGS Gross Margin Wages Fringe benefits Rent Depreciation Utilities Freight Phone & Internet Packaging Bank and Moneris Marketing Other Exp Total Expenses North Location 2017 2018 Actuals Actuals 2018 Budget South Location 2018 Actuals 2018 Budget