Question
Ray Company provided the following excerpts from its Production Departments flexible budget performance report. Required: Complete the Production Departments Flexible Budget Performance Report. (Indicate the
Ray Company provided the following excerpts from its Production Departments flexible budget performance report. Required: Complete the Production Departments Flexible Budget Performance Report. (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. Round "rate per hour" answers to 2 decimal places.)
Need help with all the red x's
GIVEN:
labor-hours for actual results = 9540
labor-hours for planning budget = 9060
direct labor actual results = 164250
direct labor flexible budget = 162180
indirect labor variable portion of cost formula = $1.50
indirect labor spending variance = 1840 F
indirect labor flexible budget = 21790
utilities fixed portion of cost formula = 7100
utilities spending variance = 1510
utilities activity variance = 624 U
utilities planning budget = 18878
supplies actual results = 5024
supplies flexible budget = 4504
supplies planning budget = 4360
equipment depreciation = 79900, spending variance = 0, activity variance = 0
factory administration fixed portion of cost formula = 18820, variable portion of cost formula = 1.50
Total expense of actual results = 322066
Answer is complete but not entirely correct. Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Spending Flexible Results Variances Budget 9,540 9,540 Activity Variances Planning Budget 9,060 Labor-hours (9) s + 9) S 17.00) $ 7,615 X $ 7,100 $ 1,015 + S > 79,900 $ 1.50 $ 1.30 Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory administration S 164,250 $ 2,070 U 19,950 1,840 F 20,895 X 1,510 U 5,024 520 U 79.900 0 None S 162,180 21,790 19,385 4,504 $ 8,160U 585 X U 624 U 144 U 154,020 21,205 X 18,878 9) $ 0.37 9) 4,360 ( 79,900 0 None 79,900 ( 18,820 $ 1.50 9) 32,047 X 948 X F > 32,995 % 585 X U 32,410 Total expense $ 322,066 5 1,312x1U S 320,754 $ 9,981 X U S 310,773 XStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started