Standard Reference Lottery
1 (a) The standard reference lottery is the method of predicting probabilities of happening or not happening something in the gamble games. This method of probability prediction is mainly used for the purpose of assessing and finding out the preferences between the intermediate choices. The example of standard reference lottery is depicted in the chart given below (Sox, 1988):
Figure 1: Example of Standard Reference Lottery (Sox, 1988)
1 (b) The marginal analysis is a managerial tool used for the long term as well as day to day decisions. The marginal analysis takes only the relevant information into account and for this reason it is considered to be most appropriate and efficient managerial tool (Armstrong, 2006). The analysis of cost and benefits is based in the additional information which reduces the burden of analyzing large data and also simplifies the decision making process apart from making it more relevant. However, there are certain disadvantages of using the marginal analysis also. For instance, the marginal analysis does not provide standard format of reporting, thus, the results of the analysis can not be used for reporting purpose. Further, overall picture of profitability is also not presented by the marginal analysis (Armstrong, 2006).
1 (c-1) The optimist believes that the market conditions would be favorable to them and hence, it would take a view that the demand of X-120 will increase in the coming year. The highest profit is given under the alternative of new equipment of $240,000; therefore, the optimist would go for hiring new equipment.
1 (c-2) The pessimist believes that the market conditions would be unfavorable to them and hence, it would be anticipated that the demand will decrease in the coming year. In this case, optimist would chose overtime alternative with the net profit of $100,000. However, operating at the current level will also yield the same amount of profits, but if the prediction of the pessimist does not go right i.e. if the demand increases, then overtime option will dominate the current level operations.
1 (c-3) According to the Maximax criterion of regret, the new equipment having maximum output (net profit of $240,000) would be marked for selection.
1 (c-4)
Decrease in Demand |
Probability |
Product |
Increase in Demand |
Probability |
Product |
Expected monitory value |
|
New equipment |
$60,000 |
0.40 |
24,000.00 |
$240,000 |
0.60 |
144,000.00 |
120,000.00 |
Overtime |
$100,000 |
0.40 |
40,000.00 |
$220,000 |
0.60 |
132,000.00 |
92,000.00 |
Current level |
$100,000 |
0.40 |
40,000.00 |
$140,000 |
0.60 |
84,000.00 |
44,000.00 |
The expected monitory value of is highest in the case of new equipment, therefore, the preferable alternative will be hiring of new equipment.
1 (c-5) According to the decision making theory, the expected value of the perfect information is the price that one is willing to pay to get the perfect information. Further, in computing the expected value of perfect information, the consideration can also be given to the loss that may be caused due to unavailability of the perfect information (Drury, 2008).
Marginal Analysis
2 (a) The medical professionals should go for construction of the private clinic as the net benefits will be $120,000 as shown in the table given below:
Scenario |
Market favorable |
Market not favorable |
Net benefit |
Net profit |
400,000.00 |
(160,000.00) |
|
Probability |
0.50 |
0.50 |
|
Expected value |
200,000.00 |
(80,000.00) |
120,000.00 |
2 (b) The revised probabilities are as under:
Favourable study- favourable market = 0.90
Favourable study- unfavourable market = 0.10
Unfavourable study- favourable market = 0.30
Unfavourable study- unfavourable market = 0.70
2 (c) The posterior probability of a favourable market will be 0.45 (0.50*0.90).
2 (d)
Favorable -study |
Unfavorable -study |
||||
Favorable |
Unfavorable |
Favorable |
Unfavorable |
||
old probability |
0.5 |
0.5 |
0.5 |
0.5 |
|
New probability |
0.9 |
0.1 |
0.3 |
0.7 |
|
Joint probability |
0.45 |
0.05 |
0.15 |
0.35 |
|
Profit/Loss |
400,000.00 |
(160,000.00) |
400,000.00 |
(160,000.00) |
|
Profit/Loss* Joint probability |
180,000.00 |
(8,000.00) |
60,000.00 |
(56,000.00) |
176,000.00 |
When the consultant was not engaged, the net benefits were amounting to $120,000; however, after engaging the consultant, the net benefits are estimated to be $171,000 ($176,000-5,000). Therefore, considering the increase in estimated net benefits, it could be advised that the consultant should be engaged.
3 (a)
Initial Conditions |
|
Assumptions |
||
Number of covered employees |
18,533 |
Increasing |
2% |
per month |
Average claim per employee |
$250 |
Increasing |
1% |
per month |
Sum contributed per employee |
$125 |
Constant |
3 (b)
Month |
Number of employees |
Employee contributions |
Average claim per employee |
Total claims |
Company cost |
1 |
18,904 |
2,362,957.50 |
252.50 |
4773174.2 |
2,410,216.65 |
2 |
19,282 |
2,410,216.65 |
255.03 |
4917324 |
2,507,107.36 |
3 |
19,667 |
2,458,420.98 |
257.58 |
5065827.2 |
2,607,406.21 |
4 |
20,061 |
2,507,589.40 |
260.15 |
5218815.2 |
2,711,225.77 |
5 |
20,462 |
2,557,741.19 |
262.75 |
5376423.4 |
2,818,682.20 |
6 |
20,871 |
2,608,896.01 |
265.38 |
5538791.4 |
2,929,895.37 |
7 |
21,289 |
2,661,073.93 |
268.03 |
5706062.9 |
3,044,988.95 |
8 |
21,714 |
2,714,295.41 |
270.71 |
5878386 |
3,164,090.57 |
9 |
22,149 |
2,768,581.32 |
273.42 |
6055913.2 |
3,287,331.91 |
10 |
22,592 |
2,823,952.95 |
276.16 |
6238801.8 |
3,414,848.87 |
11 |
23,043 |
2,880,432.01 |
278.92 |
6427213.6 |
3,546,781.62 |
12 |
23,504 |
2,938,040.65 |
281.71 |
6621315.5 |
3,683,274.83 |
Formula View with Row and Column Headings
3 (c)
Initial Conditions |
|
Assumptions |
||
Number of covered employees |
18,533 |
Increasing |
2% |
per month |
Average claim per employee |
$250 |
Increasing |
3% |
per month |
Sum contributed per employee |
$200 |
Constant |
Month |
Number of employees |
Employee contributions |
Average claim per employee |
Total claims |
Company cost |
1 |
18,904 |
3,780,732.00 |
257.50 |
4867692.45 |
1,086,960.45 |
2 |
19,282 |
3,856,346.64 |
265.23 |
5113997.688 |
1,257,651.05 |
3 |
19,667 |
3,933,473.57 |
273.18 |
5372765.971 |
1,439,292.40 |
4 |
20,061 |
4,012,143.04 |
281.38 |
5644627.929 |
1,632,484.88 |
5 |
20,462 |
4,092,385.91 |
289.82 |
5930246.102 |
1,837,860.20 |
6 |
20,871 |
4,174,233.62 |
298.51 |
6230316.555 |
2,056,082.93 |
7 |
21,289 |
4,257,718.30 |
307.47 |
6545570.573 |
2,287,852.28 |
8 |
21,714 |
4,342,872.66 |
316.69 |
6876776.444 |
2,533,903.78 |
9 |
22,149 |
4,429,730.11 |
326.19 |
7224741.332 |
2,795,011.22 |
10 |
22,592 |
4,518,324.72 |
335.98 |
7590313.243 |
3,071,988.53 |
11 |
23,043 |
4,608,691.21 |
346.06 |
7974383.093 |
3,365,691.88 |
12 |
23,504 |
4,700,865.04 |
356.44 |
8377886.878 |
3,677,021.84 |
Formula View with Row and Column Headings
The total cost to be incurred by the company towards the healthcare claims under the assumption taken in the original model is arrived at $3,683,275. However, it is anticipated that the cost of claims could increase on monthly basis at the rate of 3% instead of 2%. The increase in claim cost would however be compensated by the simultaneous increase in the employees contribution. It is expected that the employee’s contribution will be increased from $125 to $200 per month. The total employee contribution will increase significantly to $4,700,865.04 from existing $2,938,040.65. Further, the increase in total claim is observed to be $1,756,571.40 ($8,377,886.88-$6,621,315). The increase in employee contribution has been more than the increase in total claims. Resultantly, the company cost has gone down from $3,683,274.83 to $3,677,021.84.
4 (a) Results of Regression of Wages against Score:
Summary output |
||||||||
Regression Statistics |
||||||||
Multiple R |
0.87013 |
|||||||
R Square |
0.75712 |
|||||||
Adjusted R Square |
0.74363 |
|||||||
Standard Error |
73.4525 |
|||||||
Observations |
20 |
|||||||
ANOVA |
||||||||
df |
SS |
MS |
F |
Significance F |
||||
Regression |
1 |
302734 |
302734 |
56.111 |
6.2E-07 |
|||
Residual |
18 |
97114.81 |
5395.27 |
|||||
Total |
19 |
399848.8 |
||||||
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
|
Intercept |
176.4 |
104.4931 |
1.68815 |
0.10863 |
-43.132 |
395.932 |
-43.132 |
395.932 |
X Variable 1 |
25.64 |
3.422694 |
7.49073 |
6.2E-07 |
18.4477 |
32.8293 |
18.4477 |
32.8293 |
Residual output |
||||||||
Observation |
Predicted Y |
Residuals |
||||||
1 |
1125 |
-41.0236 |
||||||
2 |
919.9 |
12.08425 |
||||||
3 |
791.7 |
60.27663 |
||||||
4 |
996.8 |
-28.8312 |
||||||
5 |
1099 |
-55.3851 |
||||||
6 |
868.6 |
-76.6388 |
||||||
7 |
971.2 |
-59.1927 |
||||||
8 |
740.4 |
79.55358 |
||||||
9 |
1151 |
141.338 |
||||||
10 |
714.8 |
9.192053 |
||||||
11 |
945.6 |
-45.5542 |
||||||
12 |
1048 |
143.8919 |
||||||
13 |
894.3 |
-58.2773 |
||||||
14 |
817.4 |
-17.3618 |
||||||
15 |
1022 |
89.53034 |
||||||
16 |
1074 |
6.253393 |
||||||
17 |
919.9 |
-27.9158 |
||||||
18 |
1048 |
-124.108 |
||||||
19 |
996.8 |
-28.8312 |
||||||
20 |
843 |
20.99967 |
Results of Regression of Wages against years of experience
Summary output |
||||||||
Regression Statistics |
||||||||
Multiple R |
0.46539 |
|||||||
R Square |
0.21659 |
|||||||
Adjusted R Square |
0.17307 |
|||||||
Standard Error |
131.919 |
|||||||
Observations |
20 |
|||||||
ANOVA |
||||||||
df |
SS |
MS |
F |
Significance F |
||||
Regression |
1 |
86602.96 |
86603 |
4.97645 |
0.03866 |
|||
Residual |
18 |
313245.8 |
17402.5 |
|||||
Total |
19 |
399848.8 |
||||||
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
|
Intercept |
870.1 |
46.19514 |
18.8352 |
2.7E-13 |
773.041 |
967.146 |
773.041 |
967.146 |
X Variable 1 |
54.69 |
24.51784 |
2.2308 |
0.03866 |
3.18424 |
106.204 |
3.18424 |
106.204 |
Residual output |
||||||||
Observation |
Predicted Y |
Residuals |
||||||
1 |
870.1 |
213.9067 |
||||||
2 |
924.8 |
7.212435 |
||||||
3 |
979.5 |
-127.482 |
||||||
4 |
924.8 |
43.21244 |
||||||
5 |
924.8 |
119.2124 |
||||||
6 |
870.1 |
-78.0933 |
||||||
7 |
870.1 |
41.90674 |
||||||
8 |
979.5 |
-159.482 |
||||||
9 |
1034 |
257.8238 |
||||||
10 |
924.8 |
-200.788 |
||||||
11 |
1034 |
-134.176 |
||||||
12 |
1144 |
48.43523 |
||||||
13 |
870.1 |
-34.0933 |
||||||
14 |
924.8 |
-124.788 |
||||||
15 |
979.5 |
132.5181 |
||||||
16 |
924.8 |
155.2124 |
||||||
17 |
979.5 |
-87.4819 |
||||||
18 |
979.5 |
-55.4819 |
||||||
19 |
924.8 |
43.21244 |
||||||
20 |
924.8 |
-60.7876 |
Results of Regression of Wages against score and years of experience
Cost Equation for Regressions Presented above:
S. No. |
Type of Regression |
Cost Equation |
1. |
Regression of Wages against Score |
Wages (y)= a+b(Score)*x+R2 Y= 176.40+25.64*x+73.45 |
2. |
Regression of Wages against Years of Experience |
Wages (y)= a+b(years)*x+R2 Y= 870.10+54.69*x+131.92 |
3. |
Regression of Wages against Score and Years of Experience |
Wages (y)= a+b1(Score)*x1+ b2(years)*x2+R2 Y= 170.10+24*X1+38.40*X2+57.22 |
In the first regression, the dependent variable wages has been tested against the independent variable score. The results of this regression depicts that the intercept (a) is 176.40 while beta (b) for independent variable (score) is 25.64 and standard error is 73.45. Further, the second regression has been conducted with the dependent variable wages and independent variable number of years. The results of this regression show that the intercept is 870.10, beta is 54.69, and standard error is 131.92. Further, the third regression has been conducted with the dependent variable wages and independent variables such as score and years. The results of this analysis show that intercept is 170.10, beta for variable-1 (score) is 24 and beta for variable-2 (years) is 38.40 and standard error is 57.22. It could be observed that the standard error is lowest in case the third case which shows that these results are the most reliable. Further, the R squared has been observed to be 0.76, 0.22, and 0.86 in the case-1, 2, and 3 respectively. The highest R square in the case-3 again shows that the results of Multiple Variable regression are the most reliable (Albright, Winston, & Zappe, 2010).
The Multiple Variable regression is improvement over the single variable regression model (Woolson & Clarke, 2011). The Multiple Variable regression model takes two or more factors into account while conducting regression analysis. Since, multiple factors are taken into consideration, therefore, this model is considered superior for use in the estimations and predictions (Woolson & Clarke, 2011).
4 (b) In case the results of single regression are used, it would be preferable to use regression of wages against score. The R squared of this regression is 0.76, higher than the R squared of regression of wages with years of experience of 0.22. The R squared explains the proximity of the data of independent and dependent variable. In other words, it explains how closely the outcome of dependent variable is linked to the independent variable (Elliott & Woodwar, 2014).
4 (c) The intercept of Multiple Variable regression is 170.10, which is lower than the intercepts of the single variable regressions. Further, the Multiple Variable regression provides two beta values that is one for each independent variable. The beta values computed in the Multiple Variable regression are lower than the beta values computed individually for both the independent variables. In Multiple Variable regression, the beta value for independent variable-1 is 24 and for the independent variable-2 it is 38.40. However, the beta values in case of individual regressions have been observed to be 25.64 for variable-1 and 54.69 for variable-2.
4 (d)
a (intercept) |
170.1 |
b (beta)-Score |
24 |
b (beta)-Year |
38.4 |
x Variable-Score |
30 |
x Variable-Year |
2 |
Standard error |
57.22 |
y (wages) [$170.10*(24*30+38.40*2)+57.22] |
1024 |
As per the Multiple Variable regression, the wages of the trainee who scores 30 and possesses 2 years of experience will be $1,024.
5 (a)
Product |
A |
B |
Sales price per unit |
$10 |
$18 |
Less: Variable cost per unit |
$4 |
$9 |
Unit contribution margin |
$6 |
$9 |
5 (b)
A. Fixed cost |
148500 |
B. Unit contribution margin product-A |
$6 |
C. Breakeven units of product-A (A/B) |
24,750 |
5 (c)
A. Fixed cost |
148500 |
B. Contribution margin ratio product-A |
60% |
C. Breakeven dollars of product-A (A/B) |
247,500 |
5 (d-i)
Product |
A |
B |
Sales price per unit |
$10 |
$18 |
Less: Variable cost per unit |
$4 |
$9 |
Unit contribution margin |
$6 |
$9 |
Production Ratio |
0.75 |
0.25 |
Combined unit contribution |
$6.75 |
|
Combined contribution ratio |
58% |
i) Units to earn $87,750 before tax |
|
A. Fixed cost |
148500 |
B. Desired profit before tax |
87750 |
C. Total |
236250 |
D. Combined unit contribution |
$6.75 |
E. Total units required (C/D) |
35,000 |
Product-A (35000*0.75) |
26,250.00 |
Product-B (35000*0.25) |
8,750.00 |
5 (d-ii)
ii) Units to earn $105,000 after tax |
|
A. Fixed cost |
120000 |
B. Desired profit before tax (105000/70%) |
150000 |
C. Total |
270000 |
D. Combined unit contribution |
$6.75 |
E. Total units required (C/D) |
40,000 |
Product-A (35000*0.75) |
30,000.00 |
Product-B (35000*0.25) |
10,000.00 |
References
Albright, S.C., Winston, W., & Zappe, C. 2010. Data Analysis and Decision Making. Cengage Learning.
Armstrong, M. 2006. A Handbook of Management Techniques: A Comprehensive Guide to Achieving Managerial Excellence & Improved Decision Making. Kogan Page Publishers.
Drury, C. 2008. Management and Cost Accounting. Cengage Learning EMEA.
Elliott, A.C., & Woodwar, W.A. 2014. IBM SPSS by Example: A Practical Guide to Statistical Data Analysis. SAGE Publications.
Sox, H.C. 1988. Medical Decision Making. ACP Press.
Woolson, R.F. & Clarke, W.R. 2011. Statistical Methods for the Analysis of Biomedical Data. John Wiley & Sons.