70.2K

Verified Solution

Link Copied!

Student Name: Student ID BBQ Galore Master Budget For the Quarter ended June 20XX Sales Budget Act February Actual March Forecast Apel Forecast May Forect June Quarter tot Forst wy Sales Selling Price 5 Sales Collection Budget Asumtion Inte Actu February Actual March Forecast April Forecast Forecast MY 0 1 Sales Quarter Metal 3 Collected in month of 4 Collected in month es Collected in the es Total Collections 27 E ROVE Amation mot Forecast April Forecast May For June For Quarter tot 30 Merchandise Purchases Budget 31 32 33 34 Desire dintorni 35 Total ure weary 37 Purchase 38 39 West Com 40 Pucho 41 Unit Cout Purchases (5) Merchandise Payments Budget Assumption Inputs Actual March Forecast April Forecast May Forecast June Quarter Total Purchase is Amount paid in month of purchase Amount paid in following month Total Payments Accounts payable Balance at month-end Actual Assumption Inputs Forecast April Forecast May Forecast June March Quarter Total Labour Budget 7 & 9 Purchases required units) O Variable Lisbour per unit 51 Variable Labour Expense 2 53 Fixed Labour 54 Total Labour Expense 55 56 57 Labour paid during month med 56 Labour paid in following month 59 Total cash impact of labour 20 1 Wares Payablett month and 72 73 74 75 General and Administration Budget 76 27 Asumption inputs Forecast Forecast Ronil Forecast General and Administration Budget Assumption Inputs Forecast April Forecast May Forecast June Quarter Total Sales (Units) GRA per unit Variable G&A Expense Fixed GEA Total GRA Expense Less: Depreciation GEA Cash Impact Cash Budget Forecast April Forecast May Forecast June Quarter Total Opening alone Add Collections Cash available Disbursements Merchandise Labout General and Administration Fixed Asset Purchase Dividends Total Disbursements + Cash balance before inancing Borrowing Repayment Interest pense Ending Balance Line of Credit Balance at Month-end Endin It Calibri (Body) v 11 A A v

Answer & Explanation Solved by verified expert

See Answer