Can you show how to calculate the values. Thank you!

INFORMATION FOR IIEDRON, INC Hedn, sa Hedron has no manufacturing related costs HranInc is a campany that re-sells one pradurt, a particularly coenfortable lawn chair An averseas cantractor makes the product exclusively PRODUCT COSTS er umt Per an existing cantract the cost of each chair is scheduled to merease by 5% an May 1, 2020 In addtion, because of increasing onsts of plastic wrbhing, the cost is antcipated to merease h In Nov of 2019, each lawn chair costs Hedron $4 an additional 5% on Set . 2020 PRODUCT SALES Hadron sells onch chair for $10 per unit. Prujected Sales units font ... 019 11,250 Der 11.600 2020- Ma 12.600 Ape 15.000 3000 Jul 18.000 17.00 Oct 16.500 2021 Jar 11.000 e sales price to S11.25 per unit beginning Sept 1, 2020. The sales forccast (ic, estimatod sales To offsct increasing costs of the chairs, the company plans to raisc n units) takes this price incrcase into account CREDIT SALES aalos 20% month of sale, 50% are collected the followine month, and 16 % are collected the 2 month after sale. The remainine receivables are deemed uncollectible at the end of tihe 2nd month after sale Bad dchts are vritten off in the month the deht is decmed uncollectible PRO. n's role reaantine inventory is e next month Hedron uses the firt-n first-out (FIFO) method in accounting maintam their stock (e have m ending mvemtary t 40% of the forecasted sales n unats fior r mventones 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 equpent prevusly purchased is due in Jarnury and anther Note payment af $30,000 is due m Feknary. There are no Note Payables at the ed af 2020. OPERATING EXPENSES Munthly Cash expeises -d wn d Salary and Wage Exp Sales Commiasions Exp Reat Exp $3.000 % of sales revenue S8,000 de Variable Exp 6% c $2 000 $24 000 Supplies Exp Gen & Admin Fixed Exp Gen & Admin Depreciation Exx $24,000 Cash expesare paid when incurred CASIH MANAGEMENT The company must maintain a minimum cash balance of $15,000. Borrowing can make up sbortfalls For simplicity, assume that the bank will only lend (and accept repayments) in $1,000 increments. enore interest on the loans, but minimize the amount borrowed and off amy los spon as sibl DIVIDENDS Dividends of S12.000 are paid in July BALANCE SHEET Balance Sheet balarces as of Decenber 31, 2019. 15,000 Acccunts Receivable $75.590 Supplies Merchamdhse Inventery S 2,000 $16,000 Accumlated Depreciation Accounts Payable $ 526,475 $ 26.304 S 200 000 Retained Earmines $322,811 CHECK FIGURES Cash Colletons Budant s 104.200 Total Cash Receipls fie Jurnury S1,835 3150 2020 d Debt Tve for nuxnn Bad Deht Exp, Total 2020 51.951 S Purchase Budu Cost of Purchases foe Dec 2020. 52.479 Operating Expense Budget Cash disbursnents for Op Exp fir Dee S 55.281 Cash Budet Total cash available, Summary Total Caah Disbursements, Summary Ending S1,850,333 s1,549,658 Balance for Dec Budgeted Inco $1.131.388 S 768.112 S 103.113 Cost of Goods Sold Total Net Income. Total: Budgeted Balance Sheet Total Assets Dec 2020 s 615.411 M Hadr Sales Budget For Year Endng Dec , 2020 Nov 1350 Sep Jan 21 De Feb Mar May 18 000 Jul 2 11600 8 CO0 Budoed unt sales Seling pnce par unt Total Sales 10.00 S 16,000 10.00 114,000 5 10 00 10.00 10.00 S 20,000 10.00 10.00 10.00 S 10.00 S 10.00 11.25 .11.25 s ,625 $ 11.2 S 35,000 5 11.25 40,625 $ 2010,600 156,000 180,000 180000 $ 180,000 $ 191,250 12.500 100.000 S 20,000 54 000 40.500 5 42 188 s 30.000 5 54,000 $ Cash Sales Credt Sales Tos Sales 33.750 34.800 34 200 5 36.000 46,800 66 000 $ 54.000 67,375 S 55.688 606.550 136,220 741,770 20 12600 6.600 S 900 37.000 S 6.600 $ Current month AR Collections 1 manth prer AR Collachions 2 months ealectble 21 A Hadron, Ins Ft Year Endirg Cec 31, 2020 Annual Iotal Jul 20 Jan 20 Fab '2 Mar 20 Apr 20 May 2 un 2 Aug 2 Sep 20 ct 20 Nov 2 Lec 20 Curert morch cesh Sales morth per por AH Colactions m Dad Debt Expense Desed endng inventory % 40% Hedron, Inc. ... For Year Fudne Dec 31, 2020 Ecb 20 Mar 20 May 20 Nov 19 Dec 15 Jun 2 d 20 Aug 20 Sep 2 Oct 20 Nov 20 Dec 20 n 20 Apr 20 Summary Add nd lion mtory Total unk needs R iadnt Cost per urit Cost of Purchases 52,479 P M N & Paid in Month cf Purchase 40% Faid in Month ater Purchase 60% Hedron, Inc Schedule of Budg or Year Ending Dec 31, 2020 r Merchandise Purchases ont May 20 Nov 20 Jan 20 Fab 20 Mar 20 Apr 2 Jun 20 Aug 20 Sep 20 Oct 21 Dec 20 Annual Total l 20 Csmi AP Payments Cash dsbursements for merchandise purchases Fix- anand ag Exp ratin Sales Commus.n Eve Gen & Admn Variable Exp ct Reuque S 3,000 ef Revenue 00 Gen & Admin Fixed Exp Gan & Admin Depraciation Exp 24,000 24 C00 T Operating Expense Budoot For Year Ending Dec 31, 2020 Or: 20. Dec 20 3 D00 Annual Total Apr 20 May 20 Jun 20 Sep 20 Feb 20 Mar 2 Jul 2 3 000 Aug 20 Nov 20 Jan 20 3 000 9 3 000 5 3 000 5 3 000 5. 3 000 5 3 D00 s SuCurriai Exn Re Vanable Exp Supplies Exp Gen & Dearociation Exp R ... Less: Depreciation Exp (nonzzsh) Cash Dsbursemonts for Operating Expenses Note payment Cquipment January 50,000 ment Eouipmant- Februare 12 000 Minimum Monthly Cash Budgct 15,000 D E E G H N o P Hedron, Inc. For Yaa Eodng Den 31 2020 Feb 20 Mar 21 May 2 Jun 20 Oct 21 Nov 20 Dec 20 Jan '2 Apr 2 l 2 Aug 22 Sep 20 Summary Cash balanca, bagening 102 Jan 1st Balance customers mcustomers Trtal cash aeiltle esi sh tamants toe merchandisa purchasas Ca Disbursements for Operaling Expenses Equipm 10r 109 Dividonds e of uceets er dabursements 12 Hapaymants-nate Cash balance, cnding 114 11 Inpctrey Data COGS Calculation using FIFO Cost Assumption Encing meatory Eag Invantary Hag vamary Purchasas Furchasas Urits Unt: Mar 127 May 129 134 130 Hedron, Ino Cor Year Endee Dee 11.2020 Feb 20 May 20 Dec 20 Annual Tolul Jan 20 Ma 20 Apr 20 Aug 21 Sep 20 Oct 20 Nuv 2 20 14: ales sold ... Goes Prote lua pe ome 14 Hedron c Cph Budpe For ar Ending Dec 81, 2000 100 A20 Sep 20 Nov 20 Dec 20 Jn 20 Feb 20 My 20 Apr 20 May 20 Jun 20 J200 Oct20 Sumy 101 102 Cah badaxe, bepreng T05 Less distuusenents 100 Cash disbasents for reaschendse paches Cash Disbaents for Opeating Epnes 107 Note Payrens-ben Dicends 110 Tol ch dsursernb 111 Excess of receipts ower disbansensents 112 Feascing 113 Boroing-aote 114 Rapayeso 115 Cash balace, eedng 108 116 Hedron i 111 118 Inentory Dali coGs Cacason using RFO Cost Assarption 115 Esig weery bing weony Uss 12 Beg ivensory Be vestry Purdses Pchases coos coas 177 uss 1t9 INFORMATION FOR IIEDRON, INC Hedn, sa Hedron has no manufacturing related costs HranInc is a campany that re-sells one pradurt, a particularly coenfortable lawn chair An averseas cantractor makes the product exclusively PRODUCT COSTS er umt Per an existing cantract the cost of each chair is scheduled to merease by 5% an May 1, 2020 In addtion, because of increasing onsts of plastic wrbhing, the cost is antcipated to merease h In Nov of 2019, each lawn chair costs Hedron $4 an additional 5% on Set . 2020 PRODUCT SALES Hadron sells onch chair for $10 per unit. Prujected Sales units font ... 019 11,250 Der 11.600 2020- Ma 12.600 Ape 15.000 3000 Jul 18.000 17.00 Oct 16.500 2021 Jar 11.000 e sales price to S11.25 per unit beginning Sept 1, 2020. The sales forccast (ic, estimatod sales To offsct increasing costs of the chairs, the company plans to raisc n units) takes this price incrcase into account CREDIT SALES aalos 20% month of sale, 50% are collected the followine month, and 16 % are collected the 2 month after sale. The remainine receivables are deemed uncollectible at the end of tihe 2nd month after sale Bad dchts are vritten off in the month the deht is decmed uncollectible PRO. n's role reaantine inventory is e next month Hedron uses the firt-n first-out (FIFO) method in accounting maintam their stock (e have m ending mvemtary t 40% of the forecasted sales n unats fior r mventones 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 equpent prevusly purchased is due in Jarnury and anther Note payment af $30,000 is due m Feknary. There are no Note Payables at the ed af 2020. OPERATING EXPENSES Munthly Cash expeises -d wn d Salary and Wage Exp Sales Commiasions Exp Reat Exp $3.000 % of sales revenue S8,000 de Variable Exp 6% c $2 000 $24 000 Supplies Exp Gen & Admin Fixed Exp Gen & Admin Depreciation Exx $24,000 Cash expesare paid when incurred CASIH MANAGEMENT The company must maintain a minimum cash balance of $15,000. Borrowing can make up sbortfalls For simplicity, assume that the bank will only lend (and accept repayments) in $1,000 increments. enore interest on the loans, but minimize the amount borrowed and off amy los spon as sibl DIVIDENDS Dividends of S12.000 are paid in July BALANCE SHEET Balance Sheet balarces as of Decenber 31, 2019. 15,000 Acccunts Receivable $75.590 Supplies Merchamdhse Inventery S 2,000 $16,000 Accumlated Depreciation Accounts Payable $ 526,475 $ 26.304 S 200 000 Retained Earmines $322,811 CHECK FIGURES Cash Colletons Budant s 104.200 Total Cash Receipls fie Jurnury S1,835 3150 2020 d Debt Tve for nuxnn Bad Deht Exp, Total 2020 51.951 S Purchase Budu Cost of Purchases foe Dec 2020. 52.479 Operating Expense Budget Cash disbursnents for Op Exp fir Dee S 55.281 Cash Budet Total cash available, Summary Total Caah Disbursements, Summary Ending S1,850,333 s1,549,658 Balance for Dec Budgeted Inco $1.131.388 S 768.112 S 103.113 Cost of Goods Sold Total Net Income. Total: Budgeted Balance Sheet Total Assets Dec 2020 s 615.411 M Hadr Sales Budget For Year Endng Dec , 2020 Nov 1350 Sep Jan 21 De Feb Mar May 18 000 Jul 2 11600 8 CO0 Budoed unt sales Seling pnce par unt Total Sales 10.00 S 16,000 10.00 114,000 5 10 00 10.00 10.00 S 20,000 10.00 10.00 10.00 S 10.00 S 10.00 11.25 .11.25 s ,625 $ 11.2 S 35,000 5 11.25 40,625 $ 2010,600 156,000 180,000 180000 $ 180,000 $ 191,250 12.500 100.000 S 20,000 54 000 40.500 5 42 188 s 30.000 5 54,000 $ Cash Sales Credt Sales Tos Sales 33.750 34.800 34 200 5 36.000 46,800 66 000 $ 54.000 67,375 S 55.688 606.550 136,220 741,770 20 12600 6.600 S 900 37.000 S 6.600 $ Current month AR Collections 1 manth prer AR Collachions 2 months ealectble 21 A Hadron, Ins Ft Year Endirg Cec 31, 2020 Annual Iotal Jul 20 Jan 20 Fab '2 Mar 20 Apr 20 May 2 un 2 Aug 2 Sep 20 ct 20 Nov 2 Lec 20 Curert morch cesh Sales morth per por AH Colactions m Dad Debt Expense Desed endng inventory % 40% Hedron, Inc. ... For Year Fudne Dec 31, 2020 Ecb 20 Mar 20 May 20 Nov 19 Dec 15 Jun 2 d 20 Aug 20 Sep 2 Oct 20 Nov 20 Dec 20 n 20 Apr 20 Summary Add nd lion mtory Total unk needs R iadnt Cost per urit Cost of Purchases 52,479 P M N & Paid in Month cf Purchase 40% Faid in Month ater Purchase 60% Hedron, Inc Schedule of Budg or Year Ending Dec 31, 2020 r Merchandise Purchases ont May 20 Nov 20 Jan 20 Fab 20 Mar 20 Apr 2 Jun 20 Aug 20 Sep 20 Oct 21 Dec 20 Annual Total l 20 Csmi AP Payments Cash dsbursements for merchandise purchases Fix- anand ag Exp ratin Sales Commus.n Eve Gen & Admn Variable Exp ct Reuque S 3,000 ef Revenue 00 Gen & Admin Fixed Exp Gan & Admin Depraciation Exp 24,000 24 C00 T Operating Expense Budoot For Year Ending Dec 31, 2020 Or: 20. Dec 20 3 D00 Annual Total Apr 20 May 20 Jun 20 Sep 20 Feb 20 Mar 2 Jul 2 3 000 Aug 20 Nov 20 Jan 20 3 000 9 3 000 5 3 000 5 3 000 5. 3 000 5 3 D00 s SuCurriai Exn Re Vanable Exp Supplies Exp Gen & Dearociation Exp R ... Less: Depreciation Exp (nonzzsh) Cash Dsbursemonts for Operating Expenses Note payment Cquipment January 50,000 ment Eouipmant- Februare 12 000 Minimum Monthly Cash Budgct 15,000 D E E G H N o P Hedron, Inc. For Yaa Eodng Den 31 2020 Feb 20 Mar 21 May 2 Jun 20 Oct 21 Nov 20 Dec 20 Jan '2 Apr 2 l 2 Aug 22 Sep 20 Summary Cash balanca, bagening 102 Jan 1st Balance customers mcustomers Trtal cash aeiltle esi sh tamants toe merchandisa purchasas Ca Disbursements for Operaling Expenses Equipm 10r 109 Dividonds e of uceets er dabursements 12 Hapaymants-nate Cash balance, cnding 114 11 Inpctrey Data COGS Calculation using FIFO Cost Assumption Encing meatory Eag Invantary Hag vamary Purchasas Furchasas Urits Unt: Mar 127 May 129 134 130 Hedron, Ino Cor Year Endee Dee 11.2020 Feb 20 May 20 Dec 20 Annual Tolul Jan 20 Ma 20 Apr 20 Aug 21 Sep 20 Oct 20 Nuv 2 20 14: ales sold ... Goes Prote lua pe ome 14 Hedron c Cph Budpe For ar Ending Dec 81, 2000 100 A20 Sep 20 Nov 20 Dec 20 Jn 20 Feb 20 My 20 Apr 20 May 20 Jun 20 J200 Oct20 Sumy 101 102 Cah badaxe, bepreng T05 Less distuusenents 100 Cash disbasents for reaschendse paches Cash Disbaents for Opeating Epnes 107 Note Payrens-ben Dicends 110 Tol ch dsursernb 111 Excess of receipts ower disbansensents 112 Feascing 113 Boroing-aote 114 Rapayeso 115 Cash balace, eedng 108 116 Hedron i 111 118 Inentory Dali coGs Cacason using RFO Cost Assarption 115 Esig weery bing weony Uss 12 Beg ivensory Be vestry Purdses Pchases coos coas 177 uss 1t9