((EXCEL)) I am having a hard time figuring out the correct formula to this question. If anyone could help out, I'd really appreciate it! Brett assigns each client a rating of A, B, or C depending on the number of days an invoice is overdue. Display this information using a nested IF function as follows:
In cell I6, insert a formula using an IF function to test whether the days overdue (cell G6) are less than 1 and displays a rating of "A" if the condition is true.
The next condition uses another IF function to test whether the days overdue (cell G6) are less than 30 and displays a rating of "B" if the condition is true.
Display a rating of "C" if the conditions are false.
Use the Fill Handle to fill the range I7:I15 with the formula in cell I6, filling the range without formatting.

The following balance sheet for the los gatos corporation was prepared by a recently hired accountant. in reviewing the statement you notice several errors. los gatos corporation balance sheet at december 31, 2018 assets cash $ 44,000 accounts receivable 86,000 inventories 57,000 machinery (net) 122,000 franchise (net) 32,000 total assets $ 341,000 liabilities and shareholders' equity accounts payable $ 54,000 allowance for uncollectible accounts 7,000 note payable 59,000 bonds payable 112,000 shareholders' equity 109,000 total liabilities and shareholders' equity $ 341,000 additional information: cash includes a $22,000 restricted amount to be used for repayment of the bonds payable in 2022. the cost of the machinery is $194,000. accounts receivable includes a $22,000 note receivable from a customer due in 2021. the note payable includes accrued interest of $7,000. principal and interest are both due on february 1, 2019. the company began operations in 2013. income less dividends since inception of the company totals $37,000. 52,000 shares of no par common stock were issued in 2013. 200,000 shares are authorized. required: prepare a corrected, classified balance sheet. (amounts to be deducted should be indicated by a minus sign.)

Ida sidha karya company is a family-owned company located on the island of bali in indonesia. the company produces a handcrafted balinese musical instrument called a gamelan that is similar to a xylophone. the gamelans are sold for $860. selected data for the company’s operations last year follow: units in beginning inventory 0 units produced 320 units sold 285 units in ending inventory 35 variable costs per unit: direct materials $ 135 direct labor $ 355 variable manufacturing overhead $ 30 variable selling and administrative $ 15 fixed costs: fixed manufacturing overhead $ 64,000 fixed selling and administrative $ 27,000 the absorption costing income statement prepared by the company’s accountant for last year appears below: sales $ 245,100 cost of goods sold 205,200 gross margin 39,900 selling and administrative expense 31,275 net operating income $ 8,625 required: 1. under absorption costing, how much fixed manufacturing overhead cost is included in the company's inventory at the end of last year? 2. prepare an income statement for last year using variable costing. what is the amount of the difference in net operating income between the two costing methods?

Adog whistle manufacturer's factory was located near a residential area. the manufacturer used the most effective methods for testing its whistles, but it was impossible to completely soundproof the testing area. a breeder of champion show dogs bought some property near the factory and raised and trained her dogs there. although the whistles were too high-pitched to be perceived by human ears, they could be heard by the breeder's dogs. consequently, the dogs often were in a constant state of agitation. in a suit by the breeder against the manufacturer, what is the likely outcome? response - correct a the breeder will prevail on a trespass theory, because the sound waves are entering onto the breeder's property. b the breeder will prevail on a nuisance theory, because the sound of the whistles is a substantial interference with the breeder's use of her land. c the breeder will not prevail, because the sound of the whistles is not a substantial interference with the breeder's use of her land. d the breeder will not prevail, because the manufacturer has acted reasonably in testing its whistles.