Direct Materials Purchases Budget Soda Company is the largest bottler in Western Europe. The company purchases Brand 1 and Brand 2 concentrate from The Soda Company, 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 Brand 1 and Brand 2 two-liter bottles at the Wakefleld, UK, bottling plant are as follows for the month of May: Brand 1 Brand 2 In addition, assume that the concentrate costs $87 per pound for both Brand 1 and Brand 2 and is used at a rate of 0.15 pound per 100 liters of carbonated water in blending Brand 1 and 0.2 pound per 100 liters of carbonated water in blending Brand 2. 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.084 per bottle and carbonated water costs $0.064 per liter 141,000 two-liter bottles 107,000 two-liter bottles 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. If required, round to the nearest whole number (except for unit price amounts, which should be rounded to nearest cent if required) Soda Company-Wakefield Plant Direct Materials Purchases Budget For the Month Ending May 31 (assumed data) Concentrate 2-Liter Bottles Carbonated Water Materials required for production: bs Brand 1 Brand 2 Total materials required Unit price Total direct materials to be purchased Sweet Tooth Company budgeted the following costs for anticipated production for August Advertising expenses Manufacturing supplies Power and light Sales commissions Factory insurance Production supervisor wages Production control wages Executive officer salaries Materials management wages Factory depreciation Prepare a factory overhead cost budget, separating variable and fixed costs. Assume that factory insurance and depreciation are the only fixed factory costs. $292,730 16,040 47,850 323,530 27,860 140,740 36,590 298,360 40,250 22,800 Sweet Tooth Company Factory Overhead Cost Budget For the Month Ending August 31 Variable factory overhead costs Total variable factory overhead costs Fixed factory overhead costs Total fixed factory overhead costs Total fixed factory overhead costs Total factory overhead costs