[Solved] Use the following raw data and create a g

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 29, 2024

Use the following raw data and create a graph (use the one that would most make sense from the info) and please list steps to

Use the following raw data and create a graph (use the one that would most make sense from the info) and please list steps to create it in excel

Pretend you will be presenting this in a business meeting and highlight only the important information on one page and please provide possible questions/answers that may be asked

Month Year Product Category Total Production Units Total Production Cost Total Units Sold Total Revenue COGS
Gross Profit Margin

1 2019 Product A 124,129 $114,253.63 145,475 $137,981.24 $133,901.98 2.96%

1 2019 Product B 2,160,824 $1,467,081.27 2,451,027 $1,698,172.69 $1,664,113.52 2.01%

1 2019 Product C 1,629,047 $1,187,927.82 1,444,557 $1,158,226.82 $1,053,394.48 9.05%

2 2019 Product A 185,109 $178,511.46 182,360 $175,681.87 $175,860.95 -0.10%

2 2019 Product B 2,101,369 $1,422,009.29 2,274,615 $1,569,671.27 $1,539,246.40 1.94%

2 2019 Product C 1,504,275 $1,100,180.00 1,477,104 $1,189,478.40 $1,080,308.48 9.18%

3 2019 Product A 102,379 $95,597.67 126,968 $126,715.16 $118,557.44 6.44%

3 2019 Product B 2,400,279 $1,601,660.09 1,978,872 $1,304,715.61 $1,320,463.22 -1.21%

3 2019 Product C 2,000,439 $1,476,717.22 1,398,559 $1,117,145.73 $1,032,411.60 7.58%

4 2019 Product A 121,425 $124,397.50 115,254 $109,969.17 $118,075.92 -7.37%

4 2019 Product B 2,302,646 $1,604,508.68 2,227,884 $1,510,481.69 $1,552,413.54 -2.78%

4 2019 Product C 791,204 $614,865.16 1,628,059 $1,295,888.59 $1,265,206.97 2.37%

5 2019 Product A 79,426 $72,491.05 79,784 $80,662.53 $72,817.98 9.73%

5 2019 Product B 2,174,549 $1,502,818.60 2,055,737 $1,403,815.67 $1,420,707.84 -1.20%

5 2019 Product C 1,571,872 $1,148,496.97 1,604,704 $1,273,715.24 $1,172,485.85 7.95%

6 2019 Product A 57,574 $55,674.35 76,029 $76,628.64 $73,520.38 4.06%

6 2019 Product B 816,573 $599,049.84 1,257,359 $867,302.90 $922,416.72 -6.35%

6 2019 Product C 938,441 $701,467.67 1,408,449 $1,123,063.55 $1,052,790.50 6.26%

7 2019 Product A 71,212 $64,543.43 45,749 $44,285.95 $41,464.91 6.37%

7 2019 Product B 1,612,197 $1,093,167.68 2,203,530 $1,429,750.56 $1,494,127.57 -4.50%

7 2019 Product C 1,104,341 $772,052.52 1,559,848 $1,207,198.31 $1,090,501.07 9.67%

8 2019 Product A 121,739 $126,416.50 98,116 $96,369.41 $101,886.25 -5.72%

8 2019 Product B 1,993,524 $1,264,835.55 1,981,031 $1,297,204.48 $1,256,909.38 3.11%

8 2019 Product C 1,016,453 $738,415.84 1,192,994 $926,899.02 $866,666.60 6.50%

9 2019 Product A 91,947 $81,985.02 121,367 $112,320.14 $108,218.12 3.65%

9 2019 Product B 2,043,544 $1,366,170.85 1,856,999 $1,217,647.40 $1,241,459.83 -1.96%

9 2019 Product C 1,523,766 $1,132,556.64 1,295,719 $1,001,614.05 $963,057.76 3.85%

10 2019 Product A 110,654 $105,534.82 125,305 $109,541.17 $119,507.45 -9.10%

10 2019 Product B 2,158,515 $1,449,001.94 1,949,868 $1,324,876.97 $1,308,938.16 1.20%

10 2019 Product C 1,576,466 $1,158,489.57 1,375,275 $1,038,528.22 $1,010,641.44 2.69%

11 2019 Product A 124,619 $114,117.31 125,080 $110,127.30 $114,539.18 -4.01%

11 2019 Product B 472,883 $360,698.03 1,009,100 $711,435.40 $769,705.71 -8.19%

