How do you take a known dollar value totalcost such as

Assignment Help Financial Accounting
Reference no: EM13351369

How do you take a known dollar value (totalcost) such as $240.00, back out the sales taxes from the known values using the States (VA and WV) sales tax, showing the difference so that You can print an invoice, with the fields Customer name, address, city, state Subtotal, sales tax and totalcost $240.00. All fields are currently within one table which you have built currently using table in Mysql and OpenOffice Base.

These are all the fields you have in your database which are currently created in an Open Office Base and MySql Table. You would prefer to use MySQL.  Virginia (VA) Sales tax is 5.3 percent and West Virginia's is 6.5 percent.

CustomerID

OldAcctID

FirstName

LastName

City

State

ZipCode

TotalCost (known) 240.00

TaxRate (VA) and (WV)

You need to create an invoice such as:

Name:  First and Last Name                       Square Foot:  2000       Price:  Value prior to Sales taxamount

Address:   xxxx Any Street Sales Tax:          0.xx

             City,  State  Zip CodeTotal Cost:   $240.00 (example)

Reference no: EM13351369

Questions Cloud

Assume that your business is visible and an important : assume that your business is visible and an important member of the community. would the government encourage a
Do you think that effective leadership may keep their staff : do you think that effective leadership may keep their staff motivated in improving the tqm total quality management in
Marginal rate substitution kim enjoys eating muffins and : marginal rate substitution kim enjoys eating muffins and cones.the following graph display one of kims indifference
George is seen to place an even-money 100000 bet on the : george is seen to place an even-money 100000 bet on the bulls to win the nba championship.if george has a logarithmic
How do you take a known dollar value totalcost such as : how do you take a known dollar value totalcost such as 240.00 back out the sales taxes from the known values using the
Jessica alba a famous actress starts the baby and family : jessica alba a famous actress starts the baby and family products business the honest company with christopher gavigan.
Explain what occurs when a new technology makes another one : explain what occurs when a new technology makes another one obsolete in terms of economic profit. consider firm a to be
Explain what occurs when a new technology makes another one : explain what occurs when a new technology makes another one obsolete in terms of economic profit. consider firm a to be
How can two countries both be better off as a result of : how can two countries both be better off as a result of trade? how can tariffs protect u.s. jobs? do tariffs lead to a

Reviews

Write a Review

Financial Accounting Questions & Answers

  Question a company has operational expenses of the

question a company has operational expenses of the subsequentjan - 250000feb - 350000mar - 275000apr - 250000may -

  How should this lease be classified by western soya

How should this lease be classified (a) by Western Soya Co. (the lessee) and (b) by Rhone-Metro Industries (the lessor)? Why? Prepare the appropriate entries for both Western Soya Co. and Rhone-Metro on December 31, 2011.

  How much is balance of retained earnings in current year

Prepare a summary of information with appropriate cross referencing between sources and paraphrase and appropriately reference source material (Harvard style referencing).

  Illustrate what is capital structure of smith

Illustrate what is the capital structure of Smith immediately prior to the acquisition. Determine the amount and account to be recorded for Nichols' investment in Smith.

  Purpose the company budgeted balance sheet

Purpose the company budgeted balance sheet -  The management of Mecca Copy, a photocopying center located on University Avenue, has compiled the following data to use in preparing

  Write a report to the client - geolab exploration limited

A two-column common-size statement of financial performance and statement of financial position for Geolab. The first column of each statement should present Geolab's common-size statement, and the second column should show the industry averages.

  Purpose entries for bosio for the office improvements

Purpose entries for Bosio to record (a) its payments to Harper for the right to sublease the building space (b) its payment of the 2009 annual rent to the building owner, and (c) its payments for the office improvements.

  Find out how any losses resulting from the activity

Find out how any losses resulting from the activity are treated under the passive activity loss rules

  What does this statement of cash flow tell you

What does this statement of cash flow tell you about the sources and uses of the company and is there anything ABC Company can do to improve the cash flow?

  Define discounted cash flow and payback period

Define and describe Net Present Value (NPV) as it pertains to the new cafe and define and describe the internal Rate of Control and define discounted cash flow and payback period

  Calculate the total amount of dividends

Calculate the total amount of dividends declared by March for 20X7 and calculate March's profit for 20X8.

  Provide repair and maintenance coverage

Identify several of the variable, mixed, and fixed costs that the Polaris services department is likely to incur in carrying out its services and how do you expect the costs identified in part 1 to change, if at all?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd