any and all help on the rest of this is appreciated!

Sales Budget Quarter last year next year 64,000 70,000 76,000 9 Units H0 Unit selling price 11 Budgeted sales Year 296,000 82 24 272 000 82 82 96.000 82 7,052,000 82 5.248 0005,740,000 6,232,000 Production Budget Quarter 68,000 15 16 Sales in units 17 Desired ending inventory 18 Total needs 19 Less Beginning inventory 20 Units to be produced 64.000 17 500 81 500 13 000 68.500 70.000 19,000 89,000 17.500 71,500 76,000 21,500 97 500 19,000 78,500 86,000 17 000 103,000 21,500 81 500 Year 296,000 17 000 313,000 13,000 300.000 Direct Materials Purchases Budget Quarter 24 25 Units to be produced 68 500 71,500 78,500 81,500 Year 300.000 Direct Materials Purchases Budget Quarter Year 300,000 68,500 71,500 78,500 25 Units to be produced 26 Direct materials per unit 27 Production needs 28 Desired ending inventory 29 Total needs 30 Less: Beginning inventory 31 Direct materials to be purchased 32 Cost per unit 33 Total material purchase cost 137,000 14,300 151,300 10.400 140.900 12 1,690 800 143,000 15.700 158,700 14.300 144.400 12 1732 800 157,000 16,300 173,300 15,700 157,600 12 1.891 200 4 81,500 2 163,000 14,200 177,200 16,300 160,900 600,000 14,200 614,200 10.400 603,800 12 7245,600 12 1930 800 35 Direct Labor Budget Quarter 68,500 38 Units to be produced 39 Direct labor time per unit in hours 40 Total hours needed 41 Auracowane nor hour 15 71,500 15 107 250 2400 78,500 1.5 117,750 2400 102 750 24.00 Year 300,000 1.5 450,000 24 81,500 1.5 122,250 240 Direct Labor Budget Quarter Year 300,000 1.5 38 Units to be produced 39 Direct labor time per unit in hours 40 Total hours needed 41 Average wage per hour 42 Total direct labor cost 43 68,500 1.5 102,750 24.00 2.466,000 71,500 5 1. 107,250 24.00 2,574.000 78,500 1 .5 1 17,750 24.00 2.826,000 81,500 1.5 122,250 24.00 2,934,000 450,000 24.00 10,800,000 Overhead Budget Quarter 47 Budgeted direct labor hours 48 Variable overhead rate 49 Budgeted variable overhead 50 Budgeted fixed overhead 51 Total overhead 102,750 4.50 462,375 576,400 1038, 775 107,250 4.50 482,625 576,400 1,059,025 117,750 4.50 529.875 576,400 1,108,275 122,250 4.50 550, 125 595 150 1.145 275 Year 450,000 4.50 2,025,000 2,324,350 4,349 350 53 Note: depreciation in fixed overhead 54 53 Note depreciation in fixed overhead 55 Unit product cost for ending inventory budget Direct materials Direct labor Variable overhead Fixed overhead Total unit cost 62 Total finished goods units for end of year 63 Total ending finished goods inventory 66 Cost of Goods Sold Budget Quarter Year 69 Direct matenals used 70 Direct labor used 71 Overhead 72 Budgeted manufacturing costs 73 Reginning finisherlands Cost of Goods Sold Budget Quarter Year 68 69 Direct materials used 70 Direct labor used 71 Overhead 72 Budgeted manufacturing costs 73 Beginning finished goods 74 Cost of goods available for sale 75 Less Ending finished goods 76 Budgeted cost of goods sold 18 Selling and Administrative Budget Quarter 80 4 Year 81 Planned sales in units 82 Variable selling and admin exp per unit 83 Total variable expense 84 Fixed selling and admin expense A5 Total sellinn and admin enenses Master Budget Performance Report Selling and Administrative Budget Quarter Year 81 Planned sales in units 82 Variable selling and admin exp per unit 83 Total variable expense 84 Fixed selling and admin expense 85 Total selling and admin expenses 86 89 87 Note: depreciation in fixed selling and admin expense 88 Proforma Income Statement 90 Year 91 Sales 92 Less: Cost of goods sold 93 Gross margin 94 Less: Seling and admin expenses 95 Operating income 96 Less: Interest expense 97 Income here income avec Proforma Income Statement Year 90 91 Sales 92 Less: Cost of goods sold 93 Gross margin 94 Less: Seling and admin expenses 95 Operating income 96 Less: Interest expense 97 Income before income taxes 98 Less: Income taxes 99 Net income 100 101 End of operating budget 102 103 FINANCIAL BUDGET 104 105 Cash Collections 106 Quarter 107 108 Cash Sales 100 Received an arenant fra 101 End of operating budget 102 FINANCIAL BUDGET Cash Collections Quarter 103 104 105 106 107 108 Cash Sales 109 Received on account from 110 Quarter 4, prior year 111 Quarter 1 112 Quarter 2 113 Quarter 3 114 Quarter 4 115 Total cash receipts 116 117 118 119 120 Quarter 4, prior year 121 Quarter 1 Cash Payments Quarter 2 117 Cash Payments Quarter 118 119 120 Quarter 4. pnor year 121 Quarter 1 122 Quarter 2 123 Quarter 3 124 Quarter 4 125 Total cash needed 126 127 128 129 130 Beginning cash balance 131 Cash sales and collections on account 132 Total cash available 133 Less disbursements 134 Payments for 135 Raw materials 136 Direct labor 137 Overhead Cash Budget Quarter Year 35 Raw materials 36 Direct labor 137 Overhead 138 Selling and admin expenses 139 Income taxes 140 Dividends 141 Equipment 142 Total disbursements 143 Excess (Deficiency) of cash available over needs 144 Financing 145 Borrowings 146 Repayments 147 Interest 148 Total financing 149 Ending cash balance 150 151 152 Pro Forma Balance Sheet 153 ASSETS 154 Cash Arcounts receivable Master Rudant Derformance Renart 155 Pro Forma Balance Sheet ASSETS Cash Accounts receivable Raw materials inventory Finished goods inventory Plant and equipment, net Total Assets LIABILITIES & EQUITY Accounts Payable Notes Payable Capital Stock Retained Earnings Total Liab & Equity 165 166 167 168 ARG 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 68,000 for the first quarter of 2021. b. Unit sales by quarter (for 2020) are projected as follows: First quarter 64,000 Second quarter 70,000 Third quarter 76,000 Fourth quarter 86,000 The selling price is $82 per unit. Cash sales make up 20% of all sales. Quaint collects 80 percent of the credit sales within the quarter in which they are realized; the other 20 percent are collected in the following quarter. There are no bad debts. C. 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 $24.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 14,200. 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 $576,400 for each of the first three quarters. Of this total, $175,000 represents depreciation. During the fourth quarter, the depreciation and total fixed overhead increases by $18,750. 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 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 $4.50 per direct labor hour. All variable overhead expenses are paid for in the quarter incurred. i. Fixed selling and administrative expenses total $230,000 per quarter, including $50,000 depreciation. j. Variable selling and administrative expenses are budgeted at $4 per unit sold. All selling and administrative expenses are paid for in the quarter incurred. k. The balance sheet as of December 31, 2018, is as follows: ASSETS LIABILITIES and STOCKHOLDERS'EQUITY 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 1. Quaint has a required cash balance of $50,000. An operating line of credit is available up to $250,000 at 10% 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. m. Quaint will pay quarterly dividends of $45,000. At the end of the third quarter, $575,000 of equipment will be purchased and at the end of the fourth quarter, $175,000 of equipment will be purchased n. The income tax rate is 30%. at 10% 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. m. Quaint will pay quarterly dividends of $45,000. At the end of the third quarter, $575,000 of equipment will be purchased and at the end of the fourth quarter, $175,000 of equipment will be purchased n. The income tax rate is 30%. Required Prepare a master budget for Quaint Stem Company for each quarter of 2019 and for the year in total. The following component budgets must be included: a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Ending finished goods inventory budget g. Cost of goods sold budget h. Selling and administrative expenses budget i. Cash budget j. Pro forma income statement k. Pro forma balance sheet