After reviewing your request, Cougar Consulting performed an analysis to assist Lorex Pharmaceuticals in determining a target fill rate for Linatol. The target fill that we selected is intended to maximize expected contribution during the manufacturing process and was based on information contained in a report given to Cougar Consulting. The analysis that we performed is described in further detail.
Even though the automatic filling mechanism used for production can be set to a specific target fill, the information we obtained about Linatol suggested inconsistencies in the fill amount during operations. Since revenues and specific variable costs of Linatol are directly affected by fill amounts and contribution is the difference of these costs subtracted from revenue, ultimately, contribution is affected by the inconsistent fill amounts. Once we establish how these revenues and costs are affected by the fill amounts, we need to determine how the filling mechanism will function when set at a specific target fill. These understandings will give us the information required to figure a target fill that maximizes contribution for Linatol.
Before we established a method to determine how the filling mechanism functioned at a specific target fill, we had to consider how the target fill affected the revenues and the variable costs when calculating contribution. Starting with revenue, we learned from the report that the bottles filled at or above 10 ounces would sell on the commercial market for $186 per case. On the other hand, bottles filled below the advertised 10 ounces would be sold for government use at $148.80 per case and are referred to as “seconds.” From this information, we created a formula (Figure 1) that calculated the revenue per case as a weighted average. The relationship between revenue and target fill is shown graphically in Attachment 1
Revenue = (% commercial) $186/case + (% seconds) $148.80/case
As previously mentioned, calculating contribution for Linatol consists of subtracting specific variable costs from revenue. The variable costs related to target fill were found in the Projected Operating Profit exhibit provided to Cougar Consulting. The first cost we determined for calculating contribution was the blending direct labor and active ingredients. To use this cost in calculating contribution, we divided the sum of these two costs by the total batch volume. The rounded cost of this calculation equaled $0.4027 per ounce, and its positive linear relation to the fill amount is graphically shown in Attachment 2. In other words, the cost increases per unit as the fill amount increases per unit.
Another cost needed to calculate expected contribution consisted of an additional cost associated from the number of seconds produced by the automatic filling mechanism. This additional cost is a result from the special packaging required by seconds and is figured from dividing the labor rate by the number of cases the laborer can package in an hour. This cost equals $0.7083 per case and diminishes as the fill amounts increase because a higher target fill results in less seconds produced. This relationship is shown as a graph in Attachment 3.
Since the cost associated for all cases is calculated in ounces, this unit was changed to cases by multiplying the cost by 12 bottles per case and a target fill amount in ounces per bottle. The additional cost per case from packaging seconds was figured by multiplying this cost by the probability of seconds created from the filling machine. This calculation will create an additional cost per case based on the number of seconds produced. The formula in Figure 2 was used to calculate costs.
Costs = (12 bottles/case*target fill (oz)/bottle*$0.4027/oz) + (% of seconds) $0.70833/case
Before we could determine a target fill to use for calculating...