Question

Finish the following variance report with the information given Commitments - salaries: $-315,587, grants: $100,213, O&M:...

Finish the following variance report with the information given

Commitments - salaries: $-315,587, grants: $100,213, O&M: $45,856

Projections - salaries: $-52,000, grants: $410,213, O&M: $14,856

Annual budget YTD expenditures YTD commitments Projected expenditures Year end projection year end % variance
Salaries 525,000 152,347
Grants 1,250,000 785,625
O&M 333,000 115,478
total 2,108,000 1,053,450

Homework Answers

Answer #1
Particulars Annual budget YTD expenditures YTD commitments Projected expenditures Year end projection year end % variance
Salaries 525,000 152,347      315,587           52,000.00 519,934 1%
Grants 1,250,000 785,625      100,213        410,213.00 1,296,051 -4%
O&M 333,000 115,478         45,856           14,856.00 176,190 47%
Total 2,108,000 1,053,450 461,656         477,069 1,992,175 5%
Please do upvote if you found the answer useful.
Feel free to reach in the comment section in case of any clarification or queries.
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are given the following static budget report: Budget            Actual              Variance Unit Sales  &nbsp
You are given the following static budget report: Budget            Actual              Variance Unit Sales                                           10,000               15,000             5,000 F Variable Expenses:     Commissions                                  $30,000 $33,000 $3,000 U     Advertising                                      $1,000 $1,200 $200 U     Travel                                              $10,000 $11,000 $1,000 U     Samples                                          $2,500 $2,300 $200 F Total Variable                                     $43,500 47,500 $4,000 U Fixed Expenses     Rent                                                 $5,000 $5,000 0     Salaries – Sales                               $2,000 $2,000 0     Salaries – Office                              $1,200 $1,200 0     Depreciation                                    $1,500 $1,500 0 Total Fixed                                          $9,700 $9,700             0 Total Expenses $53,200 $57,200 $4,000 U Prepare a flexible budget analysis and explain whether you believe that costs were controlled.  How do the results of...
1. Given the following performance report, determine the total amount of variance and if it is...
1. Given the following performance report, determine the total amount of variance and if it is favorable or unfavorable. Actual costs: Maintenance is $50,000; Power is $80,000; and Indirect Labor is $10,000. Budgeted costs: Maintenance is $45,000; Power is 81,000; and Indirect Labor is $8,000. a. 6,000 U b. 6,000 F c. 12,000 U d.12,000F 2. We prepare a budget based on manufacturing 20,000 chairs this month. Budgeted costs are: Fixed manufacturing costs = $50,000 per month; Variable manufacturing costs...
Please locate the following information in your current annual report and in your Journal answer the...
Please locate the following information in your current annual report and in your Journal answer the following questions: What is the sales revenue for the most current accounting period? What is the total reported stockholders’ equity for the most current accounting period? By how much did cash increase or decrease during the current year? What cash expenditures did your company make for property, plant, and equipment during the current year? What are the classes of stock, both authorized and unauthorized?...
Factory Overhead Cost Variance Report Tiger Equipment Inc., a manufacturer of construction equipment, prepared the following...
Factory Overhead Cost Variance Report Tiger Equipment Inc., a manufacturer of construction equipment, prepared the following factory overhead cost budget for the Welding Department for May of the current year. The company expected to operate the department at 100% of normal capacity of 8,400 hours. Variable costs: Indirect factory wages $30,240 Power and light 20,160 Indirect materials 16,800     Total variable cost $67,200 Fixed costs: Supervisory salaries $20,000 Depreciation of plant and equipment 36,200 Insurance and property taxes 15,200     Total fixed...
"A firm is considering purchasing a new milling machine and has collected the following information for...
"A firm is considering purchasing a new milling machine and has collected the following information for its income statement and cash flow statement. However, this income statement was calculated as if there is no inflation! All dollars are expressed in constant (year-0) dollars. Recalculate the income and cash flow statement by assuming there is a general (average) inflation of 3.9% applied to revenue, O&M, and salvage value. - The firm will pay back the loan in 2 years, and the...
[The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the...
[The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,150,000 Cost of goods sold Direct materials $ 975,000 Direct labor 225,000 Machinery repairs (variable cost) 60,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($30,000 is variable) 210,000 Plant management salaries 210,000 1,995,000 Gross profit 1,155,000...
Pebco Company’s 2011 master budget included the following fixed budget report. It is based on an...
Pebco Company’s 2011 master budget included the following fixed budget report. It is based on an expected production and sales volume of 17,000 units.    PEBCO COMPANY Fixed Budget Report For Year Ended December 31, 2011   Sales $ 3,400,000   Cost of goods sold      Direct materials $ 1,005,000      Direct labor 225,000      Machinery repairs (variable cost) 75,000      Depreciation—plant equipment 315,000      Utilities ($50,000 is variable) 210,000      Plant management salaries 215,000 2,045,000       Gross profit 1,355,000   Selling expenses      Packaging 80,000      Shipping 115,000      Sales salary...
"A firm is considering purchasing a new milling machine and has collected the following information for...
"A firm is considering purchasing a new milling machine and has collected the following information for its income statement and cash flow statement. However, this income statement was calculated as if there is no inflation! All dollars are expressed in constant (year-0) dollars. Recalculate the income and cash flow statement by assuming there is a general (average) inflation of 3.5% applied to revenue, O&M, and salvage value. - The firm will pay back the loan in 2 years, and the...
"A firm is considering purchasing a new milling machine and has collected the following information for...
"A firm is considering purchasing a new milling machine and has collected the following information for its income statement and cash flow statement. However, this income statement was calculated as if there is no inflation! All dollars are expressed in constant (year-0) dollars. Recalculate the income and cash flow statement by assuming there is a general (average) inflation of 4.9% applied to revenue, O&M, and salvage value. - The firm will pay back the loan in 2 years, and the...
1- In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible...
1- In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 300,000 units of the standard model and 120,000 units of the deluxe model during the coming year. The standard model requires 0.05 direct labor hour per unit, and the deluxe model requires 0.08. The controller has developed the following cost formulas for...