Hi,
We are Ebay sellers and want a Visual Basic Program so we can quickly work out some calculations approx 18 fields and around 15 simple calculations. We also need to change certain fields from a simple dropdown menu eg select different percentages. I have explained what we need below and have also given 3 working examples.
Requirements:
Profit at different price points
Calculate GST a 10% calculation (tax our nett postion) would need with and without GST
Tax liability at different tax rates
Ability to enter the product name with the calculations preferably across the page or in a small table
We need to be able to save the details (would like as many products per page as possible) preferably taking up 2-3 lines
Ability to print the results
Would be dynamic ??" ie change one figure and the whole calculation updates to reflect the change
Application in .exe format
Would also need total VB program so program could be modified later
Willing to pay extra if we have forgotten anything and extra work need to be done
Please see attached file for all details
## Deliverables
Information which would have to be entered: Fields (e) = entered amount (c) = program calculates
FIELDS: - See Example P6
A. Name of product ??" blank field ??" for us to type in
**Sale / Receipts**
**1.** (e) Sale price of goods blank field ??" not including post (we would enter this ??" would obviously vary for each product)
**2. ** (e) Post Cost ??" blank field ??" We would enter Amt
**3.** (c) Total Sale Price = 1 + 2
**4.** (c) GST ??" 10% of 3 above
Would need 0% on dropdown list
**5.** (c) Actual Sale - GST program would calculate 3 minus 4
**Costs / Payments**
**6**. (e) Cost of goods ??" excluding GST would vary for each product ??" blank field ??" Entered Amt
**7**. (c) GST 10% of cost of goods 6.
Also require this to be 0% on a drop down blank means 0% default is 10%
**8**. (c) Total Cost of Goods **6 + 7**
**9.** (e) Post Cost Actual ??" Entered Amount or blank = 0
**10**. (e) Courier Cost ex GST Entered Amount ??" or blank = 0
**10a**. (c) Courier GST 10% of **10** or blank = 0
**10b** (c) Courier Total Cost **10 + 10a** or blank = 0 Entered Amount
**11. ** (c) Ebay Final Value Fee ??" set amount 7.9% of sale price less post charge ??" Calculated Amt
**12**. (c) Paypal Fee ??" set amount 2.0%+.30c of total Ebay sale including post ??" Calculated Amt
**13**. (c) Cost ex GST **6+9+10+11+12**
**14**. (c) GST Nett ??" **4 - 7** **??" 10a**
**15**. (c) Tax Payable ??" 28% of Profit (Profit = Total Sale ??" GST (5) less (Cost of goods+post charge Ebay+courier+Final Value Fee+Paypal Fee) ??" Calculated Amt
We would require different tax percentages on a drop down eg 28%, 15%, 30% and 0%
**16.** (c) Final Profit Figure ??" this would obviously be calculated
**17**. (c) Tax and GST Payable ??" calculated **12+13**
**18** (c) Postage P/L **2 - 9 - 10** could be neg or positive
** **
If any $0 amounts eg maybe no courier charge ??" I don’t want to have to enter 0 a blank field means 0 please
All amounts correct to 2 decimal places eg $.574c would be .57c.
Attractive layout ie colour borders preferably blues or greens no background cell colour
All Fonts Arial Normal 9 or 10pt
Headings Bold
PLEASE SEE ATTACHED FILE FOR FULL DETAILS , EXAMPLES AND LAYOUT EXAMPLE FOR PROGRAM p6