Without grouping the sheets, make the following calculations in both worksheets: • In cell B10, enter a COUNTIF function to determine how many different types of Tulips are in stock on the Bulbs sheet and how many different types of Evergreens are in stock on the Trees worksheet.

The 2016 financial statements of the new york times company reveal average shareholders’ equity attributable to controlling interest of $837,283 thousand, net operating profit after tax of $48,032 thousand, net income attributable to the new york times company of $29,068 thousand, and average net operating assets of $354,414 thousand. the company's return on net operating assets (rnoa) for the year is: select one: a. 3.5% b. 6.9% c. 13.6% d. 18.7% e. there is not enough information to calculate the ratio.

12. nelson corporation, which has only one product, has provided the following data concerning its most recent month of operations: selling price $ 115 units in beginning inventory 380 units produced 5,900 units sold 6,070 units in ending inventory 210 variable costs per unit: direct materials $ 46 direct labor $ 27 variable manufacturing overhead $ 3 variable selling and administrative $ 12 fixed costs: fixed manufacturing overhead $ 112,100 fixed selling and administrative $ 36,420 the company produces the same number of units every month, although the sales in units vary from month to month. the company's variable costs per unit and total fixed costs have been constant from month to month. a. prepare a contribution format income statement for the month using variable costing. unit product cost under variable costing direct materials direct labor variable manufacturing overhead variable costing unit product cost (formula)

Afinancial institution, the thriftem bank, is in the process of formulating its loan policy for the next quarter. a total of $12 million is allocated for that purpose. being a full-service facility, the bank is obligated to grant loans to different clientele. the following table provides the types of loans, the interest rate charged by the bank, and the possibility of bad debt as estimated from past experience.type of loaninterest rateprobability of bad debtpersonal.140.10car.130.07home.120.03farm.125.05commercial.100.02 bad debts are assumed unrecoverable and hence produce no interest revenue either. competition with other financial institutions in the area requires that the bank allocate at least 40% of the total funds to farm and commercial loans. to assist the housing industry in the region, home loans must equal at least 50% of the personal, car, and home loans. the bank also has a stated policy specifying that the overall ratio for bad debts on all loans may not exceed .04. formulate this problem as a linear program. define your variables clearly and write all the constraints explaining the significance of each.