What purpose does culture serve for an organization? 2Describe the Mayo Clinic’s culture from the perspective of espoused values and enacted values. 3Using the perspective of the functions of organizational culture, explain the impact of Mayo’s values and ideals. 4What role has the Mayo Clinic’s compensation system played in developing and maintaining its culture? 5Do you think the Mayo Clinic’s culture provides a good model for other healthcare organizations? Why or why not? SOURCE: This case was written by Michael K. McCuddy, The Louis S. and Mary L. Morgal

ACCT 500: Signature Assignment:

Finance Assessment – Part A: Financial Statement Analysis

Select the most recent financial set of financial statements for the company of your choice. Be sure to have your company approved by your professor.

Here is the scenario for your project:

You are the newly appointed treasurer and your partner is the newly appointed controller of your company. In order to learn more about your company, you have decided to analyze the company’s financial performance over the last 2 years. To do this, you have decided to calculate the following ratios for the company’s 2 most recent years in the noted categories:

1. Profitability Ratios
   1. Gross Margin Percentage
   2. EBIT Margin Percentage
2. Resource Management Ratios:
   1. Age of Inventory
   2. Age of Accounts Receivable
   3. Age of Accounts Payable
3. Liquidity Ratio:
   1. Current Ratio
4. Leverage Ratios
   1. Debt-to-Assets Ratio
   2. Debt-to-Equity Ratio
   3. Interest Coverage

In addition, you have decided to evaluate the Return on Equity (ROE) of the company by calculating the DuPont Ratio, including the Profit Margin, Asset Turnover, and Financial Leverage Ratios.

Required

As a member of a team, you will produce a 5–7-page paper that will show your calculations of each of these ratios for the company’s 2 most recent years. In addition, you will provide a brief analysis of each of the ratios. You will also provide a brief evaluation regarding the company’s performance as it relates to the four categories listed above, plus the DuPont Equation. Finally, you will discuss how these ratios will help you make appropriate financial decisions as they relate to your role as a financial manager, and also assist in achieving the firm’s financial management goals.

In addition, your team will also produce a 7-10 minute narrated PowerPoint presentation using VoiceThread or a similar tool that discusses the analysis of at least one ratio from the each of the four categories above. In addition, you must also discuss your DuPont Equation results. Finally, you must discuss how these ratios can be used to help you make appropriate decisions in your role as a treasurer or controller. All team member must be involved in the narration of the presentations.

As this is a collaborative project, an online collaboration tool (such as Big Blue Button or Cisco Spark) must be used to conduct your team meetings. Evidence must be provided that the tool was used for three weekly team meetings.

As with all papers and projects, APA standards are to be followed for all portions of this paper, including but not limited to proper referencing and citations.

Students are to observe two or more adults unknown to the observer. The student must not be able to hear the subjects being observed and those being observed must not be wearing a uniform of any kind as this would provide information about their occupation to the observer. Students must describe the environment and the people being observed, i.e., age, gender, dress, etc. Discuss the nonverbal communication, i.e. eye contact, body position and any other nonverbal behavior. Provide your interpretation of the relationship between those being observed. Be very discrete and do not have a conversation with those being observed.

Read Case 7.2: Poverty and Pollution, located on page 267 in your textbook. Next, predict the effects of pollution permits on poor, less-developed areas like Brazil’s “valley of death”. Assess the effectiveness of incentive programs on manufacturers in less-developed areas. Based on your assessment, pin an argument in support of either pollution permits or incentive programs.

Compose a 250-500 word essay describing your reasons for undertaking study in nursing at The George Washington University, your academic objectives, career goals, and related qualifications. Your essay should address Why nursing? Why now? Why GW?

1. Background: IT managers work with senior level IT leadership to submit an annual budget based on the business and IT strategies, tactical plans, operational plans and approved initiatives IT project portfolio. Hence, in this scenario the CIO has provided you with the IT budgeting workbook and asked you frame up next year’s IT budget for final review and approval.

