Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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