Create an Excel File with the name What If Analysis & your name . Copy the following
Fantastic news! We've Found the answer you've been seeking!
Question:
Create an Excel File with the name What If Analysis & your name
Copy the following Data in Sheet :
Data for Goal Seek Assignment
Note: Keep in Mind that Goal Seek Does not work on the NONFORMULA 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.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: