(4)Your quote for the costs of cleaning the heating ducts (registers and associated ductwork) is based on the estimated number of total registers in your home (dim!L11). Write an Excel formula in cell cale!C3, which can be copied down the column, to detemine cost of cleaning your ducts for the corresponding room. Remember you have two possible pricing schemes both based on the total number of ducts in your home. The scheme you will use is the minimum cost scheme that your fomula should detemine automatically. I Hint: You may lookup the corresponding cost (per register) from the array price B10:E12 dim- C F G K Number of Registers A Type of Purpose Floor |aet |cet car Number of Light Fixtures Windows Room Width Feet Height Feet Number of Room Lengthe Area SF 131.7 81763 2303 3083 8 Inches 2 Area 3 bedroom1 4 bedroom2 5 bedroom3 6 Iving room Feet Inches 10 15 13 15 12 private private private public 7 dining room public public 3 1 12 1 11 21 20 5 1 17 2 0 5 2 12 1 1 12 1440 8 kitchen 9 bath1 10 bath2 11 totals 12 6 vin private public 15 18 2821 2 1 ol 5 tile tile 6 46.8 8 358 1355.2 0015 001 6 8 1 6 6 5 6 1 1 price logic A B C D E Analysis: E A B 1 Cleaning: 2 Floors Carpet 4 Price/Unit Unit 1 Within 10% of Budget FALSE FALSE FALSE FALSE TRUE FAL SE TRUE FALSE Over Budget TRUE FAL SE FAL SE FALSE TRUE FALSE FALSE FALSE $/SY $/SF $/SF $leach S/each 2 Room 3 bedroom 4 bedroom2 5 |bedroom Purpose private private private 6 living room public 7 dining room public S Budget $100.00 $ 200.00 S 300.00 $ 500.00 $ 200.00 3 5.00 Tile 125 1.00 All other Floor types 6 Windows 7 Light Fixtures 8 5 25.00 1250 8 kitchen 9 bath1 10 bath2 11 totals public private public 500.00 10 #Registers in Home 11 Cost per Register Bid#1 12 Cost per Register Bid#2 $ 20 $ 125.00 $ 100.00 $2,025.00 10 21 $ 19 50 25 $ 20 $ 18 15 19 17 a pet ea enea OOr Cea gwa Cicamg ugmt nAtue ccammg and window Creamng. You also have a quote from a company to clean the ductwork ) They have two pricing schemes and they will apply the lower of the two based on the total number of registers estimated for your home (in the array price!B10E12 named register). The table lists the costs per regi ster. If your home contains less than 10 registers the cost per register is $25 for bid#1 and $20 for bid # 2 , if your home contains at least 10 registers but less than 20 the cost per register is $21 for bid#1 and $19 for bid# 2. I (4)Your quote for the costs of cleaning the heating ducts (registers and associated ductwork) is based on the estimated number of total registers in your home (dim!L11). Write an Excel formula in cell cale!C3, which can be copied down the column, to detemine cost of cleaning your ducts for the corresponding room. Remember you have two possible pricing schemes both based on the total number of ducts in your home. The scheme you will use is the minimum cost scheme that your fomula should detemine automatically. I Hint: You may lookup the corresponding cost (per register) from the array price B10:E12 dim- C F G K Number of Registers A Type of Purpose Floor |aet |cet car Number of Light Fixtures Windows Room Width Feet Height Feet Number of Room Lengthe Area SF 131.7 81763 2303 3083 8 Inches 2 Area 3 bedroom1 4 bedroom2 5 bedroom3 6 Iving room Feet Inches 10 15 13 15 12 private private private public 7 dining room public public 3 1 12 1 11 21 20 5 1 17 2 0 5 2 12 1 1 12 1440 8 kitchen 9 bath1 10 bath2 11 totals 12 6 vin private public 15 18 2821 2 1 ol 5 tile tile 6 46.8 8 358 1355.2 0015 001 6 8 1 6 6 5 6 1 1 price logic A B C D E Analysis: E A B 1 Cleaning: 2 Floors Carpet 4 Price/Unit Unit 1 Within 10% of Budget FALSE FALSE FALSE FALSE TRUE FAL SE TRUE FALSE Over Budget TRUE FAL SE FAL SE FALSE TRUE FALSE FALSE FALSE $/SY $/SF $/SF $leach S/each 2 Room 3 bedroom 4 bedroom2 5 |bedroom Purpose private private private 6 living room public 7 dining room public S Budget $100.00 $ 200.00 S 300.00 $ 500.00 $ 200.00 3 5.00 Tile 125 1.00 All other Floor types 6 Windows 7 Light Fixtures 8 5 25.00 1250 8 kitchen 9 bath1 10 bath2 11 totals public private public 500.00 10 #Registers in Home 11 Cost per Register Bid#1 12 Cost per Register Bid#2 $ 20 $ 125.00 $ 100.00 $2,025.00 10 21 $ 19 50 25 $ 20 $ 18 15 19 17 a pet ea enea OOr Cea gwa Cicamg ugmt nAtue ccammg and window Creamng. You also have a quote from a company to clean the ductwork ) They have two pricing schemes and they will apply the lower of the two based on the total number of registers estimated for your home (in the array price!B10E12 named register). The table lists the costs per regi ster. If your home contains less than 10 registers the cost per register is $25 for bid#1 and $20 for bid # 2 , if your home contains at least 10 registers but less than 20 the cost per register is $21 for bid#1 and $19 for bid# 2
