PENERAPAN FASILITAS GOAL SEEK PADA EXCEL SEBAGAI ALAT PERENCANAAN KEUANGAN

Abstract

Companies that can survive the current fierce competition are companies that do careful
planning about what to do in the future. Planning needs to be done for one company is
related to financial planning. With financial planning firms will know how much the cost, the
profit to be achieved and the volume of sales or production. Determination of a number of
sales volume can be achieved by the company to do with the Goal Seek facility. Goal Seek is
one of the facilities provided by Excel in order to facilitate the users in finding the value that
must be achieved with pre-determined conditions. In this case, the Goal Seek facility that can
be known with certainty how much should be produced or sold in order to obtain the
expected earnings accurately.