11 2019 Product C 1,237,810 $894,618.15 1,166,474 $886,751.90 $843,060.13 4.93%

12 2019 Product A 248,256 $229,920.51 217,137 $203,138.57 $201,100.28 1.00%

12 2019 Product B 829,686 $591,747.56 935,737 $602,141.60 $667,385.01 -10.84%

12 2019 Product C 1,275,709 $928,964.83 1,650,020 $1,208,263.44 $1,201,535.67 0.56%

1 2020 Product A 139,243 $126,019.61 203,201 $185,192.38 $183,904.13 0.70%

1 2020 Product B 2,196,671 $1,442,258.87 2,313,820 $1,498,578.40 $1,519,174.90 -1.37%

1 2020 Product C 1,309,923 $974,392.70 1,641,027 $1,203,001.86 $1,220,686.35 -1.47%

2 2020 Product A 193,023 $179,321.71 160,412 $141,888.07 $149,025.98 -5.03%

2 2020 Product B 1,756,036 $1,178,442.45 1,878,197 $1,162,831.61 $1,260,422.49 -8.39%

2 2020 Product C 1,701,376 $1,240,589.06 1,785,763 $1,299,390.36 $1,302,121.57 -0.21%

3 2020 Product A 205,632 $202,266.00 155,404 $131,735.05 $152,860.39 -16.04%

3 2020 Product B 1,688,302 $1,105,771.28 1,673,784 $1,028,021.52 $1,096,262.54 -6.64%

3 2020 Product C 1,875,501 $1,379,763.35 1,757,874 $1,266,108.61 $1,293,227.52 -2.14%

4 2020 Product A 140,140 $133,354.96 223,610 $192,664.33 $212,783.66 -10.44%

4 2020 Product B 1,407,829 $958,141.99 1,494,154 $960,140.21 $1,016,892.90 -5.91%

4 2020 Product C 1,404,450 $1,027,881.35 1,621,994 $1,187,576.35 $1,187,096.35 0.04%

4 2020 Product D 9,653 $12,761.36 1,609 $2,940.00 $2,126.89 27.66%

5 2020 Product A 73,177 $70,080.76 85,349 $76,698.02 $81,737.45 -6.57%

5 2020 Product B 1,698,999 $1,154,494.86 1,503,744 $1,020,994.19 $1,021,816.50 -0.08%

5 2020 Product C 1,445,496 $1,053,199.34 1,099,724 $760,372.05 $801,267.46 -5.38%

6 2020 Product A 209,708 $195,091.93 162,251 $139,783.51 $150,942.66 -7.98%

6 2020 Product B 1,454,931 $982,907.48 1,880,269 $1,164,930.39 $1,270,253.11 -9.04%

6 2020 Product C 1,562,479 $1,153,328.39 2,037,780 $1,396,224.77 $1,504,166.82 -7.73%

7 2020 Product A 59,645 $54,091.80 124,869 $95,678.03 $113,242.42 -18.36%

7 2020 Product B 1,793,844 $1,216,297.64 1,638,770 $1,019,205.03 $1,111,151.01 -9.02%

7 2020 Product C 2,232,374 $1,643,963.55 2,082,445 $1,422,059.21 $1,533,553.10 -7.84%

8 2020 Product A 114,233 $108,766.29 102,938 $95,617.78 $98,012.27 -2.50%

8 2020 Product B 2,426,434 $1,607,182.93 2,380,040 $1,446,381.93 $1,576,452.86 -8.99%

8 2020 Product C 1,879,200 $1,346,011.10 1,950,196 $1,326,962.31 $1,396,863.43 -5.27%

8 2020 Product D 32,175 $42,690.16 32,175 $39,000.00 $42,690.16 -9.46%

9 2020 Product A 242,121 $229,826.17 230,226 $208,432.73 $218,534.64 -4.85%

9 2020 Product B 2,474,331 $1,584,307.06 2,411,448 $1,507,350.05 $1,544,043.39 -2.43%

9 2020 Product C 1,368,403 $1,005,269.04 1,492,172 $1,051,287.38 $1,096,193.64 -4.27%

10 2020 Product A 137,214 $154,869.46 260,340 $226,129.44 $293,837.44 -29.94%

10 2020 Product B 1,671,071 $1,149,637.74 1,776,073 $1,183,112.92 $1,221,875.25 -3.28%

10 2020 Product C 2,162,647 $1,583,180.06 1,870,221 $1,367,195.56 $1,369,107.15 -0.14%

