excel-project-data-analysis-class

/in /by

Northwind Traders sells international specialty food items to buyers from around the world. Management is currently realizing that issues such as rising shipping costs due to gas prices as well as competition are cutting into the company’s profit margins. In an effort to reduce cost and increase profits, they have hired you to perform an analysis of their sales data. They have provided you with a set of data from their sales database that includes sales data that spans three years. This data set includes the following information for each order:

 

  • product category
  • last name and first name of the salesperson
  • country from which the order originated
  • order date
  • product ordered
  • quantity of product ordered
  • product name
  • unit price for the product
  • any discount given to the customer off the item price

 

Northwind Traders has a company looking at their overall costs to see where reductions can be made, but at the same time, they wish to see if there are any trends in their sales that might enable them to increase their sales revenue. Based on only the data that you have been provided, you must analyze the data, draw conclusions, and present them in a recommendation report. Use Excel data, charts, and tables to justify these recommendations.

 

Organize the Data

Back to Top

 

Often in the real world, data used for analysis comes from external sources. In the case you will be looking at this week, you will first need to import data extracted from a database into Excel. Recall that in Week 4, we looked at importing data. The first step is to understand the format of the data. Because our data has been provided in a .csv file, we can open the file in Notepad, and review it to determine whether it is in fixed format or delimited format. You can use the Excel Import Wizard (Data tab, Get External Data Group, From text command), you will want to ensure that you select the correct delimiter and then set appropriate data types for each of the items you have imported. It may be beneficial to go back to the Week 4 iLab and review the lab videos and instructions. However, with the 2010 version of Excel, the import is automatic. You can simply open the SalesData.csv file and save it as an Excel file with an .xlsx extension.

 

Once the data is in Excel, you will provide professional formatting following the formatting guidelines we studied during the first week of class. Are there any formatting features that will make this list more readable? What types of documentation might you provide to make the data set easier to follow? You will want to add a documentation sheet to the workbook to explain the author, purpose, and date and provide information about each of the sheets you will create as you analyze the data. Because we are looking at overall sales data, you will also want to review the data to see if there are any calculations that you need to provide that will give more information about sales in general. For example, how will you calculate the total revenue from each sale made?

 

Analyze the Data

 

You have a tool set of ways to analyze the data at this point in the course. Your goal is to experiment with tools to see what trends might become obvious as you begin working with the data. Remember that you can copy the data to new worksheets as you explore its meaning and begin to draw conclusions. The following are some strategies you might use:

 

  • Sort the data. Remember that you can sort using multiple sort levels. Try sorting by date and then by product. What price increases have there been over time? How have these price increases impacted sales? Sort by product and discount level. Have discounts increased the sales of a product? Is there any discount level that appears to be more effective?
  • Graph sales over time to see trends. Are there any peaks and lows in sales? Is there any time of year during which sales are highest or lowest?
  • Pivot the data to see total sales by quarter, country, category, and salesperson. Are there any highs? Are there any lows that need to be addressed?
  • Subtotal the data. How are the quarterly sales’ totals? How are the sales by salesperson?

 

Challenge Option
If you are feeling adventurous, you may want to try to perform a what-if analysis. For example, what if prices were raised by a certain percentage with a slight decline in sales? What combination of price increases and decline in sales makes the most sense? Regardless of which type of analysis you decide to take, you are required to provide three different analyses.

 

Draw Conclusions

 

Your data-analysis activities will lead you to draw conclusions about sales highs and lows. Once you have determined items that are impacting sales, can you suggest solutions? For example, suppose you determine that the lowest sales are in Japan. Would you recommend that marketing in Japan be increased or that discounts for Japanese customers be increased? Are there any products you would suggest be discontinued based on lack of sales, or products that might be added to the mix due to high sales in that particular category? These are just some recommendations to get you started. Remember that you have been contracted by Northwind Traders to provide recommendations for changes that you believe will impact sales and increase the overall performance of the company. These recommendations should grow out of the conclusions you draw as you perform your data analysis. Let the results of your analysis draw the conclusions. Don’t make guesses; you need to have data to support your recommendations in your Memo.

 

Present the Evidence

The last step in the Excel project is to present your findings in a Memo. Use the integration techniques we worked on in the course to develop a recommendation Memo (Word document) that includes data and graphs copied and pasted from your spreadsheet. Use the Word template in Doc Sharing under the Course Project Materials as a starting point. Make sure to include an explanation in your Memo that shows your approach and outcome for each method of analysis you completed. Also, you will need to turn in both your recommendation Memo and your spreadsheet to the Drop Box. Remember that the Memo is just as important–if not more–as the analysis.

 

“. WITH nursingessayswriters.com TODAY AND GET AN AMAZING DISCOUNT”

The post excel-project-data-analysis-class appeared first on nursingessayswriters.com.

 

“Are you looking for this answer? We can Help click Order Now”

response week 11

/in /by

