Description
Equations and Percentage Cases
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 Training
Save 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.
Click the Assignment Files tab to submit your assignment.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
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
192
Ceiling
Length of the ceiling
Width of the ceiling
Total Area
12
14
168
Not require painting
Closet Area
Door Area
Window
Total area not requiring
painting
Width of the wall
Height of the wall
No. of walls
Total Area
14
8
2
224
42
21
20
83 =Closet Area + Door Area + Window
Bedroom Net Area to be
Painted
501 =Area of walls + Area of Ceiling - Not Require Painting
Walls
Length of the wall
Height of the wall
No. of ...