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

Task 3

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:

YearAdvertisingSales
20022201200
20032601400
20043201500
20053601800
20064202200
20075002300
20085402600
20097803000
20109003100
20119403300
201210003650
201310403800
201411204300
201511904870

(Sutherland & Holstead, 2014)

Line chart:

(Sutherland & Holstead, 2014)

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

BranchesNet Income
London240
Birmingham180
Bristol160
Cambridge140
Coventry130

(Sutherland & Holstead, 2014)

Pie chart:

Unit 3 Business Decision Making Assignment Help

Unit 3 Business Decision Making Assignment Help

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:

YearSales
20021200
20031400
20041500
20051800
20062200
20072300
20082600
20093000
20103100
20113300
20123650
20133800
20144300
20154870

Trend line:

sale

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

c) Prepare a business presentation using suitable software (power point) and techniques (graphic representations of data) to disseminate information effectively regarding the above scenario of the company. (AC 3.3)

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

 

Maddox Smith

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