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
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...
Related questions
Concept explainers
Variance Analysis
In layman's terms, variance analysis is an analysis of a difference between planned and actual behavior. Variance analysis is mainly used by the companies to maintain a control over a business. After analyzing differences, companies find the reasons for the variance so that the necessary steps should be taken to correct that variance.
Standard Costing
The standard cost system is the expected cost per unit product manufactured and it helps in estimating the deviations and controlling them as well as fixing the selling price of the product. For example, it helps to plan the cost for the coming year on the various expenses.
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
>](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5d9c9f6a-3a92-4650-aee4-d1b63ade92c4%2Fb471ac81-57a0-4e83-adce-3c3ba990fedc%2Frmp083k_processed.png&w=3840&q=75)
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5d9c9f6a-3a92-4650-aee4-d1b63ade92c4%2Fb471ac81-57a0-4e83-adce-3c3ba990fedc%2Fzdz1is_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning