Use the following raw data to create a Financial Key Performance Indicator (KPI) on Microsoft Excel (please list steps) Then put together 1 slide of what would be the most important thing to present to management from this information Month Year Product Category Total Production Units Total Production Cost Total Units Sold Total Revenue 1 2019 Product A 124,129 $114,253 63 145,475 $137,981 24 1 2019 Product B 2,160,824 $1,467,081 27 2,451,027 $1,698,172 69 1 2019 Product C 1,629,047 $1,187,927 82 1,444,557 $1,158,226 82 2 2019 Product A 185,109 $178,511 46 182,360 $175,681 87 2 2019 Product B 2,101,369 $1,422,009 29 2,274,615 $1,569,671 27 2 2019 Product C 1,504,275 $1,100,180 00 1,477,104 $1,189,478 40 3 2019 Product A 102,379 $95,597 67 126,968 $126,715 16 3 2019 Product B 2,400,279 $1,601,660 09 1,978,872 $1,304,715 61 3 2019 Product C 2,000,439 $1,476,717 22 1,398,559 $1,117,145 73 4 2019 Product A 121,425 $124,397 50 115,254 $109,969 17 4 2019 Product B 2,302,646 $1,604,508 68 2,227,884 $1,510,481 69 4 2019 Product C 791,204 $614,865 16 1,628,059 $1,295,888 59 5 2019 Product A 79,426 $72,491 05 79,784 $80,662 53 5 2019 Product B 2,174,549 $1,502,818 60 2,055,737 $1,403,815 67 5 2019 Product C 1,571,872 $1,148,496 97 1,604,704 $1,273,715 24 6 2019 Product A 57,574 $55,674 35 76,029 $76,628 64 6 2019 Product B 816,573 $599,049 84 1,257,359 $867,302 90 6 2019 Product C 938,441 $701,467 67 1,408,449 $1,123,063 55 7 2019 Product A 71,212 $64,543 43 45,749 $44,285 95 7 2019 Product B 1,612,197 $1,093,167 68 2,203,530 $1,429,750 56 7 2019 Product C 1,104,341 $772,052 52 1,559,848 $1,207,198 31 8 2019 Product A 121,739 $126,416 50 98,116 $96,369 41 8 2019 Product B 1,993,524 $1,264,835 55 1,981,031 $1,297,204 48 8 2019 Product C 1,016,453 $738,415 84 1,192,994 $926,899 02 9 2019 Product A 91,947 $81,985 02 121,367 $112,320 14 9 2019 Product B 2,043,544 $1,366,170 85 1,856,999 $1,217,647 40 9 2019 Product C 1,523,766 $1,132,556 64 1,295,719 $1,001,614 05 10 2019 Product A 110,654 $105,534 82 125,305 $109,541 17 10 2019 Product B 2,158,515 $1,449,001 94 1,949,868 $1,324,876 97 10 2019 Product C 1,576,466 $1,158,489 57 1,375,275 $1,038,528 22 11 2019 Product A 124,619 $114,117 31 125,080 $110,127 30 11 2019 Product B 472,883 $360,698 03 1,009,100 $711,435 40 11 2019 Product C 1,237,810 $894,618 15 1,166,474 $886,751 90 12 2019 Product A 248,256 $229,920 51 217,137 $203,138 57 12 2019 Product B 829,686 $591,747 56 935,737 $602,141 60 12 2019 Product C 1,275,709 $928,964 83 1,650,020 $1,208,263 44 1 2020 Product A 139,243 $126,019 61 203,201 $185,192 38 1 2020 Product B 2,196,671 $1,442,258 87 2,313,820 $1,498,578 40 1 2020 Product C 1,309,923 $974,392 70 1,641,027 $1,203,001 86 2 2020 Product A 193,023 $179,321 71 160,412 $141,888 07 2 2020 Product B 1,756,036 $1,178,442 45 1,878,197 $1,162,831 61 2 2020 Product C 1,701,376 $1,240,589 06 1,785,763 $1,299,390 36 3 2020 Product A 205,632 $202,266 00 155,404 $131,735 05 3 2020 Product B 1,688,302 $1,105,771 28 1,673,784 $1,028,021 52 3 2020 Product C 1,875,501 $1,379,763 35 1,757,874 $1,266,108 61 4 2020 Product A 140,140 $133,354 96 223,610 $192,664 33 4 2020 Product B 1,407,829 $958,141 99 1,494,154 $960,140 21 4 2020 Product C 1,404,450 $1,027,881 35 1,621,994 $1,187,576 35 4 2020 Product D 9,653 $12,761 36 1,609 $2,940 00 5 2020 Product A 73,177 $70,080 76 85,349 $76,698 02 5 2020 Product B 1,698,999 $1,154,494 86 1,503,744 $1,020,994 19 5 2020 Product C 1,445,496 $1,053,199 34 1,099,724 $760,372 05 6 2020 Product A 209,708 $195,091 93 162,251 $139,783 51 6 2020 Product B 1,454,931 $982,907 48 1,880,269 $1,164,930 39 6 2020 Product C 1,562,479 $1,153,328 39 2,037,780 $1,396,224 77 7 2020 Product A 59,645 $54,091 80 124,869 $95,678 03 7 2020 Product B 1,793,844 $1,216,297 64 1,638,770 $1,019,205 03 7 2020 Product C 2,232,374 $1,643,963 55 2,082,445 $1,422,059 21 8 2020 Product A 114,233 $108,766 29 102,938 $95,617 78 8 2020 Product B 2,426,434 $1,607,182 93 2,380,040 $1,446,381 93 8 2020 Product C 1,879,200 $1,346,011 10 1,950,196 $1,326,962 31 8 2020 Product D 32,175 $42,690 16 32,175 $39,000 00 9 2020 Product A 242,121 $229,826 17 230,226 $208,432 73 9 2020 Product B 2,474,331 $1,584,307 06 2,411,448 $1,507,350 05 9 2020 Product C 1,368,403 $1,005,269 04 1,492,172 $1,051,287 38 10 2020 Product A 137,214 $154,869 46 260,340 $226,129 44 10 2020 Product B 1,671,071 $1,149,637 74 1,776,073 $1,183,112 92 10 2020 Product C 2,162,647 $1,583,180 06 1,870,221 $1,367,195 56 10 2020 Product D 33,784 $44,817 05 33,784 $43,350 00 11 2020 Product A 308,502 $334,198 34 218,784 $185,127 67 11 2020 Product B 1,758,576 $1,164,333 22 1,237,186 $861,085 12 11 2020 Product C 1,836,483 $1,335,442 34 1,423,034 $1,067,062 20 12 2020 Product A 222,395 $249,266 09 214,498 $181,338 32 12 2020 Product B 1,206,809 $823,717 03 1,437,283 $1,010,691 74 12 2020 Product C 2,030,056 $1,542,983 08 1,494,520 $1,114,030 68

