need formula for trends and bonus AveryCollinsKinsleyMcDonnoughRossShannon2012 Total Sales by AgentJanuary - JuneJanuaryFebruaryMarchApril$ 3,671 $ 2,973 $ 4,017 $ 5,040 $$ 1,549 $992$$2,267 $ 3,201 $2,996 $ 6,948 $ 4,205 $ 5,523 $2,003 $ 4,190 $ 3,496 $$ 4,038 $ 2,064 $ 7,015 $$ 1,172 $ 866 $2,109 $$Task 5Create Line sparklines in column Hin the Summary sheet to display six-month trends for each agent. Showthe high point in each sparkline.Task 7Create a footer with your fullname on the left side, the filename in the center, and theDate on the right side of eachsheet (Part_1 and Part_2).MayJune4,963 $ 5,4974,008 $ 3,7986,597 $ 5,1471,975 $ 2,936 $ 3,4986,832 $ 5,971 $ 5,4973,385 $ 4,078 $ 3,598TrendsBonus$BonusTask 6Insert an IF function in column I that displaysa $600 bonus if an agent's average sales aregreater than the average of all sales for thesix months. Use two nested AVERAGEfunctions in the logical_test argument of theIF function to make the comparison. Use cellreference for Bonus.600

Find the Given details below: Given details January February March April May June Avery $…

Answered: Avery Collins Kinsley McDonnough Ross…

Management, Loose-Leaf Version

13th Edition

ISBN:9781305969308

Author:Richard L. Daft

Publisher:Richard L. Daft

Chapter5: Managing Ethics And Social Responsibility

Section: Chapter Questions

Problem 2OTJVC

See similar textbooks

Similar questions

Q3b Domod Plc is on the verge of collapse, and the main problem identified relates tothe lack of qualified staff. Explain the process for attracting and hiring staff startingfrom manpower planning to employee appraisal. ii. Henry Gantt is said to have developed the Gannt Chart, discuss the relevance of theGannt chart in decision making. Relate your explanation to your courses for thesemester and present a diagram to show how you would apply the Gannt chart andexplain how it functions using the diagram.
1. The business that I will start is a Coffee business.As a result,it aims at solving the problem of- -Quality of coffe bean -Coffee brewed properly -To take it from a common coffee to a global drink -To create acceptance through all age segments -To supply coffee globally that is of quality 2.The product or service -Quality coffee having no match in the industry -Ease of use and less time of preparation -Include variants to suit each ones taste -Build on the benefits of different types of coffees 3.Target market- -Young People -Coffee lovers -Office workers -Foodgram 4.Competitors- -Coffee estate owners -Local coffee manufacturers -Coffee companies as it forms a substitute 5.Promotion -Advertisement from Instagram-Ads -Café’s interior design -10% discounts for first purchase -Special offer on customer’s birthday Based on the business idea above, do the following: How do you increase the interaction and interest of your audience during your time communicate the business idea?
1. The business that I will start is a Coffee business.As a result,it aims at solving the problem of- -Quality of coffe bean -Coffee brewed properly -To take it from a common coffee to a global drink -To create acceptance through all age segments -To supply coffee globally that is of quality 2.The product or service -Quality coffee having no match in the industry -Ease of use and less time of preparation -Include variants to suit each ones taste -Build on the benefits of different types of coffees 3.Target market- -Young People -Coffee lovers -Office workers -Foodgram 4.Competitors- -Coffee estate owners -Local coffee manufacturers -Coffee companies as it forms a substitute 5.Promotion -Advertisement from Instagram-Ads -Café’s interior design -10% discounts for first purchase -Special offer on customer’s birthday Based on the business idea above, do the following: a. How do you communicate these business ideas creatively and innovatively to potential investors. Use the core…
Withtheaidofexamplesexplainhowtheconceptofmarketforcescouldbeimportantin describingentrepreneurialbehavior.
Amazon bought Whole Foods for almost $14B. Why would it have made sense for Amazonto buy WF instead of (a) building a grocery business themselves or (b) entering into analliance with Whole Foods?
Propose a strategic direction for Sharaf DGGive recommendations on the capabilities and processes that the company needs to develop in order to be competitive, and how to acquire them
1. Under the POCD framework, this refers to the vision and mission statements of thecompany:a. Peopleb. Contextc. Opportunityd. Deal2. A common mistake of companies in their quest to create competitive advantage is:a. Lack of analysis on wastageb. Overly priced productsc. Lack of systematic business frameworksd. Inability to manage business3. Ethics theoretically speaking is a moral philosophy because:a. It is not biblicalb. It is a personal choicec. It is taught and practiced in societyd. It begins at home4. Understanding the “Toyota Way” in essence is an example of the study in:a. Ethicsb. Professionalismc. Cultured. Strategies5. This is a common knee jerk reaction by companies when they start losing cash:a. Terminate employeesb. Sell assets, regardlessc. Loan and then put the business under collaterald. File for bankruptcy6. The industry is part of the scope of business ethics because:a. It makes or breaks the employeeb. It influences how your organization behavesc. It can reshape…
BUSINESS FINANCE 1. As a student, what practical benefits can you gain from learning business finance? 2. Can you give me person that you know who is very good in budgeting or in financial matters and kindly share to us his/her good practices. 3. What is the major role of the board of directors in an corporation? 4. What’s the differences between the VP MARKETING AND VP ADMINISTRATION? 5. What is the differences between wealth maximization and profit maximization? 6. Name one CEO and share his/her advocacies that you would like to evaluate and live by. 7. What was your personal experience regarding budgeting your own money? How did you overcome any difficulty? 8. What do you understand with the terms savings and investment?
For a samgyupsal grill box business, provide the ff. COMPETITOR ANALYSISWho are my current competitors? What is their market share? How successful are they? What are their strengths? What are their weaknesses?
1.a)Traditional women business owners areSelect one:O a. neither committed to entrepreneurial ideas nor to traditional gender roles.O b. highly committed to entrepreneurial ideas, but not to traditional gender rolesO c. highly committed to entrepreneurial ideas and the acceptance of entrepreneurial gender roles.O d. not committed to entrepreneurial ideas, but have high attachment to traditional gender roles. 1.b)Bills payable and promissory notes are negotiable instruments and are used mostly to replace_____Select one:O a. financial meansO b. term loansO c. long-term creditO d. trade creditO e. overdraft facilities
______1. “entreprendre” means ___________________A. To undertakeB. To MakeC. To createD. To understand______2. Which of the following is the direct contribution of entrepreneurship to thegovernment?A. Entrepreneurship provides employment which enables employees to paytaxesB. Entrepreneurship provides goods and services which encouragesconsumers to purchaseC. Entrepreneurship adds more national income through business creationD. Entrepreneurship address the needs and wants of the government______3. Which of the following is the indirect effect entrepreneurship to the government?A. Entrepreneurship provides employment which enables employees to paytaxesB. Entrepreneurship provides goods and services which encouragesconsumers to purchaseC. Entrepreneurship adds more national income through business creationD. Entrepreneurship address the needs and wants of the government______4. The flexibility characteristics of entrepreneurs refers to ________________?A. Responds to changes if deemed…
In what ways does Traders Joe's demonstrate the importance of each reponsibility in the management process- planning, organizing, leading, and controlling?

SEE MORE QUESTIONS

Recommended textbooks for you

Management, Loose-Leaf Version

Management

ISBN:

9781305969308

Author:

Richard L. Daft

Publisher:

South-Western College Pub

Management, Loose-Leaf Version

Management

ISBN:

9781305969308

Author:

Richard L. Daft

Publisher:

South-Western College Pub

SEE MORE TEXTBOOKS