Write business memo that discusses a different variance (favorable or unfavorable) in each of the four quarters analyzed. Be creative and provide a detailed explanation of what could have caused the variance. You can make suggestions on what to do in the future to either repeat it or reduce it.
me Statement Quarterly Variance Analysis - Year 2 01 Actual 01 Budget Variance For U 42,000 42,317 (317) U 30,600 30,440 160 F 72,600 72,757 (157) U 45,810 45,110 700 U 26,790 27,648 (858) U Q2 Actual Q2 Budget Variance For U 52,010 50,781 1,229 F 39,500 36,528 2,972 F 91,510 87,309 4,201 F 51,515 50,639 876 U 39,995 36,670 3,325 475 U New construction revenue Remodel revenue Total revenue Less: Cost of goods sold Gross profit Less: Selling and admin expenses Salaries expense Marketing expense Legal expense Business development expense Depreciation expense Office supplies expense Miscellaneous expense Total selling and admin expenses Net operating income (395) (280) 168 400 C C TI TI 78 350 4,530 1,400 3,890 3,650 775 800 1,910 16,955 9,835 4,925 1,680 3,722 3,250 775 964 1,804 17,121 10,527 5,400 2,500 3,800 3,600 775 1,500 1,850 19,425 20,570 4,925 2,500 3,722 3,250 775 1,109 2,026 18,307 18,363 (164) 106 (166) (692) F U F U 391 (176) 1,118 2,207 TIC TIC Q3 Actual Q3 Budget Variance For U 51,200 50,781 419 36,500 36,528 (28) U 87,700 87,309 391 F 54,400 54,131 269 U 33,300 33,177 123 F Q4 Actual Q4 Budget Variance For U 41,600 42,317 (717) U 29,700 30,440 (740) U 71,300 72,757 (1,457) 40,940 42,199 (1,259) F 30,360 30,558 (198) U New construction revenue Remodel revenue Total revenue Less: Cost of goods sold Gross profit Less: Selling and admin expenses Salaries expense Marketing expense Legal expense Business development expense Depreciation expense Office supplies expense Miscellaneous expense Total selling and admin expenses Net operating income TIC 5,910 2,950 3,125 4,500 900 1,109 2,230 20,724 12,576 4,950 2,346 3,722 4,400 875 1,109 2,165 19,567 13,610 960 604 (597) 100 25 0 65 1,157 (1,034) U U F U U 6,200 1,460 3,722 3,900 920 1,240 1,850 19,292 11,068 5,910 1,694 3,722 4,400 875 964 1,688 19,253 11,305 290 (234) (0) (500) 45 276 162 39 (237) CCCCCT CCC me Statement Quarterly Variance Analysis - Year 2 01 Actual 01 Budget Variance For U 42,000 42,317 (317) U 30,600 30,440 160 F 72,600 72,757 (157) U 45,810 45,110 700 U 26,790 27,648 (858) U Q2 Actual Q2 Budget Variance For U 52,010 50,781 1,229 F 39,500 36,528 2,972 F 91,510 87,309 4,201 F 51,515 50,639 876 U 39,995 36,670 3,325 475 U New construction revenue Remodel revenue Total revenue Less: Cost of goods sold Gross profit Less: Selling and admin expenses Salaries expense Marketing expense Legal expense Business development expense Depreciation expense Office supplies expense Miscellaneous expense Total selling and admin expenses Net operating income (395) (280) 168 400 C C TI TI 78 350 4,530 1,400 3,890 3,650 775 800 1,910 16,955 9,835 4,925 1,680 3,722 3,250 775 964 1,804 17,121 10,527 5,400 2,500 3,800 3,600 775 1,500 1,850 19,425 20,570 4,925 2,500 3,722 3,250 775 1,109 2,026 18,307 18,363 (164) 106 (166) (692) F U F U 391 (176) 1,118 2,207 TIC TIC Q3 Actual Q3 Budget Variance For U 51,200 50,781 419 36,500 36,528 (28) U 87,700 87,309 391 F 54,400 54,131 269 U 33,300 33,177 123 F Q4 Actual Q4 Budget Variance For U 41,600 42,317 (717) U 29,700 30,440 (740) U 71,300 72,757 (1,457) 40,940 42,199 (1,259) F 30,360 30,558 (198) U New construction revenue Remodel revenue Total revenue Less: Cost of goods sold Gross profit Less: Selling and admin expenses Salaries expense Marketing expense Legal expense Business development expense Depreciation expense Office supplies expense Miscellaneous expense Total selling and admin expenses Net operating income TIC 5,910 2,950 3,125 4,500 900 1,109 2,230 20,724 12,576 4,950 2,346 3,722 4,400 875 1,109 2,165 19,567 13,610 960 604 (597) 100 25 0 65 1,157 (1,034) U U F U U 6,200 1,460 3,722 3,900 920 1,240 1,850 19,292 11,068 5,910 1,694 3,722 4,400 875 964 1,688 19,253 11,305 290 (234) (0) (500) 45 276 162 39 (237) CCCCCT CCC