2. Requirements & Deliverable: This is not a group project assignment. It is to be completed and submitted by each student individually.  Carefully, read the Project #3 Guideline Document. Use the IT Budget Workbook provided by the professor.  Complete the Project #3 assignment as instructed and submit before or on the scheduled due date. Your deliverable will be the completed IT Budget Workbook; must be a S. Excel File (working spreadsheet) that is uploaded into Moodle using the designated link. Note: Any manual entries or overwriting of pre-calculated fields on the work sheets or IT Department Budget dashboard to force the expected results outlined in section 5 of this document; will result in a failing grade for this assignment.

3. The IT Budgeting Workbook contains the following worksheets (Tabs):
   1. IT Department Budget
   2. IT Department Budget Worksheet*
   3. G&A Worksheet
   4. Software-Equipment-Service Worksheet*
   5. Personnel Worksheet
   6. References

Note: * Denotes that these are the only worksheets that will be modified to create the budget.  All worksheet will need to be referenced to make the appropriate entries in the IT Department Budget Worksheet and successfully create the IT Department budget.

4. IT Budget Workbook Tabs and Instructions:
   1. IT Department Budget Tab: This is the IT Budget Dashboard which will self-populate when the other worksheets have been completed.  You will use the dashboard to provide your overview of the budget for the CIO.

