JPH05151227A - Device for allocating depreciation amount to sections - Google Patents

Abstract

PURPOSE:To collectively allocate the apreciation amount of fixed assets to plural sections based upon previously determined rates to be charged without executing manual calculation. CONSTITUTION:A file information updating part 3 forms a section rate master allowing sections charged with depreciation amount to correspond to rates to be charged in each fixed asset based upon data inputted from a keyboard 2 and stores the formed master in a section rate master storing part 4. A fixed assets master correspondingly setting up the depreciation amount of each asset for a year and the asset code and fixed asset name of the fixed asset is stored in a fixed assets master storing part 5. An allocation calculation operating part 6 is started to read out contents stored in the storing part 4, the yearly depreciation amount of each fixed asset code in the section rate master is extracted by referring to the fixed assets master, the depreciation amount is distributed to respective sections based upon said rates to be charged in each month and the allocated result is stored in a depreciation storing file storing part 7, and a document output part 8 is started to output the stored result to the external.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a depreciation amount division allocating device for allocating depreciation amounts of fixed assets registered and stored in a storage device according to predetermined divisions.

[0002]

2. Description of the Related Art When a fixed asset is purchased at a company or the like, the depreciation amount for this fixed asset is calculated by a predetermined calculation by an information processing device for each fixed asset. However, how much the depreciation amount calculated above is to be paid for each of a plurality of departments in one organization (for example, a company) is manually calculated. Therefore, for example, the organization of the company consists of 6 departments,
Assuming that the company holds 1000 fixed assets, of which 500 fixed assets must be allocated to each department, the operator calculates monthly depreciation amount by department 500 × 6 = 3000. The process will be performed manually by using an electronic desk calculator.

[0003]

However, in the conventional apparatus for calculating the depreciation amount, since the amount cannot be allocated to each department, the number of fixed assets that the company must manage is increased. As a result, there is a drawback in that the burden on the operator who performs monthly calculations becomes extremely large.

In order to solve such a conventional problem, the object of the present invention is to correspond the divisions of each fixed asset that should bear the depreciation amount and the proportion of the depreciation amount that the division should bear. Create and memorize the department rate masters
Depreciation that does not require manual calculation for allocating depreciation amount by performing calculation to allocate depreciation amount by month to each department, storing the result, and outputting the allocation result when necessary It is to provide a depreciation amount department allocation device.

[0005]

[Means for Solving the Problems] The depreciation amount department allocation device of the present invention is a department for one or more departments that should bear the depreciation cost for the fixed assets for each asset code attached to each fixed asset. A department ratio master storage unit that stores a department ratio master that associates a department code that identifies the department code with an allocation ratio that is the ratio of the fixed asset burden that the department that the department code represents must Contents of the fixed asset master storage unit that stores the fixed asset name corresponding to each fixed asset having the asset code for a certain period and the corresponding fixed asset name as a fixed asset master, and the department ratio master A keyboard used to enter instructions for updating and data and other information about the update, and a keyboard that displays the input from the keyboard. File information updating means that operates in accordance with an input from the keyboard, adds and corrects an item in the department ratio master, and re-stores the added and corrected contents in the department ratio master storage unit. With reference to the fixed asset master in the fixed asset master storage section for fixed assets corresponding to each asset code existing in the section rate master storage section in the section rate master storage unit that is activated by a predetermined command input from the keyboard, Depreciation amount for a fixed period for fixed assets corresponding to the asset code specified in the department ratio master is extracted from the fixed asset master, and for the department with the department code associated with the corresponding asset code Calculate the depreciation amount according to the allocation rate specified in this department rate master for each preset period Allocation calculation operation unit that outputs the allocation result as a depreciation storage file, depreciation storage file storage unit that stores the depreciation storage file, and a predetermined command is input from the keyboard. Then, there is provided a form output unit for editing the contents of the depreciation and amortization storage file according to a predetermined specification and outputting it to the outside.

[0006]

The present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of the present invention. The depreciation amount department allocation device of the present invention is a keyboard 2 for inputting various data and commands, and a keyboard 2.
Command and the information input from the keyboard 2 described above, which operates when receiving the command and the information, and performs a process of updating the content of the department ratio master in the department ratio master storage unit 4 described later. Is input, and referring to the contents stored in the fixed asset master storage unit 5 and the department ratio master storage unit 4 described later, the depreciation amount of fixed assets is paid at a predetermined rate for each department. An allocation calculation calculation unit 6 that performs a process of allocating, and a department ratio master storage unit 4 that stores the allocation ratio of the depreciation amount for each fixed asset for each fixed asset in association with each other. , A fixed asset master storage unit 5 that stores a fixed asset master that stores the depreciation amount of each fixed asset and the fixed assets in association with each other, and an allocation calculation calculation unit 6
Depreciation storage file storage unit 7 for storing the output result as a depreciation storage file, and a form for editing the contents of the depreciation storage file described above in a predetermined format when receiving a command from the keyboard 2 and outputting it to the outside. Output unit 8
And a display 1 for displaying commands and information input from the keyboard 2.

FIG. 2 is an explanatory diagram showing the storage contents of the department ratio master stored in the department ratio master storage unit 4. That is, the asset code given to each fixed asset, the department code that represents the department that should bear the depreciation cost of the fixed asset that corresponds to this asset code, and the allocation rate of the depreciation cost that corresponds to that department code, that is, the ratio to bear. 2 are associated with each other as a department master and stored in the department master storage unit 4. The process of creating the department master and the storage process of the result in the department ratio master storage unit 4 are performed by inputting a predetermined command from the keyboard 2 to activate the file information update unit 3, and by the file information update unit 3. Let it be done.

