Both JOIN and UNION are used to combine the data from one or more tables. In case of JOIN, the additional data appears in column while in case of UNION additional data appears in rows.For example, JOINSuppose we have two DB2 tables, ORDERS and TRANSACTIONS. We have to extract TRANSACTION_ID ... Read More

The purpose of VALUE function in DB2 is to check for NULL values and it can be used in place of NULL indicator or COALESCE function. The VALUE function replaces the column value with the given argument if it contains a NULL value.For example, if we have an ORDER table ... Read More

Operation cycle method considers total cycle of operations, from raw materials to finished goods, from accounts payable to net cash.The times taken to complete these operations are called operating cycle time.If the operating cycle is long then, requirement of working capital is less, if the operating cycle is less then, ... Read More

In regression analysis method, statistical tool is used to calculate working capital.CalculationsWorking capital = Int + m*R            Int = intercept, m = slope, R = RevenueΣy = na + bΣxΣxy = aΣx + bΣ2            Where x = sales, y = ... Read More

Percentage of sales method is the traditional method to find out working capital. This method is based on historical relationship between sales and working capital. Each of historical value is converted to percentage of net sales and those values are used to forecast.Steps involved in this method are −Determine historical ... Read More

Appraisal methods are categorised into two types. Each method has its own merits and de-merits. One of the methods used by companies are modern methods which are divided into following typesMBOMBO means Management by Objectives. This concept was developed by Peter F.Drucker in 1954. It is the process where, both ... Read More

Appraisal methods are categorised into two types. Each method has its own merits and de-merits. One of the methods used by companies are traditional methods, which are divided into following types −Ranking method − It is the oldest method used in performance appraisal. In this method, employees are ranked according ... Read More

An appraisal is the process of conducting a fair analysis to evaluate an asset, a business, an organization or a performance based on certain standards. A qualified person called an appraiser does appraisal. It is done whenever properties need to be sold and its value is determined for tax obligations ... Read More

Departmental overheads used in machine hour rate of depreciation are classified into following types −FixedVariableFixed charges − These are constant charges irrespective of machine hours. Rent, taxes, insurance, general expense etc.Some of the fixed charges are as mentioned below −Fixed expensesBasisRentFloor area occupied by machineInsuranceBased on capital value of machineSupervisoryExpenses ... Read More

Machine hour rate is called as service hour method. In this method, active hours of machine are taken into account for calculation of depreciation. This method is commonly used in sectors like chemicals, steel and other heavy industries.In this method, machine hour rate is established and charged to production. Machine ... Read More