I need the answers and excel formulas(please use excel) that fit into this so I can practice so I know how to do it.

January, the first month of the new fiscal year, has just ended and management is eager to see how the actual results compared to the budget. Sweetwater's fixed budget (based on projected sales of 1,200 units) for January is listed below. The actual sales volume for January was 1,500 units, which is 300 units more than originally predicted in the fixed budget. To better evaluate Sweetwater's January performance, you must prepare a flexible budget report showing actual and budgeted dollar amounts at 1,500 units. January Fixed Budget 1,200 $ 30,000.00 January Actual Results 1,500 $ 37,500.00 units sold Sales Cost of goods sold: Direct materials Direct labor Indirect materials (all variable Factory rent Factory depreciation Gross profit Selling & Admin expenses: Shipping (2% of sales) Sales commissions (10% of sal Office salaries Office rent Office depreciation Income from operations 6,750.00 3,000.00 4,476.00 3,000.00 2,520.00 10,254.00 9,235.05 3,600.00 6,283.00 3,000.00 2,520.00 12,861.95 600.00 3,000.00 3,000.00 1,200.00 400.00 2,054.00 735.00 3,750.00 3,200.00 1,200.00 400.00 3,576.95 Required: (A.) Prepare a Flexible Budget Performance Report for January at 1,500 units. Use a Contribution Margin format. Label the variance for each line item as favorable or unfavorable. (B.) Based on the Flexible Budget Performance Report, management would like to better understand the reasons for the direct materials variance. Sweetwater's direct materials are made up of only one raw material, which is chocolate. Calculate the direct materials price variance, direct materials quantity variance, and total direct materials variance using the following information: Direct Materials Standard Cost Per Unit = 18 ounces of chocolate @ $0.3125 per ounce Direct Materials Actual Costs for January = 27,985 ounces @ $0.33 per ounce Comment on the results