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

  Administrative and selling expenses

Administrative and Selling expenses

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Evaluate the appropriate discount factor using tables

Evaluate net annual cash inflow must the store generate for Anita to earn a 14 percent return over the 10-year period?

  Purpose a monthly cash budget and supporting schedules

Purpose a monthly cash budget and supporting schedules for March, April, and May.

  How much overhead may be allocated each time

How much overhead may be allocated each time a copy is made if cost allocations are computed to 4 significant digits?

  Evaluate taxable income and income tax payable for 2012

Evaluate taxable income and income tax payable for 2012. Evaluate the amounts reported as assets and liabilities of the Schimmel Company?

  Evaluate total fixed manufacturing overhead

Evaluate total fixed manufacturing overhead Evaluate variable manufacturing overhead per direct labor-hour Determine total direct labor-hours to be worked Net actual manufacturing overhead costs incurred

  Investigate any checks shows large or unusual payments

Investigate any checks shows large or unusual payments to related partie

  What is the outcome on the financial statements

What is the outcome on the financial statements when a company fails to accrue salaries expense at year-end?

  Evaluate the consolidated financial statements

Determine the value that would be shown in Padre and Sol's consolidated financial statements for each of the accounts listed. (Input all amounts as positive values.)

  Evaluate forward contract hedge

What is the total increase or decrease in cash flow from having entered into this forward contract hedge?

  What is your choice of controller and president reasoning

What is your choice of the controller and president's reasoning? Is the president's order ethical? Who benefits and who is harmed if the organizer follows the president's order?

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