Devry BIS155 final exam August 2015

Question

Devry BIS155 final exam August 2015

Question # 00097073 Posted By: neil2103 Updated on: 08/26/2015 11:49 AM Due on: 08/31/2015

Subject Computer Science Topic General Computer Science Tutorials:

Question

Question 1.1.(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours.

Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification.

Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula so that it may be copied to the other employees without modification.

Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification.

Part 4: Salaried and Exempt employees (Pay Codes E and S) are covered by the company’s health insurance. The deduction is $10.00 per week. Write a formula as if it were in Cell H2 that calculates the Insurance deduction (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification. (Points : 40)

Question 2.2.(TCO 3) Your supervisor has e-mailed you a workbook that contains a lot of very important data. He wants you to create a chart or charts to be displayed to upper management who will make major business decisions based on your presentation. Explain what kind of analysis is best summarized by each of the six basic chart types.(Points : 40)

Question 3.3.(TCO 4) Jessica is an entry point student at DeVry University. In her BIS155 class, she has been provided a table including customer and sales data from an online e-business selling bait and tackle for both fresh and saltwater fishing. The layout of the table is organized with customer names in column A, purchase items in column B, purchase prices in column C, and phone numbers in column D. To assist Jessica, you as a tutor, agreed to help her with the following questions below:

If asked to provide a sales report for one specific customer including all purchase items in the report, which Excel function or tool should be used and why?
If asked to provide a sales report of all customers summarized to the level of totaled purchase prices, which Excel function or tool should be used and why?
If asked to visually represent the answer to question “2,” which Microsoft Excel tool should be used and why?
Would a Pivot table be feasible based on the table of data provided to Jessica? Why or why not?

(Points : 40)

Question 4.4.(TCO 5) Michael and Sally own 89 ice cream shops across the southeastern United States. In efforts to manage sales data collected from these ice cream shops, Michael and Sally currently have several workbooks developed with the same purpose and structure but with so much information, Michael and Sally need help consolidating this data for more efficient decision making. Given the needs of Michael and Sally, describe in detail how you would explain to Michael and Sally how to use Excel to develop and produce summary reports with consolidated sales data displaying periods of weekly, monthly, and quarterly reports along with visual options to trend and compare data across all ice cream shops. Be sure to include sample Excel formulas. Also, explain in detail the benefits of using consolidated summary reports in the decision making process. (Points : 40)

Question 5.5.(TCO 9) You have been provided an Access database that contains sales data for the past five years for a florist. The data has information about the date of transaction, client name, client zip code, products purchased, and product price. You have been tasked to provide a few reports to the owner of the business.

Explain the steps to import the data from Access into Excel for data analysis.
Due to the high amounts of perishable inventory over the last year, the owner would like to eliminate five products. Provide the steps in your data analysis to determine the appropriate products to eliminate.
The owner would like to increase marketing during slower periods of the year. Because flower sales are seasonal, the owner does not know the best times of year to increase marketing to attract more customers when business is slower. Provide the steps in your data analysis to determine the best times of the year to increase marketing.
How would you report your findings to the owner to Parts 2 and 3? Assume that the owner is visual and does not want to look over a worksheet of data.

(Points : 40)

Rating:

4.9/5

Tutorials for this Question

Recent Feedback

Rated By	Comments	Rated On
ajc...nics	Improve academic performance	01/19/2016
so...grl	Payment modes are easy and secure	01/19/2016
n...22	Great quality and professional work	09/28/2015

Get the Solution

Great! We have found the solution of this question!

score 5 · Accepted Answer · 08/26/2015 12:14 PM

Solution: Devry BIS155 final exam August 2015

Tutorial # 00091704 Posted By: neil2103 Posted on: 08/26/2015 12:14 PM

Puchased By: 5

Tutorial Preview

The solution of Devry BIS155 final exam August 2015...

Get the Solution

Attachments

Question_7.docx (23.36 KB)

Devry BIS155 final exam August 2015

Solution: Devry BIS155 final exam August 2015

Related Questions and Answers

Whatsapp our consultant to discuss your concerns happy to help :)

Lisa