Hi Tutor,

 

Needing assistance with the below question please. 

 

Within your 'Product Pricing Worksheet' locate the 'Projected Cash Flow' tab and record below the maximum monthly cash flow shortfall for any month in the year (known as the Working Capital requirement):

 

 

Projected Cash Flowfor the year ended 30 JuneJulAugSepOctNovDecJanFebMarAprMayJunTotal yrCash inflowsCofee regular$8,415 $8,415 $ 8,415 $8,415 $8,415 $8,415 $8,415 $8,415 $8,415 $8,415 $ 8,415 $Coffee Large7,064$7,064 $8,415 $ 100,9837,064 $7,064| $7,064 | $7,064 $7,064$7,064 $7.064 $7,064$7,064$7,064S84,764Botled water3,743 $3,743 $3,743 $3,743 $3,743 $3,743| $3,743 $3,743 $3,743 | $3,743 $Banana cakeS2,563 $3,743 $2,563 $3,743 $44,9102,563 $2,563 | $2,563 | $2,563 | $2,563 |$2,563 $2,563 $2,563| $2,563 $2,563 $Carrot cake30,7531,776 $1,776 $1,776 $1,776 $1,776 $1,7761,776 $S1,776 $1,776 $1,776 $Choc chip cookie3,707 $1,776 $3,707 $1,776 $ 21,3153,707 $3,707 $3,707 $3,707 $3,707 $3,707 $3,707 $3,707 $3,707 $3,707 $ 44,481Total cash inflows$ 27,267 $ 27,267$ 27,267 $ 27,267 $ 27,267 $ 27,267$ 27,267$ 27,267 $ 27,267 $ 27,267 $ 27,2677 $ 27,267 $327,208Cash outflowsStart up costs (less $5,000 in savings)$ 23,417 $S - $Coffee (variable costs)-$ 23,417- Raw materials and labour7,096 $7,096 $ 7,096 $7,096 $ 7,096 $ 7,096 $7,096 $7,096 $ 7,096 $7,096 $ 7,096 $Purchase price of retail pre pkgd products7,096 $ 85,150- Bottled waterS2,925 $2,925 $2,925 $2,925 $2,925|$2,925 $2,925 $2,925 $2,925 $2,925 $2,925 $2,925 $- Banana cake35, 1001,853 $1,853 $1,853 $1,853 $1,853 s1,853 $1,853 S1,853 $1,853 $1,853 s- Carrot cake$1,138 $1,853 $1,85322,2301,138 $1,138 |$1,138 $1,138 $1,138 $1,138 $1,138 $1,138 $1,138 $1,138 $- Choc chip cookie1,138 $S13,6502,893 $2,893 $2,893 $2,893 $2,893 s2,893 S2,893 $2,893 $2,893 $Fixed costs2,893 $ 2,893 $2,893 $ 34,710- RentS3,100 $3,100 $ 3,100 $3, 100 $3,100 $3,100 $3,100 $$ 3,100 $3,100 $ 3,100 $ 3,100 $- Electricity3,100 $ 37,200$200 $200 $200 $200 $200 | $200 S200 $200 | $200 | $200 S200 $$200 | $- Coffee machine servicing2,40S$$200 $$$$S- Internet service80 $BOS80 s80 S80 $8080 $80 $80 $80 S80 $80 $- Bank fees960$60 S60 $60 | $60 $60 $60 $60 $60 S60 $60 $60 | $60 S- MarketingS500 $720500 $500 | $500 $500 $500 $500 $500 $500 | $500 $500 | $-Barista (full time)500 $6,004,333 $4,333 $4,333 $4,333 $4,333 $4,333 |$4,333 $4,333 $4,333 $4,333 $4,333 $4,333 S52,000Total cash outflows$ 47,593 $ 24,177 $ 24,177$ 24,177 $ 24,177 $ 24,377 $ 24,177 $ 24,177 $ 24,177 $ 24,177 $ 24,177 $ 24,177 $ 313,537Net cash flows$20,326$3.091$3.091$3.091$3,091$2,891$3.091$3.091$3.091$3,091$3.091$3.091$13,471Beginning cash balance$5,000$15,326-$12,235$9,145$6,054$2,963-$73$3,018$6,109$9,199$12,290$15,380Ending cash balance$15,326-$12,235$9,145$6,054$2,963$73$3,018$6,109$9,199$12,290$15,380$18,471