The Answer is in the image, click to view ...

Question: Use the following raw data to create a Financial Key Performance Indicator (KPI) on Microsoft Excel (please list steps) Then put together 1 slide of

Use the following raw data to create a Financial Key Performance Indicator (KPI) on Microsoft Excel (please list steps)

Then put together 1 slide of what would be the most important thing to present to management from this information

Month	Year	Product Category	Total Production Units	Total Production Cost	Total Units Sold	Total Revenue
1	2019	Product A	124,129	$114,253.63	145,475	$137,981.24
1	2019	Product B	2,160,824	$1,467,081.27	2,451,027	$1,698,172.69
1	2019	Product C	1,629,047	$1,187,927.82	1,444,557	$1,158,226.82
2	2019	Product A	185,109	$178,511.46	182,360	$175,681.87
2	2019	Product B	2,101,369	$1,422,009.29	2,274,615	$1,569,671.27
2	2019	Product C	1,504,275	$1,100,180.00	1,477,104	$1,189,478.40
3	2019	Product A	102,379	$95,597.67	126,968	$126,715.16
3	2019	Product B	2,400,279	$1,601,660.09	1,978,872	$1,304,715.61
3	2019	Product C	2,000,439	$1,476,717.22	1,398,559	$1,117,145.73
4	2019	Product A	121,425	$124,397.50	115,254	$109,969.17
4	2019	Product B	2,302,646	$1,604,508.68	2,227,884	$1,510,481.69
4	2019	Product C	791,204	$614,865.16	1,628,059	$1,295,888.59
5	2019	Product A	79,426	$72,491.05	79,784	$80,662.53
5	2019	Product B	2,174,549	$1,502,818.60	2,055,737	$1,403,815.67
5	2019	Product C	1,571,872	$1,148,496.97	1,604,704	$1,273,715.24
6	2019	Product A	57,574	$55,674.35	76,029	$76,628.64
6	2019	Product B	816,573	$599,049.84	1,257,359	$867,302.90
6	2019	Product C	938,441	$701,467.67	1,408,449	$1,123,063.55
7	2019	Product A	71,212	$64,543.43	45,749	$44,285.95
7	2019	Product B	1,612,197	$1,093,167.68	2,203,530	$1,429,750.56
7	2019	Product C	1,104,341	$772,052.52	1,559,848	$1,207,198.31
8	2019	Product A	121,739	$126,416.50	98,116	$96,369.41
8	2019	Product B	1,993,524	$1,264,835.55	1,981,031	$1,297,204.48
8	2019	Product C	1,016,453	$738,415.84	1,192,994	$926,899.02
9	2019	Product A	91,947	$81,985.02	121,367	$112,320.14
9	2019	Product B	2,043,544	$1,366,170.85	1,856,999	$1,217,647.40
9	2019	Product C	1,523,766	$1,132,556.64	1,295,719	$1,001,614.05
10	2019	Product A	110,654	$105,534.82	125,305	$109,541.17
10	2019	Product B	2,158,515	$1,449,001.94	1,949,868	$1,324,876.97
10	2019	Product C	1,576,466	$1,158,489.57	1,375,275	$1,038,528.22
11	2019	Product A	124,619	$114,117.31	125,080	$110,127.30
11	2019	Product B	472,883	$360,698.03	1,009,100	$711,435.40
11	2019	Product C	1,237,810	$894,618.15	1,166,474	$886,751.90
12	2019	Product A	248,256	$229,920.51	217,137	$203,138.57
12	2019	Product B	829,686	$591,747.56	935,737	$602,141.60
12	2019	Product C	1,275,709	$928,964.83	1,650,020	$1,208,263.44
1	2020	Product A	139,243	$126,019.61	203,201	$185,192.38
1	2020	Product B	2,196,671	$1,442,258.87	2,313,820	$1,498,578.40
1	2020	Product C	1,309,923	$974,392.70	1,641,027	$1,203,001.86
2	2020	Product A	193,023	$179,321.71	160,412	$141,888.07
2	2020	Product B	1,756,036	$1,178,442.45	1,878,197	$1,162,831.61
2	2020	Product C	1,701,376	$1,240,589.06	1,785,763	$1,299,390.36
3	2020	Product A	205,632	$202,266.00	155,404	$131,735.05
3	2020	Product B	1,688,302	$1,105,771.28	1,673,784	$1,028,021.52
3	2020	Product C	1,875,501	$1,379,763.35	1,757,874	$1,266,108.61
4	2020	Product A	140,140	$133,354.96	223,610	$192,664.33
4	2020	Product B	1,407,829	$958,141.99	1,494,154	$960,140.21
4	2020	Product C	1,404,450	$1,027,881.35	1,621,994	$1,187,576.35
4	2020	Product D	9,653	$12,761.36	1,609	$2,940.00
5	2020	Product A	73,177	$70,080.76	85,349	$76,698.02
5	2020	Product B	1,698,999	$1,154,494.86	1,503,744	$1,020,994.19
5	2020	Product C	1,445,496	$1,053,199.34	1,099,724	$760,372.05
6	2020	Product A	209,708	$195,091.93	162,251	$139,783.51
6	2020	Product B	1,454,931	$982,907.48	1,880,269	$1,164,930.39
6	2020	Product C	1,562,479	$1,153,328.39	2,037,780	$1,396,224.77
7	2020	Product A	59,645	$54,091.80	124,869	$95,678.03
7	2020	Product B	1,793,844	$1,216,297.64	1,638,770	$1,019,205.03
7	2020	Product C	2,232,374	$1,643,963.55	2,082,445	$1,422,059.21
8	2020	Product A	114,233	$108,766.29	102,938	$95,617.78
8	2020	Product B	2,426,434	$1,607,182.93	2,380,040	$1,446,381.93
8	2020	Product C	1,879,200	$1,346,011.10	1,950,196	$1,326,962.31
8	2020	Product D	32,175	$42,690.16	32,175	$39,000.00
9	2020	Product A	242,121	$229,826.17	230,226	$208,432.73
9	2020	Product B	2,474,331	$1,584,307.06	2,411,448	$1,507,350.05
9	2020	Product C	1,368,403	$1,005,269.04	1,492,172	$1,051,287.38
10	2020	Product A	137,214	$154,869.46	260,340	$226,129.44
10	2020	Product B	1,671,071	$1,149,637.74	1,776,073	$1,183,112.92
10	2020	Product C	2,162,647	$1,583,180.06	1,870,221	$1,367,195.56
10	2020	Product D	33,784	$44,817.05	33,784	$43,350.00
11	2020	Product A	308,502	$334,198.34	218,784	$185,127.67
11	2020	Product B	1,758,576	$1,164,333.22	1,237,186	$861,085.12
11	2020	Product C	1,836,483	$1,335,442.34	1,423,034	$1,067,062.20
12	2020	Product A	222,395	$249,266.09	214,498	$181,338.32
12	2020	Product B	1,206,809	$823,717.03	1,437,283	$1,010,691.74
12	2020	Product C	2,030,056	$1,542,983.08	1,494,520	$1,114,030.68

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

