Chapter10Homework_Question11

.xlsx

School

Stockton University *

*We aren’t endorsed by this school

Course

ACCT-211

Subject

Economics

Date

Apr 30, 2024

Type

xlsx

Pages

2

Uploaded by AdmiralAnteater3461 on coursehero.com

Function: IF; Formula: Multiply, Subtract; Cell Referencing PROBLEM a. Direct labor rate per direct labor hour $ 20.00 Actual direct labor cost, January $ 206,000 Expected direct labor hours per month 10,000 Actual direct labor hours, January 10,400 b. a. A static budget report b. A flexible budget report c. Using Excel to Prepare a Static and Flexible Direct Labor Budget Require with cell reference Rooney Company provided the following information needed for the preparation of its static and flexible budget reports during January, 2022. Prepare the following budget reports for January 2022 using Excels' IF function, and evaluate the usefulness of each report.
Student Work Area Rooney Company Static Direct Labor Budget Report For the Month Ended January 31, 2022 Budget Actual Difference Direct labor $ 200,000 $ 206,000 $ 6,000 unfavorable Rooney Company Flexible Direct Labor Budget Report For the Month Ended January 31, 2022 Budget Actual Difference Direct labor $ 208,000 $ 206,000 $ 2,000 favorable Which budget report is more useful? Flexible Budget Report The static budget does not provide a proper basis for evaluating performance because the budget is not based on the hours actually worked. The flexible budget provides a proper basis for evaluating performance because the budget is based on the hours actually worked. ed: Provide input into cells shaded in yellow in this template. Use mathematical formulas references to the Problem area or work area as indicated. Use the IF function with cell es to label as Favorable or Unfavorable.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help