Dan D$.$ Vito is the risk manager for a regional chain of grocery stores. A common financial loss for the grocery chain is food spoilage in trucks during shipment. Recognizing that attentive drivers can take steps to prevent food spoilage during transit, the chain has hired $100$ of such attentive drivers to drive trucks containing perishable foods, paying them bonus compensation above competitive wages for this specialty transportation.

Dan is trying to find the best way to handle food spoilage losses. Dan tracks his drivers' annual spoilage losses, revealing that $84\%$ have no losses, $12\%$ have one loss, and $4\%$ have two spoilage losses in a year.

Because he has a limited sample of losses, Dan compares the size of his firm's losses to industry data, concluding his firm is consistent with industry severity data. Dan finds that $70\%$ of his firm's losses can be classified as small $($a loss of $$5000),20\%$ are moderate $($a loss of $$15,000),$ and $10\%$ are large $($a loss of $$25,000).$

A$.$ Develop a convolution table that considers both the frequency of losses incurred by Dan's drivers and the severity of the losses as described above. $($It is recommended to set up the answer in excel so that you can use it in parts B$)$

B$.$ Dan is considering buying food spoilage insurance. The insurer sets its premiums based on the expected loss $($i$.$e$.,$ actuarially fair premium$)$ and has loading percentage equal to $30$ percent of the premium. Because it is a large insurer, the insurer includes the risk charge $($which is minimal$)$ in its loading percentage. To control moral hazard, the insurer requires a $$5000$ deductible $($i$.$e$.,$ Dan$$s firm pays the first $$5000$ of loss and the insurer pays all losses in excess of $$5000)$ that applies per loss. What will the insurer charge Dan?

C$.$ Dan's alternative is to adopt a risk management policy that eliminates the extra bonus compensation paid to a driver who suffers more than $1$ spoilage loss. Based on his familiarity with his drivers, Dan anticipates the modified compensation plan will result in $92\%$ of his drivers having no losses, $6\%$ with one loss and $2\%$ with two losses. Calculate the expected loss for the firm under the revised comp plan.