FIN615 Excel Dashboard Assignment

assignment.xlsx

Home >Business & Finance homework help >FIN615 Excel Dashboard Assignment

Sales Forecasts

FY 2010 Sales Forecast by Month
	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	FY 2010
Total Sales	$ 82,280	82,880	83,630	83,900	83,700	83,800	83,580	83,680	83,800	84,000	85,100	85,650	$ 1,006,000
FY 2010 Product Sales Forecast by Customer Type
Customer Type	Product	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	FY 2010
Corporate	Copy Paper	$ 9,670	$ 9,750	$ 9,840	$ 9,880	$ 9,850	$ 9,870	$ 9,840	$ 9,850	$ 9,870	$ 9,890	$ 10,030	$ 10,100	$ 118,440
	Ink Jet Cartridges	9,940	10,010	10,100	10,130	10,110	10,120	10,090	10,110	10,120	10,150	10,280	10,340	121,500
	Toner Cartridges	7,620	7,680	7,750	7,800	7,750	7,760	7,740	7,750	7,760	7,780	7,880	7,930	93,200
Educational	Copy Paper	9,800	9,850	9,930	9,940	9,940	9,950	9,950	9,940	9,950	9,960	10,090	10,160	119,460
	Ink Jet Cartridges	8,340	8,400	8,480	8,510	8,490	8,500	8,470	8,480	8,500	8,520	8,630	8,680	102,000
	Toner Cartridges	6,500	6,550	6,610	6,630	6,610	6,620	6,600	6,620	6,620	6,640	6,730	6,770	79,500
Governmental	Copy Paper	10,970	11,050	11,150	11,180	11,160	11,170	11,140	11,150	11,170	11,200	11,340	11,420	134,100
	Ink Jet Cartridges	9,360	9,430	9,520	9,550	9,530	9,540	9,510	9,520	9,540	9,560	9,690	9,750	114,500
	Toner Cartridges	10,080	10,160	10,250	10,280	10,260	10,270	10,240	10,260	10,270	10,300	10,430	10,500	123,300
Total Sales		$ 82,280	$ 82,880	$ 83,630	$ 83,900	$ 83,700	$ 83,800	$ 83,580	$ 83,680	$ 83,800	$ 84,000	$ 85,100	$ 85,650	$ 1,006,000
FY 2010 Sales Forecast by Sales Representative
Sales Representative	Forecasted FY 2010 Sales
Karen Winthrop	$ 236,700
Nathan Clark	244,700
Rachel Smith	272,600
Walter Jones	252,000
Total	$ 1,006,000

Sales Data

