A$20$

A

B

C

D

E

$H$

$3$ Their CVP Operating Income Statement for $2022$ is as follows.

$5$

$6$ Sales

$7$ Variable Costs

$8$ Cost of Goods Sold

$9$ Selling & Administrative Expenses

$10$ Total Variable Costs

$11$

$12$ Contribution Margin

$14$ Fixed Costs

$15$ Cost of Goods Sold

$16$ Selling & Administrative Expenses

$17$ Total Fixed Costs

$19$ Operating Income

$$3,380,450$

$20$

$21$ Question $1$ Problem

What selling price would Altec needs to charge in order to earn their target operating income of $$1,500,000$ for $2023?$ Altec expects to

produce and sell $90,000$ units in $2023.$ Variable cost per unit will increase by $10\%$ compared with $2022$ ; fixed costs will remain

unchanged. Fill in each of the blue cells below.

$22$ Please solve the problem using MS Excel's 'Goal Seek' function.

$23$

$24$ Selling Price

$$,2,602,300$

$$,778,150$

$$

$,$

$

$122$

Q$1$

Q$2$

Q$3$

Q$4$

$+$

Ready $?$ Accessibility: Unavailable

Type here to searchfx

A

B

C

D

E $,F,G$

$21$ Question $1$ Problem

What selling price would Altec needs to charge in order to earn their target operating income of $$1,500,000$ for $2023?$ Altec expects to

produce and sell $90,000$ units in $2023.$ Variable cost per unit will increase by $10\%$ compared with $2022$ ; fixed costs will remain

unchanged. Fill in each of the blue cells below.

$22$ Please solve the problem using MS Excel's 'Goal Seek' function.

$23$

$24$ Selling Price

$25$ Variable Costs

$26$ Cost of Goods Sold

$27$ Selling & Administrative Expenses

per unit

$28$ Total Variable Costs

$29$ CM

per unit

$90,000$ units

$31$

$32,$ Altec Manufacturing, Inc.

$33$ Projected Income Statement

$34$

Year Ending December $31,2023$

$36$ Sales Revenue

$37$ Variable Costs

$38$ Contribution Margin

$39$ Fixed Costs

$40$ Net Operating Income

$Q1Q2Q3Q4$

Ready ${}_{?}$ Accessibility: Unavailable