Week 2 Riordan Manfacturing

profileak6809
riordanbudgetitfy2004.xls
Home>Business & Finance homework help>Operations Management homework help>Week 2 Riordan Manfacturing

Sheet1

Riordan Manufacturing, Inc
FY2004
Consolidated Operating Budget - Cost Center IT
Item Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Total
Compensation
Wages & Salaries $ 92,666 $ 92,666 $ 92,666 $ 92,666 $ 92,666 $ 92,666 $ 92,666 $ 92,666 $ 92,666 $ 92,666 $ 92,666 $ 92,666 $ 1,111,992
Benefits 21,313 21,313 21,313 21,313 21,313 21,313 21,313 21,313 21,313 21,313 21,313 21,313 $ 255,758
Bonuses 50,000 50,000 50,000 50,000 $ 200,000
Total 113,979 113,979 163,979 113,979 113,979 163,979 113,979 113,979 163,979 113,979 113,979 163,979 $ 1,567,750
Other Expenses
Conferences 1,500 1,500 750 $ 3,750
Contracts (1) 3,600 3,600 3,600 3,600 3,600 3,600 3,600 3,600 3,600 3,600 3,600 3,600 $ 43,200
Hardware (2) 1,500 1,500 2,000 2,000 1,500 $ 8,500
Leased Lines 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 $ 50,400
Maintenance 250 250 250 250 250 250 250 250 250 250 250 250 $ 3,000
Office supplies 100 100 100 100 100 100 100 100 100 100 100 100 $ 1,200
Postage 50 50 50 50 50 50 50 50 50 50 50 50 $ 600
Shipping 200 200 200 200 200 200 200 200 200 200 200 200 $ 2,400
Software Licenses 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 $ 42,000
Special Projects 150,000 $ 150,000
Subscriptions 50 50 50 50 50 50 50 50 50 50 50 50 $ 600
Telephone 250 250 250 250 250 250 250 250 250 250 250 250 $ 3,000
Training 500 500 500 $ 1,500
Travel 1,500 1,500 1,500 1,500 3,500 1,500 1,500 1,500 3,500 1,500 1,500 1,500 $ 22,000
Entertainment 200 200 400 200 400 $ 1,400
Total $ 17,400 $ 13,700 $ 15,400 $ 163,700 $ 18,600 $ 13,700 $ 15,400 $ 15,700 $ 16,600 $ 14,450 $ 15,200 $ 13,700 $ 333,550
Total Operating Expenses $ 131,379 $ 127,679 $ 179,379 $ 277,679 $ 132,579 $ 177,679 $ 129,379 $ 129,679 $ 180,579 $ 128,429 $ 129,179 $ 177,679 $ 1,901,300
Notes:
(1) Contracts covered: a: Off site data storage, b: Web Hosting, c: Hardware Maintenance
(2) Capital threshold is $2,000…all purchases, to include hardware, $1,999 or less will be expensed

Sheet2

Sheet3