• September 9, 2016
• 0

This is a solution of Unit 3 Business Decision Making Assignment Help in which we discuss Developing business

### a) Produce line graphs for advertising and sales figures given from 2002 to 2015, pie and bar charts for net income generated by the five branches of the company and scatter graphs of advertising and sales figures using spreadsheets.(AC 3.1 & AC 4.1)

Data given:

 Year Advertising Sales 2002 220 1200 2003 260 1400 2004 320 1500 2005 360 1800 2006 420 2200 2007 500 2300 2008 540 2600 2009 780 3000 2010 900 3100 2011 940 3300 2012 1000 3650 2013 1040 3800 2014 1120 4300 2015 1190 4870

Line chart:

Net income generated by five different branches as follow (given):

 Branches Net Income London 240 Birmingham 180 Bristol 160 Cambridge 140 Coventry 130

Pie chart:

### b) Create trend lines in the spreadsheet on scatter graphs (scatter plot previously plotted) to assist in forecasting sales figures for years 2016 – 2017. Get the linear equation of the line fitted on the scatter graph. (AC 3.2 & AC 4.1)

Data given:

 Year Sales 2002 1200 2003 1400 2004 1500 2005 1800 2006 2200 2007 2300 2008 2600 2009 3000 2010 3100 2011 3300 2012 3650 2013 3800 2014 4300 2015 4870

Trend line:

Below are the forecasted figures:

For the year 2016 = 4,800

For the year 2017 = 5,000 Read more : Five Personality Traits Assignment part 2

### d) Produce a formal business report for the Board of Directors meeting using the above scenario and the work that you have done in AC 3.1, AC 3.2 & AC 3.3. (AC 3.4 )

To,

Board of Directors,

ABC Ltd.

Subject: – Analysis over sales and net income performance

Date: – 11th July, 2016

Business decision making process require relevant and adequate level of information so that management make influencing decisions. In order to get the relevant information various aspects get considered effectively and this report include the various factors over which need to be focused by the board of directors. For this purpose this report having analysis of the various performance such as sales and net income. For net income various different branches get analysed in order to render effective information(Valaskova, et. al., 2015).

For the representation purpose tables and graphical representation is made as it render the effective information related to the personal performance and it helps in easy understanding. With the help of the information gathered and represented it is analysed that there is subsequent increase is noted down in the sales. There is also increase in advertisement cost and it gets proportionate to the sales revenue. Due to proportionate ratio both factors increasing simultaneously. With the use of the pie chart and bar chart the information related to net income of five different branches get represented and as per the information represented it is observed that London branch yields high net income as compare to other branches. The lowest net income generating branch is of Coventry so it is essential for management to manage their affairs and help them in improving their performance. Management need to take effective decision and corrective actions in order to improve their overall performance(Valaskova, et. al., 2015).

In order to make the representation of the forecasted figures for the period of 2016 and 2017 trend lines get utilised as it helps in supporting the business decision making process. For trend line regression analysis is utilised as it renders accuracy or correct forecasted figures. The forecast figures are as follows:

For the year 2016 the forecasted figures are 4,800 and for 2017 they are 5,000.

Regression analysis is as follows:

y = 267.1x + 783.4

R2 = 0.984

With the help of regression analysis it is analysed that forecasted figures are accurate as it is near to 1 (R2 = 0.984). These forecasted figures are accurate and effectively get utilised for the purpose of decision making(Forquer Gupta, 2012).

Cheap Assignment Help provide assignment writing service based on case study requirements in affordable prices and we are providing most flexible online assignment writing help, so book your Assignment with us,  Order Now

Hey,
Greetings for the day !
Hope that you’re well !

We want to introduce ourselves as a team of professionals who are into academic writing for the last 10+ years. We can provide assignment assistance in all subjects. Our experts can provide solutions across all the topics right from Management, HR, Marketing, Finance & Accounts, Statistics, IT, childcare, nursing, law, and general writing. We provide plagiarism free work and also send a ‘Turnitin’ report along with completed work. Our services are available at reasonable cost; we entertain amendment requests from clients without any extra charges.

Our Feature Included

Ø Every assignment includes graphical representation like pie chart, bar graph, smart art and all.
Ø Free 0% plagiarism report
Ø Expert team for technical work as well.
Ø On time delivery
Ø Multiple rework facility
Ø Huge team of expert in each subject
Ø Referencing like: Harvard, APA, MLA, Oscola, automatic referencing all are familiar to our experts.

Subject we cover: Math , finance, economics, accounts, civil engineering, mechanical engineering, IT, Computer science, electrical and electronics engineering, history, geography, political science, sociology, physiology, philosophy, biology, microbiology, biotechnology, biotechnology, B-school assignments, project report, psychology, nursing assignments, medical assignments, Tourists and travelling assignments all kinds of dissertation and so on

Best Regards:
Oz Paper Help
WhatsApp:+1 585-666-2225
Email:ozpaperhelp@gmail.com
www.ozpaperhelp.com
www.cheapassignmenthelp.co.uk
www.freeassignmenthelp.com

https://www.ozpaperhelp.com/
1 Step 1
GET INSTANT ASSIGNMENT HELP BY PHD EXPERTS FROM UNITED KINGDOM
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right