1. Pool Dimensions and Features The data given contains the case you will initially evaluate. The lengths and widths are given in linear feet (LF) and are the actual size of the pool. All costs associated with the building of the pool are outlined below. (0-4 pts) In Cell A7 : Calculate the Pool Area using cell references. (0-4 pts) In Cell B7 : Calculate the Pool Perimeter using cell references. (0-4 pts) In Cell C7 : Calculate the Pool Volume using cell references. Convert your cubic feet to cubic yards, there are 27 cubic feet per cubic yard. 2. Component pricing To calculate the cost of each pool option, use the list of construction components detailed below. Some items are priced based on the square footage (SF) - area of the pool, area of the decking, or entire area (pool + deck). Some items are priced based on linear footage (LF) - perimeter of the pool area - and some items are priced by unit (each). You will be calculating the cost of each component using the quantities and pricing given. USE CELL REFERENCES IN ALL CALCULATIONS UNLESS THE SPREADSHEET DOES NOT INCLUDE A CELL REFERENCE WITH THE VALUE NEEDED FOR THE CALCULATION. (0-4 pts) In Cell F9 : Excavation - The cost to excavate the hole required for this pool is estimated based on the pool volume using the pool length * width * maximum depth. It costs $4.00 per cubic yard (CY) to dig this hole. Therefore you will multiply the volume in cubic yards in cell B9 by the cost per cubic yard in cell D9. (0-4 pts) In Cell F10 : Pool Structural Framing The cost per square foot of this framing is $5.00/SF. Multiply the framing square feet given in cell B10 by the cost in cell D10. (0-4 pts) In Cell F11 : Filtration System, Water Hookup and Drainage- The cost of filtration is $10,970. Use cell references in B11 and D11 to calculate the cost in F11. (0-4 pts) In Cell F12: Pool Lining The cost of the pool lining is $68,160. Use cell references in B12 and D12 to calculate the cost in F12. (0-4 pts) In Cell F13: Deck The cost of the deck is $11,475. Use cell references in B13 and D13 to calculate the cost in F13. (0-4 pts) In Cell F14: Diving Board one type of diving board is offered at the cost of $475/each. Use cell references in B14 and D14 to calculate the cost in F14.

fx A B D E F G G H 1 J K L 1 ABC Pool Company--Quote Pool Dimensions/Features 2 3 4 Length - FT 100 Width-FT 40 Depth-FT 12 5 Pool Area Pool Perimeter Basic Calculations Pool Volume Cubic yards 6 7 48,000 Given 27 cu ft/cu yd 8 Cost Estimate 9 Excavation volume 10 - (sf) Given framing = pool perimeter * pool depth /2 11 Framing Filtration Lining 1 $ 4.00 per CY $ 5.00 per SF $ 10,970.00 each $ 68,160.00 each $ 11,475.00 each 12 1 13 Deck 1 14 1 $ 475.00 each Diving Board Total Costs 15 16