Prepare a flexible budget performance report

Assignment Help Financial Accounting
Reference no: EM13497176

Exercise 10-16


AirQual Test Corporation provides on-site air quality testing services. The company has provided the following data concerning its operations:

Fixed Variable Actual
Component ComponentTotal for
per Month per Job February
Revenue . . . . . . . . . . . . . . . . . . . . . $360 $18,950
Technician wages . . . . . . . . . . . . . . $6,400 $6,450
Mobile lab operating expenses . . . . $2,900 $35 $4,530
Office expenses . . . . . . . . . . . . . . . $2,600 $2 $3,050
Advertising expenses . . . . . . . . . . .$970 $995
Insurance . . . . . . . . . . . . . . . . . . . . $1,680 $1,680
Miscellaneous expenses . . . . . . . . . $500 $3 $465


The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $2,900 plus $35 per job, and the actual mobile lab operating expenses forFebruary were $4,530.

The company expected to work 50 jobs in February, but actually worked 52 jobs.

Required:

Prepare a flexible budget performance report showing AirQuaTest Corporation's activity variancesand revenue and spending variances for February.

PROBLEM 11-14 Comprehensive Variance Analysis [LO2, LO3, LO4]
Miller Toy Company manufactures a plastic swimming pool at its Westwood Plant. The plant has been experiencing problems as shown by its June contribution format income statement below:

Budgeted Actual
Sales (15,000 pools) . . . . . . . . . . . . . . . . . . . . $450,000 $450,000
Variable expenses:
Variable cost of goods sold* . . . . . . . . . . . . 180,000 196,290
Variable selling expenses . . . . . . . . . . . . . . 20,000 20,000
Total variable expenses . . . . . . . . . . . . . . . . . . 200,000 216,290
Contribution margin . . . . . . . . . . . . . . . . . . . . . 250,000 233,710
Fixed expenses:
Manufacturing overhead . . . . . . . . . . . . . . . 130,000 130,000
Selling and administrative . . . . . . . . . . . . . . 84,000 84,000
Total fixed expenses . . . . . . . . . . . . . . . . . . . . 214,000 214,000
Net operating income . . . . . . . . . . . . . . . . . . . $ 36,000 $ 19,710

*Contains direct materials, direct labor, and variable manufacturing overhead

Janet Dunn, who has just been appointed general manager of the Westwood Plant, has been given instructions to "get things under control." Upon reviewing the plant's income statement, Ms. Dunnhas concluded that the major problem lies in the variable cost of goods sold. She has been providedwith the following standard cost per swimming pool:


Standard Quantity Standard Price Standard
or Hours or Rate Cost
Direct materials . . . . . . . . . . . . . . . . . 3.0 pounds $2.00 per pound $ 6.00
Direct labor . . . . . . . . . . . . . . . . . . . . 0.8 hours $6.00 per hour 4.80
Variable manufacturing overhead . . . 0.4 hours* $ 3.00 per hour 1.20
Total standard cost . . . . . . . . . . . . . . $12.00
*Based on machine-hours.

During June the plant produced 15,000 pools and incurred the following costs:
a. Purchased 60,000 pounds of materials at a cost of $1.95 per pound.
b. Used 49,200 pounds of materials in production. (Finished goods and work in process inventories are insignificant and can be ignored.)
c. Worked 11,800 direct labor-hours at a cost of $7.00 per hour.
d. Incurred variable manufacturing overhead cost totaling $18,290 for the month. A total of 5,900 machine-hours was recorded.
It is the company's policy to close all variances to cost of goods sold on a monthly basis.

Required:
1. Compute the following variances for June:
a. Direct materials price and quantity variances.
b. Direct labor rate and efficiency variances.
c. Variable overhead rate and efficiency variances.
2. Summarize the variances that you computed in (1) above by showing the net overall favorableor unfavorable variance for the month. What impact did this figure have on the company's incomestatement? Show computations.
3. Pick out the two most significant variances that you computed in (1) above.

Reference no: EM13497176

Questions Cloud

Explain can anyone tell me how is made sigma : Can anyone tell me how is made Sigma(Like as primary bond) and Pi(like as secondarybond)in Oxygen(O2) molecule. How are joined atomical orbital.
What was the cost of each acquisition : What was the cost of each acquisition? How was that cost allocated in each case? What amount of goodwill was recorded by each firm?
Explain the same uv-absorbing compound : Consider two different solutions of the same UV-absorbing compound. Upon UV-analysis, Solution B gave an absorbance of 1.5 and Solution A gave an absorbance of 0. 5 at the same wavelength. Solution B is higher in concentration by what ratio (or pe..
Exhibiting all the primary keys and foreign keys : Draw the corresponding GRD, exhibiting all the primary keys and foreign keys. For simplicity, no other attributes nor multiplicity constraints are required.
Prepare a flexible budget performance report : The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $2,900 plus $35 per job, and the actual mobile lab operating expenses forFebruary were $4,530.
Explain the melting point of a newly discovered element : The melting point of a newly discovered element is 1935.4°F. Express this temperature in degrees Celsius.
Find how much work was done on the player by friction : A baseball player decides to keep going past second base and try for third base. If the player comes to rest at third base, how much work was done on the player by friction
Define the change in oxidation number : Show the change in oxidation number (give number of electrons gained or lost per atom: e.g., 3e- gained) in the following reactions:
How to make income statement and balance sheet : Below find the trial balance for Nybrostrand Company. Prepare an income statement and balance sheet in good format. After you have completed the two statements comment on the success of the company.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Calculate the number and total cost of the units available

The company uses a periodic inventory system. On December 31, 2011, a physical count reveals that 35,000 units of its product remain in inventory. Calculate the number and total cost of the units available for sale in year 2011

  Money from these accounts could be mixed

Money from these accounts could be mixed or further divided and sent to other accounts or individuals, who, in turn, would do the same, until several checks for $1000 or less eventually arrive at party headquarters.

  Prepare the companys statement of cash flows

Prepare the companys statement of cash flows for the year ended December 31, 20X1. Use the indirect method of determining net cash flows from operating activities.

  Purpose summary journal entries related to the sales

Purpose summary journal entries related to the (1) sales, (2) sales returns, (3) collections of accounts receivable, and (4) write-offs of accounts receivable for the year ended September 30, 2009.

  Wakefield home is a private not-for-profit healthcare

wakefield home is a private not-for-profit healthcare organization offering services for a fee. in first quarter of

  Journalization of transactions for production costs

Journalization of transactions for production costs as like of raw materials, labor, processing and overhead using transferred goods data and details.

  Direct material 10 direct labor 20 variable manufacturing

direct material 10 direct labor 20 variable manufacturing costs per unit 5 total variable manufacturing cost per unit

  Multiple questions on cash flows

Multiple questions on cash flows and What was the loan balance when you sold the property and What was the remaining term when you sold the property?

  Calculation of arithmetic geometric mean and npva stock had

calculation of arithmetic geometric mean and npv.a stock had returns of 11 percent 15 percent 14 percent 3 percent 12

  Describe breakeven point

assume that the company can produce up to 150,000 units (relevant range for this cost structure) and it typically sells 110,000 units per month. A customer has placed a bid for 30,000 gadgets; however, they are willing to pay only $3 each. Would C..

  Purchase of merchandise on credit using perpetual inventory

Which of the is allowed under generally accepted accounting principles - purchase of merchandise on credit using a perpetual inventory system includes

  Journalize the entries required by the reconciliation

Prepare the adjusting entry necessary as a result of the physical count Account - Description Debit Credit and compute the ending inventory

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