Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
As a qualified BAS Agent, you have been asked by one of your newly acquired clients, Mr Xavier Samuel to assist him with his business. He wants to keep a spreadsheet for each month's sales. He has five sales staff and would like to record the daily sales figure. He wants to see a monthly total for each person and a daily sales total. He would also like an average daily sale, the lowest sales figure, and the highest sales figure for each day. The data should have highlighted to show figures below the daily average and figures above the average. There should be a separate worksheet that shows a commission figure for each salesperson daily. He pays each person a flat 15% of everything they sell as a commission. Mr Samuel thinks a template for the above spreadsheet would help him because he will crate a new spreadsheet every month. Then he would like a master spreadsheet that shows each person's monthly sales figure. He would like to have an annual total for each and a grand total. He would like a chart showing each person my month and another chart that shows each person's annual sales figure as a part of the total sales figure. Mr Samuel has provided you with January's sales figures for each staff member to input into your spreadsheet as follows.
Date
$ Staff No 1
$ Staff No 2
$ Staff No 3
$ Staff No 4
$ Staff No 5
01 Jan
3,000
8,000
1,000
2,000
2,200
02 Jan
200
1,500
03 Jan
2,500
2,980
04 Jan
3,500
1,780
05 Jan
4,000
06 Jan
07 Jan
750
08 Jan
6,000
09 Jan
10 Jan
11 Jan
12 Jan
13 Jan
14 Jan
1,900
15 Jan
16 Jan
17 Jan
18 Jan
19 Jan
20 Jan
21 Jan
22 Jan
23 Jan
24 Jan
25 Jan
6,600
26 Jan
27 Jan
1,100
28 Jan
29 Jan
30 Jan
31 Jan
Layout instructions for Part C:
-Identify the difference between occasional negative emotions and more serious mental health issues, such as anxiety disorder or depression.
Your company is experiencing decline in business because of competition. In your discussion, explain what is E-Commerce and Mobile Technology.
1. E-learning programmes are MOST useful and effective when:
What is corporate parenting? Discuss the various value adding roles played by a corporate parent
Why do you think it would be important to have a well-trained spokesperson speak for the corporation during a crisis such as this one? Why is the "head and heart" principle important for a spokesperson during a crisis?
Choose the organization in which you are familiar. Create the 1050 to 1400 word paper in which you estimate the organizing function of management as it associates to at least two of following organizational resources.
Why is supply chain management important to an organization?
Bill is the Operations Manager at Bonzo Chemical Manufacturing Company. One of his leaders have suggested that it might be valuable to measure productivity in the operations. What would you tell Bill about how to measure productivity in his operation..
What are the reasons of failure in Digital Business?
Who is responsible to for an employees career path the employee or the employer?
What association establishes rates for international air carriers (with a few exceptions) and regulates service competition?
Describe the core values of the organization. Why are these specific values important to the organization? Describe the benefits and purpose for an organizational vision statement.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd