4Reports and Inquiry
Option 2Budget Comparison by Subsidiary Code Report
This function prints a summary of the Subsidiary Codes by Account file, sorted by account number within subsidiary code. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the Subsidiary Codes by Account information, this step provides sequencing of data records by Subsidiary Code and Account with no option to change the sequence at run time. Selection of data records is provided by Account Component, Subsidiary Code, Subsidiary Code Type, and Alpha Sort, with the option to enter user-specified comparisons at run time.
- Step 2This disposition type is used for all standard General Subsidiary reports.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Budget Comparison by Subsidiary Code Report, this step formats the Subsidiary Codes by Account information. The following data items are shown: Account, Description, Annual Budget, Year-to-Date Balance, Difference, Lifetime Budget, Life-to-Date Balance, and Difference. As appropriate, group headings and totals appear whenever a change occurs in Subsidiary Code.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 16:16 LGG Page: 1
Budget Comparison by Subsidiary Code Report
Annual YTD Lifetime LTD
Account Description Budget Balance Difference Budget Balance Difference
=================================================================================================================================
Subsidiary Code COMPUTER
1150001000MA Equipment 58400.00 .00 58400.00 236000.00 121630.00 114370.00
1170001000 Accumulated Depreciation .00 1904.00- 1904.00 .00 30844.00- 30844.00
4040001000 Depreciation Expense .00 1904.00 1904.00- .00 30844.00 30844.00-
4080000000 Salaries Expense 81500.00 50421.74 31078.26 198560.00 128273.83 70286.17
4090000000MA Repairs and Maintenance, Mfg. 94420.00 3789.84 90630.16 182800.00 37500.35 145299.65
4110000000 Travel and Entertainment 37200.00 4645.39 32554.61 98990.00 60286.64 38703.36
4160000000 Direct Labor 126820.00 54499.44 72320.56 248950.00 159065.75 89884.25
4180000000 Indirect Labor 40250.00 7151.30 33098.70 159870.00 92365.99 67504.01
—————— —————— —————— —————— —————— ——————
— Subsidiary Code Totals —> 438590.00 120507.71 318082.29 1125170.00 120507.71 526047.44
============ ============ ============ ============ ============ ============
Subsidiary Code GENERAL
1150001000MA Equipment 24000.00 .00 24000.00 .00 476670.00 476670.00-
1170001000 Accumulated Depreciation .00 55917.00- 55917.00 .00 711143.74- 711143.74
4040001000 Depreciation Expense .00 55917.00 55917.00- .00 55917.00 55917.00-
4080000000 Salaries Expense 189410.00 33888.78 155521.22 .00 33888.78 33888.78-
4090000000MA Repairs and Maintenance, Mfg. 265812.00 56783.41 209028.59 .00 56783.41 56783.41-
4110000000 Travel and Entertainment 211814.00 30091.77 181722.23 .00 30091.77 30091.77-
4160000000 Direct Labor 289166.00 103633.51 185532.49 .00 103633.51 103633.51-
4180000000 Indirect Labor 75755.00 17580.65 58174.35 .00 17580.65 17580.65-
—————— —————— —————— —————— —————— ——————
— Subsidiary Code Totals —> 1055957.00 241978.12 813978.88 .00 241978.12 63421.38-
============ ============ ============ ============ ============ ============
Subsidiary Code JONES
3010001001MA Sales, Manufacturing 1831317.00- 411194.51- 1420122.49- .00 411194.51- 411194.51
4010000001MA Cost of Goods Sold, Sales/Mfg. 107127.00 15004.70 92122.30 .00 15004.70 15004.70-
4020000001MA Sales Commissions, Mfg. 187472.00 27145.24 160326.76 .00 27145.24 27145.24-
4100000001MA Promotion/Advertising, Mfg. 55708.00 11200.00 44508.00 .00 11200.00 11200.00-
4110000001MA Travel & Entertainment, Sales 76188.00 15939.33 60248.67 .00 15939.33 15939.33-
4190000001MA Freight Out, Sales/Mfg. 9822.00 4642.08 5179.92 .00 4642.08 4642.08-
—————— —————— —————— —————— —————— ——————
— Subsidiary Code Totals —> 1395000.00- 337263.16- 1057736.84- .00 337263.16- 337263.16
============ ============ ============ ============ ============ ============