This file of HIM 435 Week 1 DQs comprises:

Which of the Principles of Management functions do you see as the most important? Is one more important than another? Explain your answer.

What did you learn from the interactive tutorial about the principles of management that can be applied in the management of an HIM department?

Sources of Employment Law (graded)Abu Okari Al-Amin, an African-American man in his mid-20s, was recently hired by the HIM department to manage its photocopying, mailing, and office supplies center. In this role Mr. Al-Amin has regular contact with virtually all of the 25 staff in the department and employees and some physicians from other adjacent departments. Mr. Al-Amin is quite articulate, personable, and knowledgeable in his areas of responsibility. However, his long dreadlocks, Afro-Caribbean clothing style, his playing Reggae music on his lunch breaks, and (in the words of one white employee with 25 years of seniority) his using of “militant language” seemed to discomfort or threaten some of the staff. However, no real problems surfaced until one of the coders, Ms. Joyce Kim, an older Korean-American woman, filed a complaint with her supervisor, Leah Solomon, against Mr. Al-Amin for using “dirty” language in her presence, including the use of ethnic slurs, and otherwise treating her with disrespect. Ms. Kim also claimed that she smelled what she thought might be marijuana when he was close to her. The alleged incidents took place with no other witnesses to corroborate the facts Ms. Solomon presented the complaint to Mr. Al-Aminin a one-on-one meeting to give him the opportunity to respond to the charges. Although Mr. Al-Amin conceded that he was not comfortable with Koreans because of tension with Korean Businesses in his neighborhood, he denied that he said anything disrespectful or abusive toMs. Kim. He admitted to using some colorful street language with her that he used regularly with everybody and that no offense had been intended. He brushed off the reference to any drug use. Class, as the employee’s supervisor, what steps would you take next to resolve this issue?

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Hello! I am in an Info System Fundamentals class, and need help desperately on this homework. If you could explain step-by-step how to complete these questions I’d be so grateful! Below are the questions, along with pictures of the excel sheets.

1.Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirstwith your name.

2.On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20.

3.On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold $200,000 or more (cell J2) AND is International(cell I4), he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range J9:J20.

4.Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica.

5.Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales.

6.Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22.

7.In cell J7, enter a database function to calculate the number of reps meeting the criteria. 

8.In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. 

9.In cell J9, enter a database function to calculate the average sales for records meeting the criteria. 

10.Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters.

11.In cell E5, enter a function to calculate the monthly payment. Modify the function to ensure that the result is a positive number.

12.In cell E6, enter a function to calculate the total interest paid after five payments. Modify the function to ensure that the result is a positive number. The formula will result in an error until the loan amortization table is completed.

13.In cell B11, make relative reference to cell B7 and in cell C11, make relative reference to cell E2. In cell C12, enter a relative reference to cell F11 and copy the formula to the range C13:C15.

14.In cell B12, insert a function to enter the payment date for the next month. Copy the function to the range B13:B15.

15.In cell D11, enter the financial function to calculate the interest paid for the first payment period. The result should be a positive value. 

16.In cell E11, enter the financial function to calculate the principal payment for the first payment period. The result should be a positive value.

17.In cell F11, subtract the principal payment in cell E11 from the beginning balance in cell C11. Copy the functions and formulas from the range D11:F11 to the range D12:F15.

18.Save the file making sure the worksheets are in the following order: Sales, Database, and Addition. Close Excel. Submit the file as directed.

• Attachment 1
• Attachment 2
• Attachment 3

Hille_exploring_e07_grader_a1_SalesQ v Search Sheeto+vHomeInsertPage LayoutFormulasDataReviewViewCalibri (Body)11A- A=M- Wrap TextGeneralInsertx DeleteAY.PasteBIU -ECEMerge & Center$%.00Conditional FormatCellSort &Formatting as TableStylesFormatFilterA1XVfx Input AreaDEFGHMNOPR1 Input AreaSummary Calculations2Facility Costs720,000Loan AmountDown Payment250,000No. Periods3604 # of Pmts per Year12Monthly Rate0.44%5 Years30Monthly Payment6 APR.25%Total Interest Paid1st Payment Date4/9/188Payment #Payment DateBeginningPrincipalBalanceInterest PaidPaymentEnding Balance23UISalesDatabaseAdditionReady- +100%

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

hiiii..this is kamal. actually can u please give me list of costing and budgeting formulas???

thanks

Formula ListRevenueVariable Costs or COGS= Contribution MarginFixed Costs= Gross MarginOperating ExpensesTaxes= NI or Profit Residual Income = net inc – (COC)(Tot Invest)Net RI = net inc…

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Hi，I working on a project that is wind fram. how to manage or make plan such as health and safety plans, traffic management plan, risk management plan, sustainability statement/plan and other similar information as you consider necessary.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Hi

I have come back again with another challenge.

Please read the file for each task and resolve it as desired.

Thanks

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"