Simulation Questions Harvard Case Solution & Analysis

Simulation Questions Case Study Analysis

In addition to this, if the outsourcing increases by 1000 and further 1000 up to the maximum of 5000, then the point where the profits maximize, is the outsourcing cases of 3000 from the external suppliers, which gives the maximum profits of 12461 dollars as shown in following  table:

Table 2:

Average Profits (2000)           12,066
Average Profits (3000)           12,461
Average Profits (4000)           12,280
Average Profits (5000)           11,819

Part 2:

By using the linear programing method in excel; the advertisement fund of 100,000dollars need to be allocated in four markets, in order to maximize the sales revenue, which are as follows:

Table 1:

Markets Adv. Dollars
Domestic 16,000
Premium 27,000
Light 9,000
Microbrew 48,000

If the distributor adds additional 1000 dollar funds in the advertisement budget, then the advertisement dollars 101,000 funds that need to be allocated in four markets to maximize the sales revenue, are as follows:

Table 2:

Markets Adv. Dollars
Domestic 16,000
Premium 27,000
Light 9,000
Microbrew 49,000

Part 3:

After creating the spreadsheet that replicates 500 outcomes; the average revenue amount is 8782 dollars, while the probability that generates the total sales more than 10000 dollars to get the 5000 bonus, is 31.6%. In addition to this, as shown in the below mentioned table; the total average revenue is 8782 dollars, which is lower than 10000 dollars to get 5000 bonus, so the restaurant owner will not be willing to spend money on sales incentives in the form of sales discount, to get more customers to earn the bonus amount.

Table 1:

Average Revenue 8,782
Number of Cases in Which the Revenue will >10000 158
Probability 31.60%

..............................

 

This is just a sample partical work. Please place the order on the website to get your own originally done case solution.

Share This

SALE SALE

Save Up To

30%

IN ONLINE CASE STUDY

FOR FREE CASES AND PROJECTS INCLUDING EXCITING DEALS PLEASE REGISTER YOURSELF !!

Register now and save up to 30%.