Please calculate Static budget ,actual budget , flexible Budget , static & flexible variance analysis , material variance & labor variance

Clipboard Font Alignment Number Styles Cells Enditing Analysis Sensitivity 615 X v fr D E F G H 1 N Parameters -budget Parameters - actual Quarter Quarters Year thoung Sales ( hours]: Budgeted total sales in hours 4,090 4,900 4.300 5,200 18,400 Actual total sales 3,800 5,000 3,900 5,100 17./100 geted commercial sales in hours 2,800 3,430 3,010 3,640 12,880 Actual sales - commercial 2,660 3,500 2.730 3,570 12.460 ential sales in hours 1,200 1.470 1,290 1.560 5,520 Actual sales . residential 1,140 1,500 1,170 1530 5.340 ig price ( 5/hil Selling price ( $/hurl 9 Filing price per hour (commercial $40 940 $40 540 Actual selling price commercial $10 $40 $40 $40 10 Selling price per hour fresidential) 450 $50 $50 Actual sellling price -residential $50 $50 $50 12 Direct labour expense [ S/hir]: S 20 5 20 5 20 $ 20 Direct labour expense ( $/hi] S 18 5 18 5 ing Supply usage [ Etre / labour hour]: Actual Cleaning Supply usage [ litre / labour hours 15 Corum mercial 0.2 0.2 0.2 0.2 7 Commerical 3.19 0.19 3,19 0.19 15 Repdential 0.1 0.1 0.1 0.1 Residential 0.09 0.09 0.09 0.09 17 18 Dear apply expense [ $/litrell: 5.50 5 5.50 $ 5.50 5 5 50 Actual Cleaning Supply expense ( $/uitre): 5.6 5 5.6 5 5.6 5 5.6 20 Fired overhead: Actual Fled ovech 21 Receptionist 6,250 6,250 6,250 6,250 25,000 Receptionist 6,000 5,750 5,900 23,950 22 Depreciation 9.375 9,375 9,375 9,375 37,500 Depreciation 9,375 9,375 9,375 9,375 37,500 7,500 7,500 7,500 7 500 30,000 Gas 7,200 7,800 7,100 7.000 29,100 24 Office Supplies 1.DOO 1,000 1,000 1,000 4,000 Office Supplies 950 1.100 1,050 1,000 4,190 25 Total no. of hours actually paid to employees 21,360 27 Breakdown: 28 Commercial 3,192 4.200 3,276 4,784 14,952 29 Residential 1,36 1,800 1,404 1,836 6,40 Actual hours worked 4,560 6,000 1.680 6.120 21,360 21 Direct labour cost 82,080 1,08,000 84,240 1,10,160 3,84,480 32 33 Unproductive ( unbilled ] factor 2016 20% 20% Static Budget Actual Budget Flexible Budget Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric Type here to search ENG