Excel Work & Vendor Selection and Management Assignments

This week we will have two assignments. One will sharpen your MS Excel skills. The other assignment will allow us to make some decisions about what existing healthcare focused data analysis tools could best fit a scenario.

Assignment $1$: Excel Work

This assignment is designed to get students comfortable with working in MS Excel which is a baseline I$$m sure most have used to generate a report. The important thing to note is this work must be submitted in MS Excel format to receive any credit. In short, students will be generating a healthcare focused balance sheet. Yes, students will create this from scratch $($no template will be provided$)$ just as they were in a true work environment. Here are the detailed instructions:

Pretend you are generating a balance sheet for an urgent care $+$ pharmacy facility for a single month $($i$.$e$.,$ snapshot of time$).$

The balance sheet submitted must have three main sections: assets, liabilities, and equity.

For last name$$s beginning with a letter A$-$M$,$ the sheet should balance out to be $80,000.$ For last name$$s begging with a letter N$-$Z$,$ the sheet should balance out to be $70,000.$ Students may input whatever numbers in the respective categories to get to that result.

This is a time to get comfortable with excel. The professor will be double checking that basic adding formulas are inserted into the cells instead of the students just manually entering each number. Also, basic items such as bolding, shading headers, and formatting cells to be money should be implemented.

$*$Note your professor might change the ending balance numbers so check with them to be sure $$

$5.$ There should be at minimum of:

$4$ assets $($but no more than $5)$; you can make these up $($i$.$e$.,$ Rx Copays$)$

$4$ liabilities $($but no more than $5)$; you can make these up $($i$.$e$.,$ mortgage$)$

$2$ items representing equity $($but no more than $4)$

$*$Remember Assets $=$ liability $+$ Equity and Equity $=$ Assets $$ Liabilities

$6.$ Inserted below is a very brief of what the final balance sheet output should somewhat look like. Your submission should be a little more jazzed up$.$ For example, come up with a name for the facility.

$7.$ Finally, generate a pie chart within Excel displaying the liabilities.