The updating process of the department ratio master once stored is similarly performed by operating the file information updating unit 3. At this time, the display 1 displays the input of commands and other information from the keyboard 2.

FIG. 3 is an explanatory diagram showing the contents of the fixed asset master stored in advance in the fixed asset master storage unit 5. That is, the asset name indicating the fixed asset name and the same asset code given to each fixed asset as shown in FIG. 2, the acquisition date of the fixed asset, and the monthly depreciation amount of the fixed asset. The fixed asset master is stored in the fixed asset master storage unit 5 by associating and with each other.

Next, a predetermined command is input from the keyboard 2 to activate the allocation calculation operation unit 6. The allocation calculation calculation unit 6 reads out the department ratio master from the department ratio master storage unit 4, and uses the asset code as a key to store the fixed asset master storage unit 5
Extract the monthly depreciation amount associated with the relevant asset code in the above, and for each department code associated with the above-mentioned asset code in the department ratio master, assign the allocation associated with that department code. The amount in charge of the rate is calculated, and the result is output to and stored in the depreciation storage file storage unit 7 as a depreciation storage file.

FIG. 4 is an explanatory diagram showing an example of the contents of the depreciation storage file output by the allocation calculation computing unit 6. Figure 4
As shown in, the asset code described above in the depreciation storage file, the department code corresponding to this asset code, and the fixed asset whose department corresponding to the department code corresponds to the asset code described above from the first month. The amount of depreciation to be paid each month up to the 12th month is associated with each other. If there are multiple department codes corresponding to the same asset code, another corresponding department code and the depreciation amount to be paid by the department corresponding to that department code are associated by month on the right side of FIG. Will be generated. Such a depreciation storage file is generated for all fixed assets in the department rate master.

Then, when a command for activating the form output unit 8 is input from the keyboard 2, the form output unit 8 reads the contents of the depreciation storage file stored in the depreciation storage file storage unit 7, It is edited in a predetermined format and its contents are output to the outside. Therefore, this output can be printed on paper by connecting it to a printer, for example.

The output content of the allocation calculation calculation unit shown in FIG. 4 is the depreciation amount to be paid for each month for the 12 months from the first month to the 12th month. The period calculated by 6 may be set arbitrarily.

Further, the depreciation amount in the fixed asset master stored in the fixed asset master storage unit 5 is not limited to the amount per month, for example, the depreciation amount for one year, and the allocation calculation is performed. If the allocation amount to each department is divided monthly by the department 6 as described above, when calculating the allocation amount by the allocation calculation calculator 6, first, the depreciation amount extracted from the fixed master is divided into 12 equal parts. Then, by setting the operation of the allocation calculation calculation unit 6 so as to multiply by the allocation ratio given next, it is possible to calculate the allocation amount of each department for each month.

[0016]

As described above, in the depreciation amount division allocation device of the present invention, the division to which the depreciation cost for the fixed asset should be assigned and the burden rate of the division are associated with each other for each fixed asset. By storing the fixed asset master that correlates the department rate master and the depreciation amount that should be depreciated for each fixed asset for each year, the depreciation amount that each department should bear can be calculated manually. It is possible to output in a short time without needing it, and it is possible to reduce the burden on the operator.

[Brief description of drawings]

FIG. 1 is a block diagram showing an embodiment of a depreciation amount department allocation device of the present invention.

FIG. 2 is an explanatory diagram showing stored contents in a department ratio master storage unit.

FIG. 3 is an explanatory diagram showing storage contents in a fixed asset master storage unit.

FIG. 4 is an explanatory diagram showing the contents of a depreciation storage file output by an allocation calculation calculation unit.

[Explanation of symbols]

 1 Display 2 Keyboard 3 File Information Update Section 4 Department Rate Master Storage Section 5 Fixed Asset Master Storage Section 6 Allocation Calculation Calculation Section 7 Depreciation Storage File Section 8 Form Output Section

Claims (1)

[Claims] 1. A department code for identifying one or more departments that should bear depreciation costs for the fixed assets for each asset code assigned to each fixed asset and a department represented by the department code should bear the department code. A department ratio master storage unit that stores a department ratio master that correlates the allocation ratio, which is the ratio of the burden of fixed assets, with each other, and a fixed depreciation amount for fixed assets that have that asset code for each asset code. Enter the fixed asset master storage unit that stores the amount of the period and the corresponding fixed asset name as a fixed asset master by associating them with each other, the command for updating the contents of the department ratio master, the update data, and other information. A keyboard used for the display, a display for displaying the input from the keyboard, and operating according to the input from the keyboard. File information updating means for performing addition and modification of items in the department ratio master and re-storing the added and modified contents in the department ratio master storage unit, and a predetermined command input from the keyboard For fixed assets corresponding to each asset code existing in the department ratio master in the department ratio master storage unit, refer to the fixed asset master in the fixed asset master storage unit and specify the asset code specified in the department ratio master. The depreciation amount for a fixed period for the corresponding fixed asset is extracted from the fixed asset master, and the allocation specified in this department rate master is assigned to the department with the department code associated with the corresponding asset code. The depreciation amount is calculated according to the rate and allocated for each preset period, and the allocation result is output as a depreciation memory file. An allocation calculation operation unit, a depreciation storage file storage unit for storing the depreciation storage file, and a predetermined specification of the contents of the depreciation storage file when a predetermined command is input from the keyboard. A depreciation amount department allocation device, comprising: