business analysis report to support a business bank loan application for $100,000

Assignment – Business Report
Based on the Business Scenario students are required to complete a business analysis report that could be used to support a business bank loan application for up to $100,000 (Your actual loan amount will depend on your calculated project budget).
Students can choose a type of business within any industry that they are interested in. For example if your major is accounting you could choose to develop an information systems for an accounting firm that is currently paper based in order to bring the business into the 21st century.
Your report may not be based on a real business. You can review real businesses to get ideas to improve your business.
Your business must operate in 4 different locations in one city. In the future your business may open 10 new operations in other cities to bring your business empire to a total of 14 locations.

Below are the requirements of your Business Report. Please follow these guidelines along with the assignment rubric while completing this report.
Table of Contents Page
1.0 Introduction

1.1 Background

1.2 Aim

2.0 Business Overview

3.0 Business Analysis

4.0 Business Analysis Team

5.0 Business Analysis Team ICT (Information and Communications Technology consultants)

6.0 Business Process Analysis and Management (BPM)

7.0 BPM ICT Design

8.0 Customer Relationship Database Design

9.0 Project Plan

10.0 Project Budget

11.0 Conclusion

12.0 References

1.1 Introduction and Background to the report

[Make sure your work is 1.5 spacing]
[Refer to the sample report for an example of background content]

What we are looking for
• The paragraph clearly outlines the background for this report
• Understands what a background for a report is.
• Why is the report being written?

1.2 Aim of the report

[Make sure your work is 1.5 spacing]
[Refer to the sample report for an example of aim content]

What we are looking for
• The paragraph clearly outlines the aim for this report
• Understands what an aim for a report is
• aims and objectives in detail
• the problem or situation that prompted this report
• what the report intends to achieve
• any definition of terms

2. Business Overview
[Provide an overview of your business. Describe the main features of your business. History, business mission, goals, objectives, key products and or services, staff roles and numbers, customers, market etc . Your report may not be based on a real business.]
Diagram 1. Using MS Word Smart Art or shapes, draw a supply chain management (SCM) diagram to illustrate your business supply chain.

[200 words]
What we are looking for
• The section clearly outlines an overview of the business and why the business loan is required
• Introduce your business and its mission, goals and objectives. Describe how you will measure whether you have achieved your objectives and an estimated timescale.
• Remember your business must operate in 4 different locations in one city.
• Diagram 1. Using MS Word Smart Art or shapes, draw a supply chain management (SCM) diagram to illustrate your business supply chain.

3. Business Project Analysis
Introduce your business analysis, identifying the areas of your business that you have reviewed and why?
Which of your business functions (processes and departments) are you investigating?
Why are you conducting this analysis?
What are the current problems these business functions?
How will this project improve your businesses efficiency?
[300 words]
What we are looking for:
• Clear identification of the business functions you are investigating.
• Discussion of the current problems of these business functions?
• Identification of how this project will improve your businesses efficiency?

4. Business Analysis Team
Developing a new information system for your business requires employees at all levels to work in effective teams to ensure the success of this new system. Identify the team/s that you will need and the responsibility of the team/s. Include the types of IT staff that will be hired to help you develop the project. What role/s will you allocate to each individual in these teams and why?
[200 words]
What we are looking for:
• A list of people who will be involved in the development of your project. (Business and IT)
• A description of the individual roles (jobs) of people who will be involved in the development of your project and why you chose them to be in your project development team.
[Effective teams: Refer to Chapter Extension 1: Improving your Collaboration Skills. pg 404 – 411]

5. Business Analysis Team ICT (Information and Communications Technology)

How will your teams collaborate to achieve the goal of developing a new information system? What types of technology will your team use to communicate?
[100 words]

[Refer to Chapter Extension 2: Using Collaboration Information Systems. pg 414 – 429]

6. Business Process Analysis and Management (BPM)

An organization’s success depends on quality of managers’ decisions.
To be able to make good management decisions a manager must understand the business processes that are key to the success of their business.

Describe one of the main processes that are a feature of your business.
Diagram 2. Using MS Word shapes draw a BPMN diagram to illustrate your existing main business processes.

[300 words]

What we are looking for:
• 1 diagram (BPMN before IS technology)
• Decisions: Which will be improved
• Why?
• How will they be improved?
• Explain what process will be impacted by the new information system
• Demonstrate your understanding of the impact of your decision making process
[Business Processes: Refer to Chapter 2: Business Processes, Information and Information Systems. pg 27 – 41]
[SCM diagrams: Refer to Chapter 8: Digital Commerce and Web 2.0. pg 237 – 243]
[BPMN diagrams: Refer to Chapter 7: Business Process Management diagrams and examples. pg 197 – 202]
[Decision Making: Refer to Chapter Extension 3: Information Systems and Decision Making. pg 432 – 436]

7. BPM ICT Design

List and describe the types of ICT that you will use to enable your new business processes.
Discuss why you have selected each ICT.

What decision process steps would be improved by introducing a new IS system? Why?
Diagram 3. Draw a second BPMN diagram to illustrate your planned main business processes after the implementation of your new information systems.
[200 words]

• Identifies the types of information systems that this loan supports
• 1 diagram (BPMN after the implementation of IS technology)
• Discusses the decision process steps would be improved by introducing a new IS system and why?

8. Customer Relationship Database Design

Databases are created to operate large quantities of information by inputting, storing, retrieving, and managing that information. Databases are used to support internal operations of organizations and to underpin online interactions with customers and suppliers

Describe the types of information will each of your users need?
What information will be stored in your knowledge management system (Database)?
Why is this information important to your business?
[100 words]

Access: Create a customer relationship management database using MS Access for your business.
Arrange the information needed by each type of staff member you identified into an Access Database.
Ensure that you create ‘enforced’ relationships between the tables.
Create 2 Queries for your database.
1. Create a query that displays typical Customer orders.
2. Create a query of your choice (including 1 group total) that provides useful information to you as owner of the business.

What we are looking for.
• A list of the type of information each user will require to perform their role and why this information is important.
• A sample ACCESS database containing the types of information that your business will need.
• For each entity, include all the attributes. Identify the primary key. If there is any foreign key identify it as well.
• Create ‘enforced’ relationships between the tables
• Use realistic sample data to populate each of the tables with 3-5 records (using MS Access).
• Create 2 queries.
• NOTE: Your database and data will be unique to your business.
[Name your ACCESS file with your student ID.
Submit your Access File
Create a folder with your Student ID. Insert your ACCESS file.
Submit your folder to your class folder in the QIBT Dropbox (I drive)
> 1008ICT Assignment Folder
> Your Class folder

[Refer to Chapter Extension 7 Using Microsoft Access 2010 pgs 484 – 495]
[Chapter Extension 8 “Using Excel and Access together” Pg 516 – 521 “How can you create group totals in ACCESS?”]

9. Project Plan
You will used the supplied Excel Project Planning file to create a WBS table, a Gantt Chat and a PERT chart to help you manage you project.
In approximately discuss how you would use your Project Plan Excel file to help you manage your project.

Using the Supplied Excel Project Planning file:
• Create your WBS table using MS Excel.
• Insert your start date
• Assign task names and durations to tasks in your project.
• Specify task dependencies.(Predecessors)
• Create a PERT/CPM diagram for your project and identify the critical path in RED.
• Discuss how you would use your Project Plan Excel file to help you manage your project.

[200 words]

[Use the one Excel file for your budget and project plan].
• Create a folder with your Student ID. Insert your EXCEL files.
• Submit your folder to your class folder in the QIBT Dropbox (I drive)
> 1008ICT Assignment Folder
> Your Class folder
What we are looking for:
• WBS Table and Gantt Chart.
• Assign durations to tasks.
• Specify task dependencies.
• Identify Critical path in PERT/CPM.
• Discuss how you would use your Project Plan Excel file to help you manage your project.

[Refer to Chapter Extension 11 Systems Development Project Management pgs 563 – 576]

10. Project Budget

Describe the process and steps required for preparing your budget for your new information system.
Using Microsoft Excel prepare a budget for this information system.
Conduct searches for up-to-date prices of the following items required to install and implement the information system for your business, including:
• hardware,
• software
• networking
• Staff
• training
• other expenses
Provide links to any site that you use or reference.
Provide active website links to any site that you use or reference in your spreadsheet. (Inset supplier website URLs to your spreadsheet as active links)
You must use Excel Formulae and functions to calculate your budget. Typed in answers (literals) will receive no marks.
Create 1 chart of your choice to visually identify the important information in your budget.
[100 word introduction to summarizing your budget and excel file]
What we are looking for:
• A description of the process and steps (Around 100 words)
• A list of active website links to supplier websites.
• Budget table in Excel including hardware, and software components.
• Use of Excel Formulae and functions to calculate your budget.
• Total Cost adds up to no more than $100,000
• An Excel Chart visually identifying the important information in your budget.
[Name your Excel file Budget and Project plan and your student ID].
• Create a folder with your Student ID. Insert your EXCEL files.
• Submit your folder to your class folder in the QIBT Dropbox (I drive)
> 1008ICT Assignment Folder
> Your Class folder
[Refer to Chapter Extension 5 Introduction to Microsoft Excel pg 447 – 465
Chapter Extension 6 Preparing a Computer Budget using Excel pg 466 – 483
Chapter Extension 8 Using Excel and Access Together: Charts pg 512 – 516]

11. Conclusion
[The conclusion should be a summary of your findings (business analysis). It should attempt to provide a response to key questions you posed in the introduction (why you need this loan). Remember NO NEW INFORMATION]
[150 words]
What we are looking for
• The section provides a clear conclusion for the report
• The section provides a clear conclusion of section 3.0 – 10.0
• The section clearly identifies why the report is written to support the loan application and why the loan should be approved

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get ordering with idealtermpapers.com now! Contact our live support team for any assistance or inquiry.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total:

Purchase Guarantee

Why ORDER at IdealTermPapers.com?

  • Educated and experienced writers.
  • Quality, Professionalism and experience.
  • Original Content writing.
  • Best customer support.
  • Affordable Pricing on orders.
  • Thorough research.
  • Ontime delivery of finished work.
  • 100% plagiarism free papers.

Reasonable Prices

  • To get the best quality papers isn’t cheap so don’t trust extremely low prices.
  • We can’t claim that we have unreasonably low prices because low prices equal to low quality.
  • Our prices are good and they balance with the quality of our work.
  • We have a Moneyback guarantee.

Original and Quality work

  • Our writers are professionals and they write your paper from scratch and we don’t encourage copy pasting.
  • All writers are assessed and they have to pass our standards for them to work with us.
  • Plagiarism is an offence and it’s never tolerated in our company.

Native Writers plus Researchers

  • Our writers are qualified and excellent and will guarantee the best performance in your order.
  • Our team has writers who have master's and PhD qualifications who can handle any assignment
  • We have the best standards in essay writing.

We have been in business for over 7 syears

  • We have always served our customers from all over the world and they have continued to order with us.
  • We value our customers since they have trusted us to do their assignments.
  • We are competent in our writing gained from experience over the years
  • Our company has 24/7 Live Support.

You will get

  •  Custom Admission Essay written by competent professional English writers.
  •  Free revisions according to our revision policy if required
  •  Paper format:  275 words per page, Times New Roman font and size 12, doublespaced text and1 inch margin
  •  On time delivery and direct order download
  •  Privacy guaranteed

We can help you:

  •  acquire a comprehensive professional presentation.
  •  get a unique and remarkable content as per your instructions.
  •  Get an additional portion that can be included to your existing presentation;
  •  turn your work in to an eyecatching presentation with well communicated ideas.
  •  improve your presentation to acquire the best professional standards.