Income Statement (P&L) $5,000,000 5 Revenues 7 (Revenue Deductions) $1,223,551 9 Net Revenues $3,776,449 11 Operating Expenses $2,776,449 13 Profit 15 Depreciation 16 Cash Flow $151,058 $1,151,068 1. Use the Assignment 6 Regression Work sheet below, which includes St. Vincent's Medical Center P&L data. 2. Produce a regression model predicts St. Vincent's total operating expense (Y) from its patient days (X). 3. Base the calculation of your model and its coefficients (slope and intercept) on St. Vincent's operating expenses and patient days from July through December. 4. The model you present to your CEO must be written out as follows, where you will use Excel to calculate the model's intercept and slope coefficients. *This is a model without coefficients representing its intercept and slope. I *Operating expense = intercept? + slope? (patient days) 4. Using the model you produced and patient days below, predict the requested operating expenses in Table 1. 5. Use the memorandum guide below to prepare your for CEO Franklin. *Operating expense = intercept? + slope? (patient days) 4. Using the model you produced and patient days below, predict the requested operating expenses in Table 1. 5. Use the memorandum guide below to prepare your for CEO Franklin. Table 1.0 Patient Days (X) 1. 2. 3. 4. Predicted Operating Expenses (Y) ? ? ? ? ? ? ? ? ? 0 2,069 2,110 2,139 2,078 2,037 2,800 2,300 1.999 5. 6. 7. 8. 9 Income Statement (P&L) $5,000,000 5 Revenues 7 (Revenue Deductions) $1,223,551 9 Net Revenues $3,776,449 11 Operating Expenses $2,776,449 13 Profit 15 Depreciation 16 Cash Flow $151,058 $1,151,068 1. Use the Assignment 6 Regression Work sheet below, which includes St. Vincent's Medical Center P&L data. 2. Produce a regression model predicts St. Vincent's total operating expense (Y) from its patient days (X). 3. Base the calculation of your model and its coefficients (slope and intercept) on St. Vincent's operating expenses and patient days from July through December. 4. The model you present to your CEO must be written out as follows, where you will use Excel to calculate the model's intercept and slope coefficients. *This is a model without coefficients representing its intercept and slope. I *Operating expense = intercept? + slope? (patient days) 4. Using the model you produced and patient days below, predict the requested operating expenses in Table 1. 5. Use the memorandum guide below to prepare your for CEO Franklin. *Operating expense = intercept? + slope? (patient days) 4. Using the model you produced and patient days below, predict the requested operating expenses in Table 1. 5. Use the memorandum guide below to prepare your for CEO Franklin. Table 1.0 Patient Days (X) 1. 2. 3. 4. Predicted Operating Expenses (Y) ? ? ? ? ? ? ? ? ? 0 2,069 2,110 2,139 2,078 2,037 2,800 2,300 1.999 5. 6. 7. 8. 9