Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help with graph 3. The final chart the CEO would like to see a chart which indicates what percentage of US sales occurred each

need help with graph
image text in transcribed
image text in transcribed
3. The final chart the CEO would like to see a chart which indicates what percentage of US sales occurred each quarter for 2022 . This will require that you consolidate the data. Place the consolidated data necessary for this chart in a different area of the original worksheet. Use the same column titles but this new table will only have 8 rows (one row for each quarter of each year). Be sure to follow the charting checklist for the type of chart you selected to complete this task. This is in canvas in the module for the charting class. \begin{tabular}{|r|r|r|r|r|r|r|} \hline Month & US Sales & Other Sales & Total Sales & Sales & Goods Sold & Gross Profit \\ \hline Jan-21 & $6,989,238 & $199,693 & $7,188,931 & $6,829,484 & $3,235,019 & $3,953,912 \\ \hline Feb-21 & $7,729,650 & $220,847 & $7,950,497 & $7,234,952 & $3,577,724 & $4,372,773 \\ \hline Mar-21 & $6,038,549 & $172,530 & $6,211,079 & $6,335,301 & $2,794,986 & $3,416,093 \\ \hline Apr-21 & $5,484,312 & $365,621 & $5,849,933 & $5,876,257 & $2,632,470 & $3,217,463 \\ May-21 & $8,551,452 & $244,327 & $8,795,779 & $8,268,032 & $3,958,101 & $4,837,678 \\ \hline Jun-21 & $8,238,174 & $235,376 & $8,473,550 & $8,261,712 & $3,813,098 & $4,660,452 \\ \hline Jul-21 & $8,831,025 & $252,315 & $9,083,340 & $9,265,007 & $4,087,503 & $4,995,837 \\ \hline Aug-21 & $6,924,096 & $197,831 & $7,121,927 & $6,409,735 & $3,204,867 & $3,917,060 \\ \hline Sep-21 & $13,085,376 & $654,269 & $13,739,645 & $14,770,118 & $6,182,840 & $7,556,805 \\ \hline Oct-21 & $8,230,572 & $235,159 & $8,465,731 & $7,195,872 & $3,809,579 & $4,656,152 \\ \hline Nov-21 & $12,352,014 & $352,915 & $12,704,929 & $12,692,224 & $5,717,218 & $6,987,711 \\ \hline Dec-21 & $8,246,180 & $235,605 & $8,481,785 & $8,142,514 & $3,816,803 & $4,664,982 \\ \hline Jan-22 & $12,531,645 & $358,047 & $12,889,692 & $13,405,280 & $5,800,361 & $7,089,331 \\ \hline Feb-22 & $11,636,328 & $332,467 & $11,968,795 & $12,208,170 & $5,385,958 & $6,582,837 \\ \hline Mar-22 & $14,015,464 & $700,773 & $14,716,237 & $15,084,143 & $6,622,307 & $8,093,930 \\ \hline Apr-22 & $19,252,800 & $550,080 & $19,802,880 & $18,416,678 & $8,911,296 & $10,891,584 \\ \hline May-22 & $19,362,725 & $553,221 & $19,915,946 & $17,924,351 & $8,962,176 & $10,953,770 \\ \hline Jun-22 & $12,495,600 & $357,017 & $12,852,617 & $12,209,986 & $5,783,678 & $7,068,939 \\ \hline Jul-22 & $19,798,587 & $565,674 & $20,364,261 & $20,567,904 & $9,163,917 & $11,200,344 \\ \hline Aug-22 & $17,511,312 & $500,323 & $18,011,635 & $17,381,228 & $8,105,236 & $9,906,399 \\ \hline Sep-22 & $19,019,657 & $766,101 & $19,785,758 & $18,796,470 & $10,342,364 & $9,443,394 \\ \hline Oct-22 & $14,804,280 & $422,979 & $15,227,259 & $14,770,442 & $6,852,267 & $8,374,992 \\ \hline Nov-22 & $17,176,170 & $490,748 & $17,666,918 & $17,843,587 & $7,950,113 & $9,716,805 \\ \hline Dec-22 & $16,480,000 & $459,870 & $16,939,870 & $17,363,367 & $8,104,500 & $8,835,370 \\ \hline Tala & $294,785,206 & $9,423,788 & $304,208,994 & $313,632,782 & $138,814,378 & $165,394,613 \\ \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

Auditing Principles And Techniques

Authors: Prof. A.R. Solanki

1st Edition

9350533979, 9789350533970

More Books

Students also viewed these Accounting questions