Anne Colton has a renovation business which uses painters to do custom paint jobs for house...
Fantastic news! We've Found the answer you've been seeking!
Question:
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?
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Is it a valid assumption that variable cost increases linearly with the volume? Explain your response wit an example.
-
On Bankrate.com, McGlone Mortgage Group and Homefinity are offering thirty-year mortgage financing with the following APR's based on monthly payments: 2.76% (McGlone) and 2.88% (Homefinity). The...
-
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...
-
Lead nitrate solution is added to a test tube containing potassium iodide solution. (a) Write the name and colour of the compound precipitated. (b) Write the balanced chemical equation for the...
-
Pick two cards. Pick two cards at random from a well-shuffled deck of 52 cards (pick them simultaneously, i.e., grab two cards at once-so they are not the same card!). There are 12 cards which are...
-
Everyday Hardware Consultants purchased a building for $540,000 and depreciated it on a straight-line basis over a 40-year period. The estimated residual value is $96,000. After using the building...
-
Recording Purchase and Sales Transactions} Raymond Company and Geeslin Company both use a perpetual inventory system. The following transactions occurred during the month of January: Jan. 1 Raymond...
-
Refer to the information in Problem 6-33. Assume the following: Pet Luggage (PL) does not make any sales on credit. PL sells only to the public, and accepts cash and credit cards; 90% of its sales...
-
Find the equation of the tangent line to the graph of the function f (:13) : sin (55?) at the point (71'2 , O). Enclose numerators and denominators in parentheses. For example, (a b)/ (1 l n)....
-
(-2.6 102) (2.0 103) Write your answer in scientific notation.
-
A copper fabricator decides to enter into 4 long March futures contracts on copper. Each contract is for the delivery of 15,000 lbs. The current futures price is 352/lb. and the initial margin is...
-
Identify the strategies, policies, or procedures that should be implemented as a result of the Divisional organizational structure. What key strategies, policies, or procedures should you implement?...
-
Logan Passport Services budgeted sales of 8,100 units of its Basic Visa Service (BVS). This was based on its estimated 5 percent share of this service in the relevant regional market. Actual sales of...
-
Leah is training for a competition which is four months away. Her Physique Coach has given her a new mesocycle that has her increasing repetitions first and then increasing load after a few...
-
Requirement #1 - The November 30, 2014 balances have been posted to your general ledger accounts. (The accounts given are the only accounts you are to use.) Prepare an unadjusted trial balance as of...
-
4. You plan to purchase a house for $375,000 and you will make a 20% down payment . You are evaluating two mortgages a 30-year fixed mortgage at 3.16 % and a 15 -year fixed mortgage at 2.75 %. Your...
-
Catherine (aged 42) and Johnson (aged 45) have been married for 12 years. Johnson is a project manager of an event company at a monthly salary of $55,000 with an additional one-month salary of...
-
Can you think of any drawbacks in providing interim financial statements for users? R3
-
A year ago Pod Limited bought 225,000 1 fully paid ordinary shares of Pea Limited for a consideration of 500,000. Pea Limiteds share capital and share premium were each the same as at todays date....
-
Segmental information relating to Dali pic for the year to 31 December 2012 is shown below. Required: Analyse the performance of each of the three main business segments for the year and comment on...
Study smarter with the SolutionInn App