Create a budget proposal spreadsheet

Assignment Help Corporate Finance
Reference no: EM131393854

Budget Exercuse

Create a budget proposal spreadsheet for the requested security modifications. Use all information described in the video scenario to include estimated costs for each modification, a cost-benefit analysis for each item requested, and an estimated return on investment. A budget template and APEX building layout are provided.

Apex Security Budget Exercise Transcript

Speakers: Narrator, Ed Blocker

Slide 1.2

NARRATOR: Welcome to the APEX Security Budget Exercise Module. This module will provide you with the information and resources you need to complete the security budgeting exercises required for this course. Please refer to the Assignment Instructions for further details.

Select the Start button when you're ready to begin.

Slide 1.3

NARRATOR: APEX is a fifty thousand square foot munitions manufacturing facility located in the southwestern United States. APEX employs three-hundred personnel and has a gross income of twenty million dollars per year.

You are part of a team of thirty-five corporate security specialists working at APEX. As the security manager, you've been called to a meeting with Ed Blocker, the CEO.

Slide 1.4

NARRATOR: Here are three video excerpts from your meeting with Mr. Blocker. Select the Play All button to play all three in sequence.

Slide 1.5

ED BLOCKER: Thank you for taking the time to meet with me. I've called you here because I need your help and advice.

A few days ago I met with Agent Carlson of the FBI, who informed me that they'd become aware of terrorist plans to attack or infiltrate a U.S. munitions facility.

As you know, APEX is one of the nation's largest munitions facilities. That makes us a prime target.

The FBI wants assurances and evidence that we're taking all appropriate measures to secure the facility.

I don't think I need to explain what could happen if even one terrorist was able to get past security.

The effects to human life and safety could be horrific, not to mention damage to the company's reputation, loss of revenues, and potential liability for associated losses.

We can't afford to ignore it. On the other hand, we need to be sure the money we spend produces real and measurable benefits.

What I need to know is, how much will it cost to improve security to the extent necessary to counter this potential threat? And just as important, how can we know the money will be well spent?

Slide 1.6

ED BLOCKER: Here are the basic security modifications we need to address the challenge. First, we need to hire and train five additional security personnel.

The FBI also recommended we install a video surveillance system, biometric access control, and high-security perimeter fencing.

While we're at it, we need to fortify our computer network against hackers and predators. Let's beef up security against cyber threats by upgrading antivirus software and firewalls.

All this is in addition to our current security operations. So what I need from your team is a budget for these five upgrades.

Slide 1.7

ED BLOCKER: For your budget proposal I'll need to see a spreadsheet listing each of the line items I mentioned, along with a cost/benefit analysis for each item, and an estimated return on investment.

I'll also need a written explanation of the metrics you intend to use to measure the benefit of each item and justify its expense.

You'll find a list of all the requirements here in this document. I'll need your proposal here on my desk by a week from today.

Now I hope you'll forgive me, but I have to take an important call. Thank you for your time and I look forward to your best effort.

Slide 2.1

NARRATOR: Let's take a moment to review the key takeaways from this APEX security upgrade request. The five requirements are as listed here:

Install a video surveillance system...

Install a biometric access control system...

Install perimeter fencing...

Hire and train five additional security personnel...

And fifth, upgrade antivirus and firewalls for the company network that includes 100 desktop computers.

Slide 2.2

NARRATOR: Here is a list of important factors you should keep in mind as you complete your assignment or any real-world security budget proposal.

Please review each one. When you've finished, select Next to the final screen of this module, which contains resources to help complete your assignment.

Risk: Risk is a combination of probability and criticality.

This means that, just as you can't afford to ignore the events that are most likely to happen, you have to consider events that may not be as likely to happen, but could be disastrous if they did.

So, as you complete your budget, cost-benefit analysis and metrics, balance the risks you are trying to reduce against the cost of reducing them.

Costs: Costs for each line item do not need to be actual costs but they do need to be realistic.

Metrics: You need to support whatever costs and benefits you propose with a description of how you plan to measure the results and justify the expense.

