Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Evaluate the company's performance using the Static and Flexible budget reports. The Squeaky Horn Flexible Budget Performance Report For the Year Ending December 31, 2020
Evaluate the company's performance using the Static and Flexible budget reports.
The Squeaky Horn Flexible Budget Performance Report For the Year Ending December 31, 2020 Budgeted Actual Flexible Amount per (4,405 jobs) Budget Unit (4,405 jobs) Flexible Budget Variance $ 150.21 $ 664,170.00 $ 661,657.21 $2,512.79 F Revenue Less variable expenses: Owner Salaries - Base Owner Salaries - Bonus Band Repairers Wages Orchestral Repairers Salaries Rush Job Wages Replacement Parts Delivery Total variable expenses Contribution margin 41.19 7.51 16.75 26.09 0.86 18.51 10.50 121.41 28.80 180,000.00 33,209.00 104,400.00 121,200.00 3,850.00 92,050.00 53,961.00 588,670.00 75,500.00 181,441.65 33,082.86 73,786.27 114,913.04 3,780.03 81,547.94 46,252.50 534,804.30 126,852.91 1,441.65 126.14 30,613.73 6,286.96 69.97 10,502.06 7,708.50 53,865.70 51,352.91 C C C C TI U U U $ F 500.00 U Less fixed expenses: Advertisiing Depreciation Office Rent Miscellaneous Total fixed expenses Operating Income None None 12,500.00 12,000.00 3,600.00 3,600.00 48,000.00 48,000.00 4,400.00 4,500.00 68,500.00 68,100.00 $ 7,000.00 $ 58,752.91 F 100.00 400.00 51,752.91 The Squeky Horn Static Budget Performance Report For the Year Ending December 31, 2020 Actual Plan/ Static Budget Static Budget Variance $ 664,170.00 $ 656,400.00 $ 7,770.00 F. None U U Revenue Less variable expenses: Owner Salaries - Base Owner Salaries - Bonus Band Repairers Wages Orchestral Repairers Salaries Rush Job Wages Replacement Parts Delivery Total variable expenses Contribution margin U 180,000.00 33,209.00 104,400.00 121,200.00 3,850.00 92,050.00 53,961.00 588,670.00 75,500.00 180,000.00 32,820.00 73,200.00 114,000.00 3,750.00 80,900.00 45,885.00 530,555.00 125,845.00 U 389.00 31,200.00 7,200.00 100.00 11,150.00 8,076.00 58,115.00 50,345.00 U U U U U Less fixed expenses: Advertisiing Depreciation Office Rent Miscellaneous Total fixed expenses Operating Income 12,500.00 3,600.00 48,000.00 4,400.00 68,500.00 $ 7,000.00 $ 12,000.00 500.00 3,600.00 48,000.00 4,500.00 100.00 68,100.00 400.00 57,745.00 $ 50,745.00 None None F U UStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started