This assignment is required to be completed using Excel, all calculations must be reflected in your spreadsheet Your spreadsheet is due on April 14 at 11:59 AM via Moodle Dropbox This assignment is worth 125 points for the course Attached is the financial information needed from your sports apparel company, please use this data to answer the following questions Average Sales Price: $43.00 per item Cost of Goods Sold: Operating Expenses: Direct Materials (Variable Cost): 75% Variable Costs: 35% Direct Labor (Variable Cost): 10% Fixed Costs: 65% Variable Overhead: 5% Fixed Overhead: 10% 1) What is the contribution margin per unit, breakeven in units, and margin of safety in units for the three years? What do these volumes indicate about the performance of the company? (30 Points) 2) What is the direct labor per unit for the three years presented? (15 points) 3) What is the direct materials per unit for the three years presented? (15 points) 4) Below are the expected changes for next year (15 Points): Sales: Increase 4% Cost of Goods Sold: Decrease 12% Operating Expenses: Increase 2% What is the expected operating income for next year? 5) A new advertising program is being considered by the marketing department for your company. The marketing plan has a fixed cost of $500,000. (25 points) How many units will be required to be sold to cover the cost of this marketing plan? Based on this change in sales, what is your recommendation regarding this marketing plan? 6) Below are the standard costs that were expected for the most recently completed year (25 Points): Direct Labor per Unit: $2.89 Direct Materials per Unit: $21.76 Please compute the following and label as either favorable, or unfavorable: Direct Labor Variance per Unit Direct Materials Variance per Unit Total Direct Labor Variance Total Direct Materials Variance This assignment is required to be completed using Excel, all calculations must be reflected in your spreadsheet Your spreadsheet is due on April 14 at 11:59 AM via Moodle Dropbox This assignment is worth 125 points for the course Attached is the financial information needed from your sports apparel company, please use this data to answer the following questions Average Sales Price: $43.00 per item Cost of Goods Sold: Operating Expenses: Direct Materials (Variable Cost): 75% Variable Costs: 35% Direct Labor (Variable Cost): 10% Fixed Costs: 65% Variable Overhead: 5% Fixed Overhead: 10% 1) What is the contribution margin per unit, breakeven in units, and margin of safety in units for the three years? What do these volumes indicate about the performance of the company? (30 Points) 2) What is the direct labor per unit for the three years presented? (15 points) 3) What is the direct materials per unit for the three years presented? (15 points) 4) Below are the expected changes for next year (15 Points): Sales: Increase 4% Cost of Goods Sold: Decrease 12% Operating Expenses: Increase 2% What is the expected operating income for next year? 5) A new advertising program is being considered by the marketing department for your company. The marketing plan has a fixed cost of $500,000. (25 points) How many units will be required to be sold to cover the cost of this marketing plan? Based on this change in sales, what is your recommendation regarding this marketing plan? 6) Below are the standard costs that were expected for the most recently completed year (25 Points): Direct Labor per Unit: $2.89 Direct Materials per Unit: $21.76 Please compute the following and label as either favorable, or unfavorable: Direct Labor Variance per Unit Direct Materials Variance per Unit Total Direct Labor Variance Total Direct Materials Variance