Determine the cost of each employees medical plan

Assignment Help Financial Accounting

Reference no: EM131211140

In cell P2, enter a formula using the VLOOKUP function to determine the cost of each employee’s medical plan as described below: a. Use a structured reference to the Medical Plan field as the Lookup_value parameter value. b. Use the defined name Medical_Premium (which represents the range S8:T15) as the Table_array parameter value. c. Use 2 as the Column_index_num parameter value. d. Use FALSE as the Range_Lookup parameter value. e. The entire VLOOKUP function should be multiplied by 12 (to convert the monthly premium cost to a yearly premium cost). MICROSOLFT EXCEL 2013

Reference no: EM131211140

Questions Cloud

When costs are rising and inventory quantities are stable : A company should accrue a loss contingency only if the likelihood that a liability has been incurred is: In a period when costs are rising and inventory quantities are stable, the inventory method that would result in the highest ending inventory is:

Determine the gain that razzle should recognize : Courtney owns a 70% interest in Razzle Partnership and an 85% interest in Dazzle Partnership. IN August, 2015, Dazzle sold land to Razzle for $2.3 million. The land had a basis to Dazzle of $2.5 million. In September 2015, Razzle sold the land to an ..

Using the straight-line depreciation method : Pinnacle Corporation has been using the straight-line depreciation method to depreciate some office equipment that was acquired at the beginning of 2013. Prepare the journal entry, if any, to record the accounting change at the beginning of 2016.

Determine the amount of income that the partner : Determine the amount of income that the partner should report as income on partnership or the amount of capital gain or loss the partner should recognize:

Determine the cost of each employees medical plan : In cell P2, enter a formula using the VLOOKUP function to determine the cost of each employee’s medical plan as described below: Use a structured reference to the Medical Plan field as the Lookup_value parameter value.

Collect costs related to production of crunchy pick cereal : Magno Cereal Corporation uses a standard cost system to collect costs related to the production of its "crunchy pickle" cereal. The pickle (materials) standards for each batch of cereal produced are 1.4 pounds of pickles at a standard cost of $3.00 p..

What will be the value of the annuity when you retire : You are earning an average of $45,900 and will retire in 11 years. If you put 15% of your gross average income in an ordinary annuity compounded at 8% annually, what will be the value of the annuity when you retire?

Anticipates he will need approximately : Sam Long anticipates he will need approximately $225,400 in 13 years to cover his 3-year-old daughter’s college bills for a 4-year degree. How much would he have to invest today at an interest rate of 6 percent compounded semiannually?

What alternative transaction : At the beginning of the year, Jenny, Inc. (a corporation for tax purposes) had a negative $15,000 in E&P. During the year, the company had $5,000 in profits. What are the federal tax consequences to Jenny of the distribution? What alternative transac..

User Account

All Pages