I need major help entering the answers in excel formula for this problem please!!!
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. Data set #1 Inputs: Data Section: Fixed Variable $2.30 4.70 3.00 $225,000 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 0.75 97,000 47,500 16,200 92.000 12,300 15,000 0.25 I Total Additional information: Selling price per unit Expected unit sales Target profit $16.00 120,000 $20,000 Check figure (Target profit - Dollar sales needed): $1,680,000.00 Data set #2 Inputs: Data Section: Fixed Variable $2.30 4.70 3.00 $300,000 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 1.25 97,000 47,500 16,200 92,000 12,300 20,000 0.50 Total DES Additional information: Selling price per unit Expected unit sales Target profit $18.00 150,000 $50,000 Check figure (Target profit - Dollar sales needed): $1,828,800.00 Data set #3 Inputs: Data Section: Fixed Variable $2.30 5.00 5.50 $300,000 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 1.25 97,000 47,500 16,200 92,000 12,300 20,000 0.50 Total Additional information: Selling price per unit Expected unit sales Target profit $24.00 150,000 $50,000 Check figure (Target profit - Dollar sales needed): $1,612,698.41 working where yo E47 x fx A B D E Data Section: Fixed Variable $2.30 4.70 3.00 $225,000 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 0.75 97.000 47,500 16,200 92,000 12,300 15,000 0.25 Total FORMULA1 FORMULA2 DESDE 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Additional information: Selling price per unit Expected unit sales Target profit $16.00 120,000 $20,000 Answer Section: Contribution margin per unit Contribution margin (Total) Contribution margin ratio Break-even point in units Break-even point in sales dollars Target profit (Unit sales needed) Target profit (Dollar sales needed) FORMULA3 FORMULA4 FORMULA5 FORMULA FORMULA7 FORMULAS FORMULAS Total revenue at expected unit sales Net income at expected unit sales Margin of safety as a percentage of sales FORMULA10 FORMULA11 FORMULA12 Sheet1 + Honda
