Waterway Painting Service specializes in painting tall office buildings. During a recent month, the company worked on three painting projects (the Arrow Building, the Besler Building and the Cartrwright Building). The company is interested in controlling the materials costs, namely the paint, used for these painting contracts. In order to provide management with useful cost control information, the company uses standard costs and prepares monthly variance reports. Analysis reveals that the purchasing agent mistakenly purchased poor-quality paint for the Arrow Building project. The Besler Building project, however, received higher-than-standard-quality paint that was on sale. The Cartwright Building project received standard-quality paint. However, the price had increased and a new employee was used to paint the building. Shown below are quantity and cost data for each project. Actual Standard Total Variance Project Quantity Costs Costs Arrow Building 3,750 gallons $281,250 $274,920 $6,330 U Besler Building 3,750 $288,750 3,970 $313,630 24,880 F Cartwright Building 4,500 $364,500 4,220 $333,380 31,120 U Total variance $12,570 U Quantity 3,480 gallons (a) 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 price per unit to 2 decimal places, e.g. 15.25.) WATERWAY Painting S Variance Report - Purchasing For the month ended Actual Gallons Actual Standard Purchased Price Price Project Arrow Building Besler Building Cartwright Building Total price variance LA LA LA (a) 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 price per unit to 2 decimal places, e.g. 15.25.) ERWAY Painting Service port - Purchasing Department the month ended XX Price Variance Explanation GA tA $ > < < 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. (Round price per unit to 2 decimal places, e.g. 15.25.) WATERWAY Painting S Variance Report - Production For the month ended Standard Standard Actual Gallons Project Gallons Price Arrow Building Besler Building Cartwright Building Total quantity variance tA GA GA 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. (Round price per unit to 2 decimal places, e.g. 15.25.) ERWAY Painting Service port - Production Department the month ended XX Quantity Variance Explanation $ LA $ > < > > > > > In an effort to improve performance, Waterway 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,660 gallons 3,480 gallons $274,920 $8,364 U $283,284 $290,250 Besler Building 3,750 3,970 $313,630 23,380 F Cartwright Building 4,370 $338,238 4,220 $333,380 4,858 U Total variance $10,158 F 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 price per unit to 2 decimal places, e.g. 15.25.) WATERWAYPainting Se Variance Report - Purchasing For the month ended Actual Gallons Purchased Standard Actual Price Price Project Arrow Building Besler Building 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 price per unit to 2 decimal places, e.g. 15.25.) WATERWAYPainting Service ariance Report - Purchasing Department For the month ended XX Standard Price Variance Price Explanation GA tA < < > C2). 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. (Round price per unit to 2 decimal places, e.g. 15.25.) WATERWAY Painting S Variance Report - Production For the month ended Standard Standard Actual Gallons Project Gallons Price Arrow Building Besler Building Cartwright Building Total quantity variance $ LA $ +A (c2). 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. (Round price per unit to 2 decimal places, e.g. 15.25.) ERWAY Painting Service port - Production Department the month ended XX Quantity Variance Explanation $ tA < > < V > < >