Masefield Dairy is preparing a third-quarter budget (July, August, and September) for its ice cream products. It produces five brands of ice cream, and each uses a different mix of ingredients. Its suppliers deliver ingredients just in time, provided that they are given 2 months' notice. The following table indicates the units of weight or volume of each type of ingredient required per unit of each product:

The following table summarizes the estimated unit sales for each product in each of the months in the third quarter:

Prepare a monthly purchases budget for the ice cream ingredients.

Transcribed Image Text:

Masefield Dairy Required Ingredients PRODUCT INGREDIENTS A B C E Ingredient 1 1 2 Ingredient 2 2 0 Ingredient 3 0 1 Ingredient 4 1 3 1320 1 1 2 4 0 0 2 2 Ingredient 5 0 2 1 0 Ingredient 6 3 1 3 0 1