Use the following raw data to create a Financial Key Performance Indicator (KPI) on Microsoft Excel (please list steps) Then put together 1 slide of what would be the most important thing to present...

Use the following raw data to create a Financial KPI onMicrosoft Excel (list steps)Then put together 1 slide of what would be the most importantthing to present to management from this information 0...

MKT500 Week 8 Discussion Board 8 attached are the questions, scenario, and supportive reading materials. MKT500 DB 8 "The Importance of Social Media and Web Analytics" 1.) From the scenario,...

Meeting Schedules Code Short Name Period (d/m/yy-d/m/yy) Freq Day Mediums Comments PSG Steering Group 1/04/24-24/06/24 W/2W Tu, Th F2F EdMI team members only PSG Steering Group 24/06/24-19/07/24 2W...

Question 4 [30 Marks] Create a Balanced Score Card for XT Beauty. Formulate three possible strategies for the Financial - and Internal Business Processes perspectives of a balanced score card for the...

Kindly answer the following question from facility management without explanations : in which of the following project phases are a project's end results identified? a. Define b. Do c. Plan d. Act An...

Introducing the do-it-yourself concept in Egypt - the case of House Wonders Ahmed Ayman and Mahitab Mohamed Shahin Introduction House Wonders has been operating in Egypt since June 2017 and is facing...

