Complete the Analysis section using formulas with statistical functions. Use named ranges instead of cell references in the formulas. Calculate the average, highest, and lowest values for each of the following:a. Price b. MPG City c. MPG Highway d. Average MPG e. Maintenance/Year f. Registration Fee g. Insurance /Year h. Amount to Borrow i. APR j. Years k. Loan Payment l. Gas m. Maintenance/Month n. Insurance/Month o. Total Monthly

]4. seiler company has the following information: materials work-in-process finished goods beginning inventory 300 400 500 ending inventory 700 900 1500 material purchase 7,700 cost of goods sold 15,600 direct labor 5,500 what was the manufacturing overhead for the period? a. $3,400. b. $4,300. c. $3,000. d. $5,500.

Suppose the following items were taken from the balance sheet of nike, inc. (all dollars are in millions.) 1. cash $ 2,316.7 7. inventory $ 2,245.6 2. accounts receivable 2,786.2 8. income taxes payable 80.3 3. common stock 2,841.1 9. equipment 1,783.8 4. notes payable 291.2 10. retained earnings 6,162.5 5. buildings 3,959.7 11. accounts payable 2,624.6 6. mortgage payable 1,092.3 perform each of the following. classify each of these items as an asset, liability, or stockholders’ equity, and determine the total dollar amount for each classification. (enter amounts in millions up to 1 decimal place, e.g. 45.5 million.) cash accounts receivable common stock notes payable buildings mortgage payable inventory income taxes payable equipment retained earnings accounts payable assets $ 13092 liability $ 4088.4 stockholders’ equity $ 9003.6 etextbook and media determine nike’s accounting equation by calculating the value of total assets, total liabilities, and total stockholders’ equity. (enter amounts in millions up to 1 decimal place, e.g. 45.5 million.) total assets = total liabilities + total stockholders’ equity

(a) what was the opportunity cost of non-gm food for many buyers before 2008? (b) why did they prefer the alternative? (c) what was the opportunity cost in 2008? (d) why did it change?