Materials price and quantity variances

Assignment Help Accounting Basics
Reference no: EM131298540

Garden City Pots, Inc. manufactures large flower pots for city and urban settings. It sells its large flower pots to cities, municipalities, and large businesses to be used it their landscaping designs. Garden City Pots has developed the following per unit standard costs for 2016 for each large flower pot:

Standard Costs:                    

Direct Material                                    15 lbs. resin                 $5.00 per lb.   

Direct Labor                                        2.0 hr.                          $13.00 per hr.

Variable Manufacturing Overhead     2.0 hr.                          $?per hr.

Fixed Manufacturing Overhead         2.0 hr.                          $?per hr.

2016 Budgeted Data:
Budgeted production, 2,000 large garden pots
Denominator Hours, 4,000 DLH. (Garden City Pots, Inc. applies overhead on the basis of direct labor hours.)
Budgeted variable overhead, $24,800.
Budgeted fixed overhead, $23,600.

2016 Actual Results:
Direct material purchases were 30,230 lbs. of resin which cost $157,196.
Direct material used was 29,830 lbs. of resin.
Direct labor costs $54,720 for 4,560 direct labor hours actually worked.
Total variable manufacturing overhead was $28,272.
Total fixed manufacturing overhead was $23,484.
Actual production was 1,900 large flower pots.

REQUIRED:

1. Calculate the following variances:
a. materials price and quantity variances.
b. labor rate and efficiency variances.
c. variable overhead spending(rate) and efficiency variances.
d. fixed overhead budget and volume variances.

2. Add a separate sheet within your excel workbook and change the name of the sheet to "Journal Entries". On this new sheet, prepare journal entries for:
a. material price and quantity variances.
b. labor rate and efficiency variances.

3. Add a separate sheet within your excel workbook and change the name of the sheet to "Causes". For the material price and quantity variances and labor price and efficiency variancesin the Analysis Report, state 3 reasons that could explain why each of these variances occurred. Use complete sentences and detailed explanations that is specific to your variance results. Do NOT use a "bullet point" format. If you just use a bullet point format without any explanation referencing the specific problem and variances you calculated, you will not receive ANY extra credit for this part of the assignment.

What IF Problem & Data :

WHAT IF ANALYSIS:
Check Figure: MPV: $6.000 Favorable
VOH EV: $0 No Variance

The "What If" part of the assignment will help you determine whether you have correctly used cell referencing in your spreadsheets. Change your date in the heading to: "For the Year Ended December 31, 2017."

In the actual costs portion of your data block page make the following changes (The standard data has NOT changed from the previous year.):

1. Due to a supplier going out of business, Garden City Pots, Inc. was able to
purchase material (resin) at a significant discount. They purchased 30,000 lbs. of resin at a total cost of $144,000.

2. Direct material (resin) used in production was 32,010 lbs. of resin

3. Factory management has replaced its aging machinery that was prone to breakdowns
with new computerized equipment. The new equipment has contributed to an overall
improvement in theefficiency of its production workers. However, Garden City Pots, Inc.also negotiated a new 2 year contract with the union shop which increased the actuallabor wage rate. Total direct labor hours for 2017 are 4,400 hours at an overall higher cost of $59,400.

4. Total actual variableoverhead for 2017 is $26,400.

5. Insurance and depreciation costs have increased due to purchasing the new
manufacturing equipment. Total fixed overhead for 2017 is $23,980.

6. Due to an increase in demand, total production for 2017 has increased to 2,200 unitsin 2017.

Your spreadsheet should automatically recalculate using the new data. You should not have to change any of the cell references or formulas for any of the variances. You are only changing the data block page.

Reference no: EM131298540

Questions Cloud

Actual ending financial statements for february : You will need to take a look at the actual ending financial statements for February, March and April and use this data to help create the forecast for the next fiscal year of business.
How many students are employed : If the college introduces a strictly enforced minimum wage of $11.50 an hour, how many students are employed, how many are unemployed, and what is the lowest wage at which some students would be willing to work?
How manager could develop employees with different strengths : Explain how a manager could develop employees with different strengths. Determine how the process might be approached differently for each employee to produce the best results. Use scenarios to convey your idea.
Why empirical facts can cause a us trade deficit : Use the small open economy model below to explain the logic of why these to empirical facts can cause a U.S. trade deficit. Assume that the worldwide risk-free real interest rate is fixed at r* and does not move.  Use words to explain your equatio..
Materials price and quantity variances : The What If part of the assignment will help you determine whether you have correctly used cell referencing in your spreadsheets. Change your date in the heading to: "For the Year Ended December 31, 2017.
What method is used to allocate flowers at bloemenveiling : The world's largest tulip and flower market Every day over 19 million tulips and flowers are auctioned at the Dutch market called "The Bloemenveiling." These Dutch auctions match buyers and sellers.
Explain what the impact of the tsunami : Using the economic terms and concepts from class, explain what the impact of the Tsunami was on the Japanese economy, initially and in the long-run.
Explain how mark sims could better motivate the employees : From the case study, discuss how Mark Sims could better motivate the employees he already has to become more productive and dedicated. Provide specific examples to support your response.
Why a corporation is a better alternative to a partnership : Discuss, in detail, why a corporation is a better alternative to a partnership and why. Use examples from the text.

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  Inventory of materials

One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 20% of the following month's production needs. At the beginning of Month 1, 3,200 lb. of materials were on hand. Purchases o..

  Which of the given analyses is the most beneficial one for

In your opinion, which of the given analyses is the most beneficial one for decision-makers: Analysis of balance sheet. Analysis of income statement. Analysis of statement of cash flow. Cite two instances where your chosen analysis stands more benefi..

  For 2012 the new products division of testar company had

for 2012 the new products division of testar company had operating income of 9700000 and operating assets of 46500000.

  Under what conditions of bond issuance

Under what conditions of bond issuance does a discount on bonds payable arise? Under what conditions of bond issuance does a premium on bonds payable arise?

  What were the most compelling topics learned in the course

What were the most compelling topics learned in this course? How did participating in discussions help your understanding of the subject matter? Is anything still unclear that could be clarified?

  Wainwright corporation had the following activities in 2012

wainwright corporation had the following activities in 2012. 1. sale of land 249600 2. purchase of inventory 875100 3.

  Supervisors hire and fire their own crews

Golden Bear Construction Co. operates throughout California. The owner, Gaylan Beavers, employs 15 work crews. Construction supervisors report directly to Beavers, and the supervisors are trusted employees. The home office staff consists of an acc..

  Role of the different types of auditors

Examine the role of the different types of auditors. Determine what situations are most appropriate for each type of auditor.

  Posting to subsidiary ledger accounts

Using the following revenue journal for Alpha Services Inc., identify each of the posting references, indicated by a letter, as representing

  Prepare a partial income statement for green day beginning

Green Day Corporation had income from continuing operations of $12,600,000 in 2004. During 2004, it disposed of its restaurant division at an after-tax loss of $189,000.

  How does cash flow affect the evaluation of an investment

how does cash flow affect the evaluation of an investment? if an initial investment will be 100000 which is better a

  Discuss the ethical dilemma

Discuss the ethical dilemma or explain why you do not perceive an ethical dilemma.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd