$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

MPA14 Information Systems For Accountants

tag 0 Download4 Pages / 759 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT


Robert’s Department Store is a prestigious, upscale department store located in Chadstone Shopping Centre. The store has specialty departments for women, men, children, cosmetics, cologne, linen, furniture, and housewares. One of the reasons why Robert’s has such a fine reputation is because of its highly trained sales staff. Robert’s management believes in rewarding its sales staff for its hard work, so in addition to an hourly wage, sales representatives are paid a commission on sales above an established quota. Sales representatives are classified as either part-time or full-time. Part-time representatives are then subcategorised as sales assistants or sales partners.

Full-time representatives are subcategorised as assistant managers, sales consultants, or sales associates. Part-time representatives work 20 hours a week, while full-time representatives work 40 hours a week. Sales representatives have input into how many hours a day they work; however, they cannot work overtime. Within the company, sales representatives are ranked and paid according to their experience and tenure with the company. Sales representatives are paid a commission on all sales exceeding their established quota. As members of the sales staff may work a different number of hours on a given day, the sales quota is based on the hours worked. For instance, if a sales representative has an hourly quota of $100 in sales and he works 5 hours, then his daily sales quota is $500. For any sales above the $500 quota, the sales representative receives a commission. Figure 1 below summarises the hourly wages and established quotas.

At the end of each business day, Vasanthi prepares a Daily Productivity Report. As Figure 2 shows, the Daily Productivity Report summarises each employee’s sales activity for the day. (The data shown in Figure 2 are for illustrative purposes only. Your report format and data may vary.) This report specifies the employee’s name, rank, assigned department, daily sales, hours, base pay, commission, and gross pay. At the end of each week, Vasanthi uses the Daily Productivity Reports to prepare a Weekly Productivity Report. The Weekly Productivity Report summarises the Daily Productivity Reports. Vasanthi currently uses a word processor to prepare the reports. However, she realises that a spreadsheet application is a much better tool for the summarisation and analysis work that she needs, so she asks you to develop a Productivity workbook for her.

Vasanthi wants to use the Productivity workbook to analyse the performance of her sales staff. She specifically requests that you show her how to use the PivotTable to analyse the sales data. She wants to:

  1. compare the commissions and sales by department, and
  2. view the commissions by individuals within each department.

In addition to the information requirements specified above, Vasanthi wants answers to the following questions. Using the PivotTable, Advanced Filter and Filter tools, provide Vasanthi with answers to these questions.

  1. Which six sales representatives received the highest commissions last week
  2. Which sales representatives received commissions above average last week
  3. Excluding the Furniture Department and its employees, which sales representatives received commissions above average last week
  4. If sales staff must make their quotas at least 70 percent of the time, which sales staff did not achieve this goal
  5. For each department, which salesperson had the highest sales
  6. On average, how frequently will the sales staff make their quota
  7. What are the commissions and total sales for each sales position by department
  8. What are the base pay, commission, and gross pay categorised by sales position
  9. What are the total salaries and hours worked by department
  10. Which department’s staff met their quotas more often than other departments, and which department’s staff met their quotas least often than other departments.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Unique Document

Under Evaluation

Get Money
into Your Wallet

Total 4 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Information Systems For Accountants. Retrieved from https://myassignmenthelp.com/free-samples/mpa14-information-systems-for-accountants/productive-report.html.

My Assignment Help (2021) Information Systems For Accountants [Online]. Available from: https://myassignmenthelp.com/free-samples/mpa14-information-systems-for-accountants/productive-report.html
[Accessed 20 September 2021].

My Assignment Help. 'Information Systems For Accountants' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/mpa14-information-systems-for-accountants/productive-report.html> accessed 20 September 2021.

My Assignment Help. Information Systems For Accountants [Internet]. My Assignment Help. 2021 [cited 20 September 2021]. Available from: https://myassignmenthelp.com/free-samples/mpa14-information-systems-for-accountants/productive-report.html.

With time, MyAssignmenthelp.com has become one of the best college essay writing services. Our all rounded services give students the confidence to overcome assignment related issues. Our services are fast enough to meet most urgent deadlines. We are capable of delivering fast essay writing services with the help of our specially designed provisions and writers' teams. Our urgent essay help services guarantee most rapid delivery of assignment solutions. Some of our most popular essay services are application essay help, exploratory essay help, literary review essay help and argumentative essay help.

Latest Accounting Samples

FIN10002 Financial Statistics

Download : 0 | Pages : 4

Answer: Introduction  For the present assignment we anaIyse the salesdata on banking provided by Office Supplies Pty Ltd. The data contained information on 2000 orders, however a sample of 60 was selected from the data for the present analysis. Order id provides information of the id of the sales data. The sales data contained information on order priority, mode of delivery of the order, type of consumer as well as the number of days to ...

Read More arrow

BFA312 Management Accounting

Download : 0 | Pages : 9

Answers: Answer 1 (1): Accounting is a vast field. In order to simplify the knowledge and its application it has been divided into management accounting and financial accounting. These two are very different from each other. In the discussion below we will discuss these differences: Objectives: the objective of financial accounting is to disclose and present the financial information of the company to its stakeholders, whereas the objectiv...

Read More arrow Tags: Australia Sydney Management Management Accounting and Financial Accounting  University of Sydney MBA 

TACC401 Principles Of Accounting

Download : 0 | Pages : 10

Answer: Introduction The purpose of this report is to explore the agency costs and agency problems related to the relationships between the owner-manager and lender-manager agency using the agency theories. It can be said that Agency Theory describes the way to best organize relationships in which an individual party determines the job when another party completes the job. It is a matter of fact that in this relationship the principal employs...

Read More arrow

ACC303 Contemporary Issues In Accounting

Download : 0 | Pages : 7

Answer Introduction Caltex is seen to begin its operation in 1936 in form of California Texas Oil Company. This company has been further seen as a joint venture between Texas Company and standard oil, thereby gaining concession in Saudi Arabia. The company has been further seen with gained concessions in Saudi Arabia. It was further seen to be renamed in 1968. The parent company has been further seen to be based on the consideration of merger...

Read More arrow Tags: Australia Strathfield Management Hygiene and Toxicity University of New South Wales 

BAP22 Management Accounting

Download : 0 | Pages : 8

Answer: This report depicts the user about the concept of value chain which could be analyzed through investigating over various concepts of the value chain. Basically, in this report, a statement of value chain has been analyzed and through that various factors of value chain has also been evaluated. In this report, concept of value chain, cost estimation in the company, segment of value chain and the value chain’s main purpose has been...

Read More arrow

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

callback request mobile
Have any Query?