Hi, I have 2 of my classmate posts. I need you to respond to each one separately. , one source at least for each one of them.

about
how good their posts or how bad.

need
to do is to choose one point of the post and explore it a little bit with one source support for each response. The paper should be APA style


the
question was:

Develop a hospital emergency management committee. How is it structured?

What

is their
purpose and responsibilities?

Who should be on your EMC and why?

this
is the first post from my

calssmate
 FUNYEISS NEED TO RESSPONSE

:

The Emergency Security Committee belongs to a group of people involved in

development
of processes, policies and procedures, conserving the necessary resources and providing personnel training to ensure faster speed, cooperation and an effective response to disaster relief in the hospital. Emergency management committees focus on six strategic planning issues, including communication, services and equipment, work, patient, medical services and support, and safety and protection. These six areas are considered as the basis for responding to natural disasters or catastrophes. This article reflects the development of the Hospital Emergency Committee in analyzing the structure and responsibilities of the committees. It also emphasizes people who will be on the Hospital Management Committee.

(
Canton, 2019)

The Emergency Management Committee is a provincial committee composed of representatives from ten different provincial hospitals. The committee’s goal is to protect the community by integrating and integrating activities necessary for

development
, care and skills development for training, responding, reducing and losing natural disasters, terrorist acts and other human disasters. A committee will have a director general who will be the head of each committee, and committee members will report on this matter. From the Director General, the next level will be the management response team, then the task force, and finally the tactical group.

The CEO will be the general coordinator and head of the disaster or response and recovery. The whole committee will report to the director and is expected to make a high decision on the issues concerning the committee. It is expected that the Director-General will actively promote the universal observance of the needs of all members of the committee. The administrator will be the face of the community center.

A tactical team is a team that responds to emergencies. This group will use the strategies of the strategic response team and will be directed to the application.

The operations team will be responsible for the services that have been allocated for budget execution. The team will also coordinate the allocation of resources. The team will also be responsible for tying the tactical team when working in the field.

The next level team, which is the Strategic Response Team, will be responsible for organizing the strategies used in the field. The construction process will be used for the tactical squad in the field. In addition to developing strategies, the Strategic Response Team provides guidance and helps lower-level committee members what they should do and how to perform actions. The core response team will monitor the actions of the members of the subcommittee and provide support for the questions asked by the lower level members.

Responsibilities of the committee typically include analyzing all the risks that expose the hospital to its potential intervention, to help develop emergency repair and emergency response systems, act as emergency response teams, and review existing emergency management plans in an attempt to improve the situation. The committee needs to take certain step to ensure that they work fine and according to the needs.

Canton, L. G. (2019). Emergency management: Concepts, strategies for effective programs. Wiley.

This is the second post

from
 IBRAHIM need

to
response

:

In a hospital, the Emergency Management Committee is a group gathering medical staff from different disciplines with the aim of preparing the hospital to properly handle disasters or any other emergency cases. In concrete terms, the Emergency Management Committee is in charge of developing the processes, policies, and procedures which will guide the reaction of the entire medical facility during emergency cases (Leider et al., 2017). The main purpose of the Emergency Management Committee is making sure that the hospital is ready at all levels to face any type of foreseeable emergencies. Thus, the most important part of the committee’s actions takes place upstream, before the emergency situations. The committee is in charge of the integration of all the aspects of the emergency plan. This suggests that they conduct frequent exercises aimed at assessing the ability of the medical staff to properly react to emergencies (Leider et al., 2017). Such exercises are always followed by a report stating the current organizational performances along with the opportunities for improvement. The Emergency Management Committee concentrates its efforts on six strategic fields for more efficient actions during emergencies. These fields are communications, resources and assets, safety and security, staff responsibility, utilities, and patient clinical and support activities (Fountain, 2016).

The Emergency Management Committee is made of members of several departments of the hospital. The designated members must be the key administrators of the selected departments. This will ensure that the right decisions are taken at the right time, without delays due to hierarchical organization. First of all, the committee should include a member of the hospital security. In fact, emergency situations involve important risks of additional injuries, thefts, and other negative consequences because of the prevailing state of panic. Hospital security will help take the appropriate measures to avoid worsening the situation (Leider et al., 2017). Facilities Services represent another department whose contribution within the committee is essential (Leider et al., 2017). In fact, emergency situations suggest that the hospital accommodates more patients than before. Thus, the need for available facilities will be more important than ever before. The member of the facilities service will make sure that the available installations are properly used without delays, and that critical cases are prioritized. The human resources department has to be included in the committee (Fountain, 2016). With guaranteed security and several available installations, the committee has to ensure that the admitted patients will be properly treated. The need of available specialists will be important during a crisis. Thus, the human resources department has to make sure that all available doctors are mobilized and available. In addition, the human department resources will assess the need for additional resources during the preparatory stage of the plan (Fountain, 2016). The next department to integrate to the committee is the information technology service. During disasters, communications are limited because most of the local infrastructures are damaged. However, the medical staff needs to communicate and even access online medical data. At this stage, the information technology service has to develop a plan aimed at creating backup networks and infrastructures in order to properly assist the medical staff. In addition, the department of sciences and analyses which is generally represented by the laboratory plays a key role in the committee (Fountain, 2016). Usually, in the medical setting, analyses require important deadlines that some medical facilities cannot afford during disasters. Thus the laboratory has to establish the appropriate protocols in order to deliver timely analyses. Other departments such as the financial service, the risk management department, and the safety department are also members of the committee (Leider et al., 2017). Generally, the chairman of the emergency management committee is the General Manager (GM) of the hospital. However, under some circumstances, the most experienced specialist can be appointed to this position.

