What is the first step when creating a 3-D range name? Open the New Range window, and click 3-D.
O Press the Shift key while selecting the new sheet.
O Open the Name Manager, and click New.
O Click a cell to insert the cell reference.

An office manager is concerned with declining productivity. despite the fact that she regularly monitors her clerical staff four times each day—at 9: 00 am, 11: 00 am, 1: 00 pm, and again at 3: 00 pm—office productivity has declined 30 percent since she assumed the helm one year ago. would you recommend that the office manager invest more time monitoring the productivity of her clerical staff? explain.

You are the manager in charge of global operations at bankglobal – a large commercial bank that operates in a number of countries around the world. you must decide whether or not to launch a new advertising campaign in the u.s. market. your accounting department has provided the accompanying statement, which summarizes the financial impact of the advertising campaign on u.s. operations. in addition, you recently received a call from a colleague in charge of foreign operations, and she indicated that her unit would lose $8 million if the u.s. advertising campaign were launched. your goal is to maximize bankglobal’s value. should you launch the new campaign? explain. pre-advertising campaign post-advertising campaign total revenues $18,610,900 $31,980,200 variable cost tv airtime 5,750,350 8,610,400 ad development labor 1,960,580 3,102,450 total variable costs 7,710,930 11,712,850 direct fixed cost depreciation – computer equipment 1,500,000 1,500,000 total direct fixed cost 1,500,000 1,500,000 indirect fixed cost managerial salaries 8,458,100 8,458,100 office supplies 2,003,500 2,003,500 total indirect fixed cost $10,461,600 $10,461,600

Lindon company is the exclusive distributor for an automotive product that sells for $30.00 per unit and has a cm ratio of 30%. the company’s fixed expenses are $162,000 per year. the company plans to sell 20,200 units this year. required: 1. what are the variable expenses per unit? (round your "per unit" answer to 2 decimal places.) 2. what is the break-even point in unit sales and in dollar sales? 3. what amount of unit sales and dollar sales is required to attain a target profit of $72,000 per year? 4. assume that by using a more efficient shipper, the company is able to reduce its variable expenses by $3.00 per unit. what is the company’s new break-even point in unit sales and in dollar sales? what dollar sales is required to attain a target profit of $72,000?