2005-09-16 VBZ Sales Profit & Loss

From HypertWiki
Jump to navigation Jump to search

This is a monthly sales profit/loss summary for vbz.net, generated in MS Access

  • Figures are approximate; accuracy improves closer to the present time.
  • Figures include only sales-related income/expenses, i.e. monies received or refunded to customers, cost of postage and cost of shipping materials. Regular overhead costs (e.g. utilities, services, rent) or labor costs were not included.
  • Algorithms used to calculate figures are not guaranteed error-free, though they do seem to correlate with reality most of the time.

Cash In includes checks, cash, money transfers (e.g. PayPal), and credit card deposits. Any processing fees charged by financial institutions have not been subtracted out, so the actual deposits are somewhat lower.
Cust S/H is the estimated actual cost (postage plus shipping materials) of shipping orders to customers.
Restocks is the total cost of merchandise ordered from suppliers, including shipping charges
Rstk S/H is the shipping portion of the cost of merchandise ordered from suppliers
Net is the net Sales Profit, and is calculated thusly: [Cash In] – [Cust S/H] – [Restocks]. It includes only sales-related income/expenses, i.e. monies received or refunded to customers, cost of postage and cost of shipping materials. Regular overhead costs (e.g. utilities, services, rent) and labor costs were not included.


Month Cash In Cust S/H Restocks Rstk S/H Net
2001-03 $20.27 $95.60 $1,430.52 $53.46 ($1,505.85)
2001-07 $28.27 $66.38 $1,421.47 $67.11 ($1,459.58)
2001-08 $2,579.56 $198.41 $715.85 $40.44 $1,665.30
2001-09 $933.26 $121.95 $657.35 $24.97 $153.96
2001-10 $767.92 $130.57 $1,004.10 $40.72 ($366.75)
2001-11 $2,142.08 $240.50 $1,654.35 $73.44 $247.23
2001-12 $6,119.15 $710.30 $2,288.48 $202.41 $3,120.37
2002-01 $2,413.09 $77.76 $2,103.75 $91.66 $231.58
2002-02 $486.57 $82.09 $500.93 $70.53 ($96.45)
2002-03 $1,493.81 $148.51 $1,107.70 $46.46 $237.60
2002-04 $1,141.73 $128.49 $898.83 $25.62 $114.41
2002-05 $1,112.85 $112.23 $258.00 $6.25 $742.62
2002-06 $2,086.86 $238.37 $2,071.29 $19.43 ($222.80)
2002-07 $1,713.72 $116.13 $1,232.93 $26.74 $364.66
2002-08 $775.03 $141.99 $692.58 $21.08 ($59.54)
2002-09 $506.91 $72.55 $417.52 $16.84
2002-10 $1,343.61 $165.26 $644.04 $14.71 $534.31
2002-11 $1,317.35 $213.19 $1,824.00 $70.49 ($719.84)
2002-12 $2,919.70 $480.27 $2,067.95 $358.85 $371.48
2003-01 $1,645.59 $119.19 $674.05 $63.38 $852.35
2003-02 $1,291.93 $180.78 $932.74 $71.17 $178.41
2003-03 $1,576.57 $229.09 $843.04 $60.42 $504.44
2003-04 $872.23 $115.41 $435.05 $22.05 $321.77
2003-05 $2,031.94 $223.92 $1,815.83 $58.04 ($7.81)
2003-06 $650.29 $84.00 $529.35 $28.66 $36.94
2003-07 $1,547.81 $190.14 $990.16 $33.91 $367.51
2003-08 $817.74 $88.16 $664.23 $27.43 $65.35
2003-09 $1,513.50 $191.80 $908.71 $40.71 $412.99
2003-10 $1,383.28 $123.69 $904.82 $37.48 $354.77
2003-11 $1,470.51 $158.28 $4,027.12 $105.72 ($2,714.89)
2003-12 $2,957.65 $431.66 $1,891.52 $182.99 $634.47
2004-01 $1,168.02 $128.35 $433.08 $46.33 $606.59
2004-02 $974.63 $133.42 $593.27 $30.90 $247.94
2004-03 $942.91 $145.99 $855.98 $52.98 ($59.06)
2004-04 $1,502.73 $192.19 $560.23 $44.13 $750.31
2004-05 $1,216.39 $125.57 $821.88 $35.23 $268.94
2004-06 $1,362.91 $169.68 $605.94 $57.64 $587.29
2004-07 $730.31 $76.12 $284.97 $14.47 $369.22
2004-08 $1,631.04 $189.99 $688.50 $64.60 $752.55
2004-09 $944.61 $80.04 $845.23 $43.27 $19.34
2004-10 $1,304.94 $132.64 $953.05 $50.95 $219.25
2004-11 $1,003.69 $113.32 $539.63 $39.32 $350.74
2004-12 $2,346.47 $286.29 $1,656.28 $153.91 $403.90
2005-01 $340.58 $40.85 $109.00 $8.25 $190.73
2005-02 $1,065.77 $87.03 $919.91 $61.01 $58.83
2005-03 $1,130.17 $119.09 $558.46 $53.39 $452.62
2005-04 $864.51 $125.83 $432.98 $28.42 $305.70
2005-05 $689.32 $82.35 $646.44 $29.94 ($39.47)
2005-06 $744.58 $103.67 $313.38 $21.92 $327.53
2005-07 $331.47 $27.07 $245.32 $9.82 $59.08
2005-08 $1,890.59 $195.32 $1,006.29 $85.78 $688.98
2005-09 $211.70 $34.32 $153.93 $9.93 $23.45