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

Answer rating: 100% (QA)

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 the full answer