Hello, please see the attached. I am looking for an understanding of how to produce a break-even analysis based on the information as attached.
A B C E F G H K M March April May June QTRI July August Sept QTR Z Monthly Income / Receipts :" Google Ads : # clicks / week 500 500 500 500 500 500 Google Ads : # clicks / month 2000 2000 2000 2000 2000 2000 # clicks resulting in sales 10% 10% 20% 20% 20% 10% # T-shirts / month 200 200 400 400 400 200 Sale Price per T-shirt $30 $30 $30 OES $30 $30 Projected Monthly Income $6 , 000 . 00 $6 , 000 . 00 $12 , 000 . 00* $24 , 000 . 00 $12 , 000 . 00 $12 , 000 . 00 $6 , 000 . 00* $30 , 000 . 00 Expenses / Disbursements :" Fixed Expenses Business Support Services ( $80. 00 ) ( $80. 00 ) ( $80.00 ) ($80. 00 ) ( $80. 00 ) ( $80.00 ) Business Phone System ( $ 20. 00 ) ( $ 20. 00 ) ( $ 20.00 ) ( $ 20. 00 ) ( $ 20. 00 ) ( $ 20. 00 ) Total Monthly Fixed Expenses ( $ 100 . 00 ) ( $ 100. 00 ) ( $ 100 . 00 ) ( $ 100 . 00 ) ( $ 100. 00 ) ( $ 100 . 00 ) Variable Expenses Register / Incorporate Business ( $ 200. 00 ) Cost of T-shirts Sold @ $8 each ( $1 , 600. 00 ) ( $ 1 , 600 . 00 ) ( $3 , 200 . 00 ) ( $3, 200.00 ) ( $3 , 200. 00 ) ( $1 , 600 . 00 ) Google Add @ avg of $1 . 50 / click / month ($3, 000 . 00 ) ( $3 , 000 .00 ) ( $3 , 000. 00 ) ($3, 000. 00 ) ( $3 , 000 . 00 ) ( $3 , 000 . 00 ) Total Variable Expenses ( $4 , 800.00 ) ( 5 4 , 600. 00 ) ( 56 , 200. 00 ) ( 56 , 200. 00 ) ( 56 , 200.00 ) ( $ 4 , 600. 00 ) Total Monthly Expenses / Disbursements (54, 900.00 ) ( 54 , 700.00 ) ( 56 , 300.00 )" ( $ 15 , 900.00 ) ( 56 , 300 .00 ) ( 56 , 300 .00 ) ( $4 , 700 .00 )" ( $17 , 300 . 00 ) Net Profit / Loss $1 , 100. 00 | $1 , 300 . 00 $5 , 700 . 00 $8 , 100 . 00 $5 , 700 . 00\\ $5 , 700 . 00 $1 , 300 . 00 $12 , 700 . 00 Initial Investment from Team Members $10 , 000 Less Quarterly Profit Distributed to Team / Investors (58 , 100. 00 ) Cash Balance $10 , 000. 00 $11 , 100. 00 $12 , 400. 00 $18 , 100. 00* $18 , 100 . 00| $23 , 800. 00 | $29, 500. 00 $30 , 800. 00" $22, 700 . 00