Costing please?database Name Birthday Food Type Cost Type Count Subtotal Abel...

Question

Costing please?database 	Name	Birthday	Food	Type	Cost	Type	Count	Subtotal 	Abel Feehan	10/24/82	parsley	Herb	$2.00	Herb	10	$29.94 	Arturo Mcmann	4/19/98	molasses	Sugar	$3.00	Sugar	7	$24.96 	Lucius Lapp	3/15/70	grouper	Seafood	$20.00	Seafood	17	$375.45 	Carmelita Funderburke	1/23/80	brown sugar	Sugar	$3.00	Spread	4	$20.50 	Daren Holdren	1/17/99	marmalade	Spread	$5.00	Cereal	9	$31.95 	Tish Helms	12/21/86	peanut butter	Spread	$6.50	Sauce	9	$25.00 	Stefania Mandell	12/22/77	corn flour	Cereal	$2.00	Nut	9	$60.96 	Penni Osier	2/9/84	hoisin sauce	Sauce	$4.00	Fruit	15	$51.53 	Cami Fortman	8/29/00	tuna	Seafood	$15.00	Drink	9	$48.15 	Kip Betterton	9/2/86	moo shu wrappers	Cereal	$4.00	Cheese	7	$36.44 	Louanne Ohalloran	12/22/87	hazelnuts	Nut	$5.00	Vegetable	19	$66.94 	Susanna Weist	10/19/95	tomato sauce	Sauce	$4.00	Meat	10	$162.96 	Alise Schiffman	12/20/80	mussels	Seafood	$15.00	Seasoning	13	$40.00 	Joette Moris	7/24/88	blackberries	Fruit	$5.00	Pickle	1	$3.00 	Verlene Summerford	7/15/71	cider	Drink	$3.00	Dairy	5	$22.96 	Sherrill Purnell	6/8/79	ricotta cheese	Cheese	$6.00	Salad	4	$18.99 	Raina Fenstermacher	2/9/88	beets	Vegetable	$2.00	Ingredient	1	$3.00 	Carola Groesbeck	10/18/92	lima beans	Vegetable	$2.00 	Micaela Trostle	2/22/97	basil	Herb	$3.00 	Evelyn Biggerstaff	10/22/80	grapes	Fruit	$6.00 	Johnathon Pierre	2/17/91	lamb	Meat	$16.00 	Jone Jacko	2/24/91	chicory	Seasoning	$2.00 	Bonny Salley	11/2/97	pomegranates	Fruit	$2.00 	Essie Wishart	8/5/84	flounder	Seafood	$23.50 	Jong Musante	3/25/97	rice wine	Drink	$3.00 	Leola Hubler	8/13/91	cashew nut	Nut	$5.00 	Margert Blade	12/26/91	scallops	Seafood	$18.00 	Sherley Mickelson	4/28/97	Romano cheese	Cheese	$5.00 	Columbus Ketchum	2/17/94	sazon	Seasoning	$2.00 	Hedy Liedtke	8/28/96	pumpkin seeds	Cereal	$5.00 	Georgina Aller	8/27/81	summer squash	Vegetable	$2.50 	Loyce Brimer	12/7/88	anchovies	Seafood	$10.00 	Joaquina Mccraw	12/21/74	celery seeds	Seasoning	$1.00 	Rosio Dosch	10/18/78	granola	Cereal	$3.00 	Maragaret Hanshaw	5/3/98	vanilla bean	Seasoning	$2.00 	Tereasa Rueckert	3/8/00	catfish	Seafood	$20.00 	Yu Hagemeier	4/17/82	black olives	Vegetable	$7.00 	Florentina Maskell	10/9/77	monkfish	Seafood	$18.00 	Simon Hammack	7/11/95	guavas	Fruit	$3.00 	Marcene Sentell	6/17/85	white chocolate	Sugar	$6.00 	Amber Dederick	8/30/98	ginger	Seasoning	$7.00 	Russell Gearhart	2/17/68	balsamic vinegar	Sauce	$2.00 	Claud Crossen	4/14/86	blue cheese	Cheese	$6.00 	Slyvia Ertl	7/3/90	Parmesan cheese	Cheese	$6.00 	Katrice Cearley	11/1/89	liver	Meat	$16.00 	Cristine Eakle	3/2/85	chicken	Meat	$18.00 	Marquetta Hoopes	12/26/70	red cabbage	Vegetable	$2.00 	Niesha Rojas	8/19/68	rabbits	Meat	$29.00 	Hans Kaster	1/28/84	aioli	Sauce	$3.00 	Tamesha Dewitt	8/2/71	horseradish	Seasoning	$3.00 	Trenton Nanney	5/23/94	lemon grass	Herb	$3.00 	Reyna Ewing	11/30/96	lobsters	Seafood	$25.00 	Brittany Lappin	11/5/75	bourbon	Drink	$2.70 	Flavia Cogar	5/13/92	spinach	Vegetable	$4.00 	Janet Keane	9/7/77	mint	Herb	$3.00 	Chance Emrick	11/20/81	pinto beans	Vegetable	$1.50 	Ethelene Rooks	11/26/94	soybeans	Vegetable	$1.99 	Clotilde Kenan	5/20/95	poultry seasoning	Seasoning	$2.00 	Jules Ayres	11/1/84	bananas	Fruit	$2.99 	Adalberto Redman	7/26/89	pistachios	Nut	$16.00 	Brice Pentz	8/12/76	herring	Seafood	$23.49 	Quintin Bachmann	9/29/92	date sugar	Sugar	$5.99 	Man Yelverton	10/13/81	pine nuts	Nut	$4.99 	Elicia Slater	1/18/85	zest	Seasoning	$3.00 	Susanne Bellard	12/10/84	sauerkraut	Pickle	$3.00 	Amparo Mayson	10/31/80	pecans	Nut	$7.00 	Rosanna Clingerman	11/17/90	watermelons	Fruit	$3.00 	Mana Congdon	12/6/77	shrimp	Seafood	$19.99 	Jesusita Tranmer	7/20/00	curry paste	Seasoning	$6.00 	Gladis Keeble	11/16/80	allspice	Seasoning	$3.00 	Aron Throneberry	5/29/87	eel	Seafood	$24.50 	Ivy Danis	1/21/73	sausages	Meat	$2.99 	Majorie Tibbitts	2/21/84	tomato puree	Vegetable	$3.00 	Vickey Faivre	10/16/97	turtle	Seafood	$52.00 	Shelly Lampe	5/19/97	cocoa powder	Seasoning	$2.00 	Mohamed Houseman	12/11/94	bacon grease	Meat	$16.00 	Zita Dotson	4/10/69	sage	Vegetable	$2.00 	Hershel Buescher	2/23/69	mozzarella	Cheese	$5.00 	Leonarda Towery	4/1/90	potatoes	Vegetable	$3.00 	Joie Kinsley	12/10/88	strawberries	Fruit	$2.49 	Yaeko Reyna	5/8/86	curry leaves	Herb	$2.99 	Zenobia Clayborn	4/29/66	cilantro	Herb	$2.99 	Remedios Spradlin	4/4/73	poppy seeds	Seasoning	$3.00 	Wen Fulton	11/3/99	carrots	Vegetable	$3.00 	Sybil Attwood	4/12/78	bean sauce	Sauce	$3.00 	Deedee Bax	8/12/98	almond butter	Spread	$6.00 	Germaine Edmiston	2/17/70	rice vinegar	Sauce	$3.00 	Moses Saylor	6/7/95	bean threads	Vegetable	$3.00 	Dorinda Buford	7/21/75	condensed milk	Dairy	$2.99 	Kasha Calixte	1/31/69	spearmint	Herb	$3.99 	Lashaun Hougland	7/10/93	pineapples	Fruit	$5.00 	Leeanne Freels	2/15/98	snap peas	Vegetable	$7.99 	Chelsey Block	10/10/72	bruschetta	Salad	$6.99 	Roseann Everly	10/6/91	kale	Vegetable	$3.00 	Kecia Bruss	11/27/93	coriander	Herb	$2.99 	Terrilyn Kurt	9/21/82	lentils	Vegetable	$1.99 	Xiao Trout	9/17/66	half-and-half	Dairy	$2.99 	Mimi Laboy	1/29/84	wine	Drink	$3.00 	Carrol Fortes	11/14/78	buckwheat	Cereal	$4.99 	Faye Reisch	2/29/84	gelatin	Ingredient	$3.00 	Neida Jerry	11/7/73	hot sauce	Sauce	$2.00 	Mora Brouse	2/26/97	walnuts	Nut	$4.99 	Michale Rothermel	2/21/74	caviar	Seafood	$28.00 	Arthur Coffey	9/8/87	rice paper	Cereal	$1.99 	Charlette Zuckerman	10/31/76	limes	Fruit	$2.49 	Concetta Danek	9/2/66	cider vinegar	Sauce	$2.00 	Vena Tarver	9/1/79	Tabasco sauce	Sauce	$2.00 	Tomoko Fertig	11/26/00	succotash	Salad	$4.00 	Laquanda Schroyer	12/25/90	almond paste	Nut	$4.00 	Sigrid Pinkley	7/18/77	quail	Meat	$18.00 	Ruby Montana	1/18/77	jelly beans	Sugar	$2.49 	Dorethea Oros	7/18/75	vanilla	Seasoning	$4.00 	Lucio Renfrew	1/27/85	yogurt	Dairy	$5.99 	Gala Harjo	2/11/92	margarine	Spread	$3.00 	Ricki Ruvalcaba	11/30/70	berries	Fruit	$5.99 	Malka Madore	11/16/75	oregano	Herb	$2.99 	Scot Holmon	3/20/75	ice cream	Dairy	$4.99 	Lavon Mealey	8/29/69	cod	Seafood	$23.99 	Marhta Morlock	8/17/77	bok choy	Vegetable	$2.49 	Jacinda Lauderback	2/28/84	pancetta	Meat	$21.99 	Soon Milian	11/30/75	passion fruit	Fruit	$1.00 	Ruthe Brimer	2/23/86	habanero chilies	Fruit	$2.00 	Leonie Honaker	8/24/96	brunoise	Salad	$3.00 	Angeles Brodeur	6/28/67	mesclun greens	Salad	$5.00 	Shantelle Fazzino	10/15/79	ale	Drink	$2.49 	Lenny Milot	10/27/84	nectarines	Fruit	$1.59 	Alpha Bromberg	1/17/70	barley sugar	Sugar	$2.49 	Dorla Vera	10/21/66	cornstarch	Cereal	$2.99 	Fawn Martinek	1/10/85	sour cream	Dairy	$6.00 	Alexandra Necaise	10/14/93	peanuts	Nut	$2.99 	Abbey Brumsey	3/6/72	huckleberries	Fruit	$4.99 	Sadie Angulo	11/2/80	powdered sugar	Sugar	$1.99 	Tashia Faul	2/10/00	clams	Seafood	$12.99 	Shon Repka	9/28/80	brazil nuts	Nut	$10.99 	Margarette Darrah	8/5/93	oatmeal	Cereal	$3.99 	Treasa Ratzlaff	2/5/68	rose water	Drink	$2.99 	Jone Pummill	8/20/97	steak	Meat	$18.99 	Majorie Leyendecker	2/4/77	brandy	Drink	$21.99 	Charlsie Tekulve	11/7/86	Marsala	Drink	$5.99 	Oma North	10/31/80	mackerel	Seafood	$25.99 	Shavonne Knabe	1/22/93	mushrooms	Vegetable	$9.99 	Luanna Thornley	12/15/67	coconuts	Vegetable	$4.49 	Lee Utterback	8/3/85	grits	Cereal	$3.99 	Mariela Monterroso	6/8/75	cottage cheese	Cheese	$2.45 	Carie Rosebrook	4/5/71	thyme	Herb	$2.99 	Marry Khalaf	4/12/72	colby cheese	Cheese	$5.99 	Tijuana Lundell	10/18/85	ham	Meat	$5.99 	Keely Dejean	12/19/81	chile peppers	Fruit	$3.99 	Orpha Gholston	5/28/84	amaretto	Drink	$2.99 Sheet1 	parsley 	molasses 	grouper 	brown sugar 	marmalade 	peanut butter 	corn flour 	hoisin sauce 	tuna 	moo shu wrappers 	hazelnuts 	tomato sauce 	mussels 	blackberries 	cider 	ricotta cheese 	beets 	lima beans 	basil 	grapes 	lamb 	chicory 	pomegranates 	flounder 	rice wine 	cashew nut 	scallops 	Romano cheese 	sazon 	pumpkin seeds 	summer squash 	anchovies 	celery seeds 	granola 	vanilla bean 	catfish 	black olives 	monkfish 	guavas 	white chocolate 	ginger 	balsamic vinegar 	blue cheese 	Parmesan cheese 	liver 	chicken 	red cabbage 	rabbits 	aioli 	horseradish 	lemon grass 	lobsters 	bourbon 	spinach 	mint 	pinto beans 	soybeans 	poultry seasoning 	bananas 	pistachios 	herring 	date sugar 	pine nuts 	zest 	sauerkraut 	pecans 	watermelons 	shrimp 	curry paste 	allspice 	eel 	sausages 	tomato puree 	turtle 	cocoa powder 	bacon grease 	sage 	mozzarella 	potatoes 	strawberries 	curry leaves 	cilantro 	poppy seeds 	carrots 	bean sauce 	almond butter 	rice vinegar 	bean threads 	condensed milk 	spearmint 	pineapples 	snap peas 	bruschetta 	kale 	coriander 	lentils 	half-and-half 	wine 	buckwheat 	gelatin 	hot sauce 	walnuts 	caviar 	rice paper 	limes 	cider vinegar 	Tabasco sauce 	succotash 	almond paste 	quail 	jelly beans 	vanilla 	yogurt 	margarine 	berries 	oregano 	ice cream 	cod 	bok choy 	pancetta 	passion fruit 	habanero chilies 	brunoise 	mesclun greens 	ale 	nectarines 	barley sugar 	cornstarch 	sour cream 	peanuts 	huckleberries 	powdered sugar 	clams 	brazil nuts 	oatmeal 	rose water 	steak 	brandy 	Marsala 	mackerel 	mushrooms 	coconuts 	grits 	cottage cheese 	thyme 	colby cheese 	ham 	chile peppers 	amaretto   Simple If Statement 	Date	age		pocket_money			pocket_money (alternative) 	8/28/17 13:57	5		2			2 	8/28/17 18:30	5		2			2 	8/29/17 18:31	5		2			2 	8/28/17 13:57	6		8			8 	8/28/17 18:30	6		8			8 	8/29/17 18:31	6		8			8 Nested IF statement 	Date	age	hour	minute		time of day		pocket_money		pocket_money (alternative)			pocket_money(penalty)		pocket_money(penalty) - alternative 	8/28/17 13:57	5	13	57		day time		2		2			2		2 	8/28/17 18:30	5	18	30		day time		2		2			2		2 	8/29/17 18:31	5	18	31		night time		2		2			3		3 	8/28/17 13:57	6	13	57		day time		8		8			8		8 	8/28/17 18:30	6	18	30		day time		8		8			8		8 	8/29/17 18:31	6	18	31		night time		8		8			9		9

