Question: Worksheet # 1 WINES ( 8 points ) 3 . Worksheet 1 ( Renamed Wines ) : Double click on Sheet 1 ( on bottom

Worksheet #1 WINES (8 points)3. Worksheet 1(Renamed Wines): Double click on Sheet 1(on bottom left -hand corner of workbook) and select Rename option then title the worksheet Wines. 4. Choose either four (4) varietals OR four (4) appellations/regions OR four (4) styles to track. The row headings will be by: Grape varietal such as Chardonnay, Moscato, Pinot Grigio, Merlot, and Cabernet SauvignonOR Appellation/region- 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. (750 ml,1.5 liter, etc.) Each size will receive its own column.b. Listed selling pricec. Total number of wine SKUs by varietal/region/style Remember each item has an individual SKU so you could see something like Wine Cube Cabernet Sauvignon in a 500 ml carton and a 3L box so that would mean 2 separate SKUS for the wine with the same name from the same brand. d. Number of wines discounted by varietal/region/style Keep in mind that some retailers offer discounts on single bottles as well as volume purchasing such 10% off when you purchase 6 bottles or a 12-bottle case discount. 5. Highlight in one color, the selling price of the lowest priced wine by varietal/appellation/style including the discount. 6. Highlight in a second color, the selling price of the highest priced wine by varietal/appellation/style including the discount. Worksheet #2 BEERS (4 points)7. Click the plus sign next to your Worksheet titled Wines and add Worksheet 2 which you should rename Beers. Include a header with your names on this worksheet. 8. Choose two (2) 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.12 oz bottleb. 12 oz canc. kegd. othere. Total number of beer SKUsf. Number of beers discounted. 9. Highlight in one color, the selling price of the lowest priced beer per one-12 oz bottle including discount. 10. Highlight in a second color, the selling price of the highest priced beer per one-12 oz bottle including discount. Worksheet #3 SPIRITS (4 points)11. Click the plus sign (+) next to your worksheet titled Beers and add Worksheet 3 which you should rename Spirits. Include a header with your names on this worksheet. 12. Choose two (2) spirits/liqueurs/cordials 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.25.6 ozb. Quartc. Literd. (1)/(2) 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!