Purpose of Assignment The purpose of this assignment is to provide students an opportunity to apply the concepts of equations and percentages covered in Ch. 5 and 6 to integrated case studies. Assignment Steps Resources: Equations and Percentage Cases Excel® Template, Excel® 2016 Essential TrainingSave the Equations and Percentage Cases Excel® Template to your computer.Read the instructions on the first tab.Complete the two Excel® cases located in the template.Business Math/Cleaves, Hobbs & Noble/2017/11th edition /Pearson Education
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
Not require painting
Closet Area
Door Area
Window
Total area not requiring
paining
=Closet Area + Door Area + Window
Bedroom Net Area to be
Painted
=Area of walls + Area of Ceiling – Not Require Painting
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
Width of the wall
Height of the wall
No. of walls
Total Area
30
10
2
Not require painting
Patio Door Area
Single Windows Area
No. of Windows
Total Windows Area
=Single Windows Area * No. of Windows
Picture Window Area
Total area not requiring
paining
=Patio Door Area + Total Windows Area + Picture Window Are
Living/Dining Room Net
Area to be Painted
=Area of walls + Area of Ceiling – Not Require Painting
Entire Job
Total Square Footage
No. of coats of paint
Grand Total Sq. Footage
=Bedroom Net Area to be Painted + Living, Dining Net Area to
=Total Square Footage * No. of coats of paint
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
=C55
=C64/C63
=No. of gallons needed for the job*Cost of one gallon of 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)
square feet per hour
=C55
=Grand Total Sq. Footage to be painted divided by Painting Rat
=Labor Rate*No. of labor hours
=C68
Total Cost of Labor +
Materials (Paint)
Profit Margin
=C83*Desired Profit Margin
Final Bid Price
=Total cost of material + Labor + Profit Margin
+ Living, Dining Net Area to be Painted
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 3
Part 2
Cost to carpet
1 square yard
Cost to carpet
per square yard
square feet
per square feet
Discount (%)
Total Cost
Total Savings
=Discount(%)*Total Cost
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
=Total Cost – Total Savings – Current Cash they hold
Part 4
Part 5
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
% of total cost by Room
– Current Cash they hold
…
Purchase answer to see full
attachment
Recent Comments