hello this homework is based on management accounting I'm struggling with if someone could help me that's greatly appreciated i have all the instructions provided in the first two pages and then the remainder of the template below if someone could guide me through with instructions that would be greatly appreciated. thank you so much as well the correct amount in purchases is $245, 106 NOT $246, 106.

Details: Its March 31\Below is the Balance Sheet as of March 31'\": _ _ _ _ w 611 R_equired: Using the template provided, complete all the budget schedules and nish the forecast with cashow, income statement and balance sheet projections. Time required could be 8 to 12 hours so plan your time. The template will keep you organized. You shouldn't need to change it much, but you can if you prefer alternate layouts. Very Important: Your spreadsheet should use formulas and links to other cells wherever possible. The only cells that should have numbers typed in is the assumptions given in the question (eg. Number of units sold each month). The rest should be formulas or links to other cells. The idea is that we can change the selling price or number of units and your whole budget will recalculate and everything will still balance. Simply inputting values into cells without linking the value to the cell it is coming from will not allow for that automated functionality which is so critical to the budgeting process. Time management: If you get everything working perfectly... 1. Your cashow balances should agree with your March and June bank balances on your balance sheet. 2. Your net income and dividend values should explain the change in retained earnings between March and June. 3. Your balance sheet should balance. J L N A B C D E F G H I K M 5 BBQ Galore 6 Master Budget For the Quarter ended June 20XX 10 Sales Budget Actual Actual Forecast Forecast Forecast Forecast 11 February March April May June Quarter Total July 12 13 Sales (Units] 14 Selling Price 15 Sales (S) 16 17 18 Collection Budget Assumption Actual Actual Forecast Forecast Forecast 19 Inputs February March April May June Quarter Total 20 21 Sales 22 23 Collected in month of sale 24 Collected in month after sale 25 Collected in second month after sale 26 Total Collections 27 28 Accounts Receivable at month-end 25 30 Merchandise Purchases Budget Assumption Forecast Forecast Forecast Forecast 31 Inputs April May June Quarter Total July 32 33 Sales (units) 34 Desired ending inventory (units] 35 Total needs 36 Less: Beginning Inventory 37 Purchases required (units) 3BB N A C D E F G H K L M 29 30 Merchandise Purchases Budget Assumption Forecast Forecast Forecast Forecast 31 Inputs April May June Quarter Total July 32 33 Sales (units) 34 Desired ending inventory (units] 35 Total needs 36 Less: Beginning Inventory 37 Purchases required (units) 3B 39 Unit Cost 40 Purchases (S) 41 42 43 44 Merchandise Payments Budget Assumption Actual Forecast Forecast Forecast 45 Inputs March April May June Quarter Total 40 47 Purchases (S) 48 49 Amount paid in month of purchase 50 Amount paid in following month 51 Total Payments 52 53 Accounts payable Balance at month-end 54 55 56 Labour Budget Assumption Actual Forecast Forecast Forecast 57 Inputs March April May June Quarter Total 58 59 Purchases required (units) 60 Variable Labour per unit 51 Variable Labour Expense 62 53 Fixed Labour 54 Total Labour ExpenseD G I M Q E F K L N P B C H co 65 67 Labour paid during month earned 68 Labour paid in following month 69 Total cash impact of labour 70 71 Wages Payable at month-end 72 73 74 General and Administration Budget Assumption Forecast Forecast Forecast 76 Inputs April May June Quarter Total 77 78 Sales (Units] 79 G&A per unit 80 Variable G&A Expense 81 82 Fixed GBA 83 Total G&A Expense 84 85 Less: Depreciation 86 G&A Cash Impact 87 BB 89 90 91 92 Cash Budget Forecast Forecast Forecast 93 April May June Quarter Total 94 95 Opening Balance 96 Add: Collections 97 Cash available 98 99 Disbursements 100 Merchandise 101 LabourN A B C D E F G H I J K L M 100 Merchandise 01 Labour 102 General and Administration 03 Fixed Asset Purchase 04 Dividends Total Disbursements 06 07 Cash balance before financing 08 Borrowing 09 Repayment 10 Interest Expense 11 Ending Balance 12 13 Line of Credit Balance at Month-end 14 15 Ending Inventory / COGS Budget Forecast Forecast Forecast 16 April May June Quarter Total 17 18 Cost per unit 19 20 Sales (Units] 21 Cost of Goods Sold 22 123 Beginning Inventory (units] 24 Purchases (units) 25 Sales (Units] 26 Ending Inventory (Units) .27 28 Value of Ending Inventory 120 Budgeted Income Statement Forecast Forecast Forecast 31 April May June Quarter Total 33 Sales 134 Cost of Goods Sold 35 Gross Profit Sheet1 +A B C D E F G H I J K L M 129 130 Budgeted Income Statement Forecast Forecast Forecast 131 April May June Quarter Total 132 133 Sales 134 Cost of Goods Sold 135 Gross Profit 136 137 Labour 138 General and Administration (incl. Depreciation) 139 Total Expenses 140 141 Net Income before tax 142 143 144 Budgeted Balance Sheet 145 Actual Forecast Forecast Forecast 146 April April May June 147 148 Cash $100,000 49 Accounts Receivable $84,757 150 Merchandise Inventory $228,000 51 Fixed Assets $1,000,000 152 Less: Depreciation -$350,000 53 Total Assets $1 062,757 154 155 Accounts payable $171,574 156 Wages Payable $8,572 57 Line of credit SO 58 Total Liabilities $180,146 159 160 Common Shares $650,000 61 Retained Earnings $232,611 62 Total Liabilities and Equity $1,062,757 163 164 165 Balance Check SO SO 166