Question

1 Approved Answer

Posted on Jul 15, 2024

0 E F G H Kelsey's Frozen Confectionaries Master Budget Performance Report For the month ended June 30 ACTUAL 21460 MASTER VARIANCE 20,000 $ 1460

0 E F G H Kelsey's Frozen Confectionaries Master Budget Performance Report For the month ended June 30 ACTUAL 21460 MASTER VARIANCE 20,000 $ 1460 VAR % 7.30% For U F Investigate? No Volume in cases) 1000,000 $ 131020 13.10% F No No les 600.000 $ 50.000 $ 40.000 $ 9.000 $ 301000 $ 82 880 8.685 4213 7930 27 312 13.8174 17.37% 10.53% 88.11% 9074 TCCCC Yes No Yes No Sales Revenue $ 1.131.020 $ Less Variable Expenses Cost of Goods Sold $682 880 $ Sales Commissions $ 58,685 $ Shipping Expense $ 44,213 $ Bad debt expense $ 16,930$ Contribution Margin $ 328,312 $ Less Fixed Expenses Salaries $ 43.000 $ Lease on Disin center $ 15.500 $ Deprec on fleel'equip $ 12,000 $ Advertising $ 7750 $ Office rent, phone, ne $ 12,300 $ Operating Income $ 237.7625 3.000 (1500) 40,000 $ 17,000 $ 12.000 $ 10.000 $ 11.000 $ 211.000 $ 7.504 -8.82% 0.00% -22 50% 11.82% 12.68% SLLLL No No No Yes No No (2.250) 1300 26,762 Kelsey's Frozen Confectionaries Fexible Budget Performance Report For the month ended June 30 Flexible Budget ACTUAL Variance 21.460 $ FLEXIBLE Volurne MASTER BUDGET Variance BUDGET $ 21460 $ 1,460 $ 20.000 Volume (in cases) Sales Revenue $ 1.131.020 $ 58.020 $ 1073.000 $ 73.000 $ 1.000.000 Less Variable Expenses Cost of Goods Sold $ 682.880 $ 39.080$ 643.800 $ 43,800 $ 600.000 Sales Commissions $ 58,685 $ 5.035 $ 53,650 $ 3,650 $ 50 000 Shipping Expense $ 44,213 $ 12935 42.920 $ 2.920 $ 40.000 Bad debt expense $ 16.930 $ 72735 9,657 $ 657 $ 9,000 Contribution Margin $ 328 312 $ 5.3395 322 973 $ 219735 301.000 Less Fixed Expenses Salaries $ 43,000 $ 3.000$ 40,000 $ $ 40.000 Lease on Distn certe $ 15,500 $ (1500) 17,000 $ $ 17 000 Deprec on fleetlequi $ 12,000 $ $ 12.000 $ $ 12.000 Advertising $ 7,750 $ 12.250) $ 10,000 $ $ 10,000 Office rent phone n. $ 12.300 $ 1300$ 11,000 $ $ 11.000 Operating Income 237 762$ 47996 232 973.5 21.9735 211.000 Report Analysis- page 1 Analysis- page 2 Grading Rubric venite and Yes No Athena What there for What DO the best pe Your answers to each question should be shown in the shaded cells mabwawa ROTO perem UND Marley Www Selle wat net 10 W watery worth ww! 0 E F G H Kelsey's Frozen Confectionaries Master Budget Performance Report For the month ended June 30 ACTUAL 21460 MASTER VARIANCE 20,000 $ 1460 VAR % 7.30% For U F Investigate? No Volume in cases) 1000,000 $ 131020 13.10% F No No les 600.000 $ 50.000 $ 40.000 $ 9.000 $ 301000 $ 82 880 8.685 4213 7930 27 312 13.8174 17.37% 10.53% 88.11% 9074 TCCCC Yes No Yes No Sales Revenue $ 1.131.020 $ Less Variable Expenses Cost of Goods Sold $682 880 $ Sales Commissions $ 58,685 $ Shipping Expense $ 44,213 $ Bad debt expense $ 16,930$ Contribution Margin $ 328,312 $ Less Fixed Expenses Salaries $ 43.000 $ Lease on Disin center $ 15.500 $ Deprec on fleel'equip $ 12,000 $ Advertising $ 7750 $ Office rent, phone, ne $ 12,300 $ Operating Income $ 237.7625 3.000 (1500) 40,000 $ 17,000 $ 12.000 $ 10.000 $ 11.000 $ 211.000 $ 7.504 -8.82% 0.00% -22 50% 11.82% 12.68% SLLLL No No No Yes No No (2.250) 1300 26,762 Kelsey's Frozen Confectionaries Fexible Budget Performance Report For the month ended June 30 Flexible Budget ACTUAL Variance 21.460 $ FLEXIBLE Volurne MASTER BUDGET Variance BUDGET $ 21460 $ 1,460 $ 20.000 Volume (in cases) Sales Revenue $ 1.131.020 $ 58.020 $ 1073.000 $ 73.000 $ 1.000.000 Less Variable Expenses Cost of Goods Sold $ 682.880 $ 39.080$ 643.800 $ 43,800 $ 600.000 Sales Commissions $ 58,685 $ 5.035 $ 53,650 $ 3,650 $ 50 000 Shipping Expense $ 44,213 $ 12935 42.920 $ 2.920 $ 40.000 Bad debt expense $ 16.930 $ 72735 9,657 $ 657 $ 9,000 Contribution Margin $ 328 312 $ 5.3395 322 973 $ 219735 301.000 Less Fixed Expenses Salaries $ 43,000 $ 3.000$ 40,000 $ $ 40.000 Lease on Distn certe $ 15,500 $ (1500) 17,000 $ $ 17 000 Deprec on fleetlequi $ 12,000 $ $ 12.000 $ $ 12.000 Advertising $ 7,750 $ 12.250) $ 10,000 $ $ 10,000 Office rent phone n. $ 12.300 $ 1300$ 11,000 $ $ 11.000 Operating Income 237 762$ 47996 232 973.5 21.9735 211.000 Report Analysis- page 1 Analysis- page 2 Grading Rubric venite and Yes No Athena What there for What DO the best pe Your answers to each question should be shown in the shaded cells mabwawa ROTO perem UND Marley Www Selle wat net 10 W watery worth ww