10 2020 Product D 33,784 $44,817.05 33,784 $43,350.00 $44,817.05 -3.38%

11 2020 Product A 308,502 $334,198.34 218,784 $185,127.67 $237,007.02 -28.02%

11 2020 Product B 1,758,576 $1,164,333.22 1,237,186 $861,085.12 $819,126.61 4.87%

11 2020 Product C 1,836,483 $1,335,442.34 1,423,034 $1,067,062.20 $1,034,792.85 3.02%

12 2020 Product A 222,395 $249,266.09 214,498 $181,338.32 $240,414.84 -32.58%

12 2020 Product B 1,206,809 $823,717.03 1,437,283 $1,010,691.74 $981,028.38 2.93%

12 2020 Product C 2,030,056 $1,542,983.08 1,494,520 $1,114,030.68 $1,135,938.46 -1.97%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

Step: 3

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

The Business Of We The Proven Three Step Process For Closing The Gap Between Us And Them In Your Workplace

Authors: Laura Kriska

1st Edition

ISBN: 140021680X, 978-1400216802

More Books

Students also viewed these Accounting questions

Question

★★★★★

Anchovy acquired 90 percent of Yelton on January 1, 2009. Of Yeltons total acquisition-date fair value, $60,000 was allocated to undervalued equipment (with a 10-year life) and $80,000 was attributed...

Answered: 1 week ago

Question

★★★★★

36. Let X be uniformly distributed on [0, 1]. Find a linear function Y g(X) such that the interval [0, 1] is transformed into [5, 5]. Use the relationship for linear functions MaX b(t) ebtMX(at)...

Answered: 1 week ago

Question

★★★★★

Sales Increase Bannister Legal Services generated $2.0 million in sales during 2009, and its year-end total assets were $1.5 million. Also, at year-end 2009, current liabilities were $500,000,...

Answered: 1 week ago

Question

★★★★★

If you were to save $3000 per year to your age 65 (assume you invested in common stocks) with a rate of return of 10%, how much money will you have? Starting age is 21.

Answered: 1 week ago

Question

★★★★★

Let us consider a flat initial interest rate curve at 3%. An insurance company has sold the following 2 products to its clients: a 2% guaranteed (compound) rate product at maturity 4 years. Initial...

Answered: 1 week ago

Question

★★★★★

Examine managing a firearms business from a potentially challenging scenario: Managing a firearms business during a national tragedy, more specifically, during a national tragedy involving a mass...

Answered: 1 week ago

Question

★★★★★

Imagine you want to air an advertisement on TV . The options are morning or afternoon. The media agency claims that the advertisement will have same effectiveness regardless of the time. The...

Answered: 1 week ago

Question

★★★★★

An existing office in Kariakoo currently sells goods for Tshs 100 per unit. The variable cost is Tshs 40 per unit, and 20,000units are sold annually and a profit of Tshs 300,000 is available...

Answered: 1 week ago

Question

★★★★★

1 In MS SQL we can calculate the email address for our vendor contacts IF the vendor has their email domain value provided in the VendorUpdates_20230107 table (not all of them do!). Email addresses...

Answered: 1 week ago

Question

★★★★★

Which brand, if any, emerged as the favorite? How did you determine this? 2 . Is the favorite generally a popular brand, or were you surprised by the winner? 3 . If a consumer had a favorite before...

Answered: 1 week ago

Question

★★★★★

4. How has e-commerce affected business-to-business transactions?

Answered: 1 week ago

Question

★★★★★

1. How important is mobile technology in Orbitzs business strategy? Why? When it comes to mobile apps and gauging their impact on consumers and business, the online travel industry and its airline...

Answered: 1 week ago

Question

★★★★★

1. Analyze Pandora using the value chain and competitive forces models. What competitive forces does the company have to deal with? What is its customer value proposition? Pandora is the Internets...

Answered: 1 week ago

Previous Question Next Question

