Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 ;)
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

ACCA Approved Study Text P7 Advanced Audit And Assurance

Authors: BPP

1st Edition

1472744349, 978-1472744340

More Books

Students also viewed these Accounting questions

Question

Who is responsible for preparing a company

Answered: 1 week ago

Question

L A -r- P[N]

Answered: 1 week ago