Can I recieve help with filling this out?

This is all the information I have to include.

SECTION 1 st Quarter 4th Quarter 2nd Quarter 2021 48,100 3rd Quarter 2021 2021 34,500 31,000 2021 43,000 41,000 530 per production unit (Finished Goods) 5 4th 7 Quarter B 2020 9 Budgeted Sales in units 10 11 Budgeted Selling Price $ 12 13 14 VABLES 15 Receivables Collection Schedule 16 17 18 19 Policy 20 21 TORY COSTS 22 Direct Labor 23 $ 24 25 Raw Materials 26 $ 27 28 Variable Overhead $ 29 30 Fixed Overhead 31 Depreciation $ 32 Other Fixed Overhead $ 33 83.00% quarter of sale 15.00% quarter following sale 2.00% uncollectible 100.00% Entire projected uncollectible receivables are written off each quarter 4.5 hours 18.00 per direct labor hour 3 pounds per finished goods unit 85.00 per pound 10.50 per Direct Labor Hour 195,000 per quarter 950,000 per quarter 2 Fixed Selling & Administrative Exp 53 Depreciation $ 55,000 per quarter 54 Other Selling & Administrative Exp $ 180,000 per quarter 55 56 AL EXPENDITURES 67 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 68 2021 2021 2021 2021 69 Equipment Purchases $1,000.00 $1,500.00 $2,000.00 $2,500.00 70 71 URY ACTIVITIES 72 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 73 2021 2021 2021 2021 74 Dividends to be Declared $500.00 $1,000.00 $1,500.00 $2,000.00 75 76 Minimum Cash Balance s 250,000 Required at end of every quarter 77 78 Interest Rate for Investing (short-term) 4.00% Annually 79 Interest Policy All of the ending cash balance for the quarter earns interest for the entire quarter 80 All of the ending cash balance for the quarter remains in Cash at the beginning of the next quarter 81 82 Interest Rate for borrowing 12.00% Annually 83 Interest Policy $ 10,000 increments are used in borrowing and repayment, maintaining the minimum cash balance 84 Borrowing occurs at the beginning of the quarter, 85 Repayments occur at the end of the year. 86 87 LE BUDGET 88 Actual Units Produced USE VALUE FROM PRODUCTION BUDGET 89 90 Flexible Budget - Analyze at Additional Production Levels 91 Production level 1 500 units 92 Production level 750 units 93 94 YEAR RESULTS 3 Interest Rate for Investing (short-term) 4.00% Annually Interest Policy All of the ending cash balance for the quarter earns interest for the entire quarter All of the ending cash balance for the quarter remains in Cash at the beginning of the next quarter 1 2 Interest Rate for borrowing 12.00% Annually 3 Interest Policy $ 10,000 increments are used in borrowing and repayment, maintaining the minimum cash balance 34 Borrowing occurs at the beginning of the quarter. 35 Repayments occur at the end of the year. 36 37 LE BUDGET 88 Actual Units Produced USE VALUE FROM PRODUCTION BUDGET 89 90 Flexible Budget - Analyze at Additional Production Levels 91 Production level 1 500 units 92 Production level 2 750 units 93 94 YEAR RESULTS 95 Precision Propulsion Company 96 Balance Sheet 97 12/31/2020 98 ASSETS 99 Cash $ 6,150,000 100 Inventory S 3,748,000 101 Accounts Receivable (net) $ 5,050,000 102 Plant and Equipment $ 29,400,000 103 S 44,348,000 104 105 LIABILITIES AND EQUITY 106 Accounts Payable $ 8,100,000 107 Common Stock $ 26,234,500 108 Retained Earnings $ 10,013,500 109 $ 44,348,000 110 Direct Materials Purchases Budget First Quarter 63,100 Second Quarter 38,500 Third Quarter 32,000 Fourth Quarter 39,000 Annual Total 172,600 Budgeted Finished Goods Produced (units) Raw Materials needed per unit Raw Materials needed for production Raw Material Ending Inventory (units) Total Raw Materials needed Raw Materials Beginning Inventory (units) Raw Materials Purchases (units) 2 Cost per Unit Raw Material Purchases Cost (dollars) 5 6 CHECK YOUR DIRECT MATERIALS PURCHASES BUDGET Does the sum of the Direct Material Purchases each quarter equal the total calculated from the 7 Annual Total column (E? YES 8 9 0 1 2 Second Third 23 24 Direct Labor Budget 25 26 27 28 Finished Goods Produced (units) 29 Direct Labor Hours Required per Unit 30 Total Direct Labor Hours Required 31 Hourly Labor Rate 32 Direct Labor Cost (dollars) 33 First Quarter 63,100 Quarter 38,500 Quarter 32,000 Fourth Quarter 39,000 Annual Total 172,600 Overhead Budget Annual Total First Second Third Fourth Quarter Quarter Quarter Quarter - Total Direct Labor Hours Budgeted Variable Overhead Rate per hour Variable Overhead Cost 3 Fixed Overhead Cost without Depreciation Depreciation Cost 0 Total Overhead Cost 11 12 13 CHECK YOUR OVERHEAD BUDGET Does the sum of the overhead costs each quarter equal the total calculated from the Annual Total YES 14 column (F)? 15 16 17 18 19 Selling & Administrative Expense Budget 20 21 First Second Third Fourth 22 Quarter Quarter Quarter Quarter 23 Budgeted Sales in Dollars 24 Variable S&A rate 25 Variable S&A Cost 26 Fixed S&A Cost without Depreciation 27 Depreciation Cost 28 Total S&A Cost 29 Annual Total Sales Budget Projected for Year Ending 12/31/2021 Budgeted Sales in Units Selling Price 3 Budgeted Sales in Dollars First Quarter 48,100 $530 $ 25,493,000 Second Quarter 34,500 $530 18,285,000 $ Third Fourth Annual Quarter Quarter Total 31,000 43,000 156600 $530 $530 $530 16,430,000 $ 22,790,000 $ 82,998,000 0 11 CHECK YOUR SALES BUDGET Does the sum of the four quarters of sales equal the total calculated from the Annual 12 Total column (F)? YES D E First -Nminio OEM 1 Production Budget 2 Projected for Year Ending 12/31/2021 3 4 5 6 Budgeted Sales in units 7 Ending Inventory of Finished Goods 8 Total Need for Finished Goods 9 Beginning Inventory of Finished Goods 10 Budgeted Finished Goods Produced in units Quarter 48,100 15,000 63,100 0 Second Quarter 34,500 19,000 53,500 15,000 38,500 Third Quarter 31,000 20,000 51,000 19,000 32,000 Fourth Quarter 43,000 16,000 59,000 20,000 39,000 Annual Total 156,600 16,000 172,600 0 63,100 172,600 13 CHECK YOUR PRODUCTION BUDGET Does the sum of the four quarters of units produced equal the total calculated from the 14 Annual Total column (F)? 15 YES