Gaurav · Accepted Answer

Sheet1
	Quote date	Material	Size	Quote amount	Manufacturing cost ($)	Staff Name Week	Week
	2018-06-04	Wool	L	102.3	44.3	Abbey	23
	2018-06-04	Silk	XL	486	106.8	Abbey	23
	2018-06-05	Wool	M	68.3	38.5	Abbey	23
	2018-06-06	Leather	M	217.6	58.9	Abbey	23
	2018-06-07	Wool	S	142.3	37.3	Bridget	23
	2018-06-07	Silk	XL	233.9	118.6	Bridget	23
	2018-06-08	Wool	S	165.5	37.3	Bridget	23
	2018-06-08	Wool	L	119.8	48	Bridget	23
	2018-06-08	Tweed	XXL	224.3	94.3	Bridget	23
	2018-06-11	Wool	M	80	38.8	Abbey	24
	2018-06-11	Wool	S	78.3	35.5	Abbey	24
	2018-06-12	Wool	XS	70.6	31.9	Abbey	24
	2018-06-12	Wool	S	95.3	36.3	Abbey	24
	2018-06-13	Wool	XS	91.9	31.6	Abbey	24
	2018-06-14	Cotton	M	57.5	25.3	Bridget	24
	2018-06-14	Cotton	M	74.8	25	Bridget	24
	2018-06-15	Cotton	XS	100.3	19.3	Bridget	24
	2018-06-18	Cotton	S	57	23.8	Abbey	25
	2018-06-19	Cotton	XXL	93.3	33.5	Abbey	25
	2018-06-20	Cotton	S	64.6	24.9	Abbey	25
	2018-06-20	Wool	L	120.3	51.3	Abbey	25
	2018-06-20	Cotton	M	81.9	24.6	Abbey	25
	2018-06-21	Wool	S	156.5	39.3	Bridget	25
	2018-06-21	Wool	XL	145.8	51	Bridget	25
	2018-06-22	Wool	XXL	145.3	57.3	Bridget	25
	2018-06-25	Cotton	XXL	97	34.8	Abbey	26
	2018-06-25	Cotton	L	78.3	29.5	Abbey	26
	2018-06-25	Tweed	S	213.6	63.9	Abbey	26
	2018-06-26	Silk	S	345.3	89.3	Abbey	26
	2018-06-26	Cotton	L	88.9	30.6	Abbey	26
	2018-06-27	Cotton	XS	72.5	19.3	Abbey	26
	2018-06-27	Cotton	M	70.8	25	Abbey	26
	2018-06-27	Leather	M	183.3	54.3	Abbey	26
	2018-06-28	Wool	S	166	39.8	Bridget	26
	2018-06-29	Wool	L	175.3	52.5	Bridget	26
	2018-06-29	Cotton	M	66.6	25.9	Bridget	26
	2018-07-02	Silk	XL	540.3	119.3	Abbey	27
	2018-07-03	Leather	L	229.9	63.6	Abbey	27
	2018-07-03	Wool	XS	98.5	33.3	Abbey	27
	2018-07-04	Cotton	XXL	94.8	33	Abbey	27
	2018-07-05	Silk	XL	257.3	121.3	Bridget	27
	2018-07-06	Tweed	XS	288	56.8	Bridget	27
	2018-07-09	Wool	XS	103.3	35.5	Abbey	28
	2018-07-09	Wool	M	127.6	48.9	Abbey	28
	2018-07-09	Silk	S	439.3	92.3	Abbey	28
	2018-07-09	Cotton	M	78.9	23.6	Abbey	28
	2018-07-10	Silk	L	453.5	109.3	Abbey	28
	2018-07-11	Leather	M	188.8	50	Abbey	28
	2018-07-12	Wool	S	154.3	42.3	Bridget	28
	2018-07-13	Wool	L	141	53.8	Bridget	28
	2018-07-13	Cotton	XS	80.3	19.5	Bridget	28
	2018-07-16	Tweed	L	257.6	88.9	Abbey	29
	2018-07-16	Cotton	XS	65.3	18.3	Abbey	29
	2018-07-16	Cotton	XS	75.9	18.6	Abbey	29
	2018-07-17	Wool	XS	97.5	37.3	Abbey	29
	2018-07-17	Wool	M	113.8	47	Abbey	29
	2018-07-18	Silk	XS	456.3	75.3	Abbey	29
	2018-07-18	Cotton	XXL	94	33.8	Abbey	29
	2018-07-19	Cotton	M	65.3	25.5	Bridget	29
	2018-07-19	Wool	XS	104.6	36.9	Bridget	29
	2018-07-19	Cotton	XXL	101.3	34.3	Bridget	29
	2018-07-19	Wool	L	148.9	55.6	Bridget	29
	2018-07-20	Cotton	XXL	91.5	35.3	Bridget	29
	2018-07-23	Leather	XS	175.8	39	Abbey	30
	2018-07-23	Silk	M	449.3	102.3	Abbey	30
	2018-07-23	Tweed	S	244	70.8	Abbey	30
	2018-07-23	Leather	XS	203.3	40.5	Abbey	30
	2018-07-24	Leather	M	199.6	50.9	Abbey	30
	2018-07-24	Silk	S	501.3	90.3	Abbey	30
	2018-07-25	Cotton	XXL	89.9	32.6	Abbey	30
	2018-07-25	Cotton	S	72.5	22.3	Abbey	30
	2018-07-25	Leather	L	218.8	57	Abbey	30
	2018-07-26	Leather	M	116.3	49.3	Bridget	30
	2018-07-27	Wool	M	135	50.8	Bridget	30
	2018-07-27	Wool	XL	141.3	61.5	Bridget	30
	2018-07-27	Wool	XS	103.6	38.9	Bridget	30
	2018-07-30	Wool	S	120.3	47.3	Abbey	31
	2018-07-30	Silk	XS	412.9	79.6	Abbey	31
	2018-07-30	Cotton	XL	93.5	30.3	Abbey	31
	2018-07-31	Wool	XS	119.8	38	Abbey	31
	2018-07-31	Leather	M	198.3	49.3	Abbey	31
	2018-08-01	Cotton	S	78	23.

database NameBirthdayFoodTypeCostTypeCountSubtotal Abel Feehan10/24/82parsleyHerb$2.00Herb10$29.94 Arturo Mcmann4/19/98molassesSugar$3.00Sugar7$24.96 Lucius...

Answer To: database NameBirthdayFoodTypeCostTypeCountSubtotal Abel...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment