User Account

All Pages

Prepare an invoice

Assignment Help Financial Accounting
Reference no: EM135391

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: EM135391

Questions Cloud

Government encourage a decision to expand : Government encourage a decision to expand? How would it affect the reputation of the business?
Effective leadership - total quality management : Effective leadership may keep their staff motivated in improving the total quality management in an organization
Business owner making final decision of international aspect : As a business owner making a final decision regarding the international aspects of a business decision, you may decide to set up a table with the risks and weigh their relative importance against the rate of return you foresee
Factors that affect pay differentials : What are the factors that affect pay differentials? How does each factor increase or decrease relative wages?
Prepare an invoice : How do you take a known dollar value such as $240.00, back out the sales taxes from the known values using the States sales tax
Describe a skimming price and a penetration price : Describe a skimming price and a penetration price, and advise them whether they should charge a skimming price or a penetration price, with supportive reasoning for and against each pricing alternative.
What occurs when a new technology makes another one obsolete : Explain what occurs when a new technology makes another one obsolete in terms of economic profit.
What occurs when a new technology makes another one obsolete : Explain what occurs when a new technology makes another one obsolete in terms of economic profit.
How can 2 countries both be better off as a result of trade : 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 net increase in jobs?

Reviews

Write a Review

Financial Accounting Questions & Answers

  What is the direct labor rate alteration

Albertville has a direct labor standard of two hours per unit of output. All employee has a standard wage rate of $22.50 per hour. Throughout July Albertville paid $189,500 to employees for 8,890 hours worked. 4,700 units were produced throughout ..

  Purpose a post-closing trial balance

Purpose a post-closing trial balance and Journalize and post the adjusting entries.

  Prepare needed journal entries for 2014 and 2015

Prepare needed journal entries for 2014 and 2015. Be sure to indicate whether each entry should be made to an unrestricted or temporarily restricted fund. You need not, thus, record the indirect costs themselves.

  What is the journal entry required to establish the lifo

What is the journal entry required to establish the LIFO reserve for Orange Corporation?

  Determine and journalize the foreign exchange adjustments

Determine and journalize the foreign exchange adjustments for 2005, 2006 and 2007 for the Canadian subsidiary.

  Financial management and accounting processes

Financial management and accounting processes

  Evaluate the amount to be reported as the cost of the land

Evaluate the amount to be reported as the cost of the land

  Differences between the book value and the fair value

Differences between the book value and the fair value of the identifiable assets of Salem Company

  Journal entries required to create and close the warranty

Make the Journal entries required to create and close the warranty period

  How should profit on extinguishment of debt be evaluated

How should profit or loss on early extinguishment of debt be evaluated? Does the early extinguishment of the 7 percent bonds result in a gain or loss? Describe.

  Determine the amount of research and development expense

Determine the amount of research and development expense Janson could report in its 2013 income statement related to this project.

  Evaluate the abc cost of a resident day for each category

Evaluate the ABC cost of a resident day for each category of residents using assistance hours as the cost driver.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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