Please solve yellow empy spots . answers must be written in formula only

Custom 29 CM G K D F Sales Bug For the mos ndng e 30, 2016 6 Nov 2017 72.000 10.00 S 120.000 Dec 2017 13,000 10.00 30 000 Jan 2018 Feb 2018 Mar 2018 Aroa 9.000 10.000 13.000 TA DOO 10000 1000 10.00 90000000000 150.000 ufactur st of God lanufactu ling & Ac dgeted in ash Budge Be able to archandise Dudgeted May 2018 Aan 2018 2000 TATOO 1000 11.00 11 DO TOO 19.000 Budged un Seliny pre per unit 10 Talles Rever 11 12 Cash Sa 13 Credits 14 15 C 1. CatSales 17 Tota: Sales Revenue 10 19 20 Current AR Collections month prior AR Collections months prior AR Colecione 24 $ 72.000 48.000 720.000 75.000 $ 12.000 130.000 $ 54 DO 5 16.000 10.000 60,000 1 78.000 40 DOO 52,000 100,000 $138.000 sales 60.000 0 000 $ TOTTA 2008.000 200 200 048.400 100000 1,000 5 000 5 20% 70% SON Herren Cash Collector For the meaning in 300 Jan 2018 Feb 2011 M2016 17.00 720 2.000 18.400 25.00 22 28 29 Current month 30 Cofrece made them Corector of credit sales maman Budget A 204 000 12,000 36.400 May 2018 TO 13.00 2018 TIRES 15.40 120 18.4134 42.000 MacBook Pro Anal 10 B 2 Custom * CAS K M B D 24 G 1 25 Haren Ina 26 Cath Collections 27 For the mos ringane 30, 2018 26 29 Curre months Jan 2018 Feb 2018 Mar 2018 Apr 2016 May 2 Jun 2018 monta 54.000 30 Collections of this month 60/600 78.000 50.000 118.800 8.800 00 7.200 8.000 19.40 52 000 151140 31 Collections of urdmade tanto 15.540S 09.200 36.400 25.200 28,000 35.400 32 Collections of made morth 42,000 36.440 $223,440 4.800 5.200 3.800 33 4,000 5.200 Totalcash collection 6,000 $28,000 1027,4005 93,400 120.000 34 167400 101, 105 196,000 141,120 35 Desed ending wity 300 of name 36 37 Heren in 38 Purch Budget 39 For the mange 2010 40 41 Nov 2017 Dec 2017 Jan 2018 Feb 2018 Mar 2011 Apr 2011 May 2016 Jun 2018 42 Budged units 127000 WOO 10.000 3000 15 000 TO 1.000 2000 43 Ads desired ending invory 3,000 3.500 2.To Wood 3000 4 500 8.400 5.400 24.900 4 needs 15600 11,700 13000 TO 16500 23:40 21400 10000 49 Loss Beginning inventory 50, 500 11.700 Required Purchases 13.000 1600 10 500 33700 107 211430 42 45 Cost per un 5 $ $ 49 Total phases.cost 50 51 Pa Mormofuchas Dudget Too re Arial 10 B Custom C40 M 47 43 Coster 4 Total che cost 50 PM of Purch 52 Pin Month Phase 0 Tos be ere bud So Budges Castro Merchandise For the go.2014 2018 F204 Mw 2018 6740 TI 240 49.560 1000 4576 1003 M YOO 59 for current month purch 66 Payment for month purchase Cashdissement for merchases Aer 2018 52,170 May 2010 2018 17400 OTVO 1600 13.00 1700 5 3:22:23: Food Orange 65 Sand Wages Rentap 6 Sense One bed Depan 70 Vappen 17.000 anos 6,000 2000 5.000 2500 Og de Budget For the 2011 Budo MacBook Pro A Yustom 2. A4 A CAS G M D - Opening ExpenBudget For the mos ending June 30, 2018 72 73 74 75 76 Sales and Expen 77 Sales Com 78 Repen Supplies Eupen 30 Overhead Express 31 Depecoense Total operating expert 83 Surat non-cheese 04 Depreciation 85 wishes BG Jan 2018 Feb 2018 Me 2018 Ar 2018 May 2015 Jan 2018 metal 17000 17 od 5 177000 17.000 5 17.000 5 17.000 09.000 6.100 0.100 7.000 10.500 13 MO 12.000 60.00 6,000 0.00 0.000 6.000 6,000 6.000 Jid 2.000 2000 2.000 2.000 2.000 2,000 12.000 5000 5.000 6.000 5.000 5.000 5.000 30,000 2.500 2.600 2.500 2.000 2.500 15.000 30.000 160 40 60 255.00 2.500 2.500 7.000 2500 2.500 2.500 18.000 300 17.000 ONE Donec OR S DOS DO OPONERE NIE 06 Cash For the ending June 10, 2018 2014 Feb 2018 Mw 2016 Apr 2018 6. 30.00 5205 30.10 500 400 6400 120.000 400 117400 26 1500 May 2010 Jan 2013 340 Od 1.30 20 TO NOWE TO NO 92 Cash 31 Aastrum Toulable 95 Cassante Cash Outpulchases 97 Cash for operating experts Total chrome 99 Cache blonding Butot 102410 467600 DUL OWE 1.000 001 300 10260 14800 800 40 60 THE BCVO ODP PESOS 0900 185 336 500 11.160 WER 17200 MacBook Pro 049 D G E 33.520 M 14.00 41160 46 120 63.120 127.00 146.800 16,000 1.000 11.000 2.000 50,000 305200, 160 550 S 12.000 83220 112788000 Morening Budgeted incontestar For the mosending Jun 30, 2018 99 Cow balance beton financing 100 Franding 101 Borrowing repaymentyrte payable 102 Ch balance, ending 10 104 105 106 107 108 109 110 Sales, no 111 Cost of Good Sold 112 Gross margin 113 Total operating expenses 114 Mat income 115 116 Heron in 117 Budged Serk of Rintained inge 118 For the most ending June 20, 2016 119 120 ined Earnings beginning 121 Add Not income 122 Betained Earrings, endine 123 124 Heron in 135 Budgled Balance She 126 Ane 30, 2014 Budget Jan 2018 Feb 2018 Mw 2018 Ape 2018 May 2018 hun 2018 6. 90000 100.000 130 000 100003 198,000.00 66.000 55 800 85.400 81.600 95.400 100.000 105 200 512.400 $ 342605 4600 4400 545005 1,000,000 351600 35100 9.500 41.600 42.000 46.360 255.00 15 2003 05 GOOS 111001 41.64034505 11:10 350.040 Can MacBook Pro D 360,040 B 117 Budgeted Statement of Retained Earnings 118 For the 6 mos ending June 30, 2018 119 120 Retained Earnings, beginning 121 Add Net Income 122 Retained Earnings, ending 123 124 Heron, Inc. 125 Budgeted Balance Sheet 126 As of June 30, 2018 127 128 Assets: 129 Current Assets: 130 Cash 131 Accounts Receivable Office Supplies 133 Merchandise Inventory 134 Total Current Assets 135 Plant and Equipment: 136 Buildings and Equipment 137 Accumulated Depreciation 138 Total Plant and Equipment 139 Total assets 140 141 Liabilities 142 Accounts Payable 143 144 Equity = Budget + 132 Calculation Mode: Automatic Workbook Statistics te u Saved File Home Insert Draw Page Layout Formulas Dal Arial V 10 V B 9 ft B 30 29 Current Assets: 30 Cash 31 Accounts Receivable 32 Office Supplies 33 Merchandise Inventory 34 Total Current Assets 135 Plant and Equipment: 36 Buildings and Equipment 537 Accumulated Depreciation 138 Total Plant and Equipment 139 Total assets 140 141 Labilities 142 Accounts Payable 143 144 Equity 145 Common Stock 146 Retained Earnings 147 Total Equity 145 Total liabilities and equity 149 150 151 152 153 154 155 156 Budget CMA Woche esc 80 F2 DOD 000 13 74 1 N @ 2 # 3 $ 4 Q WFT D Check figures are also located under "Comprehensive Problem 2* in Blackboard INFORMATION FOR HENRON, INC. BUDGET PROJECT 1. Horon, Inc. is a company that re-sels one product, a lawn chair. A contractor makes the product exclusively for Heron, so Heron has no manufacturing costs Henron sells each chair for $10 per unit, but plans to raise the sales price to $11.00 per unit beginning May 1, 2018 2. The estimated sales in units) are as follows: Nov 17 Dec 17 Jan 18 Feb 18 Mar 18 Apr 18 May 18 kn 18 Jul 16 12,000 13,000 9,000 10,000 13.000 15,000 18.000 18,000 17.000 3. They expect that 50% of any month's sales are for cash, and the remaining 40% are on credit of the credit scles, they expect to colect 20% in the month of the sale 70% in the following month, and 10% in the month after that 4. The firm's policy regarding inventory is to stock (le have in ending Inventory) 30% of the estimated sales for the next month 5. Each lawn chair costs Henron $6. They plan to pay for 30% of the inventory purchases in the month of purchase and pay the remaining 70% the following month (le all of the previous month's Accounts Payable are paid off by the end of any month) Page 12 6. Monthly operating expenses consist of the following (any cash exponses are paid as incurred) MacBook Pro 22 100 6. Many operating expenses consist of the following the Salaries and Wages Expense $17.000 Sales Commissions ove Rent Expense 58.000 Supplies Expense $2.000 Omer Overhead Expense $5,000 Depreciation Expense $2.500 7. Henron must maintain a minimum cash balance of 530,000. Borrowing can make the For simplicity assume that the bank wil only tend and accept payment 1.200 increments on interest on the loan in your calcions, but only bow what you need pay off any loans as soon as possible & Cash on hand as of December 31, 2017 expected to be $15.000 MB notes payable on balances of this date 9. See below the other Balance Sheet accounts with their best beginning of the year Buildings in En 31.050,000 Acumulated Deprecation 5 520.000 Not Your Common Shock $ 200.000 depreciation and der Retained Earnings $360040 ruction units budget budgeted and Materials: Meeded budgeted end, ww material needed budgeted production ct Labor Budget budgeted production nufacturing OH Budget budgeted product st of Goods Sold Budget budgeted anufacturing cost per unit includes OM DL ting & Admin Exp Budgets dgeted Income Statement Sales revenue Budget: Beg cash babudgeted collect Beste toate budgeted collections Perchandise Purchases budget for me budgeted unit budget and Inventory 10 Herron maintains office wol of $2.000 at the end of each month 11. Accounts receivable consists of the credit have not been received Accounts payable connects of invertory purchase that have not yet been paid MacBook Pro Custom 29 CM G K D F Sales Bug For the mos ndng e 30, 2016 6 Nov 2017 72.000 10.00 S 120.000 Dec 2017 13,000 10.00 30 000 Jan 2018 Feb 2018 Mar 2018 Aroa 9.000 10.000 13.000 TA DOO 10000 1000 10.00 90000000000 150.000 ufactur st of God lanufactu ling & Ac dgeted in ash Budge Be able to archandise Dudgeted May 2018 Aan 2018 2000 TATOO 1000 11.00 11 DO TOO 19.000 Budged un Seliny pre per unit 10 Talles Rever 11 12 Cash Sa 13 Credits 14 15 C 1. CatSales 17 Tota: Sales Revenue 10 19 20 Current AR Collections month prior AR Collections months prior AR Colecione 24 $ 72.000 48.000 720.000 75.000 $ 12.000 130.000 $ 54 DO 5 16.000 10.000 60,000 1 78.000 40 DOO 52,000 100,000 $138.000 sales 60.000 0 000 $ TOTTA 2008.000 200 200 048.400 100000 1,000 5 000 5 20% 70% SON Herren Cash Collector For the meaning in 300 Jan 2018 Feb 2011 M2016 17.00 720 2.000 18.400 25.00 22 28 29 Current month 30 Cofrece made them Corector of credit sales maman Budget A 204 000 12,000 36.400 May 2018 TO 13.00 2018 TIRES 15.40 120 18.4134 42.000 MacBook Pro Anal 10 B 2 Custom * CAS K M B D 24 G 1 25 Haren Ina 26 Cath Collections 27 For the mos ringane 30, 2018 26 29 Curre months Jan 2018 Feb 2018 Mar 2018 Apr 2016 May 2 Jun 2018 monta 54.000 30 Collections of this month 60/600 78.000 50.000 118.800 8.800 00 7.200 8.000 19.40 52 000 151140 31 Collections of urdmade tanto 15.540S 09.200 36.400 25.200 28,000 35.400 32 Collections of made morth 42,000 36.440 $223,440 4.800 5.200 3.800 33 4,000 5.200 Totalcash collection 6,000 $28,000 1027,4005 93,400 120.000 34 167400 101, 105 196,000 141,120 35 Desed ending wity 300 of name 36 37 Heren in 38 Purch Budget 39 For the mange 2010 40 41 Nov 2017 Dec 2017 Jan 2018 Feb 2018 Mar 2011 Apr 2011 May 2016 Jun 2018 42 Budged units 127000 WOO 10.000 3000 15 000 TO 1.000 2000 43 Ads desired ending invory 3,000 3.500 2.To Wood 3000 4 500 8.400 5.400 24.900 4 needs 15600 11,700 13000 TO 16500 23:40 21400 10000 49 Loss Beginning inventory 50, 500 11.700 Required Purchases 13.000 1600 10 500 33700 107 211430 42 45 Cost per un 5 $ $ 49 Total phases.cost 50 51 Pa Mormofuchas Dudget Too re Arial 10 B Custom C40 M 47 43 Coster 4 Total che cost 50 PM of Purch 52 Pin Month Phase 0 Tos be ere bud So Budges Castro Merchandise For the go.2014 2018 F204 Mw 2018 6740 TI 240 49.560 1000 4576 1003 M YOO 59 for current month purch 66 Payment for month purchase Cashdissement for merchases Aer 2018 52,170 May 2010 2018 17400 OTVO 1600 13.00 1700 5 3:22:23: Food Orange 65 Sand Wages Rentap 6 Sense One bed Depan 70 Vappen 17.000 anos 6,000 2000 5.000 2500 Og de Budget For the 2011 Budo MacBook Pro A Yustom 2. A4 A CAS G M D - Opening ExpenBudget For the mos ending June 30, 2018 72 73 74 75 76 Sales and Expen 77 Sales Com 78 Repen Supplies Eupen 30 Overhead Express 31 Depecoense Total operating expert 83 Surat non-cheese 04 Depreciation 85 wishes BG Jan 2018 Feb 2018 Me 2018 Ar 2018 May 2015 Jan 2018 metal 17000 17 od 5 177000 17.000 5 17.000 5 17.000 09.000 6.100 0.100 7.000 10.500 13 MO 12.000 60.00 6,000 0.00 0.000 6.000 6,000 6.000 Jid 2.000 2000 2.000 2.000 2.000 2,000 12.000 5000 5.000 6.000 5.000 5.000 5.000 30,000 2.500 2.600 2.500 2.000 2.500 15.000 30.000 160 40 60 255.00 2.500 2.500 7.000 2500 2.500 2.500 18.000 300 17.000 ONE Donec OR S DOS DO OPONERE NIE 06 Cash For the ending June 10, 2018 2014 Feb 2018 Mw 2016 Apr 2018 6. 30.00 5205 30.10 500 400 6400 120.000 400 117400 26 1500 May 2010 Jan 2013 340 Od 1.30 20 TO NOWE TO NO 92 Cash 31 Aastrum Toulable 95 Cassante Cash Outpulchases 97 Cash for operating experts Total chrome 99 Cache blonding Butot 102410 467600 DUL OWE 1.000 001 300 10260 14800 800 40 60 THE BCVO ODP PESOS 0900 185 336 500 11.160 WER 17200 MacBook Pro 049 D G E 33.520 M 14.00 41160 46 120 63.120 127.00 146.800 16,000 1.000 11.000 2.000 50,000 305200, 160 550 S 12.000 83220 112788000 Morening Budgeted incontestar For the mosending Jun 30, 2018 99 Cow balance beton financing 100 Franding 101 Borrowing repaymentyrte payable 102 Ch balance, ending 10 104 105 106 107 108 109 110 Sales, no 111 Cost of Good Sold 112 Gross margin 113 Total operating expenses 114 Mat income 115 116 Heron in 117 Budged Serk of Rintained inge 118 For the most ending June 20, 2016 119 120 ined Earnings beginning 121 Add Not income 122 Betained Earrings, endine 123 124 Heron in 135 Budgled Balance She 126 Ane 30, 2014 Budget Jan 2018 Feb 2018 Mw 2018 Ape 2018 May 2018 hun 2018 6. 90000 100.000 130 000 100003 198,000.00 66.000 55 800 85.400 81.600 95.400 100.000 105 200 512.400 $ 342605 4600 4400 545005 1,000,000 351600 35100 9.500 41.600 42.000 46.360 255.00 15 2003 05 GOOS 111001 41.64034505 11:10 350.040 Can MacBook Pro D 360,040 B 117 Budgeted Statement of Retained Earnings 118 For the 6 mos ending June 30, 2018 119 120 Retained Earnings, beginning 121 Add Net Income 122 Retained Earnings, ending 123 124 Heron, Inc. 125 Budgeted Balance Sheet 126 As of June 30, 2018 127 128 Assets: 129 Current Assets: 130 Cash 131 Accounts Receivable Office Supplies 133 Merchandise Inventory 134 Total Current Assets 135 Plant and Equipment: 136 Buildings and Equipment 137 Accumulated Depreciation 138 Total Plant and Equipment 139 Total assets 140 141 Liabilities 142 Accounts Payable 143 144 Equity = Budget + 132 Calculation Mode: Automatic Workbook Statistics te u Saved File Home Insert Draw Page Layout Formulas Dal Arial V 10 V B 9 ft B 30 29 Current Assets: 30 Cash 31 Accounts Receivable 32 Office Supplies 33 Merchandise Inventory 34 Total Current Assets 135 Plant and Equipment: 36 Buildings and Equipment 537 Accumulated Depreciation 138 Total Plant and Equipment 139 Total assets 140 141 Labilities 142 Accounts Payable 143 144 Equity 145 Common Stock 146 Retained Earnings 147 Total Equity 145 Total liabilities and equity 149 150 151 152 153 154 155 156 Budget CMA Woche esc 80 F2 DOD 000 13 74 1 N @ 2 # 3 $ 4 Q WFT D Check figures are also located under "Comprehensive Problem 2* in Blackboard INFORMATION FOR HENRON, INC. BUDGET PROJECT 1. Horon, Inc. is a company that re-sels one product, a lawn chair. A contractor makes the product exclusively for Heron, so Heron has no manufacturing costs Henron sells each chair for $10 per unit, but plans to raise the sales price to $11.00 per unit beginning May 1, 2018 2. The estimated sales in units) are as follows: Nov 17 Dec 17 Jan 18 Feb 18 Mar 18 Apr 18 May 18 kn 18 Jul 16 12,000 13,000 9,000 10,000 13.000 15,000 18.000 18,000 17.000 3. They expect that 50% of any month's sales are for cash, and the remaining 40% are on credit of the credit scles, they expect to colect 20% in the month of the sale 70% in the following month, and 10% in the month after that 4. The firm's policy regarding inventory is to stock (le have in ending Inventory) 30% of the estimated sales for the next month 5. Each lawn chair costs Henron $6. They plan to pay for 30% of the inventory purchases in the month of purchase and pay the remaining 70% the following month (le all of the previous month's Accounts Payable are paid off by the end of any month) Page 12 6. Monthly operating expenses consist of the following (any cash exponses are paid as incurred) MacBook Pro 22 100 6. Many operating expenses consist of the following the Salaries and Wages Expense $17.000 Sales Commissions ove Rent Expense 58.000 Supplies Expense $2.000 Omer Overhead Expense $5,000 Depreciation Expense $2.500 7. Henron must maintain a minimum cash balance of 530,000. Borrowing can make the For simplicity assume that the bank wil only tend and accept payment 1.200 increments on interest on the loan in your calcions, but only bow what you need pay off any loans as soon as possible & Cash on hand as of December 31, 2017 expected to be $15.000 MB notes payable on balances of this date 9. See below the other Balance Sheet accounts with their best beginning of the year Buildings in En 31.050,000 Acumulated Deprecation 5 520.000 Not Your Common Shock $ 200.000 depreciation and der Retained Earnings $360040 ruction units budget budgeted and Materials: Meeded budgeted end, ww material needed budgeted production ct Labor Budget budgeted production nufacturing OH Budget budgeted product st of Goods Sold Budget budgeted anufacturing cost per unit includes OM DL ting & Admin Exp Budgets dgeted Income Statement Sales revenue Budget: Beg cash babudgeted collect Beste toate budgeted collections Perchandise Purchases budget for me budgeted unit budget and Inventory 10 Herron maintains office wol of $2.000 at the end of each month 11. Accounts receivable consists of the credit have not been received Accounts payable connects of invertory purchase that have not yet been paid MacBook Pro