assignment

profilegoog
unit-i_.xls
Home>Business & Finance homework help>Marketing homework help>assignment

Unit

Year 2014
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 0 0 0 10 10 15 15 25 25 27 25 25 177
Tim Hortan 0 0 8 8 10 10 20 20 30 20 20 146
Costa   0 0 0 8 10 10 10 15 15 20 15 15 118
Total 0 0 0 26 28 35 35 60 60 77 60 60 441
Year 2015
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 10 10 14 17 17 17 25 27 27 30 33 33 260
Tim Hortan 10 10 15 15 17 20 20 23 25 27 27 27 236
Costa   8 8 10 10 13 13 16 16 20 20 20 20 174
Total 28 28 39 42 47 50 61 66 72 77 80 80 670
Year 2016
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 18 18 23 23 23 23 27 27 33 37 50 50 352
Tim Hortan 15 15 17 20 20 25 25 28 33 35 40 40 313
Costa   13 13 15 15 17 20 24 23 30 35 35 35 275
Total 46 46 55 58 60 68 76 78 96 107 125 125 940

Price Canada

Unit Price 120
Year 2014
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks - 0 - 0 - 0 1,200 1,200 1,800 1,800 3,000 3,000 3,240 3,000 3,000 21,240
Tim Hortan - 0 - 0 - 0 960 960 1,200 1,200 2,400 2,400 3,600 2,400 2,400 17,520
Costa   - 0 - 0 - 0 960 1,200 1,200 1,200 1,800 1,800 2,400 1,800 1,800 14,160
Total - 0 - 0 - 0 3,120 3,360 4,200 4,200 7,200 7,200 9,240 7,200 7,200 52,920
Year 2015
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 1,200 1,200 1,680 2,040 2,040 2,040 3,000 3,240 3,240 3,600 3,960 3,960 31,200
Tim Hortan 1,200 1,200 1,800 1,800 2,040 2,400 2,400 2,760 3,000 3,240 3,240 3,240 28,320
Costa   960 960 1,200 1,200 1,560 1,560 1,920 1,920 2,400 2,400 2,400 2,400 20,880
Total 3,360 3,360 4,680 5,040 5,640 6,000 7,320 7,920 8,640 9,240 9,600 9,600 80,400
Year 2016
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 2,160 2,160 2,760 2,760 2,760 2,760 3,240 3,240 3,960 4,440 6,000 6,000 42,240
Tim Hortan 1,800 1,800 2,040 2,400 2,400 3,000 3,000 3,360 3,960 4,200 4,800 4,800 37,560
Costa   1,560 1,560 1,800 1,800 2,040 2,400 2,880 2,760 3,600 4,200 4,200 4,200 33,000
Total 5,520 5,520 6,600 6,960 7,200 8,160 9,120 9,360 11,520 12,840 15,000 15,000 112,800

Price Brazilin Real

1CAD 2.65 BRL
Year 2014
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks - 0 - 0 - 0 3,180 3,180 4,770 4,770 7,950 7,950 8,586 7,950 7,950 56,286
Tim Hortan - 0 - 0 - 0 2,544 2,544 3,180 3,180 6,360 6,360 9,540 6,360 6,360 46,428
Costa   - 0 - 0 - 0 2,544 3,180 3,180 3,180 4,770 4,770 6,360 4,770 4,770 37,524
Total - 0 - 0 - 0 8,268 8,904 11,130 11,130 19,080 19,080 24,486 19,080 19,080 280,476
Year 2015
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 3,180 3,180 4,452 5,406 5,406 5,406 7,950 8,586 8,586 9,540 10,494 10,494 82,680
Tim Hortan 3,180 3,180 4,770 4,770 5,406 6,360 6,360 7,314 7,950 8,586 8,586 8,586 75,048
Costa   2,544 2,544 3,180 3,180 4,134 4,134 5,088 5,088 6,360 6,360 6,360 6,360 55,332
Total 8,904 8,904 12,402 13,356 14,946 15,900 19,398 20,988 22,896 24,486 25,440 25,440 426,120
Year 2016
Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Starbucks 5,724 5,724 7,314 7,314 7,314 7,314 8,586 8,586 10,494 11,766 15,900 15,900 111,936
Tim Hortan 4,770 4,770 5,406 6,360 6,360 7,950 7,950 8,904 10,494 11,130 12,720 12,720 99,534
Costa   4,134 4,134 4,770 4,770 5,406 6,360 7,632 7,314 9,540 11,130 11,130 11,130 87,450
Total 14,628 14,628 17,490 18,444 19,080 21,624 24,168 24,804 30,528 34,026 39,750 39,750 597,840

