Question: Instructions: Use the information from this sheet to complete the spreadsheet assignment. Once completed, please email the completed workbook to zpowell@odesa.edu no later than the
Instructions: Use the information from this sheet to complete the spreadsheet assignment. Once completed, please email the completed workbook to zpowell@odesa.edu no later than the specified due date. If sent after the due date, the max points awarded will be 70. RockChuck Company manufactures mountain bikes and has provided the following information for September 2022: Units Sales Price Variable Cost/unit Fixed Costs Units Sales Revenue Variable Costs Fixed Costs Static Budget 2,000 $795 $500 $500,000 Actual Results 1,500 $1,215,000 $742,500 $425,000 1. Prepare a flexible budget performance report. a. Compute operating income based on the static budget b. Compute the flexible budget based on actual units c. Compute operating income based on actual results d. Compute the flexible budget variances as absolute values and label them as F (favorable) or U (unfavorable) e. Compute the sales volume variances as absolute values and label them as F (favorable) or U (unfavorable) 2. Calculate the overall budget varian
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
