Can I recieve help with filling this out?

These 4 photos are the project information to fill out the following tabs in the excel spreadsheet.

Can I recieve help filling this out?

SECTION 4th Quarter Quarter 2nd Quarter 2021 48,100 3rd 4th Quarter Quarter 2021 2021 34,500 31,000 2020 2021 43,000 Budgeted Sales in units 41,000 $ 530 per production unit (Finished Goods) 1 Budgeted Selling Price 2 3 4 TABLES 5 Receivables Collection Schedule 6 7 8 9 0 11 TORY COSTS 2 Direct Labor 23 24 25 Raw Materials 26 83.00% quarter of sale 15.00% quarter following sale 2.00% uncollectible 100.00% Entire projected uncollectible receivables are written off each quarter Policy s 4.5 hours 18.00 per direct labor hour 3 pounds per finished goods unit 85.00 per pound $ 28 Variable Overhead $ 10.50 per Direct Labor Hour 29 30 Fixed Overhead 31 Depreciations 195,000 per quarter Other Fixed Overhead S 950,000 per quarter 33 34 Fixed Overhead Application Rate CALCULATE FROM PRODUCTION BUDGET 35 36 TORY ACCOUNTS 37 Finished Goods inventory 38 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 39 2020 2021 2021 2021 2021 40 Ending units 0 15,000 19,000 20.000 16.000 41 41,368 pounds 26,000 pounds 25.00% of next quarters' needs for production is in ending Raw Materials inventory 231,720 231,720 2 Raw Materials Inventory 3 Beginning units on 1/1/2021 4 Planned Ending units on 12/31/2021 5 Policy 6 7 Work in Process Inventory 8 Beginning value 1/1/2021 $ 9 planned Ending value on 12/31/2021 $ 0 1 Payment for Raw Materials 2 Payment Policy 3 14 55 TING EXPENSES 66 Wages and Salaries Payment 7 Payment Policy 58 59 50 Variable Selling & Administrative Exp. 85.00% quarter of purchase 15.00% quarter following purchase 2 times monthly on the 15th and 30th Fully paid each month 3.25% of selling price 2021 52 Fixed Selling & Administrative Exp Depreciations 55,000 per quarter Other Selling & Administrative ExpS 180,000 per quarter 65 66 AL EXPENDITURES 67 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 68 2021 2021 2021 69 Equipment Purchases $1,000.00 $1,500.00 $2,000.00 $2,500.00 70 71 URY ACTIVITIES 72 Ist 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 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 nn 2021 $500.00 2021 $1,000.00 2021 $1,500.00 2021 $2,000.00 73 74 Dividends to be Declared 75 76 Minimum Cash Balance $ 250,000 Required at end of every quarter 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 2 750 units 93 94 YEAR RESULTS 95 Precision Propulsion Company 96 Balance Sheet 97 12/31/2020 98 ASSETS 99 Cash S 6,150,000 100 Inventory S 3,748,000 101 Accounts Receivable (net) S 5,050,000 102 Plant and Equipment S 29,400,000 103 $ 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 S 44,348,000 110 Direct Materials Purchases Budget Annual Total 172,600] 3 First Second Third Fourth Quarter Quarter Quarter Quarter 5 Budgeted Finished Goods Produced (units) 63,100 38,500 32,000 39,000 5 Raw Materials needed per unit 7 Raw Materials needed for production 3 Raw Material Ending Inventory (units) Total Raw Materials needed O Raw Materials Beginning Inventory units) 1 Raw Materials Purchases (units) 2 Cost per Unit 3 Raw Material Purchases Cost (dollars) 4 5 6 CHECK YOUR DIRECT MATERIALS PURCHASES BUDGET Does the sum of the Direct Material Purchases each quarter equal the total calculated from the YES 7 Annual Total column (62 8 9 20 1 22 Fourth Quarter 39,000 Annual Total 172,600 24 Direct Labor Budget 25 26 First Second Third Quarter Quarter Quarter 28 Finished Goods Produced units) 63,100 38,500 32.000 29 Direct Labor Hours Required per Unit 30 Total Direct Labor Hours Required 31 Hourly Labor Rate 32 Direct Labor Cost dollars) 33 34 35 CHECK YOUR DIRECT LABOR BUDGET Does the sum of the Direct Labor costs each quarter equal the total calculated from the Annual 36 Total column 17 1 Overhead Budget Fourth Quarter Annual Total YES 3 First Second Third 4 Quarter Quarter Quarter 5 Total Direct Labor Hours Budgeted 5 Variable Overhead Rate per hour 7 Variable Overhead Cost 3 Fixed Overhead Cost without Depreciation Depreciation Cost 0 Total Overhead Cost 1 2 3 CHECK YOUR OVERHEAD BUDGET Does the sum of the overhead costs each quarter equal the total calculated from the Annual Total 4 column 162 5 6 7 18 19 Selling & Administrative Expense Budget 20 21 First Second Third 22 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 30 31 CHECK YOUR SELLING & ADMINISTRATIVE EXPENSE BUDGET Does the sum of the selling & administrative costs each quarter equal the total calculated from 32 the Annual Total column (F) information? Fourth Annual Quarter Total YES 1 SCHEDULE OF CASH COLLECTIONS Fourth Annual First Quarter Second Quarter Third Quarter Quarter 4 5 Budgeted sales in dollars 6 7 Collections in quarter of sale B Collections in quarter following sale 9 Total Collections 10 11 Net Accounts Receivable Balance 12 13 CHECK YOUR SCHEDULE OF CASH COLLECTIONS MORE WORK TO DO 14 Have you found the amount of cash that will be collected in the first quarter from sales in 20202 15 16 17 18 SCHEDULE OF CASH PAYMENTS 19 20 First Second 21 Quarter Quarter Annual Third Quarter Fourth Quarter 23 Raw Material Purchases 24 25 Payments in quarter of purchase 26 Payments in quarter following purchase 27 Total payments 28 29 Accounts payable balance 30 B1 CHECK YOUR SCHEDULE OF CASH PAYMENTS MORE WORK TO 00 32 Have you found the amount of payments in the first quarter from purchases in 2020? 33 34 35 36 CASH BUDGET 37 3B First Second Third Fourth Annual SCHEDULE OF CASH PAYMENTS First Quarter Second Quarter Annual Third Quarter Fourth Quarter Raw Material Purchases Payments in quarter of purchase 5 Payments in quarter following purchase Total payments Accounts payable balance 1 CHECK YOUR SCHEDULE OF CASH PAYMENTS MORE WORK TO DO 2. Have you found the amount of payments in the first quarter from purchases in 2020 3 4 5 6 CASH BUDGET 7 3 First Second 9 Quarter Quarter Cash Collections 1 Collections in quarter of sale 2. Collections in quarter following sale 3. Total Cash Receipts Annual Third Quarter Fourth Quarter 5 Cash Disbursements 6 Raw Materials 17 Payments in quarter of purchase 18 Payments in quarter following purchase 39 Direct Labor Costs 50 Overhead Costs 51 Selling and Administrative Costs 52 Total Cash Disbursements 53 54 Net Operating Cash Flows 55 Beginning Cash 56. Net Cash Available Oil Paidat OHR S&A Fyn Budget Cas 41 Collections in quarter of sale 42 Collections in quarter following sale 43 Total Cash Receipts 44 45 Cash Disbursements: 46 Raw Materials 47 Payments in quarter of purchase 48 Payments in quarter following purchase 49 Direct Labor Costs 50 Overhead Costs 51 Selling and Administrative Costs 52 Total Cash Disbursements 53 54 Net Operating Cash Flows 55 Beginning Cash 56 Net Cash Available 57 Minimum cash balance 58 Cash Available for Discretionary Uses 59 60 Discretionary Uses of Cash 61 Equipment Purchases 62 Dividends 63 64 Leave Financing section empty 65 Financing (should not be required) 66 Borrowing 67 Repayment 58 Interest 69 Total Financing Cash increase (Decrease) 70 71 Net Cash Available After Dicretionary Cash Uses 72 Interest Earned on Cash 73 Ending Cash Balance 74 75 Grayed cells are not used 76 Light yellow cells are your cash outflow choices from the INPUT worksheet 77 78 CHECK YOUR CASH BUDGET Does the ending balance of cash derived from your Row 73 information match the ending value of cash from the 79 Annual Total column ? YES 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 Fixed Overhead Depreciation $ Other Fixed Overhead $ 195,000 per quarter 950,000 per quarter Fixed Overhead Application Rate CALCULATE FROM PRODUCTION BUDGET 1st Quarter 2021 15,000 2nd Quarter 2021 19,000 3rd Quarter 2021 20,000 4th Quarter 2021 16,000 41,368 pounds 26,000 pounds 25.00% of next quarters' needs for production is in ending Raw Materials Inventory STORY ACCOUNTS 7 Finished Goods Inventory 8 4th Quarter 9 2020 0 Ending units 11 #2 Raw Materials Inventory 43 Beginning units on 1/1/2021 44 Planned Ending units on 12/31/2021 45 Policy 46 47 Work In Process Inventory 48 Beginning value 1/1/2021 $ 49 Planned Ending value on 12/31/2021 $ 50 51 Payment for Raw Materials 52 Payment Policy 53 54 55 ATING EXPENSES 56 Wages and Salaries Payment 57 Payment Policy 58 59 60 Variable Selling & Administrative Exp. 61 62 Fixed Selling & Administrative Exp 231,720 231,720 85.00% quarter of purchase 15.00% quarter following purchase 2 times monthly on the 15th and 30th Fully paid each month 3.25% of selling price 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 1 SCHEDULE OF CASH COLLECTIONS 2 3 Second Third First Quarter Annual Fourth Quarter Quarter Quarter 5 Budgeted Sales in dollars 6 7 Collections in quarter of sale 8 Collections in quarter following sale 9 Total Collections 10 11 Net Accounts Receivable Balance 12 13 CHECK YOUR SCHEDULE OF CASH COLLECTIONS MORE WORK TO DO 14 Have you found the amount of cash that will be collected in the first quarter from sales in 2020? 15 16 17 First Annual 18 SCHEDULE OF CASH PAYMENTS 19 20 21 22 23 Raw Material Purchases 24 Second Quarter Third Quarter Fourth Quarter Quarter 25 Payments in quarter of purchase 26 Payments in quarter following purchase 27 Total payments 28 29 Accounts payable balance 30 A D E F CASH BUDGET First Quarter Second Quarter Third Quarter Annual Fourth Quarter e Cash Collections: 1 Collections in quarter of sale 2. Collections in quarter following sale 3 Total Cash Receipts 4 -5 Cash Disbursements: 26 Raw Materials 17 Payments in quarter of purchase 28 Payments in quarter following purchase 49 Direct Labor Costs 50 Overhead Costs 51 Selling and Administrative Costs 52 Total Cash Disbursements 53 54 Net Operating Cash Flows 55 Beginning Cash 56 Net Cash Available 57 Minimum cash balance 58 Cash Available for Discretionary Uses 59 60 Discretionary Uses of Cash 61 Equipment Purchases 62 Dividends 63 64 Leave Financing section empty: 65 Financing: (should not be required) 66 Borrowing 67 Repayment 68 Interest 69 Total Financing Cash Increase (Decrease) 70 71 Net Cash Available After Dicretionary Cash Uses Interest Earned on Cash 73 Ending Cash Balance 72 74 75 Graved cells are not used. 76 Linht allow calle Turcach outflounchalcar from the INDUT. Mcheat A B D E F Discretionary Uses of Cash Equipment Purchases Dividends Leave Financing section empty: Financing: (should not be required) Borrowing Repayment Interest Total Financing Cash Increase (Decrease) 0 1 Net Cash Available After Dicretionary Cash Uses 2 Interest Earned on Cash 3 Ending Cash Balance 74 75 Grayed cells are not used 76 Light yellow cells are your cash outflow choices from the INPUT worksheet