Discussion

CarlsCookiesData.ods

Home >Psychology homework help >Discussion

Week	Year	Month	Quarter	Gross Sales	Cookies Sold	Selling Price /Cookie	Snickerdoodles Sold	Peanut Butter Sold	Pumpkin Sold	Sugar Sold	Oatmeal Rasin Sold	White Choc. Mac. Sold	Gingerbread Sold	Black and White Sold	Macaron Sold	Cost to Make Cookies	Labor Cost	Rent Cost	Utilities Cost	Marketing Cost	Type of Marketing	# Discounts Given	Customer Sat.Rating	Average Customer Spend
1	2023	January	1	7890.45	2254	3.5	386	282	297	386	277	222	191	136	77	3535.33	1200.67	750.00	300.45	500.00	flyer	12	3	29.00
2	2023	January	1	8450.67	2414	3.5	245	251	342	240	395	399	104	139	299	4258.37	1300.78	750.00	320.56	600.00	coupon	45	9	30.00
3	2023	January	1	9023.89	2578	3.5	333	244	383	234	291	234	122	199	538	4756.45	1400.89	750.00	310.67	700.00	tv	23	8	35.00
4	2023	January	1	7654.32	2187	3.5	388	356	334	292	225	254	117	106	115	3513.47	1250.90	750.00	305.78	550.00	shopper	11	8	27.50
5	2023	January	1	8234.56	2353	3.5	349	351	396	399	275	199	178	100	106	3715.87	1350.01	750.00	315.89	650.00	radio	32	9	32.50
6	2023	February	1	8123.45	2321	3.5	271	244	397	357	203	204	184	144	317	3993.89	1320.12	750.00	310.12	620.00	flyer	8	4	31.00
7	2023	February	1	8345.67	2384	3.5	394	213	233	305	350	287	132	112	358	4118.21	1370.23	750.00	320.45	640.00	coupon	47	9	32.00
8	2023	February	1	8567.89	2448	3.5	227	335	254	304	365	365	173	120	305	4230.45	1420.34	750.00	330.78	660.00	tv	50	9	33.00
9	2023	February	1	7890.45	2254	3.5	307	396	388	256	375	232	145	135	20	3581.92	1200.67	750.00	300.45	500.00	flyer	27	7	33.00
10	2023	March	1	8450.67	2414	3.5	311	233	261	284	257	358	160	184	366	4275.35	1300.78	750.00	320.56	600.00	coupon	49	9	30.00
11	2023	March	1	9023.89	2578	3.5	221	239	280	226	219	271	105	180	837	5119.81	1400.89	750.00	310.67	700.00	tv	26	7	34.00
12	2023	March	1	7654.32	2187	3.5	341	350	384	398	235	200	129	87	63	3398.25	1250.90	750.00	305.78	550.00	shopper	26	7	29.00
13	2023	March	1	8234.56	2353	3.5	245	395	343	310	394	272	129	121	144	3875.38	1350.01	750.00	315.89	650.00	radio	25	7	32.50
14	2023	April	2	8123.45	2321	3.5	207	326	399	314	261	217	101	131	365	4094.69	1320.12	750.00	310.12	620.00	flyer	16	4	31.00
15	2023	April	2	8345.67	2384	3.5	355	354	374	287	292	321	158	160	83	3867.92	1370.23	750.00	320.45	640.00	coupon	25	8	32.00
16	2023	April	2	8567.89	2448	3.5	351	370	357	335	223	367	183	155	107	3971.81	1420.34	750.00	330.78	660.00	tv	10	5	33.00
17	2023	April	2	7890.45	2254	3.5	223	340	285	203	215	304	197	166	321	3993.40	1200.67	750.00	300.45	500.00	flyer	28	7	32.00
18	2023	May	2	8450.67	2414	3.5	378	220	271	391	336	329	197	131	161	3923.17	1300.78	750.00	320.56	600.00	coupon	48	10	32.00
19	2023	May	2	9023.89	2578	3.5	324	245	295	322	203	364	153	189	483	4656.31	1400.89	750.00	310.67	700.00	tv	8	3	34.00
20	2023	May	2	7654.32	2187	3.5	370	368	334	361	165	285	128	112	64	3432.41	1250.90	750.00	305.78	550.00	shopper	34	9	29.00
21	2023	May	2	8234.56	2353	3.5	221	235	256	241	343	350	191	158	358	4202.36	1350.01	750.00	315.89	650.00	radio	50	9	32.50
22	2023	May	2	8123.45	2321	3.5	363	246	363	276	373	357	120	113	110	3804.33	1320.12	750.00	310.12	620.00	flyer	9	4	31.00
23	2023	June	2	8345.67	2384	3.5	244	224	390	341	329	322	157	198	179	4038.01	1370.23	750.00	320.45	640.00	coupon	23	7	32.00
24	2023	June	2	8567.89	2448	3.5	371	399	311	297	239	352	112	180	187	4086.36	1420.34	750.00	330.78	660.00	tv	14	8	33.00
25	2023	June	2	7890.45	2254	3.5	262	350	281	224	222	218	125	151	421	4057.89	1200.67	750.00	300.45	500.00	flyer	43	10	29.00
26	2023	June	2	8450.67	2414	3.5	233	351	248	248	301	319	193	134	387	4280.79	1300.78	750.00	320.56	600.00	coupon	10	5	30.00
27	2023	July	3	9023.89	2578	3.5	375	392	302	214	396	331	162	108	298	4411.61	1400.89	750.00	310.67	700.00	tv	38	9	35.00
28	2023	July	3	7654.32	2187	3.5	295	382	265	352	272	169	189	172	91	3481.13	1250.90	750.00	305.78	550.00	shopper	27	3	29.00
29	2023	July	3	8234.56	2353	3.5	387	376	248	327	318	343	122	101	131	3789.73	1350.01	750.00	315.89	650.00	radio	47	9	32.50
30	2023	July	3	8123.45	2321	3.5	261	376	398	388	325	183	125	157	108	3744.12	1320.12	750.00	310.12	620.00	flyer	46	9	31.00
31	2023	July	3	8345.67	2384	3.5	304	355	223	297	275	291	109	151	379	4182.15	1370.23	750.00	320.45	640.00	coupon	37	8	32.00
32	2023	August	3	8567.89	2448	3.5	308	240	203	284	254	366	136	148	509	4465.13	1420.34	750.00	330.78	660.00	tv	18	4	33.00
33	2023	August	3	7890.45	2254	3.5	304	392	202	301	290	315	136	179	135	3704.94	1200.67	750.00	300.45	500.00	flyer	50	9	27.00
34	2023	August	3	8450.67	2414	3.5	374	324	281	289	213	352	178	123	280	4096.84	1300.78	750.00	320.56	600.00	coupon	32	7	30.00
35	2023	August	3	9023.89	2578	3.5	346	350	338	366	200	376	185	174	243	4334.40	1400.89	750.00	310.67	700.00	tv	19	6	34.00
36	2023	September	3	7654.32	2187	3.5	257	350	371	381	244	218	159	121	86	3483.63	1250.90	750.00	305.78	550.00	shopper	43	9	29.00
37	2023	September	3	8234.56	2353	3.5	369	352	225	305	311	224	121	159	287	3986.61	1350.01	750.00	315.89	650.00	radio	15	3	32.50
38	2023	September	3	8123.45	2321	3.5	370	287	239	396	257	271	166	193	142	3759.73	1320.12	750.00	310.12	620.00	flyer	36	9	31.00
39	2023	September	3	8345.67	2384	3.5	289	247	373	353	257	236	125	117	387	4170.38	1370.23	750.00	320.45	640.00	coupon	26	7	32.00
40	2023	September	3	8567.89	2448	3.5	360	284	248	204	201	253	113	164	621	4595.25	1420.34	750.00	330.78	660.00	tv	44	9	33.00
41	2023	October	4	7890.45	2254	3.5	393	257	359	361	275	164	125	175	145	3656.94	1200.67	750.00	300.45	500.00	flyer	34	8	29.00
42	2023	October	4	8450.67	2414	3.5	252	350	335	239	367	385	154	129	203	4111.59	1300.78	750.00	320.56	600.00	coupon	40	9	30.00
43	2023	October	4	9023.89	2578	3.5	339	210	344	242	277	348	151	113	554	4738.34	1400.89	750.00	310.67	700.00	tv	49	10	34.00
44	2023	October	4	7654.32	2187	3.5	234	273	225	367	272	400	128	142	146	3623.35	1250.90	750.00	305.78	550.00	shopper	19	6	29.00
45	2023	November	4	8234.56	2353	3.5	234	350	273	314	301	348	119	193	221	4022.22	1350.01	750.00	315.89	650.00	radio	50	10	32.50
46	2023	November	4	8123.45	2321	3.5	282	325	385	305	261	335	198	141	89	3780.22	1320.12	750.00	310.12	620.00	flyer	39	9	31.00
47	2023	November	4	8345.67	2384	3.5	364	230	388	257	326	214	129	134	342	4154.27	1370.23	750.00	320.45	640.00	coupon	49	8	32.00
48	2023	November	4	8567.89	2448	3.5	330	288	288	301	355	217	144	104	421	4291.06	1420.34	750.00	330.78	660.00	tv	34	9	33.00
49	2023	December	4	7890.45	2254	3.5	210	332	340	274	364	260	172	155	147	3768.22	1200.67	750.00	300.45	500.00	flyer	5	4	27.00
50	2023	December	4	8450.67	2414	3.5	258	375	259	352	215	398	136	143	278	4125.85	1300.78	750.00	320.56	600.00	coupon	7	3	30.00
51	2023	December	4	9023.89	2578	3.5	262	228	242	251	205	331	155	138	766	4987.36	1400.89	750.00	310.67	700.00	tv	19	5	34.00
52	2023	December	4	7654.32	2187	3.5	330	334	314	360	280	180	175	173	41	3430.03	1250.90	750.00	305.78	550.00	shopper	16	7	25.00
53	2024	January	1	8234.56	2353	3.5	393	336	394	258	343	254	120	150	105	3833.83	1350.01	750.00	315.89	650.00	radio	21	7	32.50
54	2024	January	1	8123.45	2321	3.5	348	254	233	232	262	233	185	172	402	4123.97	1320.12	750.00	310.12	620.00	flyer	33	8	31.00
55	2024	January	1	8345.67	2384	3.5	203	268	343	343	367	226	106	133	395	4223.90	1370.23	750.00	320.45	640.00	coupon	18	5	32.00
56	2024	January	1	8567.89	2448	3.5	301	226	358	275	385	293	102	197	311	4301.42	1420.34	750.00	330.78	660.00	tv	17	5	33.00
57	2024	January	1	7890.45	2254	3.5	236	381	270	354	296	301	151	173	92	3657.89	1200.67	750.00	300.45	500.00	flyer	39	9	28.00
58	2024	February	1	8450.67	2414	3.5	327	340	316	313	347	340	173	101	157	3956.99	1300.78	750.00	320.56	600.00	coupon	11	4	30.00
59	2024	February	1	9023.89	2578	3.5	308	370	369	227	371	208	170	112	443	4574.32	1400.89	750.00	310.67	700.00	tv	44	10	35.00
60	2024	February	1	7654.32	2187	3.5	337	347	361	225	243	240	134	154	146	3632.75	1250.90	750.00	305.78	550.00	shopper	18	9	27.50
61	2024	February	1	8234.56	2353	3.5	287	299	233	322	315	371	129	152	245	4005.63	1350.01	750.00	315.89	650.00	radio	22	5	32.50
62	2024	March	1	8123.45	2321	3.5	267	378	268	363	201	352	134	149	209	3879.88	1320.12	750.00	310.12	620.00	flyer	21	6	31.00
63	2024	March	1	8345.67	2384	3.5	213	200	281	400	206	316	165	191	412	4252.47	1370.23	750.00	320.45	640.00	coupon	14	3	32.00
64	2024	March	1	8567.89	2448	3.5	225	339	390	227	204	379	179	114	391	4383.36	1420.34	750.00	330.78	660.00	tv	25	6	33.00
65	2024	March	1	7890.45	2254	3.5	346	396	214	336	212	262	113	115	260	3758.86	1200.67	750.00	300.45	500.00	flyer	43	9	27.00
66	2024	April	2	8450.67	2414	3.5	221	338	244	237	205	293	118	157	601	4549.16	1300.78	750.00	320.56	600.00	coupon	33	8	30.00
67	2024	April	2	9023.89	2578	3.5	391	277	201	258	215	330	137	127	642	4777.49	1400.89	750.00	310.67	700.00	tv	43	8	34.00
68	2024	April	2	7654.32	2187	3.5	250	207	231	345	275	371	172	121	215	3689.14	1250.90	800.00	305.78	550.00	shopper	11	7	28.00
69	2024	April	2	8234.56	2353	3.5	297	299	285	378	357	279	167	106	185	3855.27	1350.01	800.00	315.89	650.00	radio	37	9	32.50
70	2024	May	2	8123.45	2321	3.5	368	253	228	244	313	247	136	132	400	4096.92	1320.12	800.00	310.12	620.00	flyer	11	3	31.00
71	2024	May	2	8345.67	2384	3.5	338	337	397	208	393	342	120	123	126	3964.65	1370.23	800.00	320.45	640.00	coupon	48	9	32.00
72	2024	May	2	8567.89	2448	3.5	289	322	209	222	226	233	198	177	572	4533.46	1420.34	800.00	330.78	660.00	tv	35	8	33.00
73	2024	May	2	7890.45	2254	3.5	399	280	252	332	201	323	129	132	206	3729.07	1200.67	800.00	300.45	500.00	flyer	32	7	25.00
74	2024	May	2	8450.67	2414	3.5	246	217	348	382	270	312	185	156	298	4155.54	1300.78	800.00	320.56	600.00	coupon	21	8	30.00
75	2024	June	2	9023.89	2578	3.5	233	360	215	361	222	319	122	116	630	4751.79	1400.89	800.00	310.67	700.00	tv	11	4	35.00
76	2024	June	2	7654.32	2187	3.5	347	392	282	242	201	366	128	116	113	3572.21	1250.90	800.00	305.78	550.00	shopper	30	7	27.50
77	2024	June	2	8234.56	2353	3.5	370	294	371	294	239	297	131	120	237	3961.01	1350.01	800.00	315.89	650.00	radio	17	7	32.50
78	2024	June	2	8123.45	2321	3.5	329	302	234	320	226	357	128	163	262	3956.96	1320.12	800.00	310.12	620.00	flyer	20	6	31.00
79	2024	July	3	8345.67	2384	3.5	314	365	280	216	367	378	179	115	170	3987.54	1370.23	800.00	320.45	640.00	coupon	24	7	32.00
80	2024	July	3	8567.89	2448	3.5	381	320	231	394	333	325	183	116	165	3949.56	1420.34	800.00	330.78	660.00	tv	15	3	33.00
81	2024	July	3	7890.45	2254	3.5	211	247	296	379	267	308	108	136	302	3900.73	1200.67	800.00	300.45	500.00	flyer	8	4	28.00
82	2024	July	3	8450.67	2414	3.5	258	288	259	221	238	209	173	175	593	4525.07	1300.78	800.00	320.56	600.00	coupon	23	7	30.00
83	2024	July	3	9023.89	2578	3.5	307	224	243	241	213	298	192	131	729	4915.34	1400.89	800.00	310.67	700.00	tv	17	6	35.00
84	2024	August	3	7654.32	2187	3.5	248	393	205	310	259	245	107	195	225	3708.39	1250.90	800.00	305.78	550.00	shopper	15	4	27.50
85	2024	August	3	8234.56	2353	3.5	280	208	338	292	254	238	193	189	361	4159.59	1350.01	800.00	315.89	650.00	radio	44	9	32.50