PENERAPAN FASILITAS GOAL SEEK PADA EXCEL SEBAGAI ALAT PERENCANAAN KEUANGAN

Abstract

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