[go: up one dir, main page]
Scribd
Upload
38 views8 pages

Book Analysis

The document presents a detailed analysis of sales predictions based on varying price points, including metrics such as percentage purchased, predicted sales, revenue, and profit. It includes a mathematical model for predicting sales based on price, with a high R² value indicating strong correlation. Additionally, it compares profit at different price points, showcasing potential revenue outcomes.

Uploaded by

Thaddi Srinivas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
38 views8 pages

Book Analysis

The document presents a detailed analysis of sales predictions based on varying price points, including metrics such as percentage purchased, predicted sales, revenue, and profit. It includes a mathematical model for predicting sales based on price, with a high R² value indicating strong correlation. Additionally, it compares profit at different price points, showcasing potential revenue outcomes.

Uploaded by

Thaddi Srinivas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

Price % Purchased Predicted % Predicted Sales Revenue Profit Profit@4.

25
$ 5.00 64.00% 70% 69600 347,998 34799.7939698004 52199.691
$ 6.00 51.00% 49% 49402 296,413 74,103.24 86453.7776
$ 7.00 40.00% 37% 36973 258,812 92,432.77 101676.047
$ 8.00 32.00% 29% 28765 230,118 100,676.74 107867.936
$ 9.00 25.00% 23% 23051 207,461 103,730.60 109493.407
$ 9.61 20.00% 20% 20363 195,762 104,128.89 109219.641
$ 11.00 16.00% 16% 15807 173,878 102,746.11 106697.883
$ 12.00 13.00% 13% 13422 161,061 100,663.22 104018.656
$ 13.00 11.00% 12% 11547 150,107 98,146.70 101033.367
$ 14.00 9.50% 10% 10045 140,630 95,427.42 97938.6662
$ 15.00 8.00% 9% 8823 132,346 92,642.02 94847.7808
$ 16.00 7.00% 8% 7815 125,039 89,871.62 91825.3465
$ 17.00 6.30% 7% 6973 118,543 87,163.83 88907.1091
$ 18.00 5.80% 6% 6263 112,728 84,545.74 86111.403
$ 19.00 5.30% 6% 5657 107,490 82,031.66 83446.0007
$ 20.00 5.00% 5% 5137 102,746 79,627.96 80912.2807
$ 21.00 4.60% 5% 4687 98,428 77,336.04 78507.8012
$ 22.00 4.40% 4% 4295 94,480 75,154.27 76227.9067
$ 23.00 4.20% 4% 3950 90,855 73,079.18 74066.7378
$ 24.00 4.10% 4% 3646 87,515 71,106.25 72017.865
$ 25.00 4.00% 3% 3377 84,427 69,230.41 70074.6861
Profit@4
69599.59
98804.32
110919.3
115059.1 % Purchased
115256.2 70.00%
114310.4 f(x) = 14.1032351920281 x^-1.87447879824148
60.00% R² = 0.992025003787293
110649.7
107374.1 50.00%
103920
100449.9 40.00%
97053.54 30.00%
93779.08
90650.39 20.00%
87677.06
10.00%
84860.34
82196.6 0.00%
$- $5.00 $10.00 $15.00 $20.00 $25.00
79679.56
77301.54
75054.29
72929.48
70918.96
hased

1 x^-1.87447879824148
3

5.00 $20.00 $25.00 $30.00


% Purchased
70.00%
f(x) = 14.1032351920281 x^-1.87447879824148
60.00% R² = 0.992025003787293

50.00%

40.00%

30.00%

20.00%

10.00%

0.00%
$- $5.00 $10.00 $15.00 $20.00 $25.00 $3
ed

.87447879824148

$20.00 $25.00 $30.00


% Purchased
70.00%

60.00%

50.00%

40.00%

30.00%

20.00%

10.00%

0.00%
$- $5.00 $10.00 $15.00 $20.00 $25.00 $30.00
% Purchased
70.00%

60.00%

50.00%

40.00%

30.00%

20.00%

10.00%

0.00%
$- $5.00 $10.00 $15.00 $20.00 $25.00 $30.00
Price % Purchased Predicted % Predicted Sales Revenue Profit Profit @4.25 Profit@ 4.00
$ 9.61 64% 20% 20,363 195,762 104,128.89

$ 7.82 51% 30% 30,000 234,692 107,192.06

$ 5.96 40% 50% 50,000 298,087 98,086.62

You might also like