I am having issue with this problem excel sheet. It's only one question divided into four parts I can separately post them individually if that is what is needed. Any help will be highly appreciated. Thanks

Jun 10 1111:50 Activities LibreOffice Calc 18.4C Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abs AL A 2:9 BIUA - % 74 09 00 * Calibri == 11 A31 asked you to provide the following items for the months of January, February, and March of 2019: A) a Purchases Budget; B) a Cash Budget; C) a Budgeted Income Statement; and D) a Budgeted Balance Sheet. They have provided you with the planning document below and also, with their December 31, 2018 Balancesheet. Please complete the four budget documents requested on Worksheet Tabs A, B, A 7 10 C, a d D of this Workbook. Check Figures are provided for you on each Worksheet. for 11 12 Butter, Inc 13 PLANNING DATA FOR 2019 14 15 16 17 Actual November 2018 Sales $245,000 $235,000 18 Actual December 2018 Sales 19 Expected Monthly Sales $179,000 $184,000 $163,000 January 20 February 21 March 22 April $176,000 23 24 25 All Sales are on Credit Collections f Accounts Receivable: 26 Month of Service 45,00% 27 Month following Service 55,00% 28 29 30 Cost of Goods Sold as a percentage of selling price. 31 62.00% 3pLandonding inuentonasnocsont f menthl couired inennto co nnor +Budget Planning Decument Dec 2118 53rce Sheet 4. Purchases Bud IStvie dast eocaDo emeSatement D.Budped Baiance Sheet Average, Sum: 0 English IUSA Sree1of Jun 10 1111:57 Activities LibreOffice Calc 18.4C 97 Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Edit View Insert Farmat Data Tacls Wincow Help Styles Sheet abs AL : A BIUA == % 74 00 00 - Calibri 11 fx Months of insurance coverage paid for AS5 30 Cost of Goods Sold as a percentage of selling price 62,00% A 31 32 Planned ending inventory as a percentage of next month's required inventory. 68.00% 33 34 Purchases are are all on credit for Actual Purchases made in December 2018 $122,090 35 Purchases paid in current month 70,00% 26 Purchases paid in next month 30.00% 37 38 39 Marketing expenses have a fixed and variable portion: 40 Fixed portion $3,450 The fixed portion of the marketing is paid in the current month. 41 42 Variable portion as a percentage of sales 1.10% The yariable nortion is naid two months after the month incurred. 43 Total marketing for month. 45 46 Sales commission as a percent of sales 2,00% Sales commission are paid one month after the month incurred. 47 48 49 Selling and Administrative expenses have a fixed and variable portion: 50 Fixed portion is paid in the month incurred 51 Variable portion as a percentage of sales $21,300 1.50% Variable S&A expenses are paid one month after the month incurred 52 54 Insurance policy: 55 Months of insurance coverage paid for 56 The nolicv nerind is from Fehruary 1 to lanuary 31 each vear 12 Budget Planning Document Dec 2018 Bace Sheet A. Purchases Bud I BageStvle Budast oasaD cme eatement D.Budped Baiance Sheet e1of 6 Average Sum 0 LasoN Enelish JUSA Activities LibreOffice Calc Jun 10 1112:14 18.4C 97 Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help F A % 74 00 00 - A 2 BIU Calibri 11 fx I A78 53 A 54 Insurance policy 55Months of insurance coverage paid for 56 The policy period is from February 1 to January 31 each year 57 The premium to be paid on February 1, 2019 is 12 $14,640 for The premium will be charged to prepaid insurance 58 59 $5,080 60 Depreciation expense per month 61 62 The annual interest rate on the long term debt is 4,65% Interest is incurred on the princinal balance outstanding each month Interest is paid on a quarterly basis, Interest for December to February will be paid March 1. 63 6A No principal payments are scheduled to be made on the long-term debt until September of 2019. 65 66 67 The Company's Board of Directors plans to declare a dividend on March 20. $10,000 It will be paid on April 15. 68 69 70 Income Tax rate 21.00% Accrued taxes for the three previous months are paid on the 15th of January, April, July and October 71 72 73 74 75 76 77 78 79 Budget Planning Documemt Dec 2018 Bajance Sheet A. Purchases Bud . n. me Statement D.Budeted Balance Sheet Fo 1 of 6 Average Sum 0 LasoN English iUSA Jun 10 1113:44 Activities LibreOffice Calc 18.4C 97 Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help F A A . = _ % 74 00 00 BIU Calibri 11 fx = D6 A 4 Use the information provided on the December 31, 2018 Balance n below to help you create the budgeting documents requested. 6 for Butter, Inc. 2 BALANCE SHEET 8 December 31, 2018 10 ASSETS 11 12 Current Assets Cash 303.200 13 Accounts Receivable 129.250 14 Inventory Prepaid Insurance 17 Total Current Assets 75,466 15 1,220 16 509,136 18 19 Property Plant and Equipment Office Equipment Accumulated Depreciation 304,800 20 (60,960) 21 22 Total Property Plant and Equipment 243.840 23 24 Total Assets 752,976 25 26 LIABILITIES AND SHAREHOLDERS EQUITY 22 LIABILITIES 28 D. Budgeted Balance Sheet Budget Planning Decument Dec 2018Balance Steet 4. Purchases Budget B. Statement LPGte Dec 3018 Bc Shct Averg Sum: 0 LasoN EngishUSA Jun 10 1113:50 Activities LibreOffice Calc 18.4C 97 Summer 2019 Module 6 Cheese To Please_Budget Assiqnment.xisx- LibreOffice Calc File Edit View Insert Farmat Styles Sheet Data Taols Wincow Help- F A A = = :% 74 00 00* BIU Calibri 11 fx D52 LIABILITIES AND SHAREHOLDERS EQUITY 27 LIABILITIES 29 Current Liabilities Accounts Payable Purchases 36,627 20 Sales Commission Pavable 4,700 31 for Selling and Admin Payable 3,525 32 Interest Payable Marketing Payable Income Taxes Payable Dividends Payable 465 33 5,280 34 15,320 35 36 Total Current Liabilities 65,917 37 38 Long Term Debt 120,000 39 40 41 Total Liabilities 185,917 47 SHAREHOLDERS' EQUITY 42 Common Stock 104.000 AA Retained Earnings 463.059 45 AC 47 Total Shareholders' Equity 567,059 48 49 Total Liabilities and Shareholders Equity 752,976 50 51 52 53 D. Budgeted Balace Sheet Budget Planning Document Dec 2018 Balance Sheet A. Purchases Budget B. Satement Erglsh (U5A LPule De 2018 Baacce Shest T- LasoN Average Sum: 0 Shee 2 of 5 Jun 10 1117:32 Activities LibreOffice Calc 18.4C 45 Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abe AL z A BIUA = = % 74 00 00 * - Calibri 11 f Checkfiqures arc: January Cash Reccipts $209,800; February Cash Disbursements $155,825 March Ending Cash Balance $405,496 Ab F C D Hi 1 A 3 4Based on the information available to you, complete the Cash Budget worksheet below: 5 for 800; February Cash Disbursements = $155,825; March Ending Cash Balance = $405,496. 8 9 Solution: Butter, Inc. 10 PLANNED CASH TRANSACTIONS and CASH BUDGET 11 For the Month Ending, 12 13 Feb 28, 2019 Jan 31, 2019 Mar 31, 2019 14 15 Beginning of Month Cash Balance 16 CASH IN 17 18 45% This Month's Sales 19 55% of Last Month's Sales 20 21 Total Cash Receipts for Month 22 23 Total Cash Available During Month 24 CASH OUT 25 2630% Last Month's Purchases D.Budpeted Bala ce Sheet tUudget Pianing Docr nt. Dec 2018 Balace Sheet A. Purchases Budget ed Irceme Statement aevic B. Cash Budget AssragsSum: 0 Sheet 4of6 Engish (USA) Jun 10 1117:51 Activities LibreOffice Calc 18.4C 45 Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abe AL z A BIUA = = % 74 00 00 * - Calibri 11 f Checkfiqures arc: January Cash Reccipts $209,800; February Cash Disbursements $155,825 March Ending Cash Balance $405,496 Ab F C D Hi 1 A 3 4Based on the information available to you, complete the Cash Budget worksheet below: 5 for 800; February Cash Disbursements = $155,825; March Ending Cash Balance = $405,496. 8 9 Solution: Butter, Inc. 10 PLANNED CASH TRANSACTIONS and CASH BUDGET 11 For the Month Ending, 12 13 Feb 28, 2019 Jan 31, 2019 Mar 31, 2019 14 CASH OUT 75 26 30% Last Month's Purchases 27 70% This Month's Purchases 28 Marketing 29 Commissions 30 Selling & Administrative 31 Insurance 32 Interest 33 Income Tax 34 Dividends 35 36 Total Cash Disbursements for Month Budget Planning Doc. D.Budpeted Bala ce Sheet nt Dec 2018 Baarce Sheet A. Purchases Budget ed Irceme Statement aevic B. Cash Budget AssragsSum: 0 Shee: 4 of 6 Engish (USA) Jun 10 1117:58 Activities LibreOffice Calc 92 18.4C Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abs AL A BIUA = = % 74 00 00 * - Calibri 11 fx Checkfiqures arc: January Cash Reccipts $209,800; February Cash Disbursements $155,825 March Ending Cash Balance $405,496 Ab F C D Hi 1 A 3 4Based on the information available to you, complete the Cash Budget worksheet below: 5 for 800; February Cash Disbursements = $155,825; March Ending Cash Balance = $405,496. 8 9 Solution: Butter, Inc. 10 PLANNED CASH TRANSACTIONS and CASH BUDGET 11 For the Month Ending, 12 13 Feb 28, 2019 Jan 31, 2019 Mar 31, 2019 14 5 36 Total Cash Disbursements for Month 37 38 End of Month Cash Balance 39 40 41 42 13 44 45 47 D.Budgrted Balsce Sheet edIrcome Statement Budget Planning Doc nt Dec 2018 Bajance Sheet A. Purchases Budget asoN Raevic B. Cash Budust Aseraget; Sum: 0 See 4of 6 Engish (USA) Jun 10 1118:25 Activities LibreOffice Calc 92 18.4C Summer 2019 Module 6 Cheese To Please Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abe = AL z A BI U A % 74 00 00* - Calibri 11 = = fx Chockfiqures are: January Budgctod Gross Margin $68,020; February Budqeted Opcrating Income $30,406; March Budgcted Net Income $18,112 Ar F C G H K 1 A 4Base at hel mtion available to you, complete the Budgeted Income Statement for 6 Check figures are: January Budgeted Gross Margin $68,020; February Budgeted 8 Operating Income = $30,406; March Budgeted Net Income $18,112. 9 10 Solution: Butter, Inc. 11 BUDGETED INCOME STATEMENTS 12 For the Month Ending, 13 14 Jan 31, 2019 Feb 28,2019 Mar 31, 2019 15 16 Sales 17 Cost of Sales 18 Gross Margin 20 Other Operating Expenses 21 Commission Expense 22 Marketing Expense 23 Insurance Expense 24 Selling & Administrative Expense 25 Depreciation Expense 26 Total Other Operating Expenses +Budget Piaeing Document ement D. Budpeted Balance Sheet A. Purchases udgets Dec 2018 Baace Sheet English (U5A werageSum asoN Activities LibreOffice Calc Jun 10 1118:31 92 18.4C Summer 2019 Module 6 Cheese To Please Budget Assignment.xisx- LibreOffice Calc File Edit View Insert Farmat Styles Sheet Data Tacls Wincow Help abe = AL z A BI U A % 74 00 00* - Calibri 11 = = fx i Az Checkfiqures arc: January Budgeted Gross Marqin $68,020; February Budgeted Opcrating Income $30,406; March Budgeted Net Income $18,112. C G H K 20 Other Operating Expenses 21 Commission Expense 22 Marketing Expense A 23 Insurance Expense 24 Selling & Administrative Expense 25 Depreciation Expense 26 Total Other Operating Expenses for 27 28 Operating Income 29 30 Other Inccome (Expense) 31 Interest Expense 32 33 Income Before Income Tax 34 35 Income Tax Expense 36 37 Net Income 38 39 40 41 42 MA 45 ement D. Budpeted Balance Sheet Dec 2018 Bajarce Sheet A. Purchases udget Budget Flanning Decument B. English (U5A werageSum asoN Activities LibreOffice Calc Jun 10 1118:53. 92 18.4C Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help BIU A = 00 00 *r % 74 Calibri 11 f, Check fiqures are: January Total Asscts $761,006: February Total Liabilitics $175,620: March Total Current Assets - $581,548 G Ab A D H M A 3 Based on the information available to you, complete the Budgeted Balance Sheet worksheet below: 4 5 for 6 Check figures are: January Total Assets 7 Current Assets $581.548. $761,006; February Total Liabilities $175,620; March Total 9Solution: Butter, Inc. 10 BUDGETED BALANCE SHEETS 11 12 13 ASSETS Feb 28,2019 Mar 31, 2019 Dec 31, 2018 Jan 31, 2019 14 Current Assets Cash 15 Accounts Receivable 16 Inventory 17 Prepaid Insurance 18 19 20 Total Current Assets 21 22 Property Plant and Equipment Office Equipment Accumulated Depreciation 25 Total Property Plant and Equipment 23 24. 26 27 Total Assets +Budget Planning Document D.Budgeted Balance Sheet Dec 2018 Baarce Sheet A. Purchases Budget Statement ula Buociot Bdanre Steet ee 66 English (U5A werage Sum Activities LibreOffice Calc Jun 10 1119:09. 92 18.4C Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help BIU A = % 74 00 00 - Calibri 11 fx Check figures arc: January Tatal Assets- $761,006; February Total Liabilitics $175,620: March Total Current Assets $581,548 P D K M 27 Total Assets 28 A 29 LIABILITIES AND SHAREHOLDERS EQUITY 30 LIABILITIES 31 Current Liabilities Accounts Payable Purchases Sales Commission Payable for 32 33 Marketing Payable Selling and Administrative Payable Interest Payable Dividends Payable Income Taxes Payable 34 35 36 37 38 29 40 Total Current Liabilities 41 42 Long Term Debt 43 44 Total Liabilities 45 46 SHAREHOLDERS' EQUITY Common Stock 47 Earnings 48 49 50 Total Shareholders' Equity 51 52 Total Ligbilities and Shareholders Eauity _53 D.Budgeted Balance Sheet Budget Planning Document Dec 2018 Balace Sheet A. Purchases Budget Statement ul uortet Balance Sree English (U5A werage Sum LasoN Jun 10 1111:50 Activities LibreOffice Calc 18.4C Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abs AL A 2:9 BIUA - % 74 09 00 * Calibri == 11 A31 asked you to provide the following items for the months of January, February, and March of 2019: A) a Purchases Budget; B) a Cash Budget; C) a Budgeted Income Statement; and D) a Budgeted Balance Sheet. They have provided you with the planning document below and also, with their December 31, 2018 Balancesheet. Please complete the four budget documents requested on Worksheet Tabs A, B, A 7 10 C, a d D of this Workbook. Check Figures are provided for you on each Worksheet. for 11 12 Butter, Inc 13 PLANNING DATA FOR 2019 14 15 16 17 Actual November 2018 Sales $245,000 $235,000 18 Actual December 2018 Sales 19 Expected Monthly Sales $179,000 $184,000 $163,000 January 20 February 21 March 22 April $176,000 23 24 25 All Sales are on Credit Collections f Accounts Receivable: 26 Month of Service 45,00% 27 Month following Service 55,00% 28 29 30 Cost of Goods Sold as a percentage of selling price. 31 62.00% 3pLandonding inuentonasnocsont f menthl couired inennto co nnor +Budget Planning Decument Dec 2118 53rce Sheet 4. Purchases Bud IStvie dast eocaDo emeSatement D.Budped Baiance Sheet Average, Sum: 0 English IUSA Sree1of Jun 10 1111:57 Activities LibreOffice Calc 18.4C 97 Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Edit View Insert Farmat Data Tacls Wincow Help Styles Sheet abs AL : A BIUA == % 74 00 00 - Calibri 11 fx Months of insurance coverage paid for AS5 30 Cost of Goods Sold as a percentage of selling price 62,00% A 31 32 Planned ending inventory as a percentage of next month's required inventory. 68.00% 33 34 Purchases are are all on credit for Actual Purchases made in December 2018 $122,090 35 Purchases paid in current month 70,00% 26 Purchases paid in next month 30.00% 37 38 39 Marketing expenses have a fixed and variable portion: 40 Fixed portion $3,450 The fixed portion of the marketing is paid in the current month. 41 42 Variable portion as a percentage of sales 1.10% The yariable nortion is naid two months after the month incurred. 43 Total marketing for month. 45 46 Sales commission as a percent of sales 2,00% Sales commission are paid one month after the month incurred. 47 48 49 Selling and Administrative expenses have a fixed and variable portion: 50 Fixed portion is paid in the month incurred 51 Variable portion as a percentage of sales $21,300 1.50% Variable S&A expenses are paid one month after the month incurred 52 54 Insurance policy: 55 Months of insurance coverage paid for 56 The nolicv nerind is from Fehruary 1 to lanuary 31 each vear 12 Budget Planning Document Dec 2018 Bace Sheet A. Purchases Bud I BageStvle Budast oasaD cme eatement D.Budped Baiance Sheet e1of 6 Average Sum 0 LasoN Enelish JUSA Activities LibreOffice Calc Jun 10 1112:14 18.4C 97 Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help F A % 74 00 00 - A 2 BIU Calibri 11 fx I A78 53 A 54 Insurance policy 55Months of insurance coverage paid for 56 The policy period is from February 1 to January 31 each year 57 The premium to be paid on February 1, 2019 is 12 $14,640 for The premium will be charged to prepaid insurance 58 59 $5,080 60 Depreciation expense per month 61 62 The annual interest rate on the long term debt is 4,65% Interest is incurred on the princinal balance outstanding each month Interest is paid on a quarterly basis, Interest for December to February will be paid March 1. 63 6A No principal payments are scheduled to be made on the long-term debt until September of 2019. 65 66 67 The Company's Board of Directors plans to declare a dividend on March 20. $10,000 It will be paid on April 15. 68 69 70 Income Tax rate 21.00% Accrued taxes for the three previous months are paid on the 15th of January, April, July and October 71 72 73 74 75 76 77 78 79 Budget Planning Documemt Dec 2018 Bajance Sheet A. Purchases Bud . n. me Statement D.Budeted Balance Sheet Fo 1 of 6 Average Sum 0 LasoN English iUSA Jun 10 1113:44 Activities LibreOffice Calc 18.4C 97 Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help F A A . = _ % 74 00 00 BIU Calibri 11 fx = D6 A 4 Use the information provided on the December 31, 2018 Balance n below to help you create the budgeting documents requested. 6 for Butter, Inc. 2 BALANCE SHEET 8 December 31, 2018 10 ASSETS 11 12 Current Assets Cash 303.200 13 Accounts Receivable 129.250 14 Inventory Prepaid Insurance 17 Total Current Assets 75,466 15 1,220 16 509,136 18 19 Property Plant and Equipment Office Equipment Accumulated Depreciation 304,800 20 (60,960) 21 22 Total Property Plant and Equipment 243.840 23 24 Total Assets 752,976 25 26 LIABILITIES AND SHAREHOLDERS EQUITY 22 LIABILITIES 28 D. Budgeted Balance Sheet Budget Planning Decument Dec 2018Balance Steet 4. Purchases Budget B. Statement LPGte Dec 3018 Bc Shct Averg Sum: 0 LasoN EngishUSA Jun 10 1113:50 Activities LibreOffice Calc 18.4C 97 Summer 2019 Module 6 Cheese To Please_Budget Assiqnment.xisx- LibreOffice Calc File Edit View Insert Farmat Styles Sheet Data Taols Wincow Help- F A A = = :% 74 00 00* BIU Calibri 11 fx D52 LIABILITIES AND SHAREHOLDERS EQUITY 27 LIABILITIES 29 Current Liabilities Accounts Payable Purchases 36,627 20 Sales Commission Pavable 4,700 31 for Selling and Admin Payable 3,525 32 Interest Payable Marketing Payable Income Taxes Payable Dividends Payable 465 33 5,280 34 15,320 35 36 Total Current Liabilities 65,917 37 38 Long Term Debt 120,000 39 40 41 Total Liabilities 185,917 47 SHAREHOLDERS' EQUITY 42 Common Stock 104.000 AA Retained Earnings 463.059 45 AC 47 Total Shareholders' Equity 567,059 48 49 Total Liabilities and Shareholders Equity 752,976 50 51 52 53 D. Budgeted Balace Sheet Budget Planning Document Dec 2018 Balance Sheet A. Purchases Budget B. Satement Erglsh (U5A LPule De 2018 Baacce Shest T- LasoN Average Sum: 0 Shee 2 of 5 Jun 10 1117:32 Activities LibreOffice Calc 18.4C 45 Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abe AL z A BIUA = = % 74 00 00 * - Calibri 11 f Checkfiqures arc: January Cash Reccipts $209,800; February Cash Disbursements $155,825 March Ending Cash Balance $405,496 Ab F C D Hi 1 A 3 4Based on the information available to you, complete the Cash Budget worksheet below: 5 for 800; February Cash Disbursements = $155,825; March Ending Cash Balance = $405,496. 8 9 Solution: Butter, Inc. 10 PLANNED CASH TRANSACTIONS and CASH BUDGET 11 For the Month Ending, 12 13 Feb 28, 2019 Jan 31, 2019 Mar 31, 2019 14 15 Beginning of Month Cash Balance 16 CASH IN 17 18 45% This Month's Sales 19 55% of Last Month's Sales 20 21 Total Cash Receipts for Month 22 23 Total Cash Available During Month 24 CASH OUT 25 2630% Last Month's Purchases D.Budpeted Bala ce Sheet tUudget Pianing Docr nt. Dec 2018 Balace Sheet A. Purchases Budget ed Irceme Statement aevic B. Cash Budget AssragsSum: 0 Sheet 4of6 Engish (USA) Jun 10 1117:51 Activities LibreOffice Calc 18.4C 45 Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abe AL z A BIUA = = % 74 00 00 * - Calibri 11 f Checkfiqures arc: January Cash Reccipts $209,800; February Cash Disbursements $155,825 March Ending Cash Balance $405,496 Ab F C D Hi 1 A 3 4Based on the information available to you, complete the Cash Budget worksheet below: 5 for 800; February Cash Disbursements = $155,825; March Ending Cash Balance = $405,496. 8 9 Solution: Butter, Inc. 10 PLANNED CASH TRANSACTIONS and CASH BUDGET 11 For the Month Ending, 12 13 Feb 28, 2019 Jan 31, 2019 Mar 31, 2019 14 CASH OUT 75 26 30% Last Month's Purchases 27 70% This Month's Purchases 28 Marketing 29 Commissions 30 Selling & Administrative 31 Insurance 32 Interest 33 Income Tax 34 Dividends 35 36 Total Cash Disbursements for Month Budget Planning Doc. D.Budpeted Bala ce Sheet nt Dec 2018 Baarce Sheet A. Purchases Budget ed Irceme Statement aevic B. Cash Budget AssragsSum: 0 Shee: 4 of 6 Engish (USA) Jun 10 1117:58 Activities LibreOffice Calc 92 18.4C Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abs AL A BIUA = = % 74 00 00 * - Calibri 11 fx Checkfiqures arc: January Cash Reccipts $209,800; February Cash Disbursements $155,825 March Ending Cash Balance $405,496 Ab F C D Hi 1 A 3 4Based on the information available to you, complete the Cash Budget worksheet below: 5 for 800; February Cash Disbursements = $155,825; March Ending Cash Balance = $405,496. 8 9 Solution: Butter, Inc. 10 PLANNED CASH TRANSACTIONS and CASH BUDGET 11 For the Month Ending, 12 13 Feb 28, 2019 Jan 31, 2019 Mar 31, 2019 14 5 36 Total Cash Disbursements for Month 37 38 End of Month Cash Balance 39 40 41 42 13 44 45 47 D.Budgrted Balsce Sheet edIrcome Statement Budget Planning Doc nt Dec 2018 Bajance Sheet A. Purchases Budget asoN Raevic B. Cash Budust Aseraget; Sum: 0 See 4of 6 Engish (USA) Jun 10 1118:25 Activities LibreOffice Calc 92 18.4C Summer 2019 Module 6 Cheese To Please Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help abe = AL z A BI U A % 74 00 00* - Calibri 11 = = fx Chockfiqures are: January Budgctod Gross Margin $68,020; February Budqeted Opcrating Income $30,406; March Budgcted Net Income $18,112 Ar F C G H K 1 A 4Base at hel mtion available to you, complete the Budgeted Income Statement for 6 Check figures are: January Budgeted Gross Margin $68,020; February Budgeted 8 Operating Income = $30,406; March Budgeted Net Income $18,112. 9 10 Solution: Butter, Inc. 11 BUDGETED INCOME STATEMENTS 12 For the Month Ending, 13 14 Jan 31, 2019 Feb 28,2019 Mar 31, 2019 15 16 Sales 17 Cost of Sales 18 Gross Margin 20 Other Operating Expenses 21 Commission Expense 22 Marketing Expense 23 Insurance Expense 24 Selling & Administrative Expense 25 Depreciation Expense 26 Total Other Operating Expenses +Budget Piaeing Document ement D. Budpeted Balance Sheet A. Purchases udgets Dec 2018 Baace Sheet English (U5A werageSum asoN Activities LibreOffice Calc Jun 10 1118:31 92 18.4C Summer 2019 Module 6 Cheese To Please Budget Assignment.xisx- LibreOffice Calc File Edit View Insert Farmat Styles Sheet Data Tacls Wincow Help abe = AL z A BI U A % 74 00 00* - Calibri 11 = = fx i Az Checkfiqures arc: January Budgeted Gross Marqin $68,020; February Budgeted Opcrating Income $30,406; March Budgeted Net Income $18,112. C G H K 20 Other Operating Expenses 21 Commission Expense 22 Marketing Expense A 23 Insurance Expense 24 Selling & Administrative Expense 25 Depreciation Expense 26 Total Other Operating Expenses for 27 28 Operating Income 29 30 Other Inccome (Expense) 31 Interest Expense 32 33 Income Before Income Tax 34 35 Income Tax Expense 36 37 Net Income 38 39 40 41 42 MA 45 ement D. Budpeted Balance Sheet Dec 2018 Bajarce Sheet A. Purchases udget Budget Flanning Decument B. English (U5A werageSum asoN Activities LibreOffice Calc Jun 10 1118:53. 92 18.4C Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help BIU A = 00 00 *r % 74 Calibri 11 f, Check fiqures are: January Total Asscts $761,006: February Total Liabilitics $175,620: March Total Current Assets - $581,548 G Ab A D H M A 3 Based on the information available to you, complete the Budgeted Balance Sheet worksheet below: 4 5 for 6 Check figures are: January Total Assets 7 Current Assets $581.548. $761,006; February Total Liabilities $175,620; March Total 9Solution: Butter, Inc. 10 BUDGETED BALANCE SHEETS 11 12 13 ASSETS Feb 28,2019 Mar 31, 2019 Dec 31, 2018 Jan 31, 2019 14 Current Assets Cash 15 Accounts Receivable 16 Inventory 17 Prepaid Insurance 18 19 20 Total Current Assets 21 22 Property Plant and Equipment Office Equipment Accumulated Depreciation 25 Total Property Plant and Equipment 23 24. 26 27 Total Assets +Budget Planning Document D.Budgeted Balance Sheet Dec 2018 Baarce Sheet A. Purchases Budget Statement ula Buociot Bdanre Steet ee 66 English (U5A werage Sum Activities LibreOffice Calc Jun 10 1119:09. 92 18.4C Summer 2019 Module 6 Cheese To Please_Budget Assignment.xisx- LibreOffice Calc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help BIU A = % 74 00 00 - Calibri 11 fx Check figures arc: January Tatal Assets- $761,006; February Total Liabilitics $175,620: March Total Current Assets $581,548 P D K M 27 Total Assets 28 A 29 LIABILITIES AND SHAREHOLDERS EQUITY 30 LIABILITIES 31 Current Liabilities Accounts Payable Purchases Sales Commission Payable for 32 33 Marketing Payable Selling and Administrative Payable Interest Payable Dividends Payable Income Taxes Payable 34 35 36 37 38 29 40 Total Current Liabilities 41 42 Long Term Debt 43 44 Total Liabilities 45 46 SHAREHOLDERS' EQUITY Common Stock 47 Earnings 48 49 50 Total Shareholders' Equity 51 52 Total Ligbilities and Shareholders Eauity _53 D.Budgeted Balance Sheet Budget Planning Document Dec 2018 Balace Sheet A. Purchases Budget Statement ul uortet Balance Sree English (U5A werage Sum LasoN