Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How to calculate for the Year 2018? And the Year 2019? And what is the Excel Formula for the Year 2018 and 2019? begin{tabular}{|c|c|c|c|c|c|c|c|c|} hline

How to calculate for the Year 2018? And the Year 2019? And what is the Excel Formula for the Year 2018 and 2019?

image text in transcribed \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \begin{tabular}{c} Products/ \\ Services \end{tabular} & 2016 & 2017 & \begin{tabular}{l} Rate of \\ Change \end{tabular} & 2018 & 2019 & \begin{tabular}{c} Average \\ Sales from \\ 20162019 \end{tabular} & \begin{tabular}{l} Total \\ Sales for \\ 2016-2019 \end{tabular} & \begin{tabular}{l} Market Share \\ for 2017 \end{tabular} \\ \hline \begin{tabular}{l} Banana \\ Muffin \end{tabular} & $8,500.00 & $11,050.00 & 0.3 & & & & & 36% \\ \hline \begin{tabular}{l} Chocolate \\ Chip \\ Muffin \end{tabular} & $7,360.25 & $8,000.00 & 0.09 & & & & & 26% \\ \hline \begin{tabular}{l} Lemon- \\ raspberry \\ streusel \\ Muffin \end{tabular} & $6,107.14 & $5,655.14 & -0.07 & & & & & 18% \\ \hline \begin{tabular}{l} Cinnamon \\ Muffin \end{tabular} & $5,500.17 & $4,600.25 & -0.16 & & & & & 15% \\ \hline \begin{tabular}{l} Blueberry \\ Muffin \end{tabular} & $1,011.05 & $1,640.95 & 0.62 & & & & & 5% \\ \hline \begin{tabular}{l} Total \\ Sales \end{tabular} & $28,478.61 & $30,946.34 & & & & & & 100% \\ \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

Accounting

Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren

23rd Edition

978-0324662962

More Books

Students also viewed these Accounting questions

Question

Contrast the methods employed by Titchener and Brentano.

Answered: 1 week ago