please help. I need the FORMULAS to plug into the cells! Thank you!!

Parker, Incorporated produces one model of mountain bike. Partial information for the company follows: Complete the template worksheet filling in all of the following: 1. Total variable costs for each sales level 2. Total fixed costs for each sales level 3. Total costs for each sales level 4. Variable cost per unit for each sales level 5. Fixed cost per unit for each sales level 6. Total cost per unit for each sales level 7. Contribution margin ratio for each sales level, using a sales price of 710 per unit. 8. Total contribution margin for each sales level 9. Breakeven units 15 Complete the template worksheet filling in all of the following: 1. Total variable costs for each sales level 2. Total fixed costs for each sales level 3. Total costs for each sales level 4. Variable cost per unit for each sales level 5. Fixed cost per unit for each sales level 6. Total cost per unit for each sales level 7. Contribution margin ratio for each sales level, using a sales price of 710 per unit. 8. Total contribution margin for each sales level 9. Breakeven units 10. Breakeven sales revenue 11. Prepare the GAAP (absorption costing) income statement if selling, general, and administrative costs are $30,000. Recall that you have already solved for total costs, previously. 12. How many units should Parker, Inc sell AND what should the sales revenue be in order to earn a profit of $220,000 ? A B C D E F G Sales Price 710.00 \begin{tabular}{|c|c|c|c|} \hline Number of bikes produced and sold & 500 & 750 & 960 \\ \hline \multicolumn{4}{|l|}{ Total costs } \\ \hline Variable costs & 116,000.00 & ? & ? \\ \hline Fixed costs per year & ? & ? & ? \\ \hline Total costs & ? & ? & ? \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline Cost per unit & ? & ? & ? \\ \hline Variable cost per unit & ? & ? & ? \\ \hline Fixed cost per unit & ? & 519.75 & ? \\ \hline Total cost per unit & ? & ? & ? \\ \hline \end{tabular} 7. 8 \begin{tabular}{|c|c|c|c|} \hline Contribution Margins & 500 & 750 & 960 \\ \hline Contribution Margin Ratio & ? & ? & ? \\ \hline Total Contribution Margin & ? & ? & ? \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Break-even Analysis \\ \hline Units & ? \\ \hline Sales revenue & ? \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & A & B & C & D & E \\ \hline 20 & & \multicolumn{2}{|l|}{ Break-even Analysis } & & \\ \hline 21 & 9 & Units & ? & & \\ \hline 22 & 10 & Sales revenue & ? & & \\ \hline 23 & & & & & \\ \hline 24 & & & & & \\ \hline 25 & 11 & \multicolumn{2}{|l|}{ Income Statement } & & \\ \hline 26 & & Units & 500 & 750 & 960 \\ \hline 27 & & & & & \\ \hline 28 & & Sales revenue & ? & ? & ? \\ \hline 29 & & Cost of goods sold & ? & ? & ? \\ \hline 30 & & Gross profit & ? & ? & ? \\ \hline 31 & & Selling, general, \& administrative exf & ? & ? & ? \\ \hline 32 & & Net operating income (loss) & ? & ? & ? \\ \hline 33 & & & & & \\ \hline 34 & & Target Profit of & 220,000.00 & & \\ \hline 35 & 12 & Units & ? & & \\ \hline 36 & & Sales revenue & ? & & \\ \hline 37 & & & & & \\ \hline 38 & & & & & \\ \hline 39 & & & & & \\ \hline \end{tabular}