Scribd
Upload
7 views11 pages

Ticket Sales and Profit Analysis Report

The document contains examples of various business modeling scenarios including ticket sales with 3 salespersons averaging 15 tickets sold per person, a company sales model with inputs like price and cost and outputs like revenues and profits projected over 5 years, and packaging volumes with height, width and depth dimensions. It also includes examples of models for random numbers in a normal distribution, a news vendor problem, game of craps probabilities for single and multiple rolls, and a bidding scenario to determine most profitable bids.

Uploaded by

sathya_454
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
7 views11 pages

Ticket Sales and Profit Analysis Report

The document contains examples of various business modeling scenarios including ticket sales with 3 salespersons averaging 15 tickets sold per person, a company sales model with inputs like price and cost and outputs like revenues and profits projected over 5 years, and packaging volumes with height, width and depth dimensions. It also includes examples of models for random numbers in a normal distribution, a news vendor problem, game of craps probabilities for single and multiple rolls, and a bidding scenario to determine most profitable bids.

Uploaded by

sathya_454
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Ticket Sales

Number of salespersons 3
Avg num tickets sold per person 15
Price per ticket $20.00
Cost per ticket $15.00
Total profit $225.00

$225.00
$16.00
$18.00
$20.00
$22.00
$24.00
$30.00
Company Sales

Inputs Tax Rate 0.4


Year 1 Sales 10000
Sales Growth 0.1
Year 1 Price $9.00
Year 1 Cost $6.00
Interest Rate 0.15
Cost Growth Rate 0.05
Price Growth Rate 0.03

Outputs Year 1 2 3 4
Unit Sales 10000 11000 …
Unit Price $9.00 $9.27
Unit Cost $6.00 $6.30
Revenues $90,000.00 $101,970.00
Costs $60,000.00 $69,300.00
Before Tax Profits $30,000.00 $32,670.00
Tax $12,000.00 $13,068.00
After Tax Profits $18,000.00 $19,602.00

NPV
5
Packaging Volumes
Heights Widths Depths

Random Numbers in Normal Distribution


News Vendor Problem

Inputs Ordering Cost $2.30


Sales Price $4.70
Salvage Value $0.75

Demand Probability Cumulative


150 0.30 0.30
200 0.30 0.60
250 0.40 1.00

Number Ordered
Expected Number Sold
Number Returned

Outputs Costs
Sales Revenue
Salvage Revenue
Profit

Rand Prob for Expected Number


Runs Number Ordered Demand Sold
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

Averages
Random
Probability
0.31

Number Sales Salvage


Returned Costs Revenue Revenue Profit
Game of Craps

Input One Roll


Losing Probability Winning Probability
2 1/36 7 1/6
3 1/18 11 1/18
12 1/36

Multiple Rolls
First Probability Second Probability
4 1/12 2 1/36
5 1/9 3 1/18
6 5/36 4 1/12
8 5/36 5 1/19
9 1/9 6 5/36
10 1/12 7 1/6
8 5/36
9 1/9
10 1/12
11 1/18
12 1/36

Second
First Roll Win Roll Second Roll Third Roll
Output Game Roll Value or Lose Value Win or Lose Value
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

1 Roll 2 Rolls 3 Rolls 4 Rolls 5 Rolls


Number of Wins
Percentage of Games Won
Third Roll Forth Roll Forth Roll Fifth Roll Fifth Roll Win
Win or Lose Value Win or Lose Value or Lose
Bidding

Inputs Cost $12,000.00


Bid

Competitor Bid
1
2
3

Output Profit

Runs Bid Competitor 1 Bid Competitor 2 Bid Competitor 3 Bid Profit


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

Max Profit
Bid for Max Profit
Bid

You might also like