Complete each sentence to describe how to add range names to existing formulas. Select the cells containing formulas with cell references that should be changed to names. Click the tab. In the group, click the Define Names drop-down arrow. Click . Use the dialog box to select the names.

The cook corporation has two divisions--east and west. the divisions have the following revenues and expenses: east west sales $ 603,000 $ 506,000 variable costs 231,000 300,000 traceable fixed costs 151,500 192,000 allocated common corporate costs 128,600 156,000 net operating income (loss) $ 91,900 $ (142,000 ) the management of cook is considering the elimination of the west division. if the west division were eliminated, its traceable fixed costs could be avoided. total common corporate costs would be unaffected by this decision. given these data, the elimination of the west division would result in an overall company net operating income (loss)

Bayside coatings company purchased waterproofing equipment on january 2, 20y4, for $190,000. the equipment was expected to have a useful life of four years and a residual value of $9,000. instructions: determine the amount of depreciation expense for the years ended december 31, 20y4, 20y5, 20y6, and 20y7, by (a) the straight-line method and (b) the double-declining-balance method. also determine the total depreciation expense for the four years by each method. depreciation expense year straight-line method double-declining-balance method 20y4 $ $ 20y5 20y6 20y7 total $

For each of the following cases determine the ending balance in the inventory account. (hint: first, determine the total cost of inventory available for sale. next, subtract the cost of the inventory sold to arrive at the ending balance.)a. jill’s dress shop had a beginning balance in its inventory account of $40,000. during the accounting period jill’s purchased $75,000 of inventory, returned $5,000 of inventory, and obtained $750 of purchases discounts. jill’s incurred $1,000 of transportation-in cost and $600 of transportation-out cost. salaries of sales personnel amounted to $31,000. administrative expenses amounted to $35,600. cost of goods sold amounted to $82,300.b. ken’s bait shop had a beginning balance in its inventory account of $8,000. during the accounting period ken’s purchased $36,900 of inventory, obtained $1,200 of purchases allowances, and received $360 of purchases discounts. sales discounts amounted to $640. ken’s incurred $900 of transportation-in cost and $260 of transportation-out cost. selling and administrative cost amounted to $12,300. cost of goods sold amounted to $33,900.a& b. cost of goods avaliable for sale? ending inventory?