Required: 3a. Plot the cost data against square feet and against openings. (Click each house and then click the graph to bring up the data coordinates. Enter the exact coordinates for each house.)

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
Required information
[The following information applies to the questions displayed below.]
The Mac Davis Company specializes in the purchase, renovation, and resale of older homes. Mac employs several
carpenters and painters to do the work for him. It is essential for him to have accurate cost estimates so he can determine
total renovation costs before he purchases a piece of property. If estimated renovation costs plus the purchase price of a
house are higher than the house's estimated resale value, it is not a worthwhile investment.
Mac has been using the home's interior square feet for his exterior paint cost estimations. Recently he decided to include
the number of external openings-the total number of doors and windows in a house-as a cost driver. Their cost is
significant because they require time-consuming preparatory work and careful brushwork. The rest of the house usually is
painted either by rollers or spray guns, which are relatively efficient ways to apply paint to a large area. Mac has kept
careful records of these exterior painting costs on his last 12 jobs:
House
1
2
LN345679
8
9
10
11
12
Square
Feet
2,500
3,010
2,800
2,850
4,600
2,700
2,600
2,550
2,600
3,710
2,650
3,550
External
Openings
13
15
12
12
19
13
11
11
10
16
13
16
Costs
$ 2,810
3,742
3,100
3,150
4,700
3,225
2,920
2,836
3,242
4,122
3,210
3,965
Required:
3a. Plot the cost data against square feet and against openings. (Click each house and then click the graph to bring up the data
coordinates. Enter the exact coordinates for each house.)
Transcribed Image Text:Required information [The following information applies to the questions displayed below.] The Mac Davis Company specializes in the purchase, renovation, and resale of older homes. Mac employs several carpenters and painters to do the work for him. It is essential for him to have accurate cost estimates so he can determine total renovation costs before he purchases a piece of property. If estimated renovation costs plus the purchase price of a house are higher than the house's estimated resale value, it is not a worthwhile investment. Mac has been using the home's interior square feet for his exterior paint cost estimations. Recently he decided to include the number of external openings-the total number of doors and windows in a house-as a cost driver. Their cost is significant because they require time-consuming preparatory work and careful brushwork. The rest of the house usually is painted either by rollers or spray guns, which are relatively efficient ways to apply paint to a large area. Mac has kept careful records of these exterior painting costs on his last 12 jobs: House 1 2 LN345679 8 9 10 11 12 Square Feet 2,500 3,010 2,800 2,850 4,600 2,700 2,600 2,550 2,600 3,710 2,650 3,550 External Openings 13 15 12 12 19 13 11 11 10 16 13 16 Costs $ 2,810 3,742 3,100 3,150 4,700 3,225 2,920 2,836 3,242 4,122 3,210 3,965 Required: 3a. Plot the cost data against square feet and against openings. (Click each house and then click the graph to bring up the data coordinates. Enter the exact coordinates for each house.)
Expert Solution
steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.