ABC Pool Company

Congratulations, you$$ve just started your new job as sales manager for a mid$-$size pool company operating

on the west coast. ABC Pool Company is the leader in supplying and installing quality in$-$ground pools for

residential and commercial customers. One of the first projects you$$d like to tackle is to assist your sales

staff in providing customers with fast, reasonable estimates for potential pool installations. To do this

you$$d like to setup an estimating workbook that outlines inputs and costs for the most common pool

type$/$size configuration. Download the Excel start file to begin your work. Data given in the spreadsheet

is shaded gray. You will be providing proper formulas for the remaining data in the un$-$shaded cells by

answering the following questions using formulas and cell references from this worksheet. You will input

your formulas in the spreadsheet, NOT in this file. Remember to start all formulas with an equal $(=)$ sign

and to always use cell references.

$$ All of the basic pool specifications have already been input for you on the spreadsheet.

o You will use these inputs to calculate each component cost. See next page.

o Your calculations will be in cells A$7$:C$7$ and in cells F$9$:F$15.$

o All the other cells will be input for you.

If your calculations are correct, the total pool costs should be $$106,591\mathrm{.}11$

Width of Deck Area

Pool

Pool Length

Pool Width