Answer:
What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. The following example helps you master what-if analysis quickly and easily.
Assume you own a book store and have 100 books in storage. You sell a certain % for the highest price of $50 and a certain % for the lower price of $20.
(i really hope this is what u needed)
Answer:
Total unit of work required is 1019 units.
Solution:
As per the question:
Initial capacity = 100
On each expansion 50 is added to the present capacity.
Now,
Work done required in addition of 1000 items = 1000 unit
No. of times there is a need for the allocation of a new Array is given by:
We know that:
On addition of 101th element it expands from 100 to 150
On addition of 151st element it expands from 150 to 200 and so on till
On addition of 951st element it expands from 950 to 1000
Now,
For an array of 100 size - 1 for initial allocation.
Therefore, total work done is given by:
W =