Basic Quantitive Method

profileLobitoriginal
MAT-20013All-StoreProfitandLossStatement.xlsx

P&L

All-Store Profit & Loss Statement
Profit & Loss January February March April May June
Total revenue $ 650,037.00 $ 622,477.00 $ 594,917.00 $ 567,357.00 $ 539,797.00 $ 512,237.00
Less cost of goods sold $ 425,774.24 $ 407,722.44 $ 389,670.64 $ 371,618.84 $ 353,567.04 $ 335,515.24
Gross Profit $ 224,262.76 $ 214,754.57 $ 205,246.37 $ 195,738.16 $ 186,229.96 $ 176,721.77
Expenses
Accounting and legal fees $ 2,597.00 $ 2,273.00 $ 2,396.00 $ 2,788.00 $ 2,328.00 $ 2,116.00
Advertising $ 10,424.43 $ 7,828.92 $ 5,432.84 $ 8,426.54 $ 1,735.09 $ 6,167.04
Depreciation $ 3,800.00 $ 3,800.00 $ 3,800.00 $ 3,800.00 $ 3,800.00 $ 3,800.00
Electricity $ 2,700.00 $ 2,700.00 $ 2,700.00 $ 2,700.00 $ 2,700.00 $ 2,700.00
Insurance $ 9,200.00 $ 9,200.00 $ 9,200.00 $ 9,200.00 $ 9,200.00 $ 9,200.00
Interest and bank charges $ 504.46 $ 409.24 $ 344.53 $ 569.77 $ 331.61 $ 586.74
Shipping & postage $ 1,601.88 $ 2,816.37 $ 2,116.86 $ 2,338.60 $ 2,092.21 $ 2,324.49
Printing and stationery $ 488.35 $ 715.25 $ 542.00 $ 371.18 $ 484.02 $ 456.18
Professional memberships $ 580.00 $ 580.00 $ 580.00 $ 580.00 $ 580.00 $ 580.00
Rent for premises $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00
Repairs and maintenance $ 774.14 $ 209.72 $ 455.88 $ 935.95 $ 80.64 $ 812.08
Training $ 121.85 $ 191.27 $ 170.53 $ 176.69 $ 177.25 $ 146.02
Wages and salaries $ 47,000.00 $ 45,698.00 $ 48,111.00 $ 47,327.00 $ 44,779.00 $ 45,819.00
Workers compensation $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00
Less Total Expenses $ 88,292.11 $ 84,921.76 $ 84,349.64 $ 87,713.74 $ 76,787.83 $ 83,207.55
Equals Net Profit (income) $ 135,970.66 $ 129,832.81 $ 120,896.73 $ 108,024.43 $ 109,442.14 $ 93,514.22

Net Profit (income) January February March April May June 135970.65791965276 129832.80997003146 120896.72941983343 108024.42830333773 109442.13688028869 93514.219290182315