devry BIS155 final exam 2015 spring

Question

devry BIS155 final exam 2015 spring

Question # 00097631 Posted By: spqr Updated on: 08/28/2015 07:35 AM Due on: 09/12/2015

Subject Business Topic General Business 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.

Rating:

4.9/5

Tutorials for this Question

Recent Feedback

Rated By	Comments	Rated On
m...rez	Tutorials helped score A+ grades	11/24/2015
en...s23	Perfect work without any grammatical error	11/22/2015
vst...nd18	Awesome tutorials	11/18/2015

Get the Solution

Great! We have found the solution of this question!

score 5 · Accepted Answer · 08/28/2015 07:35 AM

Solution: devry BIS155 final exam 2015 spring

Tutorial # 00091993 Posted By: spqr Posted on: 08/28/2015 07:35 AM

Puchased By: 5

Tutorial Preview

The solution of devry BIS155 final exam 2015 spring...

Get the Solution

Attachments

devry_BIS155_final_exam_2015_spring.docx (23.36 KB)

devry BIS155 final exam 2015 spring

Solution: devry BIS155 final exam 2015 spring

Related Questions and Answers

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

Lisa