Scribd
Upload
5 views8 pages

NTPC Unchahar Dining Performance Report

This document contains the results of several simulations run to optimize the operations of a restaurant. It tests different combinations of variables including bar size, batch size, dining times, and advertising. The highest profit of $566.50 was achieved with a bar size of 71, batch size of 8/8/4-8, dining times of 45/45/75 minutes, and advertising at 1.5 times normal from 5-6PM.

Uploaded by

Sougat Tiwari
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
5 views8 pages

NTPC Unchahar Dining Performance Report

This document contains the results of several simulations run to optimize the operations of a restaurant. It tests different combinations of variables including bar size, batch size, dining times, and advertising. The highest profit of $566.50 was achieved with a bar size of 71, batch size of 8/8/4-8, dining times of 45/45/75 minutes, and advertising at 1.5 times normal from 5-6PM.

Uploaded by

Sougat Tiwari
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

RUN NO. BAR SIZE RESTAURANT SIZE PROFIT LOST CUSTOMERS AVG. WAIT TIME AVG.

DINING TIME
1 79 11 196.32 33 38 74.4
2 79 11 139.48 2 5.95 76.28
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
AVG. UTILIZATION % AVG. CUSTOMERS
71.5 63
50.66 56.7 45 45 75
BATCH DECISION BAR DECISION

Batch: 8/8/4-8 Bar: 79/11


Batch: 8/8/4-8 Bar: 79/11Dining time:45/45/75Adv: 1.5x/HH/5PM
DINING TIME DECISION ADVERTISING DECISION

Dining time:45/45/75 Adv: 1.5x/HH/5PM


BATCH DECISION BAR DECISION DINING TIME DECISION
Batch: 8/8/4-8 Bar: 79/11 Dining time:45/45/75
PROFIT 547.66
LOST CUSTOMERS 11
AVG. WAIT TIME 30.5
AVG. DINING TIME 88.5
AVG. UTILIZATION % 66.3
AVG. CUSTOMERS 58.3
ADVERTISING DECISION BATCH DECISION BAR DECISION DINING TIME DECISION
Adv: 1.5x/HH/5PM Batch: 8/8/4-8 Bar: 63/13 Dining time:45/45/75
555.09
3
11.16
82.8
55
57.2
ADVERTISING DECISION BATCH DECISION BAR DECISION DINING TIME DECISION
Adv: 1.5x/HH/5PM Batch: 8/8/4-8 Bar: 71/12 Dining time:45/45/75
566.5
4
22.65
86.28
60.5
58.1
ADVERTISING DECISION
Adv: 1.5x/HH/5PM

You might also like