Can I recieve help with the Variable Costing Income Statement, Retained Earnings, and Balance Sheet?

INPUT SECTION SALES 4th Quarter 2020 1st Quarter 2nd Quarter 2021 48,100 3rd 4th Quarter Quarter 2021 2021 34,500 31,000 2021 43,000 Budgeted Sales in units 41,000 Budgeted Selling Price $ 530 per production unit (Finished Goods) RECEIVABLES Receivables Collection Schedule 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 INVENTORY COSTS Direct Labor 4.5 hours 18.00 per direct labor hour $ Raw Materials 3 pounds per finished goods unit 85.00 per pound $ Variable Overhead $ 10.50 per Direct Labor Hour Fixed Overhead Depreciation $ Other Fixed Overhead $ 195,000 per quarter 950,000 per quarter Fixed Overhead Application Rate CALCULATE FROM PRODUCTION BUDGET INVENTORY ACCOUNTS 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 2021 2021 2021 2021 0 15,000 19,000 20,000 16,000 41,368 pounds 26,000 Ipounds 25.00% of next quarters' needs for production is in ending Raw Materials Inventory 231,720 231,720 36 INVENTORY ACCOUNTS 37 Finished Goods Inventory 38 4th Quarter 39 2020 40 Ending units 41 42 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 OPERATING EXPENSES 56 Wages and Salaries Payment 57 Payment Policy 58 59 60 Variable Selling & Administrative Exp. 61 62 Fixed Selling & Administrative Exp 63 Depreciation $ 64 Other Selling & Administrative Exp $ 65 66 CAPITAL EXPENDITURES 67 1st Quarter 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 55,000 per quarter 180,000 per quarter 2nd Quarter 2021 3rd Quarter 2021 4th Quarter 2021 2021 68 66 CAPITAL EXPENDITURES 67 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 68 2021 2021 2021 2021 69 Equipment Purchases $1,000.00 $20,000.00 $30,000.00 $40,000.00 70 71 TREASURY ACTIVITIES 72 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 73 2021 2021 2021 2021 74 Dividends to be Declared $500.00 $10,000.00 $20,000.00 $30,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 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 S 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 FLEXIBLE BUDGET 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 PRIOR YEAR RESULTS 95 Precision Propulsion Company 96 Balance Sheet 97 12/31/2020 98 ASSETS CUSTOMIZATION PROJECT INFORMATION Sales Budget Production Budget DM & DL Budge... 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 FLEXIBLE 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 PRIOR YEAR RESULTS 95 Precision Propulsion Company 96 Balance Sheet 97 12/31/2020 98 ASSETS 99 Cash $ 6,150,000 100 Inventory $ 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 S 26,234,500 108 Retained Earnings $ 10,013,500 109 $ 44,348,000 110 CUSTOMIZATION PROJECT INFORMATION Sales Budget Production Budget DM & DL Budge... + + E 1 Sales Budget 2 Projected for Year Ending 12/31/2021 3 4 5 6 Budgeted Sales in Units 7 Selling Price 8 Budgeted Sales in Dollars 9 First Second Third Fourth Annual Quarter Quarter Quarter Quarter Total 48,1001 34,500 31,000 43,000 156600 $530 $530 $530 $530 $530 $ 25,493,000 $ 18,285,000$ 16,430,000$ 22,790,000$ 82,998,000 1 Production Budget 2 Projected for Year Ending 12/31/2021 3 4 Third 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 11 First Quarter 48,100 15,000 63,100 0 Second Quarter 34,500 19,000 53,5001 15,000 38,5001 Quarter 31,000 20,000 51,000 19,000 32,0001 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 1 Direct Materials Purchases Budget 2 3 4 5 Budgeted Finished Goods Produced (units) Raw Materials needed per unit 7 Raw Materials needed for production 8 Raw Material Ending Inventory (units) 9 Total Raw Materials needed 10 Raw Materials Beginning Inventory (units) 11 Raw Materials Purchases (units) 12 Cost per Unit 13 Raw Material Purchases Cost (dollars) 14 First Second Third Fourth Annual Quarter Quarter Quarter Quarter Total 63,100 38,500 32,0001 39,000 172,600 3 3 3 3 3 189,300 115,500 96,000 117,000 517,800 28,875 24,000 29,250 26,000 26,000 218,175 139,500 125,250 143,000 543,800 41,368 28,875 24,000 29,250 41,368 176,807 110,625 101,250 113,750 502,432 $ 85.00 $ 85.00 $ 85.00 $ 85.00 $ 85.00 $ 15,028,595 $ 9,403,125 $ 8,606,250 $ 9,668,750 $ 42,706,720 15 16 CHECK YOUR DIRECT MATERIALS PURCHASES BUDGET Does the sum of the Direct Material Purchases each quarter equal the total calculated from the YES 17 Annual Total column (F)? 18 19 20 21 22 23 24 Direct Labor Budget 25 26 First Second Third Fourth Annual 27 Quarter Quarter Quarter Quarter Total 28 Finished Goods Produced (units) 63,100 38,500 32,000 39,000 172,600 29 Direct Labor Hours Required per Unit 4.50 4.50 4.50 4.50 4.50 30 Total Direct Labor Hours Required 283,950 173,250 144,000 175,500 776,700 31 Hourly labor Rate 18.00 $ 18.00 $ 18.00 $ 18.00 $ 18.00 32 Direct Labor Cost (dollars) $ 5,111,100 $ 3,118,500 $ 2,592,000 $3,159.000 $ 13,980,600 1 Overhead Budget 2 3 First Second Third Fourth Annual 4 Quarter Quarter Quarter Quarter Total 5 Total Direct Labor Hours Budgeted 283,950 173,250 144,000 175,500 776,700 6 Variable Overhead Rate per hour $ 10.50 $ 10.50 $ 10.50 $ 10.50 $ 10.50 7 Variable Overhead Cost $ 2,981,475$ 1,819,125$ 1,512,000 $ 1,842,750$ 8,155,350 8 Fixed Overhead Cost without Depreciation $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 3,800,000 9 Depreciation Cost $ 195,000 $ 195,000 $ 195,000 $ 195,000 $ 780,000 10 Total Overhead Cost $ 4,126,475$ 2,964,125$ 2,657,000 $ 2,987,750 $ 12,735,350 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 (E)? 15 16 17 18 19 Selling & Administrative Expense Budget 20 21 First 22 Quarter Second Quarter 18,285,000 $ 3.25% $ 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 25,493,000 $ 3.25% 828,523$ 180,000 $ 55,000 $ 1,063,523 $ Third Fourth Quarter Quarter 16,430,000$ 22,790,000 $ 3.25% 3.25% 533,975$ 740,675$ 180,000 $ 180,000 $ 55,000 $ 55,000$ 768,975 $ 975,675$ Annual Total 82,998,000 3.25% 2,697,435 720,000 220,000 3,637,435 $ $ $ 594,263 $ 180,000 $ 55,000 $ 829,263 $ Annual Second Quarter 18,285,000 Third Quarter 16,430,000 Fourth Quarter 22,790,000S 82,998,000 1 SCHEDULE OF CASH COLLECTIONS 2 3 First 4 Quarter 5 Budgeted Sales in dollars S 25,493,000 $ 6 7 Collections in quarter of sale 21,159,190$ 8 Collections in quarter following sale $ 5,050,000 $ 9 Total Collections 5 26,209,1905 10 11 Net Accounts Receivable Balance $ 3,823,950 $ 12 13 CHECK YOUR SCHEDULE OF CASH COLLECTIONS 15.176,550 $ 3,823,950 S 19,000,500 13,636.900$ 2,742,750 S 16,379,650 $ 18.915.700$ 2,464,500 $ 21,380.2005 68,888,340 14 081200 82,969,540 2,742,750 2,464,500 3,418 500S 3,418 500 Annual YES 14 Have you found the amount of cash that will be collected in the first quarter from sales in 2020? 15 16 17 18 SCHEDULE OF CASH PAYMENTS 19 20 First Second Third Fourth 21 Quarter Quarter Quarter Quarter 22 23 Raw Material Purchases $ 15,028,595s 9,403 125$ 8,606 2505 9,668,7505 24 25 Payments in quarter of purchase S 12,774,305.75 S 7,992,656.25S 7,315,312.50 S 8,218,437.50 $ 26 Payments in quarter following purchase $ 8,100,000 $ 2,254,2895 1,410,4695 1,290,9385 27 Total payments s 20,874,3065 10,246,9465 8,725,7815 9,509,3755 28 29 Accounts payable balance $ 2,254,2895 1.410,469S 1.290,9385 1.450,3135 30 42.706, 720 36,300,712 13,055,696 49,356 408 1.450 313 Third Annual First Quarter Second Quarter Fourth Quarter Quarter S s $ 21,159,190$ 5,050,000 $ 26,209,190$ 15,176,550 $ 3,823,950 $ 19,000 500 $ 13,636,9005 2,742,750 $ 16 379,650 $ 18,915,700 2,464,500 5 21,380.2005 68,888,340 14,081,200 82.969.540 S $ s s S $ 12,774,305S 8,100,000 5,111,100S 3,931,475 S 1.008,5235 30,925,4035 7,992,656S 2,254,289S 3,118,500S 2,769,125S 774263$ 16,908,833S 7,315,313 S 1,410,469 $ 2,592,000 $ 2,462,000S 713 975$ 14,493,756$ 8,218,438 S 1,290,9385 3,159,000S 2,792,750S 920,675 S 16,381,8005 36,300,712 13,055,696 13,980,600 11,955,350 3,417,435 78,709,793 -5 6 CASH BUDGET 17 38 89 10 Cash Collections. 11 Collections in quarter of sale 12 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 80 Discretionary Uses of Cash 61 Equipment Purchases 62 Dividends 63 64 Leave Financing section empty 65 Financing (should not be required) 66 Borrowing 67 Pepayment 68 Interest 69 Total Financing Cash Increase (Decreasel 70 71 Net Cash Available After Dicretionary Cash Uses 72 Interest Earned on Cash 73 Ending Cash Balance 74 5 5 S 5 5 (4,716,213) $ 6,150,000 $ 1,433,787 250,000 S 1,183,787 S 2,091,667 S 785,7035 2,877,370 S 250,000 S 2,627,370 S 1,885,8945 2,243,7235 4,129,6175 250,000 $ 3,879,6175 4,998,400 S 3,508, 492 S 8,506,8925 250.000 S 8,256,892 S 4,259,748 6,150,000 10,409,748 250,000 10,159,748 $ S $ 655,863 S $ 655,863S 5,450,000 655,8635 5,450,000 2,623.450 655,863S $ S 777924S 7.779 $ 785 703 S 2,221,508S 222155 2.243 723S 3,473,754 S 34 738 S 3.508.4925 2,401,0295 24,010 S 2.425 040S 2,336,298 88.742 2.425.040 1 Fixed Manufacturing Overhead Rate 2 3 Total Finished Goods Units Produced 172,6001 4 Total Fixed Overhead $4,580,000 5 Fixed Manufacturing Overhead Rate $26.54 6 7 CHECK YOUR FIXED MANUFACTURING OVERHEAD RATE Have you found the Total Fixed Overhead and used the correct formula? MORE WORK TO DO 8 9 Use Per Unit Costs $ 255.00 $ 81.00 $ 47.25 S 26.54 $ 409.79 16,000 $ 6,556,565 10 11 12 Ending Finished Goods Inventory-Absorption 13 14 Direct Material 15 Direct Labor 16 Variable Overhead 17 Fixed Overhead 18 Total product cost per unit manufactured 19 20 Units in Ending Finished Goods Inventory 21 Finished Goods Ending Inventory Value 22 23 24 25 Ending Finished Goods Inventory - Variable 26 27 Direct Material 28 Direct Labor 29 Variable Overhead 30 Total product cost per unit maufactured 31 32 Units in Ending Finished Goods Inventory 33 Finished Goods Ending Inventory Value Use Per Unit Costs $ 255.00 $ 81.00 $ 47.25 $ 383.25 3 $ 16,000 6,132,000 $ D E 1 Cost of Goods Manufactured - Absorption 2 For Year Ended 12/31/2021 3 4. Direct Materials: 5 Beginning Inventory of raw materials $ 3,516,280 6 Raw Material Purchases $ 42,706,720 7 Raw Materials Available $ 46,223,000 8 Ending Inventory of Raw Materials $ 2,210,000 9 Direct Materials Used 10 Direct Labor: 11 Overhead: 12 Total Manufacturing Costs Added 13 Plus: Beginning Work in Process Inventory 14 Total Manufacturing Costs 15 Less: Ending Work in Process Inventory 16 Cost of Goods Manufactured 17 18 CHECK YOUR COST OF GOODS MANUFACTURED - ABSORPTION $ 44,013,000 $13,980,600 $12,735,350 $ 70,728,950 $ 231,720 $ 70,960,670 231,720 $ 70,728,950 Have you calculated beginning inventory of raw materials from the 2020 information? YES 19 20 21 22 23 Cost of Goods Manufactured - Variable 24 For Year Ended 12/31/2021 25 26 Direct Materials Used 27 Direct Labor 28 Variable Overhead 29 Total Variable Manufacturing Costs 30 $ 44,013,000 $13,980,600 $8,155,350 $ 66,148,950 1 Cost of Goods Sold - Absorption 2 3 Beginning Finished Goods Inventory 4 Cost of Goods Manufactured 5 Ending Finished Goods Inventory 6 Cost of Goods Sold $ 3,748,000.00 $ 70,728,950 $ 6,556,565 $ 67,920,385 7 8 9 Cost of Goods Sold - Variable 10 11 Beginning Finished Goods Inventory 12 Cost of Goods Manufactured 13 Ending Finished Goods Inventory 14 Cost of Goods Sold $ 3,748,000.00 $ 66,148,950 $ 6,132,000 $ 63,764,950 15 1 Precision Propulsion Company 2 Absorption Costing Income Statement 3 For the Year Ended 12/31/2021 4 $ 82,998,000 $ 67,920,385 $ 15,077,615 $ 5 Revenue 6 Less: Cost of Goods Sold 7 Gross Margin 8 Less: Operating Expenses 9 Selling & Administrative Expense 10 Bad Debt Expense 11 Operating Income 12 Plus: Interest Revenue 13 Income Before Taxes 14 15 Grayed cells not used $ $ $ 3,637,435 1,659,960 9,780,220 206,813 9,987,033 $ $ 16 1 Precision Propulsion Company 2 Variable Costing Income Statement 3 For the Year Ended 12/31/2021 4 5 Revenue 6 Less: Variable Costs 7 Variable Cost of Goods Sold 8 Variable Selling & Administrative Costs 9 Bad Debt Expense 10 Contribution Margin 11 Less: Fixed Costs 12 *Fixed Manufacturing Cost 13 *Fixed Selling & Administrative Costs 14 Operating Income 15 Plus: Interest Revenue 16 Income Before Taxes 17 18 *Include cash and non-cash fixed costs 19 Grayed cells not used 1 2 Precision Propulsion Company Statement of Retained Earnings For the Year Ended 12/31/2021 3 4 5 Retained Earnings 12/31/2020 Plus: Income (Before Taxes) 7 Less: Dividends 8 Retained Earnings 12/31/2021 B 1 2 Precision Propulsion Company Balance Sheet For the Year Ended 12/31/2021 3 4 5 ASSETS 6 Cash 7 Raw Materials Inventory 8 Work in Process Inventory 9 Finished Goods Inventory 10 Accounts Receivable (net) 11 Plant and Equipment 12 Total Assets 13 14 LIABILITIES AND STOCKHOLDER'S EQUITY 15 Accounts Payable 16 Common Stock 17 Retained Earnings 18 Total Equity 19