Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January $280,000 February 360,000 March 500,000 All sales are on account. 60% of sales are expected to be collected in the month of the sale, 36% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for January, February, and March. Pet Supplies Inc. Schedule of Cash Collections from Sales For the Three Months Ending March 31 January February March January sales on account: Collected in January Collected in February Collected in March February sales on account: Collected in February Collected in March March sales on account: Collected in March Total cash collected o Direct Materials Purchases Budget Coca-Cola Enterprises (CCE) is the largest botter 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 fills 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 bottles Sprite 86,500 two-liter bottles In addition, assume that the concentrate costs $75 per pound for both Coke and Sprite 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 liters of carbonated water are used for each two-liter bottle of finished product. Assume further that two-liter bottles cost $0.08 per bottle and carbonated water costs $0.06 per liter. Prepare a direct materials purchases budget for May, assuming inventories are ignored, because there are no changes between beginning and ending inventories for concentrate, bottles, and carbonated water. Coca-Cola Enterprises-Wakefield Plant Direct Materials Purchases Budget For the Month Ending May 31 (assumed data) Concentrate 2-Liter Bottles Carbonated Water Materials required for production: lbs. btis. Itrs. Coke Sprite Total materials lbs. btls. Itrs. Direct materials unit price Total direct materials to be purchased