Question: Worksheet # 1 WINES ( 8 points ) 3 . Worksheet 1 ( Renamed Wines ) : Double click on Sheet 1 ( on bottom
Worksheet # WINES points Worksheet Renamed Wines: Double click on Sheet on bottom left hand corner of workbook and select Rename option then title the worksheet Wines. Choose either four varietals OR four appellationsregions OR four styles to track. The row headings will be by: Grape varietal such as Chardonnay, Moscato, Pinot Grigio, Merlot, and Cabernet SauvignonOR Appellationregion such as Bordeaux, Sonoma, Italy, and Paso RoblesOR Wine Styles such as Red Blend, Sparkling, Sweet, or Rose. The column headings will identify the a Size of packaging in which each product is sold. ml liter, etc. Each size will receive its own column.b Listed selling pricec. Total number of wine SKUs by varietalregionstyle Remember each item has an individual SKU so you could see something like Wine Cube Cabernet Sauvignon in a ml carton and a L box so that would mean separate SKUS for the wine with the same name from the same brand. d Number of wines discounted by varietalregionstyle Keep in mind that some retailers offer discounts on single bottles as well as volume purchasing such off when you purchase bottles or a bottle case discount. Highlight in one color, the selling price of the lowest priced wine by varietalappellationstyle including the discount. Highlight in a second color, the selling price of the highest priced wine by varietalappellationstyle including the discount. Worksheet # BEERS points Click the plus sign next to your Worksheet titled Wines and add Worksheet which you should rename Beers. Include a header with your names on this worksheet. Choose two brands of beer to track. The row headings will be by name brands of beer. The column headings will identify the size of packaging in which each product is sold. a oz bottleb. oz canc. kegd. othere. Total number of beer SKUsf. Number of beers discounted. Highlight in one color, the selling price of the lowest priced beer per one oz bottle including discount. Highlight in a second color, the selling price of the highest priced beer per one oz bottle including discount. Worksheet # SPIRITS points Click the plus sign next to your worksheet titled Beers and add Worksheet which you should rename Spirits. Include a header with your names on this worksheet. Choose two spiritsliqueurscordials to track. For example, you might track rum and liqueurs OR vodka and whiskey. The row headings will be all the brands for each spirit category. The column headings will identify the size of packaging in which each product is sold. a ozb. Quartc. Literd. gallone. Otherf. Selling price for each productg. Total number of spirit products were discounted.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
