Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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: Total Cost Number of Windows & Doors 13 15 12 12 House Square Footage . 2,600 B 3,010 2,800 D 2,850 E 4,600 F 2,700 G 2,375 H 2,450 | 2,600 J 3,700 K 2,650 L 3,550 19 13 11 11 $3,335 3,742 3,100 3,150 4,700 3,225 2,920 2,836 2,945 4,112 3,210 3,965 IO 10 16 13 16 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. 2) Which method do you recommend? Explain your answer. 3) What considerations should Anne take into account when examining the data? Explain

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Passive Activity Loss IRS Audit Technique Guide

Authors: Internal Revenue Service

1st Edition

1304114325, 978-1304114327

More Books

Students also viewed these Accounting questions

Question

what is information system ethnic means

Answered: 1 week ago