4Reports and Inquiry
Option 2Budget Review - 6 Months
This report provides you with budget amounts for the first (or last) six months in comparison to the previous six months. The following processing steps accomplish this job.
- Step 1Use this function to specify whether net or cumulative amounts are to be used for printing the Budget Review report.
The screen shown below allows you to enter parameters to define what should be printed on the Budget Review - 6 Months report.
Budget Review - 6 Months screen
Data items for the preceding screen are described below:
- Fiscal Year
Positive number, up to 2 digits
Supply the fiscal year of budget data to be displayed.
- Six Month Period
Positive number, 1 digit
Enter ‘1’ if you wish to see budget information on the first six months of the fiscal year. Enter ‘2’ if you wish to see budget information on the second six months of the specified fiscal year.
Press ENTER to save the information on this screen.
- Step 2In preparation for performing a sort/selection process on the Budget Amounts information, this step provides you with a default sequencing of data records by Budget Type, Account, and Fiscal Year, giving additional sort order choice by Account Component, with the option to change modifiable parameters at run time. Selection of data records is provided by Budget Type, Account, Account Component, and Annual Amount, with the option to enter user-specified comparisons at run time.
- Step 3This disposition type is used for all standard General Ledger reports.
- Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 5In order to print the Budget Review - 6 Months report, this step formats the Budget Amounts information. The following data items are shown: Account, Description, Budget Amount, Six Month Total, and Percent Difference. As appropriate, group headings appear whenever a change occurs in Account Component.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 16:59 LGG Page: 1
Budget Review - 6 Months Report
For Fiscal Year 90
6 Month Prev 6 Mo %
Account Jun Jul Aug Sep Oct Nov Total Total Change
=================================================================================================================================
Budget Type FY90 Budget
Fiscal Year 90
3010001001MA Sales, Manufacturing 428220- 441927- 366887- 376554- 444518- 307287- 2365393- 0 .0
3010001001WH Sales, Wholesale 270134- 268380- 249560- 243899- 222896- 211343- 1466212- 0 .0
3010002001MA Sales, Canadian Manufacturing 197282- 181463- 149817- 165931- 173999- 162280- 1030772- 0 .0
3010002001WH Sales, Canadian Wholesale 84288- 90145- 97004- 85980- 94844- 77918- 530179- 0 .0
3020000000 Service Charge Income 2000- 1904- 2222- 2063- 2328- 1904- 12421- 0 .0
4010000000MA Cost of Goods Sold, Corp./Mfg. 31275 31170 25835 27124 30926 23478 169808 0 .0
4010000000WH Cost of Goods Sold, Corp/Whlsl 10633 10755 10397 9897 9532 8678 59892 0 .0
4010000001MA Cost of Goods Sold, Sales/Mfg. 25020 24936 20668 21699 24741 18783 135847 0 .0
4010000001WH Cost of Goods Sold, Sales/Whls 10633 10755 10397 9897 9532 8678 59892 0 .0
4020000001MA Sales Commissions, Mfg. 43785 43637 36170 37974 43296 32870 237732 0 .0
4020000001WH Sales Commissions, Wholesale 17721 17926 17329 16494 15888 14464 99820 0
4040001000 Depreciation Expense 28216 29605 31042 32541 34088 37769 193261 0 .0
4040002000 Depreciation Expense, Canadian 17839 18838 21212 22246 24036 25095 129266 0 .0
4080000000 Salaries Expense 20618 23589 24754 23911 22802 12879 128553 0 .0
4080000000MA Salaries, Manufacturing 38954 43392 44135 44749 43767 25942 240939 0 .0
4080000001WH Salaries, Wholesale 31727 34464 35059 34278 32282 22631 190441 0 .0
4080100000 Bonuses 0 0 0 0 0 0 0 0 .0
4090000000MA Repairs and Maintenance, Mfg. 11647 14467 37066 39235 30543 37094 170052 0 .0
4090000001WH Repairs and Maintnc, Wholesale 3456 4465 10888 10296 9204 11658 49967 0 .0
4100000001MA Promotion/Advertising, Mfg. 8686 10442 16327 18295 14788 15061 83599 0 .0
4100000001WH Promotion/Advertising, Wholesl 5005 6068 10774 11104 7813 9238 50002 0 .0
4110000000 Travel and Entertainment 16488 18662 26167 20364 17459 19731 118871 0 .0
4110000001MA Travel & Entertainment, Sales 19047 19047 19047 19047 19047 19047 114282 0 .0
4120000000 Tax Expense, Corporate 4378 5665 7777 8343 9476 8755 44394 0 .0
4120000001 Tax Expense, Sales Outlets 3801 4223 6077 6386 5253 6386 32126 0 .0
4130000000 Insurance Expense 0 0 0 0 0 0 0 0 .0
4130002000 Insurance Expense-Canadian 0 0 2566 0 0 2566 5132 0 .0
4140000000 Interest Expense 18718 18730 18742 18755 18769 18784 112498 0 .0
4150000000 Utilities, Corporate 0 0 0 0 0 0 0 0 .0
4150000001 Utilities, Sales Outlet 9828 10738 11967 10319 9303 11170 63325 0 .0
4160000000 Direct Labor 31840 35134 37307 37544 36524 22151 200500 0 .0
4160000000MA Direct Labor, Manufacturing 20371 23113 25019 24926 23485 13210 130124 0 .0
4160000000WH Direct Labor, Wholesale 12752 15770 20260 20642 21270 12270 102964 0 .0
4160100000 Vacation & Sick Expense 2737 6857 9594- 17686 16913 34598- 1 0 .0
4170001000MA Factory Overhead, Mfg. 9776 10561 12503 12271 11088 10535 66734 0 .0
4170002000MA Factory Overhead, Canadian Mfg 85405 120936 131544 162016 155686 134217 789804 0 .0
4180000000 Indirect Labor 6019 6175 10209 10627 9249 16829 59108 0 .0
4180000000MA Indirect Labor, Manufacturing 5149 6810 7861 6925 6855 0 33600 0 .0
4180000000WH Indirect Labor, Wholesale 3111 3272 5219 7832 7559 4949 31942 0 .0
4190000000MA Freight Out, Corp./Mfg. 1358 1545 2242 4529 1845 2016 13535 0 .0
4190000000WH Freight Out, Corp./Wholesale 3078 4002 4831 5676 5706 4941 28234 0 .0
4190000001MA Freight Out, Sales/Mfg. 1203 1433 2357 1924 2073 2095 11085 0 .0
4190000001WH Freight Out, Sales/Wholesale 3905 3204 4471 4228 3854 3218 22880 0 .0
________ ________ ________ _________ ________ ________ ________ _________
— Fiscal Year Subtotals —> 417745- 343433- 166865- 114647- 203933- 178142- 1424767- 0
========= ========= ========= ========= ========= ========= ========= =========
________ ________ ________ ________ _________ _________ ________ _________
— Budget Type Subtotals —> 417745- 343433- 166865- 114647- 203933- 178142- 1424767- 0
========= ========= ========= ========= ========= ========= ========= =========
________ ________ ________ _________ ________ ________ ________ _________
— Grand Totals —> 417745- 343433- 24715- 114647- 141633- 71858 970317- 0
========= ========= ========= ========= ========= ========= ========= =========