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.