Anne Colton has a renovation business which uses painters to do custom paint jobs for house...

Transcribed Image Text:

Anne Colton has a renovation business which uses painters to do custom paint jobs for house exteriors. She is trying to get a better idea of her cost structure to be able to bid on contracts as there has been new competition entering her neighbourhood from the downtown area. She has traditionally used the square footage of the houses she's worked on; but noticed that the amount of time taken also differed on the last 2 projects which had a lot of windows and doors, which requires a lot more preparation work. Information for her last 12 jobs are as follows: House Square Number of Total Cost Footage Windows & Doors A 2,600 13 $3,335 B 3,010 15 3,742 C 2,800 12 3,100 D 2,850 12 3,150 E 4,600 19 4,700 F 2,700 13 3,225 G 2,375 11 2,920 H 2,450 11 2,836 I 2,600 10 2,945 3,700 16 4,112 K 2,650 13 3,210 L 3,550 16 3,965 Required: 1) How much would Anne charge for a house with 3,300 square feet and 14 openings (windows and doors), based on: A. high-low method, based on square footage. B. high-low method, based on number of windows. C. regression analysis, based on square footage. D. regression analysis, based on number of windows. I 2) Recommend which option Anne should choose. (Hint: when a question asks you to make a recommendation, what it really means is to analyze the pros/cons of each option and make a recommendation based on your analysis) 3) Are there any issues with the data/methodologies that should of concern to Anne? Anne Colton has a renovation business which uses painters to do custom paint jobs for house exteriors. She is trying to get a better idea of her cost structure to be able to bid on contracts as there has been new competition entering her neighbourhood from the downtown area. She has traditionally used the square footage of the houses she's worked on; but noticed that the amount of time taken also differed on the last 2 projects which had a lot of windows and doors, which requires a lot more preparation work. Information for her last 12 jobs are as follows: House Square Number of Total Cost Footage Windows & Doors A 2,600 13 $3,335 B 3,010 15 3,742 C 2,800 12 3,100 D 2,850 12 3,150 E 4,600 19 4,700 F 2,700 13 3,225 G 2,375 11 2,920 H 2,450 11 2,836 I 2,600 10 2,945 3,700 16 4,112 K 2,650 13 3,210 L 3,550 16 3,965 Required: 1) How much would Anne charge for a house with 3,300 square feet and 14 openings (windows and doors), based on: A. high-low method, based on square footage. B. high-low method, based on number of windows. C. regression analysis, based on square footage. D. regression analysis, based on number of windows. I 2) Recommend which option Anne should choose. (Hint: when a question asks you to make a recommendation, what it really means is to analyze the pros/cons of each option and make a recommendation based on your analysis) 3) Are there any issues with the data/methodologies that should of concern to Anne?