I need to be able to calculate the break-even ($0) at month's end. The problem is that as Gross Revenue increases, Parts Cost increases.....
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 71px"><col width="97"><col width="72"><col width="99"><col width="143"><col width="79"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Year One Monthly Revenue Break Even Number
[/TD]
[TD="align: center"]$52,217.42[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6AA84F]#6AA84F[/URL] , align: center"]Gross Revenue[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF0000]#FF0000[/URL] , align: center"]50% Parts[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF0000]#FF0000[/URL] , align: center"]Monthly Liability[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF0000]#FF0000[/URL] , align: center"]Total Liability[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1C4587]#1C4587[/URL] , align: center"]Month End[/TD]
[/TR]
[TR]
[TD]December[/TD]
[TD="align: center"]$40,000.00[/TD]
[TD="align: center"]$20,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$46,108.71[/TD]
[TD="align: center"]-$6,108.71[/TD]
[/TR]
[TR]
[TD]January[/TD]
[TD="align: center"]$40,000.00[/TD]
[TD="align: center"]$20,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$46,108.71[/TD]
[TD="align: center"]-$6,108.71[/TD]
[/TR]
[TR]
[TD]February[/TD]
[TD="align: center"]$60,000.00[/TD]
[TD="align: center"]$30,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$56,108.71[/TD]
[TD="align: center"]$3,891.29[/TD]
[/TR]
[TR]
[TD]March[/TD]
[TD="align: center"]$60,000.00[/TD]
[TD="align: center"]$30,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$56,108.71[/TD]
[TD="align: center"]$3,891.29[/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD="align: center"]$60,000.00[/TD]
[TD="align: center"]$30,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$56,108.71[/TD]
[TD="align: center"]$3,891.29[/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD="align: center"]$100,000.00[/TD]
[TD="align: center"]$50,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$76,108.71[/TD]
[TD="align: center"]$23,891.29[/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD="align: center"]$100,000.00[/TD]
[TD="align: center"]$50,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$76,108.71[/TD]
[TD="align: center"]$23,891.29[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD="align: center"]$100,000.00[/TD]
[TD="align: center"]$50,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$76,108.71[/TD]
[TD="align: center"]$23,891.29[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD="align: center"]$100,000.00[/TD]
[TD="align: center"]$50,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$76,108.71[/TD]
[TD="align: center"]$23,891.29[/TD]
[/TR]
[TR]
[TD]September[/TD]
[TD="align: center"]$100,000.00[/TD]
[TD="align: center"]$50,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$76,108.71[/TD]
[TD="align: center"]$23,891.29[/TD]
[/TR]
[TR]
[TD]October[/TD]
[TD="align: center"]$70,000.00[/TD]
[TD="align: center"]$35,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$61,108.71[/TD]
[TD="align: center"]$8,891.29[/TD]
[/TR]
[TR]
[TD]November[/TD]
[TD="align: center"]$70,000.00[/TD]
[TD="align: center"]$35,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$61,108.71[/TD]
[TD="align: center"]$8,891.29[/TD]
[/TR]
[TR]
[TD]December[/TD]
[TD="align: center"]$70,000.00[/TD]
[TD="align: center"]$35,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$61,108.71[/TD]
[TD="align: center"]$8,891.29[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: center"]$970,000.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]$824,413.21[/TD]
[TD="align: center"]$145,586.79[/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 71px"><col width="97"><col width="72"><col width="99"><col width="143"><col width="79"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Year One Monthly Revenue Break Even Number
[/TD]
[TD="align: center"]$52,217.42[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6AA84F]#6AA84F[/URL] , align: center"]Gross Revenue[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF0000]#FF0000[/URL] , align: center"]50% Parts[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF0000]#FF0000[/URL] , align: center"]Monthly Liability[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF0000]#FF0000[/URL] , align: center"]Total Liability[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1C4587]#1C4587[/URL] , align: center"]Month End[/TD]
[/TR]
[TR]
[TD]December[/TD]
[TD="align: center"]$40,000.00[/TD]
[TD="align: center"]$20,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$46,108.71[/TD]
[TD="align: center"]-$6,108.71[/TD]
[/TR]
[TR]
[TD]January[/TD]
[TD="align: center"]$40,000.00[/TD]
[TD="align: center"]$20,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$46,108.71[/TD]
[TD="align: center"]-$6,108.71[/TD]
[/TR]
[TR]
[TD]February[/TD]
[TD="align: center"]$60,000.00[/TD]
[TD="align: center"]$30,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$56,108.71[/TD]
[TD="align: center"]$3,891.29[/TD]
[/TR]
[TR]
[TD]March[/TD]
[TD="align: center"]$60,000.00[/TD]
[TD="align: center"]$30,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$56,108.71[/TD]
[TD="align: center"]$3,891.29[/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD="align: center"]$60,000.00[/TD]
[TD="align: center"]$30,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$56,108.71[/TD]
[TD="align: center"]$3,891.29[/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD="align: center"]$100,000.00[/TD]
[TD="align: center"]$50,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$76,108.71[/TD]
[TD="align: center"]$23,891.29[/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD="align: center"]$100,000.00[/TD]
[TD="align: center"]$50,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$76,108.71[/TD]
[TD="align: center"]$23,891.29[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD="align: center"]$100,000.00[/TD]
[TD="align: center"]$50,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$76,108.71[/TD]
[TD="align: center"]$23,891.29[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD="align: center"]$100,000.00[/TD]
[TD="align: center"]$50,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$76,108.71[/TD]
[TD="align: center"]$23,891.29[/TD]
[/TR]
[TR]
[TD]September[/TD]
[TD="align: center"]$100,000.00[/TD]
[TD="align: center"]$50,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$76,108.71[/TD]
[TD="align: center"]$23,891.29[/TD]
[/TR]
[TR]
[TD]October[/TD]
[TD="align: center"]$70,000.00[/TD]
[TD="align: center"]$35,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$61,108.71[/TD]
[TD="align: center"]$8,891.29[/TD]
[/TR]
[TR]
[TD]November[/TD]
[TD="align: center"]$70,000.00[/TD]
[TD="align: center"]$35,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$61,108.71[/TD]
[TD="align: center"]$8,891.29[/TD]
[/TR]
[TR]
[TD]December[/TD]
[TD="align: center"]$70,000.00[/TD]
[TD="align: center"]$35,000.00[/TD]
[TD="align: center"]$26,108.71[/TD]
[TD="align: center"]$61,108.71[/TD]
[TD="align: center"]$8,891.29[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: center"]$970,000.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]$824,413.21[/TD]
[TD="align: center"]$145,586.79[/TD]
[/TR]
</tbody>[/TABLE]