The According to the lecture video on building dynamic charts, which of the following Excel functions are used in the "Refers to:" formula in Name Manager?combo box (form control) option in macros can be used to substitute for ___ when doing scenario analysis.

Depreciation on the company's equipment for 2017 is computed to be $18,000.the prepaid insurance account had a $6,000 debit balance at december 31, 2017, before adjusting for the costs of any expired coverage. an analysis of the company's insurance policies showed that $1,100 of unexpired insurance coverage remains.the office supplies account had a $700 debit balance on december 31, 2016; and $3,480 of office supplies were purchased during the year. the december 31, 2017, physical count showed $300 of supplies available.two-thirds of the work related to $15,000 of cash received in advance was performed this period.the prepaid insurance account had a $6,800 debit balance at december 31, 2017, before adjusting for the costs of any expired coverage. an analysis of insurance policies showed that $5,800 of coverage had expired.wage expenses of $3,200 have been incurred but are not paid as of december 31, 2017.

Jacob is a member of wcc (an llc taxed as a partnership). jacob was allocated $155,000 of business income from wcc for the year. jacob’s marginal income tax rate is 37 percent. the business allocation is subject to 2.9 percent of self-employment tax and 0.9 percent additional medicare tax. (round your intermediate calculations to the nearest whole dollar a) what is the amount of tax jacob will owe on the income allocation if the income is not qualified business income? b) what is the amount of tax jacob will owe on the income allocation if the income is qualified business income (qbi) and jacob qualifies for the full qbi duduction?

Classify each of the following items as a public good, a private good, a natural monopoly good, or a common resource.(a) measles vaccinations (b) tuna in the pacific ocean (c) airline service in the united states (d) local storm-water system