I need the formula that is supposed to be in F6 as well. But the one that i posted and someone answered earlier last week, keeps coming up with a number in the millions and its only supposed to be in the hundred thousands according to the instructor.

Complete the exercise Contribution Format Income Statement (Chapter 7 DA Exercise 2) before answering this question. Open the Contribution worksheet. Change the year to 2021 in cell B1 and the value in cell F15 to 50,000. Enter the output in cell F6 in the space below. Type your response as shown on the worksheet with zero decimal places. Do NOT include any digits after the decimal place.

Year	2019
Contribution Format Income Statement
Fiscal Year: 2019				Target Profit Scenarios
Sales Revenue		$ 420,245		Sales Units	6,363
Variable Cost				Sales Target in Dollars
Product	$ 159,075			Sales Target in Units	24,621
SG&A	$ 150,224
Total Variable Cost		$ 309,299		Variable Cost Ratio	73.6%
Contribution Margin		$ 110,946		Contribution Margin Ratio	26.4%
Fixed Cost				Contribution Margin per Unit	$ 17.44
Product	$ 219,075
SG&A	$ 150,224
Total Fixed Cost		$ 369,299
Net Operating Income		$ 110,932		Target Profit	$ 60,000