Question

Ray Company provided the following excerpts from its Production Department's flexible budget performance report. (Round "rate per hour" answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Flexible war Spending Variances Results Budget 9,660 9,660 Activity Variances Planning Budget 9,180 Labor-hours (q) Direct labor ( $ 23.009) $ 224,370 | $ 222,180 $ 22,090 Indirect labor U 1,960 F 1,630 u $ $ 11.50/9) Utilities $ 8,300 + q) $ 1,200 U $ 31,250 Supplies q) $ $ 5,192 + 4,624 $ 4,480 Equipment depreciation | $ $ 82,900 0 None 0 None Factory administration 19.060| " | 1.70 + Total expense $ 400,834

Answer 1

Solution:

Ray Company
Production Department Flexible Budget Performance Report
For the Month Ended August 31
Particulars						Actual Results	Spending Variances		Flexible Budget	Activity Variances		Planning Budget
Labor-hours (q)						9,660			9,660			9,180
Direct labor	(	$23	q)			$224,370.00	$2,190.00	U	$222,180.00	$11,040.00	U	$211,140.00
Indirect labor	(	$7,600.00	+	$1.50	q)	$20,130.00	$1,960.00	F	$22,090.00	$720.00	U	$21,370.00
Utilities	(	$8,300	+	$2.50	q)	$34,080.00	$1,630.00	U	$32,450.00	$1,200.00	U	$31,250.00
Supplies	(	$1,726.00	+	$0.30	q)	$5,192.00	$568.00	U	$4,624.00	$144.00	U	$4,480.00
Equipment depreciation	(	$82,900	)			$82,900.00	$0.00	None	$82,900.00	$0.00	None	$82,900.00
Factory administration	(	$19,060	+	$1.70	q)	$34,162.00	$1,320.00	F	$35,482.00	$816.00	U	$34,666.00
Total expense						$400,834.00	$1,108.00	U	$399,726.00	$13,920.00	U	$385,806.00

Excel 8 - Microsoft Excel X 90 = File Home Insert Page Layout Formulas Data Review View - 2 x Calculate Now Insert Function Math More & Trig Functions A a Define Name Use in Formula Name Manager Create from Selection Defined Names Trace Precedents 5 Show Formulas Trace Dependents Error Checking Watch Remove Arrows" Evaluate Formula Window Formula Auditing Calculation Calculate Sheet Options Calculation AutoSum Recently Financial Logical Text Date & Lookup & - Used - Time Reference Function Library 070 fx A B C D E F G H L M N O P Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Spending Actual Results Variances 9660 Particulars Flexible Budget Activity Variances Planning Budget 9180 Labor-hours (9) =H6 U =H8-K8 1960 1630 F Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory administration Total expense (I=K8/K6 224370 (=K9-(K6*F9) 9) =K9-19 (8300 1=(N10-D10)/N6 =K10+110 (=K11-(K6*F11) +=(K11-N11)/(K6-N6) g) 5192 (82900 =K12+112 (19060 + 1.7 =H14-H8-H9-H10-H11-H12 400834 =H11-K11 U 222180 =K8-N8 U =N6*D8 22090 =K9-N9 JU =D9+(N6*F9) =N10+L10 1200 31250 4624 -K 11-N11 4480 =D12 None I=D12 =D13+K6*F13) =K13-N13 u =D13+N6*F13) =SUM(K8:K13) 1=K14-N14 U =SUM(N8:N13) None =K13-H13 =H14-K14 U K 24 M Ready Sheet94 Sheet450 (2) Sheet817 (2) Sheet521 Sheet423 (13) Sheet294 (2) Sho Sheet92 Sheet350 (3) Circular References BO! 100% - @o e o 180 - Myou paid. Ma Ww. Answers , Download secuni. 2510 4 W 10:16 AM 11/6/2019