Anders 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 Cartwright 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 Project Quantity Costs Quantity Costs Arrow Building 3,770 gallons $290,290 3,520 gallons $285,120 Besler Building 3,770 $297,8303,960 $320,760 Cartwright Building 4,470 $371,010 4,160 $336,960 Total variance Total Variance $5,170 U 22,930 F 34,050 U $16,290 U Prepare a variance report for the purchasing department with the following columns Proiect. (2) Actual Gallons Purchased. (3) Actual Price (4 Standard Price, (5) Price Variance, and (6) Explanation (Round price per unit to 2 decimal places, e3. 15.25 Anders Painting Service Varlance Report - Purchasing Department For the month ended XX 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, es. 15.25.) Anders Painting Service Variance Report - Purchasing Department For the month ended XX Actual Gallons Purchased Actual Price Standard Price Price Variance Project Arrow Building Besler Building Cartwright Building Total price variance e Textbook and Media $371,010 4,160 $330,700 Cartwright Building 4,470 Total variance 3, 0 $16,290 U 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, s. 15.25.) Anders Painting Service Variance Report - Purchasing Department For the month ended XX Price Standard Price Variance Explanation High Quality Paint Purchased on sale Poor Quality Paint Purchased/Cheaper Std. Quality Purchase/Price increased e Textbook and Media 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, es. 15.25.) Anders Painting Service Variance Report - Production Department 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.) Anders Painting Service Variance Report - Production Department For the month ended XX Standard Price Actual Gallons Standard Gallons Project Quantity Variance Arrow Building Besler Building Cartwright Building Total quantity variance e Textbook and Media In an effort to improve performance, Anders 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,680 gallons $292,560 3,520 gallons $285,120 $7.440 U Besler Building $299,715 3.960 $320,760 21,045 F Cartwright Building 4,320 $343,440 4,160 $336,960 6,480 U Total variance $7,125 F 3,770 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, eg. 15.25.) Anders Painting Service Variance Report - Production Department For the month ended XX Standard Price indard allons Quantity Variance Explanation ULU LE High Quality Paint/Reeded Less Inexperienced Worker/Wasted Paint Poor Quality Paint/Needed More e Textbook and Media In an effort to improve performance, Anders 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,680 gallons $292,560 3,520 gallons $285,120 $7,440 U Besler Building 3,770 $299,715 3,960 $320,760 21,045 F Cartwright Building 4,320 $343,440 4,160 $336,960 6,480 U Total variance $7,125 F In an effort to improve performance, Anders 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,680 gallons $292,560 3,520 gallons $285,120 $7,440 U Besler Building 3,770 $299,715 3,960 $320,760 21,045 F Cartwright Building 4,320 $343,440 4,160 $336,960 6,480 U Total variance $7,125 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.. 15.25.). Anders Painting Service Variance Report - Purchasing Department For the month ended XX Actual Gallons Purchased Actual Price Project Standard Price Price Variance Arrow Building Besler Building Cartwright Building Total price variance eTextbook and Media In an effort to improve performance, Anders 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,680 gallons $292,560 3.520 gallons $285,120 $7.440 U Besler Building 3,770 $299,715 3,960 $320,760 21,045 F Cartwright Building 4,320 $343,440 4,160 $336,960 6,480 U Total variance $7,125 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, eg: 15.25.) Anders Painting Service Variance Report - Purchasing Department For the month ended XX Standard Price Price Variance Explanation inexperienced Worker/Wasted Paint Paint Cheaper than Standard Cost Std. Quality Purchase/Price increased 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.) Anders Painting Service Variance Report - Production Department For the month ended XX Standard Price Actual Gallons Standard Gallons Quantity Variance Project Arrow Building $ Besler Building Cartwright Building Total quantity variance eTextbook and Media 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, eg: 15.25) Anders Painting Service Variance Report - Production Department For the month ended XX Standard Price ndard allons Quantity Variance Explanation Average Quality Paint/Needed Less Average Quality Paint/Needed More Inexperienced Worker/Wasted Paint e Textbook and Media