[go: up one dir, main page]
Scribd
Upload
61 views2 pages

Optional Problem (Text Messaging Plan)

The document outlines a text message plan with details on usage, costs, and financial implications for prepaid and extra unpaid messages. It includes statistical data from a simulation, showing mean costs, standard deviation, and probabilities related to cost outcomes. The total cost for the prepaid messages used in the first period is $600.00.

Uploaded by

Rushil Surapaneni
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
61 views2 pages

Optional Problem (Text Messaging Plan)

The document outlines a text message plan with details on usage, costs, and financial implications for prepaid and extra unpaid messages. It includes statistical data from a simulation, showing mean costs, standard deviation, and probabilities related to cost outcomes. The total cost for the prepaid messages used in the first period is $600.00.

Uploaded by

Rushil Surapaneni
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/ 2

A B C D E

1 Text Message Plan


2
3 Period 1
4 Normal Mean 6,000
5 Usage Standard Deviation 1,000
6 Per Unit Cost for Prepaid Message $0.10
7 Financial Cost for Extra Unpaid Message $0.30
8 Data Refund for Unnecessary Prepaid Message $0.00
9 Given Info Computations
10 Period 1
11 Prepaid Messages (Beginning Inventory) 6,000
12 Message Usage (Demand) 5,804.482
13 Rounded Message Usage (Rounded Demand) 5,804
14 Prepaid Messages Used (Sales) 5,804
15 Extra Unpaid Messages (Unsatisfied Demand) 0
16 Unnecessary Prepaid Messages (Ending Inventory) 196
17
18 Cost for Prepaid Messages $600.00
19 Total Cost for Extra Unpaid Messages $0.00
Financial
20 Data Refund for Unnecessary Prepaid Messages $0.00
21 Total Cost $600.00
22
23 CUSTOMIZED SIMULATION RESULTS
24 Prepaid Messages Q 6000
25 Simulation # 1
26 Mean $719.68
27 Std Dev $175.16
28 Maximum $1,984.20
29 Cost Minimum $600.00
30 Downside Potential: Pr{Cost $700} 0.63062
31 Upside Risk: Pr{Cost > $1000} 0.09120
32 95-th Percentile $1,093.50
33
34 CUSTOMIZED SIMULATION RESULTS (pasted after simulation)
35 Prepaid Messages Q 6000
36 Simulation # 1
37 Mean $719.68
38 Std Dev $175.15
39 Maximum $1,927.20
40 Cost Minimum $600.00
41 Downside Potential: Pr{Cost $700} 0.63062
42 Upside Risk: Pr{Cost > $1000} 0.09118
43 95-th Percentile $1,093.50

You might also like