Month	Year	Product Category	Total Production Units	Total Production Cost	Total Units Sold	Total Revenue	COGS	Gross Profit Margin
1	2019	Product A	124,129	$114,253.63	145,475	$137,981.24	$133,901.98	2.96%
1	2019	Product B	2,160,824	$1,467,081.27	2,451,027	$1,698,172.69	$1,664,113.52	2.01%
1	2019	Product C	1,629,047	$1,187,927.82	1,444,557	$1,158,226.82	$1,053,394.48	9.05%
2	2019	Product A	185,109	$178,511.46	182,360	$175,681.87	$175,860.95	-0.10%
2	2019	Product B	2,101,369	$1,422,009.29	2,274,615	$1,569,671.27	$1,539,246.40	1.94%
2	2019	Product C	1,504,275	$1,100,180.00	1,477,104	$1,189,478.40	$1,080,308.48	9.18%
3	2019	Product A	102,379	$95,597.67	126,968	$126,715.16	$118,557.44	6.44%
3	2019	Product B	2,400,279	$1,601,660.09	1,978,872	$1,304,715.61	$1,320,463.22	-1.21%
3	2019	Product C	2,000,439	$1,476,717.22	1,398,559	$1,117,145.73	$1,032,411.60	7.58%
4	2019	Product A	121,425	$124,397.50	115,254	$109,969.17	$118,075.92	-7.37%
4	2019	Product B	2,302,646	$1,604,508.68	2,227,884	$1,510,481.69	$1,552,413.54	-2.78%
4	2019	Product C	791,204	$614,865.16	1,628,059	$1,295,888.59	$1,265,206.97	2.37%
5	2019	Product A	79,426	$72,491.05	79,784	$80,662.53	$72,817.98	9.73%
5	2019	Product B	2,174,549	$1,502,818.60	2,055,737	$1,403,815.67	$1,420,707.84	-1.20%
5	2019	Product C	1,571,872	$1,148,496.97	1,604,704	$1,273,715.24	$1,172,485.85	7.95%
6	2019	Product A	57,574	$55,674.35	76,029	$76,628.64	$73,520.38	4.06%
6	2019	Product B	816,573	$599,049.84	1,257,359	$867,302.90	$922,416.72	-6.35%
6	2019	Product C	938,441	$701,467.67	1,408,449	$1,123,063.55	$1,052,790.50	6.26%
7	2019	Product A	71,212	$64,543.43	45,749	$44,285.95	$41,464.91	6.37%
7	2019	Product B	1,612,197	$1,093,167.68	2,203,530	$1,429,750.56	$1,494,127.57	-4.50%
7	2019	Product C	1,104,341	$772,052.52	1,559,848	$1,207,198.31	$1,090,501.07	9.67%
8	2019	Product A	121,739	$126,416.50	98,116	$96,369.41	$101,886.25	-5.72%
8	2019	Product B	1,993,524	$1,264,835.55	1,981,031	$1,297,204.48	$1,256,909.38	3.11%
8	2019	Product C	1,016,453	$738,415.84	1,192,994	$926,899.02	$866,666.60	6.50%
9	2019	Product A	91,947	$81,985.02	121,367	$112,320.14	$108,218.12	3.65%
9	2019	Product B	2,043,544	$1,366,170.85	1,856,999	$1,217,647.40	$1,241,459.83	-1.96%
9	2019	Product C	1,523,766	$1,132,556.64	1,295,719	$1,001,614.05	$963,057.76	3.85%
10	2019	Product A	110,654	$105,534.82	125,305	$109,541.17	$119,507.45	-9.10%
10	2019	Product B	2,158,515	$1,449,001.94	1,949,868	$1,324,876.97	$1,308,938.16	1.20%
10	2019	Product C	1,576,466	$1,158,489.57	1,375,275	$1,038,528.22	$1,010,641.44	2.69%
11	2019	Product A	124,619	$114,117.31	125,080	$110,127.30	$114,539.18	-4.01%
11	2019	Product B	472,883	$360,698.03	1,009,100	$711,435.40	$769,705.71	-8.19%
11	2019	Product C	1,237,810	$894,618.15	1,166,474	$886,751.90	$843,060.13	4.93%
12	2019	Product A	248,256	$229,920.51	217,137	$203,138.57	$201,100.28	1.00%
12	2019	Product B	829,686	$591,747.56	935,737	$602,141.60	$667,385.01	-10.84%
12	2019	Product C	1,275,709	$928,964.83	1,650,020	$1,208,263.44	$1,201,535.67	0.56%
1	2020	Product A	139,243	$126,019.61	203,201	$185,192.38	$183,904.13	0.70%
1	2020	Product B	2,196,671	$1,442,258.87	2,313,820	$1,498,578.40	$1,519,174.90	-1.37%
1	2020	Product C	1,309,923	$974,392.70	1,641,027	$1,203,001.86	$1,220,686.35	-1.47%
2	2020	Product A	193,023	$179,321.71	160,412	$141,888.07	$149,025.98	-5.03%
2	2020	Product B	1,756,036	$1,178,442.45	1,878,197	$1,162,831.61	$1,260,422.49	-8.39%
2	2020	Product C	1,701,376	$1,240,589.06	1,785,763	$1,299,390.36	$1,302,121.57	-0.21%
3	2020	Product A	205,632	$202,266.00	155,404	$131,735.05	$152,860.39	-16.04%
3	2020	Product B	1,688,302	$1,105,771.28	1,673,784	$1,028,021.52	$1,096,262.54	-6.64%
3	2020	Product C	1,875,501	$1,379,763.35	1,757,874	$1,266,108.61	$1,293,227.52	-2.14%
4	2020	Product A	140,140	$133,354.96	223,610	$192,664.33	$212,783.66	-10.44%
4	2020	Product B	1,407,829	$958,141.99	1,494,154	$960,140.21	$1,016,892.90	-5.91%
4	2020	Product C	1,404,450	$1,027,881.35	1,621,994	$1,187,576.35	$1,187,096.35	0.04%
4	2020	Product D	9,653	$12,761.36	1,609	$2,940.00	$2,126.89	27.66%
5	2020	Product A	73,177	$70,080.76	85,349	$76,698.02	$81,737.45	-6.57%
5	2020	Product B	1,698,999	$1,154,494.86	1,503,744	$1,020,994.19	$1,021,816.50	-0.08%
5	2020	Product C	1,445,496	$1,053,199.34	1,099,724	$760,372.05	$801,267.46	-5.38%
6	2020	Product A	209,708	$195,091.93	162,251	$139,783.51	$150,942.66	-7.98%
6	2020	Product B	1,454,931	$982,907.48	1,880,269	$1,164,930.39	$1,270,253.11	-9.04%
6	2020	Product C	1,562,479	$1,153,328.39	2,037,780	$1,396,224.77	$1,504,166.82	-7.73%
7	2020	Product A	59,645	$54,091.80	124,869	$95,678.03	$113,242.42	-18.36%
7	2020	Product B	1,793,844	$1,216,297.64	1,638,770	$1,019,205.03	$1,111,151.01	-9.02%
7	2020	Product C	2,232,374	$1,643,963.55	2,082,445	$1,422,059.21	$1,533,553.10	-7.84%
8	2020	Product A	114,233	$108,766.29	102,938	$95,617.78	$98,012.27	-2.50%
8	2020	Product B	2,426,434	$1,607,182.93	2,380,040	$1,446,381.93	$1,576,452.86	-8.99%
8	2020	Product C	1,879,200	$1,346,011.10	1,950,196	$1,326,962.31	$1,396,863.43	-5.27%
8	2020	Product D	32,175	$42,690.16	32,175	$39,000.00	$42,690.16	-9.46%
9	2020	Product A	242,121	$229,826.17	230,226	$208,432.73	$218,534.64	-4.85%
9	2020	Product B	2,474,331	$1,584,307.06	2,411,448	$1,507,350.05	$1,544,043.39	-2.43%
9	2020	Product C	1,368,403	$1,005,269.04	1,492,172	$1,051,287.38	$1,096,193.64	-4.27%
10	2020	Product A	137,214	$154,869.46	260,340	$226,129.44	$293,837.44	-29.94%
10	2020	Product B	1,671,071	$1,149,637.74	1,776,073	$1,183,112.92	$1,221,875.25	-3.28%
10	2020	Product C	2,162,647	$1,583,180.06	1,870,221	$1,367,195.56	$1,369,107.15	-0.14%
10	2020	Product D	33,784	$44,817.05	33,784	$43,350.00	$44,817.05	-3.38%
11	2020	Product A	308,502	$334,198.34	218,784	$185,127.67	$237,007.02	-28.02%
11	2020	Product B	1,758,576	$1,164,333.22	1,237,186	$861,085.12	$819,126.61	4.87%
11	2020	Product C	1,836,483	$1,335,442.34	1,423,034	$1,067,062.20	$1,034,792.85	3.02%
12	2020	Product A	222,395	$249,266.09	214,498	$181,338.32	$240,414.84	-32.58%
12	2020	Product B	1,206,809	$823,717.03	1,437,283	$1,010,691.74	$981,028.38	2.93%
12	2020	Product C	2,030,056	$1,542,983.08	1,494,520	$1,114,030.68	$1,135,938.46	-1.97%