Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $12.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER QUANTITY (UNITS) QUARTER QUANTITY (UNITS) LAST YEAR THIS YEAR I 12 I 16 II 18 II 24 III 26 III 28 IV 16 IV 14 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) b. Compute trend and seasonal factor from a linear regression line obtained with Excel. (Do not round intermediate calculations. Round your answers to 3 decimal places.)

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