Companies in the u. s. car rental market vary greatly in terms of the size of the fleet, the number of locations, and annual revenue. in 2011 hertz had 320,000 cars in service and annual revenue of approximately $4.2 billion. the following data show the number of cars in service (1000s) and the annual revenue ($ millions) for six smaller car rental companies (auto rental news website, august 7, 2012). excel file: data14-09.xls if required, enter negative values as negative numbers. a. select a scatter diagram with the number of cars in service as the independent variable. b. what does the scatter diagram developed in part (a) indicate about the relationship between the two variables? c. use the least squares method to develop the estimated regression equation (to 3 decimals). ŷ = + x d. for every additional car placed in service, estimate how much annual revenue will change. by $ e. fox rent a car has 11,000 cars in service. use the estimated regression equation developed in part (c) to predict annual revenue for fox rent a car. round your answer to nearest whole value. $ million hide feedback partially correct

Milden company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. as an aid in planning, the company has decided to start using a contribution format income statement. to have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas: cost cost formula cost of good sold $35 per unit sold advertising expense $210,000 per quarter sales commissions 6% of sales shipping expense ? administrative salaries $145,000 per quarter insurance expense $9,000 per quarter depreciation expense $76,000 per quarter management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. units sold and the related shipping expense over the last eight quarters follow: quarter units sold shipping expense year 1: first 10,000 $ 119,000 second 16,000 $ 175,000 third 18,000 $ 190,000 fourth 15,000 $ 164,000 year 2: first 11,000 $ 130,000 second 17,000 $ 185,000 third 20,000 $ 210,000 fourth 13,000 $ 147,000 milden company’s president would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter. required: 1. using the high-low method, estimate a cost formula for shipping expe