Millie, age 80, is supported during the current year as follows: Percent of Support Weston (a son) 20% Faith (a daughter) 35% Ja
1 answer:
You might be interested in
Answer:
The solution is given below.
Explanation:
It is a practical, complex scheduling problem that can be easily modelled and solved as IP. Note that part time and full time employees are paid at different rates. So, it is important that the bank operates to provide required service level (indicated by the number of tellers per hour) while minimizing total cost due to staff salary.
We use x as full time and y as part time staff.
It would help if you construct a table as shown below to better analyze the problem before attempting to model it. Red shows work hrs of full time staff and green is for part timers. Just follow their work hour rules.
So, full timers have 3 options:
(i) start at 9 – work till 1pm, take 1 hr break, then work 2 – 5 pm
(ii) start at 10 – work till 2pm, take 1 hr break, then work 3 – 6 pm
(iii) start at 11 – work till 3pm, take 1 hr break, then work 4 – 7 pm
that’s all… bank closes at 7 pm.
However, part timers don’t have 1 hr break. They work straight 4 hrs and leave. See green cells above to understand their alternatives.
Now, decision variables should include this work hour information. Here goes their definition. You must clearly define decision variables in exam, otherwise, the model is meaningless.
X9 = number of full time staff who start at 9 and follow the hour-related rule (no need to specify more details; those are already undestood)
X10 = number of full time staff who start at 10 and follow the hour-related rule
X11 = number of full time staff who start at 11 and follow the hour-related rule
Y9 = number of part time staff who start at 9 and follow the hour-related rule
Y10 = number of part time staff who start at 10 and follow the hour-related rule
…. This way you define up to Y15.
You must also specify that:
Xi, Yi >=0, integers.
Objective Function:
Minimize Z = 105*(x9 + x10 + x11) + 32* (y9 + y10 + … + y 15)
You will need one “covering” constraint for each working hour. Both full and part-timers can “cover” the duty of each hour. Look at the color-coded table (above) column-wise. The 9:00-10:00 hour can be covered only by x9 and y9 staff; next hour by x9, x10, y9, y10 only,… and so on. So, the
constraints are: (attached with image)
Answer:
NPV with a 14.9% discount rate: 6,329.06
The toy should be produced as the NPV is positive.
IRR = 26.65%
Explanation:
First we calculate for the NPV using the given discount rate of 14.9%
We will calculate the present value of each year cash inflow:
Year 1 cash inflow: 47,500.00
time 1.00
rate 0.149
PV 41,340.30
Year 2 cash inflow: 18,600.00
time 2.00
rate 0.149
PV 14,088.76
Then, we add them and subtract the investment to get NPV
NPV = 14,088.76 + 41,340.3 - 49,100 = 6,329.06
The toy should be produced as the NPV is positive.
Now for the IRR
That is the rate at which NPV equals zero we can solve for this using the quadratic equation as there are only two cash flow:
Year 1 will discount at (1+IRR)
Year 2 will be discount at (1+IRR )^2
So we can express and recreate the quadratic formula:
18,600 X^2 + 47,500 X - 49,500 = 0
A = 18,600
B = 47,500
C = -49,100
We can solve and get:
x1 = 0.78957
x2 = -3.3433
We take the positive value.
and now solve for IRR
IRR = 0,2665121 = 26.65%
This will be the IRR for the project.