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

Expert Solution

ekkarill92 answered 2 years ago

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?

Question