Question: begin { tabular } { | l | l | l | l | } hline Month - & Units sold - &

\begin{tabular}{|l|l|l|l|}
\hline Month - & Units sold - & Sales Revenu - & Net operating incom \\
\hline Jan-19 & 782 & 46,920 & 20\\
\hline Feb-19 & 825 & 49,500 & 1,224\\
\hline Mar-19 & 846 & 50,760 & 1,812\\
\hline Apr-19 & 950 & 57,000 & 4,724\\
\hline May-19 & 1,200 & 72,000 & 11,724\\
\hline Jun-19 & 1,450 & 87,000 & 18,724\\
\hline Jul-19 & 1,435 & 86,100 & 12,564\\
\hline Aug-19 & 1,682 & 100,920 & 18,492\\
\hline Sep-19 & 1,695 & 101,700 & 18,804\\
\hline Oct-19 & 1,761 & 105,660 & 20,388\\
\hline Nov-19 & 1,925 & 115,500 & 24,324\\
\hline Dec-19 & 2,400 & 144,000 & 35,724\\
\hline Jan-20 & 2,306 & 166,032 & 61,140\\
\hline Feb-20 & 2,612 & 188,064 & 72,156\\
\hline Mar-20 & 2,895 & 208,440 & 70,764\\
\hline Apr-20 & 3,042 & 219,024 & 75,468\\
\hline May-20 & 3,126 & 225,072 & 78,156\\
\hline Jun-20 & 3,680 & 264,960 & 95,884\\
\hline Jul-20 & 4,111 & 295,992 & 109,676\\
\hline Aug-20 & 4,687 & 337,464 & 121,108\\
\hline Sep-20 & 5,067 & 364,824 & 143,402\\
\hline Oct-20 & 5,249 & 377,928 & 149,590\\
\hline Nov-20 & 5,825 & 419,400 & 169,174\\
\hline Dec-20 & 6,030 & 434,160 & 176,144\\
\hline
\end{tabular} chart. cursor on a bar (make sure all bars are highlighted), right click and select Add data labels.
c. Sort bar chart from the largest expenditure to the smallest.
d. Using your data visualization, answer the following questions.
1. What are the top three revenue sources and dollar amounts for the General fund in 2022?
Note: Enter your answers with two decimal places and do not round your answers.
2. What is the dollar amount of revenue for the category "Cigarettes and Tobacco"?
Note: Enter your answer with two decimal places and do not round your answer. Select \% of Grand Total.
Note: Show your percentages with two decimal places such as \(18.56\%\). to the smallest dollar amounts. Note: Round your answers to two decimal places, this time rounded to the nearest million dollar.
f. What are some strengths and weaknesses of using the incremental approach to budgeting?
Advantages:
Simplified process: assumes that the base of the budget is
and only focuses on the whether the amount is accurate.
Disadvantages:
An incremental budgeting process does not encourage analysis of the budget.
\ begin { tabular } { | l | l | l | l | } \ hline

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 Finance Questions!