All categories

3 years ago

Assuming that all the table and column names are spelled correctly, what's wrong with the INSERT statement that follows?

Business

1 answer:

Nezavi [6.7K]3 years ago

3 0

Answer:

(VendorID = 97

InvoiceNumber = 456789

InvoiceTotal = 8344.50

PaymentTotal = 0

CreditTotal = 0

TermsID = 1

InvoiceDate = 2006-08-01

InvoiceDueDate = ?

You cannot have PaymentTotal = 0. The sales value was $8,344.50, and since the sales was paid with cash (no invoice due date), the payment should record the same amount as the invoice.

InvoiceTotal = PaymentTotal + CreditTotal, since you were paid with cash or you gave credit to the client.

You might be interested in

Before you start to develop your résumé, what should you analyze?

Reil [10]

You need to analyze your personal achievements, or B. Without doing this, there is nothing to put on your resume.

4 0

3 years ago

Read 2 more answers

Tangshan Industries has issued a bond which has a $1,000 par value and a 15 percent annual coupon interest rate. The bond will

mina [271]

Answer:

B. 10.79 percent

Explanation:

yield to maturity = [150 + (1250 - 1000/10)]/[(1250 + 1000/2)]

= 10.79%

Therefore, The yield to maturity on the Tangshan Industries bond is 10.79%

6 0

3 years ago

Ma Barker Company has a job-order costing system and uses a predetermined overhead rate based on direct labor-hours to apply man

Sophie [7]

Answer:

Job 334 total cost: $ 8,400

Unit cost: 8,400 / 200 = $ 42

Explanation:

Total cost: Material + Labor + Overhead

Material: 5,000

Labor: 2,400

Overhead:

$\frac{Cost\: Of \:Manufacturing \:Overhead}{Cost \:Driver}= Overhead \:Rate$

We distribute the expected cost over the expected base:

expected cost: 100,000

cost driver: 40,000 labor hours

cost per hour: 100,000 / 40,000 = 2.5 predetermined overhead

Now we multiply this rate by the hours of the job to know Applied Overhead:

job labor hours x overhead rate:

Job #334 had 2,400 labor cost / $6 rate per hour = 400 hours

400 x 2.5 = 1,000

Total cost: 5,000 + 2,400 + 1,000 = 8,400

7 0

3 years ago

charger company's most recent balance sheet reports total assets of $28,413,000, total liabilities of $16,113,000 and total equi

OleMash [197]

The debt to equity ratio for the period, based on the total liabilities and total equity, would be 1.31

<h3>How to find the debt to equity ratio?</h3>

The debt to equity ratio shows the amount of debt that a company has as a ratio of the debts to the equity that the company has.

The debt to equity ratio can be found by the formula:

= Total liabilities / Total Equity

Total liabilities = $16, 113, 000

Total equity = $12, 300, 000

The debt to equity ratio is therefore:
= 16, 113, 000 / 12, 300, 000

= 1.31

Find out more on the debt to equity ratio at brainly.com/question/27993089

#SPJ1

5 0

1 year ago

Mustang Corporation had 100,000 shares of $2 par value common stock outstanding. On December 31, 2018, the company's board of di

Gnom [1K]

Answer:

December 31, 2018

Debit : Dividend $40,000

Credit : Shareholders for dividends $40,000

Explanation:

When dividends are declared, we Debit an Equity Element - Dividend and Credit the Liability - Shareholders for dividends.

Calculation of this dividend is made on the stockholders in existence at the on a stated date (January 15 in this case) and at par value ($2) as follows :

Dividend = 100,000 x $2.00 x $0.20 = $40,000

6 0

3 years ago