This is my accounting 2 homework!, Please I desperately need Help! Thank you!!!!! :(

H15 v Each question is worth 15 points Read each question requirements carefully Recommend completing the formulas on Question 1 then copying them over to the other questions Note that some questions may require you to create new formulas or alter the other ones. Note the formula section must be populated for each question 10 E10 ACCOUNTING 102 F1 Cost-Volume-Profit Analysis - Project Question #1 -Instructions: Complete the formulas in thei "Formula Section " Below tudent - Data Input Section Fixed Variable 8 Production costs 4.30 $4.70 $ 225,000 3.00 Direct materials 10 Direct labor Factory overhead 12 Selling expenses 13Sales salaries&commissions$97,000 $ 0.75 $ 47,500 14 Advertising 5 Miscellaneous selling expense $ 16,200 16 General expenses C-V-P GRAPH 7 Office salaries 18 Supplies 19 Miscellaneous general expense $ 87,000 $ 12,300$1.25 $%60,000 15,000 $500,000 20 21 22 Projected unit sales 23 Selling price per unit 24 Target net income $400,000 90,000 Fixed CosB $20.0030.0 $200,000$20.000 Saes $100,000 ormula Section 26 27 8 Contribution margin per unit FORMULA FORMULA FORMULA 29 Contribution margin ratio *DO NOT EDIT* 1 Break-even point (units) 32 Target net income (units needed to achieve) FORMULA FORMULA Data Table Units Sales IV. Costs F. Costs T. Costs FORMULA $0 $0 $0 $0 34 Break-even point (sales dollars) 0 $0 $0 $0 s Target net income (sales dollars needed to achie FORMULA FORMUL 36 7 Projected net income FORMULA 38 39 K15 ACCOUNTING 102 F1 Cost-Volume-Profit Analysis - Projec Question #2-Instructions: Complete the formulas in the "Formula Section " Below tudent Data Input Section Apply this scenario 1. Factory overhead increases by 10% 2, Direct materials increase by 50% 3. Projected Unit Sales 150,000 4. Determine selling price per unit in order to net $100,000 of income Fixed Variable Production costs 9 Direct materials 10 Direct labor 1Factory overhead 2 Selling expenses $6.45 $4.70 3.00 $ 247,500 | $ Sales salaries &commissions $ 97.000 s Miscellaneous selling expense $ 16,200 0.75 $ 47,500 4 Advertising 6 General expenses 7 Office salaries 18 Supplies 9 Miscellaneous general expense 20 C-V-P GRAPH $ 87,000 $ 12,300$1.25 6 15,000 $500,000 $400,000 2 Projected unit sales 3 Selling price per unit 4 Target net income Fixed Cost Plot Area $300,000 $200,000 $100,000 ormula Section FORMULA 8 Contribution margin per unit FORMULA FORMULA Contribution margin ratio **DO NOT EDIT* FORMULA 2 Target net income (units needed to achieve) FORMULA Break-even point (units) Data Table Units Sales V. Costs FORMULA sTarget net income (sales dollars needed to achie FORMULA 4 Break-even point (sales dollars) 0### $0 $0 $0 FORMUL 0 7 Projected net income FORMULA ACCOUNTING 102 F1 Cost-Volume-Profit Analysis Project Question #3-Instructions: Complete the formulas in the "Formula Section " Below Student- Data Input Section Apply this scenario: 1. Purchased a new machine that reduces direct labor by $1.00 per 5 units FixedVariable2. New machine increases overhead by $0.10 per unit s Production costs 9 Direct materials 10 Direct labor 3. New machine will double the projected unit sales $4.30 4. Determine the breakeven selling price per unit $4.705. Determine how many units must be sold to achieve $200,000 in net income at the $ 225,000$3.00 Factory overhead breakeven selling price per unit. 2 Selling expenses Advertising Sales salaries & commissions $ 97,000 $ 0.75 Miscellaneous selling expense 16,200 Supplies $ 47,500 General expenses 17 Office salaries C-V-P GRAP 12,300$1.259%130.000 $ 15.000 19 Miscellaneous general expense $500,00014.00 21 $400,000 0,000 Projected unit sales 23 Selling price per unit 24 Target net income 25 $10 5 0 Fixed Cost 200,000 100.000 Formula Section 0 FORMULA0 28 Contribution margin per unit FORMULA FORMULA 29 Contribution margin ratio **DO NOT EDIT** Chart Data Table 1Break-even point (units) FORMULA 32 Target net income (units needed to achieve FORMULA s Target net income (sales dollars needed to achie FORMULA 7 Projected net income Units Sales V. Costs F. Costs T.Costs Haret nret nomte fales obian needed to achie FORMULA $0 $0 FORMULA $0 FORMULA 38 ACCOUNTING 102 F1 Cost-Volume-Profit Analysis - Project Question #4-instructions: Complete the formulas in the "Formula Section " Below tudent 1. All labor and salaries increase by 20% (fixed and variable) 2. Materials double in cost ection ixedVariable3. Management reduces the advertising to S30,000 Production costs 9 Direct materials 10 Direct labor 4. Management reduces the target contribution margin to 20% 6. Determine the selling price per unit $4.30 $4.70 7. Determine the projected unit sales to achieve net income of $500,000 $225,0003.00 $47,500 $87,000 Factory overhead 12 Selling expenses 13 Sales salaries&commissions$ 97,000 $ 4Advertising s Miscellaneous selling expense $ 16,200 16 General expenses 17 Office salaries 18 Supplies 9 Miscellaneous general expense 15,000 0.75 C-V-P GRAPH $ 12,300 1.25000 5500000 21 22 Projected unit sales 23 Selling price per unit 24 Target net income -Fixed Cost 5200000 Formula Section FORMULA 0 28 Contribution margin per unit 29 Contribution margin ratio 30 31 Break-even point (units) FORMULA FORMULA *DO NOT EDIT** FORMULA Data Table 32 Target net income (units needed to achieve FORMULA UnitsSales V. Costs F. Costs T. Costs 34 Break-even point (sales dollars) 3s Target net income (sales dollars needed to achiFORMULA FORMULA $0 0 # FORMULA 3 Projected net income ACCOUNTING 102 F1 Cost-Volume-Profit Analysis- Project Question #5-Instructions: Complete the formulas in the "Formula Section " Below Year One: 1. Management reduces all costs by 10% 2. Management requires a contribution margin of 25% 3. Management determines a target net income of $250,000 4. Determine contribution margin per unit, breakeven, and target no. of units ection Production costs o Direct labor 2 Selling expenses 4 Advertising s General expenses $4.30 Direct materials Factory overhead 3 Sales salaries& commissions s Miscellaneous selling expense 4.70 Year Two: 3.00 1. Management adds another facility for $20,000 in fixed and reduces $0.50 per unit in factory overhead $225,000 2. Determine new contribution margin per unit, breakeven, and target no. of units emssions $ $ 97,000 0.75 47,500 16,200 $ 87,000 15,000 C-V-P GRAPH Office salaries Supplies 9 Miscellaneous general expense $ 12,3001.2500 2 Projected unit sales s Selling price per unit Target net income s30c000 $250,000 S000e 5100000 ormula Section FORMULA FORMULA 8Contribution margin per unit Contribution margin ratio "DO NOT EDIT FORMULA FORMULA Break-even point (units) Data Table es 2 Target net income (units needed to achieve) FORMULA s Target net income (sales dollars needed to ach FORMULA 4 Break-even point (sales dollars) 0 ## FORMUL FORMULA $0 Projected net income H15 v Each question is worth 15 points Read each question requirements carefully Recommend completing the formulas on Question 1 then copying them over to the other questions Note that some questions may require you to create new formulas or alter the other ones. Note the formula section must be populated for each question 10 E10 ACCOUNTING 102 F1 Cost-Volume-Profit Analysis - Project Question #1 -Instructions: Complete the formulas in thei "Formula Section " Below tudent - Data Input Section Fixed Variable 8 Production costs 4.30 $4.70 $ 225,000 3.00 Direct materials 10 Direct labor Factory overhead 12 Selling expenses 13Sales salaries&commissions$97,000 $ 0.75 $ 47,500 14 Advertising 5 Miscellaneous selling expense $ 16,200 16 General expenses C-V-P GRAPH 7 Office salaries 18 Supplies 19 Miscellaneous general expense $ 87,000 $ 12,300$1.25 $%60,000 15,000 $500,000 20 21 22 Projected unit sales 23 Selling price per unit 24 Target net income $400,000 90,000 Fixed CosB $20.0030.0 $200,000$20.000 Saes $100,000 ormula Section 26 27 8 Contribution margin per unit FORMULA FORMULA FORMULA 29 Contribution margin ratio *DO NOT EDIT* 1 Break-even point (units) 32 Target net income (units needed to achieve) FORMULA FORMULA Data Table Units Sales IV. Costs F. Costs T. Costs FORMULA $0 $0 $0 $0 34 Break-even point (sales dollars) 0 $0 $0 $0 s Target net income (sales dollars needed to achie FORMULA FORMUL 36 7 Projected net income FORMULA 38 39 K15 ACCOUNTING 102 F1 Cost-Volume-Profit Analysis - Projec Question #2-Instructions: Complete the formulas in the "Formula Section " Below tudent Data Input Section Apply this scenario 1. Factory overhead increases by 10% 2, Direct materials increase by 50% 3. Projected Unit Sales 150,000 4. Determine selling price per unit in order to net $100,000 of income Fixed Variable Production costs 9 Direct materials 10 Direct labor 1Factory overhead 2 Selling expenses $6.45 $4.70 3.00 $ 247,500 | $ Sales salaries &commissions $ 97.000 s Miscellaneous selling expense $ 16,200 0.75 $ 47,500 4 Advertising 6 General expenses 7 Office salaries 18 Supplies 9 Miscellaneous general expense 20 C-V-P GRAPH $ 87,000 $ 12,300$1.25 6 15,000 $500,000 $400,000 2 Projected unit sales 3 Selling price per unit 4 Target net income Fixed Cost Plot Area $300,000 $200,000 $100,000 ormula Section FORMULA 8 Contribution margin per unit FORMULA FORMULA Contribution margin ratio **DO NOT EDIT* FORMULA 2 Target net income (units needed to achieve) FORMULA Break-even point (units) Data Table Units Sales V. Costs FORMULA sTarget net income (sales dollars needed to achie FORMULA 4 Break-even point (sales dollars) 0### $0 $0 $0 FORMUL 0 7 Projected net income FORMULA ACCOUNTING 102 F1 Cost-Volume-Profit Analysis Project Question #3-Instructions: Complete the formulas in the "Formula Section " Below Student- Data Input Section Apply this scenario: 1. Purchased a new machine that reduces direct labor by $1.00 per 5 units FixedVariable2. New machine increases overhead by $0.10 per unit s Production costs 9 Direct materials 10 Direct labor 3. New machine will double the projected unit sales $4.30 4. Determine the breakeven selling price per unit $4.705. Determine how many units must be sold to achieve $200,000 in net income at the $ 225,000$3.00 Factory overhead breakeven selling price per unit. 2 Selling expenses Advertising Sales salaries & commissions $ 97,000 $ 0.75 Miscellaneous selling expense 16,200 Supplies $ 47,500 General expenses 17 Office salaries C-V-P GRAP 12,300$1.259%130.000 $ 15.000 19 Miscellaneous general expense $500,00014.00 21 $400,000 0,000 Projected unit sales 23 Selling price per unit 24 Target net income 25 $10 5 0 Fixed Cost 200,000 100.000 Formula Section 0 FORMULA0 28 Contribution margin per unit FORMULA FORMULA 29 Contribution margin ratio **DO NOT EDIT** Chart Data Table 1Break-even point (units) FORMULA 32 Target net income (units needed to achieve FORMULA s Target net income (sales dollars needed to achie FORMULA 7 Projected net income Units Sales V. Costs F. Costs T.Costs Haret nret nomte fales obian needed to achie FORMULA $0 $0 FORMULA $0 FORMULA 38 ACCOUNTING 102 F1 Cost-Volume-Profit Analysis - Project Question #4-instructions: Complete the formulas in the "Formula Section " Below tudent 1. All labor and salaries increase by 20% (fixed and variable) 2. Materials double in cost ection ixedVariable3. Management reduces the advertising to S30,000 Production costs 9 Direct materials 10 Direct labor 4. Management reduces the target contribution margin to 20% 6. Determine the selling price per unit $4.30 $4.70 7. Determine the projected unit sales to achieve net income of $500,000 $225,0003.00 $47,500 $87,000 Factory overhead 12 Selling expenses 13 Sales salaries&commissions$ 97,000 $ 4Advertising s Miscellaneous selling expense $ 16,200 16 General expenses 17 Office salaries 18 Supplies 9 Miscellaneous general expense 15,000 0.75 C-V-P GRAPH $ 12,300 1.25000 5500000 21 22 Projected unit sales 23 Selling price per unit 24 Target net income -Fixed Cost 5200000 Formula Section FORMULA 0 28 Contribution margin per unit 29 Contribution margin ratio 30 31 Break-even point (units) FORMULA FORMULA *DO NOT EDIT** FORMULA Data Table 32 Target net income (units needed to achieve FORMULA UnitsSales V. Costs F. Costs T. Costs 34 Break-even point (sales dollars) 3s Target net income (sales dollars needed to achiFORMULA FORMULA $0 0 # FORMULA 3 Projected net income ACCOUNTING 102 F1 Cost-Volume-Profit Analysis- Project Question #5-Instructions: Complete the formulas in the "Formula Section " Below Year One: 1. Management reduces all costs by 10% 2. Management requires a contribution margin of 25% 3. Management determines a target net income of $250,000 4. Determine contribution margin per unit, breakeven, and target no. of units ection Production costs o Direct labor 2 Selling expenses 4 Advertising s General expenses $4.30 Direct materials Factory overhead 3 Sales salaries& commissions s Miscellaneous selling expense 4.70 Year Two: 3.00 1. Management adds another facility for $20,000 in fixed and reduces $0.50 per unit in factory overhead $225,000 2. Determine new contribution margin per unit, breakeven, and target no. of units emssions $ $ 97,000 0.75 47,500 16,200 $ 87,000 15,000 C-V-P GRAPH Office salaries Supplies 9 Miscellaneous general expense $ 12,3001.2500 2 Projected unit sales s Selling price per unit Target net income s30c000 $250,000 S000e 5100000 ormula Section FORMULA FORMULA 8Contribution margin per unit Contribution margin ratio "DO NOT EDIT FORMULA FORMULA Break-even point (units) Data Table es 2 Target net income (units needed to achieve) FORMULA s Target net income (sales dollars needed to ach FORMULA 4 Break-even point (sales dollars) 0 ## FORMUL FORMULA $0 Projected net income