Budget proposal

profilenealtwicelove
PADM5387DMVbudgetproposal.xlsx
Home>Government homework help>Budget proposal

Instruction

SOLUTION: Use this template for your estimation report. Feel free to create sheets as you need.
For your final answers, you will need to work on a separate MS Word file.
Halfway drafts and feedback need to be reported in MS Word. Identify the student names who provided feedback.
These extra credit activities are to check and communicate for correcting mistakes, but not to just provide full answers.
For a complete assignment, submit all of the followings:
1) Final Budget Proposal in MS Word
2) Estimation Report in MS Excel: All your calculation process and function data must be recorded in this Excel report. Use multiple sheets in one document. Add as many sheets as you need for revisions and corrections. All your work processes must be based in this report so that the instructor can check every part of the proposal. No information missing in the estimation report can be included in the final budget proposal.
3) Optional—Halfway Drafts and Feedback in MS Word: Refer to the extra credit section in the syllabus for the instruction.
When you or your group submits pre- and post-feedback drafts with revisions, you will receive 2 extra points
When you give comments in 3 or more parts of other student or group’s budget draft, you will receive 3 extra points.

Base info

Division of Motor Vehicles Budget
Base Information
Revenues
Per Old Driver's License Issued
Per New Driver's License Issued
Per Vehicle Registration
Per Failed Vehicle Inspection
Expenditures
Fixed Personnel
Personnel Cost Per Transaction
Materials and Supplies Per Transaction
Overhead Costs
Vehicle Inspection
Vision Test
Road Test
Written Test
License Plate
Old Style Driver's License
New Digitized Driver's License
Per Inquiry into Insurance Database
Transactions
Old Style Drivers' Licenses to be issued Sept. through Dec.
Old Style Drivers' Licenses to be issued Jan. through Aug.
New Style Drivers' Licenses to be issued Jan. through Aug.
New Style Drivers' Licenses to be issued Sept. through Dec.
Vision Tests
Written Driving Tests
Road Tests
Vehicle Inspections
Registrations
Inquiries into Insurance Database
Additional Information
Fail inspection
Registrations get new license plates

Transactions

Transactions per Month
Sept. Oct. Nov. Dec. Jan. Feb. Mar. April May June July Aug. Total
Old Style Drivers' Licenses
New Style Drivers' Licenses
Vision Tests
Written Driving Tests
Road Tests
Vehicle Inspections
Registrations
Total Excluding Ins. Inquiries
Inquiries into Insurance Database

Q1

Department of Transportation
Division of Motor Vehicles
Draft Operating Budget
For the Next Fiscal Year
September October November December January February March April May June July August Total
Revenues
Expenditures
Excess/(Deficit) of Revenues over
Expenditures before State Subsidy

Q2

Answer to Q2.

Q3

Department of Transportation
Division of Motor Vehicles
Draft Operating Budget
For the Upcoming Fiscal Year
September October November December January February March April May June July August Total
Revenues
Expenditures
Excess/(Deficit) of Revenues over
Expenditures before State Subsidy

Q4

Department of Transportation
Division of Motor Vehicles
Draft Operating Budget
For the Upcoming Fiscal Year
September October November December January February March April May June July August Total
Revenues
Expenditures
Excess/(Deficit) of Revenues over
Expenditures before State Subsidy