review instructions and complete worksheet

the right worksheet to be completed according to the instructions is this one:

please complete this worksheet according to the instructions

Module 5 Excel Spreadsheet Instructions Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. For this assignment, please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Check figure (Target profit - Dollar sales needed)? $1,640,000.00 $1,828,800.00 Date set \#3 Inputs: Data Section: Fixed Variable Production costs: Direct materials Direct labor Factory overhead Selling expenses: Sales sataries \& commissions Advertising Miscellaneous selling expense General expenses: office salaries Supplies Miscellaneous general expense Total Additional information: Selling price per unit Expected unit saies Target profit $24.00 150,000 $50.000 Check figure (Target profit - Dollar sales needed): $1,612,698.41 ROI 8 Servlce Cost Allocation Student Name: Section Number: Revenues Operating Expenses Income before Service Charges Investment $300,000$500,000 ROI before service charges FORMULA 3 FORMULA 4 Number of professors Number of students in program 520010500 Service department expenses Service department charge rate FORMULA 5 FORMULA 6 ROl after service charges FORMULA 13 FORMULA 14 Data Section: Fixed Variable Production costs: Direct materials Direct labor Factory overhead $2.30 4.70 3.00 Selling expenses: Sales salaries \& commissions Advertising Miscellaneous selling expense General expenses: Office salaries Supplies Miscellaneous general expense Total FORMULA1 FORMULA2 Additional information: Selling price per unit Expected unit sales Target profit Contribution margin per unit FORMULA Contribution margin (Total) FORMULA4 Contribution margin ratio FORMULAS Break-even point in units FORMULA6 Break-even point in sales dollars FORMULA7 Target profit (Unit sales needed) FORMULAB Target profit (Dollar sales needed) FORMULA 9 Total revenue at expected unit sales FORMULA10 Net income at expected unit sales FORMULA11 Margin of safety as a percentage of sales FORMULA12 Data Section: Fixed Variable Production costs: Direct materials Direct labor Factory overhead Selling expenses: Sales salaries & commissions Advertising Miscellaneous selling expense General expenses: Office salaries Supplies Miscellaneous general expense Total FORMULA1 Additional information: Selling price per unit Expected unit sales Target profit $16,00 120,000 $20,000 Answer Section: Contribution margin per unit FORMULAB Contribution margin (Total) Contribution margin ratio FORMULA4 FORMULA5 Break-even point in units FORMULA 6 Break-even point in sales dollars Target profit (Unit sales needed) FORMULA7 Target profit (Dollar sales needed) FORMULAB FORMULA9 Total revenue at expected unit sales Net income at expected unit sales FORMULA10 Margin of safety as a percentage of sales FORMULA11 FORMULA12 Module 5 Excel Spreadsheet Instructions Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. For this assignment, please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Check figure (Target profit - Dollar sales needed)? $1,640,000.00 $1,828,800.00 Date set \#3 Inputs: Data Section: Fixed Variable Production costs: Direct materials Direct labor Factory overhead Selling expenses: Sales sataries \& commissions Advertising Miscellaneous selling expense General expenses: office salaries Supplies Miscellaneous general expense Total Additional information: Selling price per unit Expected unit saies Target profit $24.00 150,000 $50.000 Check figure (Target profit - Dollar sales needed): $1,612,698.41 ROI 8 Servlce Cost Allocation Student Name: Section Number: Revenues Operating Expenses Income before Service Charges Investment $300,000$500,000 ROI before service charges FORMULA 3 FORMULA 4 Number of professors Number of students in program 520010500 Service department expenses Service department charge rate FORMULA 5 FORMULA 6 ROl after service charges FORMULA 13 FORMULA 14 Data Section: Fixed Variable Production costs: Direct materials Direct labor Factory overhead $2.30 4.70 3.00 Selling expenses: Sales salaries \& commissions Advertising Miscellaneous selling expense General expenses: Office salaries Supplies Miscellaneous general expense Total FORMULA1 FORMULA2 Additional information: Selling price per unit Expected unit sales Target profit Contribution margin per unit FORMULA Contribution margin (Total) FORMULA4 Contribution margin ratio FORMULAS Break-even point in units FORMULA6 Break-even point in sales dollars FORMULA7 Target profit (Unit sales needed) FORMULAB Target profit (Dollar sales needed) FORMULA 9 Total revenue at expected unit sales FORMULA10 Net income at expected unit sales FORMULA11 Margin of safety as a percentage of sales FORMULA12 Data Section: Fixed Variable Production costs: Direct materials Direct labor Factory overhead Selling expenses: Sales salaries & commissions Advertising Miscellaneous selling expense General expenses: Office salaries Supplies Miscellaneous general expense Total FORMULA1 Additional information: Selling price per unit Expected unit sales Target profit $16,00 120,000 $20,000 Answer Section: Contribution margin per unit FORMULAB Contribution margin (Total) Contribution margin ratio FORMULA4 FORMULA5 Break-even point in units FORMULA 6 Break-even point in sales dollars Target profit (Unit sales needed) FORMULA7 Target profit (Dollar sales needed) FORMULAB FORMULA9 Total revenue at expected unit sales Net income at expected unit sales FORMULA10 Margin of safety as a percentage of sales FORMULA11 FORMULA12