Prepare a spending and volume variance analysis of operating expenses based on the additional information supplied in
Question:
Prepare a spending and volume variance analysis of operating expenses based on the additional information supplied in Exhibit 3.
Exhibit 3: Expense Items: Budget Q2 2000
Question 3:
Prepare a variance analysis of expenses based on the additional information supplied in Exhibit 3.
Formulas and approach:
Variance analysis formula: Total revenue variance = AR - ER
Flexible budget: Fixed expenses + variable expenses
Volume variance: (AQ-EQ)*cost per unit
Prepare a flexible budget to display the spending variance attributable to fixed (committed) and variable expenses. Calculate the volume variance for the difference in number of consultants
Actual Budget Variable Advertising and Promotion 0% 22,100 15,100 80% Administrative and Support Staff 225,000 191,250 Information Systems 126,200 120,000 80% 0% Depreciation 23,400 22,700 Dues and Subscriptions 11,800 13,100 80% Education and Training 36,200 38,900 80% Equipment 23,500 22,440 25% Leases 33,600 Insurance 32,200 0% 0% Professional 39,500 34,700 Services Office Expense 42,100 36,550 100% Office Supplies 86,200 89,600 80% Postage 27,300 24,700 80% Rent - Real Estate 117,260 117,260 0% Telephone 40,000 38,500 100% Travel and 57,800 56,300 100% Entertainment Utilities 25% 26,600 24,000 Total 938,560 877,300
Step by Step Answer:
Flexible Budjet Particulars Actual Budjet Variable Fixed Exp Variable Exp Total FV Advertisement Pra...View the full answer
Management Accounting
ISBN: 978-0132570848
6th Canadian edition
Authors: Charles T. Horngren, Gary L. Sundem, William O. Stratton, Phillip Beaulieu
Students also viewed these Corporate Finance questions
-
Additional information supplied in the Sports Illustrated article was that 34.6% of all professional baseball players are from Latin-American countries, but 368 of the 595 (61.8%) players suspended...
-
The flexible budget formula is fixed costs $50,000 plus variable costs of $4 per direct labor hour. What is the total budgeted cost at (a) 9,000 hours and (b) 12,345 hours?
-
Flexible budget formulas and interpolation Required: 1. Using the facts and the flexible budget prepared in Part (1) of P7-7 above, determine the budgeted cost at 96% of capacity, using...
-
The Apache NetBeans IDE is mainly composed of NetBeans Open-Source IDE and NetBeans Platform. (True/False)
-
Calculate the rms value of the waveform shown in Fig P 9.39 vt) (V) t
-
How does strategic group analysis enable a company to understand its competitors?
-
What are the key elements of a project scope document?
-
A Barberton Glass Co. truck was transporting large sheets of glass down the highway. Elliot Schultz was driving his automobile some distance behind the truck. Because of the negligent way that the...
-
Comparing Net Present Value with Internal Rate of Return 1. Starting from the Excel spreadsheet and using the =IRR(values,[guess]) Excel function, calculate the Internal Rate of Return (IRR) for...
-
Anak Chips Sdn Bhd manufactures and sells electronic chips. Anak Chips has an issued share capital of RM1,000,000 and is wholly owned by Mother Board Sdn Bhd, a company with an issued share capital...
-
The owner of Firewood To Go is considering buying a hydraulic wood splitter which sells for $50,000. He figures it will cost an additional $100 per cord to purchase and split wood with this machine,...
-
Should commercial speech receive less first amendment protection than other types of speech, or does this violate the rights of corporations? Please do not just copy the Nike answer, I am looking for...
-
The amount of debt for selected countries in 2013 is given in the table below (trn means trillions): Country Debt Britain..............................1.4 trn Canada...................1.2 $CDN trn...
-
In an experiment to determine the calorific value of octane \(\left(\mathrm{C}_{8} \mathrm{H}_{18} ight)\) with a bomb calorimeter the mass of octane was \(5.42195 \times 10^{-4} \mathrm{~kg}\), the...
-
A stoichiometric mixture of carbon monoxide and air reacts in a combustion chamber, forms exhaust products at \(3000 \mathrm{~K}\) and 1 bar. If the products are in chemical equilibrium, but no...
-
One method of reducing the maximum temperature in an engine is to run with a rich mixture. A spark-ignition engine with a compression ratio of 10:1, operating on the Otto cycle, runs on a rich...
-
A gas injection system supplies a mixture of propane \(\left(\mathrm{C}_{3} \mathrm{H}_{8} ight)\) and air to a spark-ignition engine, in the ratio of volumes of 1:30. The mixture is trapped at 1 bar...
-
Show that the Walsh matrix \(\mathbf{W}\) has the property \(\mathbf{W}_{(m)}^{2}=m \mathbf{I}_{(m)}\), where each of the matrices is of order \(m\).
-
Part A. Indicate whether each of the six items above would increase, decrease, or have no effect on Teds net income. What would be the total value of this increase or decrease? Part B. Based on the...
-
(a) Water flows through the nozzle of a garden hose. Find an expression for m in terms of line pressure P 1 , ambient pressure P 2 , inside hose diameter D 1 , and nozzle outlet diameter D 2 . Assume...
-
Give two limitations of the physical-measure method of joint-cost allocation.
-
Give two limitations of the physical-measure method of joint-cost allocation.
-
Give two limitations of the physical-measure method of joint-cost allocation.
-
Image transcription text 1. A cylindrical specimen of cold-worked copper (see Fig. below) has experienced a ductility of 25%EL. If its cold worked radius is 10 mm, what was its radius before...
-
Question 2 As a project manager, you need to synthesize information about a problem to stakeholders. What should you do first in your synthesizing process? Describe Briefly.
-
Please help me as much as you can!! I will take all your effort to solve this problem and will give you a good rate!!! Please show all the calculations in detail! Also, please do not copied and...
Study smarter with the SolutionInn App