Region	Product	Customer Type	Sales Representative	31-Oct-08	30-Nov-08	31-Dec-08	31-Jan-09	28-Feb-09	31-Mar-09	30-Apr-09	31-May-09	30-Jun-09	31-Jul-09	31-Aug-09	30-Sep-09	31-Oct-09	30-Nov-09	31-Dec-09	31-Jan-10	28-Feb-10	31-Mar-10	30-Apr-10	31-May-10	30-Jun-10	31-Jul-10	31-Aug-10	30-Sep-10	31-Oct-10	30-Nov-10	31-Dec-10
East	Toner Cartridges	Corporate	Nathan Clark	$ 697	$ 711	$ 713	$ 710	$ 710	$ 724	$ 732	$ 735	$ 742	$ 738	$ 732	$ 749	$ 748	$ 755	$ 755	$ 827	$ 825	$ 826	$ 827	$ 830	$ 830	$ 852	$ 877	$ 884
East	Toner Cartridges	Corporate	Rachel Smith	356	362	360	358	361	365	368	373	379	382	380	382	387	386	387	463	467	465	470	467	468	469	466	464
East	Toner Cartridges	Corporate	Karen Winthrop	101	100	101	101	100	101	103	105	105	105	106	106	107	107	106	186	185	186	185	186	188	188	187	190
East	Toner Cartridges	Corporate	Walter Jones	104	105	104	105	105	104	105	105	104	104	103	104	103	104	105	186	187	186	185	185	184	185	185	185
East	Toner Cartridges	Educational	Nathan Clark	336	338	336	342	339	344	344	345	350	348	350	352	356	353	356	337	334	331	337	341	340	341	342	346
East	Toner Cartridges	Educational	Rachel Smith	310	313	310	312	322	322	319	318	320	325	323	322	320	325	327	313	313	315	313	311	317	314	316	313
East	Toner Cartridges	Educational	Karen Winthrop	727	733	736	743	745	753	760	756	752	759	759	757	775	775	768	749	759	768	777	782	800	800	824	823
East	Toner Cartridges	Educational	Walter Jones	466	476	473	484	493	494	496	496	506	515	510	505	513	511	506	490	495	494	491	495	495	491	506	508
East	Toner Cartridges	Governmental	Nathan Clark	192	191	193	193	195	197	197	197	199	198	201	200	198	199	200	199	201	204	205	203	203	205	207	209
East	Toner Cartridges	Governmental	Rachel Smith	784	792	795	812	810	815	822	819	839	844	849	842	838	842	841	845	845	838	832	839	831	848	847	843
East	Toner Cartridges	Governmental	Karen Winthrop	764	766	768	770	771	767	764	774	777	787	801	800	797	798	800	812	818	813	811	818	829	835	829	829
East	Toner Cartridges	Governmental	Walter Jones	676	679	676	686	690	690	698	707	705	704	701	697	696	710	703	713	712	722	718	729	746	751	758	760
East	Ink Jet Cartridges	Corporate	Nathan Clark	725	732	730	739	745	742	735	731	734	751	753	762	755	762	765	739	732	732	733	733	732	745	740	746
East	Ink Jet Cartridges	Corporate	Rachel Smith	254	254	254	254	259	257	256	264	266	266	267	265	263	265	263	227	227	230	237	241	240	243	241	239
East	Ink Jet Cartridges	Corporate	Karen Winthrop	872	877	885	891	886	884	886	882	878	894	891	896	905	903	903	861	862	854	852	851	850	849	858	881
East	Ink Jet Cartridges	Corporate	Walter Jones	321	324	327	324	327	324	325	327	325	327	334	331	339	347	352	316	317	326	330	331	337	341	350	358
East	Ink Jet Cartridges	Educational	Nathan Clark	735	746	745	766	764	760	774	784	791	794	800	817	843	847	847	879	878	872	879	885	896	896	900	903
East	Ink Jet Cartridges	Educational	Rachel Smith	472	472	476	482	487	497	500	500	495	499	503	514	525	531	532	562	563	559	559	561	558	557	553	556
East	Ink Jet Cartridges	Educational	Karen Winthrop	115	117	117	116	116	118	119	119	121	121	120	120	121	120	120	155	154	153	153	152	152	152	154	157
East	Ink Jet Cartridges	Educational	Walter Jones	460	464	466	475	474	473	469	469	472	472	473	473	473	483	483	522	525	526	522	520	519	516	518	521
East	Ink Jet Cartridges	Governmental	Nathan Clark	114	113	115	116	116	118	118	117	120	119	121	122	121	123	123	161	162	161	160	162	162	161	161	160
East	Ink Jet Cartridges	Governmental	Rachel Smith	801	798	796	806	798	804	800	801	797	802	803	795	806	803	813	870	886	884	887	888	905	906	899	891
East	Ink Jet Cartridges	Governmental	Karen Winthrop	912	924	932	939	954	958	953	944	944	941	946	942	945	938	951	1,011	1,010	1,005	1,001	1,005	997	1,001	995	1,010
East	Ink Jet Cartridges	Governmental	Walter Jones	847	855	848	844	838	857	852	852	860	865	880	878	879	881	874	905	923	927	926	932	940	932	939	940
East	Copy Paper	Corporate	Nathan Clark	645	652	651	650	646	645	651	660	665	663	657	653	654	652	647	644	656	652	655	654	661	665	662	659
East	Copy Paper	Corporate	Rachel Smith	899	892	902	914	939	953	956	969	963	954	957	951	964	963	970	973	977	1,001	998	1,006	1,016	1,044	1,041	1,033
East	Copy Paper	Corporate	Karen Winthrop	914	918	929	921	917	921	921	914	928	950	941	941	935	933	926	931	949	940	936	937	945	946	967	970
East	Copy Paper	Corporate	Walter Jones	125	126	125	125	124	123	127	126	126	125	126	127	130	131	130	132	132	136	135	135	134	133	135	134
East	Copy Paper	Educational	Nathan Clark	955	972	964	963	985	985	1,009	1,023	1,034	1,047	1,043	1,056	1,070	1,078	1,084	995	994	1,023	1,014	1,015	1,030	1,030	1,035	1,039
East	Copy Paper	Educational	Rachel Smith	704	709	716	709	704	699	701	713	719	727	740	739	737	742	741	647	642	654	649	645	647	645	641	642
East	Copy Paper	Educational	Karen Winthrop	233	237	241	241	243	243	246	252	253	255	258	261	262	267	265	174	172	173	178	177	178	177	176	176
East	Copy Paper	Educational	Walter Jones	858	855	854	853	873	868	870	869	891	884	876	887	881	890	909	819	810	810	813	814	816	811	803	803
East	Copy Paper	Governmental	Nathan Clark	713	710	722	718	720	713	724	723	720	721	731	744	752	745	760	774	776	772	768	768	765	762	784	785
East	Copy Paper	Governmental	Rachel Smith	957	977	974	984	1,000	997	1,005	1,009	1,006	1,009	1,016	1,035	1,043	1,049	1,045	1,048	1,049	1,070	1,086	1,099	1,094	1,084	1,097	1,103
East	Copy Paper	Governmental	Karen Winthrop	987	1,006	1,025	1,035	1,047	1,048	1,052	1,060	1,064	1,060	1,078	1,078	1,084	1,100	1,105	1,105	1,104	1,105	1,126	1,129	1,153	1,142	1,144	1,146
East	Copy Paper	Governmental	Walter Jones	535	532	528	530	531	542	547	543	553	551	546	559	570	567	562	557	557	552	551	548	555	551	550	555
North	Toner Cartridges	Corporate	Nathan Clark	475	483	481	478	481	494	492	497	506	509	504	503	514	511	506	584	592	590	585	588	585	589	604	604
North	Toner Cartridges	Corporate	Rachel Smith	98	99	99	100	100	99	99	99	101	100	100	100	102	101	100	179	181	180	180	180	181	181	182	181
North	Toner Cartridges	Corporate	Karen Winthrop	820	833	829	850	846	861	857	850	873	869	869	863	863	862	873	948	943	939	955	951	948	942	944	949
North	Toner Cartridges	Corporate	Walter Jones	568	581	595	596	602	606	607	604	607	605	604	624	618	616	618	698	693	693	698	709	708	711	712	714
North	Toner Cartridges	Educational	Nathan Clark	304	304	302	302	302	301	304	301	298	299	300	301	303	305	310	299	299	300	308	318	316	316	319	324
North	Toner Cartridges	Educational	Rachel Smith	166	168	167	167	169	172	174	174	175	176	176	177	177	179	184	167	170	170	174	175	179	180	182	184
North	Toner Cartridges	Educational	Karen Winthrop	653	652	651	657	651	657	655	651	645	639	637	632	627	625	623	602	604	622	624	628	623	630	625	624
North	Toner Cartridges	Educational	Walter Jones	399	404	407	406	406	402	400	397	397	397	395	394	396	397	397	390	399	399	398	394	392	395	400	401
North	Toner Cartridges	Governmental	Nathan Clark	853	855	857	862	861	867	867	865	866	876	873	890	883	891	898	895	921	934	936	938	944	935	944	966
North	Toner Cartridges	Governmental	Rachel Smith	803	800	795	789	791	801	815	817	810	817	811	811	818	816	823	825	836	853	848	844	836	848	852	854
North	Toner Cartridges	Governmental	Karen Winthrop	535	534	533	531	531	538	542	545	553	553	556	551	551	559	554	553	553	549	544	540	547	544	556	551
North	Toner Cartridges	Governmental	Walter Jones	206	211	214	212	213	216	214	218	222	221	219	217	216	215	220	225	223	229	228	230	228	226	228	229
North	Ink Jet Cartridges	Corporate	Nathan Clark	640	635	635	638	652	646	648	642	639	660	659	669	676	691	700	661	656	657	654	669	682	675	683	687
North	Ink Jet Cartridges	Corporate	Rachel Smith	408	408	406	406	404	402	399	405	405	404	405	412	410	414	410	381	384	396	397	396	395	394	403	401
North	Ink Jet Cartridges	Corporate	Karen Winthrop	450	460	459	458	459	455	455	453	449	445	453	456	453	461	474	435	432	429	431	428	439	436	439	439
North	Ink Jet Cartridges	Corporate	Walter Jones	376	375	372	371	369	367	372	380	384	386	389	391	392	393	390	354	356	356	354	351	357	355	364	362
North	Ink Jet Cartridges	Educational	Nathan Clark	298	303	304	306	303	306	305	304	307	306	304	307	306	313	317	361	359	357	356	354	356	354	356	361
North	Ink Jet Cartridges	Educational	Rachel Smith	394	394	395	397	399	400	397	399	399	397	399	407	403	404	401	439	440	449	448	447	447	445	449	445
North	Ink Jet Cartridges	Educational	Karen Winthrop	547	560	560	569	579	587	595	607	608	602	598	603	608	610	617	653	652	646	647	642	647	662	663	668
North	Ink Jet Cartridges	Educational	Walter Jones	152	153	153	152	151	153	157	158	158	157	160	160	160	161	160	194	198	199	199	200	200	201	201	200
North	Ink Jet Cartridges	Governmental	Nathan Clark	749	742	738	749	771	778	781	786	790	790	790	792	804	809	810	848	859	866	862	866	873	876	875	886
North	Ink Jet Cartridges	Governmental	Rachel Smith	257	259	265	265	266	266	266	266	267	266	267	274	272	270	269	308	309	313	313	314	312	316	317	316
North	Ink Jet Cartridges	Governmental	Karen Winthrop	114	117	117	117	119	121	121	121	120	119	119	121	120	119	119	156	158	157	157	156	158	160	159	162
North	Ink Jet Cartridges	Governmental	Walter Jones	725	735	736	735	732	732	742	741	749	749	764	773	774	791	787	821	830	825	827	822	821	815	830	831
North	Copy Paper	Corporate	Nathan Clark	613	625	626	628	634	652	655	658	664	679	677	677	695	695	698	718	722	738	740	742	757	765	788	805
North	Copy Paper	Corporate	Rachel Smith	221	219	221	219	219	219	220	219	223	225	225	224	229	233	233	236	236	235	234	239	238	244	242	243
North	Copy Paper	Corporate	Karen Winthrop	187	188	189	188	188	187	188	188	188	189	189	192	191	192	191	192	196	196	195	196	195	198	198	198
North	Copy Paper	Corporate	Walter Jones	949	949	956	962	971	991	1,014	1,036	1,048	1,042	1,061	1,086	1,096	1,114	1,108	1,115	1,128	1,139	1,130	1,121	1,111	1,107	1,097	1,098
North	Copy Paper	Educational	Nathan Clark	257	263	267	266	270	271	279	283	288	287	286	286	286	291	291	199	206	209	206	212	212	217	218	218
North	Copy Paper	Educational	Rachel Smith	148	147	146	149	150	154	157	158	160	160	161	162	163	164	166	70	73	73	74	74	74	75	74	74
North	Copy Paper	Educational	Karen Winthrop	801	794	787	805	805	800	798	794	791	812	820	828	831	828	833	740	750	757	768	777	793	786	782	790
North	Copy Paper	Educational	Walter Jones	689	702	712	706	701	702	697	709	717	721	721	717	722	728	731	638	644	646	645	644	647	654	658	660
North	Copy Paper	Governmental	Nathan Clark	364	372	377	385	392	395	404	403	409	416	420	424	425	422	426	423	427	429	432	432	430	438	439	440
North	Copy Paper	Governmental	Rachel Smith	740	742	741	748	752	747	759	758	756	754	756	778	787	784	790	806	804	805	803	820	830	835	828	831
North	Copy Paper	Governmental	Karen Winthrop	773	772	774	775	776	771	768	764	764	761	760	756	756	753	755	761	766	777	781	784	805	808	803	802
North	Copy Paper	Governmental	Walter Jones	754	749	757	750	751	756	762	759	757	759	759	764	768	762	768	765	772	767	766	762	781	802	807	811
South	Toner Cartridges	Corporate	Nathan Clark	524	525	527	540	548	548	551	563	559	566	566	573	585	595	601	682	685	693	697	697	714	712	709	703
South	Toner Cartridges	Corporate	Rachel Smith	872	873	867	875	876	885	887	906	902	914	924	925	920	917	912	990	1,002	1,005	999	1,005	1,017	1,026	1,029	1,031
South	Toner Cartridges	Corporate	Karen Winthrop	496	492	497	501	496	494	490	487	483	481	485	485	484	486	486	569	566	563	564	563	564	563	571	581
South	Toner Cartridges	Corporate	Walter Jones	574	576	580	595	603	620	635	636	633	631	626	625	645	660	658	737	748	750	759	769	767	761	772	786
South	Toner Cartridges	Educational	Nathan Clark	877	885	904	913	917	936	945	940	958	951	949	942	950	946	962	946	943	935	944	935	942	937	951	944
South	Toner Cartridges	Educational	Rachel Smith	100	100	101	101	102	104	104	103	105	106	105	105	104	104	103	86	85	86	86	86	85	87	87	88
South	Toner Cartridges	Educational	Karen Winthrop	466	471	471	469	470	469	476	475	478	476	479	484	482	485	482	463	465	462	461	468	466	478	475	474
South	Toner Cartridges	Educational	Walter Jones	391	396	404	401	401	401	402	407	406	409	408	411	423	432	430	412	422	424	423	423	423	424	424	420
South	Toner Cartridges	Governmental	Nathan Clark	679	674	681	678	681	689	685	693	705	703	702	702	717	721	722	718	721	719	721	714	724	730	742	742
South	Toner Cartridges	Governmental	Rachel Smith	949	957	953	953	980	991	985	1,000	1,007	1,004	1,003	1,002	1,007	1,005	1,000	1,004	995	999	999	1,018	1,016	1,008	1,005	1,004
South	Toner Cartridges	Governmental	Karen Winthrop	699	696	691	690	698	705	701	698	703	709	712	725	724	732	725	722	735	731	738	744	740	747	745	740
South	Toner Cartridges	Governmental	Walter Jones	548	547	552	560	556	567	566	571	588	589	584	584	587	595	601	601	604	618	619	632	641	641	638	636
South	Ink Jet Cartridges	Corporate	Nathan Clark	412	409	407	403	400	408	414	415	411	420	426	422	423	427	431	389	393	392	389	385	386	386	383	386
South	Ink Jet Cartridges	Corporate	Rachel Smith	869	888	885	880	875	868	860	878	881	894	919	912	920	912	903	872	895	926	939	963	958	951	950	970
South	Ink Jet Cartridges	Corporate	Karen Winthrop	414	414	410	406	404	402	405	409	411	413	419	419	420	418	424	388	385	387	384	382	390	391	388	388
South	Ink Jet Cartridges	Corporate	Walter Jones	984	986	991	989	981	985	982	975	992	1,008	1,013	1,026	1,025	1,034	1,030	987	994	994	988	995	1,016	1,016	1,019	1,009
South	Ink Jet Cartridges	Educational	Nathan Clark	666	669	687	696	696	706	709	705	708	706	708	701	697	695	691	727	721	729	733	748	757	764	761	759
South	Ink Jet Cartridges	Educational	Rachel Smith	313	316	318	316	313	311	313	310	312	314	318	315	312	309	313	346	343	343	340	342	343	341	338	339
South	Ink Jet Cartridges	Educational	Karen Winthrop	772	767	762	780	787	782	780	781	788	790	787	784	781	774	780	831	844	844	864	866	867	867	875	878
South	Ink Jet Cartridges	Educational	Walter Jones	937	930	929	929	948	948	941	935	941	936	943	943	940	933	937	965	960	959	964	984	978	972	1,001	1,001
South	Ink Jet Cartridges	Governmental	Nathan Clark	478	487	487	486	490	490	493	492	488	487	490	492	497	505	504	542	549	549	557	555	561	556	552	553
South	Ink Jet Cartridges	Governmental	Rachel Smith	955	958	967	977	983	984	976	967	985	992	1,005	997	1,024	1,014	1,024	1,061	1,054	1,049	1,065	1,060	1,056	1,048	1,038	1,034
South	Ink Jet Cartridges	Governmental	Karen Winthrop	167	168	171	173	172	173	172	172	176	178	180	184	185	184	186	228	227	232	232	232	232	234	238	244
South	Ink Jet Cartridges	Governmental	Walter Jones	982	974	976	974	983	1,009	1,000	997	992	988	1,012	1,039	1,056	1,065	1,061	1,106	1,114	1,109	1,113	1,109	1,101	1,104	1,110	1,131
South	Copy Paper	Corporate	Nathan Clark	926	919	916	924	916	937	938	961	988	988	1,000	1,013	1,011	1,014	1,017	1,034	1,031	1,026	1,029	1,048	1,046	1,045	1,048	1,052
South	Copy Paper	Corporate	Rachel Smith	891	896	896	895	913	916	917	921	919	923	915	913	918	920	927	920	925	923	931	941	961	972	973	982
South	Copy Paper	Corporate	Karen Winthrop	306	312	315	316	313	318	316	314	320	320	317	314	323	320	317	314	318	317	319	317	316	315	320	319
South	Copy Paper	Corporate	Walter Jones	864	866	870	874	871	888	894	897	899	894	888	885	881	901	928	938	958	953	958	963	984	984	978	975
South	Copy Paper	Educational	Nathan Clark	197	198	200	198	197	200	202	203	206	206	207	211	209	212	212	121	120	121	120	119	118	116	118	120
South	Copy Paper	Educational	Rachel Smith	585	584	596	597	604	603	602	599	605	605	606	600	615	615	612	518	514	520	517	516	516	518	528	529
South	Copy Paper	Educational	Karen Winthrop	263	263	267	275	282	280	283	286	291	299	304	303	307	307	308	212	209	209	215	220	217	218	221	225
South	Copy Paper	Educational	Walter Jones	420	421	418	416	416	428	431	429	426	426	423	424	423	422	426	333	332	331	329	329	329	332	335	332
South	Copy Paper	Governmental	Nathan Clark	992	993	990	993	1,016	1,010	1,016	1,010	1,015	1,010	1,011	1,007	1,011	1,015	1,013	1,035	1,036	1,029	1,024	1,027	1,017	1,021	1,025	1,034
South	Copy Paper	Governmental	Rachel Smith	956	953	956	947	977	978	974	988	979	1,000	993	992	1,004	1,006	1,011	1,002	1,001	1,006	1,023	1,031	1,041	1,049	1,065	1,069
South	Copy Paper	Governmental	Karen Winthrop	944	949	943	935	928	943	954	954	948	941	937	928	931	928	930	933	940	933	930	928	927	926	919	912
South	Copy Paper	Governmental	Walter Jones	103	102	102	101	101	101	100	99	99	99	100	99	100	99	99	100	100	99	99	99	99	100	100	100
West	Toner Cartridges	Corporate	Nathan Clark	685	689	688	687	685	695	691	685	698	696	698	697	691	686	688	766	762	780	795	804	799	803	805	817
West	Toner Cartridges	Corporate	Rachel Smith	366	363	363	366	364	368	369	367	368	368	366	366	363	363	361	439	436	434	436	439	439	436	434	438
West	Toner Cartridges	Corporate	Karen Winthrop	192	196	199	199	198	200	198	199	199	199	200	199	198	200	205	285	283	282	281	280	280	278	277	280
West	Toner Cartridges	Corporate	Walter Jones	135	135	134	133	132	133	132	132	133	134	134	137	138	138	140	220	222	224	226	227	226	226	227	229
West	Toner Cartridges	Educational	Nathan Clark	177	176	177	179	181	181	183	182	181	180	183	183	185	189	188	173	173	172	174	180	179	181	181	181
West	Toner Cartridges	Educational	Rachel Smith	213	215	217	218	224	230	230	236	236	239	237	237	239	237	238	226	224	225	223	221	221	221	222	225
West	Toner Cartridges	Educational	Karen Winthrop	162	161	162	162	162	163	166	166	170	170	170	171	170	171	173	162	161	161	161	161	160	163	164	163
West	Toner Cartridges	Educational	Walter Jones	288	292	293	294	292	297	297	298	301	300	297	302	300	306	304	289	294	298	301	302	299	301	300	302
West	Toner Cartridges	Governmental	Nathan Clark	160	159	159	158	159	158	160	159	162	164	164	164	164	165	168	169	168	167	166	167	166	168	167	168
West	Toner Cartridges	Governmental	Rachel Smith	559	561	558	553	553	554	560	572	574	587	582	592	591	591	592	600	595	599	606	612	615	619	627	626
West	Toner Cartridges	Governmental	Karen Winthrop	892	898	909	905	898	891	906	900	924	940	940	940	945	951	961	986	990	989	994	992	994	996	1,001	1,012
West	Toner Cartridges	Governmental	Walter Jones	101	103	103	106	105	105	106	107	107	110	111	111	111	113	112	111	112	111	111	111	110	109	109	110
West	Ink Jet Cartridges	Corporate	Nathan Clark	437	433	439	440	442	441	440	437	443	444	455	456	457	455	452	414	421	428	433	436	436	440	442	439
West	Ink Jet Cartridges	Corporate	Rachel Smith	919	923	924	932	939	951	954	951	943	944	939	930	923	945	970	942	946	960	952	954	961	961	952	981
West	Ink Jet Cartridges	Corporate	Karen Winthrop	358	358	355	357	360	359	356	363	367	378	376	374	380	380	380	345	344	344	346	349	349	358	355	363
West	Ink Jet Cartridges	Corporate	Walter Jones	989	1,002	1,001	992	984	985	982	987	994	1,005	1,007	1,009	1,004	1,005	1,009	976	980	985	994	984	993	1,011	1,004	1,000
West	Ink Jet Cartridges	Educational	Nathan Clark	674	676	673	678	692	687	690	692	686	697	704	711	712	716	709	764	780	780	773	771	771	783	778	783
West	Ink Jet Cartridges	Educational	Rachel Smith	815	807	805	812	815	815	822	824	818	818	824	825	817	815	820	853	863	864	865	884	881	887	881	888
West	Ink Jet Cartridges	Educational	Karen Winthrop	205	203	202	202	200	201	206	205	209	209	208	210	213	214	213	246	246	249	254	260	258	260	259	259
West	Ink Jet Cartridges	Educational	Walter Jones	248	250	252	257	256	255	255	254	253	254	257	257	256	257	258	296	297	296	296	298	296	295	296	303
West	Ink Jet Cartridges	Governmental	Nathan Clark	162	163	166	168	171	174	173	176	178	180	183	184	185	188	188	225	228	227	226	225	225	225	225	228
West	Ink Jet Cartridges	Governmental	Rachel Smith	436	436	439	439	447	446	444	446	448	451	448	453	461	458	460	497	494	490	498	503	504	500	500	500
West	Ink Jet Cartridges	Governmental	Karen Winthrop	126	126	127	127	130	131	132	132	131	130	130	129	129	132	134	172	172	171	171	173	175	175	178	178
West	Ink Jet Cartridges	Governmental	Walter Jones	902	900	899	907	899	896	898	912	930	921	916	918	933	932	952	991	1,006	1,012	1,009	1,019	1,019	1,010	1,015	1,015
West	Copy Paper	Corporate	Nathan Clark	273	272	276	275	276	280	285	285	285	285	283	283	287	288	289	288	289	294	293	292	293	294	296	295
West	Copy Paper	Corporate	Rachel Smith	961	959	953	955	972	972	973	973	971	971	979	984	986	994	1,014	1,016	1,035	1,034	1,027	1,030	1,020	1,010	1,024	1,031
West	Copy Paper	Corporate	Karen Winthrop	482	478	481	477	477	485	492	496	502	499	499	504	502	506	504	511	514	511	506	507	511	516	513	523
West	Copy Paper	Corporate	Walter Jones	516	515	515	526	528	530	530	528	523	529	526	530	528	529	530	540	547	551	557	566	572	570	572	569
West	Copy Paper	Educational	Nathan Clark	169	168	170	169	170	174	174	176	175	174	175	176	176	175	174	82	82	84	84	87	88	87	88	89
West	Copy Paper	Educational	Rachel Smith	683	679	681	682	679	678	683	680	683	686	690	685	679	675	685	593	611	626	639	638	638	649	663	662
West	Copy Paper	Educational	Karen Winthrop	527	522	522	520	523	524	523	521	532	534	542	540	546	556	562	469	473	478	477	473	473	472	479	488
West	Copy Paper	Educational	Walter Jones	881	878	872	887	883	899	919	917	922	914	906	922	921	914	907	836	830	836	829	833	835	845	850	848
West	Copy Paper	Governmental	Nathan Clark	362	364	368	370	369	369	375	375	376	377	378	390	392	389	390	393	393	391	400	400	410	412	421	424
West	Copy Paper	Governmental	Rachel Smith	736	734	741	742	738	734	727	729	722	718	714	719	717	718	728	730	735	737	738	755	757	771	781	778
West	Copy Paper	Governmental	Karen Winthrop	245	243	243	242	248	247	251	250	254	258	261	261	262	265	266	268	268	269	267	266	267	269	269	271
West	Copy Paper	Governmental	Walter Jones	223	221	223	221	222	224	228	230	234	232	235	235	240	242	246	248	249	249	253	253	255	255	259	262

Instructions

	FIN 615 Excel Dashboard Assignment
		Print it Green, Inc. is a manufacturer of recycled printing supplies. The company began operations on 10/1/2008 and is dedicated to producing sustainable green printing products. Print it Green, Inc. provides recycled laser toner cartridges, recycled ink jet cartridges as well as cases of recycled copy paper to a variety of customers across the United States.
		Upper management created several detailed sales forecasts for FY 2010. Now that Print it Green, Inc. is beginning the final quarter of their year, management has requested that a detailed analysis be performed as to whether the company is expected to achieve the forecasted results.
		Print it Green's Sales Manager has pulled together the detailed sales forecasts for FY 2010 as well as the inception-to-date sales data from their accounting system (see the additional tabs below). She has requested that an Excel Dashboard be created to illustrate on a detailed basis whether or not the company is expected to achieve total forecasted sales of $1,006,000 for FY 2010.
		Using at least three of the Excel functions and/or capabilities that we have learned in class, create an Excel Dashboard that will address the Sales Manager's request for Print it Green, Inc.