RSS

Management Information Systems

Management Information Systems

Chapter 8 Assignment

                           

Review Questions – give examples to support your answers

 

  1. List and describe the five primary activities in a supply chain?
  2. Why are customer relationships important to an organization? Do you agree that every business needs to focus on customers to survive in the information age?
  3. How can a sales department use CRM to improve operations?
  4. “The fly in the ointment is that typically only 20 percent of a firm’s customers are actually profitable. And many – often most – of a company’s profitable customers are not loyal”. Do you agree or disagree with this statement? Why?

 

 
 

Tags:

Management Information Systems – LAB EXAM

Management Information Systems – LAB EXAM

FILE: MIS Lab Final Exam Online

 

THERE ARE INSTRUCTIONS FOR 5 WORKSHEETS/SECTIONS. YOU MUST COMPLETE 4 OF THEM. IF YOU CHOOSE TO COMPLETE ALL 5, THE LAST ONE WILL BE CONSIDERED FOR EXTRA CREDIT.

 

LOOKUP WORKSHEET:

  1. GRADES: In cell C4, use a nested IF function to determine the final grade for the first student based on the grading scheme presented in E5:F9. Write the formula so it can be copied to all students.
  2. COPY COSTS: In cell B17, use a LOOKUP function to determine the total costs of making copies based on the number of copies in A17 and the pricing table in E17:F22. Copy this formula down column B to cell B20.
  3. Format the worksheet for a professional appearance; then format page for printing – add name and worksheet name to the footer, fit to 1 page.

SALES MTG WORKSHEET:

  1. Write a formula in cell E3 that can be copied down the column to determine (TRUE or FALSE) if this item is within budget (an item is within budget if the actual amount is less than the budgeted amount).
  2. Write a formula in cell E10 to determine if at least one item is within budget. (Answer should evaluate to TRUE or FALSE.)
  3. Write a formula in cell E11 to determine if all of the items are within budget. (Answer should evaluate to TRUE or FALSE.)
  4. Set conditional formatting to the item names in column A so that the item name would be italicized and shaded in yellow if the item has a budget over $200.
  5. Write a formula in cell F3 that can be copied down the column to return the following:
    1. If this item has an actual cost of less than $100, then return the text “Low”.
    2. If this item has an actual cost between $100 and $200, return the text “Average”
    3. If this item has an actual cost of more than $200, return the text “High”.

 

  1. Write a formula in cell G3 that can be copied down the column to calculate the cost of this component for a larger sales meeting based on the following:
    1. If this item is required, as indicated in column B (required items are marked “R”; optional items are marked “N”), then the cost will be 2 times the original budgeted amount.
    2. If this item is not required/optional, as indicated in column B, then the cost will be equal to the original budgeted amount.

 

  1. Write a formula in cell H3 that can be copied down the column to determine whether or not there is “cause for concern” per item. Results should evaluate to TRUE or FALSE. There is cause for concern if all of the following conditions are met:
    • Item is not required;
    • Budgeted amount is greater than $50;
    • Actual amount is greater than the budgeted amount.

 

  1. Write a formula in cell I3 that can be copied down the column to determine whether or not there is “no concern” per item. Results should evaluate to TRUE or FALSE. There is no concern if any of the following conditions are met:
    • Item is required;
    • Budgeted amount is greater than $75;
    • Actual amount is less than the budgeted amount.

 

  1. Write a formula in cell C9 that can be copied to D9 that shows the totals for Budget and Actual amounts.
  2. Determine the number of required and not required/optional items and the total of actual costs for each.
    1. In cell E14, calculate the number of REQUIRED items.
    2. In cell E15, calculate the number of OPTIONAL items.
    3. In cell E16, calculate the sum of actual costs for REQUIRED items.
    4. In cell E17, calculate the sum of actual costs for OPTIONAL items.

 

  1. Format the worksheet for a professional appearance; then format page for printing – add name and worksheet name to the footer, fit to 1 page.

FINANCIAL OPTIONS WORKSHEET:

Using financial functions (RATE, PMT, FV, NPER, PV) complete the shaded cells to analyze 5 financial options for MIS, Inc. (HINT: Make sure your interest rate and number of payments are set to the correct terms)

SAM’S STUFF:

  1. Group worksheets for Quarters 1-4 and calculate revenue under each pricing scenario for each quarter.
  2. Group worksheets for Quarters 1-4 and calculate costs under each pricing scenario for each quarter. In cell C10, use the appropriate combination of mixed references so the formula can be copied across to column E and down to row 13.
  3. Group worksheets for Quarters 1-4 and calculate projected earnings under each pricing scenario for each quarter. Projected earnings is equal to revenue minus the subtotal of cost of goods sold.
  4. Using static consolidation, dynamic consolidation, or formulas, complete the summary sheet to show totals for the entire year. Calculate yearly totals for number of units sold (sales volume), total revenue, cost of goods sold and projected earnings.
  5. What pricing strategy seems to work best for Sam? Why? Type your answer at the bottom of your summary sheet.

 

