Plan finances for new business ventures in Australia Profit, loss and cash flow projections Monthly projected $ sales Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total Coffee regular $ 8,734 $ 9,170 $ 9,629 $ 10,110 $ 10,616 $ 11,677 $ 10,510 $ 11,035 $ 11,587 $ 12,166 $ 12,775 $ 13,413 $ 131,422 Coffee large $ 7,719 $ 8,105 $ 8,510 $ 8,936 $ 9,382 $ 10,321 $ 9,289 $ 9,753 $ 10,241 $ 10,753 $ 11,290 $ 11,855 $ 116,152 Bottled water $ 1,424 $ 1,495 $ 1,570 $ 1,648 $ 1,731 $ 1,904 $ 1,713 $ 1,799 $ 1,889 $ 1,983 $ 2,082 $ 2,187 $ 21,424 Banana cake $ 1,968 $ 2,067 $ 2,170 $ 2,278 $ 2,392 $ 2,632 $ 2,368 $ 2,487 $ 2,611 $ 2,742 $ 2,879 $ 3,023 $ 29,617 Carrot cake $ 2,150 $ 2,257 $ 2,370 $ 2,489 $ 2,613 $ 2,874 $ 2,587 $ 2,716 $ 2,852 $ 2,995 $ 3,144 $ 3,302 $ 32,348 Choc chip cookie $ 2,331 $ 2,448 $ 2,570 $ 2,699 $ 2,834 $ 3,117 $ 2,805 $ 2,946 $ 3,093 $ 3,247 $ 3,410 $ 3,580 $ 35,079 Total sales dollars $ 24,325 $ 25,542 $ 26,819 $ 28,160 $ 29,568 $ 32,524 $ 29,272 $ 30,736 $ 32,272 $ 33,886 $ 35,580 $ 37,359 $ 366,042 Total operating expenses $21,340 $22,007 $22,707 $23,441 $24,213 $25,983 $24,051 $24,853 $25,695 $26,579 $27,508 $28,483 $296,711 Projected Net Profit $2,984 94 $3,534 72 $4,112 00 $4,718 14 $5,354 59 $6,541 13 $5,220 93 $5,882 52 $6,577 19 $7,306 58 $8,072 45 $8,876 62 $ 69,332 1 Please help to determine the break even point by adjusting the 'Number of Items Sold' in below table until the break even figure in reaches zero or just above zero the break even point regular coffee sales quantities large coffee sales quantities retail pre packaged product sales quantities Break Even Analysis Regular Coffee Large Coffee Retail Pre packaged Products Total Number of Coffees Sold 0 Marked Up Price $3 31 $4 39 $7 53 $5 07 Total Sales $0 00 $0 00 $0 00 $0 00 Total Operating Expenses $296,711 Break even $296,710 61

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on May 11, 2024

Plan finances for new business ventures in Australia Profit, loss and cash flow projections Monthly projected $ sales Jul Aug Sep Oct Nov

Plan finances for new business ventures in Australia Profit, loss and cash flow projections

	Monthly projected $ sales
	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Total
Coffee regular	$ 8,734	$ 9,170	$ 9,629	$ 10,110	$ 10,616	$ 11,677	$ 10,510	$ 11,035	$ 11,587	$ 12,166	$ 12,775	$ 13,413	$ 131,422
Coffee large	$ 7,719	$ 8,105	$ 8,510	$ 8,936	$ 9,382	$ 10,321	$ 9,289	$ 9,753	$ 10,241	$ 10,753	$ 11,290	$ 11,855	$ 116,152
Bottled water	$ 1,424	$ 1,495	$ 1,570	$ 1,648	$ 1,731	$ 1,904	$ 1,713	$ 1,799	$ 1,889	$ 1,983	$ 2,082	$ 2,187	$ 21,424
Banana cake	$ 1,968	$ 2,067	$ 2,170	$ 2,278	$ 2,392	$ 2,632	$ 2,368	$ 2,487	$ 2,611	$ 2,742	$ 2,879	$ 3,023	$ 29,617
Carrot cake	$ 2,150	$ 2,257	$ 2,370	$ 2,489	$ 2,613	$ 2,874	$ 2,587	$ 2,716	$ 2,852	$ 2,995	$ 3,144	$ 3,302	$ 32,348
Choc chip cookie	$ 2,331	$ 2,448	$ 2,570	$ 2,699	$ 2,834	$ 3,117	$ 2,805	$ 2,946	$ 3,093	$ 3,247	$ 3,410	$ 3,580	$ 35,079
Total sales dollars	$ 24,325	$ 25,542	$ 26,819	$ 28,160	$ 29,568	$ 32,524	$ 29,272	$ 30,736	$ 32,272	$ 33,886	$ 35,580	$ 37,359	$ 366,042


Total operating expenses	$21,340	$22,007	$22,707	$23,441	$24,213	$25,983	$24,051	$24,853	$25,695	$26,579	$27,508	$28,483	$296,711

Projected Net Profit	$2,984.94	$3,534.72	$4,112.00	$4,718.14	$5,354.59	$6,541.13	$5,220.93	$5,882.52	$6,577.19	$7,306.58	$8,072.45	$8,876.62	$ 69,332

1. Please help to determine the break-even point by adjusting the 'Number of Items Sold' in below table until the break-even figure in reaches zero or just above zero: the break-even point:

regular coffee sales quantities
large coffee sales quantities
retail pre-packaged product sales quantities

Break-Even Analysis


	Regular Coffee	Large Coffee	Retail Pre-packaged Products	Total
Number of Coffees Sold				0
Marked Up Price	$3.31	$4.39	$7.53	$5.07
Total Sales	$0.00	$0.00	$0.00	$0.00


Total Operating Expenses	$296,711
Break-even	-$296,710.61