1. IT Department Budget Worksheet Tab: This is the primary worksheet used to formulate the IT budget.  You will complete all of the IT budget sections (e.g., Personnel, Computing Equipment, Software, Enterprise Data Center, and General & Administrative) by entering the appropriate dollar values for each month.  You will need complete and/or use the other worksheet tabs in the IT Budget workbook (e.g., G& A, Personnel, and Software-Equipment-Services) to properly complete the IT Department Budget Worksheet.  Please note the following:
   1. You will enter budget line items in Column “A” Rows (specifically 13-17; 21-27; 31-36; 40-46; 50-54; and 58-63) under each budget category where there are blanks referencing information outlined in the other corresponding worksheet tabs. Note: you may have one blank row in some budget sections; this is okay and part of the challenge for you to determine.
   2. To determine which equipment, software, and EDC facilities budget line items fall under capital or operational expense sections; you will need to determine the correct “Expenditure Type” by first completing the Software-Equipment-Services worksheet (Specifically: Column D in each of the tables, selecting either CAPEX or OPEX and then make the corresponding budget line item entry and amount into the IT Department Budget Worksheet. Also you do not need to add or change any of the remaining fields in these tables on this worksheet, they have already been prepopulated with the essential information for you to fill out the IT Department Budget Worksheet.

• You will enter the correct dollar amounts (fields already formatted) for each budget line items in the months (Jan – Dec / Columns B-M) when the expense will occur during the budget year. Specifically cells located in Columns B-M items in Rows 4-9; 13-17; 21-27; 31-36; 40-46; 50-54; 58-63; and 68-76 under each budget category where there are $0 values referencing information outlined in the other corresponding worksheet tabs. Note: you may have one or more $0 values contained in a row in some budget sections. Hint: not all expenses reoccur on a monthly basis; use the information already outlined in the corresponding worksheet to make the correct determination (e.g., amounts, billing frequency, and billing months).

1. All the cells “Total” fields in Column N for each row are calculated fields and already formatted. Do nothing in this column.
2. The IT Budget Worksheet Totals below the green highlighted row; are calculated fields and already formatted. Do nothing in the cells contained in Columns A-N:  Rows 78, 80, 81, 82, 83, and 84 in this worksheet.
3. The all of the G&A expense budget line items have already been entered into the IT Department Budget Work Sheet (Column A: Rows: 68 – 76). The cells contained in Columns B – N: Row 77; (Total G&A Expenses) under G&A section are calculated fields and already formatted. Do nothing in this row.

• The all of the Personnel expense budget line items have already been entered into the IT Department Budget Work Sheet (Column A: Rows: 31 – 36). The cells contained in Columns B-N: Row 10 (Total G&A Expenses) under G&A section are calculated fields and already formatted. Do nothing in this row.
• Columns B-M: Row 4 (Full-Time Employee Salaries) has already been prepopulated automatically from the Personnel Worksheet tab. The values in these cells are calculated fields and already formatted. Do nothing in this row.

1. G&A Worksheet: This worksheet does not need to be modified but analyzed and referenced to complete the corresponding G&A budget line items in the IT Department Budget Worksheet (e.g., Item names, estimated costs, billing frequency, occurrence, and billing month). This worksheet contains some typical expenses found in the G&A section of an IT budget. Please note the Equipment Depreciation was outlined on the G&A Worksheet but is not included in the IT Department Budget Worksheet (this particular item often requires a good understanding and special treatment with coordination with Finance & Account to determine the asset fair market value and allowable depreciation rates for these assets. In addition, this item is often excluded from the IT budget but included in the overall corporate budget. Lastly, top executives and Board of Directors salaries are often included in G&A and spread across all department budgets.  This G&A line item was not included for this exercise.

1. Software-Equipment-Service Worksheet: This worksheet does need to be analyzed, modified, and referenced to complete the corresponding G&A budget line items in the IT Department Budget Worksheet.  You will need to determine the correct “Expenditure Type” by first completing the Software-Equipment-Services worksheet (Specifically: Column D in each of the tables, selecting either CAPEX or OPEX and then make the corresponding budget line item entry and amount into the IT Department Budget Worksheet. Also you do not need to add or change any of the remaining fields in these tables on this worksheet, they have already been prepopulated with the essential information for you to fill out the IT Department Budget Worksheet (e.g., Item names, expenditure type, total price, billing frequency, occurrence, and billing month).

1. Personnel Worksheet: Fortunately for you, this worksheet does not need to be modified but analyzed and referenced to complete the corresponding Personnel budget line items in the IT Department Budget Worksheet (e.g., Item names, estimated costs, salaries, headcounts per month, billing frequency, occurrence, and billing month). This worksheet contains some typical expenses found in the personnel section of an IT budget. As noted earlier, all of the Personnel expense budget line items have already been entered into the IT Department Budget Work Sheet (Column A: Rows: 31 – 36). You will need to populate the remaining cells for this section of the budget using the prepopulated tables on the Personnel Worksheet. You will notice that the Full-Time Employee salaries have already been populated in the IT Department Budget Worksheet (Columns: B-M; Row 4) you do not need to do anything else with this line item. This information came from and is directly linked to the IT Department Personnel Monthly Worksheet You will how ever need to calculate the budget amounts for the consulting staff using the Contracted Support Staff Table based on the total number per month and predefined salaries. Use the Other Personnel Expenditure Table to complete the remaining budget line items and associated expenditures per month to their corresponding line item on the IT Department budget Worksheet.
2. References: Do nothing with this worksheet. It was used to build reference lists for drop downs items in the table on the worksheets.

5. This project assignment is meant to give you some practical hands-on experience and a better understanding of the key components, data, correlations to IT investments and operations required in formulating the IT Department budget. Reference Module 6 lecture notes and course text, and perhaps independent research to complete this project assignment. As a guide post your IT Department Dashboard final total results for this Year’s Budget column should be comparable to the following:

Use this table to compare with the IT Department Budget dashboard tab in the workbook.

If you are off buy a small amount don’t get concerned.  However, if you are way off the mark, then you most likely have misclassified the expenditure type, have errors in calculations, or entered in a wrong amount in a cell.  You must pay attention to detail when transferring information from the corresponding worksheets. Recheck your determinations and values. Again do not make entries to force the expected outcomes outlined in this table. You will be much better off submitted the assignment giving it your best try with minor errors than manipulating the spreadsheet to align with the expected result outlined in the table above.  Lastly, you will have a working example to reference if and when you are asked to submit an IT Budget.   Good Luck!

Identify advocacy strategies that you can use to create change in your current workplace

Identify the educational preparation and role(s) of the clinical nurse leader (CNL) designation. Give an example of how the CNL influences direct patient care whether in a hospital or out in the community.