Requirement 4 (40 points) 1. Prepare a report showing the revenue and spending and activity variances for each cost, including total and net income amounts. (Remember, you will need to prepare a flexible budget for the actual level of activity in order to complete this report.) 2. Based on your report, answer the following: a. Look at the Revenue Variance in conjunction with the Selling Expense variances. What is a possible explanation for these variances? b. Are the Activity Variances mostly favorable or unfavorable? Is this a good thing? What do activity variances tell us about the company's performance? c. What do you notice about the FIXED activity variances? Why is this the case? d. What do the Direct and Indirect Materials spending variances indicate about the company's use of materials? e. What do the Direct and Indirect Labor spending variances indicate about the company's laborers? f. Overall, how well did the company perform in the first month with regard to sales of the Whack-O? The CEO of Baxter Company is particularly concerned about the Direct Materials and Direct Labor spending variances and asks the Production Manager to further investigate what caused them. Upon further review, it was determined that the company purchased 40,000 pounds of raw materials in the first month at a cost of $.38 a pound. All of the materials purchased were used to make the 12,900 units produced that month. The standard materials quantity and cost for each unit is 3 pounds per unit at a cost of $.50 per pound. Additionally, it was discovered that the direct laborers spent, on average, 30 minutes on each product and were paid a rate of $9.00 per DL hour. The standard activity is 20 minutes per product at a rate of $12.00 per DL hour. Total (variable plus fixed) manufacturing overhead was applied at a rate of $20.85 per direct labor hour. The Production Manager thought that he had done a good job of containing the material and labor costs for the month and was surprised that the CEO was concerned about the production costs.