MBA Assignment: Supply Chain -- 2
Budget: $30 – $250 USD
The word count limit: 2400 words
Deadline: 15 June 2022
Title : A Strategic Review of Hospital Capacity
Assessment Context
Waterside Hospital Trust (WHT) provides in-patient services to a medium-sized town. During the recent pandemic, the Trust’s general wards were converted to accommodate pandemic patients only. Routine patients were instead treated by a local private healthcare company, Nene Valley Health (NVH), under emergency arrangements that allowed public hospitals such as WHT to secure additional capacity.
WHT was grateful for the additional capacity provided by NVH during the first part of last year, but frankly did not need it.
The patients admitted at that time were generally younger individuals who recovered quickly. The same could not be said of the winter months, when the patients tended to be more elderly. Once the rate of admissions rose above 250 per week, the additional capacity filled up rapidly.
NVH has indicated that it is prepared to make capacity available to WHT for the coming year, providing guarantees can be given that the capacity will be needed. [Images of empty wards at NVH caused some negative publicity at the time].
Forecasts for the next wave of the pandemic have recently been released by the Public Health Authority. These forecasts estimate the range of New Cases in the Community (NCC) within 95% confidence limits (the upper and lower bounds).
The Assessment Task
You are to use the supplied historic data and forecasts to inform WHT’s decision whether or not to retain additional capacity at NVH.
1. Plot the historic data and provide an estimate of the lag between New Cases in the Community (NCC) and Hospital Admissions (HA).
2. Provide an estimate of the mathematical relationship between NCC and HA (a) in the Summer and (b) in the Winter.
3. Use the supplied Lower Bound and Upper Bound growth rate forecasts to derive the forecast of New Cases in the Community for the coming year.
4. Apply your formula derived in (2) to generate an Admissions forecast for the coming year, within Upper and Lower Bounds.
5. What advice would you offer Waterside Hospital Trust regarding their capacity arrangement with Nene Valley Health?
Deadline: 15 June 2022
Title : A Strategic Review of Hospital Capacity
Assessment Context
Waterside Hospital Trust (WHT) provides in-patient services to a medium-sized town. During the recent pandemic, the Trust’s general wards were converted to accommodate pandemic patients only. Routine patients were instead treated by a local private healthcare company, Nene Valley Health (NVH), under emergency arrangements that allowed public hospitals such as WHT to secure additional capacity.
WHT was grateful for the additional capacity provided by NVH during the first part of last year, but frankly did not need it.
The patients admitted at that time were generally younger individuals who recovered quickly. The same could not be said of the winter months, when the patients tended to be more elderly. Once the rate of admissions rose above 250 per week, the additional capacity filled up rapidly.
NVH has indicated that it is prepared to make capacity available to WHT for the coming year, providing guarantees can be given that the capacity will be needed. [Images of empty wards at NVH caused some negative publicity at the time].
Forecasts for the next wave of the pandemic have recently been released by the Public Health Authority. These forecasts estimate the range of New Cases in the Community (NCC) within 95% confidence limits (the upper and lower bounds).
The Assessment Task
You are to use the supplied historic data and forecasts to inform WHT’s decision whether or not to retain additional capacity at NVH.
1. Plot the historic data and provide an estimate of the lag between New Cases in the Community (NCC) and Hospital Admissions (HA).
2. Provide an estimate of the mathematical relationship between NCC and HA (a) in the Summer and (b) in the Winter.
3. Use the supplied Lower Bound and Upper Bound growth rate forecasts to derive the forecast of New Cases in the Community for the coming year.
4. Apply your formula derived in (2) to generate an Admissions forecast for the coming year, within Upper and Lower Bounds.
5. What advice would you offer Waterside Hospital Trust regarding their capacity arrangement with Nene Valley Health?
Related categories:
Accounting
Health & Medicine
Research Writing
Business Analysis
Business Writing