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 |
Step by Step Solution
★★★★★
3.51 Rating (158 Votes )
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Answer To create a Financial Key Performance Indicator KPI on Microsoft Excel using the provided raw data follow these steps 1 Open a new Microsoft Ex... View full answer
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help