Question: Please help! I need the specific formulas that go into the cells in excel please please please! thank you ;) A B C D E

Please help! I need the specific formulas that go into the cells in excel please please please! thank you ;)
Please help! I need the specific formulas that go into the cells

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} Cost per unit 4 Variable cost per unit Fixed cost per unit Total cost per unit 519.75 \begin{tabular}{l} ? \\ ? \\ \hline \end{tabular} 7 \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}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!