All categories

2 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]2 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

Dozier Company produced and sold 1,000 units during its first month of operations. It reported the following costs and expenses

Airida [17]

Answer:

Explanation:

Hi, I have attached the full question as images below

Total Product Cost = ($70,000 + $35,500 + $43,700) ÷ 1,000 = $149.20

Total Period Cost = $30,600 + $29,300 = $59,900

Total Direct Manufacturing Cost = $70,000 + $35,500 + $15,400 = $120,900

Total Indirect Manufacturing Cost = $28,300

Total Manufacturing Cost = $70,000 + $35,500 + $43,700 = $149,200

Total Non Manufacturing Cost = $30,600 + $29,300 = $59,900

Total Conversion Cost = $35,500 + $43,700 = $79,200

Total Prime Cost = $70,000 + $35,500 = $105,500

Total Variable Manufacturing Cost = $70,000 + $35,500 + $15,400 = $120,000

Total Fixed Costs = $25,200 + $18,400 + $28,300 = $71,900

Variable Cost per unit = ($70,000 + $35,500 + $15,400 + $12,200 + $4,100) ÷ 1000 = $137.20

Incremental manufacturing cost = ($70,000 + $35,500 + $15,400) ÷ 1,000 = $120.90

5 0

2 years ago

Assume that one year ago, you bought 130 shares of a mutual fund for $27 per share, you received an income distribution of $0.12

Anika [276]

Answer:

Solution:

Dollar amount of total return = Capital gain distributions + Change in market value

First, we calculate the capital gain distributions

Income and capital gains distribution = ($0.12 + $0.22) x 130 shares

Income and capital gains distribution = $44.2

Now, we calculate the change in market value

Change in market value = Sales Price - Purchase price

Change in market value = 130 x $24 - 130 x $27

Change in market value = -$390

Therefore,

Dollar amount of total return = $44.2 + (-$390)

Dollar amount of total return = -$345.80

6 0

3 years ago

High Flying takes tourists on helicopter tours of Hawaii. Each tourist buys a $190 ticket; the variable costs average $57 per pe

Dennis_Churaev [7]

Answer:

a. 450 tours per month

b. $850 per month

c. CM Ratio = 0.7

1. Increase

2. Decrease

3. No Effect

Explanation:

The questions are:

a. Compute the average number of tours the company must conduct per month to break even

b. Compute the average sales revenue needed per month to produce a target average profit of $53,200

c. Calculate the contribution margin ratio. (Round your answer to 2 decimal places.)

d. Determine whether the actions that follow will increase, decrease, or not affect the company's break-even point.

1. A decrease in tour prices.

2. The termination of a salaried clerk (no replacement is planned).

3. A decrease in the number of tours sold.

Solution:

Selling Price = 190

VC = 57

Unit Contribution Margin = $133

Fixed Cost = 718,200 yearly, so monthly is:

718,200/12 = 59,850

Break even occurs when by selling tours they will cover monthly fixed cost of 59,850 [each tour will get 133], thus:

59,850/133 = 450 tours per month

718,200 FC yearly, means, monthly:

718,200/12 = $59,850

Profit needed 53,200, so we would need to cover:

53200+59850 = $113,050

Each tour gives Unit CM to be $133, so we would need revenue of:

Rev = 113,050/133 = $850

Contribution margin ratio is the quotient of difference in sales and var expenses to sales.

So,

CM Ratio = (Sales - Var Exp) / Sales

CM Ratio = (190 - 57) / 190 = 0.7

If the tour prices, decrease, there will be less revenue coming in so the break even point would go higher.

So, break even point will increase

If a salaried clerk is terminated, it will decrease the salary costs of the company. This is decrease the fixed costs of the company (annual wages and salaries), thus it will be easier to cover the new, lower, fixed costs. Thus, the break even point will decrease

A decrease in number of tours sold would proportionally change the variables and other costs and revenues associated. If you look at the calculation above, you will see that "number of tours" won't affect the Break Even Point. Thus, this action will create "no effect".

7 0

3 years ago

The economic theory that is focused on group ownership of the means of production with all members of the community sharing in t

brilliants [131]

It is Communism I think-

6 0

3 years ago

Cotrone Beverages makes energy drinks in three flavors: Original, Strawberry, and Orange. Company is currently operating at 75 p

yulyashka [42]

Answer:

Yes Strawberry line should be dropped as it reduces the overall profit by$ 3600 when the fixed costs are not 20 %

Yes Strawberry line should be dropped as it reduces the overall profit by$ 1720 even when the fixed costs are 20 %

Explanation:

Cotrone Beverages

Differential Analysis

Totals Totals Difference / Change

including (less) Without (equals)

Strawberry Strawberry

Sales 253,200 167,600 85600 Decrease

Variable costs 201,400 124,200 77200 Decrease

Fixed costs allocated 35,600 28,480 7120 Decrease

Operating profit (loss) 13,200 14,920 (1720) Increase

Working

Total Fixed Costs Reduced will be = 35,600 *20%= 7120

Here we see the profit is increased by 1720 therefore strawberry line should be dropped.

Cotrone Beverages

Differential Analysis

Totals Totals Difference / Change

including (less) Without (equals)

Strawberry Strawberry

Sales 253,200 167,600 85600 Decrease

Variable costs 201,400 124,200 77200 Decrease

Contribution margin 51,800 43,400 8,400 Decrease

Fixed costs allocated 35,600 23,600 12000 Decrease

Operating profit (loss) 13,200 16,800 (3,600) Increase

Yes Strawberry line should be dropped as it reduces the overall profit by$ 3600

Working

We find the totals with and without the strawberry product line and then subtract to find the differential costs

Cotrone Beverages

Product Original Strawberry Orange Total

Sales $65,200 $85,600 $102,400 253,200

Variable costs 44,000 77,200 80,200 201,400

Contribution margin $21,200 $8,400 $22,200 51,800

Fixed costs allocated 9,400 12,000 14,200 35,600

Operating profit (loss) $11,800 $(3,600) $8,000 13,200

If we drop the strawberry line then the new totals would be

Product Original Orange Total

Sales $65,200 $102,400 167,600

Variable costs 44,000 80,200 124,200

Contribution margin $21,200 $22,200 43,400

Fixed costs allocated 9,400 14,200 23,600

Operating profit (loss) $11,800 $8,000 16,800

6 0

2 years ago