Which function will give the average of values in the second column of a database named “Earnings” that meets the criteria listed in cells A2 through C4? A. =DAVERAGE(2,Earnings, A2:C4)
B. =DAVERAGE(A2:C4,Earnings,2)
C. =DAVERAGE(A2:C4,2,Earnings)
D. =DAVERAGE(Earnings,2,A2:C4)

In 2015, lori assigned a paid-up whole life insurance policy to an irrevocable life insurance trust (ilit) for the benefit of her three children. the ilit contained a crummey provision for the benefit of each child. at the time of the transfer, the whole life insurance policy was valued at $200,000, and since lori had not made any other taxable gifts during her lifetime, she did not owe any gift tax. lori died in 2016, and the face value of the whole life insurance policy of $2,000,000 was paid to the ilit. regarding this transfer, how much is included in lori’s gross estate at her death?

The chromosome manufacturing company produces two products, x and y. the company president, jean mutation, is concerned about the fierce competition in the market for product x. she notes that competitors are selling x for a price well below chromosome's price of $13.50. at the same time, she notes that competitors are pricing product y almost twice as high as chromosome's price of $12.50.ms. mutation has obtained the following data for a recent time period: product x product y number of units 11,000 3,000 direct materials cost per unit $3.23 $3.09 direct labor cost per unit $2.22 $2.10 direct labor hours 10,000 3,500 machine hours 2,100 1,800 inspection hours 80 100 purchase orders 10 30ms. mutation has learned that overhead costs are assigned to products on the basis of direct labor hours. the overhead costs for this time period consisted of the following items: overhead cost item amount inspection costs $16,200 purchasing costs 8,000 machine costs 49,000 total $73,200using direct labor hours to allocate overhead costs determine the gross margin per unit for product x. choose the best answer from the list below.a. $1.93b. $3.12c. $7.38d. $2.43e. $1.73using activity-based costing for overhead allocation, determine the gross margin per unit for product y. choose best answer from list below.a. $10.07b. ($2.27)c. ($5.23)d. ($7.02)e. $7.02

Vortex company operates a retail store with two departments. information about those departments follows. department a department b sales $ 800,000 $ 450,000 cost of goods sold 497,000 291,000 direct expenses salaries 125,000 88,000 insurance 20,000 10,000 utilities 24,000 14,000 depreciation 21,000 12,000 maintenance 7,000 5,000 the company also incurred the following indirect costs. salaries $36,000 insurance 6,000 depreciation 15,000 office expenses 50,000 indirect costs are allocated as follows: salaries on the basis of sales; insurance and depreciation on the basis of square footage; and office expenses on the basis of number of employees. additional information about the departments follows. department square footage number of employees a 28,000 75 b 12,000 50 required: 1. determine the departmental contribution to overhead and the departmental net income for department a and department b.