Can you show how to calculate the values for Cash collection Budget, Operating Expense Budget and Cash Budget Tables. Thank you in advance.

INFORMATION FOR IEDRON, INC. Hedon, Inc. is a company that re-sells one product a partcularly confortabile lawn chur. An overseas contractor makes the product exclusively for Heckan, sa Hect has to manufacturing related costs PRODUCT COSTS In Now of 2019, rach lawn chair costs Hedon S4 per imit Per an existing contract the cost of each chair is scheduled to crease by 5% on May 1, 2020 In adition, because of increasing costs of plastic webbing the cost is anticipated to crease by an additional 5% on Sept 1.2020 PRODUCT SALES Hadron sells each chair for $10 per mit Projected Sales ums Ycar 2019 2020 Month NOV Dec Jan Feb Mar Alpe May Amt 11.250 11.600 10.000 11.400 12.600 115.000 18.000 22.000 18000 18.000 17.000 16,500 12000 12.500 | 11.000 Jul Avg Oct New Der Jan 2021 To offset increasing costs of the chairs, the company plans to raise the sales price to S11.25 per unit beginning Sept 1, 2020. The sales forecast (ic, estimated sales in units) takes this price increase into account CREDIT SALES Monthly sales are 30% cash sales, 70% credit sales. 30% of credit sales are collected in the month of sale, 50% are collected the following month and 16% are collected the 2-month after sale. The remaining receivables are deemed uncollectable at the end of the 2nd month after sale. Bad delats are written oft in the month the debt is deemed collectible PRODUCT INVENTORY The firm's policy regarding inventory is to maintain their stock (1e have in ending m entary) at 40% of the forecasted sales in units for the next month. Haikonises the first-, first-out (FIFO) method in accounting for inventones 40% of the inventory purchases are paid in the month of purchase with the remaining 60% paid the following month EQUIPMENT A Nate payment of $50,000 for Equment previously purchased is dun in January and another Note payment of $30,000 in dun in Felmary. There are no Note Payables at the end of 2020 OPERATING EXPENSES M ithly Cash experies are paid when incurred Salary and Who Exp Sales Commissions Exp Reut Exp Gen & Adhuri Variable Exp Supplies Exp Cien & Admin Fixer Ext Gen & Admin Depreciation Exp $9,000 7% of sales revenue $8.000 6% of sales revenue $2,000 $24000 $24.000 (Cash experter care paid when incurred) CASII MANAGEMENT The company must maintain a minimum cash balance of $15,000. Borrowing can make up sbortfall. For simplicity pay off any loans In A Dossible) sure that the bank will only lend (And nocent repayments) in $1.000 increments Tonom interest on the loans bent minimize the amount borrowed and DIVIDENDS Dividends of $12,000 are paid in July BALANCE SHEET Balance Sheet balance of December 31, 2019 Cash $ 15,000 Accounts Receivable $ 75,590 Supplies $ 2.000 Merchandise Inventory $ 16.000 Duildines and Equipment $ 1.050.000 Accumulated Depreciation 5 526 475 Accounts Payable $ 26,304 Notes Payable $ 80,000 Capital Stock $ 200.000 Retained Lamines $322.811 CHECK FIGURES Cash Collections Rudiget Total Cash Receipts for Turmury: Total Cash Receipts, Total 2020. Bad Debt Exp for January Bad Deht Exp. Tatal 2020- $ 104,200 $ 1,835,333 $ 3.150 $ 51.951 Purchase Budget Cost of Purchases for Dec 2020. S 52,479 Operating Expense Budget Cash disbursements for Op Exp for Dec $ 55,281 Cash Budget Total cash available, Summary $ 1,850,333 Total Cash Disbursements, Summary: $1,549,658 Ending Cash Balance for Dec: S 300,676 Budgeted Incoane Statement Gross Profit. Total: Cost of Goods Sold Total Net Income, Total: $ 1.131.388 $ 268,112 $ 109,113 Budgeted Balance Sheet Total Assets Dec 2020: $ 615,411 Jan 21 11.000 Nov 19 11.250 10.00 112.500 Budeed unt sales Saling page par unit Total Sales Dec 19 11.000 10.00 S 116.000 5 Jan 20 10,00D 10.00 100,000 Feb 20 11,400 10.00 $ 114.000 $ Me 20 12.000 10.00 20.000 Hudson, Inc. Sales Budget For Year Ending Dec 31, 2020 Jun 20 J 20 Aug 20 22,000 18.000 18,000 10 $ 10.00 10.00 220.000 $ 0.00 $ 100,000 Aur 20 15.000 0.00 $ 150.000 $ May 20 18.000 10.00 $ 100.000 $ Sep 20 17.000 11.25 $ 191,250 $ Oct 20 16,500 112 105,62% $ Ny 20 12.000 1126 350.00 Dec 20 Annual Total 12.500 194.GOD 1125 140.625 3 2018.500 $ $ $ $ $ $ $ $ Cash Sales Credt Sales 30% 33.750S S 55,688 8 Cash Sales Credt Sales Tote Sales 30,000 S 7.000 37.000 S 34.200 S 7900 42.180 S 7.875 35.000 $ 8.400 44.400 $ 46,800 5 10,920 57.7205 1 8. 120 42.9205 64,000 2.GOD 66 600 88 ANS 54,000 5 12.600 66.6005 67,375 5 11,900 69.2755 42,188 5 8,750 S 11.592 606,650 136,220 673 Current month AR Collections 1 month prior AR Collechons 2 months prior Ar Collections Uncollectible Hadiren Inc Cash Collections Budget For Year Ending Dec 31, 2020 Jan 20 Feb 20 Mar 20 Apr 20 May 20 Jun 20 Jul 20 Aug 20 Sep 20 Oct 20 Nov 20 Dec 20 Annual Total Current monchuh Sales Current month AR Collections 1 month prior NR Collections 2 months por A Collections Total cash collections Bad Dobt Espenze Desired ending inventory Tiedon nc Purchase Hudget For Year Ending Dec 31, 2020 2020 Nov 19 Dec 19 Jan 20 Feb 20 Mar 20 Apr 20 May 20 Jun 20 Jul 20 Aug 20 Sep 20 Oct 20 Nov 20 Dec 20 Summary Hudsed unt RAR Add deyirding teritory Total unit needs Loss Beginning inventory Required Unit Purchases Cost per unit Cost of Purchases * Paid in Month of Purchase % Paid in Month at Purchase Hedron, Inc. Schedule of Budgated Cash Disbursements for Merchandise Purchases For Year Ending Dec 31, 2020 Jan 20 Feb 20 Mar 20 Apr 20 May 20 Jun 20 Jul 20 Aug 20 S ep 20 Oct 20 Nov 20 Dec 20 Annual Total Cash purchases 1 month prior AP Payments Cash disbursements for merchandise purchase Variable Operating Expenses: Sales Commission Expe of Revenue Gan & Admin Variable Exp % of Revenue Fixed Operating expenses: Salary and Wage Exp Rent Exp Supplies Exp Gon & Admin lixed Exp Gen & Admin Depreciation ExpS $ 5 5 $ 3.000 8000 2,000 24,000 24 000 Hedron, Inc. Operating expense Budget For Year Ending Dec 31, 2020 Dec 20 Ann Jan 20 feb 20 Mar 20 Apr 20 May 20 Jun 20 Jul 20 Aug 20 Sep 20 Oct 20 53000 53000 53000 53000 53000 53000 53000 53000 53000 53,000 $ Nov 20 3,000 Salary and Waga Exn Sales Commission Exp Rent. Exp Gan & Admin Variable Exp Supplies Exp Gen & Admin Fixed Exp Gon & Admin Depreciation Exp Had Det Exp Tulal Operating Exp Less: Depreciation Exp inoncash) LARS Had Debt Exp inancash) Cash Disbursements for Operating Expenses 50.000 30 000 5 Note payment Ecuipment - January Note payment Equipment Fahniky Dividendy - Jul Minimum Monthly Cash Budget 12.000 15.000 Hedron, Inc. Cash Budget For Year Ending Dec 31, 2020 Jan 20 Feb 20 Mar 20 Apr 20 May 20 Jun 20 Jul 20 Aug 20 Sep 20 Oct 20 Nov 20 Dec 20 Summary Jan 1st Balance Add colections from customers Total cash available 104 107 Cash balance, beginning And collections from customers Tutal cash available Less cisbursements: Cash disbursements to marchandise purchases Cash Disbursements for Operating Expenses Nute Payments - Equipment Dividends Total cash disbursements Excess of receipts over de bursements Financing Lorrowing note Repayments Cash balance, ending 109 110 111 112 115 116 scron, Inc. Imatory Data 118 COGS Calculation using FIFO Cost Assumption Beq Inventory | Haq Inventory Purchase Purchases OOGS C OGS Cncing inventory imatory 131 136 137 130 Hecten. Ine Budgeted Income Statement For Year Ending Dec 31, 2020 Ma: 20 Apr 20 May 20 Jun 20 Jul 20 Aug 20 - 20 Dec 20 Annual Total 141 143 144 145 Sales Cost of goods sold: C Profit Tul Operating Exp Net Operating incomA Hedron, Inc. Budgeted Balance Sheet As of Dec 31, 2020 149 150 2019 2020 153 151 152 Assets Current Assets 154 Cash 155 Accounts receivable Supplies 157 Merchandise Inventory 158 Plant and Equipment: 159 Buildings and Equipment Accumulated Depreciation 161 Total assets 15,000 75,590 2,000 16,000 156 $ $ 1,050,000 526,475 160 $ 645,411 162 163 Liabilities and Equity 164 Accounts Payable Notes Payable 165 $ $ 26,304 80,000 166 167 Capital stock 168 Retained earnings 169 Total liabilities and equity $ $ 200,000 322,811