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>
<colgroup><col style="width: 71px"><col width="97"><col width="72"><col width="99"><col width="143"><col width="79"></colgroup><tbody>
</tbody>
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
| Year One Monthly Revenue Break Even Number | $52,217.42 | ||||
| Gross Revenue | 50% Parts | Monthly Liability | Total Liability | Month End | |
| December | $40,000.00 | $20,000.00 | $26,108.71 | $46,108.71 | -$6,108.71 |
| January | $40,000.00 | $20,000.00 | $26,108.71 | $46,108.71 | -$6,108.71 |
| February | $60,000.00 | $30,000.00 | $26,108.71 | $56,108.71 | $3,891.29 |
| March | $60,000.00 | $30,000.00 | $26,108.71 | $56,108.71 | $3,891.29 |
| April | $60,000.00 | $30,000.00 | $26,108.71 | $56,108.71 | $3,891.29 |
| May | $100,000.00 | $50,000.00 | $26,108.71 | $76,108.71 | $23,891.29 |
| June | $100,000.00 | $50,000.00 | $26,108.71 | $76,108.71 | $23,891.29 |
| July | $100,000.00 | $50,000.00 | $26,108.71 | $76,108.71 | $23,891.29 |
| August | $100,000.00 | $50,000.00 | $26,108.71 | $76,108.71 | $23,891.29 |
| September | $100,000.00 | $50,000.00 | $26,108.71 | $76,108.71 | $23,891.29 |
| October | $70,000.00 | $35,000.00 | $26,108.71 | $61,108.71 | $8,891.29 |
| November | $70,000.00 | $35,000.00 | $26,108.71 | $61,108.71 | $8,891.29 |
| December | $70,000.00 | $35,000.00 | $26,108.71 | $61,108.71 | $8,891.29 |
| $970,000.00 | $824,413.21 | $145,586.79 |
<colgroup><col style="width: 71px"><col width="97"><col width="72"><col width="99"><col width="143"><col width="79"></colgroup><tbody>
</tbody>
