Excel Assigment 3 steps missing only
User Generated
Nmmv
Business Finance
Description
Hi I have excel assignment, and I want to complete 3 more steps on the assignment using functions, I already done most of this.
if you are good in this please let me know.. see the attached file below.
KSA_EBTM337_Sp11_Assignment_V4.docx
I need this within 4 hours maximum.
Thanks,,,
Unformatted Attachment Preview
West Textile---Personnel
Name
Bill Jones
Bob Marshall
Don Smith
Fred Johnson
Jack Parsons
Jim Evans
Linda Flores
Lisa Fuller
Marsha Grayson
Rick Fisher
Shelly Hanson
Phone
Floor Office Dept. Years Exp.
5116
4 3 MKT
5859
3 14 MKT
5871
2 21 ADM
5886
4 17 ADM
5860
2 12 MKT
5876
2 11 ADM
5853
4 16 R&D
5860
3 14 R&D
5872
3 16 R&D
5324
2 18 MKT
5551
2 13 R&D
Name
Salary
>=$40,000
9
9
2
4
8
5
4
5
8
10
5
Regression
Name
Bill Jones
Jack Parsons
Marsha Grayson
Rick Fisher
Salary
45,000.00
40,000.00
42,000.00
42,000.00
1953.333333
Salary
45,000.00
29,000.00
25,000.00
33,000.00
40,000.00
32,000.00
31,000.00
28,000.00
42,000.00
42,000.00
30,000.00
Analysis
Major Skill Using MS-Excel to assist in decision-making
Specific
1. Creating an Excel file from a formatted text file
Skills
2. Using Excel's Data filtering capabilities for extracting relevant data
3. Using Excel's Graphing capabilities to create informative charts
4. Using Excel's mathematical capabilities (specifically logical functions and
array functions)
5. Apply regression techniques to data
1. Download the file skills2.txt to your PC from your Assignment/Assignment2 folder on Blackboard.
2. Import this file into Microsoft Excel. Use the appropriate columns to convert this tab-delimited
formatted text file into a Microsoft Excel file.
3. Change the format of the title "West Textile - Personnel" to the format (Red, Arial 14 Font in
merged cells) to resemble the form of Figure 1 below.
4. Use the Data - Filter - Advanced Filter menu commands to extract all people whose salaries
are equal or above $40,000. The data range, criteria range and output range are visible in the
spreadsheet.
5. Perform a regression of salary against number of years of experience. Use the Linest function so
create regression coefficients. Use the regression coefficients as shown and enter formulas to
calculate the predicted salary in column H. (Hint: For help with Linest function refer to this youtube
video, http://www.youtube.com/watch?v=WAXv9y1wIL4 or you can, of course, Google ‘linest
function’).
6. Create a chart which graphs the actual salary and predicted salary against the number of years of
experience. The X-Y graph that you will create is shown below in Figure 2. Please format the data
series appropriately, change the fonts and colors as required.
7. Provide a last column titled Status (Column I) after the predicted Salary column. In this column
you will enter an IF function which evaluates to "Manager" if the person is on Floor 4, or evaluates
to "Executive" otherwise.
8. Create borders of appropriate thickness for the entire spreadsheet as shown in Figure 1 below.
9. Save the file using your first initial and last name. For example, John Doe would save the file as
jdoe.xlw or jdoe.xls or jdoe.xlsx
10. Follow your instructor’s instructions on how to submit your assignment.
11. The printed form of your spreadsheet should appear exactly as follows (except replace ‘John Doe’
with your name):
Figure 1. Output Sample
12. Your graph should appear exactly as follows (except replace ‘John Doe’ with your name):
Figure 2. Graph of Salaries versus Number of Years of Experiences
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
This question has not been answered.
Create a free account to get help with this and any other question!
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
University of Phoenix Wk 5 Cognitive and Affective Perspective Taking Discussion
Write a 250- to 300-word response to the following: Healy and Grossman (2018) discuss cognitive and affective perspective- ...
University of Phoenix Wk 5 Cognitive and Affective Perspective Taking Discussion
Write a 250- to 300-word response to the following: Healy and Grossman (2018) discuss cognitive and affective perspective-taking. Read Cognitive and Affective Perspective-Taking: Evidence for Shared and Dissociable Anatomical Substrates from the University Library.Describe the differences between cognitive and affective perspective-taking and how the knowledge of perspective-taking might assist in an interview process for a research study.
PJM 440 CSU Total Quality MGT and Office of Personnel MGT on Federal Plan Portfolio
Total quality management and the Office of Personnel Management (OPM) on Federal RetirementsThe Government Accounting Offi ...
PJM 440 CSU Total Quality MGT and Office of Personnel MGT on Federal Plan Portfolio
Total quality management and the Office of Personnel Management (OPM) on Federal RetirementsThe Government Accounting Office (GAO), Office of Personnel Management (OPM) in May of 2019 published the Federal Retirement: OPM Actions Needed to Improve Application Processing Times. OPM has a goal of processing most retirement application in 60 days, but for several years has not met that standard. The GAO OPM for that reason, studied the process for federal retirement processing to determine root causes of delays, and to determine what strategies should be employed to remedy the situation. The results of that study are available at the following website: https://www.gao.gov/assets/700/699120.pdf (Links to an external site.)While the document provides root cause analysis and recommends six opportunities for improvements, it offers no quality management plan. You have been contracted to develop a quality management plan, and you will report to the Comptroller General of the United States, the director of the Government Accountability Office. The GAO is a legislative branch agency established by Congress in 1921 to ensure the fiscal and managerial accountability of the federal government. If your quality management plan is acceptable, the Comptroller General of the United States will support your company for project managing the implementation of funded improvements. This could be a long and lucrative contract for your company.Note: While the document at the core of this assignment is an actual document published by The Government Accounting Office, the quality management scenario described is fictional and only for the educational purpose of showing mastery of the course objectives set forth for this course.In Module 3, you were asked as a first step, to familiarize yourself with the Federal Retirement: OPM Actions Needed to Improve Application Processing Times document, hereafter called the GAO report. After your review of the guidelines, you were asked to provide your input to the following:Is the current Federal Retirement: OPM Actions Needed to Improve Application Processing Times document one that promotes high quality? If yes, how? If no, why not and what should change to promote quality? Support your position with specific references to the GAO report or current scholarly documentation.What do you interpret to be meant by "quality" from the perspective of the GAO OPM, retirees, Congressional leaders, and the public both now and in the future? What support do you have for your position with current (published in the past five years) scholarly documentation?What are the drivers for change, and the barriers to change from the perspective of the GAO OPM, retirees, Congressional leaders, and the public? Are there competing drivers for change that may impact quality from the public's perspective? Support your position with specific references to the GAO report or current scholarly documentation.In Module 8, you are asked to build upon your work from Module 3 and show additional mastery through other course modules.Provide the following quality management plan in your final portfolio:Provide an opening paragraph which describes the importance of the using this case to show your mastery of course objectives, and mapping of what is contained in your paper to prove that mastery.Delineate your next section with a header, and in less than one page, describe the current situation with federal retirement processing, the recommendations from the GAO study, and the role of the GAO OPM in promoting quality.Delineate your next section using headers and sub-headers with your work from Module 3. Include any updates that you wish to make as a result of learning more about quality management, and input from your instructor in Module 3 for the following: Is the current Federal Retirement: OPM Actions Needed to Improve Application Processing Times document one that promotes high quality? If yes, how? If no, why not and what should change to promote quality? Support your position with specific references to the GAO report or current scholarly documentation.What do you interpret to be meant by "quality" from the perspective of the GAO OPM, retirees, Congressional leaders, and the public both now and in the future? What support do you have for your position with specific references to scholarly (peer-reviewed) resources?What are the drivers for change, and the barriers to change from the perspective of the GAO OPM, retirees, Congressional leaders, and the public? Are there competing drivers for change that may impact quality from the public's perspective? Support your position with specific references to the GAO report or current scholarly documentation.Delineate your next section with a header to discuss the operational issues that must be managed and controlled to support quality including partnering and strategic alliances if any are pertinent. How will those issues be managed and controlled in your plan? As usual, what support do you have for your position with specific references to the GAO report or current scholarly documentation?Delineate your next section with a header to discuss the human resource issues that must be managed and controlled to support quality including employee empowerment, teamwork, education and training. How will those issues be managed and controlled in your plan? As usual, what support do you have for your position with specific references to the GAO report or current scholarly documentation?Delineate your next section with a header to discuss customer satisfaction and how it will be measured. How will and when will measurement happen in your plan? As usual, what support do you have for your position with specific references to the GAO report or current scholarly documentation?Delineate your next section with a header to discuss how problems will be solved, conflicts resolved, and how decisions will be made especially any interagency issues, or legislative issues that may arise. As usual, what support do you have for your position with specific references to the GAO report or current scholarly documentation?Delineate your next section with a header to discuss what quality tools should be used, when and how, including communications tools, process control tools, benchmarking, or other tools as you find appropriate. What support do you have for your position with specific references to the GAO report or current scholarly documentation?Finally, conclude with the final section making a recommendation to the Comptroller General of the United States for your plans, and why your company is in the best position to lead the quality management effort going forward through implementation.Submission:Write a paper addressing the case of federal employee retirement processing regarding the GAO OPM report and quality management. Your paper should be 8-10 pages in length, not including the required title and references pages and any appendix if required. For more information see "How do I do an Appendix in APA style?" (Links to an external site.)Support the paper with a minimum of six current (published in the most recent five years) scholarly sources from the CSU Global Library. This is in addition to any course textbooks, lecture material you decide to use, or the case itself. Of course, you may always exceed the minimum number of sources.Format the paper according to the CSU Global Writing Center (Links to an external site.).Be clear, concise, and focused.Tip: Cases may be addressed in 6 steps:Read the assignment and questions provided to get an idea of the important course concepts to be covered. There is plenty of material in a case that may be immaterial to the course learning objectives. (For example, a case may have significant information on staff acknowledgements, but the assignment questions relate to quality management. In that case, do not spend time on those acknowledgements unless relevant to quality management. Use your time searching the case, researching and reporting on quality management.)Read and take notes on the entire case. Read every figure and table to thoroughly understand them.Determine who are the key players; what are the key issues; what is the problem to be solved?Do the research and analyze any data. Use the CSU Global library to research the key issues and problems. Find current academic information on those topics.Make your decisions relative to the important course concepts, and document the defense of your position by melding the scholarly research and examples from the case. Remember, no opinions; only facts.Finalize your portfolio by checking all assignment questions are fully answered, rubric items are met, and the document follows CSU Global Guide to Writing and APA requirements.
4 pages
Aviation Industry
The airline or aviation industry is evolving to handle the ever-increasing demand for passenger travel. As the air transpo ...
Aviation Industry
The airline or aviation industry is evolving to handle the ever-increasing demand for passenger travel. As the air transport industry is making ...
BUS 622 Ashford University Walmart International Business Model Discussion
Walmart Case Study[WLO: 3] [CLOs: 2, 3, 5]Prior to this assignment, review Chapter 12: Global Marketing Channels and Physi ...
BUS 622 Ashford University Walmart International Business Model Discussion
Walmart Case Study[WLO: 3] [CLOs: 2, 3, 5]Prior to this assignment, review Chapter 12: Global Marketing Channels and Physical Distribution and analyze Case 12-2: Can Walmart Crack the Retail Code in India? carefully. Review the Intro and Company Profile sections in the Walmart Case Study (Links to an external site.) interactive.Your assignment has two parts. Part A will be based on a case in Chapter 12, and Part B will be built upon your Final Paper about Walmart from your BUS621: Leadership and Teamwork course. In fact, the purpose is for you to analyzed Walmart from different angles: leadership style, marketing strategies and tactics, HR, Financial aspects, etc. so by the end of your MBA program you have completed Walmart’s big-picture puzzle.IntroductionWalmart today is a global retail giant. According to Carbonara (2018) in the recommended resource Walmart, Amazon Top World’s Largest Retail Companies (Links to an external site.) article, Walmart is the world’s largest retail company with continued plans for global growth. There are many competitors, one of which is Amazon. How will Walmart continue to be a global giant in the years to come? To maintain the market leader position Walmart will be required to continually look for ways to outgrow its global competitors (Carbonara, 2018).To understand Walmart and where it is today and what tomorrow holds, it is important to understand the company’s foundation. “Sam Walton opened his first five-and-dime in 1950. His vision was to keep prices as low as possible” (Wilbert, 2018, para. 1). Walton opened the first Walmart in the early 1960s in Rogers, AR (Wilbert, 2018, para. 2). One thing that has and will always remain a key component for all Walmart stores is to keep expenses low. There has always been a mentality behind the vision of Walton to demand that employees always keep costs to a bare minimum (Wilbert, 2018, para. 3). On average, “Walmart saves a typical American family of four about $2500 a year. That’s about what a family of four gets from the government in food stamps. That makes Walmart a major antipoverty force in the United States” (Kestenbaum, 2017, para. 3). Another factor to consider when thinking about Walmart is that “since 1990, the global rate of poverty has been cut by two-thirds. That’s the sharpest decline in human poverty in all of history, more than one billion people have been lifted out of poverty during that period and Walmart is a major force in that effect” (Kestenbaum, 2017, para. 3).Today, Walmart has grown considerably and continues to expand. Just to get an idea of how large this retail giant is, consider the following:Walmart employs 1.6 million people.Walmart has 6,200 retail outlets. In contrast, Home Depot has 2,040. (Wilbert, 2018, para. 4)One might question, “What does Walmart do to continue to be successful and keep costs to a minimum?” There are several things that this retail giant has incorporated into the operations. First, “Walmart became the first major retailer to demand manufacturers use radio frequency identification technology (RFID). The technology uses radio frequencies to transmit data stored on small tags attached to pallets or individual products. As explained in the recommended resource How Wal-Mart Works (Links to an external site.), RFID tags hold significantly more data than bar codes” (Wilbert, 2018, para. 6). For information on how RFIDs and radio waves work, you may like to review the articles How RFID Works (Links to an external site.) and How Radio Works (Links to an external site.). You may also be interested in reviewing the Is Walmart Good or Bad for America? The Question May Be Outdated (Links to an external site.) article which explains another interesting fact, which is that “Walmart is the single most important pipeline distributing wealth from rich countries to poor countries” (Kestenbaum, 2017, para. 3).One concern pertaining to Walmart is how employees are treated. It is well known that Walmart not only pays low wages, but their practices have impacted how their suppliers manage production costs while sacrificing the safety of their labor force (Kestenbaum, 2017). Walmart tends to hire mostly part-time workers (Kestenbaum, 2017). Some may even say that Walmart “pays their workers poverty wages” (Kestenbaum, 2017, para. 4). There have long been ethical concerns about how Walmart operates and manages its employees.Case Study AssignmentThroughout your MBA program you will cover various subjects as they relate to business. You will initially have an opportunity in BUS621 Leadership and Teamwork to create and build your own Walmart in a new global location. Your choices for location include Peru, New Zealand, Philippines, Egypt, Czech Republic, and United Arab Emirates. As you progress through each course in the program you will build upon your case study of Walmart.The purpose of this Walmart Case Study is to give you an opportunity to apply the subject matter from each course in the MBA program to an ongoing strategic development. The knowledge gained from the case study in each course will be cumulative. The knowledge will assist you in demonstrating your ability to conduct critical analysis and decision making across a wide range of subjects throughout the MBA program.MethodologyThe case study is based upon past and current information about Walmart and the country of destination. You will select a country to develop your case and will use the same country in each course of the MBA program.You will be responsible for gathering as much information as needed that will help you with determining the course of action that Walmart should pursue in the company’s quest to growth and to meeting the needs of international markets.Part A: Read Case 12.1: Can Walmart Crack the Retail Code in India? and answer the following questions:Summarize some of the elements in India’s political, economic, and cultural environments that can impact the market opportunity.Explain some of the obstacles facing Walmart and other foreign retailers in India.Review Figure 12-4 (Global Marketing). Explain which quadrant of the matrix applies most directly to India. Provide your rationale.Part B: In your BUS621: Leadership and Teamwork course, you selected a country for Walmart to expand to, and you also analyzed the nine dimensions of the culture and the leadership models and skills that would apply to your selected country. In this assignment, you will work and build on your previous Walmart work, and develop some place strategies as Walmart expands on its global marketing activities to the country of your choice. Address the following points for the selected country:Summarize some of the elements in your selected country’s political, economic, and cultural environments that can impact the market opportunity for Walmart expansion.Based on your environmental review and referring to Figure 12-4, discuss what market expansion strategy you would suggest for Walmart in your selected country.You learned that channels create utility for customers (place utility, form utility, time utility, and information utility) that can be leverages as a source of competitive advantage. Analyze each of these utilities that Walmart may be creating in the country of your choice, and explain which one can potentially work as a competitive advantage for Walmart considering its target market and their needs, wants, and preferences in your selected country.Considering the growth of global online retailers like Amazon.com, Aliexpress.com, Target.com, and eBay.com as competitors of Walmart.com, and based on the factors you evaluated in Part A, formulate a SWOT analysis for Walmart.com in your selected country.The Walmart Case Study paperMust be three to five double-spaced pages in length (not including title and references pages and formatted according to APA style as outlined in the Ashford Writing Center’s APA Style (Links to an external site.) resource.Must include a separate title page with the following:Title of paperStudent’s nameCourse name and numberInstructor’s nameDate submittedFor further assistance with the formatting and the title page, refer to APA Formatting for Word 2013 (Links to an external site.).Must use at least two scholarly sources for each environment topic in addition to the course text.The Scholarly, Peer-Reviewed, and Other Credible Sources (Links to an external site.) table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.Must document any information used from sources in APA style as outlined in the Ashford Writing Center’s Citing Within Your Paper (Links to an external site.) guide.Must include a separate references page that is formatted according to APA style as outlined in the Ashford Writing Center. See the Formatting Your References List (Links to an external site.) resource in the Ashford Writing Center for specifications.Carefully review the Grading Rubric (Links to an external site.) for the criteria that will be used to evaluate your assignment.
CPMGT 303 University of Phoenix JP Phentar Construction Case Study Analysis
Assignment ContentReview the JP Phentar Construction: Case Study in Ch. 11 of A Comprehensive Guide to Project Management ...
CPMGT 303 University of Phoenix JP Phentar Construction Case Study Analysis
Assignment ContentReview the JP Phentar Construction: Case Study in Ch. 11 of A Comprehensive Guide to Project Management Schedule and Cost Control.Complete the following:Determine which information-gathering tools would be most effective for this project and what activities would need to be monitored.Based on data that would be generated from work activities, what types of analytical tools could be used to determine project status?Can any corrective actions be initiated? And if so, how?Answer these questions in a 1,050- to 1,400-word paper. Format your paper consistent with APA guidelines. Submit the assignment.
FNCE 3001 Walden University Stocks Company Valuation Essay
What does it mean to own a stock? You may know
that a stock is an investment and that it can go up or down, but there
...
FNCE 3001 Walden University Stocks Company Valuation Essay
What does it mean to own a stock? You may know
that a stock is an investment and that it can go up or down, but there
is more to owning a stock than that. When you own a stock, you own a
fraction of the company. If it is just one stock, then it is likely an
incredibly small fraction, but institutional investors and even some
individuals may accumulate enough stock in a company to own a
significant portion of the company. It is important for you, as a
shareholder of the company, to understand that you may be entitled to
certain privileges, such as voting rights or dividends. Additionally,
there are different types of stocks (e.g., common and preferred), and
you should understand the difference between them before making an
investment decision in a company. For this Assignment, you will explain the
differences between common stock and preferred stock, as well as explain
other aspects of common stocks, such as potential total return and
valuation. You will describe how dividends affect stocks and their total
returns.What are a few differences between common stock and preferred stock? (75–150 words, or 1–2 paragraphs)What makes up the potential total return of a common stock that you purchase? (75–150 words, or 1–2 paragraphs)Why are stocks generally more difficult to value than bonds? (75–150 words, or 1–2 paragraphs)Why might a company choose to not pay dividends? (75–150 words, or 1–2 paragraphs)Under what two assumptions can you use the dividend growth model to
determine the value of a share of stock? (150–225 words, or 2–3
paragraphs)Based on the dividend growth model, what are the two components of
the total return on a share of common stock? Which do you think is
typically larger? (75–150 words, or 1–2 paragraphs)
Similar Content
finish last point (Implementation Strategies)
look doc. finish last point (Implementation Strategies). combine the whole article. writing Implementation Strategies....
Management Discussion
Examine an organization that added new technology that allows them to be more competitive and productive. Discuss the pro...
MGT 311 Saudi Electronic University Operation Management Questions
Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencin...
Employment Law Wk 3- HW Affirmative Action, law homework help
Please read Chapter 8 provided in the ppt below. Give a full and complete explanation of the three “types” of Affirmat...
Team Management Assignments
Please find the attachment for the list of all questions from 1 to 8.NOTE:Write at least 1000 words per each question.Also...
University of Scranton Amsterdam on the Road to Become a Smart City PPT
The Power Point file, should describe a) a brief overview b) problems to be solved or goals to be achieved, c) analytic to...
Wall Street And The Sarbanes
In the year 2001, Enron Corporation together with its subsidiaries filed for bankruptcy protection which made it the large...
Impact Of White Collar Crime
With the technological advancement, there has been an increase in crimes in the contemporary society. Most of these crimes...
Law Enforcement Agencies Final
The main role of law enforcement agencies is to maintain law and order within a particular jurisdiction. However, in the p...
Related Tags
Book Guides
The Rhythm Section
by Mark Burnell
The Power of Habit - Why We Do What We Do in Life and Business
by Charles Duhigg
No Exit
by Taylor Adams
The Secret Life of Bees
by Sue Monk Kidd
My Brilliant Friend
by Elena Ferrante
The 7 Habits of Highly Effective People
by Stephen R. Covey
Where the Crawdads Sing
by Delia Owens
Jane Eyre
by Charlotte Brontë
Slaughterhouse Five
by Kurt Vonnegut
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
University of Phoenix Wk 5 Cognitive and Affective Perspective Taking Discussion
Write a 250- to 300-word response to the following: Healy and Grossman (2018) discuss cognitive and affective perspective- ...
University of Phoenix Wk 5 Cognitive and Affective Perspective Taking Discussion
Write a 250- to 300-word response to the following: Healy and Grossman (2018) discuss cognitive and affective perspective-taking. Read Cognitive and Affective Perspective-Taking: Evidence for Shared and Dissociable Anatomical Substrates from the University Library.Describe the differences between cognitive and affective perspective-taking and how the knowledge of perspective-taking might assist in an interview process for a research study.
PJM 440 CSU Total Quality MGT and Office of Personnel MGT on Federal Plan Portfolio
Total quality management and the Office of Personnel Management (OPM) on Federal RetirementsThe Government Accounting Offi ...
PJM 440 CSU Total Quality MGT and Office of Personnel MGT on Federal Plan Portfolio
Total quality management and the Office of Personnel Management (OPM) on Federal RetirementsThe Government Accounting Office (GAO), Office of Personnel Management (OPM) in May of 2019 published the Federal Retirement: OPM Actions Needed to Improve Application Processing Times. OPM has a goal of processing most retirement application in 60 days, but for several years has not met that standard. The GAO OPM for that reason, studied the process for federal retirement processing to determine root causes of delays, and to determine what strategies should be employed to remedy the situation. The results of that study are available at the following website: https://www.gao.gov/assets/700/699120.pdf (Links to an external site.)While the document provides root cause analysis and recommends six opportunities for improvements, it offers no quality management plan. You have been contracted to develop a quality management plan, and you will report to the Comptroller General of the United States, the director of the Government Accountability Office. The GAO is a legislative branch agency established by Congress in 1921 to ensure the fiscal and managerial accountability of the federal government. If your quality management plan is acceptable, the Comptroller General of the United States will support your company for project managing the implementation of funded improvements. This could be a long and lucrative contract for your company.Note: While the document at the core of this assignment is an actual document published by The Government Accounting Office, the quality management scenario described is fictional and only for the educational purpose of showing mastery of the course objectives set forth for this course.In Module 3, you were asked as a first step, to familiarize yourself with the Federal Retirement: OPM Actions Needed to Improve Application Processing Times document, hereafter called the GAO report. After your review of the guidelines, you were asked to provide your input to the following:Is the current Federal Retirement: OPM Actions Needed to Improve Application Processing Times document one that promotes high quality? If yes, how? If no, why not and what should change to promote quality? Support your position with specific references to the GAO report or current scholarly documentation.What do you interpret to be meant by "quality" from the perspective of the GAO OPM, retirees, Congressional leaders, and the public both now and in the future? What support do you have for your position with current (published in the past five years) scholarly documentation?What are the drivers for change, and the barriers to change from the perspective of the GAO OPM, retirees, Congressional leaders, and the public? Are there competing drivers for change that may impact quality from the public's perspective? Support your position with specific references to the GAO report or current scholarly documentation.In Module 8, you are asked to build upon your work from Module 3 and show additional mastery through other course modules.Provide the following quality management plan in your final portfolio:Provide an opening paragraph which describes the importance of the using this case to show your mastery of course objectives, and mapping of what is contained in your paper to prove that mastery.Delineate your next section with a header, and in less than one page, describe the current situation with federal retirement processing, the recommendations from the GAO study, and the role of the GAO OPM in promoting quality.Delineate your next section using headers and sub-headers with your work from Module 3. Include any updates that you wish to make as a result of learning more about quality management, and input from your instructor in Module 3 for the following: Is the current Federal Retirement: OPM Actions Needed to Improve Application Processing Times document one that promotes high quality? If yes, how? If no, why not and what should change to promote quality? Support your position with specific references to the GAO report or current scholarly documentation.What do you interpret to be meant by "quality" from the perspective of the GAO OPM, retirees, Congressional leaders, and the public both now and in the future? What support do you have for your position with specific references to scholarly (peer-reviewed) resources?What are the drivers for change, and the barriers to change from the perspective of the GAO OPM, retirees, Congressional leaders, and the public? Are there competing drivers for change that may impact quality from the public's perspective? Support your position with specific references to the GAO report or current scholarly documentation.Delineate your next section with a header to discuss the operational issues that must be managed and controlled to support quality including partnering and strategic alliances if any are pertinent. How will those issues be managed and controlled in your plan? As usual, what support do you have for your position with specific references to the GAO report or current scholarly documentation?Delineate your next section with a header to discuss the human resource issues that must be managed and controlled to support quality including employee empowerment, teamwork, education and training. How will those issues be managed and controlled in your plan? As usual, what support do you have for your position with specific references to the GAO report or current scholarly documentation?Delineate your next section with a header to discuss customer satisfaction and how it will be measured. How will and when will measurement happen in your plan? As usual, what support do you have for your position with specific references to the GAO report or current scholarly documentation?Delineate your next section with a header to discuss how problems will be solved, conflicts resolved, and how decisions will be made especially any interagency issues, or legislative issues that may arise. As usual, what support do you have for your position with specific references to the GAO report or current scholarly documentation?Delineate your next section with a header to discuss what quality tools should be used, when and how, including communications tools, process control tools, benchmarking, or other tools as you find appropriate. What support do you have for your position with specific references to the GAO report or current scholarly documentation?Finally, conclude with the final section making a recommendation to the Comptroller General of the United States for your plans, and why your company is in the best position to lead the quality management effort going forward through implementation.Submission:Write a paper addressing the case of federal employee retirement processing regarding the GAO OPM report and quality management. Your paper should be 8-10 pages in length, not including the required title and references pages and any appendix if required. For more information see "How do I do an Appendix in APA style?" (Links to an external site.)Support the paper with a minimum of six current (published in the most recent five years) scholarly sources from the CSU Global Library. This is in addition to any course textbooks, lecture material you decide to use, or the case itself. Of course, you may always exceed the minimum number of sources.Format the paper according to the CSU Global Writing Center (Links to an external site.).Be clear, concise, and focused.Tip: Cases may be addressed in 6 steps:Read the assignment and questions provided to get an idea of the important course concepts to be covered. There is plenty of material in a case that may be immaterial to the course learning objectives. (For example, a case may have significant information on staff acknowledgements, but the assignment questions relate to quality management. In that case, do not spend time on those acknowledgements unless relevant to quality management. Use your time searching the case, researching and reporting on quality management.)Read and take notes on the entire case. Read every figure and table to thoroughly understand them.Determine who are the key players; what are the key issues; what is the problem to be solved?Do the research and analyze any data. Use the CSU Global library to research the key issues and problems. Find current academic information on those topics.Make your decisions relative to the important course concepts, and document the defense of your position by melding the scholarly research and examples from the case. Remember, no opinions; only facts.Finalize your portfolio by checking all assignment questions are fully answered, rubric items are met, and the document follows CSU Global Guide to Writing and APA requirements.
4 pages
Aviation Industry
The airline or aviation industry is evolving to handle the ever-increasing demand for passenger travel. As the air transpo ...
Aviation Industry
The airline or aviation industry is evolving to handle the ever-increasing demand for passenger travel. As the air transport industry is making ...
BUS 622 Ashford University Walmart International Business Model Discussion
Walmart Case Study[WLO: 3] [CLOs: 2, 3, 5]Prior to this assignment, review Chapter 12: Global Marketing Channels and Physi ...
BUS 622 Ashford University Walmart International Business Model Discussion
Walmart Case Study[WLO: 3] [CLOs: 2, 3, 5]Prior to this assignment, review Chapter 12: Global Marketing Channels and Physical Distribution and analyze Case 12-2: Can Walmart Crack the Retail Code in India? carefully. Review the Intro and Company Profile sections in the Walmart Case Study (Links to an external site.) interactive.Your assignment has two parts. Part A will be based on a case in Chapter 12, and Part B will be built upon your Final Paper about Walmart from your BUS621: Leadership and Teamwork course. In fact, the purpose is for you to analyzed Walmart from different angles: leadership style, marketing strategies and tactics, HR, Financial aspects, etc. so by the end of your MBA program you have completed Walmart’s big-picture puzzle.IntroductionWalmart today is a global retail giant. According to Carbonara (2018) in the recommended resource Walmart, Amazon Top World’s Largest Retail Companies (Links to an external site.) article, Walmart is the world’s largest retail company with continued plans for global growth. There are many competitors, one of which is Amazon. How will Walmart continue to be a global giant in the years to come? To maintain the market leader position Walmart will be required to continually look for ways to outgrow its global competitors (Carbonara, 2018).To understand Walmart and where it is today and what tomorrow holds, it is important to understand the company’s foundation. “Sam Walton opened his first five-and-dime in 1950. His vision was to keep prices as low as possible” (Wilbert, 2018, para. 1). Walton opened the first Walmart in the early 1960s in Rogers, AR (Wilbert, 2018, para. 2). One thing that has and will always remain a key component for all Walmart stores is to keep expenses low. There has always been a mentality behind the vision of Walton to demand that employees always keep costs to a bare minimum (Wilbert, 2018, para. 3). On average, “Walmart saves a typical American family of four about $2500 a year. That’s about what a family of four gets from the government in food stamps. That makes Walmart a major antipoverty force in the United States” (Kestenbaum, 2017, para. 3). Another factor to consider when thinking about Walmart is that “since 1990, the global rate of poverty has been cut by two-thirds. That’s the sharpest decline in human poverty in all of history, more than one billion people have been lifted out of poverty during that period and Walmart is a major force in that effect” (Kestenbaum, 2017, para. 3).Today, Walmart has grown considerably and continues to expand. Just to get an idea of how large this retail giant is, consider the following:Walmart employs 1.6 million people.Walmart has 6,200 retail outlets. In contrast, Home Depot has 2,040. (Wilbert, 2018, para. 4)One might question, “What does Walmart do to continue to be successful and keep costs to a minimum?” There are several things that this retail giant has incorporated into the operations. First, “Walmart became the first major retailer to demand manufacturers use radio frequency identification technology (RFID). The technology uses radio frequencies to transmit data stored on small tags attached to pallets or individual products. As explained in the recommended resource How Wal-Mart Works (Links to an external site.), RFID tags hold significantly more data than bar codes” (Wilbert, 2018, para. 6). For information on how RFIDs and radio waves work, you may like to review the articles How RFID Works (Links to an external site.) and How Radio Works (Links to an external site.). You may also be interested in reviewing the Is Walmart Good or Bad for America? The Question May Be Outdated (Links to an external site.) article which explains another interesting fact, which is that “Walmart is the single most important pipeline distributing wealth from rich countries to poor countries” (Kestenbaum, 2017, para. 3).One concern pertaining to Walmart is how employees are treated. It is well known that Walmart not only pays low wages, but their practices have impacted how their suppliers manage production costs while sacrificing the safety of their labor force (Kestenbaum, 2017). Walmart tends to hire mostly part-time workers (Kestenbaum, 2017). Some may even say that Walmart “pays their workers poverty wages” (Kestenbaum, 2017, para. 4). There have long been ethical concerns about how Walmart operates and manages its employees.Case Study AssignmentThroughout your MBA program you will cover various subjects as they relate to business. You will initially have an opportunity in BUS621 Leadership and Teamwork to create and build your own Walmart in a new global location. Your choices for location include Peru, New Zealand, Philippines, Egypt, Czech Republic, and United Arab Emirates. As you progress through each course in the program you will build upon your case study of Walmart.The purpose of this Walmart Case Study is to give you an opportunity to apply the subject matter from each course in the MBA program to an ongoing strategic development. The knowledge gained from the case study in each course will be cumulative. The knowledge will assist you in demonstrating your ability to conduct critical analysis and decision making across a wide range of subjects throughout the MBA program.MethodologyThe case study is based upon past and current information about Walmart and the country of destination. You will select a country to develop your case and will use the same country in each course of the MBA program.You will be responsible for gathering as much information as needed that will help you with determining the course of action that Walmart should pursue in the company’s quest to growth and to meeting the needs of international markets.Part A: Read Case 12.1: Can Walmart Crack the Retail Code in India? and answer the following questions:Summarize some of the elements in India’s political, economic, and cultural environments that can impact the market opportunity.Explain some of the obstacles facing Walmart and other foreign retailers in India.Review Figure 12-4 (Global Marketing). Explain which quadrant of the matrix applies most directly to India. Provide your rationale.Part B: In your BUS621: Leadership and Teamwork course, you selected a country for Walmart to expand to, and you also analyzed the nine dimensions of the culture and the leadership models and skills that would apply to your selected country. In this assignment, you will work and build on your previous Walmart work, and develop some place strategies as Walmart expands on its global marketing activities to the country of your choice. Address the following points for the selected country:Summarize some of the elements in your selected country’s political, economic, and cultural environments that can impact the market opportunity for Walmart expansion.Based on your environmental review and referring to Figure 12-4, discuss what market expansion strategy you would suggest for Walmart in your selected country.You learned that channels create utility for customers (place utility, form utility, time utility, and information utility) that can be leverages as a source of competitive advantage. Analyze each of these utilities that Walmart may be creating in the country of your choice, and explain which one can potentially work as a competitive advantage for Walmart considering its target market and their needs, wants, and preferences in your selected country.Considering the growth of global online retailers like Amazon.com, Aliexpress.com, Target.com, and eBay.com as competitors of Walmart.com, and based on the factors you evaluated in Part A, formulate a SWOT analysis for Walmart.com in your selected country.The Walmart Case Study paperMust be three to five double-spaced pages in length (not including title and references pages and formatted according to APA style as outlined in the Ashford Writing Center’s APA Style (Links to an external site.) resource.Must include a separate title page with the following:Title of paperStudent’s nameCourse name and numberInstructor’s nameDate submittedFor further assistance with the formatting and the title page, refer to APA Formatting for Word 2013 (Links to an external site.).Must use at least two scholarly sources for each environment topic in addition to the course text.The Scholarly, Peer-Reviewed, and Other Credible Sources (Links to an external site.) table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.Must document any information used from sources in APA style as outlined in the Ashford Writing Center’s Citing Within Your Paper (Links to an external site.) guide.Must include a separate references page that is formatted according to APA style as outlined in the Ashford Writing Center. See the Formatting Your References List (Links to an external site.) resource in the Ashford Writing Center for specifications.Carefully review the Grading Rubric (Links to an external site.) for the criteria that will be used to evaluate your assignment.
CPMGT 303 University of Phoenix JP Phentar Construction Case Study Analysis
Assignment ContentReview the JP Phentar Construction: Case Study in Ch. 11 of A Comprehensive Guide to Project Management ...
CPMGT 303 University of Phoenix JP Phentar Construction Case Study Analysis
Assignment ContentReview the JP Phentar Construction: Case Study in Ch. 11 of A Comprehensive Guide to Project Management Schedule and Cost Control.Complete the following:Determine which information-gathering tools would be most effective for this project and what activities would need to be monitored.Based on data that would be generated from work activities, what types of analytical tools could be used to determine project status?Can any corrective actions be initiated? And if so, how?Answer these questions in a 1,050- to 1,400-word paper. Format your paper consistent with APA guidelines. Submit the assignment.
FNCE 3001 Walden University Stocks Company Valuation Essay
What does it mean to own a stock? You may know
that a stock is an investment and that it can go up or down, but there
...
FNCE 3001 Walden University Stocks Company Valuation Essay
What does it mean to own a stock? You may know
that a stock is an investment and that it can go up or down, but there
is more to owning a stock than that. When you own a stock, you own a
fraction of the company. If it is just one stock, then it is likely an
incredibly small fraction, but institutional investors and even some
individuals may accumulate enough stock in a company to own a
significant portion of the company. It is important for you, as a
shareholder of the company, to understand that you may be entitled to
certain privileges, such as voting rights or dividends. Additionally,
there are different types of stocks (e.g., common and preferred), and
you should understand the difference between them before making an
investment decision in a company. For this Assignment, you will explain the
differences between common stock and preferred stock, as well as explain
other aspects of common stocks, such as potential total return and
valuation. You will describe how dividends affect stocks and their total
returns.What are a few differences between common stock and preferred stock? (75–150 words, or 1–2 paragraphs)What makes up the potential total return of a common stock that you purchase? (75–150 words, or 1–2 paragraphs)Why are stocks generally more difficult to value than bonds? (75–150 words, or 1–2 paragraphs)Why might a company choose to not pay dividends? (75–150 words, or 1–2 paragraphs)Under what two assumptions can you use the dividend growth model to
determine the value of a share of stock? (150–225 words, or 2–3
paragraphs)Based on the dividend growth model, what are the two components of
the total return on a share of common stock? Which do you think is
typically larger? (75–150 words, or 1–2 paragraphs)
Earn money selling
your Study Documents