4Reports and Inquiry
Option 3Budget Variances - MTD/YTD
This report provides you with budget-to-actual comparisons for month-to-date and year-to-date totals. The following processing steps accomplish this job.
- Step 1Use this function to specify what fiscal month and year to include on the Budget Variances report.
The screen shown below allows you to enter a fiscal month and year for the Budget Variances - MTD/ YTD report.
Budget Variances - MTD/YTD screen
Data items for the preceding screen are described below:
- Fiscal Month
Enter a positive number with u to 2 digits.
Supply the fiscal month of budget data to be displayed.
- Fiscal Year
Positive number, up to 2 digits
Supply the fiscal year of budget data to be displayed.
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, Fiscal Year and Account, 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 Variances - MTD/YTD report, this step formats the Budget Amounts information. The following data items are shown: Account, Description, Budget Amount, Monthly Amount, and Budget Compared to Actual. As appropriate, group headings appear whenever a change occurs in Account Component Account.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 17:00 LGG Page: 1
Budget Variances - MTD/YTD Report
For August 89
MTD MTD MTD YTD YTD YTD
Account Budget Actual Variance Budget Actual Variance
=================================================================================================================================
Budget Type FY90 Budget
Fiscal Year 90
3010001001MA Sales, Manufacturing 366887.00- .00 366887.00- 1237034.00- 765561.50- 471472.50-
3010001001WH Sales, Wholesale 249560.00- .00 249560.00- 788074.00- 560855.13- 227218.87-
3010002001MA Sales, Canadian Manufacturing 149817.00- .00 149817.00- 528562.00- 351141.89- 177420.11-
3010002001WH Sales, Canadian Wholesale 97004.00- .00 97004.00- 271437.00- 248845.81- 22591.19-
3020000000 Service Charge Income 2222.00- .00 2222.00- 6126.00- 4750.00- 1376.00-
4010000000MA Cost of Goods Sold, Corp./Mfg. 25835.20 .00 25835.20 88279.80 38709.39 49570.41
4010000000WH Cost of Goods Sold, Corp/Whlsl 10396.92 .00 10396.92 31785.33 32601.60 816.27-
4010000001MA Cost of Goods Sold, Sales/Mfg. 20668.16 .00 20668.16 70623.84 27000.93 43622.91
4010000001WH Cost of Goods Sold, Sales/Whls 10396.92 .00 10396.92 31785.33 26569.72 5215.61
4020000001MA Sales Commissions, Mfg. 36169.28 .00 36169.28 123591.72 74333.73 49257.99
4020000001WH Sales Commissions, Wholesale 17328.20 .00 17328.20 52975.55 38234.51 14741.04
4040001000 Depreciation Expense 31042.00 .00 31042.00 88863.00 57821.00 31042.00
4040002000 Depreciation Expense, Canadian 21212.00 .00 21212.00 57889.00 30750.00 27139.00
4080000000 Salaries Expense 24754.00 .00 24754.00 68961.00 58862.41 10098.59
4080000000MA Salaries, Manufacturing 44135.00 .00 44135.00 126481.00 98429.71 28051.29
4080000001WH Salaries, Wholesale 35059.00 .00 35059.00 101250.00 76633.20 24616.80
4080100000 Bonuses .00 .00 .00 .00 .00 .00
4090000000MA Repairs and Maintenance, Mfg. 37066.00 .00 37066.00 63180.00 42903.89 20276.11
4090000001WH Repairs and Maintnc, Wholesale 10888.00 .00 10888.00 18809.00 17446.29 1362.71
4100000001MA Promotion/Advertising, Mfg. 16326.38 .00 16326.38 35454.75 21450.00 14004.75
4100000001WH Promotion/Advertising, Wholesl 10773.62 .00 10773.62 21846.55 17400.00 4446.55
4110000000 Travel and Entertainment 26167.00 .00 26167.00 61317.00 22661.05 38655.95
4110000001MA Travel & Entertainment, Sales 19047.00 .00 19047.00 57141.00 24530.41 32610.59
4120000000 Tax Expense, Corporate 7777.00 .00 7777.00 17820.00 15300.00 2520.00
4120000001 Tax Expense, Sales Outlets 6077.00 .00 6077.00 14101.00 50456.29 36355.29-
4130000000 Insurance Expense .00 1000.00 1000.00- .00 1000.00 1000.00-
4130002000 Insurance Expense-Canadian 2566.00 2515.20 50.80 2566.00 2515.20 50.80
4140000000 Interest Expense 18742.00 .00 18742.00 56190.00 37448.00 18742.00
4150000000 Utilities, Corporate .00 .00 .00 .00 .00 .00
4150000001 Utilities, Sales Outlet 11967.00 .00 11967.00 32533.00 16699.66 15833.34
4160000000 Direct Labor 37307.00 .00 37307.00 104281.00 104038.87 242.13
4160000000MA Direct Labor, Manufacturing 25019.00 .00 25019.00 68503.00 50464.38 18038.62
4160000000WH Direct Labor, Wholesale 20260.00 .00 20260.00 48782.00 34922.03 13859.97
4160100000 Vacation & Sick Expense 9594.00- .00 9594.00- .00 35192.24 35192.24-
4170001000MA Factory Overhead, Mfg. 12503.00 .00 12503.00 32840.00 15709.49 17130.51
4170002000MA Factory Overhead, Canadian Mfg 131544.00 .00 131544.00 337885.00 333633.01 4251.99
4180000000 Indirect Labor 10209.00 .00 10209.00 22403.00 16762.14 5640.86
4180000000MA Indirect Labor, Manufacturing 7861.00 .00 7861.00 19820.00 13496.51 6323.49
4180000000WH Indirect Labor, Wholesale 5219.00 .00 5219.00 11602.00 8816.71 2785.29
4190000000MA Freight Out, Corp./Mfg. 2242.00 .00 2242.00 5145.00 3854.51 1290.49
4190000000WH Freight Out, Corp./Wholesale 4831.00 .00 4831.00 11911.00 4080.22 7830.78
4190000001MA Freight Out, Sales/Mfg. 2357.00 .00 2357.00 4993.00 8417.34 3424.34-
4190000001WH Freight Out, Sales/Wholesale 4471.00 .00 4471.00 11580.00 5090.62 6489.38
— Fiscal Year Subtotals —> 166867.32- 3515.20 170382.52- 928044.13- 466919.27- 461124.86-
============= ============= ============= ============= ============= ==========
— Budget Type Subtotals —> 166867.32- 3515.20 170382.52- 928044.13- 466919.27- 461124.86-
============= ============= ============= ============= =========== ============
— Grand Totals —> 24717.32- 3515.20 28232.52- 785894.13- 466919.27- 318974.86-
============= ============= ============= ============= ========== ===========