Flexible Budget Analysis

Double check and help bottom part please

** Please enter values for yellow highlighted cells **

Flexible Actual Budget Flexible Results Variance Budget 5,000 5,000 275,000 25,000 10 250,000 Sales Price/ Volume Static Variable Variance Budget Cost/Unit (1,000) LU 6,000 1 (50,000)U 300,000 $50.00 Price/ Variable Cost/Unit Units Soldi 1 Revenue $ 55.00 Variable Costs Direct Material $ 13.00 Direct Labor! 4.00 Variable Overhead 2.00 Total Variable Costs $ 19.00 Contribution Margin 36.00 Fixed Costs Advertising Rent 65,000 5,000 20,000 5,000 10,000 95,000 10,000 180,000 25,000 !U! 60,000 u 15,000 10,000 U 85,000 Fi 165,000 12,000F72,000 $12.00 3,000 F 18,000 $3.00 2,000F 12.000 $2.00 17,000 F! 102,000 $17.00 (33,000) 0 198,000 $33.00 20,000 23,000 137.000 20,000 23,000 203,000 Tu! 8,000 U! 20,000 Yu 170,000 handed in Y (1.000) D Your CRN All Instructions are in Red. Only enter your answers in the Yellow cells 1) Complete the Schedule below using other formulas or values for Planters, a manufacturer of large clay pots for growing plants Flexible Budget Analysis 10 points Price/ Flexible Sales Price/ Variable Actual Budget Flexible Volume Static Variable Score Cost/Unit Results Variance Budget Variance Hudget Cost/Unit Units Sold 5.000 5.000 6,000 Revenue 55.00 275,000 25,000 UP 250,000 {50.000 300.000 $50.00 30 Variable costs 11 Direct Material 13.00 65,000 5.000 FU 60,000 12.000 72.000 $12.00 12 Direct Labor 4.00 20.000 5,000 UP 15,000 3,000 18,000 $3.00 Variable Overheads 2.00 13 10,000 10,000 12,000 2,000F $2.00 14 Total Variable Costs 19.00 95.000 10.000 0 85.000 17,000 103.000 $12.00 Contribution Margin 36.00 100,000 25,000 15 165 000 (33,000 U 190.000 933.00 10 Fixed Costs 20.000 Advertising 20,000 10 0.000 Rent 23,000 23.000 HU 18 20.000 203.000 U 170,000 137,000 19 Operating Income 20 2 Short Answer: Evaluate the performance of the Sales and Marketing Manager for the care out the caly the presedis Yellow 21 points 22 Score 24 3 Sheit Answer: Evaluate the performance of the Production Manager for the current month: Use only the space provided to Yellow Spinti F ENNUS Score