accounting 306( Micro app for accounting)
chang2014
excel.zipexcel/BlueLakeSports-03.xlsx
Revenue by Department
| Blue Lake Sports | ||||||
| First Quarter Sales by City | ||||||
| Department | Atlanta | Boston | Chicago | San Diego | St. Louis | Total |
| Apparel | $ 2,600 | $ 3,200 | $ 3,800 | $ 3,700 | $ 3,200 | $ 16,500 |
| Baseball | $ 3,500 | $ 1,200 | $ 1,350 | $ 2,100 | $ 2,475 | $ 10,625 |
| Basketball | $ 1,800 | $ 1,800 | $ 2,250 | $ 1,400 | $ 1,750 | $ 9,000 |
| Bike & Skate | $ 1,500 | $ 1,325 | $ 1,225 | $ 2,450 | $ 1,650 | $ 8,150 |
| Exercise | $ 2,650 | $ 2,875 | $ 3,250 | $ 3,775 | $ 2,950 | $ 15,500 |
| Fishing | $ 2,350 | $ 1,035 | $ 1,250 | $ 2,750 | $ 1,450 | $ 8,835 |
| Footwear | $ 1,875 | $ 2,675 | $ 3,575 | $ 3,250 | $ 2,950 | $ 14,325 |
| Game Room | $ 1,300 | $ 1,500 | $ 1,900 | $ 1,050 | $ 1,275 | $ 7,025 |
| Golf | $ 4,750 | $ 875 | $ 925 | $ 5,400 | $ 1,250 | $ 13,200 |
| Hockey | $ 850 | $ 1,875 | $ 1,950 | $ 750 | $ 1,650 | $ 7,075 |
| Hunting | $ 2,000 | $ 1,000 | $ 650 | $ 725 | $ 950 | $ 5,325 |
| Lacrosse | $ 1,750 | $ 1,800 | $ 1,750 | $ 1,375 | $ 1,150 | $ 7,825 |
| Running | $ 1,925 | $ 2,400 | $ 2,800 | $ 2,650 | $ 2,000 | $ 11,775 |
| Winter Sports | $ 1,250 | $ 34,350 | $ 2,750 | $ 550 | $ 1,550 | $ 40,450 |
| Total | $ 30,100 | $ 57,910 | $ 29,425 | $ 31,925 | $ 26,250 | $ 175,610 |
Atlanta Revenue by Week
| Blue Lake Sports | |||||
| January Sales in Atlanta | |||||
| Department | Week 1 | Week 2 | Week 3 | Week 4 | Total |
| Apparel | $ 235 | $ 325 | $ 215 | $ 450 | $ 1,225 |
| Baseball | $ 430 | $ 250 | $ 180 | $ 315 | $ 1,175 |
| Basketball | $ 85 | $ 150 | $ 90 | $ 200 | $ 525 |
| Bike & Skate | $ 200 | $ 325 | $ 75 | $ 175 | $ 775 |
| Exercise | $ 150 | $ 160 | $ 180 | $ 170 | $ 660 |
| Fishing | $ 75 | $ 150 | $ 85 | $ 200 | $ 510 |
| Footwear | $ 500 | $ 350 | $ 275 | $ 330 | $ 1,455 |
| Game Room | $ 45 | $ 75 | $ 35 | $ 15 | $ 170 |
| Golf | $ 175 | $ 350 | $ 580 | $ 200 | $ 1,305 |
| Hockey | $ 85 | $ 125 | $ 50 | $ 35 | $ 295 |
| Hunting | $ 125 | $ 350 | $ 475 | $ 450 | $ 1,400 |
| Lacrosse | $ 200 | $ 50 | $ 65 | $ 75 | $ 390 |
| Running | $ 165 | $ 235 | $ 325 | $ 180 | $ 905 |
| Winter Sports | $ 75 | $ 15 | $ - 0 | $ 15 | $ 105 |
| Total | $ 2,545 | $ 2,910 | $ 2,630 | $ 2,810 | $ 10,895 |
excel/BlueLakeSports-1.xlsx
Sheet1
| Blue Lake Sports Weekly Sales | |||||||
| 1-May-15 | |||||||
| Sales Categories | Monday | ||||||
| Children's Sports | 4503 | 3301 | 2304 | 2103 | 3210 | 7942 | 6201 |
| Men's Sports | 5502 | 4567 | 5543 | 2344 | 5107 | 8905 | 6103 |
| Women's Sports | 4201 | 3257 | 3408 | 3214 | 5203 | 7693 | 5932 |
| Total |
excel/ClientInfo-04.txt
Client Name Address Phone Number City State Zip Product/Service Date Gross Sales Heather Guyan 124 East Street 218-333-2313 Bemidji MN 56601 Training 10/7/2014 $1,567.04 Craig Brand 554 2nd Street 320-751-4433 Saint Cloud MN 56301 Technical Support 10/1/2014 $1,056.15 Wade Whitworth 1822 Highway 2 218-556-4211 Cass Lake MN 56633 Accounting Software 9/21/2014 $5,200.00 Terri Olander 459 10th Avenue 218-667-8977 Brainerd MN 56401 POS: Point of Sale Software 10/15/2014 $6,525.00 Charlie Lindberg 345 Lyndale Ave 612-543-2156 Minneapolis MN 55401 ERP: Enterprise Resource Planning 9/1/2014 $42,000.00 Hilary Marschke 245 West 3rd Ave 320-355-5443 Saint Cloud MN 56301 Training 11/15/2014 $750.00 Shelly Vlcko 402 2nd Ave SE 218-342-2456 Deer River MN 56636 Accounting Software 9/15/2014 $4,500.00 Mike Gunderson 304 Irvine Ave 218278-9021 Bemidji MN 56601 Technical Support 10/28/2014 $990.45 Jeremie Midboe Pilot Knob Rd 651-333-2789 Eagan MN 55121 POS: Point of Sale Software 11/1/2014 $7,500.00
excel/EllerSales-04.xlsx
MN Clients
| Eller Software Services |
| Adam White Client Information |
&K04-049&A
excel/HCCInvoice-02.xlsx
Invoice
| Hamilton Civic Center Invoice | ||||||
| 754 Rockford Court | Invoice NO. | 101 | ||||
| Hendersonville, TN 37038 | DATE | |||||
| 615-822-4965 | CUSTOMER ID | 203 | ||||
| Customer | Tara Strachan | SHIP TO | Tara Strachan | |||
| 122 Easy Street | 122 Easy Street | |||||
| Hendersonville, TN 37038 | Hendersonville, TN 37038 | |||||
| 615-822-2443 | 615-822-2443 | |||||
| QTY | ITEM # | DESCRIPTION | Back Order? | UNIT PRICE | LINE TOTAL | |
| 2.00 | 102 | |||||
| 3.00 | 103 | |||||
| 2.00 | 104 | |||||
| SUBTOTAL | ||||||
| SALES TAX RATE | 6.50% | |||||
| TOTAL | ||||||
| Authorized by | Date | |||||
Gift Shop Products
| Product Catalog | |||||
| Product # | Description | Qty on Hand | Unit Cost | Unit Price | Reorder? |
| 101 | T-Shirt | 120 | $ 4.00 | $ 11.00 | No |
| 102 | Shorts | 45 | $ 2.50 | $ 6.88 | No |
| 103 | Coffee Mug | 25 | $ 1.25 | $ 3.44 | No |
| 104 | Pants | 36 | $ 7.25 | $ 19.94 | No |
| 105 | Beach Towel | 22 | $ 3.50 | $ 9.63 | No |
| 106 | Sun Screen | 16 | $ 2.50 | $ 6.88 | No |
| 107 | Picture Frame | 56 | $ 2.25 | $ 6.19 | No |
| 108 | Pajamas | 24 | $ 5.50 | $ 15.13 | No |
| 109 | Candy | 90 | $ 0.20 | $ 0.55 | No |
| 110 | Magnet | 88 | $ 0.50 | $ 1.38 | No |
| 111 | Flowers | 15 | $ 4.50 | $ 12.38 | No |
| 112 | Book | 67 | $ 3.25 | $ 8.94 | No |
| 113 | Magazine | 56 | $ 4.35 | $ 11.96 | No |
| 114 | Stuffed Animal | 35 | $ 2.20 | $ 6.05 | No |
| 115 | Pen | 99 | $ 1.20 | $ 3.30 | No |
excel/SanDiego-02.xlsx
Fleet
| 4Hr Rate | Full Day Rate | |||||||||||||
| Boat ID | Boat Type | Length | Seats | Sleeps | 4 Hr Rate | Full Day Rate | Galley w/ Stove | Model Year | 5% Increase | 10% Increase | 15% Increase | 5% Increase | 10% Increase | 15% Increase |
| 1010 | Catalina 270 | 28'4" | 8 | 6 | $129.00 | $179.00 | 2000 | |||||||
| 1015 | Catalina 270 | 28'4" | 8 | 6 | $139.00 | $179.00 | 2001 | |||||||
| 1146 | Hunter 33 | 33'6" | 10 | 6 | $299.00 | $349.00 | 2004 | |||||||
| 1150 | Capri 22 Mk II | 24'8" | 6 | 4 | $65.00 | $89.00 | 2005 | |||||||
| 1152 | Capri 22 Mk II | 24'8" | 6 | 4 | $65.00 | $89.00 | 2005 | |||||||
| 1164 | Capri 22 Mk II | 24'8" | 6 | 4 | $65.00 | $89.00 | 2006 | |||||||
| 1168 | Hunter 33 | 33'6" | 10 | 6 | $299.00 | $349.00 | 2007 | |||||||
| 1175 | Beneteau 40 | 39'10" | 12 | 6 | $489.00 | $529.00 | 2008 | |||||||
| 1180 | Beneteau 373 | 36'11" | 10 | 6 | $369.00 | $409.00 | 2009 | |||||||
| 1185 | Hunter 36 | 35'6" | 10 | 6 | $349.00 | $389.00 | 2009 | |||||||
| 1190 | Beneteau 373 | 36'11" | 10 | 6 | $369.00 | $409.00 | 2010 | |||||||
| 1200 | Beneteau 373 | 36'11" | 10 | 6 | $369.00 | $409.00 | 2010 | |||||||
| 1205 | Beneteau 40 | 39'10" | 12 | 6 | $489.00 | $529.00 | 2012 | |||||||
| 1225 | Hunter 36 | 35'6" | 10 | 6 | $349.00 | $389.00 | 2012 | |||||||
| 1230 | Catalina 270 | 28'4" | 8 | 6 | $139.00 | $179.00 | 2012 |
excel/SierraPacificCC-03.xlsx
Tuition & Fees
| Sierra Pacific Community College District | ||||||
| Forecast for Academic Year 2015-2016 | ||||||
| Fall | Spring | InterSession | Summer | Totals | ||
| On-campus tuition | $12,163,200 | $11,403,000 | $2,345,000 | $8,973,150 | $34,884,350 | |
| Distance learning tuition | $7,194,600 | $6,994,750 | $1,150,000 | $3,314,510 | $18,653,860 | |
| Utilization fee | $575,568 | $559,580 | $92,000 | $265,161 | $1,492,309 | |
| Facilities fee | $1,459,584 | $1,368,360 | $281,400 | $1,076,778 | $4,186,122 | |
| Total Revenue | ||||||
&K04-049&F
Location 2- Breezy Point
| Paradise Lakes Resort | |||||||
| July 14 - 20, 2014 | |||||||
| Sales Categories | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |
| Cabin Rentals | 3,405.00 | 2,345.00 | 1,234.00 | 4,533.00 | 6,778.00 | 8,777.00 | 6,789.00 |
| Local Tours | 876.00 | 750.00 | 968.00 | 1,254.00 | 1,456.00 | 2,243.00 | 1,890.00 |
| Fishing Guides | 1,245.00 | 458.00 | 675.00 | 890.00 | 1,564.00 | 1,890.00 | 1,564.00 |
| Equipment Rentals | 358.00 | 250.00 | 325.00 | 678.00 | 654.00 | 876.00 | 657.00 |
| Food & Beverages | |||||||
| Apparel | 451.00 | 356.00 | 543.00 | 532.00 | 678.00 | 764.00 | 892.00 |
| Total | $ 6,335.00 | $ 4,159.00 | $ 3,745.00 | $ 7,887.00 | $ 11,130.00 | $ 14,550.00 | $ 11,792.00 |
&K04-049&F
excel/Suppliers-04.txt
| Supplier | Phone Number |
| Outdoor Inc. | 292-555-2334 |
| Outdoor Inc. | 292-555-2334 |
| Outdoor Inc. | 292-555-2334 |
| Outdoor Inc. | 292-555-2334 |
| Outdoor Inc. | 292-555-2334 |
| Outdoor Inc. | 292-555-2334 |
| Outdoor Inc. | 292-555-2334 |
| Outdoor Inc. | 292-555-2334 |
| Jennifer's Closet | 289-433-1555 |
| Jennifer's Closet | 289-433-1555 |
| Jennifer's Closet | 289-433-1555 |
| Jennifer's Closet | 289-433-1555 |
| Jennifer's Closet | 289-433-1555 |
| Jennifer's Closet | 289-433-1555 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Jennifer's Closet | 289-433-1555 |
| Jennifer's Closet | 289-433-1555 |
| Jennifer's Closet | 289-433-1555 |
| Jennifer's Closet | 289-433-1555 |
| Jennifer's Closet | 289-433-1555 |
| Jennifer's Closet | 289-433-1555 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
| Sport it! | 255-463-7896 |
excel/WearEverInventory-04.xlsx
Northern Warehouse
| Wear-Ever Shoes | ||||||||
| Current Stock | ||||||||
| Product ID | Product | Color | Size | Quantity | Men's or Women's | Cost | Retail | Reorder |
| WE001 | Rugged Hiking Boots | Brown | 8 | 5 | M | $46.50 | $90.00 | N |
| WE002 | Rugged Hiking Boots | Brown | 10 | 3 | M | $46.50 | $90.00 | Y |
| WE003 | Rugged Hiking Boots | Black | 9.5 | 6 | M | $46.50 | $90.00 | N |
| WE004 | Rugged Hiking Boots | Black | 10.5 | 4 | M | $46.50 | $90.00 | N |
| WE005 | Rugged Hiking Boots | Black | 7.5 | 4 | W | $53.50 | $98.00 | N |
| WE006 | Rugged Hiking Boots | Black | 8 | 2 | W | $53.50 | $98.00 | Y |
| WE007 | Rugged Hiking Boots | Brown | 9 | 3 | W | $53.50 | $98.00 | N |
| WE008 | Rugged Hiking Boots | Brown | 8.5 | 2 | W | $53.50 | $98.00 | Y |
| WE009 | Comfy Walking Shoes | Brown | 8.5 | 4 | M | $47.50 | $65.00 | N |
| WE010 | Comfy Walking Shoes | Black | 9 | 1 | M | $47.50 | $65.00 | Y |
| WE011 | Comfy Walking Shoes | Navy | 7.5 | 4 | W | $47.50 | $65.00 | N |
| WE012 | Comfy Walking Shoes | Black | 8 | 1 | W | $47.50 | $65.00 | Y |
| WE013 | Comfy Walking Shoes | Taupe | 7.5 | 2 | W | $47.50 | $65.00 | N |
| WE014 | Comfy Walking Shoes | Brown | 8 | 3 | W | $47.50 | $65.00 | Y |
| WE015 | Lazy Flip-Flops | Pink | 6 | 4 | W | $7.50 | $14.00 | N |
| WE016 | Lazy Flip-Flops | Pink | 7 | 0 | W | $7.50 | $14.00 | N |
| WE017 | Lazy Flip-Flops | Pink | 8 | 2 | W | $7.50 | $14.00 | Y |
| WE018 | Lazy Flip-Flops | White | 6 | 3 | W | $7.50 | $14.00 | N |
| WE019 | Lazy Flip-Flops | White | 7 | 1 | W | $7.50 | $14.00 | N |
| WE020 | Lazy Flip-Flops | White | 8 | 2 | W | $7.50 | $14.00 | Y |
| WE021 | Lazy Flip-Flops | Brown | 8 | 2 | M | $7.50 | $14.00 | Y |
| WE022 | Lazy Flip-Flops | Brown | 9 | 4 | M | $7.50 | $14.00 | N |
| WE023 | Lazy Flip-Flops | Brown | 10 | 2 | M | $7.50 | $14.00 | Y |
| WE024 | Lazy Flip-Flops | Brown | 11 | 2 | M | $7.50 | $14.00 | Y |
| WE025 | Seriously Tall Boots | Black | 6 | 0 | W | $42.50 | $80.00 | Y |
| WE026 | Seriously Tall Boots | Black | 6.5 | 0 | W | $42.50 | $80.00 | Y |
| WE027 | Seriously Tall Boots | Black | 7 | 1 | W | $42.50 | $80.00 | Y |
| WE028 | Seriously Tall Boots | Black | 7.5 | 0 | W | $42.50 | $80.00 | Y |
| WE029 | Seriously Tall Boots | Black | 8 | 2 | W | $42.50 | $80.00 | Y |
| WE030 | Seriously Tall Boots | Black | 8.5 | 1 | W | $42.50 | $80.00 | Y |
| WE031 | Glide Running Shoes | White | 8 | 6 | M | $48.00 | $75.00 | N |
| WE032 | Glide Running Shoes | White | 9 | 6 | M | $48.00 | $75.00 | N |
| WE033 | Glide Running Shoes | White | 10 | 6 | M | $48.00 | $75.00 | N |
| WE034 | Glide Running Shoes | Black | 8 | 2 | M | $48.00 | $75.00 | N |
| WE035 | Glide Running Shoes | Black | 9 | 3 | M | $48.00 | $75.00 | N |
| WE036 | Glide Running Shoes | Black | 10 | 1 | M | $48.00 | $75.00 | Y |
&K05-049&A
excel/WearEverShoes-1.xlsx
Sheet1
| Wear-Ever Shoes | ||||||||
| Outlet Product Inventory | ||||||||
| Product | Color | Sizes | Quantity | Mens/Womens | Cost | Retail Price | Total Cost | Reorder |
| Rugged Hiking Boots | Brown and Black | W 5-11 | 45 | Men | 46.5 | 90 | 2092.5 | N |
| Comfy Walking Shoes | Brown and Black | R 5-12 | 52 | Both | 34.25 | 65 | N | |
| Lazy Flip-Flops | Pink and White | R 5-12 | 13 | Both | 7.5 | 14 | Y | |
| Seriously Tall Boots | Black | W 5-11 | 0 | Women | 42.5 | 80 | Y | |
| Glide Running Shoes | Green and Black | R 5-12 | 10 | Both | 36.5 | 75 | Y | |
| Classy Pumps | Navy Blue | R 5-12 | 40 | Women | 15.45 | 30 | N | |
| Chunky Heel Boots | Brown | W 5-11 | 10 | Women | 32.45 | 65 | Y | |
| Sassy Slip-Ons | Silver | R 5-12 | 25 | Women | 23.5 | 45 | N |
