Solved by verified expert:Description is in the attachment please refer to the spreadsheat math word problems.
qrb501_r10_equations_and_percentage_cases_excel_template.xlsx
Unformatted Attachment Preview
Refer to the Chapter 5 Case Study 5-1 on Page 187 of your text.
Answer the following questions.
Question 1
Find the total square footage that requires painting for the bedroom and the living/dining room,
and then find the total square footage for the entire painting job assuming two coats of paint.
Bedroom
Walls
Length of the wall
Height of the wall
No. of walls
Total Area
12
8
2
Ceiling
Length of the ceiling
Width of the ceiling
Total Area
12
14
Width of the wall
Height of the wall
No. of walls
Total Area
14
8
2
Width of the wall
Height of the wall
No. of walls
Total Area
30
10
2
Not require painting
Closet Area
Door Area
Window
Total area not requiring
paining
Bedroom Net Area to be
Painted
Living/Dining Room
Walls
Length of the wall
Height of the wall
No. of walls
Total Area
20
10
2
Ceiling
Length of the ceiling
Width of the ceiling
Total Area
20
30
Not require painting
Patio Door Area
Single Windows Area
No. of Windows
Total Windows Area
Picture Window Area
Total area not requiring
paining
Living/Dining Room Net
Area to be Painted
Entire Job
Total Square Footage
No. of coats of paint
Grand Total Sq. Footage
Question 2
One gallon of paint will cover 350 square feet and costs $35, and each surface will require two coats.
Using your answer to question 1, determine the total number of gallons required and total cost for
paint, by rounding up to the nearest gallon.
No. of square feet 1 gallon
of paint would cover
Grand Total Sq. Footage to
be painted
No. of gallons of paint
needed for the job
Cost of one gall of paint
Total Cost of the paint
Question 3
Using a painting rate of 150 square feet per hour (including prep time), a labor rate of $20 per hour, and a desired
profit margin of 30% (or 0.3), calculate the total labor cost, profit margin, and final bid price for this painting
job—including the total paint cost from question 2.
Painting Rate
Grand Total Sq. Footage to
be painted
No. of labor hours
Labor Rate
Total Cost of Labor
Total Cost of Materials
(Paint)
Total Cost of Labor +
Materials (Paint)
Profit Margin
Final Bid Price
, and a desired
Refer to the Chapter 6 Case Study 6-3 on Page 224 of your text.
Answer the following questions.
Room
Master bedroom
Bedroom #1
Bedroom #2
Hallway
Living room
Part 1
Dimensions Area in Square Feet Cost to Carpet
16ft by 18 ft
12 ft by 13 ft
10 ft by 12 ft
10 ft by 3 ft
15 ft by 20 ft
Total Cost
Part 2
Cost to carpet
1 square yard
Cost to carpet
per square yard
square feet
per square feet
Part 4
Discount (%)
Total Cost
Total Savings
Part 5
Cash they can pay
Area of carpet they can
afford to buy
square feet
Amount to borrow
Total Cost
Total Savings
Current Cash they hold
Amount to borrow
Part 6
Cost to carpet only
bedrooms
Amount to carpet living
room and hallway
Part 7
Amount saved per month
Amount Needed
No. of months
months
Part 3
Part 3
% of total cost by Room
…
Purchase answer to see full
attachment
