Download the above TOTAL SALES FOR MARCH 2020 Spreadsheet file and save it as an Excel document as follows: (Your Last Name) Total Sales - MARCH 2020.xlsx Use this spreadsheet to do your work manually. When you initially open the spreadsheet, you will need to click on the tab titled "Enable Editing at the top of the spreadsheet. You may not be able to complete the spreadsheet at one sitting, so be sure to save your spreadsheet prior to leaving it. Complete the spreadsheet per the following instructions: You must determine if each item is subject to the State rate (4.75%). County rate (2%), and the Prepared Meal rate (1%). Under each corresponding column, place ay if the item is subject to that rate or an "N" If the item is not subject to that rate. EXAMPLE: Item: State rate (4.75%): County rate (2%); Meal rate (1%) Candy You will assume that the receipts from the Nursery are less than 50% of the total receipts of the Convenience Store. You will also assume that the receipts from the Printing section are less than 50% of the total receipts of the Convenience Store. Excel File Edit View Insert Format Tools Data Window Help Home Insert Total Sales March 2020 View Page Layout Formulas Data Calibri (Body). 11 . A- A B IU . L . S.A. Review - - Peste Copy Format General Wrap Text Merge & Center. $ . % ) 514 Cortion for X t fx w o 2 . 19 Fax Services (Over 10 49 Fax Services per page s) per po 10.00 54.00 213900 Gasoline Regular) pergal 45 Gasoline grada) perga 46 Gasoline (Premiumperga 50 Green Beans Produced). per 52 Hamburger 54 Hanging Plants 55 Hanging Plants grown inhouse 57 Headache Powders 58 Honey Buns 59 Hot Dog - single 60 Hot Dog - 3 61 Hot Dog Rolls 62 loe Cream - pink 63 Laminating-Report Covers Only 64 Legal Documents per page 55 M -1/2 Gal 66 M Gallion 67 Multiple Duplications. per po 13.00 22.00 34 00 59 Napkins 70 Onion Ring 71 Paper Plates 72 Paper Towels 73 Peaches Produced) - perb 14 Photocopies per page 75 Pimente Cheese Sand Wrapped March Sales + Sheet2 Sheet3 Ready Excel File Edit View Insert Format Tools Data Window Help Home Insert Total Sales March 2020 View Page Layout Formulas Data Calibri (Body). 11 . A- A B IU . L . S.A. Review - - Peste Copy Format General Wrap Text Merge & Center. $ . % ) 514 Cortion for X t fx w o 2 . 19 Fax Services (Over 10 49 Fax Services per page s) per po 10.00 54.00 213900 Gasoline Regular) pergal 45 Gasoline grada) perga 46 Gasoline (Premiumperga 50 Green Beans Produced). per 52 Hamburger 54 Hanging Plants 55 Hanging Plants grown inhouse 57 Headache Powders 58 Honey Buns 59 Hot Dog - single 60 Hot Dog - 3 61 Hot Dog Rolls 62 loe Cream - pink 63 Laminating-Report Covers Only 64 Legal Documents per page 55 M -1/2 Gal 66 M Gallion 67 Multiple Duplications. per po 13.00 22.00 34 00 59 Napkins 70 Onion Ring 71 Paper Plates 72 Paper Towels 73 Peaches Produced) - perb 14 Photocopies per page 75 Pimente Cheese Sand Wrapped March Sales + Sheet2 Sheet3 Ready Rohe Total Sales March 2020 Data A View Insert Page Layout Formulas X Cut Calibri (Body) 11 A Copy Format B . X fx Review = = Paste Wrap Text . 514 Merge & C . S . ) 71 Paper Plates 73 Peaches Produced) - part 75 Pimienta Cheese and Wragged] O Portfolio up to 50 pages 83 Potted Plants grown inho ) Pumpkins. Small (up to 10 lbs) 35 Pumpkins. Large Over 10 lbs) 86 Resumes (Up to 10 pages per pg 88 Sausage Dog (Heated in store ) Squash Produced) perb 92 Strawberries Produced) - Quart 93 Sub Sandwich - 6 94 Sub Sandwich - 12" 95 Sugar 96 Tomatoes Produced) per 97 Travel Kits 98 Vegetable Seeds Packs 99 Vienna Sausage 100 Watermelons Produced 101 Wet Wipes 102 Wine Fertised). Premises 103 Wine United Premium 104 Young Trees purchased) $179.82 March Sales Sheet2 Sheet3 Ready MacBook Pro Download the above TOTAL SALES FOR MARCH 2020 Spreadsheet file and save it as an Excel document as follows: (Your Last Name) Total Sales - MARCH 2020.xlsx Use this spreadsheet to do your work manually. When you initially open the spreadsheet, you will need to click on the tab titled "Enable Editing at the top of the spreadsheet. You may not be able to complete the spreadsheet at one sitting, so be sure to save your spreadsheet prior to leaving it. Complete the spreadsheet per the following instructions: You must determine if each item is subject to the State rate (4.75%). County rate (2%), and the Prepared Meal rate (1%). Under each corresponding column, place ay if the item is subject to that rate or an "N" If the item is not subject to that rate. EXAMPLE: Item: State rate (4.75%): County rate (2%); Meal rate (1%) Candy You will assume that the receipts from the Nursery are less than 50% of the total receipts of the Convenience Store. You will also assume that the receipts from the Printing section are less than 50% of the total receipts of the Convenience Store. Excel File Edit View Insert Format Tools Data Window Help Home Insert Total Sales March 2020 View Page Layout Formulas Data Calibri (Body). 11 . A- A B IU . L . S.A. Review - - Peste Copy Format General Wrap Text Merge & Center. $ . % ) 514 Cortion for X t fx w o 2 . 19 Fax Services (Over 10 49 Fax Services per page s) per po 10.00 54.00 213900 Gasoline Regular) pergal 45 Gasoline grada) perga 46 Gasoline (Premiumperga 50 Green Beans Produced). per 52 Hamburger 54 Hanging Plants 55 Hanging Plants grown inhouse 57 Headache Powders 58 Honey Buns 59 Hot Dog - single 60 Hot Dog - 3 61 Hot Dog Rolls 62 loe Cream - pink 63 Laminating-Report Covers Only 64 Legal Documents per page 55 M -1/2 Gal 66 M Gallion 67 Multiple Duplications. per po 13.00 22.00 34 00 59 Napkins 70 Onion Ring 71 Paper Plates 72 Paper Towels 73 Peaches Produced) - perb 14 Photocopies per page 75 Pimente Cheese Sand Wrapped March Sales + Sheet2 Sheet3 Ready Excel File Edit View Insert Format Tools Data Window Help Home Insert Total Sales March 2020 View Page Layout Formulas Data Calibri (Body). 11 . A- A B IU . L . S.A. Review - - Peste Copy Format General Wrap Text Merge & Center. $ . % ) 514 Cortion for X t fx w o 2 . 19 Fax Services (Over 10 49 Fax Services per page s) per po 10.00 54.00 213900 Gasoline Regular) pergal 45 Gasoline grada) perga 46 Gasoline (Premiumperga 50 Green Beans Produced). per 52 Hamburger 54 Hanging Plants 55 Hanging Plants grown inhouse 57 Headache Powders 58 Honey Buns 59 Hot Dog - single 60 Hot Dog - 3 61 Hot Dog Rolls 62 loe Cream - pink 63 Laminating-Report Covers Only 64 Legal Documents per page 55 M -1/2 Gal 66 M Gallion 67 Multiple Duplications. per po 13.00 22.00 34 00 59 Napkins 70 Onion Ring 71 Paper Plates 72 Paper Towels 73 Peaches Produced) - perb 14 Photocopies per page 75 Pimente Cheese Sand Wrapped March Sales + Sheet2 Sheet3 Ready Rohe Total Sales March 2020 Data A View Insert Page Layout Formulas X Cut Calibri (Body) 11 A Copy Format B . X fx Review = = Paste Wrap Text . 514 Merge & C . S . ) 71 Paper Plates 73 Peaches Produced) - part 75 Pimienta Cheese and Wragged] O Portfolio up to 50 pages 83 Potted Plants grown inho ) Pumpkins. Small (up to 10 lbs) 35 Pumpkins. Large Over 10 lbs) 86 Resumes (Up to 10 pages per pg 88 Sausage Dog (Heated in store ) Squash Produced) perb 92 Strawberries Produced) - Quart 93 Sub Sandwich - 6 94 Sub Sandwich - 12" 95 Sugar 96 Tomatoes Produced) per 97 Travel Kits 98 Vegetable Seeds Packs 99 Vienna Sausage 100 Watermelons Produced 101 Wet Wipes 102 Wine Fertised). Premises 103 Wine United Premium 104 Young Trees purchased) $179.82 March Sales Sheet2 Sheet3 Ready MacBook Pro