{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":52,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":114,"n_cols":7,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Apr - Jun 15"]
[null,"Ordinary Income/Expense"]
[null,null,null,"Income"]
[null,null,null,null,"Sales Medals 1",null,686.59]
[null,null,null,null,"Sales Medals",null,125.95]
[null,null,null,null,"Sales Medals",null,64.12]
[null,null,null,null,"Sales Medals",null,153.44999999999999]
[null,null,null,null,"Sales Medals",null,26.32]
[null,null,null,null,"Sales Medals",null,32.9]
[null,null,null,null,"Sales Medals",null,74.75]
[null,null,null,null,"Sales Medals",null,173.28]
[null,null,null,null,"Sales Medals",null,39]
[null,null,null,null,"Sales Medals",null,153.06]
[null,null,null,null,"Sales Medals",null,77.7]
[null,null,null,null,"Sales Medals",null,791.41]
[null,null,null,null,"Sales A.S.I. Promotional",null,179.4]
[null,null,null,null,"Sales A.S.I. Promotional",null,438]
[null,null,null,null,"Sales Acrylic",null,20]
[null,null,null,null,"Sales Acrylic",null,360]
[null,null,null,null,"Sales Acrylic",null,38]
[null,null,null,null,"Sales",null,1711.95]
[null,null,null,null,"Sales Discount",null,-482.18]
[null,null,null,null,"Sales Items"]
[null,null,null,null,null,"Resins",15]
[null,null,null,null,null,"Sales Trophies",20646.419999999998]
[null,null,null,null,null,"Sales Pins & Patches",78]
[null,null,null,null,null,"Sales Stock Medals",8599.06]
[null,null,null,null,null,"Sales Ribbons",2.75]
[null,null,null,null,null,"Sales Plaques",5915.75]
[null,null,null,null,null,"Sales Corporate",9022.66]
[null,null,null,null,null,"A.S.I. Promotional",150]
[null,null,null,null,null,"Acrylics",3057.36]
[null,null,null,null,null,"Corporate",1619.4]
[null,null,null,null,null,"Custom Medals",3978.07]
[null,null,null,null,null,"Glass Awards",653.35]
[null,null,null,null,null,"Miscellaneous",26686.400000000001]
[null,null,null,null,null,"Pins & Patches",21.25]
[null,null,null,null,null,"Plaques",18005.04]
[null,null,null,null,null,"Ribbons",2121.0700000000002]
[null,null,null,null,null,"Crystal Blast Engraving",153]
[null,null,null,null,null,"Signs",1319]
[null,null,null,null,null,"Stock Medals",7303.66]
[null,null,null,null,null,"Trophies",34151.589999999997]
[null,null,null,null,null,"Sales Items - Other",3101.7]
[null,null,null,null,"Total Sales Items",null,{"$f":"ROUND(SUM(G23:G44),5)","v":146600.53}]
[null,null,null,"Total Income",null,null,{"$f":"ROUND(SUM(G3:G22)+G45,5)","v":151264.23000000001}]
[null,null,null,"Cost of Goods Sold"]
[null,null,null,null,"Cost of Goods Sold"]
[null,null,null,null,null,"Acrylic",2080.21]
[null,null,null,null,null,"Corporate",4402.38]
[null,null,null,null,null,"Cups",861.95]
[null,null,null,null,null,"Custom Medals",1049.3599999999999]
[null,null,null,null,null,"Medals",8858.27]
[null,null,null,null,null,"Miscellaneous",5690.68]
[null,null,null,null,null,"Plaques",6027.37]
[null,null,null,null,null,"Resins",1433.6]
[null,null,null,null,null,"Ribbons",478.31]
[null,null,null,null,null,"Trophies",17412.009999999998]
[null,null,null,null,null,"Cost of Goods Sold - Other",32.46]
[null,null,null,null,"Total Cost of Goods Sold",null,{"$f":"ROUND(SUM(G48:G59),5)","v":48326.6}]
[null,null,null,null,"Shipping, Freight and Delivery",null,4909.9799999999996]
[null,null,null,null,"Purchase Discounts",null,-1067.1300000000001]
[null,null,null,"Total COGS",null,null,{"$f":"ROUND(G47+SUM(G60:G62),5)","v":52169.45}]
[null,null,"Gross Profit",null,null,null,{"$f":"ROUND(G46-G63,5)","v":99094.78}]
[null,null,null,"Expense"]
[null,null,null,null,"Bad Service Expense",null,42.16]
[null,null,null,null,"Small Tools",null,22.71]
[null,null,null,null,"Bad Debt Expense",null,3.95]
[null,null,null,null,"Bank Service Charges",null,10]
[null,null,null,null,"Charitable Contributions",null,2293.0100000000002]
[null,null,null,null,"Dues and Subscriptions",null,367.02]
[null,null,null,null,"Franchise Fees"]
[null,null,null,null,null,"Royalty Payment",7995.28]
[null,null,null,null,"Total Franchise Fees",null,{"$f":"ROUND(SUM(G72:G73),5)","v":7995.28}]
[null,null,null,null,"Insurance",null,442]
[null,null,null,null,"Marketing & Advertising",null,2541.8000000000002]
[null,null,null,null,"Merchant Fees",null,2268.9899999999998]
[null,null,null,null,"Miscellaneous",null,562.80999999999995]
[null,null,null,null,"Payroll Expenses"]
[null,null,null,null,null,"Wages",34315.57]
[null,null,null,null,null,"Taxes",2836.58]
[null,null,null,null,"Total Payroll Expenses",null,{"$f":"ROUND(SUM(G79:G81),5)","v":37152.15}]
[null,null,null,null,"Rent",null,8821.32]
[null,null,null,null,"Repairs"]
[null,null,null,null,null,"Computer Repairs",5.41]
[null,null,null,null,null,"Equipment Repairs",4553.05]
[null,null,null,null,"Total Repairs",null,{"$f":"ROUND(SUM(G84:G86),5)","v":4558.46}]
[null,null,null,null,"Supplies and Shipping"]
[null,null,null,null,null,"Refreshments / Candy",51.88]
[null,null,null,null,null,"Office Supplies",712.7]
[null,null,null,null,null,"Postage and Delivery",614.08000000000004]
[null,null,null,null,null,"Printing and Reproduction",147.5]
[null,null,null,null,null,"Warehouse Supplies",4.3]
[null,null,null,null,null,"Supplies and Shipping - Other",614.29]
[null,null,null,null,"Total Supplies and Shipping",null,{"$f":"ROUND(SUM(G88:G94),5)","v":2144.75}]
[null,null,null,null,"Taxes",null,1.95]
[null,null,null,null,"Travel & Ent"]
[null,null,null,null,null,"Meals",112.02]
[null,null,null,null,null,"Travel",74.510000000000005]
[null,null,null,null,"Total Travel & Ent",null,{"$f":"ROUND(SUM(G97:G99),5)","v":186.53}]
[null,null,null,null,"Utilities"]
[null,null,null,null,null,"Window Cleaning",51.96]
[null,null,null,null,null,"Phone",553.03]
[null,null,null,null,null,"Electric",1311.94]
[null,null,null,null,null,"Internet",222.69]
[null,null,null,null,"Total Utilities",null,{"$f":"ROUND(SUM(G101:G105),5)","v":2139.62}]
[null,null,null,"Total Expense",null,null,{"$f":"ROUND(SUM(G65:G71)+SUM(G74:G78)+SUM(G82:G83)+G87+SUM(G95:G96)+G100+G106,5)","v":71554.509999999995}]
[null,"Net Ordinary Income",null,null,null,null,{"$f":"ROUND(G2+G64-G107,5)","v":27540.27}]
[null,"Other Income/Expense"]
[null,null,"Other Income"]
[null,null,null,"Other Income",null,null,6.48]
[null,null,"Total Other Income",null,null,null,{"$f":"ROUND(SUM(G110:G111),5)","v":6.48}]
[null,"Net Other Income",null,null,null,null,{"$f":"ROUND(G109+G112,5)","v":6.48}]
["Net Income",null,null,null,null,null,{"$f":"ROUND(G108+G113,5)","v":27546.75}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}