!! SOLVE ALL QUESTION CORRECTLY !! 1. Which of the following is a primary objective of operations management? a) Maximizing shareholder wealth b) Increasing customer satisfaction c) Minimizing...

Q. Was the outcome for these companies inevitable? BALANCED SCORECARD INSTITUTE Straten Management Group Veolia Water North America Case Study O VEOLIA The Situation Based in Chicago, Veolia Water...

BSBFIM501: Assessment 2- Managing Budgets. I am so bad at this, and don't understand how to do any of this assessment. BSBFIM501 - Assessment 2 Task 1 - Sales Budget Part A (1) The Black Helmet Motor...

Solve the system a+b = s, c+d = s, a+c = s, b+d = s, a+d = s, and b+c = s.

Calculate CPP from following employess: 1- Sara regular earnings are $ 4678 and her pay period is Monthly. 2- John turned 18 on July 12. Calculate his total CPP contribution for the year 3- Melissa...

what are the key lending ratios used to evaluate the financial capacity of a business

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

3 The Amish forgive those involved in conflict with them because of their deeply held religious beliefs. Are there other reasons for forgiveness that can be useful in a conflict?

4 What is your reaction to the information on Amish forgiveness in light of what we learned about Amish shunning earlier in the chapter?

Think of an attitude you have about conflict that is making it difficult for you to talk productively about disagreements with someone in your life. For example, do you believe that discussing...