• Using the Brand sheet and dataset provided, vlookup the Brand column into the Test Dataset sheet (column W). Please leave the live formula in the column.
 

StoreID	TradeChannel	Region	Date	Product ID	Product Description	Product Category	PackSize	PackType	Unit Price	Facings_Cold	Facings_Warm	TotalFacings_Shop	OpeningStock	Stock_FridgeUnits	TotalStock_Fridge	Stock_FrontShopUnits	Stock_StoreroomUnits	TotalStock_Shop	PurchaseUnits	SalesVolume	Sales Units	Brand
335202	On Premise	North	Apr-21	463554	Guinness Smooth 500ml RGB	Beer	500	RGB	700	4	0	4	108	20	20	18	0	38	60	65	130
335202	On Premise	North	Apr-21	463555	Guinness FES 650ml RGB	Beer	650	RGB	1200	4	0	4	84	20	20	24	0	44	96	88.4	136
335202	On Premise	North	Apr-21	463556	Guinness FES 330ml RGB	Beer	330	RGB	650	12	0	12	106	84	84	48	0	132	120	31.02	94
335202	On Premise	North	Apr-21	463557	Harp Premium Lager 600ml RGB	Beer	600	RGB	700	3	0	3	96	15	15	24	0	39	111	100.8	168
335202	On Premise	North	Apr-21	463558	Orijin HAB 600ml RGB	RTD	600	RGB	700	4	0	4	96	20	20	24	0	44	72	74.4	124
335202	On Premise	North	Apr-21	463559	Smirnoff Ice Double Black 330ml RGB	RTD	330	RGB	650	3	0	3	60	18	18	36	0	54	48	17.82	54
335202	On Premise	North	Apr-21	463560	Smirnoff Ice Pineapple Punch 330ml RGB	RTD	330	RGB	650	4	0	4	60	22	22	48	0	70	48	12.54	38
335202	On Premise	North	Apr-21	463592	Malta Guinness 330ml RGB	CSD	330	RGB	500	0	0	0	48	24	24	24	0	48	48	15.84	48
335202	On Premise	North	Apr-21	463601	33 Export 500ml Can	Beer	500	Can	700	0	0	0	60	10	10	18	0	28	36	34	68
335202	On Premise	North	Apr-21	463603	33 Export 650ml RGB	Beer	650	RGB	650	4	0	4	72	24	24	18	0	42	60	58.5	90
335202	On Premise	North	Apr-21	463634	Bullet 250ml Can	RTD	250	Can	900	2	0	2	48	8	8	0	0	8	48	22	88
335202	On Premise	North	Apr-21	463639	Castel 650ml RGB	Beer	650	RGB	658	3	0	3	60	15	15	18	0	33	96	79.95	123
335202	On Premise	North	Apr-21	463648	Doppel 650ml RGB	Beer	650	RGB	650	4	0	4	72	24	24	18	0	42	60	58.5	90
335202	On Premise	North	Apr-21	463663	Heineken 500ml Can	Beer	500	Can	1000	1	0	1	48	5	5	0	0	5	48	45.5	91
335202	On Premise	North	Apr-21	463665	Heineken 330ml NRGB	Beer	330	NRGB	800	0	0	0	48	6	6	0	0	6	24	21.78	66
335202	On Premise	North	Apr-21	463672	Isenbeck Pilsener 500ml Can	Beer	500	Can	800	0	0	0	0	0	0	48	0	48	48	0	0
335202	On Premise	North	Apr-21	463673	Isenbeck Pilsener 650ml RGB	Beer	650	RGB	750	5	0	5	96	25	25	28	0	53	96	90.35	139
335202	On Premise	North	Apr-21	463675	K44 500ml RGB	Beer	500	RGB	500	2	0	2	96	12	12	16	0	28	48	58	116
335202	On Premise	North	Apr-21	463677	Kadji 650ml RGB	Beer	650	RGB	650	6	0	6	96	35	35	48	0	83	216	148.85	229
335202	On Premise	North	Apr-21	463685	Manyan 650ml RGB	Beer	650	RGB	500	5	0	5	120	26	26	36	0	62	132	123.5	190
335202	On Premise	North	Apr-21	463690	Mutzig 650ml RGB	Beer	650	RGB	650	4	0	There are 3 Steps involved in it Step: 1 Get Instant Access to Expert-Tailored Solutions See step-by-step solutions with expert insights and AI powered tools for academic success Step: 2 Step: 3 Ace Your Homework with AI Get the answers you need in no time with our AI-driven, step-by-step assistance Get Started Recommended Textbook for Concepts of Database Management Authors: Philip J. Pratt, Joseph J. Adamski 7th edition 978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591 More Books Students also viewed these Databases questions Question ★★★★★ The Edgeworth box diagram can also be used to show how a production possibility frontier is constructed for an economy as a whole. Suppose there are only two goods that might be produced (X and Y),... Answered: 1 week ago Question ★★★★★ =+1. Focusing on schools as positive learning environments, what are the most relevant exogenous and endogenous factors that enable students to flourish in school? Answered: 1 week ago Question ★★★★★ Self-Acceptance and Avoidance For healthy self-esteem, its important to know your weaknesses so that you can find creative ways to work around them. However, its also important to cope with your... Answered: 1 week ago Question ★★★★★ The following inventory data relate to Edwards, Inc.: Calculate the following for the year: a. Direct materials purchased. b. Direct labor costs incurred. c. Cost of goods sold. d. Gross profit.... Answered: 1 week ago Question ★★★★★ Coronado Company has gathered the following information: During the year, 3,190 units were produced, 10,600 hours were worked, and the actual manufacturing overhead was $20,500. Actual fixed overhead... Answered: 1 week ago Question ★★★★★ question 7 A tire pressure gauge reads 30 psi when the atmospheric pressure is 14 psi. The net force on 2 square inches of the tire is Group of answer choices 28 lbs. 32 lbs. 60 lbs. 88 lbs. none of... Answered: 1 week ago Question ★★★★★ In two to three paragraphs use the examples in this module (Col Howard, LtCol Gadson, Flight 93, Heather Penney) to answer the following questions: 1. Does your sense of duty cr-eate your values or... Answered: 1 week ago Question ★★★★★ A disadvantage of small Latin squares designs is that they provide relatively small degrees of freedom, so , if tends to be desirable to replicate them to increase the error degrees of freedom? Answered: 1 week ago Question ★★★★★ 3 . ) What is the time of completion, and why must it be clearly stated in the contract agreement provisions? Answered: 1 week ago Question ★★★★★ Let x represent the number of tails when a fair coin is flipped 100 times. a) Compute the distribution of x and represent it using a bar plot. b) Calculate the mean (expected value) and the standard... Answered: 1 week ago Question ★★★★★ What is the primary reason we have developed and employ an expansive body of knowledge of project management today? Answered: 1 week ago Question ★★★★★ Pay him, do not wait until I sign Answered: 1 week ago Question ★★★★★ Tell what you mean without sounding too dominant, i.e. show authority without sounding instructive Answered: 1 week ago Question ★★★★★ Speak clearly and distinctly with moderate energy Answered: 1 week ago Previous Question Next Question View Answer in SolutionInn App Services Sitemap Fun Definitions Become Tutor Study Help Categories Recent Questions Expert Questions Company Info Security Copyrights Privacy Policy Terms & Conditions SolutionInn Fee Scholarship Get In Touch About Us Contact Us Career Jobs FAQ Campus Ambassador Secure Payment Download Our App © 2024 SolutionInn. All Rights Reserved