You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use. Which of the following is an effective alternatives for the use of extensive nested IF functions?
lookup table

Suppose the marginal damage and marginal benefit curves in a polluted neighborhood are md = p/3 and mb = 4 – p. also, suppose that transactions costs are low, so that the consumers and the firm can bargain. we saw that in this case, the socially-optimal level of pollution is achieved. start by computing the socially-optimal p. then, for each of the following cases, compute the amount of money transferred through the bargaining process, and indicate who pays whom (i. e., whether consumers pay the firm, or vice versa). also, compute the gains to each party relative to the status quo (i. e., the starting point of the bargaining process).a)consumers have the right to clean air; firm is dominant in the bargaining process. b)consumers have the right to clean air; consumers are dominant in the bargaining process. c)firm has the right to pollute; firm is dominant in the bargaining process. d)firm has the right to pollute; consumers are dominant in the bargaining proces

Miko willingly admits that she is not an accountant by training. she is concerned that her balance sheet might not be correct. she has provided you with the following additional information. 1. the boat actually belongs to miko, not to skysong, inc.. however, because she thinks she might take customers out on the boat occasionally, she decided to list it as an asset of the company. to be consistent, she also listed as a liability of the corporation her personal loan that she took out at the bank to buy the boat. 2. the inventory was originally purchased for $27,500, but due to a surge in demand miko now thinks she could sell it for $39,600. she thought it would be best to record it at $39,600. 3. included in the accounts receivable balance is $11,000 that miko loaned to her brother 5 years ago. miko included this in the receivables of skysong, inc. so she wouldn’t forget that her brother owes her money. (b) provide a corrected balance sheet for skysong, inc.. (hint: to get the balance sheet to balance, adjust stockholders’ equity.) (list assets in order of liquidity.)

Exercise 15-7 crawford corporation incurred the following transactions. 1. purchased raw materials on account $53,000. 2. raw materials of $45,200 were requisitioned to the factory. an analysis of the materials requisition slips indicated that $9,400 was classified as indirect materials. 3. factory labor costs incurred were $65,400, of which $50,200 pertained to factory wages payable and $15,200 pertained to employer payroll taxes payable. 4. time tickets indicated that $55,000 was direct labor and $10,400 was indirect labor. 5. manufacturing overhead costs incurred on account were $81,700. 6. depreciation on the company’s office building was $8,100. 7. manufacturing overhead was applied at the rate of 160% of direct labor cost. 8. goods costing $89,400 were completed and transferred to finished goods. 9. finished goods costing $76,000 to manufacture were sold on account for $105,100. journalize the transactions. (credit account titles are automatically indented when amount is entered. do not indent manually.) no. account titles and explanation debit credit (1) (2) (3) (4) (5) (6) (7) (8) (9) (to record the sale) (to record the cost of the sale) click if you would like to show work for this question: open show work