BIS155 Week 2 Lab – Perfect solution – instant delivery

Lab Price = $9
Please feel free to send us your queries at: support@iqrajavaid.com
Payment methods

Add to Cart

Buy Now

View Cart


Problem Statement

Week 2: Lab Overview
TABLE OF CONTENTS

Lab Overview
Scenario/Summary
Management at Summit Ridge Mountain Resort is very pleased with your initial report. This week, management has asked that you add to the prior analysis and incorporate some visual images concerning the Village Shop sales. This new analysis will require the use of new formulas, new functions, and several charts to graphically depict the report findings. This updated Excel workbook will be used for a presentation to the board of directors.
Deliverables
Submit one workbook to the Lab submission page. When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity.
File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week2_Lab.xlsx.
Make certain you compare your finished work with the Grading Rubric available on the Lab submission page.
Lab Resources
Microsoft Office: Excel 2016
Options for Accessing Microsoft Excel 2016
1. Use a personal copy on your PC. You can request a copy of Microsoft Office 2016 via the Student Software Store icon on the Course Resources page.
2. If you are a MAC user, click to read the MAC User Information.
3. If you do not have Excel 2016 installed locally, then access the software by going to the Course Resources page, Lab Resources section, and click the Virtual Lab Citrix icon.
Lab Steps
Preparation
This lab will use Microsoft Excel 2016.
Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin the lab. The videos provide detailed examples that walk you through steps similar to those you will be completing in the week’s lab. Completing the hands-on exercise examples will provide both practice and instruction to help you complete the lab steps successfully.
Your final assignment workbook should include six worksheets (Documentation, Sales Data, Daily Item Totals, Total Items Bar Chart, Percent of Sales Pie Chart, and Profits by Day Line Chart).
To begin, open the Week 1 Lab you submitted last week and make any corrections or modifications.
Save this as a new Excel workbook named Doe_J_Week2_Lab.xlsx.
Follow the lab steps below to create formulas, utilize functions, and add charts to graphically depict the sales over time and by product.
Step 1: Create Daily Item Totals Worksheet
Click on the Sales Data worksheet. We need to see all of the hidden data, so unhide all hidden columns. Once you can see all the hidden data, we need to select data to copy to a new worksheet. Sort your data in A to Z order. Select the accessories data in column A, hold your control key down, and then select the daily sales data in columns D through M. Copy this selected data to a new sheet.
Click on the Image to Expand

A. The Daily Sales data will look as follows on the new worksheet. Please name the tab for this worksheet Daily Item Totals.
Click on the Image to Expand

Create daily totals using the SUM function for each day and for each item. Make these pronounced by adding a bold font and some color formatting.
Click on the Image to Expand

B. Let’s add a formula to calculate the percentage of sales for each item in column M. Percent of sales can be determined by dividing the total of each item (L4) by the total of all items (L17).
C. Add functions to determine the best sale item, the lowest sale item, and the average of all sale items.
D. Last, add a column called Profit per Item. Subtract the cost of the item from net selling price and place it in column N.
Click on the Image to Expand

Step 2: Create the Total Items Bar Chart
A. Using the Daily Item Totals sheet, select the accessories data in column A, hold your control key down, and then select the Total Items Column L. While this data is selected, click the Insert tab on the ribbon. Choose a 2-D Bar Chart.
B. Move this chart to a new worksheet.
C. Your chart needs a professional title, and the worksheet tab should also be named appropriately.
Horizontal Bar Chart
Step 3: Create the Percentage of Sales Pie Chart
A. Using the Daily Item Totals sheet, select the accessories data in column A, hold your control key down, and then select the Percent of Sales Column M. While this data is selected, click the Insert tab on the ribbon. Choose a 3-D Pie Chart.
B. Move this chart to a new worksheet.
C. Your chart needs a professional title, and the worksheet tab should also be named appropriately.

Pie Chart
Step 4: Create 10-Day Sales Report & Line Chart
A. Copy the Daily Sales data to a new worksheet.
B. Calculate the profit per item. Subtract the cost of the item from the net selling price and place it in column L.
C. Next, create a new area on the same worksheet and calculate the profits for each item. For example, the profits for gloves in cell B19 are calculated as B3 * $L3.
D. Autofill all item profits and create totals.
E. Lastly, select the dates across the horizontal, hold down the control key, and select the daily totals along the bottom. Insert a Line Chart like below.
F. Give the chart a title, but leave it on the same worksheet.
Profits by Day Line Chart
Step 5: Professional Appearance (Cleanup)
Cleanup the formatting of your Excel workbook, taking into account professional appearance.
The Minimum Requirement (per the Grading Rubric)
A. Apply a color and assign a descriptive name to each tab (sheet) in the workbook.
B. Update the documentation worksheet to include contents of each worksheet.
C. Make certain to include a custom page header on the Sales Data worksheet with your name and your instructor’s name.
D. Set the page orientation to landscape.

Remember, professional appearance doesn’t only promote better readability of your report but represents you as a professional.
Finish: Save and Submit
Save your Excel file. Saving your file often is good practice (Ctrl + s).
Your Excel file should contain six worksheets.
• Documentation
• Sales Data
• Daily Item Totals
• Total Items Bar Chart
• Percent of Sales Pie Chart
• Profits by Day
Submit one workbook. When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity.
File naming convention: If your name was Jane Doe, then your file would be named Doe_J_Week2_Lab.xlsx

Relevant Material
Screenshots
Week 2: Preview
Week 2: Preview
Instructions
* If you want to purchase multiple products then click on “Buy Now” button which will give you ADD TO CART option.Please note that the payment is done through PayPal.
* You can also use 2CO option if you want to purchase through Credit Cards/Paypal but make sure you put the correct billing information otherwise you wont be able to receive any download link.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at support@iqrajavaid.com.
* As soon as the payment is received, download link of the solution will automatically be sent to the address used in selected payment method.
* Please check your junk mails as the download link email might go there and please be patient for the download link email. Sometimes, due to server congestion, you may receive download link with a delay.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at support@iqrajavaid.com and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please wait for atleast 8 hours for a response from our side. Afterall, we are humans.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at support@iqrajavaid.com.
* MOST IMPORTANT Please use the tutorials as a guide and they need NOT to be used for any submission. Just take help from the material.
******************************************** Good Luck ***************************************************
Privacy Policy
We take your privacy seriously and will take all measures to protect your personal information.
Any personal information received will only be used to fill your order. We will not sell or redistribute your information to anyone.
Refund Policy
Incase you face any issues with the tutorial, please free to contact us on support@iqrajavaid.com
We will try our best to resolve the issue and if still persists we can discuss for a refund in case its required.
Payment Details
Lab Price = $9
Please feel free to send us your queries at: support@iqrajavaid.com

Payment methods

Add to Cart

Buy Now

View Cart

Leave a Reply