Answer:
7.76%
Explanation:
In this question, we use the PMT formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Present value = $969
Future value = $1,000
Rate of interest = 8.1%
NPER = 17 years
The formula is shown below:
= PMT(Rate;NPER;-PV;FV;type)
The present value come in negative
So, after solving this, The PMT would be $77.58
The coupon rate is shown below:
= (Coupon payment ÷ par value) × 100
= ($77.58 ÷ $1,000) × 100
= 7.76%
Answer:
The optimal production plan gives a total costs of $417,672 for the periods Feb to May
In Feb we will have to hire 26 workers to close the gap between demand and production from our 100 existing workers
In March however, we will have to lay them off (26 workers) to keep our production in line with demand.
In April, we are constrained to 100 workers, thus requiring that we run overtime. The overtime requirement is between 3,060 hours to max of 5,000 hours. Note that inspire of the hours chosen, demand for April still won't be fulfilled.
The best option will be the one that gives us last backlog because of the costs of backorder being extremely costly.
5,000 overtime hours in April is the best option .
In May, we are constrained to our 100 workers, meaning we will fulfill our back orders and also retain inventory in hand of 7,760 units.
The 3 pages attached show how the cost is worked out and the presentation as well.
