Begin outlining an argumentative position paper based on research about the "Tea Part Movement." This movement has recently emerged as a counter response to the government's bailout of the banks. Research the "Tea Party Movement." Find three sources you can use in a position paper Word Count: 900 -1100. What is this movement and what are its goals? Based on your position either in support or against, write a position paper based on your view of the capability of the movement to change the course of our economy and government? Why or why not? You must support your opinion and position with facts from outside sources. Do not include a solution in your paper. Just stick to your position in regard to the viability of the tea party movement as a third party
Category: Uncategorized
Excel Assignment Chapter 08
PROJECT DESCRIPTION Henrique Silva works in the Sales department of Spring Software, a software development company headquartered in Cambridge, Massachusetts. Henrique has created a worksheet to capture customer sales data for the Nashua office for the past three years. He has asked you to enhance the workbook using conditional formatting and advanced formulas to better analyze the customer data, highlight trends, and identify top customers. GETTING STARTED • Download the following file from the SAM website: o NP_Excel2013_T8_P1a_FirstLastName_1.xlsx • Open the file you just downloaded and save it with the name: o NP_Excel2013_T8_P1a_FirstLastName_2.xlsx o Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically. • With the file NP_Excel2013_T8_P1a_FirstLastName_2.xlsxstill open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. Go to the CustomerListworksheet and complete the following actions: a. Apply a conditional formatting rule to the range A4:A32 that formats any duplicate values with Yellow Fill with Dark Yellow Text. b. Update the Customer ID value for Firehouse Partners LLC to 1015 and the Customer ID value of the Applewild Learning Center to 1023. The conditional formatting rule should no longer highlight any values in the range A4:A32. 2. Edit the conditional formatting rule applied to the range G4:G32 so that the highlighted cells are formatted with the font color is White, Background 1 and the fill color Blue, Accent 5, Lighter 40% (9th column, 4th row in the Theme color palette.) 3. In cell D4, enter a formula that calculates customer tenure, in years, using absolute and structured references. The formula should calculate tenure based on subtracting the value in the First Order column from the current year value in cell B1. If necessary, copy the formula you created in step D4 to the range D5:D32. (Tip: Remember to use an absolute reference to the current year value in cell B1.) 4. In cell I4, enter a formula that uses the IF functionand structured referencesto calculate the 2-Year Growth Percentage. a. The 2-Year Growth Percentage can be calculated if the value in 2015 Sales column is greater than 0. b. To calculate the 2-Year Growth Percentage, divide the value in the 2-Year Sales Growth column by the value in the 2016 Sales column. c. If the value in the 2015 Sales column is not greater than 0, return a value of N/A. 5. In cell J4, enter a formula that uses an IF function and structured referencesto determine customer discount eligibility.(Tip: You will need to use the OR function in this formula.) a. A customer is eligible for a discount if the customer’s 2016 salesgreater than or equal to 100000OR if the customers First Order was placed in 2016. b. If the customer qualifies for a discount, return a value of Y. (Tip: For the value_if_true value, use “Y”.) c. If the customer does not qualify for a discount, return a value of N. (Tip: for the value_if_false, use “N”.) 6. In cell K4, enter a formula that uses a nested IF functionand structured references to calculate the discount percentage: a. If the value in Discount Y/N column is equal to N, the Discount column value should be 0. b. If the value in the Discount Y/N column is equal to Y, the formula should check if the value in the Tenure (Yrs) column is less than 5. c. If the value in Tenure (Yrs) column is less than 5, the Discount column value should be 0.07 d. Otherwise, the value of Discount column should be 0.1. (Note: The Discount column is formatted with the Percentage Number format, so the values returned by the nestedIF function will appear as 0%, 7%, or 10%.) 7. In cell L4, Enter a formula that uses an IF function and structured references to assign a priority value to each customer. (Tip: You will need to use an AND function in this formula.) a. The If function should check if a customer has a Tenure field value greater than or equal to 5 yearsAND2016 sales field value greater than or equal to 150000. b. If the customer meets both those criteria, the function should return the value High. c. If the customer does not meet both those criteria, the function should return the valueLow. 8. In cell Q4, nest the VLOOKUP function in an IFERROR function. The cell should display the error message Invalid Customer ID instead of the error value, if the VLOOKUP function finds an error. Confirm the error message appears and then update the Customer ID value in cell Q3 to 1019. 9. In cell Q6, enter a formula using the VLOOKUP function to lookup the Customer ID value shown in cell Q3in the CustomerNashua table (located in the range A3:L32). The VLOOKUP function should then retrieve the Discount value from the CustomerNashua table (the 11th column in the table) for this record. The VLOOKUP function should find an exact match to the value in Q3. 10. In cell Q7, enter a formula using the HLOOKUP function to determine the free services customer incentive offered to Spring Sales bigger clients.The HLOOKUP function should look up the value in cell Q5in the range N10:R11 (which has the defined name CustomerIncentives). The HLOOKUP function should then retrieve the value in the 2nd row of the CustomerIncentiveslookup table. Since these free services are offered to customers that meet or exceed the yearly sales levels listed in the CustomerIncentives table, the HLOOKUP function should find an approximate match to the value in Q5. 11. Go to Customer Analysis worksheet. In cell C4, enter a formula that uses the COUNT function and structured references that counts the total number of customers in the CustomersNashuatable on the CustomerList worksheet (Tip: The COUNT function only counts rows that contain a value, you cannot use the Customer column as an argument in the function. Use the Customer ID column instead.) 12. In cell D4, enter a formula that uses the COUNTIF functionand structured references to count the number of customers with a Priority rating of Highin the CustomersNashuatable on the CustomerList worksheet 13. In cell C5, enter a formulathat uses the SUM function and structured references to calculate 2016sales for all customers. 14. In cell D5, enter a formula that uses the SUMIF function and structured references to calculate 2016 sales for customers with a Priority rating of High in the CustomersNashuatable on the CustomerList worksheet 15. In cell D6, enter a formula to calculate the percentage of High Priority CustomersSales out of All Customers2016 sales. (Tip: The calculation should divide the 2016 High Priority Customer sales by the total 2016 sales for all customers.) Format the cell using the Percentage number format with no decimal places. 16. In cell C7, enter a formula that uses the AVERAGE function and structured references to calculate the average tenure of all customers in the CustomersNashuatable on the CustomerList worksheet 17. In cell D7, enter a formulathat uses the AVERAGEIF function and structured references to calculate the average tenureof customers with a Priority rating of High in the CustomersNashuatable on the CustomerList worksheet 18. In cell C8, enter a formula to calculate the average sales per customer for all customers. 19. In cell D8, enter a formula to calculate the average sales per High Priority Customer. Your workbookshould look like the Final Figures on the following page. Save your changes, close the workbook, and exit Excel. Follow the directions on the SAM website to submit your completed project.
BA 520 Week 7 – Question #2: Simulation Modeling Research
BA 520 Week 7 – Question #2: Simulation Modeling Research
Answer the following question 1. Use the internet to conduct research on popular simulation modeling software applications. Find two applications to compare by examining the costs, features, and training requirements. Your paper should reflect scholarly writing and current APA standards. Please include citations to support your ideas.
integrity and personality tests
integrity and personality tests
1. Do you think employers should use integrity and personality tests to make recruiting and promotion decisions? Why or why not? 2. Can you think of some jobs where integrity and personality tests might be more appropriate than for other jobs? Give your rationale. 3. Do you think companies will use more or less integrity and personality tests in the next five years? Why? Your initial posting: Due Thursday nights by 11:59 p.m. EST of each week Must include a minimum of 250 words Must include a minimum of two citations from two different references (one maybe be the textbook) The references must be listed and cited within your initial posting. Also this needs to be in APA Format. Thank you!
What is polluted water? Why is water pollution more…
What is polluted water? Why is water pollution more…
What is polluted water? Why is water pollution more common in the developing countries of Asia, Africa, and South America and rarely in developed countries? Additional Requirements Level of Detail: Show all work
Discuss in-detail the consequences that occur at the…
Discuss in-detail the consequences that occur at the…
Discuss in-detail the consequences that occur at the cellular level upon activation of Myc and please do the same for activation of TGF-?. Activation of either of these genes cause numerous changes at the cellular level so I would like each clearly explained and discussed. Need a three page essay with references. Additional Requirements Min Pages: 3 Other Requirements: Will provide bonus if it is complete by 7/13.
Examining Supply Chain Profitability
Examining Supply Chain Profitability
Examining Supply Chain Profitability In this web research assignment, you will research a company that uses supply chain management (SCM) and look at how their organizational profitability is affected by it. Research a company that uses supply chain management. Write a 1-page (200-word) paper. Include the following in your paper: A description of the company you researched An explanation of how they use supply chain management A brief explanation of how supply chain management affected the organization's profitability. APA style paper.
In this assignment, you will investigate the biotic…
In this assignment, you will investigate the biotic…
In this assignment, you will investigate the biotic and abiotic structure and function of an ecosystem. Choose one of the following ecosystems: Tropical rainforest Grassland Coral Reef Estuary Desert You will write a two to three page APA-style research paper about your choice of ecosystem including: Where might this type of ecosystem be located? Give one specific example. Describe the structure of the ecosystem: List both the abiotic components and biotic components Describe the function of the ecosystem: How do the abiotic and biotic components interact in biogeochemical cycles? Describe both the carbon and nitrogen cycles Describe disturbance and recovery: Describe one natural and one human caused disturbance to the ecosystem you have chosen. Explain the damage to the ecosystem, including how the abiotic and biotic characteristics of the ecosystem changed. Explain how ecosystems recover naturally based on resilience mechanisms and the theory of secondary succession. Additional Requirements Min Pages: 4
Ethical leadership
Ethical leadership means making the right decisions and doing the right things, when in powerful position. Good ethical leadership greatly relies on personal values. According to Kaufman (2008), the connection between ethical leadership and a leader’s values manifests in myriad ways. This connection is largely determined through the creation and maintenance of loyalty and respect within the organization. For example, a leader who truly believes in the kind of duties he or she performs for their employer is greatly revitalized to create necessary, beneficial and safe services and products with pride, respect, and dedication to the purpose. Secondly, a leader’s personal values play a significant role in ethical leadership, in the manner in which, a leader makes decisions that align to the organizational vision. Personal values transcend both experiences and contexts, and therefore are essential in making complex and more flexible decisions (Caldwell, Shapiro & Gross, 2007). In addition, personal values influence ethical leadership in accordance to the way a leader stimulates vision and inspire their followers. For example, within the team setting, a leader’s personal values enhance team building, sharing of ideas as well as motivating the team members to achieve results. Caldwell, C., Shapiro, J. & Gross, S. (2007). Ethical Leadership in Higher Education Admission: Equality vs. Equity. Journal of College Admission, Spring (195), 14-19. Kaufman, R. (2008). A Practical Definition of Ethics for Truly Strategic Planning In Higher Education. New Directions for Higher Education, Summer (142), 9-15.
Good Grocers, Inc. Solution Paper………….
Good Grocers, Inc. Solution Paper………….
Assignment 1: Good Grocers, Inc. Due Week 3 and worth 150 points Note: The company mentioned herein is merely a hypothetical organization with characteristics developed to enable students to respond to the assignment. You may create and / or make all necessary assumptions needed for the completion of this assignment. After Good Grocers, Inc. expanded its organic produce section and adopted a “buy local” policy, sales increased. The Virginia-based chain expanded its retail locations from seven to twelve (7 to 12) over the last three (3) years. As the Assistant Human Resources Manager, your job is to advise store managers about legal and personnel matters. The leadership at Good Grocers, Inc. considers you to be a legally astute manager, who consults with the corporation’s attorney, as necessary. The corporation’s leadership has tasked you with managing two (2) situations have come across your desk. Please respond with support that is backed by the law. Write a three to four (3-4) page paper which addresses the two (2) situations from two (2) store managers. Situation 1 Last week, my produce manager reported the following incident: As I came out from the bakery, I saw a woman lying on the floor of the produce department. Her husband started yelling at me, saying, “She slipped on a banana peel and fell. My wife is the anchorwoman for NEWSNOW, and we are going to sue you!” She didn’t look hurt, but I called 911 and filed an incident report that contained the facts of the situation. When viewing the area, I did, in fact, see a banana peel on the floor, but it was still yellow and lying on top of a ribbed rubber mat. The woman in question was wearing five-inch high heels. But I wasn’t sure what to say, other than the woman would be hearing from us. 1.Explain whether this situation is best handled by litigation or by a particular form of alternative dispute resolution. 2.Based on how you would handle this situation, either through litigation or a particular form of alternative dispute resolution, outline the key next steps involved in seeking a resolution. Justify your response. Situation 2 Last week, my bakery manager was short an employee over Mother’s Day weekend when the bakery is always busy. To make up for being shorthanded, the bakery manager called in Ms. Greene, an independent contractor. Generally, Ms. Greene comes in on Monday, Wednesday, and Friday nights between 6 to 9 p.m. just to decorate cakes; she has her own bakery business. We furnish all of her equipment, and we pay her by the cake. Ms. Greene worked eight (8) hours on Saturday and another eight (8) hours on Sunday over Mother’s Day weekend. We paid her $15.00 per hour. On the following Monday when Ms. Greene came in, she told me that she wanted to receive the same benefits as the other Good Grocers part-time employees, such as paid time off and employee discounts. Ms. Greene asserted that she really is a part-time employee who deserves the usual employee benefits. 3. Determine whether Ms. Greene is an independent contractor or a part-time employee. Provide a rationale for your response. 4. Explain the reasoning supporting whether or not Ms. Greene should receive the same benefits as part-time employees. Suggested resources for this assignment: 1.Access your Learning Resource Center (LRC) at the top of your iCampus screen. Search by keyword for business articles on arbitration, mediation, or independent contractors. You may also use your LRC to access legal topics and articles through the Lexis Nexis database. 2.At FindLaw, located at http://www.findlaw.com/, you may search by legal topic or enter a keyword(s) into a search box to find relevant information and articles. 3.You may use the following additional resources: •Internal Revenue Service (IRS): http://www.irs.gov/Businesses/Small-Businesses-&-Self-Employed/Independent-Contractor-Self-Employed-or-Employee •The Virginia Department of Labor and Industry: http://www.doli.virginia.gov/laborlaw/laborlaw.html Your assignment must follow these formatting requirements: •Use at least two (2) quality academic resources in this assignment, such as a government Website, and include internal citations. Note: Wikipedia and other Websites do not qualify as academic resources. •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.