Use Excel's Goal Seek tool to determine the sales price required to meet the $7,500 gross profit goal. Management believes monthly sales will average 1,500 next year. Assume the company will not maintain any inventory of finished goods. Hint: In a schedule in Excel, enter number of units, variable manufacturing cost per unit and total fixed costs, and a formula for gross profit. Use the Goal Seek tool to find the sales price. Goal seek is found under the Data tab, and under What-if Analysis?

Answer rating: 100% (QA)

To use Excels Goal Seek tool to determine the sales price required to meet the 7500 gross profit goa... View the full answer