(c) In an effort to improve performance, Sheridan Painting Service found a new supplier that sold average quality paint. The initial quantity and cost data for each project is below: Actual Standard Total Project Quantity Costs Quantity Costs Variance Arrow Building 3,630 gallons $288,222 3,500 gallons $283,500 $4,722 U 3,750 $297,750 3,940 $319,140 21,390 F Besler Building Cartwright Building 4.290 $340,626 4,150 $336,150 4,476 U Total variance $12.192 F (1) Prepare a variance report for the purchasing department with the following columns: (1) Project. (2) Actual Gallons Purchased, (3) Actual Price (4) Standard Price, (5) Price Variance, and (6) Explanation. (Round Actual Price answers to 2 decimal places, e.g. 10.50.) Sheridan Painting Se Variance Report - Purchasin For the month ende Actual Gallons Purchased Actual Price Standard Price Project Arrow Building $ $ $ Besler Building $ $ $ Cartwright Building $ $ Total price variance TA (c) In an effort to improve performance, Sheridan Painting Service found a new supplier that sold average quality paint. The initial quantity and cost data for each project is below: Actual Total Standard Quantity Project Quantity Costs Costs Variance Arrow Building 3,630 gallons $288,222 3,500 gallons $283,500 $4,722 U Besler Building 3.750 $297,750 3,940 $319,140 21,390 F Cartwright Building 4,290 $340,626 4,150 $336,150 4,476 U Total variance $12,192 F (1) Prepare a variance report for the purchasing department with the following columns: (1) Project, (2) Actual Gallons Purchased (3) Actual Price (4) Standard Price, (5) Price Variance, and (6) Explanation. (Round Actual Price answers to 2 decimal places, e.g. 10.50.) dan Painting Service prt - Purchasing Department he month ended XX Price Variance Explanation $ Favorable Unfavorable Neither Favorable nor Unfavorable $ In an effort to improve performance, Sheridan Painting Service found a new supplier that sold average quality paint. The initial quantity and cost data for each project is below: Actual Standard Total Project Quantity Costs Quantity Costs Variance Arrow Building 3,630 gallons $288,222 3,500 gallons $283,500 $4,722 U Besler Building 3,750 $297,750 3,940 $319,140 21,390 F Cartwright Building 4,290 $340,626 4,150 $336,150 4,476 U Total variance $12,192 F (1) Prepare a variance report for the purchasing department with the following columns: (1) Project. (2) Actual Gallons Purchased, (3) Actual Price, (4) Standard Price, (5) Price Variance, and (6) Explanation. (Round Actual Price answers to 2 decimal places, e.g. 10.50.) dan Painting Service prt - Purchasing Department he month ended xx Price Variance Explanation $ TA (2) Prepare a variance report for the production department with the following columns: (1) Project, (2) Actual Gallons (3) Standard Gallons, (4) Standard Price. (5) Quantity Variance, and (6) Explanation. Sheridan Paintings Variance Report - Productio For the month ende Actual Gallons Standard Gallons Standard Price Project Arrow Building GA $ Besler Building $ $ Cartwright Building Total quantity variance = (2) Prepare a variance report for the production department with the following columns: (1) Project, (2) Actual Gallons, (3) Standard Gallons, (4) Standard Price, (5) Quantity Variance, and (6) Explanation. Han Painting Service rt - Production Department he month ended xx Quantity Variance Explanation $ >
