Please create the budgets required at the bottom

Aussie Beverages bottles two soft drinks under license to Cadbury Schweppes at its Bendigo plant. Bottling at this plant is a highly repetitive, automated process. Empty bottles are removed from their carton, placed on a conveyor, and cleaned, rinsed, dried, filled, capped and heated (to reduce condensation). The two soft drinks bottled by Aussie Beverages are lemonade and diet lemonade. The syrup for both soft drinks is purchased from Cadbury Schweppes. Syrup for the regular brand contains a higher sugar content than the syrup for the diet brand. Aussie Beverages uses a lot size of 1000 cases as the unit analysis of its budgeting. (Each case contains 24 bottles.) Direct materials are expressed in terms of lots, where one lot of direct materials is the input necessary to yield one lot (1000 cases) of beverage. In 2022, the following purchase prices are forecast for direct materials: The two soft drinks are bottled using the same equipment. The equipment is cleaned daily, but is only rinsed when a switch is made during the day between diet lemonade and lemonade. Diet lemonade is always bottled first each day to reduce the risk of sugar contamination. The only difference in the bottling process for the two soft drinks is the syrup. Summary data used in developing budgets for 2022 are as follows: a.) Sales: a. Lemonade, 1080 lots at $9,000 selling price per lot. b. Diet lemonade, 540 lots at $8,500 selling price per lot. b.) Opening ( 1 January 2022 ) inventory of direct materials: a. Syrup for lemonade, 80 lots at $1,200 purchase price per lot. b. Syrup for diet lemonade, 70 lots at $1,100 purchase price per lot. c. Containers, 200 lots at $1000 purchase price per lot. d. Packaging, 400 lots at $800 purchase price per lot. c.) Opening ( 1 January 2022) inventory of finished goods: a. Lemonade, 100 lots at $5,300 per lot. b. Diet lemonade, 50 lots at $5,200 per lot. d.) Target closing (31 December 2022) inventory of direct materials: a. Syrup for lemonade, 30 lots. b. Syrup for diet lemonade, 20 lots. c. Containers, 100 lots. d. Packaging, 200 lots. e.) Target closing (31 December 2022) inventory of finished goods: a. Lemonade, 20 lots. b. Diet lemonade, 10 lots. f.) Each lot requires 20 direct labor hours at the 2022 budgeted rate of $25 per hour. Indirect manufacturing labor costs are included in the manufacturing overhead forecast. g.) Variable manufacturing overhead is forecast to be $600 per hour of bottling time; bottling time is the time the filling equipment is in operation. It takes 2 hours to bottle one lot of lemonade and 2 hours to bottle one lot of diet lemonade. Fixed manufacturing overhead is forecast to be $1,200,000 for 2022. h.) Hours of budgeted bottling time is the sole allocation base for all fixed manufacturing overhead. i.) Selling and General Administrative expenses for the year are budgeted at $1,000,000 Required: On the basis of the preceding data, prepare the following budgets for 2022: 1. Revenue (Sales) Budget (in \$) 2. Production Budget (in units) 3. Direct materials usage AND purchases budget (in units and \$) 4. Direct labor budget (in \$) 5. Manufacturing overhead budget (in \$) 6. Closing finished goods inventory budget (in $ ) 7. Budgeted Profit and loss account (Income Statement)(in \$)