I'm afraid you're going to have to do this yourself. It's pretty straight-forward.
1. Obtain the total sales for the month and save in TotalSalesBeforeTax.
2. Multiply TotalSalesBeforeTax by 0.04 and save the resultant in "StateTax".
3. Multiply TotalSalesBeforeTax by 0.02 and save the resultant in "CountyTax".
4. Add StateTax and CountyTax and save the resultant in TotalTax.
That is, unless the TotalSales is really the TotalReceipts, i.e. the sum of the value total receipts + sales tax + county tax. It this is the case,
TotalSalesBeforeTax = TotalReceipts / 1.06
Steps 2, 3, and 4 remain unchanged.
|