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 "By changing cell" in the Goal Seek Dialog box?
A)$5,000
B)K14
C)K10
D)$5,000*K13

Question

Quizplus · Accepted Answer

The objective of the company is to make a profit of $5,000 and the unknown value is the number of toothbrushes they have to sell (K10)to make a profit of $5,000.

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