1) Develop formulas or functions that calculate totals for the budgeted and actual encounters for June 2018, May 2018, and 2018 Year-to-Date (YTD) in the appropriate shaded cells of row 12.

1) Develop formulas or functions that calculate totals for the budgeted and actual encounters for June 2018, May 2018, and 2018 Year-to-Date (YTD) in the appropriate shaded cells of row 12.

2) Develop formulas or functions that calculate the variance between June 2018 budgeted and actual amounts in the appropriate shaded cells in Column D.

3) Develop formulas or functions that calculate totals for personnel expenses and non-personnel expenses in the appropriate shaded cells in rows 17 and 24.

4) Develop formulas or functions that calculate totals for health center expenses and their variances in the shaded cells in B25 through G25.

  • attachment

    assignmentweek1.docx
  • attachment

    assignment1clinicxlsx.xlsx
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *