BA3020QA - Using and Managing Data and Information - April 2022

This assignment solution focuses on using and managing data and information, addressing several tasks that involve fundamental mathematical concepts. It includes calculations related to work rate problems, revenue generation, road construction timelines, and paint mixture ratios. The solution also covers combinations and permutations, electricity bill calculations, mortgage repayment scenarios, and discount calculations. Furthermore, it involves solving linear equations and interpreting graphs, including determining gradients and equation of a line. The assignment concludes with a linear programming problem, providing a graphical solution and analysis to maximize profit based on production constraints. The document includes references to support the methodologies and concepts used.

Using and Managing
Data and Information

Table of Contents
INTRODUCTION.............................................................................................................................3
MAIN BODY....................................................................................................................................3
Task1........................................................................................................................................3
Task 2.......................................................................................................................................4
Task 3.......................................................................................................................................5
Task 4.......................................................................................................................................6
Task 5.......................................................................................................................................7
CONCLUSION.................................................................................................................................9
REFERENCES................................................................................................................................10

INTRODUCTION
Managing Data is very crucial and the basic computation should be known by every
person for their daily routine activities (Abiodun, Anisi and Khan, 2019). Several duties related to
using and maintaining information and data are carried out in this report. Data are numerical and
qualitative rows of facts and numbers, while data is organized and arranged data that supports
choice. The tasks in this paper are carried out using fundamental mathematical ideas.
MAIN BODY
Task1
(A) It is stated that a fence may be painted in 3 hours by 8 workers. In other words, a fence can be
painted in 3 to 8 hours by one person. Assuming that everyone works at the same pace, the
following calculation can be used to determine how long it took 12 people to paint the fence.
= 3/8 * 12
= 4.5 hours.
(B) The number of tyres sold in July and the revenue attributable to those sales are disclosed.
No. of tyres sold by the tyre seller = 510
Revenue from selling 510 tyres = 25500
Therefore, revenue generated by 1 tyre will be = 50.
If 670 tyres are sold by the tyre seller at the same price that is £50 per tyre, total revenue will
generate,
= 670 * 50
= £33500.
(C) It is stated that a 200 m long road was constructed by a total of 12 persons over the course of
5 days. The time needed by 20 persons to construct a 400 m long road can be computed as
follows: - 1 man can construct a 1-meter road in 1 hour:
time is taken by 1 man to build 1m long road
= 5*12 / 200
= 0.3 day
Total time taken by 20 men to build a road of 400m long
= 5*12*400 / 200 * 20
= 6 days

(D) Super paint is mixed by using yellow and blue in the ratio of 7:2.
(a) To make 72 litres of super paint
yellow colour in the ratio of = 72 * 7 / 9
=56
Blue colour in the ratio of = 72 * 2/ 9
= 16.
(b) To make 35 litres of super paint
yellow colour in the ratio of = 35 * 7 / 9
=27
blue colour in the ratio of = 35 * 2 / 9
=8.
Note:- Any decimals are ignored.
Task 2
(a) This algorithm can be used to combine 4 pupils from a class of 30 students.
nCr= n! / r! * (n-r)
where n represents the number of items,
r = number of items being chosen at a time.
NCr = 30! /4! * (30- 4)
=30! /4! * 26
=30*29*28*27*26! /4*3*2*1*26!
=30*29*28*27 /24
=27405
(b) Three separate digits, chosen from the range of ten digits (0 to 9), are permuted there. No digit
0 can be entered in the left slot. So, any leftover number from 1 to 9 can be filed in the location.
Again, any of the arrangements with 10 digits, ranging from 0 to 9, can occupy the tenth spot.
(c) In lottery there is choose six different numbers between 1 to 50 inclusive. The possible
combination of winning the jackpot-
nCr= n! / r! (n-r)
where n represent the no of item
r = represent the number of item choose at a time

