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

The product life cycle defines the stages that new products move through as they enter, are established in, and ultimately leave

notsponge [240]

Answer:

Market Attribute – Introduction stage - Low sales

Market Attribute – Growth stage - Opportunities increase

Market Attribute – Maturity stage - Intense competition

Market Attribute – Decline stage - Niche segment

Consumer Types – Introduction stage - Sylvie

Consumer Types – Maturity stage - Winnie

Consumer Types – Decline stage - Francine

6 0

3 years ago

Explain how you would create a job requirements matrix for a job.

Colt1911 [192]

Answer:

I would create a job by, getting the requirements for the job, I would try getting other people to help me and to work with me. That's how I would create a job and the most important part, create a name for the job.

5 0

3 years ago

How do property rights benefit entrepreneurs?

Oxana [17]

Enabling them to purchase capital and use it as they fit. having the rights means they can use the property for martgage and raise loans,or show as an asset and acquire capital on its worth. they can sublet the property and get resources from the rent as well

7 0

3 years ago

Read 2 more answers

Mauro Products distributes a single product, a woven basket whose selling price is $13 per unit and whose variable expense is $1

Ira Lisetskai [31]

Answer:

Break-even point in unit sales = 2,300 units

Break-even point in dollar sales = $29,908.97 (Approx)

New break-even point in unit sales = 2,600 units

New break-even point in dollar sales = $33,810.14 (Approx)

Explanation:

Given:

Selling price = $13 per unit

Variable expense = $11 per unit

Fixed expense = $4,600

Computation:

Break-even point in unit sales = Fixed expense / [Selling price - Variable expense]

Break-even point in unit sales = 4,600 [13-11]

Break-even point in unit sales = 2,300 units

Contribution margin = [(13-11)] / 13 = 15.38%

Break-even point in dollar sales = Fixed expense / Contribution margin

Break-even point in dollar sales = $4,600 / 15.38%

Break-even point in dollar sales = $29,908.97 (Approx)

New break-even point in unit sales = [4,600+600][13-11]

New break-even point in unit sales = 2,600 units

New break-even point in dollar sales = Fixed expense / Contribution margin

New break-even point in dollar sales = $5,200 / 15.38%

New break-even point in dollar sales = $33,810.14 (Approx)

4 0

3 years ago

Osborn Manufacturing uses a predetermined overhead rate of 18.20 per direct labor-hour. This predetermined rate was based on 12,

Leto [7]

The correct statement is that the under applied overheads for Osborn Manufacturing Company is calculates as a negative balance of $5700 at the overhead rate of $18.20.

Explanation:

The calculation of the overhead costs is done by using the formula for under applied overheads and calculating the required values from such given information.

Calculation of manufacturing overheads

The formula for the calculation of manufacturing overheads whether under applied or over applied can be determined is as below,

Under - applied Overheads = Applied Overhead - Actual overhead

However, to calculate further the actual overheads can be calculated as below by applying the given values to the formula,

Applied Overheads = Actual Level of Direct labour hours x overhead rate hours

Applied Overheads = 11500 x 18.20

Applied Overheads = $209300

Now applying the values to the formula, we get,

Under - applied Overheads=209300 - 215000

Under - applied Overheads = -$5700

Hence, the correct statement is that under applied overheads for Osborn Manufacturing Company is calculated as a negative balance of $5700 at the overhead rate of $18.20.

Learn more about manufacturing overheads here:

brainly.com/question/13214087

#SPJ4

5 0

1 year ago