plz help

Coca-Cola Enterprises (CCE) Is the largest bottier of Coca-Cola. in Western Europe. The company purchases Coke and Sprite concentrate from The Coca-Cola Company (KO), dilutes and mixes the concentrate with carbonated water, and then filts the blended beverage into cans or plastic two-liter bottles. Assume that the estimated production for Coke and Sprite two-liter bottles at the Wakefield, UK, bottling plant is as follows for the month of May: Coke 153,000 two-liter botties Sprite 86,500 two-liter bottles In addition, assume that the concentrate costs $75 per pound for both coke and 5 prite and is used at a rate of 0.15 pound per 100 liters of carbonated water In blending coke and 0.10 pound per 100 liters of carbonated water in blending Sprite. Assume that two liter of carbonated water are used for each two-liter bottle of finished product. Assume further that two-liter botties cost so.08 per bottle and carbonated water costs $0,06 per liter. Prepare a direct materials purchases budget for May, assuming inventorles are ignored, because thece, are no changes betwean beginning and ending inventories for concentrate, bottles, and carbonated water