A worksheet,created by a company making toothbrushes,contains the following information within specified cells (given in brackets): Number of toothbrushes sold (K10),Sale price * number of toothbrushes sold (K11),transportation cost per toothbrush * number of toothbrushes sold (K12),the fixed cost (K13)involved in manufacturing the toothbrushes,and the net profit (K14).If the company wants to find the number of toothbrushes they have to sell to make a profit of $5,000,what must they enter in the "To value" field in the Goal Seek Dialog box?
A)$5,000
B)K14
C)K10
D)$5,000*K13

Question

Quizplus · Accepted Answer

In the Goal Seek dialog box,the "To value" refers to the value of the objective we want to achieve.In this case,the objective is posting a profit of $5,000.

A Worksheet,created by a Company Making Toothbrushes,contains the Following Information