Question
fill in the chart/blanks
player-uimheducation.com MHE Read MHE Reader CectClass Managerial Accounting lem 9-19: Flexible Budget Performance Reports; W
0 0
Add a comment Improve this question Transcribed image text
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,480 9,480 9,000
Direct labor ( $14 q) $134,730.00 $2,010.00 U $132,720.00 $6,720.00 U $126,000.00
Indirect labor ( $7,420.00 + $1.50 q) $19,860.00 $1,780.00 F $21,640.00 $720.00 U $20,920.00
Utilities ( $6,500 + $2.75 q) $33,036.00 $1,450.00 U $31,586.00 $336.00 U $31,250.00
Supplies ( $1,600.00 + $0.30 q) $4,940.00 $496.00 U $4,444.00 $144.00 U $4,300.00
Equipment depreciation ( $78,400 ) $78,400.00 $0.00 None $78,400.00 $0.00 None $78,400.00
Factory administration ( $18,700 + $1.90 q) $17,122.00 $19,590.00 F $36,712.00 $912.00 U $35,800.00
Total expense $288,088.00 $17,414.00 F $305,502.00 $8,832.00 U $296,670.00

Excel 8 - Microsoft Excel X 90 = File Home Insert Page Layout Formulas Data Review View - 2 x Calculate Now Insert Function M

Add a comment
Know the answer?
Add Answer to:
fill in the chart/blanks player-uimheducation.com MHE Read MHE Reader CectClass Managerial Accounting lem 9-19: Flex...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Ray Company provided the following excerpts from its Production Department's flexible budget performance report. (Indicate the...

    Ray Company provided the following excerpts from its Production Department's flexible budget performance report. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance). Input all amounts as positive values. Round "rate per hour" answers to 2 decimal places.) Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Flexible Spending Variances Results Budget 9,480 Activity variances Planning Budget 9,000 Labor-hours (9) Direct...

  • apter 9 required Ray Company provided the following excerpts from its Production Department's flexible budget performance...

    apter 9 required Ray Company provided the following excerpts from its Production Department's flexible budget performance report Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (... ero variance). Input all amounts as positive values. Round "rate per hour answers to 2 decimal places.) Ray Company Production Department Flexible Budget Performance Report For the Month Ended August 31 Actual Flexible Spending Variances Results Budget 9,480 Planning Activity Variances 9,000 Labor-hours...

  • Exercise 9-16 Flexible Budgets in a Cost Center [LO9-1, LO9-2] Packaging Solutions Corporation manufactures and sells...

    Exercise 9-16 Flexible Budgets in a Cost Center [LO9-1, LO9-2] Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month Cost Formulas $15.80 $8,200 $1.60q $6,400+$0.80q $1,100 +$0.404 $23,e00 +$3.78q $8,400 $2,100 $11,700 $1.90q Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory...

  • Problem 9-19 (Algo) Flexible Budget Performance Reports; Working Backwards [LO 9-1,9-2, 9-3, 9-4] Ray Company provided...

    Problem 9-19 (Algo) Flexible Budget Performance Reports; Working Backwards [LO 9-1,9-2, 9-3, 9-4] 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 (l.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...

  • I only need a help with the one which is shown wrong. Thank you. Exercise 9-16...

    I only need a help with the one which is shown wrong. Thank you. Exercise 9-16 Flexible Budgets in a Cost Center (LO9-1, LO9-2] Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where is the number of labor-hours worked in a month: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent...

  • Can you please fill out this chart? Thank you! Ray Company provided the following excerpts from...

    Can you please fill out this chart? Thank you! Ray Company provided the following excerpts from its Production Department's flexible budget performance report. (Round "rate pe 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 Spending Variances Flexible Results Budget...

  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $16.40q Indirect labor $4,300 + $1.50q Utilities $5,800 + $0.50q Supplies $1,700 + $0.10q Equipment depreciation $18,000 + $2.40q Factory rent $8,000 Property taxes $2,500 Factory administration $13,700 +...

  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.609 $4,000 + $1.509 $5,300 + $0.909 $1,600 + $0.209 $18, 100 + $ 2.609 $8,300 $2,500...

  • Exercise 9-15 Flexible Budget Performance Report in a Cost Center (LO9-1, LO9-2, LO9-3, LO9-4] Packaging Solutions Corp...

    Exercise 9-15 Flexible Budget Performance Report in a Cost Center (LO9-1, LO9-2, LO9-3, LO9-4] Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.207 $4,600 +...

  • Problem 9-26 Critiquing a Cost Report; Preparing a Performance Report [LO9-1, LO9-2, LO9-3, LO9-4, LO9-6] Frank...

    Problem 9-26 Critiquing a Cost Report; Preparing a Performance Report [LO9-1, LO9-2, LO9-3, LO9-4, LO9-6] Frank Weston, supervisor of the Freemont Corporation's Machining Department, was visibly upset after being reprimanded for his department's poor performance over the prior month. The department's cost control report is given below: Freemont Corporation-Machining Department Cost Control Report For the Month Ended June 30 Actual Results 42,000 Planning Budget Variances Machine-hours 40,000 Direct labor wages Supplies Maintenance Utilities Supervision Depreciation $ 93,500 29,800 25,900 23,600...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT