Open Always
Email: support@globalcompose.com Call Now! +1-315 515-4588
Open Always
Email: support@globalcompose.com Call Now! +1-315 515-4588

BUAD 2020 Information Technology Management

Assignment Writing Help

This assignment question was recently posted by one of our customers and shared with our professional writers. If you are looking for assignment help on this topic or similar topic, click on ORDER NOW button to submit your details. Once we have your order details, your assignment will be assigned to one of our best writers, who will then proceed to write your paper and deliver it within your specified deadline. Thank you for choosing us today!

BUAD 2020 Information Technology Management

BUAD 2020 Information Technology Management
Assignment #1 – Using Excel’s Functions for Data Analysis
Due: Check Blackboard Course Site for Due Date
Case Background:
You have been hired by John McDougal, sales manager of Macy’s Franklin Park store, to help
him better understand the productivity of his sales force.
Mr. McDougal has provided you with a download from
the POS system that contains the employee name, rank,
department, sales and hours worked. That data is
provided to you in the file named
A1_MacysDeptStore.xlsx (and is available for download
on Blackboard – under the assignment course link) and
looks similar to the image below.
Mr. McDougal would like you to produce a series of reports that will let him know how well the
sales force is performing – where performance is defined by how many employees meet their
targeted sales quotas and the overall percentage of the sales quota obtained by the cumulative
efforts of all salesmen.
Mr. McDougal has identified two ways that he would like the analysis of each week presented.
Each part is detailed below.
Part 1: Mr. McDougal would like a weekly recap of sales by salesman that displays information
regarding weekly sales, the salesman’s sales quota, the percent of the quota met, number of
hours worked, base pay earned, commission due and the salesman’s gross pay for the week
under review. He put together a sample of how he would like the report to look – use this
layout – or your best judgement to produce a well laid out and easy to understand report.
Notice the report includes the name in the format of Last, First. You will need to use some text
functions to display the concatenated data. Also – note the sales column (“E”) in the raw data
is a text (string) value that will need to be converted to a number.
Assignment #1 – Using Excel’s Functions for Data Analysis
2
The other formulas required to produce this detail report will need to pull information from a
table of hourly wages and quotas that Mr. McDougal has provided to you.
Each employee is assigned a “Rank” within the sales force. Macy’s has 5 different ranks. The
employee’s base pay and commission rate is dependent upon the rank assignment. For
example, a rank of AM indicates an Assistant Manager who is paid $23.50 per hour, is expected
to produce $200.00 of sales for each hour that he/she works and is paid a commission on his
sales, if he/she meets the hourly sales quota for the week. A table of values is displayed below:
Hourly Wages & Quotas
Sales
Rank Sales Title Hourly Wage
Hrly Sales
Quota
Commission
Rate
AM Assistant Manager $ 23.50 $ 200.00 3.0%
PT1 Sales Assistant $ 10.50 $ 100.00 1.0%
PT2 Sales Partner $ 11.75 $ 125.00 1.5%
S1 Sales Associate $ 13.50 $ 150.00 2.0%
S2 Sales Consultant $ 15.00 $ 175.00 2.5%
 Target Sales is calculated by multiplying the hours worked times the hourly sales quota of the
designated Sales Rank.
 % of Target is calculated by dividing Sales by Target Sales.
 Base Pay is calculated by multiplying the hours worked times the hourly wage.
 Commission is calculated for employees whose Sales exceeds their Target Sales – by multiplying
the weekly sales amount times the commission rate that corresponds to the employee’s Sales
Rank.
 Gross Pay is the sum of Base pay and Commission.
The report should be sorted to make it easy to identify the “best” salesperson – defined by the % of
target column.
Part 2: Mr. McDougal would also like a summary report that will display the counts, sales and quotas
(targets) by Rank.
Assignment #1 – Using Excel’s Functions for Data Analysis
3
Put the Excel skills taught thus far to produce the requested information for Mr. McDougal. Write (and
leave) formulas on the Raw Data worksheet to convert data, as needed. Copy and paste (AS VALUES)
the data from the Raw Data worksheet onto your Reporting worksheet. You may need to seek out
additional functions (not covered) to manipulate the downloaded text data and produce the information
in the requested arrangement. Insert worksheets within the workbook supplied to build your solution
and present the required information.
Use absolute addressing, VLookup, IF, Count, CountIF, SumIF, and various text functions to create your
solution. Create a solution that would work with this or another similar data set. Do NOT go into the
data and modify it by hand – and do not use Pivot Tables in this assignment. Create formulas to lookup,
calculate and display the requested information.
Pay attention to formatting, column widths, headings, and other visual aids to produce easily consumed
information.
Attention: No late work accepted.
Assignment Deliverables:
 Submit your Excel workbook to the Blackboard Assignment #1 Course Link
 Turn in a hardcopy of both reports in class on the due date. Use a reasonable “Print to Fit”
layout so that your reports are easily read.
 Include, as cover page, a printed version of the final page of this assignment document. This will
be used as a Grading Rubric to communicate details of your grade on this assignment back to
you. Only the total score earned for the assignment will be posted to Blackboard.h they were born?

Academic Writing Help

All writing formats, 24/7 customer support via live chat, email or phone number, and timely delivery guaranteed.

Are you looking for homework writing help? Click on Order Now button below to Submit your assignment details.

Homework Writing Help
We Can Help you with this Assignment right now!

Are you looking for homework writing help on this topic? This question was posted by one of our client seeking homework help.  If you are therefore looking for an assignment to submit, then click on ORDER NOW button or contact us today. Our Professional Writers will be glad to write your paper from scratch, and delivered within your deadline. Perfect choice for your excellent grades! www.globalcompose.com.

 

We ensure that assignment instructions are followed, the paper is written from scratch. If you are not satisfied by our service, you can either request for refund or unlimited revisions for your order at absolutely no extra pay. Once the writer has completed your paper, the editors check your paper for any grammar/formatting/plagiarism mistakes, then the final paper is sent to your email.

Privacy| Confidentiality

We do not share your personal information with any company or person. We have also ensured that the ordering process is secure; you can check the security feature in the browser. For confidentiality purposes, all papers are sent to your personal email. If you have any questions, contact us any time via email, live chat or our phone number.

Our Clients Testimonials

  • I appreciate help on the assignment. It was hard for me but am good to go now

    Impact of pollution on Environment
  • Am happy now having completed the very difficult assignment

    Creative Message Strategies
  • Your writer did a fine job on the revisions. The paper is now ok

    Ethics: Theory and Practice
  • The paper was so involving but am happy it is done. Will reach you with more assignments

    Title: Privatization in or of America
  • I expected perfection in terms of grammar and I am happy. Lecturer is always on our head but was pleased with my paper. Once again, thanks a lot

    Title: Bundaberg Inquiry
  • The paper looks perfect now, thank to the writer

    Health Care Systems
  • You helped me complete several other tasks as you handled paper. wonna thank you

    Critique Paper on Political Change

Related Articles

Annotated bibliographies on a public policy issue

Please pick one topic and write 4 separated annotated bibliography using 4 different sources ( 2 must be scholarly sources). I order 2 pages so please use each page to...
Read More

Get more from us…

Would you like this sample paper to be sent to your email or would you like to receive weekly articles on how to write your assignments? You can simply send us your request on how to write your paper and we will email you a free guide within 24-36 hours. Kindly subscribe below!

Email Address: support@globalcompose.com