When starting the Philly Landscape Excel assignment, what can do I take in account to get a formula? What are the key detail to look at when beginning this assignment? What formula or procedures would be beneficial?

 

 

Transcribed Image Text:

C B B B B Copyright page B B B TestOut LabSim B + eBook: Problem Solving Cases In Microsoft Access & Excel Cover Brief Contents Preface Case 6 - Philly Landscaping What X ebooks.cenreader.com/#!/reader/2ecdc986-6b43-4976-99c9-dfd29cfb3ec3/page/page-c5e45ed9-1956-49f4-86d8-a9044aa7de80 Part 1: Database Cases Using Access Part 2: Decision Support Cases Using Microsoft Excel 91 Scenario Manager Case 6: Philly Landscaping Tutorial C: Building a Decision Support System in 93 Excel Case 7: The Electric Car Financial Analysis Part 3: Data Analysis Cases in Microsoft Access and Excel Part 4: Decision Support Case Using Basic Excel Functionality Part 5: Integration Cases Using Microsoft Access and Excel Part 6: Advanced Skills Using Excel Part 7: Presentation Skills Index V viii Type here to search 115 123 133 165 177 197 215 Jump to Page 117 / 256 237 Calendar PREVIOUS PAGE 116 How to Save a Screenshot as a P X eBook: Problem Solving Cases In Microsoft Access & Excel 3' My Home In summary, your DSS will include the following inputs: Customer base change percentage Annual repayment of the loan Annual income required for retirement . X Your DSS model must account for the effects of the preceding inputs on the Calculations section. If you design your model well, it will let you develop "what-if" scenarios with all inputs, see the results, and allow Steve to make a decision about his retirement. ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT In this assignment, you will produce a spreadsheet that models Philly Landscaping's estimated 2017 revenues, expenses, and profits; provides forecasts of 10 years of cash flows for the company; and allows for the input of other variables to answer Steve's questions. In Assignment 2, you will use your spreadsheet to gather data and then write a memorandum that documents your analysis and findings. In Assignment 3, you will prepare and give an oral presentation of your analysis and conclusions to Steve. First, you need to create the spreadsheet model based on your conversations with Steve and your understanding of the questions he would like to have answered. The model will cover 11 years-2017 as the base year and 10 subsequent years as requested by the bank to provide estimated cash flows. This section helps you set up each of the following spreadsheet components before entering cell formulas: PHILLY LANDSCAPING CONSTANTS Constants Inputs Summary of Key Results Calculations Ebooks - Webreader.io A discussion of each section follows. The spreadsheet skeleton for this case is available for you to use; it will save you time. To access the spreadsheet skeleton, go to your data files, select Case 6, and then select Philly Landscaping.xlsx. Constants Section Your spreadsheet should include the constants, otherwise known as assumptions, shown in Figure 6-1. An explanation of the line items follows the figure. Prices Rough Yard Work per Square Foot Gutter Cleaning per Linear Foot Power Washing per Square Foot Lawn Mowing and Edging per Square Foot Driveway Seal Coating per Square Foot Fall Leaf Clearing per Square Foot Snow Removal per Square Foot Customer Base Customers Costs Average Cost of Labor and Materials Average Lawn Surface (Sq Ft) Average Power Washing Surface (Sq Ft) Average Gutter Length (Linear Ft) Average Snow Removal Surface (Sq Ft) Average Driveway Seal Coating Surface (Sq Ft) Average Fall Leaf Clearing Surface (Sq Ft) Economic and Environmental Factors Tax Rate FIGURE 6-1 Constants section S S S $ $ S S X 2017 0.003 0.075 0.050 0.001 0.100 0.003 0.025 + 0.30 850 43,560 5,000 150 2,500 2,500 43,560 25% Copyright 2018 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-300 TT Q Quick Tour Print Search Annotations Accessibility Bookmark 82F Sunny I NEXT PAGE 4) 118 3:59 PM 4/28/2022 : x C B B B B Copyright page B B B TestOut LabSim B + eBook: Problem Solving Cases In Microsoft Access & Excel Cover Brief Contents Preface Case 6 - Philly Landscaping What X ebooks.cenreader.com/#!/reader/2ecdc986-6b43-4976-99c9-dfd29cfb3ec3/page/page-c5e45ed9-1956-49f4-86d8-a9044aa7de80 Part 1: Database Cases Using Access Part 2: Decision Support Cases Using Microsoft Excel 91 Scenario Manager Case 6: Philly Landscaping Tutorial C: Building a Decision Support System in 93 Excel Case 7: The Electric Car Financial Analysis Part 3: Data Analysis Cases in Microsoft Access and Excel Part 4: Decision Support Case Using Basic Excel Functionality Part 5: Integration Cases Using Microsoft Access and Excel Part 6: Advanced Skills Using Excel Part 7: Presentation Skills Index V viii Type here to search 115 123 133 165 177 197 215 Jump to Page 117 / 256 237 Calendar PREVIOUS PAGE 116 How to Save a Screenshot as a P X eBook: Problem Solving Cases In Microsoft Access & Excel 3' My Home In summary, your DSS will include the following inputs: Customer base change percentage Annual repayment of the loan Annual income required for retirement . X Your DSS model must account for the effects of the preceding inputs on the Calculations section. If you design your model well, it will let you develop "what-if" scenarios with all inputs, see the results, and allow Steve to make a decision about his retirement. ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT In this assignment, you will produce a spreadsheet that models Philly Landscaping's estimated 2017 revenues, expenses, and profits; provides forecasts of 10 years of cash flows for the company; and allows for the input of other variables to answer Steve's questions. In Assignment 2, you will use your spreadsheet to gather data and then write a memorandum that documents your analysis and findings. In Assignment 3, you will prepare and give an oral presentation of your analysis and conclusions to Steve. First, you need to create the spreadsheet model based on your conversations with Steve and your understanding of the questions he would like to have answered. The model will cover 11 years-2017 as the base year and 10 subsequent years as requested by the bank to provide estimated cash flows. This section helps you set up each of the following spreadsheet components before entering cell formulas: PHILLY LANDSCAPING CONSTANTS Constants Inputs Summary of Key Results Calculations Ebooks - Webreader.io A discussion of each section follows. The spreadsheet skeleton for this case is available for you to use; it will save you time. To access the spreadsheet skeleton, go to your data files, select Case 6, and then select Philly Landscaping.xlsx. Constants Section Your spreadsheet should include the constants, otherwise known as assumptions, shown in Figure 6-1. An explanation of the line items follows the figure. Prices Rough Yard Work per Square Foot Gutter Cleaning per Linear Foot Power Washing per Square Foot Lawn Mowing and Edging per Square Foot Driveway Seal Coating per Square Foot Fall Leaf Clearing per Square Foot Snow Removal per Square Foot Customer Base Customers Costs Average Cost of Labor and Materials Average Lawn Surface (Sq Ft) Average Power Washing Surface (Sq Ft) Average Gutter Length (Linear Ft) Average Snow Removal Surface (Sq Ft) Average Driveway Seal Coating Surface (Sq Ft) Average Fall Leaf Clearing Surface (Sq Ft) Economic and Environmental Factors Tax Rate FIGURE 6-1 Constants section S S S $ $ S S X 2017 0.003 0.075 0.050 0.001 0.100 0.003 0.025 + 0.30 850 43,560 5,000 150 2,500 2,500 43,560 25% Copyright 2018 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-300 TT Q Quick Tour Print Search Annotations Accessibility Bookmark 82F Sunny I NEXT PAGE 4) 118 3:59 PM 4/28/2022 : x