Need help with the graph 3. The final chart the...

50.1K

Verified Solution

Question

Accounting

Need help with the graph
image
image
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}

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students