Equations and Percentage Cases

WK2QRB501_r10_Equations_and_Percentage_Cases_Excel_Template.xlsx

Home >Mathematics homework help >Numerical analysis homework help >Equations and Percentage Cases

Question 1

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 ﬁnd the total square footage for the entire painting job assuming two coats of paint.
Bedroom
	Walls
	Length of the wall	12	Width of the wall	14
	Height of the wall	8	Height of the wall	8
	No. of walls	2	No. of walls	2
	Total Area		Total Area
	Ceiling
	Length of the ceiling	12
	Width of the ceiling	14
	Total Area
	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	20	Width of the wall	30
	Height of the wall	10	Height of the wall	10
	No. of walls	2	No. of walls	2
	Total Area		Total Area
	Ceiling
	Length of the ceiling	20
	Width of the ceiling	30
	Total Area
	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
proﬁt margin of 30% (or 0.3), calculate the total labor cost, proﬁt margin, and ﬁnal 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

Question 2

Refer to the Chapter 6 Case Study 6-3 on Page 224 of your text.
Answer the following questions.
			Part 1	Part 3
	Room	Dimensions	Area in Square Feet	Cost to Carpet	% of total cost by Room
	Master bedroom	16ft by 18 ft
	Bedroom #1	12 ft by 13 ft
	Bedroom #2	10 ft by 12 ft
	Hallway	10 ft by 3 ft
	Living room	15 ft by 20 ft
			Total Cost
Part 2
	Cost to carpet		per square yard
	1 square yard		square feet
	Cost to carpet		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