Can someone help me with this? 
Here is the information:
Cash Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget IMPORTANT Before using the Check Amounts, you must complete all 4 quarters of the Cash Budget and the Loan Schedule located below the Cash Budget. Full Year Total Beginning Cash Balance plus Cash Collections (from Sales Budget) less Payments for PSP (Raw Materials) (from Raw Materials Budget) () less Payments for Direct Labor (from Direct Labor Budget) less Payments for Manufacturing Overhead (from Manufacturing OH Budget) less Payments for SG&A (from SG&A Budget) less Payments for Equipment Purchases () less Payments for Dividends () Excess Cash or (Deficiency of Cash) before Borrowings, Repayments, Interest plus Additional Borrowings from the Bank during the quarter less Repayments Made to the Bank during the quarter () Cash Balance before Paying Interest less Interest Paid on the Bank Loan at the End of the Quarter() Ending Cash Balance Quarter in the 2021 Planning Year 1st 2nd 3rd $24,000 $85,201 $80,050 249,800 230,400 528,000 (89,152) (119,234) (222,062) (43,200) (40,320) (58,400) (69,200) (67,920) (73,360) (119,000) (131,000) (161,000) 0 0 (10,000) (15,000) (15,000) (15,000) (61,752) (57,873) 68,228 86,752 82,873 0 0 0 (43,228) 86,752 82,873 (43,228) (1,551) (2,823) (2,796) $85,201 $80,050 ($46,024) $23 517 4th ($46,024) 386,400 (168,652) (64,000) (75,600) (186,000) (10,000) (15,000) (178,876) 203,876 co (20,000 (60,000) A B 203,876 (3,677) (10,847) $200,199 CI Check Amounts $20 335 Sales Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget C Full Year 4th Total 16,000 units 52,000 units $28 per unit $448,000 $1,404,000 Check Amount + ReSet Inputs Quarter in the 2021 Planning Year 1st 2nd 3rd Sales in Units 12,000 units 10,000 units 14,000 units times Average Selling Price per Unit $26 per unit $28 per unit $26 per unit Total Dollar Sales $312,000 $280,000 $364,000 Check Amount + ReSet Inputs Fix the Format of All White Cells Calculation of Cash Collections - for the Cash Budget D 1st Qtr. 2nd Qtr. 3rd Qtr. Collection of Dec. 31, 2020 Accounts Rec. $125,000 Collection of 1st Qtr Sales $124,800 $62,400 $124,800 Collection of 2nd Qtr Sales $168,000 $112,000 Collection of 3rd Qtr Sales $291,200 Partial Collection of 4th Qtr Sales Total Cash Collections $249,800 $230,400 $528,000 Check Amounts ReSet Inputs ReSet Inputs ReSet Inputs 4th Qtr. E $72,800 $313,600 $386,400 ReSet Inputs Calculation of the December 31, 2021 Accounts Receivable - for the Balance Sheet Total Dollar Sales 4th Quarter (per above) $448,000 less 4th Quarter Sales Already Collected (per above) () ($313,600) Accounts Receivable as of December 31, 2021 $134,400 Check Amount RoSet Inputs Production Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget B Full Year Total Units All Units are Finished Units (Finished Cell Phone Covers) Sales in Units (from Sales Budget) plus Units Needed in Ending Inventory less Units Available from Beginning Inventory () Finished Units to Produce Check mounts Quarter in the 2021 Planning Year 1st 2nd 3rd 12,000 10,000 14,000 3,000 4,200 4,800 (3,000) (3,000) (4,200) 12,000 11,200 14,600 ReSet Inputs ReSet Inputs ReSet Inputs 4th 16,000 4,800 (4,800) 16,000 ReSet Inputs Raw Materials Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget Full Year Total 4th Quarter in the 2021 Planning Year 2nd 3rd 11,200 units 14,600 units 10 oz per unit 10 oz per unit 112,000 oz 146,000 oz 16,000 units 10 oz per unit 160,000 oz 1st Finished Units to Produce (from Production Budget)|| 12,000 units times Ounces of Plastic Steel Powder (PsP) Required per Finished Unit 10 oz per unit Ounces of Psp Required to produce the Finished Units 120,000 oz Ounces of Psp Required to produce the Finished Units 120,000 OZ plus Ounces of PsP Needed in Ending Raw Materials Inventory 22,400 OZ less Ounces of Psp Available from Beginning Raw Materials Inventory () (15,000) oz Total Ounces of Psp to Purchase 127,400 oz 112,000 oz 43,800 oz (22,400) oz 133,400 oz 146,000 oz 48,000 oz (43,800) Oz 150,200 oz 160,000 oz 26,000 oz (48,000) Oz 138,000 oz 549,000 Oz Total Ounces of Psp to Purchase 127,400 oz times Cost of PsP per Ounce $1.20 per oz Total Cost of Psp Purchases $152,880 Check Amount ReSet Inputs 133,400 oz $1.10 per oz $146,740 150,200 oz $1.10 per oz $165,220 A 138,000 oz $1.10 per oz $ 151,800 $616,640 Check Amount RoSet Inputs Fix the Format of All White Cells 3rd Qtr. 4th Qtr Calculation of Cash Payments for Raw Materials - for the Cash Budget 1st Qtr. 2nd Qtr. Payment of December 31, 2020 Accounts Payable $28,000 Payment of 1st Qtr Psp Purchases $61,152 $45,864 Payment of 2nd Qtr Psp Purchases $73,370 Payment of 3rd Qtr PsP Purchases Partial Payment of 4th Qtr Psp Purchases Total Cash Payments for PSP $89,152 $119,234 Check Amounts + ReSet Inputs Re Set Inputs $45,864 $44,022 $ 132,176 $29,348 $33,044 $106,260 $168,652 ReSet Inputs $222.062 ReSet Inputs Direct Labor Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget Full Year Total 1st Finished Units to Produce (from Production Budget) 12,000 units times Direct Labor Hours per Finished Unit 0.20 hrs equals Total Direct Labor Hours [ 2,400 hrs Quarter in the 2021 Planning Year 2nd 3rd 11,200 units 14,600 units 0.20 hrs 0.20 hrs 2,240 hrs 2,920 hrs 4th 16,000 units 0.20 hrs 3,200 hrs 10,760 hrs Total Direct Labor Hours 2,400 hrs times Average cost of a Direct Labor Hour $18 per hr Total Direct Labor $'s $43,200 Check Amount + ReSet Inputs 2,240 hrs $18 per hr $40,320 2,920 hrs $20 per hr $58,400 3,200 hrs $20 per hr $64,000 $205,920 Check Amount + ReSet Inputs Fix the Format of All White Cells Cash Payments for Direct Labor - for the Cash Budget 1st Qtr. 2nd Qtr. Total Cash Payments for Direct Labor * | $43,200 $40,320 3rd Qtr. 4th Qtr. $58,400 $ 64,000 * MyArmor pays all direct labor cost in the period incurred; thus Total Cash Payments = Total Direct Labor $'s Selling, General, and Administrative (SG&A) Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget Quarter in the 2021 Planning Year 2nd 3rd Full Year Total 1st 4th 12,000 units $6 per unit $72,000 10,000 units $6 per unit $60,000 14,000 units $6 per unit $84,000 16,000 units $6 per unit $96,000 SG&A Variable Cost Sales in Units (from Sales Budget) times Variable SG&A Cost per Unit Sold Total SG&A Variable Cost SG&A Fixed Costs Advertising Cost Salary Cost Mall Kiosk Rental Cost Utilities Cost Property Taxes Depreciation Total SG&A Fixed Cost $5,000 40,000 1,000 1,000 0 12,000 $59,000 $5,000 40,000 1,000 1,000 12,000 12,000 $71,000 $15,000 45,000 2,000 2,000 0 13,000 $77,000 $15,000 45,000 2,000 2,000 12,000 14,000 $90,000 $131,000 Total SG&A Cost $131,000 Check Amounts + ReSet Inputs $161,000 $186,000 $609,000 ReSet Inputs All Check Amounts OK Full Year Total Fix the Format of All White Cells Calculation of Cash Payments - for the Cash Budget 1st Qtr. 2nd Qtr. Total SG&A Cost (per above) $131,000 $131,000 less Depreciation Included in Total SG&A Cost () ($12,000) ($12,000) Total Cash Payments for SG&A $119,000 $119,000 Check Amounts ReSet Inputs 3rd Qtr. $ 161,000 ($13,000) $ 148,000 ReSet Inputs 4th Qtr. $186,000 ($14,000) $172,000 ($51,000) Cash Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget IMPORTANT Before using the Check Amounts, you must complete all 4 quarters of the Cash Budget and the Loan Schedule located below the Cash Budget. Full Year Total Beginning Cash Balance plus Cash Collections (from Sales Budget) less Payments for PSP (Raw Materials) (from Raw Materials Budget) () less Payments for Direct Labor (from Direct Labor Budget) less Payments for Manufacturing Overhead (from Manufacturing OH Budget) less Payments for SG&A (from SG&A Budget) less Payments for Equipment Purchases () less Payments for Dividends () Excess Cash or (Deficiency of Cash) before Borrowings, Repayments, Interest plus Additional Borrowings from the Bank during the quarter less Repayments Made to the Bank during the quarter () Cash Balance before Paying Interest less Interest Paid on the Bank Loan at the End of the Quarter() Ending Cash Balance Quarter in the 2021 Planning Year 1st 2nd 3rd $24,000 $85,201 $80,050 249,800 230,400 528,000 (89,152) (119,234) (222,062) (43,200) (40,320) (58,400) (69,200) (67,920) (73,360) (119,000) (131,000) (161,000) 0 0 (10,000) (15,000) (15,000) (15,000) (61,752) (57,873) 68,228 86,752 82,873 0 0 0 (43,228) 86,752 82,873 (43,228) (1,551) (2,823) (2,796) $85,201 $80,050 ($46,024) $23 517 4th ($46,024) 386,400 (168,652) (64,000) (75,600) (186,000) (10,000) (15,000) (178,876) 203,876 co (20,000 (60,000) A B 203,876 (3,677) (10,847) $200,199 CI Check Amounts $20 335 Sales Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget C Full Year 4th Total 16,000 units 52,000 units $28 per unit $448,000 $1,404,000 Check Amount + ReSet Inputs Quarter in the 2021 Planning Year 1st 2nd 3rd Sales in Units 12,000 units 10,000 units 14,000 units times Average Selling Price per Unit $26 per unit $28 per unit $26 per unit Total Dollar Sales $312,000 $280,000 $364,000 Check Amount + ReSet Inputs Fix the Format of All White Cells Calculation of Cash Collections - for the Cash Budget D 1st Qtr. 2nd Qtr. 3rd Qtr. Collection of Dec. 31, 2020 Accounts Rec. $125,000 Collection of 1st Qtr Sales $124,800 $62,400 $124,800 Collection of 2nd Qtr Sales $168,000 $112,000 Collection of 3rd Qtr Sales $291,200 Partial Collection of 4th Qtr Sales Total Cash Collections $249,800 $230,400 $528,000 Check Amounts ReSet Inputs ReSet Inputs ReSet Inputs 4th Qtr. E $72,800 $313,600 $386,400 ReSet Inputs Calculation of the December 31, 2021 Accounts Receivable - for the Balance Sheet Total Dollar Sales 4th Quarter (per above) $448,000 less 4th Quarter Sales Already Collected (per above) () ($313,600) Accounts Receivable as of December 31, 2021 $134,400 Check Amount RoSet Inputs Production Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget B Full Year Total Units All Units are Finished Units (Finished Cell Phone Covers) Sales in Units (from Sales Budget) plus Units Needed in Ending Inventory less Units Available from Beginning Inventory () Finished Units to Produce Check mounts Quarter in the 2021 Planning Year 1st 2nd 3rd 12,000 10,000 14,000 3,000 4,200 4,800 (3,000) (3,000) (4,200) 12,000 11,200 14,600 ReSet Inputs ReSet Inputs ReSet Inputs 4th 16,000 4,800 (4,800) 16,000 ReSet Inputs Raw Materials Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget Full Year Total 4th Quarter in the 2021 Planning Year 2nd 3rd 11,200 units 14,600 units 10 oz per unit 10 oz per unit 112,000 oz 146,000 oz 16,000 units 10 oz per unit 160,000 oz 1st Finished Units to Produce (from Production Budget)|| 12,000 units times Ounces of Plastic Steel Powder (PsP) Required per Finished Unit 10 oz per unit Ounces of Psp Required to produce the Finished Units 120,000 oz Ounces of Psp Required to produce the Finished Units 120,000 OZ plus Ounces of PsP Needed in Ending Raw Materials Inventory 22,400 OZ less Ounces of Psp Available from Beginning Raw Materials Inventory () (15,000) oz Total Ounces of Psp to Purchase 127,400 oz 112,000 oz 43,800 oz (22,400) oz 133,400 oz 146,000 oz 48,000 oz (43,800) Oz 150,200 oz 160,000 oz 26,000 oz (48,000) Oz 138,000 oz 549,000 Oz Total Ounces of Psp to Purchase 127,400 oz times Cost of PsP per Ounce $1.20 per oz Total Cost of Psp Purchases $152,880 Check Amount ReSet Inputs 133,400 oz $1.10 per oz $146,740 150,200 oz $1.10 per oz $165,220 A 138,000 oz $1.10 per oz $ 151,800 $616,640 Check Amount RoSet Inputs Fix the Format of All White Cells 3rd Qtr. 4th Qtr Calculation of Cash Payments for Raw Materials - for the Cash Budget 1st Qtr. 2nd Qtr. Payment of December 31, 2020 Accounts Payable $28,000 Payment of 1st Qtr Psp Purchases $61,152 $45,864 Payment of 2nd Qtr Psp Purchases $73,370 Payment of 3rd Qtr PsP Purchases Partial Payment of 4th Qtr Psp Purchases Total Cash Payments for PSP $89,152 $119,234 Check Amounts + ReSet Inputs Re Set Inputs $45,864 $44,022 $ 132,176 $29,348 $33,044 $106,260 $168,652 ReSet Inputs $222.062 ReSet Inputs Direct Labor Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget Full Year Total 1st Finished Units to Produce (from Production Budget) 12,000 units times Direct Labor Hours per Finished Unit 0.20 hrs equals Total Direct Labor Hours [ 2,400 hrs Quarter in the 2021 Planning Year 2nd 3rd 11,200 units 14,600 units 0.20 hrs 0.20 hrs 2,240 hrs 2,920 hrs 4th 16,000 units 0.20 hrs 3,200 hrs 10,760 hrs Total Direct Labor Hours 2,400 hrs times Average cost of a Direct Labor Hour $18 per hr Total Direct Labor $'s $43,200 Check Amount + ReSet Inputs 2,240 hrs $18 per hr $40,320 2,920 hrs $20 per hr $58,400 3,200 hrs $20 per hr $64,000 $205,920 Check Amount + ReSet Inputs Fix the Format of All White Cells Cash Payments for Direct Labor - for the Cash Budget 1st Qtr. 2nd Qtr. Total Cash Payments for Direct Labor * | $43,200 $40,320 3rd Qtr. 4th Qtr. $58,400 $ 64,000 * MyArmor pays all direct labor cost in the period incurred; thus Total Cash Payments = Total Direct Labor $'s Selling, General, and Administrative (SG&A) Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget Quarter in the 2021 Planning Year 2nd 3rd Full Year Total 1st 4th 12,000 units $6 per unit $72,000 10,000 units $6 per unit $60,000 14,000 units $6 per unit $84,000 16,000 units $6 per unit $96,000 SG&A Variable Cost Sales in Units (from Sales Budget) times Variable SG&A Cost per Unit Sold Total SG&A Variable Cost SG&A Fixed Costs Advertising Cost Salary Cost Mall Kiosk Rental Cost Utilities Cost Property Taxes Depreciation Total SG&A Fixed Cost $5,000 40,000 1,000 1,000 0 12,000 $59,000 $5,000 40,000 1,000 1,000 12,000 12,000 $71,000 $15,000 45,000 2,000 2,000 0 13,000 $77,000 $15,000 45,000 2,000 2,000 12,000 14,000 $90,000 $131,000 Total SG&A Cost $131,000 Check Amounts + ReSet Inputs $161,000 $186,000 $609,000 ReSet Inputs All Check Amounts OK Full Year Total Fix the Format of All White Cells Calculation of Cash Payments - for the Cash Budget 1st Qtr. 2nd Qtr. Total SG&A Cost (per above) $131,000 $131,000 less Depreciation Included in Total SG&A Cost () ($12,000) ($12,000) Total Cash Payments for SG&A $119,000 $119,000 Check Amounts ReSet Inputs 3rd Qtr. $ 161,000 ($13,000) $ 148,000 ReSet Inputs 4th Qtr. $186,000 ($14,000) $172,000 ($51,000)
