Create an Excel File with the name $$What If Analysis & your name$.$

Copy the following Data in Sheet $1$:

Data for Goal Seek Assignment

Note: Keep in Mind that Goal Seek Does not work on the NON$-$FORMULA CELLS. So Type the formulas for the following:

The formula for calculating the Total for Pencils Purchased is: Quantity $*$ Price Per Unit

The formula for calculating the Total for Pencils Sold is: Quantity $*$ Price Per Unit

The formula for calculating the Profit is: Total Pencils Sold $-$ Total Pencils Purchased

Using the Goal Seek function, determine the Price per Unit for following Profits:

Required Profit for Goal Seek

Apply Goal seek and write the answers in your sheets like above.