Cash budget

2014
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Initial Cash - 0 58,100 51,200 44,300 41,190 38,371 36,572 34,773 36,618 38,463 42,786 44,631
Bank Note 65,000 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Incoming Cash revenue - 0 - 0 - 0 8,268 8,904 11,130 11,130 19,080 19,080 24,486 19,080 19,080 140,238
Total Cash Availiable 65,000 58,100 51,200 52,568 50,094 49,501 47,702 53,853 55,698 62,949 61,866 63,711
expenses
COGS - 0 - 0 - 0 4,479 4,823 6,029 6,029 10,335 10,335 13,263 10,335 10,335 75,962
Salaries 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200
Utilities 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200
Taxes
Rent 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500
Transportation 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Total Cash Out 6,900 6,900 6,900 11,379 11,723 12,929 12,929 17,235 17,235 20,163 17,235 17,235 158,762
Ending Cash 58,100 51,200 44,300 41,190 38,371 36,572 34,773 36,618 38,463 42,786 44,631 46,476
2015
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Initial Cash 46,476 43,457 40,438 39,022 38,044 37,794 37,981 39,772 42,292 45,686 49,808 54,368
Bank Note - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Incoming Cash revenue 8,904 8,904 12,402 13,356 14,946 15,900 19,398 20,988 22,896 24,486 25,440 25,440 213,060
Total Cash Availiable 55,380 52,361 52,840 52,378 52,990 53,694 57,379 60,760 65,188 70,172 75,248 79,808
expenses
COGS 4,823 4,823 6,718 7,235 8,096 8,613 10,507 11,369 12,402 13,263 13,780 13,780 115,408
Salaries 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500
Utilities 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200
Taxes
Rent 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400
Transportation 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Total Cash Out 11,923 11,923 13,818 14,335 15,196 15,713 17,607 18,469 19,502 20,363 20,880 20,880 200,608
Ending Cash 43,457 40,438 39,022 38,044 37,794 37,981 39,772 42,292 45,686 49,808 54,368 58,928
2016
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Initial Cash 58,928 57,314 55,699 55,158 54,975 55,030 56,039 58,002 60,203 64,551 70,211 78,017
Bank Note - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Incoming Cash revenue 14,628 14,628 17,490 18,444 19,080 21,624 24,168 24,804 30,528 34,026 39,750 39,750 298,920
Total Cash Availiable 73,556 71,942 73,189 73,602 74,055 76,654 80,207 82,806 90,731 98,577 109,961 117,767
expenses
COGS 9,143 9,143 10,931 11,528 11,925 13,515 15,105 15,503 19,080 21,266 24,844 24,844 186,825
Salaries 3,700 3,700 3,700 3,700 3,700 3,700 3,700 3,700 3,700 3,700 3,700 3,700
Utilities 900 900 900 900 900 900 900 900 900 900 900 900
Taxes
Rent 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500
Transportation 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Total Cash Out 16,243 16,243 18,031 18,628 19,025 20,615 22,205 22,603 26,180 28,366 31,944 31,944 272,025
Ending Cash 57,314 55,699 55,158 54,975 55,030 56,039 58,002 60,203 64,551 70,211 78,017 85,823

income statement

2014 2015 2016
sales 140,238 213,060 298,920
COGS 75,962 115,408 186,825
Gross Margin 64,276 97,653 112,095
SG&A cost 82,800 85,200 85,200
EBITDA (18,524) 12,453 26,895
Interest Expenses
Icome tax (25%) (4,631) 3,113 6,724
Net Icome/Loss (13,893) 9,339 20,171