I need assistance is filling out and calculating the table information

Investigate Managerial Accounting, Prepare and Analyze Budgets Data for Division's Manufacturing Overhead Budget Part I. Acme Widget Company is preparing its Master Budget for 2016 and Evan has asked you to create the Manufacturing Overhead Budget for the Sporting Goods Division. Once you have reviewed the Project resources and the below data, prepare the Manufacturing Overhead Budget for 2016 on page 2, showing quarterly data. Be sure to add the appropriate data to all of the gray boxes and properly express each figure in terms of units, dollars or direct labor hours (DLH). Please show all calculations in the table. Sporting Goods Units to be produced (by Quarter): Q1: 70,000 Q2: 60,000 Q3: 50,000 Q4: 80,000 Direct labor: 1 hour of direct labor is required to produce one unit Variable overhead costs per direct labor hour: Indirect materials $0.80 Indirect labor $1.20 Maintenance $0.50 Fixed overhead costs per Quarter: Supervisory salaries $42,000 Depreciation $16,000 Maintenance $12,000 Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. Investigate Managerial Accounting, Prepare and Analyze Budgets Data for Division's Manufacturing Overhead Budget ACME SPORTING GOODS DIVISION MANUFACTURING OVERHEAD BUDGET FOR THE YEAR ENDED DECEMBER 31, 2016 Q1 Q2 Q3 DIRECT LABOR HOURS (DLH) VARIABLE COSTS: Indirect materials ($.80/DLH) Indirect labor ($1.20/DLH) Maintenance ($.50/DLH) TOTAL VARIABLE COSTS FIXED COSTS: Supervisory salaries Depreciation Maintenance TOTAL FIXED COSTS MANUFACTURING OVERHEAD (MO) MANUFACTURING OVERHEAD RATE PER DIRECT LABOR HOUR (MO/DLH) Part II. Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. Q4 Year Investigate Managerial Accounting, Prepare and Analyze Budgets Data for Division's Manufacturing Overhead Budget The Sporting Goods Division also uses a flexible budget for planning and budget preparation. For the month of August 2016, the monthly sales forecast is 15,000 units. Manufacturing overhead is based on machine hours. Evan would like you to prepare a Flexible Budget Report, assuming that the division used 6,000 machine hours during August 2016. Be sure to add the appropriate data to all of the gray boxes and properly express each figure. Please show all calculations in the table and in your answers to the questions on pages 5 and 6. The projected sales price per unit is $9.50 and the following variable costs per unit are projected: Direct materials $3.00 Direct labor $2.00 Variable manufacturing overhead costs per machine hour planned for August 2016: Indirect labor $5.00 Indirect materials $2.50 Maintenance $0.50 Utilities $0.30 Fixed overhead costs per month: Supervision $1,200 Insurance $400 Property taxes $600 Depreciation $1,800 Other notes to consider: Acme believes it will operate in a normal range of 4,000 to 8,000 machine hours per month. In August 2016, direct material costs were $41,250 and direct labor costs were $29,000 on sales of 14,750 units, or $135,000. During the month of August 2016, the company incurred the following manufacturing overhead costs: Indirect labor $28,000 Indirect materials $16,200 Maintenance $2,800 Utilities $1,900 Supervision $1,440 Insurance $400 Property taxes $600 Depreciation $1,860 Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. Investigate Managerial Accounting, Prepare and Analyze Budgets Data for Division's Manufacturing Overhead Budget ACME SPORTING GOODS DIVISION MONTHLY OVERHEAD FLEXIBLE BUDGET REPORT FOR THE MONTH OF AUGUST 2016 AUGUST 2016 BUDGET AUGUST 2016 ACTUAL AMOUNT OF VARIANCE Sales Variable Costs: Direct materials Direct labor Total Variable Costs Contribution Margin Manufacturing Overhead Costs: Variable Costs: Indirect labor Indirect materials Maintenance Utilities Total Variable Costs Fixed Costs: Supervision Insurance Property taxes Depreciation Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. FAVORABLE (OR UNFAVORABLE) VARIANCE Investigate Managerial Accounting, Prepare and Analyze Budgets Data for Division's Manufacturing Overhead Budget Total Fixed Costs Total Costs Budgeted Net Income Answer the following questions regarding analysis of variance: 1. Referring to \"Sales\" in Acme's MONTHLY OVERHEAD FLEXIBLE BUDGET REPORT: a. What was the Sales Variance, i.e., by how much were Acme's August 2016 actual sales favorable or unfavorable to budget? b. How much of the Sales Variance was due to selling fewer units than Acme planned to sell? You can determine this by calculating the Sales Volume Variance. c. How much of the Sales Variance was due to selling each unit at a lower price than Acme planned to sell? You can determine this by calculating the Selling Price Variance. 2. Referring to \"Variable Costs: Direct Materials\" in Acme's MONTHLY OVERHEAD FLEXIBLE BUDGET REPORT: a. What was the Direct Materials Variance, i.e., by how much were Acme's August 2016 Direct Materials Costs favorable or unfavorable to budget? b. How much of the Direct Materials Variance was due to selling fewer units than Acme Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. Investigate Managerial Accounting, Prepare and Analyze Budgets Data for Division's Manufacturing Overhead Budget planned to sell? You can determine this by calculating the Direct Materials Quantity Variance. c. How much of the Direct Materials Variance was due to buying each unit at a higher price than Acme planned to pay? You can determine this by calculating the Direct Materials Price Variance. 3. Referring to \"Variable Costs: Direct Labor\" in Acme's MONTHLY OVERHEAD FLEXIBLE BUDGET REPORT: a. What was the Direct Labor Variance, i.e., by how much were Acme's August 2016 Direct Labor Costs favorable or unfavorable to budget? b. How much of the Direct Labor Variance was due to selling fewer units than Acme planned to sell? You can determine this by calculating the Labor Efficiency Variance. c. How much of the Direct Labor Variance was due to paying a lower hourly rate than Acme planned to pay? You can determine this by calculating the Direct Labor Rate Variance. Copyright 2016 College for America at Southern New Hampshire University. All rights reserved