Physical Layout: There are no one-size-fits-all budgets. Your proposals should therefore take into consideration the size and layout of the facility to determine how much of each item will you need and where it will be most effective.

Slide 3.1

NARRATOR: Feel free to download any of the resources listed on screen. You may use the pre-formatted documents as-is or modify them to suit your needs.

Attachment:- Attachment.rar

Reference no: EM131393854

Questions Cloud

What are two factors to be considered in time value of money : Explain the phrase "a dollar today is worth more than a dollar tomorrow." What are the two factors to be considered in the time value of money?
Select a policy or piece of legislation that directly impact : Select a policy or piece of legislation that directly impacts your current or future profession (i.e., your major). In your initial post, identify your profession or future profession, define federalism, and then select a specific piece of legisla..
Describe how people can identify their federal tax brackets : Explain which account would earn more money for the investor: a traditional IRA or a Roth IRA. Support your statements with reasons and examples. Describe how people can identify their federal tax brackets.
Select a control or display in your environment : Select a control or display in your environment. Describe and evaluate it with respect to general guidelines for controls or displays. Should it be redesigned? Select a warning label. Evaluate it with respect to general principles for design of w..
Create a budget proposal spreadsheet : Create a budget proposal spreadsheet for the requested security modifications. Use all information described in the video scenario to include estimated costs for each modification.
What is the inventory turnover : Big Bang Fireworks normally purchases $120,000 of inventory each day. Each item normally remains in inventory 18 days before it is sold.
Write a comment about the given post : Most of the elderly at their end-of-life stage do not die at home as it is their desire. Despite the development of palliative care programs, it has remained a challenge to ensure that most of the elderly die in their homes. One of the main reason..
Write a literature review section for research proposal : Write a 5-6 Literature Review section for research proposal. Each week you have been adding to your growing body of evidence to support your problem and proposed innovation to address the problem. The review of literature is a critical, analytical..
How would you use demographic data to characterize disease : How would you use demographic data to characterize this disease?How would you incorporate further research to address this disease?How would you use morbidity and mortality in developing prevention strategies aimed at increasing attention to diseas..

Reviews

Write a Review

Corporate Finance Questions & Answers

  Theory question based on investment in stock

Theory question based on investment in stock - What if she repeats the experiment 10 times?

  Describe the strengths and weaknesses of the company

The Final Paper will involve applying the concepts learned in class to an analysis of a company using data from its annual report. Using the concepts from this course, you will analyze the strengths and weaknesses of the company.

  What strategy should the investor follow

The index futures price is currently 1,500 and one contract is for delivery of $50 times the index. The beta of the stock is 1.3. What strategy should the investor follow?  - Under what circumstances will it be profitable?

  Calculation of cost of preferred stock cost of debt and

calculation of cost of preferred stock cost of debt and cost of issuing new stock.1nbsp the cost of preferred stock is

  Calculate the future value of stock

A share of stock sells for 53 dollar today. The beta of the stock 1.2, & expected return on the market is 12 percent. The stock is expected to pay a dividend of 1.10 dollar in one year.

  Write text for a small business website

Write text for a small business website.- If you were starting your own business, how would you represent your product or services on your website?

  Explain the impact of credit rating on cost of capital

Clearly discuss the weaknesses in the CFO's position. Under what circumstances will the CFO's proposal for capital expenditure financing result in an unfavorable capital project outcome? Suggest other sources of financing.

  What is the future value of these cash flows

If the company uses an 8 percent discount rate and what is the future value of these cash flows at the end of year 4?

  1nbsp compare the following mortgages and determine which

1.nbsp compare the following mortgages and determine which has the lower costnbspfrmarmmortgage

  Forecast individual financial statement items

What specific methods can you use to forecast individual financial statement items, such as SG&A? Discuss.- How can you obtain a discount rate for use in your financial analysis?

  Issuing or purchasing preferred stock

You are told that one corporation just issued 100m dollar of preferred stock & another purchased 100m dollar preferred stock as an investment.

  What is the profitability index of the project

What is the profitability index of the project and the constant-growth rate for dividends must be equal to the required rate of return.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd