Segregation of duties of shipping and billing. Periodic reconciliation of prenumbered orders with prenumbered shipping documents. 12.12 Excel problem Use regression tools to analyze and forecast future sales. (Hint: The article with Excel,” by James A. Weisel in the February “Forecasting 2009 issue of the (available at ) explains how to perform the Journal of Accountancy following tasks using either Excel 2003 or Excel 2007). a. Create a spreadsheet with the following data about targeted emails, click ads, and unit sales: Emails Clicks Unit Sales 130000 125 13000 150000 100 12000 100000 85 12000 155000 105 12500 110000 100 9000 125000 75 10000 120000 135 10000 130000 150 14000 130000 140 13500 135000 125 12500 140000 125 13400 120000 100 10000 130000 115 12750 125000 125 120000 105 12750 130000 135 11500 100000 95 10000 130000 110 12500 130000 145 9000 120000 95 10500 150000 150 15000 100000 75 10750 140000 120 110000 100 10000 125000 100 13500 100000 80 9500 110000 95 11000 140000 130 13500 130000 140 13500 120000 110 11500
Segregation of duties of shipping and billing. Periodic reconciliation of prenumbered orders with prenumbered shipping documents. 12.12 Excel problem Use regression tools to analyze and forecast future sales. (Hint: The article “Forecasting with Excel,” by James A. Weisel in the February 2009 issue of the Journal of Accountancy (available at ) explains how to perform the following tasks using either Excel 2003 or Excel 2007). a. Create a spreadsheet with the following data about targeted emails, click ads, and unit sales: Emails Clicks Unit Sales 150000 100 12000 155000 105 12500 125000 75 10000 130000 150 14000 135000 125 12500 120000 100 10000 125000 125 130000 135 11500 130000 110 12500 120000 95 10500 100000 75 10750 110000 100 10000 100000 80 9500 140000 130 13500 120000 110 11500 130000 125 13000 100000 85 12000 110000 100 9000 120000 135 10000 130000 140 13500 140000 125 13400 130000 115 12750 120000 105 12750 100000 95 10000 130000 145 9000 150000 150 15000 140000 120 125000 100 13500 110000 95 11000 130000 140 13500
rais12_Sm_CH12.docx