# My total sale is \$101.65. I collected 6.25% sales tax. What is the formula to find out the portion of the total is the sales tax total?

Posted by on

• Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

• Master

Partly this is a matter of interpretation. If \$101.65 is seen as 100% then sales tax is
\$101.65 x 6.25 / 100 = \$6.35

However there is a flaw in this. The remainder (the sale price) is
\$101.65 - \$6.35 = \$95.30

So what was the sales tax on this remainder?
6.35 / 95.30 x 100 = 6.67%........too much

So we should regard the \$ total as 106.25% not 100%. Then the amount which was sales tax is really
\$101.65 x 6.25 / 106.25 = \$5.98

Posted on Apr 17, 2014

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
Goodluck!

Posted on Jan 02, 2017

i solve!! the exact total of bobs ticket is 948.48

Posted on Mar 24, 2009

Assuming the Belvedere Arms sells only food and drink:
a) Total sales for the week is the sum of the drink sales and food sales, £11,800 + £5,600 = £17,400
b) Sales budget is £16,200, so performance is (17,400-16,200)/16,200 = 1200/16200 = .074 which is up by 7.4%
c) Profit on food is £3,640 on total food sales of £5,600. 3640/5600 = .65 or 65%
d) Profit on drink is £8,496 on total drink sales of £11,800. 8496/11,800 = .72 or 72%
e) Total profit is £12,036 on total sales of £17,400. 12,136/17,400 = .697 or 70%

Posted on Mar 10, 2011

×

my-video-file.mp4

×

## Related Questions:

### I need a formula to calculate sales tax. the tax caps at \$300 dollars.

=IF((A1*7.5%) > 300, 300, A1*7.5%)
• IF Sales Amount * Tax Rate is greate than \$300 then make it \$300 no matter what the value is.
• IF Sales Amount * Tax Rate is less than \$300 then make it the value of Sales Amount * Tax Rate.

Sep 29, 2015 | Microsoft Office Excel 2003 for PC

### Do I File A Sales Tax Return For Any Period By Which I Had No Sales?

If you are registered for sales tax purposes, you must file sales and use tax returns quarterly, partly quarterly or annually with the department even if your business does not make any sales or purchases during the current reporting period.You must file your sales and use tax return before the due date. There are basically 15 Reasons for a Tax Refund which every businessmen should know.

Jul 08, 2015 | Retail Supplies

### How to calculate the percentage using the excel

Hide All
Percentages are calculated by using the following equation:
amount/total = percentage
Where percentage is in decimal format.
What do you want to do?

Calculate the amount if you know the total and percentage For example, if you purchase a computer for \$800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
1 2 A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay (\$71.20) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?
Example The example may be easier to understand if you copy it to a blank worksheet.
1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

Simple way Amount/Total*100

Apr 30, 2011 | Computers & Internet

Once the check is ready for printing you add the the collection credit as an additional line in the expenses tab at the bottom of the check.

Mar 05, 2010 | Intuit QuickBooks: Pro 2005 for PC

### I need to change the tax rate on a royal alpha 600sc

To program a sales tax rate of 6%
1 Find your sales tax rate. You may need to contact your local government
office.
2 Put the PRG key in the Mode key slot and turn it to the PRG position.
3 In the round Number keys area, press 1 and then press the Tax 1 key.
4 Press 6000 and press the Amount Tend Total key. Your sales tax is
programmed.

Apr 01, 2009 | Royal DM3070

### How to do profit and loss a/c in ms excel

Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Description
Amount
Formula
Sales Product A
1,000.00

Sales Product B
1,000.00

Total Sales
2,000.00
SUM(C1:C2)
Cost of Sales Product A
500.00

Cost of Sales Product B
200.00

Total Cost of Sales
700.00
SUM(C5:C6)
Gross Profit
1,300.00
SUM(C4-C7)

Auto
25.00

Utilities
50.00

Payroll
300.00

Office Supplies
20.00

Total Expenses
395.00

Net Profit
905.00
SUM(C8-C14)

I hope this helps

Mark

Jan 05, 2009 | Microsoft Computers & Internet

hi lilwallace;
The federal excise tax of 8% on the round trip ticket is calculated by multiplying 8% times the price of the ticket. Remember 8% is written as .08 when we multiply.
\$832 times .08 = \$66.56 is the excise tax

\$832 times .06 = \$49.92 is the sales tax

Now we just add the ticket price plus the excise tax and the sales tax and we get \$832 + \$66.56 + \$49.92 = \$948.44

Hope this helps Loringh PS Please leave a rating for me.. Thanks

Nov 29, 2008 | M2K Garfield: It's All About Math Math...

### Casio Register 265P - Doubling Tax in Sales Total

Hi.
That could be tricky. we will need to go through the tax setup in your machine.

My first questions are:

1. Does it happen on all department (item buttons)?
2. Does it happen no matter what payment method you use (cash, check,credit)?
3. When you push Subtotal, does it show the wrong amount then, or only when you press a payment type to open the drawer?

Mark

Nov 12, 2008 | Casio Parts Cash Register PC Desktop

## Open Questions:

#### Related Topics:

121 people viewed this question

Level 3 Expert

Level 3 Expert