In an effort to improve performance, Lily Painting Service found a new supplier that sold average quality paint. The initial quantity and cost data for each project is below: Project Arrow Building Besler Building Cartwright Building 4,380 Total variance Project Arrow Building Besler Building Cartwright Building Actual Total price variance Quantity 3,610 gallons 3,820 Actual Gallons Purchased Costs $276,165 3,500 gallons $292,230 4,000 $335.070 4,220 (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.) $ Standard $ Quantity $ Costs Actual Price $273,000 $312,000 $329,160 $ $ Total Variance $3,165 U 19,770 F $ 5,910 U $10,695 F Lily Painting Service Variance Report - Purchasing Department For the month ended XX Standard Price $ $ Price Variance Explanation

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter14: Quality And Environmental Cost Management
Section: Chapter Questions
Problem 21E: At the end of 20x5, Bing Pharmaceuticals began to implement an environmental quality management...
icon
Related questions
Topic Video
Question
In an effort to improve performance, Lily Painting Service found a new supplier that sold average quality paint. The initial quantity and cost data for each project is below:
Project
Arrow Building
Besler Building
Total variance
Cartwright Building 4,380
Project
Arrow Building
Besler Building
Cartwright Building
Actual
Quantity
Total price variance
3,610 gallons
3,820
Actual
Gallons
Purchased
Costs
$276,165 3,500 gallons
$292,230 4,000
$335,070 4,220
$
Standard
$
Quantity
(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.)
$
Costs
Actual
Price
$273,000
$312,000
$329,160
$
$
Total
Variance
$3,165 U
$
19,770 F
5,910 U
$10,695 F
Lily Painting Service
Variance Report - Purchasing Department
For the month ended XX
Standard
Price
$
$
Price
Variance
Explanation
>
Transcribed Image Text:In an effort to improve performance, Lily Painting Service found a new supplier that sold average quality paint. The initial quantity and cost data for each project is below: Project Arrow Building Besler Building Total variance Cartwright Building 4,380 Project Arrow Building Besler Building Cartwright Building Actual Quantity Total price variance 3,610 gallons 3,820 Actual Gallons Purchased Costs $276,165 3,500 gallons $292,230 4,000 $335,070 4,220 $ Standard $ Quantity (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.) $ Costs Actual Price $273,000 $312,000 $329,160 $ $ Total Variance $3,165 U $ 19,770 F 5,910 U $10,695 F Lily Painting Service Variance Report - Purchasing Department For the month ended XX Standard Price $ $ Price Variance Explanation >
(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.
Project
Arrow Building
Besler Building
Cartwright Building
Total quantity variance
Actual
Gallons
Standard
Gallons
$
$
tA
$
Lily Painting Service
Variance Report - Production Department
For the month ended XX
Standard
Price
$
N!
$
Quantity
Variance
>
>
>
Explanation
Transcribed Image Text:(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. Project Arrow Building Besler Building Cartwright Building Total quantity variance Actual Gallons Standard Gallons $ $ tA $ Lily Painting Service Variance Report - Production Department For the month ended XX Standard Price $ N! $ Quantity Variance > > > Explanation
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Performance measurements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning