Download the TOTAL SALES FOR JANUARY 2022 Spreadsheet file and save it as an Excel document as follows: (Your Last Name) Total Sales - JANUARY 2022.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 a "Y" 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%): Candy County rate (2%): Meal rate (1%): Y Y N 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. 1 IMPORTANT NOTES: 2 Total Sales Receipts Year-to-Date: Monthly numbers listed represent the quantity of units SOLD, NOT $ amounts. 3 For Columns F,I,L you will type in Y or N 4 For Columns E,G,H,J,K,M,N,O,P these are formulas and you DO NOT type over the formulas 5 6 Prepared State Rate? County Rate? Meal Rate? 7 Product/Service: List Price: Store Section: JANUARY 2022 (Qty Sold) Total Sales ($): Y or N Taxable Sales Amount State Rate 4.75% Y or N Taxable Sales Amount County Rate 2% Y or N Taxable Sales Amount Prepared Meal Rate 1% Total Sales Tax Due Total Due: 8 9 Antacid 1.79 Central 15.00 $26.85 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $26.85 10 Aspirin 1.49 Central 15.00 $22.35 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $22.35 11 Bathroom Tissue 4.39 Central 6.00 $26.34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $26.34 12 BBQ Sandwich 2.49 Grill 719.00 $1,790.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,790.31 13 Beer (6-Pk) - Off Premises 5.29 Central 821.00 $4,343.09 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $4,343.09 14 Beer (12 Pk. )- Off Premises 9.99 Central 424.00 $4,235.76 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $4,235.76 15 Beer (Case) - Off Premises 15.99 Central 306.00 $4,892.94 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $4,892.94 16 Bottled Water 1.29 Central 906.00 $1,168.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,168.74 17 Bread 2.19 Central 201.00 $440.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $440.19 18 Cabbage (Produced) - each 2.00 Nursery 19.00 $38.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $38.00 19 Candy Bars (no flour) 0.99 Central 521.00 $515.79 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $515.79 20 Canned Soup 1.69 Central 36.00 $60.84 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $60.84 21 Cantaloupes (Produced) - each 2.19 Nursery 0.00 $0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $0.00 22 Cheese 3.19 Central 43.00 $137.17 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $137.17 23 Cheeseburger 2.29 Grill 1,069.00 $2,448.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $2,448.01 24 Chewing Gum 0.89 Central 267.00 $237.63 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $237.63 25 Chewing Tobacco 3.49 Central 67.00 $233.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $233.83 26 Christmas Trees - 3 Ft. 20.00 Nursery 16.00 $320.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $320.00 27 Christmas Trees - 4 Ft. 25.00 Nursery 22.00 $550.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $550.00 28 Christmas Trees - 5 Ft. 30.00 Nursery 43.00 $1,290.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,290.00 29 Christmas Trees - 6 Ft. 35.00 Nursery 46.00 $1,610.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,610.00 30 Christmas Trees - 7 Ft. 40.00 Nursery 27.00 $1,080.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,080.00 31 Cigarettes per pack 4.89 Central 697.00 $3,408.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $3,408.33 32 Cigarettes - per carton 49.99 Central 37.00 $1,849.63 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,849.63 33 Cigars 34 Coffee (Hot) 35 Cookies 36 Corn (Produced) - per lb. 3.99 Central 20.00 $79.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $79.80 0.99 Central 1,248.00 $1,235.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,235.52 1.09 Central 564.00 $614.76 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $614.76 0.75 Nursery 52.25 $39.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $39.19 37 Cucumbers (Produced) - per lb. 0.89 Nursery 81.25 $72.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $72.31 38 Facial Tissues 1.99 Central 10.00 $19.90 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $19.90 39 Fax Services (Over 10 pgs.) - per p 0.30 Printing 54.00 $16.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $16.20 40 Fax Services - per page 0.25 Printing 36.00 $9.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $9.00 41 Flour 2.79 Central 5.00 $13.95 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $13.95 42 French Fries 1.39 Grill 2,139.00 $2,973.21 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $2,973.21 43 Fruit Juice 2.69 Central 9.00 $24.21 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $24.21 44 Gasoline (Regular) - per gal. 3.69 Central 29,876.50 $110,244.29 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $110,244.29 45 Gasoline (Mid-grade) - per gal. 3.79 Central 14,938.30 $56,616.16 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $56,616.16 46 Gasoline (Premium) - per gal. 3.89 Central 6,136.00 $23,869.04 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $23,869.04 47 Grass Seeds - 5lb. Bag 15.89 Nursery 1.00 $15.89 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $15.89 48 Grass Seeds - 10lb. Bag 22.79 Nursery 1.00 $22.79 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $22.79 49 Grass Seeds - 20lb. Bag 29.99 Nursery 2.00 $59.98 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $59.98 50 Green Beans (Produced) - per lb. 0.79 Nursery 54.00 $42.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $42.66 51 Grilled Cheese Sandwich 1.29 Grill 345.00 $445.05 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $445.05 52 Hamburger 1.99 Grill 927.00 $1,844.73 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,844.73 53 Hamburger Rolls 1.49 Central 201.00 $299.49 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $299.49 54 Hanging Plants 8.99 Nursery 31.00 $278.69 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $278.69 55 Hanging Plants (grown inhouse) 7.59 Nursery 33.00 $250.47 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $250.47 56 Hay Bales 57 Headache Powders 20.00 Nursery 68.00 $1,360.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,360.00 1.99 Central 14.00 $27.86 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $27.86 58 Honey Buns 1.09 Central 566.00 $616.94 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $616.94 59 Hot Dog- single 0.99 Grill 1,069.00 $1,058.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,058.31 60 Hot Dog - 3 2.69 Grill 356.00 $957.64 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $957.64 61 Hot Dog Rolls 1.49 Central 212.00 $315.88 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $315.88 62 Ice Cream-pint 1.99 Central 16.00 $31.84 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $31.84 63 Laminating - Report Covers Only 1.00 Printing 13.00 $13.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $13.00 64 Legal Documents - per page 65 Milk - 1/2 Gal. 0.25 Printing 328.00 $82.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $82.00 2.59 Central 33.00 $85.47 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $85.47 66 Milk Gallon 3.69 Central 23.00 $84.87 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $84.87 67 Multiple Duplications* - per pg. 0.07 Printing 428.00 $29.96 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $29.96 68 Nabs 0.59 Central 621.00 $366.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $366.39 69 Napkins 2.59 Central 22.00 $56.98 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $56.98 70 Onion Rings 1.69 Grill 856.00 $1,446.64 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,446.64 71 Paper Plates 2.79 Central 44.00 $122.76 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $122.76 72 Paper Towels 5.69 Central 34.00 $193.46 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $193.46 73 Peaches (Produced) - per lb. 0.79 Nursery 82.25 $64.98 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $64.98 74 Photocopies per page 0.05 Printing 642.00 $32.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $32.10 75 Pimiento Cheese Sand. (Wrapped) 1.39 Central 56.00 $77.84 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $77.84 76 Plastic Forks 77 Plastic Knives 1.69 Central 44.00 $74.36 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $74.36 1.89 Central 22.00 $41.58 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $41.58 78 Plastic Spoons 1.79 Central 34.00 $60.86 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $60.86 79 Pork 'n' Beans 1.09 Central 416.00 $453.44 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $453.44 80 Portfolio (Up to 50 pages) per pg. 0.06 Printing 26.00 $1.56 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1.56 81 Potato Chips 0.99 Central 781.00 $773.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $773.19 82 Potted Plants 5.69 Nursery 67.00 $381.23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $381.23 83 Potted Plants (grown inhouse) 5.29 Nursery 73.00 $386.17 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $386.17 84 Pumpkins - Small (Up to 10 lbs.) 5.00 Nursery 226.00 $1,130.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,130.00 85 Pumpkins - Large (Over 10 lbs.) 7.50 Nursery 198.00 $1,485.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,485.00 86 Resumes (Up to 10 pages) per pg. 87 Saltine Crackers 0.20 Printing 528.00 $105.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $105.60 2.19 Central 26.00 $56.94 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $56.94 88 Sausage Dog (Heated in store MW) 89 Shrubs (purchased) 90 Soft Drinks 1.39 Central 6.79 Nursery 1.29 Central 53.00 $73.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $73.67 23.00 $156.17 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $156.17 91 Squash (Produced) per lb. 0.59 Nursery 7,162.00 45.00 $9,238.98 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $9,238.98 $26.55 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $26.55 92 Strawberries (Produced) - Quart 0.99 Nursery 0.00 $0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $0.00 93 Sub Sandwich - 6" 3.49 Grill 482.00 $1,682.18 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,682.18 94 Sub Sandwich -12" 6.19 Grill 289.00 $1,788.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $1,788.91 95 Sugar 3.29 Central 8.00 $26.32 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $26.32 96 Tomatoes (Produced) per lb. 0.79 Nursery 121.75 $96.18 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $96.18 97 Travel Kits * 4.29 Central 12.00 $51.48 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $51.48 98 Vegetable Seeds - Packs 0.69 Nursery 0.00 $0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $0.00 99 Vienna Sausage 0.99 Central 291.00 $288.09 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $288.09 100 Watermelons (Produced) 3.00 Nursery 0.00 $0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $0.00 101 Wet Wipes 1.29 Central 61.00 $78.69 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $78.69 102 Wine (Fortified) - Off Premises 4.99 Central 167.00 $833.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $833.33 103 Wine (Unfortified) - Off Premises 4.89 Central 137.00 $669.93 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $669.93 104 Young Trees (purchased) 9.99 Nursery 18.00 $179.82 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $179.82 105 $256,978.23 0.00 $0.00 0.00 $0.00 0.00 $0.00 $0.00 $256,978.23 106 107 108 OTHER CALCULATIONS: Receipts Exempt from State Tax 109 110 Total Due for Form E500 Line 21 0.00 111 112 113