Please show all the work step by step

Requirements 3,4& 5 needs to be answered

Requirement 3 (25 points) a. Calculate the standard cost per unit for direct materials and standard rate per unit for direct labor. (The formules are given above next to the Direct Materials" and "Direct Labor" items. The standard costs that you calculate are the amounts you will use for your flexible budget for each of these costs). b. Prepare a flexible production budget including Revenues, Total Variable Costs, Total Fixed Costs, Total Costs and Net Income, for the three levels of activity (number of units to break even, number of units to achieve a $25,000 profit, number of units to achieve a $40,000 profit). The CEO is convinced of the Director of Sales' ability to achieve a profit of $40,000 a month and reports those costs on the company's static budget. However, actual sales for the first month were 12,900 units. The actual revenues and expenses for the month were: VARIABLE COSTS (per unit) Sales: $237,457 Direct Materials: Direct Labor: Indirect Materials: Indirect Labor: Utilities for Factory: Supplies for Factory: Variable Administrative Salaries Variable Sales Commissions: $15,200 $58,050 $1,305 $2,200 $8,900 $ 1,925 $9,702 $14,760 FIXED COSTS (per month) Factory Supervisor Salaries: Factory Depreciation: Property Taxes (Factory): Insurance (Factory): Maintenance (Factory): Fixed Sales Salaries Depreciation, Sales Equip. Advertising $43,000 $15,500 $4,500 $3,500 $1,860 $10,000 $12,250 $5,720 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. Requirement 5 (30 points) 1. Compute the following variances: a. Materials Price Variance AQXAP) vs (AQXSP) b. Materials Quantity Variance. (AQ X SP) vs. (SQ X SP) C. Labor Rate Variance (AH XAR) vs (AH X SR) d. Labor Quantity (Efficiency) Variance (AH X SR) vs. (SH X SR) e. Total Overhead Variance (Actual MOH VS Applied MOH). *Hint: The net of each price/quantity variance for DM and DL should equal your spending variance for each item. 2. Looking at these variances as a whole, what are some possible explanations as to what caused these variances? (Your answer must include possible explanations for each of the labor/materials variances). What are some things management can do to improve these variances? Background: Baxter Company is a well-known manufacturer of outdoor goods. They recently started production on the Whack-o, a multi-purpose survival tool, which they plan add to their line of camping products. The costs to manufacture and market the Whack-O are $8.50 per unit plus $92,000 of fixed costs. Baxter Company believes that they can easily sell the Whack-o for $18.50 per unit. Requirement 1: (2 points) *** Must be submitted by April 1st***** Given the assumptions above, how many UNITS of the Whack-O would Baxter Company need to sell each month in order to break even? Baxter Company feels that, given their reputation in the industry, they could easily make a substantial profit on the Whack-O within the first month of sales. They would like to achieve a profit of $25,000 per month on the Whack-o. Baxter's Director of Sales claims that she can sell enough Whack-O tools to generate a profit of $40,000 per month. Requirement 2: 3 points). *** Must be submitted by April 1****** a. How many units of the Whack-Owould Baxter Company need to in order to sell to generate a profit of $25,000 per month? b. How many units of the Whack-O would Baxter Company need to sell in order to generate a profit of $40,000 per month? The CEO of Baxter Company asks the Sales and Production Managers to prepare a fiexible Budget for each of the three levels of activity: the unit sales at break even, the unit sales to achieve a $25,000 profit and the unit sales to achieve a $40,000 profit. (These unir sales figures come from questions 1 and 2 above). The following standard costs were used to prepare the flexible budget: Selling Price: $18.50 Variable Costs (per unit) Direct Materials: The standard materials quantity and cost for each unit is 3 pounds per unit at a cost of $.50 per pound Direct Labor: The standard activity and wage rate is 20 minutes per product at a rate of $12.00 per DL hour. Indirect Materials: $.10 Utilities for Factory $.15 Indirect Labor for Factory $.70 Factory Supplies $.15 Variable Administrative Salaries $0.75 Variable Sales Commissions $1.15 Fixed Costs (per month) Factory Supervisor Salaries $40,000 Depreciation on Factory Equipment $15,500 Property Taxes (Factory) $4,500 Insurance (Factory) $3,200 Maintenance (Factory) $1,800 Fixed Sales Salaries $ 10,000 Depreciation on Sales Equipment $12,000 Advertising $5,000