equations and percentages cases

equations and percentages casesResources: 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.
see attachment
File #1
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 =Discount(%)*Total Cost

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 =Total Cost – Total Savings – Current Cash they hold

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

find the cost of your paper