Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Name of Department: Budget Allocated to Deparment: $ 480,270 Assumption Descriptions Salaries There are four members in the Cybersecurity department. Rent (1) John Doe,
Name of Department: Budget Allocated to Deparment: $ 480,270 Assumption Descriptions Salaries There are four members in the Cybersecurity department. Rent (1) John Doe, the Cybersecurity Director, gets $110,000 salary annually. (2) Karen Smith, the Cybersecurity Engineer, gets a $90,000 salary aanually. (3) Jane Doe, the Security Administrator, gets $70,000 salary annually. (4) Sam Smith, the Network Administrator, gets $50,000 salary annually. The monthly rent for the office space is $10,237.50 Supplies There is a $100 monthly allowance for office supplies, and $53 for postage. Cybersecurity Department Budget 2021 A request for a new laptop, printer, projector, and computer software was made for the month of February. The cost of laptop is $1300. All the staff members of the Cybersecurity department will be given a laptop. The cost of a printer is $3,425, projector is $1,850, and the bundled compuer software is $3,000. Training Three staff members will be attending a training. (1) Two staff members will attend a three-day training in New York in June. The cost of training is $5,000 each. (2) One staff member will attend a four-day training in Las Vegas in October. The cost of training is $6,000 each. Travels The airfare to New York for two persons is $600, while the hotel accommodation is $1,000 each night for the two of them The airfare to Las Vegas for one person is $245 and the hotel accommodation is $250 per night. Each training participants will get a $150 meal allowance a day. Meals Line Items Salaries Rent Supplies Training Travels Meals Mar Monthly Budget Jun Jul Oct Nov Dec Total Apr May Aug Sep $26,666.67 $26,666.67 $26,666.67 $26,666.67 $26,666.67 $26,666.67 $26,666.67 $26,666.67 $26,666.67 $26,666.67 $26,666.67 $320,000.00 $10,237.50 $10,237.50 $10,237.50 $10,237.50 $10,237.50 $10,237.50 $10,237.50 $10,237.50 $10,237.50 $10,237.50 $10,237.50 $122,850.00 $153.00 $153.00 $153.00 $153.00 $153.00 $153.00 $153.00 $153.00 Jan Feb $26,666.67 $10,237.50 $153.00 $13,628.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,600.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $900.00 $0.00 $0.00 $0.00 $6,000.00 $0.00 $995.00 $0.00 $600.00 $0.00 $153.00 $153.00 $15,311.00 $0.00 $16,000.00 $0.00 $0.00 $3,595.00 $0.00 $0.00 $1,500.00 Total $37,057.17 $50,532.17 $37,057.17 $37,057.17 $37,057.17 $50,557.17 $37,057.17 $37,057.17 $37,057.17 $44,652.17 $37,057.17 $37,057.17 $479,256.00 $ Variance Analysis Calculation: % Variance Analysis Calculation: Wages Travel Meals Training Supplies Miscellaneous Jan- Jan- Budget Actual Variance Analysis Actual minus Budget $ Variance / Budget Feb- $ Var % Var Budget Feb- Actual Mar- Mar- Total- Total - $ Var % Var Budget Actual $ Var % Var Budget Actual $ Var % Var $ Wages Wages Wages $ $ $ Travel Travel $ Travel $ $ $ $ Meals Meals Meals $ - $ S $ Training Training Training $ $ $ $ Supplies Miscellaneous Supplies Miscellaneous Supplies $ $ $ $ $ $ $ $ $ Miscella $ $ - $ $ $ $ $ $ $ $ Apr- Budget Apr- Actual May- May- Jun - Jun - $ Var % Var Budget Actual $ Var % Var Budget Actual $ Var % Var Wages Wages Wages S Travel $ Travel $ Travel $ Meals $ Meals $ Meals Training Supplies Training $ Training $ $ Supplies $ Supplies Miscellaneous Miscellaneous Miscellaneous $ $ $ $ $ $ S $ $ - $ $ Jul- Jul- Budget Actual Aug- $ Var % Var Budget Aug- Actual Sep- Sep- $ Var % Var Budget Actual $ Var % Var Wages Travel Meals Training Supplies Wages Wages $ Travel Travel $ Meals $ Meals $ Training $ Training $ $ Supplies $ Supplies S Miscellaneous $ Miscellaneous $ Miscellaneous $ $ $ $ $ $ $ $ $ $ Oct- Budget Oct- Actual $ Var % Var Nov- Budget Actual Nov- $ Var % Var Dec- Budget Dec- Actual $ Var % Var Wages Wages Wages $ Travel Travel Travel $ Meals Meals Meals $ Training Supplies Miscellaneous $ - $ $ Training Training Supplies Miscellaneous Supplies Miscellaneous $ - $ $ $ $ $ $ $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started