Asking about this question is below. Please give me detail explanation and answers in Excel. Thanks so much!

Reported is the budgeted trial balance for Breezeway Incorporated for fiscal year January 1st to December 31st, 2021. The budget accountant has completed the majority but has asked to you to complete the rest. Breezeway Incorporated Trial Balance For the Year Ended December 31, 2021 DEBIT CREDIT Cash ? Accounts Receivable $38,000 Inventory $17,188 Prepaid Insurance $10,000 Building $77,000 Equipment $230,000 Accounts Payable $65,646 Common Shares $35,000 Retained Earnings $172,000 Dividends $25,000 Sales Revenues Cost of Goods Sold Non-manufacturing costs TOTAL .JJNote 1: The company sells windows (Premier and Elite models) and is trying to budget as follows and uses the FIFO inventory method: Premier Windows Sales Information Elite Windows Expected Unit Sales 1,000 700 Target Ending Inventory 80 15 (units) Beginning Inventory (units) 95 20 Beginning Inventory (dollars) $13,000 $47,000 Selling price per unit $375 $550 Direct Materials (per window) Window Materials 50 kilograms 60 kilograms Window Material cost per kg $1.50 $1.50 Window Fittings 10 fittings 15 fittings Window Fitting cost per $0.50 $0.50 fitting Direct Manufacturing Labour (per window) DML Hours 2.00 3.00 DML Hourly Rate $25.00 $25.00 Manufacturing Overhead (per window) Manufacturing Overhead 3.00 4.00 Hours MOH Hourly Rate $14.00 $14.00Note 2: Non-manufacturing costs are compromised of fixed costs. Last fiscal, they were compromised of wages of $50,000 that are expected to increase by 3% for the new year. Other non-manufacturing cost in the prior year were $40,000; for 2021, they are expected to increase by 1%. Note 3: The company expects to collect 95% of sales in cash. The remaining 5% are expected to be collected in the next fiscal year. The company expects to pay 80% of all manufacturing costs (direct materials, direct manufacturing labour and manufacturing overhead). Non- manufacturing costs are expected to be paid in full by the end of the year. The company is started the fiscal year with $70,000 in cash and is expecting to owe and pay $15,000 in income taxes by the end of the year. The company hopes to acquire $250,000 in equipment during the year, the plan is to pay cash for the purchase. ofshl woon w Required 1. Complete the trial balance by calculating the missing values (cash, sales revenues, cost of goods sold & non-manufacturing costs) in the trial balance. Ensure to total the trial balance (debits should equal credits): planige wooniw a. Calculate the sales revenues budget b. Calculate the cost of goods sold (Hint * you will need to determine the # of units to be produced, the cost of goods manufactured, the cost of goods available for sale and the cost of ending inventory) c. Calculate non-manufacturing costs. d. Calculate the cash budget. 2. Report, in good format, the set of financial statements for the company (Income Statement, Statement of Retained Earnings & Balance Sheet) navy shutastunam