then- = 50! / 6! (50-6)!
=50! / 6*5*4*3*2*1*44!
= 50*49*48*47*46*45*44! /720*44!
=11441304000 /720
=15890700
The possible combination of winning the jackpot is 15890700.
Task 3
(A) Steven receives an electricity bill for £90, which includes a quarterly charge of £15. After
deducting the quarterly charge net bill amount is
= 90 - 15
= £75.
The cost per unit is 6 pence.
The quantity of units Mr. Steve has used is
= 75 / 0.06
= 1250 units.
(B) Information is given about a first time house buyer who can make 360 monthly payments of
£480 each to repay the mortgage amount.
Total mortgage amount = 360 * 480
= £172800.
If the buyer can make only monthly payment of £450, total no. of monthly payments
are required:
= 172800 / 450
= 384.
The buyer can make payment of total mortgage amount of £172800 in 384 monthly payments of
£450 each.
(C) A discount of 20% was offered by a second hand car dealer for a sale of £6400 for immediate
cash sales. So the price offered for immediate cash sales was 80% of the total original sale price.
The original sale price was before the discount = £6400/80%
= £8000.

Task 4
(a) In this question the equation of a line has given and the value of y is 5 as given then the value
of x is calculating:
Y = 5x+8
5 = 5x+8
5-8 = 5x
-3 = 5x
-3/5 = x
The value of x is =-3/5.
(b) (i)
In this question, the graph has given-
If value of y is 2 then value of x is 0, the coordinate of (x1, y1) is (0,2)
If value of x is 2 then value of y is 0 the coordinate of (x2, y2) is (2,0)
gradient =change in value of y/change in value of x
= y2-y1 / x2-x1
= 0-2 / 2-0
= (-2/2)
= (-1)
The gradient is -1 that is negative slope.
4(b)(ii)
The equation of the line in the form of-
Y = mx+c
Now using y=mx+c, solve the value of c using m that is slope g = (-1) and either of two points.
First points (0,2)
2 = -1 * 0+c
2 = 0 + c
2-0 = c
2 = c
second point (2,0)
0 = -1*2+c
0 = -2+c

0+2 = c
2 = c
In both point gets the same answer of c.
4(b)(iii)
If the value of x is 6 then value of y is
m = -1(calculate in above)
c = 2 (calculate in above)
y = mx+c
y = -1*6+2
y = -6+2
y = -4
The value of y is -4.
Task 5
Let x1 and x2 each donate a certain amount of base unit and cabinet unit. The following
describes the linear programming paradigm for the given issue:
Zmax = 5x1+3x2
Subject to: -
0.15x1+0.20x2 = 300 (for production department)
0.40x1+0.30x1 = 600 (for assembly department)
Different combinations of product mix include:
Combination x1 x2 Total Profit (£) Rank
P 1500 0 4500 3
Q 0 2000 10000 1
R 857 857 6856 2

The graphical solution for the problem is given below:
By taking into account the aforementioned chart, it can be concluded that profit will be
higher if the subcontractor solely produces cabinet units.

CONCLUSION
Several tasks are carried out in this report using the provided data and information. The
general mathematics fundamental is used to do these tasks. Additionally, this report contains a
graphical display of the provided data and an algebraic resolution to the issues raised.

REFERENCES
Books and Journals
Abiodun, A.S., Anisi, M.H. and Khan, M.K., 2019. Cloud-based wireless body area networks:
Managing data for better health care. IEEE Consumer Electronics Magazine. 8(3).
pp.55-59.
Collins, V. and Lanz, J., 2019. Managing data as an asset. The CPA Journal. 89(6). pp.22-27.
Halttula, H., Haapasalo, H. and Silvola, R., 2020. Managing data flows in infrastructure projects-
The lifecycle process model. Journal of Information Technology in Construction
(ITcon). 25(12). pp.193-211.
Liu, Q and et.al., 2022. Managing data quality of cooperative information systems: Model and
algorithm. Expert Systems with Applications. 189. p.116074.
Nivedhitha, N. and Vincent, P.D.R., 2019. High-End Tools and Technologies for Managing Data
in the Age of Big Data. In Intelligent Systems (pp. 207-230). Apple Academic Press.