Operating budgets: materials purchasing plan 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 two months’ notice. The following table indicates the units of weight or volume of each type of ingredient required per unit of each product:
|
MASEFIELD DAIRY REQUIRED INGREDIENTS |
|||||
|
|
PRODUCT |
||||
|
INGREDIENTS |
A |
B |
C |
D |
E |
|
Ingredient 1 |
1 |
2 |
1 |
1 |
1 |
|
Ingredient 2 |
2 |
0 |
3 |
1 |
4 |
|
Ingredient 3 |
0 |
1 |
2 |
4 |
0 |
|
Ingredient 4 |
1 |
3 |
0 |
2 |
2 |
|
Ingredient 5 |
0 |
2 |
1 |
0 |
2 |
|
Ingredient 6 |
3 |
1 |
3 |
0 |
1 |
The following table summarizes the estimated unit sales for each product in each of the months in the third quarter:
|
MASEFIELD DAIRY ESTIMATED UNIT SALES |
|||
|
PRODUCT |
JULY |
AUGUST |
SEPTEMBER |
|
A |
194,675 |
162,033 |
129,857 |
|
B |
104,856 |
98,375 |
76,495 |
|
C |
209,855 |
194,575 |
170,654 |
|
D |
97,576 |
75,766 |
55,966 |
|
E |
47,867 |
39,575 |
20,958 |
Prepare a monthly purchases budget for the ice cream ingredients.