A small business owner uses an Excel spreadsheet to calculate the costs of various health insurance options for her employees. The individual annual premium is in cell B5. The employers monthly contribution is in Cell D9 and the monthly cost of the family option is in cell B6. Which multimath formula should be entered in Cell E9 to calculate the monthly premium for an employee who selects the
individual-only healthcare?
A) =(B5/12)+B6
B) =(B5/12)-D9
C) =B5-D9
D) =B5+B6-D9
B
You might also like to view...
Computing a percentage of accounts receivable is the simplest and most commonly used approach to estimating uncollectible accounts
a. True b. False Indicate whether the statement is true or false
In a periodic inventory system, the cost of purchases is recognized as
a. an integral part of the calculation of cost of goods sold. b. the only part of the calculation of cost of goods sold. c. an increase in the inventory account. d. an increase in an asset account.
Aloe Company reports its income from its investment in Palm Company under the equity method. Aloe recognized income of $125,000 from its investment in Palm during the current year. Palm declared and paid dividends of which Aloe's share was $25,000 during the current year. The effect of these activities on the operating section of the statement of cash flows of Aloe Company prepared for the
current year under the indirect method would be a. an increase of $125,000. b. a deduction of $125,000. c. a deduction of $100,000. d. an increase of $100,000.
Which of the following is usually considered a line department?
a. public relations b. operations c. human resources d. data processing