Conditional formatting allows spreadsheet users to a> turn cell protection functions on and off. b> calculate the average number of people at sporting events. c> highlight test scores of below 90% in a grade book. d> add additional formatting options to a menu.

The following information is available for juno company for the month ending june 30, 2019. * balance as per the bank statement is $ 11 comma 000. * balance as per books is $ 10 comma 400. * check #506 for $ 1 comma 200 and check #510 for $ 900 were not shown on the june 30, bank statement. * a deposit in transit of $ 3 comma 346 had not been received by the bank when the bank statement was generated. * a bank debit memo indicated an nsf check for $ 70 written by jane smith to juno company on june 13. * a bank credit memo indicated a note collected by the bank of $ 1 comma 900 and interest revenue of $ 51 on june 20. * the bank statement indicated service charges of $ 35. what is the adjusted book balance?

Consider derek's budget information: materials to be used totals $64,750; direct labor totals $198,400; factory overhead totals $394,800; work in process inventory january 1, $189,100; and work in progress inventory on december 31, $197,600. what is the budgeted cost of goods manufactured for the year? a. $1,044,650 b. $649,450 c. $657,950 d. $197,600

M. cotteleer electronics supplies microcomputer circuitry to a company that incorporates microprocessors into refrigerators and other home appliances. one of the components has an annual demand of 235 units, and this is constant throughout the year. carrying cost is estimated to be $1.25 per unit per year, and the ordering (setup) cost is $21 per order. a) to minimize cost, how many units should be ordered each time an order is placed? b) how many orders per year are needed with the optimal policy? c) what is the average inventory if costs are minimized? d) suppose that the ordering cost is not $21, and cotteleer has been ordering 125 units each time an order is placed. for this order policy (of q = 125) to be optimal, determine what the ordering cost would have to be.