References

Fountain, R. (2016). Mass care and the University of British Columbia: A new approach to disaster response. Journal of Business Continuity & Emergency Planning, 9(4), 329–337. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&db=bth&AN=116748962&site=ehost-live

Leider, J. P., DeBruin, D., Reynolds, N., Koch, A., & Seaberg, J. (2017). Ethical Guidance for Disaster Response, Specifically Around Crisis Standards of Care: A Systematic Review. American Journal of Public Health, 107(9), e1–e9.https://doi.org/10.2105/AJPH.2017.303882

 

ORDER THIS PAPER OR A SIMILAR ORDER WITH TERM PAPER TUTORS AND GET AN AMAZING DISCOUNT

The post response week 11 first appeared on Term Paper Tutors.

 

“Are you looking for this answer? We can Help click Order Now”

Can this be done by 12pm tomorrow?wk116100

/in /by

Discussion: Data Analysis and Dissemination

“I don’t know.” Not knowing something is difficult for many people to admit for a variety of reasons: they don’t want to look unknowledgeable, they want to impress someone, or they are afraid of the truth. However, admitting what you do not know is a critical component of being a reflective practitioner. If you only focus on the things you know, you will stagnate. You will never explore new ideas, read innovative research, or improve your practice. In other words, you can never become stronger unless you focus on recognizing and developing your weaknesses.

In this Discussion, you complete a self-reflection regarding areas in program evaluation about which you feel confident and those in which you are not as confident. You will explain how you will use these weaker areas as catalysts for professional development and what resources you need to complete the task. To Prepare

This week’s Learning Resources outline techniques that may be used for data analysis and outcome dissemination in program evaluation. You are asked to complete a self-reflection this week regarding areas in these two steps of program evaluation about which you feel confident and those in which you feel you need more professional development.

Post a description of at least two areas related to data analysis and outcome dissemination about which you would like to further professionally develop beyond the course. Explain how you will use these interests or challenge areas as catalysts for professional development and how you will grow your knowledge in these areas, or what resources you might use to complete tasks cooperatively as an evaluation team.

 

“Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code “Newclient”

The post Can this be done by 12pm tomorrow?wk116100 appeared first on Psychology Homework.

 

“Are you looking for this answer? We can Help click Order Now”

LEG-505

/in /by

Assignment 3: Draft Compliance Matrix and Compliant Proposal to RFP

Due Week 6 and worth 200 points

Note: The assignments are a series of papers that build upon one another.

Refer to the following resources to complete this assignment:

  • FAR § 15.2 (Solicitation and Receipt of Proposals and Information)

(https://www.acquisition.gov/far/current/html/Subpart%2015_2.html)

As the Contract Officer (CO) of your newly formed company, you will create a compliance matrix, and then draft a proposal in response to the RFP from Assignment 2.

Write a five to seven (5-7) page Compliance Matrix and Compliant Proposal to your RFP paper in which you:

  1. Create a compliance matrix and prepare a FAR-compliant proposal in response to the RFP from Assignment 2. Note: You may create and /or assume all necessary assumptions needed for the completion of this assignment.
  2. Apply the appropriate FAR clauses in order to meet compliance in contract formulation and award.
  3. Apply the knowledge gained from your analysis of Government Accountability Office reports / decisions to identify and account for FAR compliance issues and contributing factors.
  4. Apply the knowledge of planned actions in soliciting and awarding contracts and make recommendations to ensure the government agency is in compliance with the FAR requirements.

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

  • Identify and apply the appropriate Federal Acquisition Regulation (FAR) clauses to meet compliance in contract formulation and award.
  • Analyze Government Accountability Office reports / decisions to identify FAR compliance issues and contributing factors.
  • Analyze the planned actions in soliciting and awarding contracts and make recommendations to ensure the government agency is in compliance with the FAR requirements.
  • Given a contract disputes situation, evaluate the various options and select the appropriate administrative and judicial processes available to resolve the dispute.
  • Use technology and information resources to research issues in government contract law. 
  • Write clearly and concisely about government contract law using proper writing mechanics.

Click here to view the grading rubric for this assignment.

 

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

The post LEG-505 appeared first on Nursing Assignment.

 

“Are you looking for this answer? We can Help click Order Now”