Question

In: Accounting

1. Compute The Variance in the Budget vs Actual Report Below. Indicate in Column G whether...

1. Compute The Variance in the Budget vs Actual Report Below. Indicate in Column G whether the variance is Favorable (F) or Unfavorable (U)
2. Prepare a Flexible Budget to match the Actual Sales, Compute the Variance and again indicate whether Favorable or Unfavorable
3. Comment on the difference between the reports. Is the units produced variance important? What is the overall difference?, etc.
Wireless Buds, LLC
Performance Report - Budget vs Actual
Quarter ended March 31, 2018
Static Budget Actual Variance Favorable/ Unvavorable
Units Produced      25,000      22,800
Variable Costs:
Direct Materials      75,000      66,120
Direct Labor      62,500      62,700
Indirect Materials      50,000      44,460
Indirect Labor      37,500      39,900
Utilities      25,000      25,080
Total Variable Costs     250,000     238,260
Fixed Costs:
Supervisory Salaries      90,000      90,500
Depreciation      25,000      24,800
Property Insurance        6,000        5,500
Real Estate Taxes        5,000        5,600
Total Fixed Costs     126,000     126,400
Total Overhead $ 376,000 $ 364,660
Wireless Buds, LLC
Performance Report - Budget vs Actual
Quarter ended March 31, 2018
Flexible Budget Actual Variance Favorable/ Unvavorable
Units Produced      22,800
Variable Costs:
Direct Materials      66,120
Direct Labor      62,700
Indirect Materials      44,460
Indirect Labor      39,900
Utilities      25,080
Total Variable Costs     238,260
Fixed Costs:
Supervisory Salaries      90,500
Depreciation      24,800
Property Insurance        5,500
Real Estate Taxes        5,600
Total Fixed Costs     126,400
Total Overhead $ 364,660

Solutions

Expert Solution


Related Solutions

Below is the variance report Prior year Item Budget Actual Variance Variance % Actual Days in...
Below is the variance report Prior year Item Budget Actual Variance Variance % Actual Days in time period 31 31 31 Staffed Beds 20 20 20 Patient days 527 498 (29.0) -5.5% 415 Total RN FTEs 45.1 50.1 (5.0) -11.1% 36.7 Revenue: Gross patient revenue $460,450 $441.932 ($18,518) -4.0% $417,883 Personnel Expense: Total salaries and wages $171,920 $192,845 ($20,925) -12.2% $141,552 Benefits $51,576 $52,797 ($1,221) -2.4% $42,466 Total personnel expenses $223,496 $245,642 ($22,146) -9.9% $184,018 Overtime wages % 2.0% 6.1%...
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...
Discussion Question 1: Budget vs. Actual Describe why percentage changes identified in the budgeted vs. actual...
Discussion Question 1: Budget vs. Actual Describe why percentage changes identified in the budgeted vs. actual reports need to be interpreted carefully. Provide a numerical example to aid in your explanation. Discussion Question 2: Paper vs. Excel vs. QuickBooks Based on what you have learned in studying accounting in textbooks and in some cases utilizing Microsoft Excel templates for completing assignments, would you prefer to use paper, Excel, or QuickBooks to prepare financial statements and reports? Would you use just...
Given the information below, What is the total variance in the actual and static budget? DeFleur...
Given the information below, What is the total variance in the actual and static budget? DeFleur manufactures bicycles. The bicycles are manufactured in two divisions. In the framing division, the carbon bicycle frames are manufactured. In the assembly division, the components are assembled to the frame and the bike is ready for sale. There is no market for the unassembled frames and all manufactured frames are transferred to the assembly division. For the purposes of performance evaluation, the framing division...
1) Describe an example of how an unfavorable variance between actual and budget amounts in a...
1) Describe an example of how an unfavorable variance between actual and budget amounts in a fixed static (master) budget can become a favorable variance in a flexible budget report. 2) Also, since flexible budget is more accurate in measuring performance, can company just develop flexible budget without the static budget? Why or why not?
Compute the segment margin in the budget and actual columns of the table and then fill...
Compute the segment margin in the budget and actual columns of the table and then fill in the variance column. Explain why the segment margin was not what it was expected to be and identify the two biggest factors that caused the difference. Budget Actual Var. Sales – A $255,000 $224,000 Sales – B $465,000 $436,000 Total Sales $720,000 $660,000 Variable Costs: Manufacturing $105,000 $126,000 Advertising & Marketing $75,000 $74,000 Administrative & General $28,000 $26,000 Total Variable Costs $208,000 $226,000...
Prepare a variance analysis between the budget and actual. You should present three variances: (1) the...
Prepare a variance analysis between the budget and actual. You should present three variances: (1) the difference in profit due to selling more or less units, (2) the difference in profit due to selling units at a higher or lower price, and (3) the difference in profit due to producing more or less units. In terms of variances, discuss the budget and the actual performance and changes needed to make in the budget. (Please answer all questions including discussion question)...
Define the standardized employment budget. Analyze whether the actual budget or the standardized employment budget, is...
Define the standardized employment budget. Analyze whether the actual budget or the standardized employment budget, is more helpful when discussing the long term health of the economy.
1. Identify the situation below that will result in a favorable variance. Multiple Choice Actual revenue...
1. Identify the situation below that will result in a favorable variance. Multiple Choice Actual revenue is higher than budgeted revenue. Actual revenue is lower than budgeted revenue. Actual income is lower than expected income. Actual costs are higher than budgeted costs. Actual expenses are higher than budgeted expenses. 2 Hassock Corp. produces woven wall hangings. It takes 2 hours of direct labor to produce a single wall hanging. Hassock’s standard labor cost is $12 per hour. During August, Hassock...
Describe an example of how an unfavorable variance between actual and budget amounts in a fixed...
Describe an example of how an unfavorable variance between actual and budget amounts in a fixed static (master) budget can become a favorable variance in a flexible budget report. Also, since flexible budget is more accurate in measuring performance, can company just develop flexible budget without the static budget? Why or why not?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT