current fiscal year Budget and Actual expense data from the general ledger.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

The following tabs of data are available for this exercise:

1 Ledger Data - current fiscal year Budget and Actual expense data from the general ledger. Presented at the Account level with Account Type rollups

2 Hierarchy - Represents our hierarchy defining what ledger activity gets grouped by for reporting

3 Inpatient Nursing Groups - table defining which cost centers represent our Inpatient Nursing Groups

4 Inpatient Nursing Days - current fiscal year Inpatient Nursing Days by Group

Instructions:

1 "Create a new tab called Expense Summary and create a variance report (budget vs. actual) which summarizes the ledger data rolled up by Unit and Department with subtotals for each Unit. 

Reference tabs 1 and 2.

(Note: the data also includes ""OpUnit"" which we are not using here.)"

2 "Create a new tab called IP Nursing Analysis and create a bar chart which shows Salaries and Wages dollars per Inpatient days for each IP Nursing Group. 

Reference tabs 1, 3 and 4.

 

Additional guidance below (OPTIONAL. Follow only as needed.)

- i. In a new field, combine OU (operating unit) and DeptID in the Ledger tab

- ii. Use VLOOKUPs to tie OU-DeptID combos to the Inpatient Nursing groupings

- iii. Add a field to divide total actual Salaries and Wages by inpatient days for each IP Nursing group

- iv. Show this calculated Salaries per Day for each IP Nursing group in a bar chart"

 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme