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 Ra =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 Equations and Percentage Cases Grading Guide QRB/501 Version 10 Quantitative Reasoning for Business Copyright Copyright © 2017, 2016, 2014, 2013, 2011, 2010, 2008 by University of Phoenix. All rights reserved. University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries. Microsoft®, Windows®, and Windows NT® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended to imply endorsement, sponsorship, or affiliation. Equations and Percentage Cases Grading Guide QRB/501 Version 10 Edited in accordance with University of Phoenix® editorial standards and practices. 2 Equations and Percentage Cases Grading Guide QRB/501 Version 10 Individual Assignment: Equations and Percentage Cases 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. Resources Required Equations and Percentage Cases Excel® Template, Excel® 2016 Essential Training Grading Guide Content Met Partially Met Not Met Total Available Total Earned 4 #/4 Partially Met Not Met Comments: The student saved the Equations and Percentage Cases Excel® Template to their computer. The students read the instructions on the first tab. The student completed the two (2) cases located in the linked Excel® file. Writing Guidelines Organization The tone is appropriate to the content and assignment. The introduction provides a sufficient background on the topic and previews major points. Paragraph transitions are present, logical, and maintain the flow throughout the paper. The conclusion is logical, flows from the body of the paper, and reviews the major points. Met Comments: 3 Equations and Percentage Cases Grading Guide QRB/501 Version 10 Mechanics The paper—including tables and graphs, headings, title page, and reference page—is consistent with APA formatting guidelines and meets course-level requirements. Intellectual property is recognized with in-text citations and a reference page. Sentences are complete, clear, and concise. Rules of grammar and usage are followed including spelling and punctuation. Assignment Total Additional comments: # Total Available Total Earned 2 #/2 6 #/6 4
Purchase answer to see full attachment