For the assignment, you will complete all six steps of the Experiential Exercise $($pp$.447-449)$ of your textbook. You will use the Physician Supply Model Forecast Links to an external site. to complete this assignment. You will use workforce data to create a supply model for the physician workforce in the United States. Make sure you download the spreadsheet so your edits don't show up on the shared document linked above. This criterion is linked to a Learning Outcome What would cause FTE to be lower than Headcount? The FTE$/$head count ratio is $0\mathrm{.}6,$ which means that the effective number of physicians delivering care is about $60$ percent of the head count. Why is this important to know? This criterion is linked to a Learning Outcome Do you expect male of female physicians to work more hours on average? What other factors might affect the FTE$/$Headcount ratio? This criterion is linked to a Learning Outcome Using these data and assumptions about attrition and residency supply, populate the residency training pipeline in cells D$46$ through D$63$ with the number of residents completing training in each year. How many residents complete training in $2020?$ Does this forecast seem reasonable to you? How might you improve the forecast? This criterion is linked to a Learning Outcome What happens to the headcount and FTE forecasts if all physicians retire at age $65?$