BANK LOANS WORKSHEET:

  1. Create an Excel table in the BankLoans worksheet, and rename the table as LoanData.
  2. Format the Amount and Interest Rate fields so that it is clear that these fields contain dollars and percentages, respectively (no decimals).
  3. Make a copy of the BankLoans worksheet, and name the new sheet SORT. Sort the loan data in ascending order by type, within type by city, and within city by last name. Use conditional formatting to display all loans in Taos using a format of your choice to highlight these loans.
  4. Make another copy of the BankLoans worksheet, and name the new sheet FILTER. In the Filter worksheet, filter the LoanData table to display loans made during April and May 2016. Insert a TOTAL row and display the average amount of loans for the filtered data.
  5. Make another copy of the BankLoans worksheet, and name the new sheet SUBTOTALS. Sort the loans in ascending order by city, then by type of loan, and then by amount of loan (largest loan first). Convert table to a range of data. Insert Subtotals (Average) for the loan amount by city.
  6. Using the LoanData table, create a PivotTable that displays the number (Count) and average loan amount by type and city. Place the PivotTable in a new worksheet (named Pivot1). Format the loan amount field to be Currency format, no decimals. Name the CountofAmount field as Number of Loans and name the AverageofAmount field as Average Amount.
  7. Using the LoanData table, create a PivotTable that displays the number (Count) and total loan amount categorized by type. Place the PivotTable in a new worksheet (named Pivot2). Format the loan amount field to be Currency format, no decimals. Add Loan Date to the pivot table. Rename CountofAmount field as Number of Loans, and rename SumofAmount as Total Amount. You can format your pivot table to improve its appearance.

 

Submit completed file for grading

 

 
 

Tags:

Human Services

Examine the various personnale practices and policies of the American Red Cross organization (e.g. the strategic planning, training, diversity management, recruitment, performance management, job analysis compensation, benefits, etc.,). Are their policies and practices up-to-date, relevant to the organization, and enforced consistently and fairly? Should any policy be changed? Improved upon or be eliminated? Why? How? Only 2 pages long must have references and written at graduate level. All questions must be answered, each question and topic should be in bold so we can know whats being discussed. Please look for sources in the book Pynes J.E. 2013 . Human resources management for public and non profit organizations.

 
Leave a comment

Posted by on July 23, 2018 in academic writing

 

Tags:

State Practice Agreements

State Practice Agreements

Assignment 2:

In many states, nurse practitioners are completely autonomous professionals. In other States, however, NPs have a wide range of “restrictive” practice ranging from requirements for a “supervising” physician to requirements for a “collaborative” agreement with a physician.

In this Practicum Journal Assignment, you will examine the requirements of your own state in order to prepare yourself for the realities of practice upon graduation.

To Prepare for this Practicum Journal:

  • Review practice agreements in Texas State.
  • Identify at least two physician collaboration issues in Texas State.

For this Practicum Journal:

  • Briefly describe the practice agreements for PMHNPs in Texas State.
  • Explain the two physician collaboration issues that you identified.
  • Explain what you think are the barriers to PMHNPs practicing independently in Texas State.
  • Outline a plan for how you might address PMHNP practice issues in Texas State

 

 
 

Tags:

Scientific Method Research Paper

Explore how the development of the scientific method impacts our worldview.

Instructions

Identify a current problem in physics by searching for news articles and current events. One reputable source of news in physics is Phys.org.

Choose one article, and in two pages, describe how the scientific method is being used to solve the problem mentioned in the article.

Identify the initial observations that identified the problem, the hypothesis, tests, and any revisions of the original hypothesis.

Cite the article in APA format as well as other references you might use.

 
Leave a comment

Posted by on July 23, 2018 in academic writing

 

Tags:

Credentialing Providers

Provide an executive summary to your team on how to credential providers. You will need to consider the following:

  • Type of provider being credentialed
  • Steps they will go thru to be credentialed
  • Educational background needed
  • Does this provider have an NPI number?
  • State the provider will work in
  • Is there a standard application?
  • Is an onsite visit needed; why or why not
  • Who gets credentialed (list at least 5 specialties)
  • Are all facilities credentialed?

Gather your research from at least 2 sources

 
Leave a comment

Posted by on July 23, 2018 in academic writing

 

Tags: ,

Module 3 – SLP

Module 3 – SLP

Optimizing Inventory/Transportation

SLP 3 – Transportation in the Supply Chain

In this SLP you will identify where the major transportation modes are used in the EESC from SLP3: rail, inland water, ocean steamer, and/or OTR.

There are five basic transportation modes: rail, inland water ways, ocean, over-the-road, and air. We will not be concerned about air transport in this SLP as it is the least used and most expensive in general supply chain transportation.

Review and read these resources on these three transportation modes: rail, inland water, and OTR. Ocean is not included in these readings since it is mainly used for importing and exporting. This will be covered in more detail in LOG502. But you are asked to identify where ocean transport is used, but not in detail.

RESOURCES – SEE SLP 3 RESOURCES IN BACKGROUND PAGE

Session Long Project

Review the EESC from SLP2. Identify in the EESC where each of the four modes of transportation are used: rail, inland water, ocean, and OTR. You can use topic headings for each mode. Identify the materials being transported from which industry to which industry. Discuss why this mode is being used and what the costs are on a per ton-mile basis.

SLP Assignment Expectations

The paper should include:

  • Background: Briefly review and discuss the targeted product, company, and industry
  • Diagram: Include the diagram of the EESC
  • Transportation Discussion: Discuss each of the four transportation modes (rail, inland water, ocean, OTR) in the EESC and where each one is used. Discuss why this mode is used and the costs of using.
  • Clarity and Organization: The paper should be well organized and clearly discuss the various topics and issues in depth and breadth.
  • Use of references and citations: at least six (6) proper references should be used correctly, cited in the text, and listed in the references using proper APA format.
  • Length: The paper should be three to four pages – the body of the paper excluding title page and references page.

NOTE: You can use the transportation resources. You should also do independent research and find at least two additional appropriate references, for a total of at least six.

 

 
 

Tags: