Devry BIS155 final exam

08 Jun Devry BIS155 final exam

Posted at 08:32h in Essay Writing Services by Blogger

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)

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Writedemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Print page