USES ( APPLICATIONS) of spreadsheet are;
1) to create budgets : Excel can be used in creation of budget s which is the estimation of revenue as well as expenses which covers specified future period of time.
2)produce graphs and charts: it's application is helpful in creating graphs in mathematics as well as statistics
3 for storing and sorting data: Data sorting can be done using spreadsheet. It involves arrangements of data into an order in order to make analysis of the data easier.
SPREADSHEET APPLICATION
1)Microsoft Excel : This is used in data
crunching , it can handle large data sets.
2)LibreOffice : it's applicable in Calc for a free as well as native spreadsheet app.
4) Smartsheet: is useful when handling
task involving non-spreadsheet and can be used for project management.
5)Quip : it's useful for integration of
spreadsheets into shared documents.
Answer:
The weighted average unit cost of the inventory at January 31 is $496
Explanation:
Weighted Average unit cost the average cost of units on hand on each day. It is calculated by dividing total inventory value by total available units.
Date Unit Received / Sold On Hand Unit Cost Balance
1/1 Inventory 540 units at $2.80 540 $1,512 $1,512
1/8 Purchased 960 units at $2.3 1500 $2208 $3,720
1/12 Sold 1,300 at ($3,720/1500) 200 $3,224 $496
Answer:
7 years (to the nearest year)
Explanation:
Given that;
A = amount
P= principal
t = time
r = rate
A =3P(given in the question)
Formula for compound interest;
A = P(1 + r)^t
Substituting values;
3P = P(1 + 18/100)^t
3P/P= (1.18)^t
3 = (1.18)^t
log 3 = t log 1.18
t = log 3/log 1.18
t = 0.4771/0.0719
t = 6.6 years
t = 7 years (to the nearest year)
Answer:
$50,400
Explanation:
To do this first start by multiplying .12 x 35,000. The answer should be $4,200. After this multiply 4,200 by 12 in order to get the amount of money earned over a 12 month period. This will give you $50,400.
Answer:
The aftertax salvage value of the machine is D) $10,134
Explanation:
Hi. first, we need to find out the book value of the machine at the selling date, that is 3 years from now, and the book value is as follows.
Since taxes are based on the profit you make by selling something, our profit is:
Therefore, our taxes are:
So, the after tax salvage value of the machine is the money you received on the sale minus the taxes you have to pay, that is:
Salvage Value of the Machine = $12,000 - $1,866?= $10,134
That is option D)
Best of luck.
