I need help with the Cost of Goods Sold Budget, Selling And Administrative Budget, and Proforma Income Statement. Not sure how to start them.

Quaint Stem Company is a high-end glassware manufacturer that produces fine stemware of the highest quality. The company is completing its fourth year of operations and is preparing to build its master budget for the coming year (2020). The budget will detail each quarter's activity and the activity for the year in the total. The master budget will be based on the following information: a. Fourth-quarter sales for 2019 are 82,000 units and 65,000 for the first quarter of 2021. b. Unit sales by quarter (for 2020) are projected as follows: First quarter 66,000 Second quarter 68,000 Third quarter 75,000 Fourth quarter 85,000 The selling price is $86 per unit. Cash sales make up 25% of all sales. Quaint collects 75 percent of the credit sales within the quarter in which they are realized; the other 25 percent are collected in the following quarter. There are no bad debts. The beginning inventory of finished goods is 13,000 units. Required ending inventory is 25% of the next quarter's sales in units. d. Each stemware unit uses one and a half hours of direct labor and two units of direct materials. Laborers are paid $23.00 per hour, and one unit of direct materials costs $12. e. There are 10,400 units of direct materials in beginning inventory as of January 1, 2019. At the end of each quarter, Quaint plans to have 10 percent of the direct materials needed for next quarter's unit sales. The ending unit of direct materials on hand at the end of the year was 19,500. f. Quaint buys direct materials on account. Half of the purchases are paid for in the quarter of acquisition, and the remaining half are paid for in the following quarter. Wages and salaries are paid on the 15th and 30th of each month. g. Fixed overhead totals $671,600 for each of the first three quarters. Of this total, $255,000 represents depreciation. During the fourth quarter, the depreciation and total fixed overhead increases by $18,575. All fixed expenses other than depreciation are paid for in cash in the quarter incurred. The fixed overhead rate is computed by dividing the year's total fixed overhead by the year's expected actual units produced. h. Variable overhead is budgeted at $5.50 per direct labor hour. All variable overhead expenses are paid for in the quarter incurred. i. Fixed selling and administrative expenses total $285,000 per quarter, including $50,000 depreciation. j. Variable selling and administrative expenses are budgeted at $6 k. per unit sold. All selling and administrative expenses are paid for in the quarter incurred. The balance sheet as of December 31, 2019, is as follows: ASSETS LIABILITIES and STOCKHOLDERS'EQUITY 1. Accounts Payable $ 680,000 Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Plant and equipment, net Total Assets $ 52,000 1,275,000 124,800 656,500 9,360,000 $11,468,300 Capital Stock Retained Earnings Total Liab. & Equity 9,750,000 1,038,300 $11,468,300 m. Quaint has a required cash balance of $50,000. An operating line of credit is available up to $250,000 at 8% interest. All borrowings and payments must be made in increments of $10,000 and interest is paid when principal is paid. All borrowings take place at the beginning of the quarter and all payments take place at the end of the quarter. n. Quaint will pay quarterly dividends of $55,000. At the end of the third quarter, $525,000 of equipment will be purchased and at the end of the fourth quarter, $225,000 of equipment will be purchased 0. The income tax rate is 30%. OPERATING BUDGET Sales Budget Quarter 75,000 Year 294,000 Units Unit selling price Budgeted sales 66,000 86 5,676,000 68,000 86 5,848,000 86 85,000 86 7,310,000 6,450,000 25,284,000 Production Budget Quarter 3 Sales in units Desired ending inventory Total needs Less: Beginning inventory Units to be produced 66,000 17,000 83,000 13,000 70,000 68,000 18,750 86,750 17,000 69.750 75,000 21,250 96,250 18,750 77,500 85,000 16,250 101,250 21,250 80,000 Year 294,000 16,250 310,250 13,000 297,250 21 Direct Materials Purchases Budget Quarter 70,000 69,750 77,500 80,000 Units to be produced Direct materials per unit Production needs Desired ending inventory Total needs Less: Beginning inventory Direct materials to be purchased Cost per unit Total material purchase cost 140,000 13.950 153,950 10,400 143,550 139,500 15,500 155,000 13,950 141,050 12 1,692,600 155,000 16,000 171,000 15,500 155,500 160,000 19,500 179,500 16,000 163,500 12 1,962,000 Year 297,250 2 594,500 19,500 614,000 10,400 603,600 12 7,243,200 12 12 1,722,600 1,866,000 Units to be produced Direct labor time per unit in hours Total hours needed Average wage per hour Total direct labor cost Direct Labor Budget Quarter 3 70,000 69,750 77,500 1.5 1.5 1.5 105,000 104,625 116,250 23.00 23.00 23.00 2,415,000 2,406,375 2,673,750 4 80,000 1.5 120,000 23.00 2,760,000 Year 297,250 1.5 445,875 23.00 10,255, 125 Overhead Budget Quarter Budgeted direct labor hours Variable overhead rate Budgeted variable overhead Budgeted fixed overhead Total overhead 105,000 5.50 577,500 671,600 1,249.100 104,625 5.50 575,438 671,600 1.247,038 116,250 5.50 639,375 671,600 1,310,975 120,000 5.50 660,000 690,175 1,350,175 Year 445,875 5.50 2,452,313 2,704,975 5,157, 288 Note: depreciation in fixed overhead Unit product cost for ending inventory budget: Direct materials Direct labor Variable overhead Fixed overhead Total unit cost Total finished goods units for end of year Total ending finished goods inventory 24.00 34.50 5.50 17.35 81.35 13,000 1,057,550 Cost of Goods Sold Budget Quarter 2 4 Year Direct materials used Direct labor used Overhead Budgeted manufacturing costs Beginning finished goods Cost of goods available for sale Less: Ending finished goods Budgeted cost of goods sold Selling and Administrative Budget Quarter Year Planned sales in units Variable selling and admin exp per unit Total variable expense Fixed selling and admin expense Total selling and admin expenses Note: depreciation in fixed selling and admin expense Proforma Income Statement Year Sales Less: Cost of goods sold Gross margin Less: Seling and admin expenses Operating income Less: Interest expense Income before income taxes Less: Income taxes Net income 30% End of operating budget