QRB501 Week 2 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.

Part A

Refer to the Chapter 5 Case Study 5-1 on Page 187 of your text.

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.

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.

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.

Part B

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

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.

Course: QRB501 Quantitative Reasoning For Business
School: University of Phoenix

Categories: QRB/501Questions

Available CoursesAsk Questions & Chat Now