Case study project

PepsiCoCaseStudySalesData_FinalSpring2020.xlsx

Home >Business & Finance homework help >Operations Management homework help >Case study project

2020 Actual Sales

USE AFTER MODELS HAVE BEEN BUILT
	Period 1				Period 2				Period 3				Period 4				Period 5				Period 6				Period 7				Period 8				Period 9				Period 10				Period 11				Period 12				Period 13
	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12	Week 13	Week 14	Week 15	Week 16	Week 17	Week 18	Week 19	Week 20	Week 21	Week 22	Week 23	Week 24	Week 25	Week 26	Week 27	Week 28	Week 29	Week 30	Week 31	Week 32	Week 33	Week 34	Week 35	Week 36	Week 37	Week 38	Week 39	Week 40	Week 41	Week 42	Week 43	Week 44	Week 45	Week 46	Week 47	Week 48	Week 49	Week 50	Week 51	Week 52
Sparky Supercenter NW	38,448	40,738	50,880	44,820	67,578	94,372	100,340	127,391	150,471	125,841	150,629	152,122	167,620	197,988	304,552	388,990	358,353	366,698	365,410	517,621	641,362	796,229	500,119	524,195	585,186	647,812	629,200	449,644	754,315	589,447	652,145	725,693	822,672	845,696	973,517	627,216	786,026	808,511	706,720	725,604	780,768	627,517	579,448	551,407	469,917	494,408	383,570	342,535	356,405	290,748	231,174	172,389
Sparky Supercenter SW	98,042	103,881	129,744	144,291	166,825	205,157	220,130	276,938	327,110	273,567	327,455	325,770	364,392	430,408	660,007	800,456	779,028	989,181	991,483	1,125,263	1,394,266	1,730,933	1,189,654	1,272,145	1,272,145	1,396,658	1,367,827	977,488	1,639,816	1,281,407	1,242,098	1,708,941	1,788,416	2,051,322	2,116,342	1,363,513	1,708,752	1,801,052	1,536,347	1,577,401	1,697,321	1,364,168	1,245,896	1,198,711	1,021,558	1,074,801	999,864	875,898	906,345	909,794	652,572	641,431
Sparky Supercenter SW 2	64,721	68,575	85,648	75,447	106,924	125,830	133,786	166,986	200,628	167,788	200,839	202,829	225,294	263,984	406,070	518,654	477,804	601,589	612,496	690,161	856,963	961,589	666,825	764,865	780,249	863,749	838,934	599,526	1,005,754	885,963	800,456	1,048,151	1,096,895	1,025,896	1,298,023	836,288	1,048,035	1,104,645	942,293	967,472	1,041,024	836,690	775,963	735,209	626,556	659,211	611,427	589,102	576,605	505,905	340,150	320,703
Sparky Supercenter MW	60,876	64,501	80,560	80,965	101,166	114,888	122,153	155,085	183,182	153,198	183,375	185,192	204,060	241,029	370,759	470,986	440,963	557,840	553,761	630,147	780,789	800,498	610,088	665,427	712,401	785,695	765,983	547,393	915,899	817,588	795,631	866,965	1,001,513	1,148,741	1,185,152	763,567	956,901	1,008,589	860,354	883,344	950,500	763,934	705,415	671,278	572,073	601,889	566,955	456,606	427,608	421,846	320,625	317,485
Sparky Supercenter SE	28,195	29,874	37,312	32,868	42,224	55,256	57,750	74,589	88,102	73,681	88,195	85,310	98,143	117,965	178,318	227,757	209,818	269,244	304,891	303,071	375,522	469,026	292,823	342,631	342,631	379,299	368,401	263,270	345,896	345,126	334,539	426,985	481,680	552,490	570,001	367,239	460,224	455,963	413,789	424,847	411,256	367,416	339,271	322,853	277,896	289,480	295,611	208,079	198,789	175,189	120,631	119,031
Sparky Supercenter NE	14,738	15,616	19,504	17,181	22,072	27,628	29,375	37,294	40,123	36,840	44,097	44,534	49,071	57,962	80,159	112,789	104,909	193,241	195,564	151,535	180,459	233,099	146,412	171,315	171,315	189,649	184,201	131,635	175,896	172,563	167,269	230,137	240,840	276,245	285,001	183,620	230,112	225,698	206,895	212,423	228,573	180,974	169,636	161,426	137,570	144,740	112,292	108,601	115,830	101,997	85,501	78,894