excel Spreadsheet

102-109 Business Analytics Furniture and Tip Activity The following exercises should be sketched out on paper prior to using an Excel spreadsheet to gain an understanding of the problem. This will help you organize the problem and have the correct formulas before you enter the information into Excel. Create a solution to each exercise on a separate worksheet within the same Week 6 Module workbook. Name the worksheets according to the name of the exercise. Open the Module 6 Workbook Student Data File workbook and complete EX A and EX B sheet tabs according to the instructions below. Exercise A Mastering Excel, Gipps, 2007) Select the EX A sheet tab within the workbook. At Ashley's Discount Furniture Store, Steve, the owner, marks furniture at twice his wholesale cost plus $100 If you bargain with him, he'll drop the price as much as 15%. Create a worksheet that allows you to enter the furniture type (input) and wholesale cost (input) and then calculates the list price (output) and the best discount price (output). Use assumptions for the numbers underlined and in bold above as these could change in the future. When writing your formulas, your cell reference to your assumptions should be an absolute reference. Follow the instructions below: 1. Create a worksheet with inputs for: a Furniture type (*You can create this for five different types of furniture (sofa, lamp, etc.). b. Wholesale cost of each furniture type 2. The worksheet should calculate two quantities (outputs) for each type of furniture: a. List price b. Best discount price 3. Test the worksheet using different furniture types and costs to make sure the outputs are calculating properly. 4. Submit for accuracy grading (do not forget to complete all the necessary formatting as described on side 2 of the Creating & Formatting handout) ***Before beginning in Excel, sketch your plan on a piece of paper. This is good practice and will help in the design of your worksheet. Exercise B

this does NOT need to be sketched out first, only need excel table format.

no sketch is needed

102-109 Business Analytics Furniture and Tip Activity The following exercises should be sketched out on paper prior to using an Excel spreadsheet to gain an understanding of the problem. This will help you organize the problem and have the correct formulas before you enter the information into Excel. Create a solution to each exercise on a separate worksheet within the same Week 6 Module workbook. Name the worksheets according to the name of the exercise. Open the Module 6 Workbook Student Data File workbook and complete EX A and EX B sheet tabs according to the instructions below. Exercise A Select the EX A sheet tab within the workbook. At Ashley's Discount Furniture Store, Steve, the owner, marks furniture at twice his wholesale cost plus $100 If you bargain with him, he'll drop the price as much as 15%. Create a worksheet that allows you to enter the furniture type (input) and wholesale cost (input) and then calculates the list price (output) and the best discount price (output). Use assumptions for the numbers underlined and in bold above as these could change in the future. When writing your formulas, your cell reference to your assumptions should be an absolute reference. Follow the instructions below: 1. Create a worksheet with inputs for: a. Furniture type ("You can create this for five different types of furniture (sofa, lamp, etc.) b. Wholesale cost of each furniture type 2. The worksheet should calculate two quantities (outputs) for each type of furniture a. List price b. Best discount price 3. Test the worksheet using different furniture types and costs to make sure the outputs are calculating properly. 4. Submit for accuracy grading (do not forget to complete all the necessary formatting as described on side 2 of the Creating \& Formatting handout) - Before beginning in Excel, sketch your plan on a piece of paper. This is good practice and will help in the design of your worksheet