In serious need of help. The content was never taught to our class, the school does not provide tutoring for this class or excel. I am at a loss. All help is greatly appreciated. Thank you for taking the time to read through the instructions and to help accordingly.

Details: Assignment = 15% of overall grade for ACCT CB203

Its March 31^st, and BBQ Galore ("BG") is asking you to complete their monthly budget for the next three months. They buy Barbeques from a wholesaler for an average cost of $950 each and plan to sell the following units at the average selling price shown.

Month	Sales (# of Units)	Average Selling Price
February Actual	155	$1,125
March Actual	98	$1,018
April Estimate	300	$1,600
May Estimate	800	$1,600
June Estimate	600	$1,550
July Estimate	600	$1,550

The prices fluctuate as old units are sold off in the Winter and as the new units are rolled out in the busy Spring season. Some customers pay right away and others are invoiced on account. Historically, 50% of the sales are collected in the month of sale, with 30% more in the next month and the balance in the second month.

It takes time to build all the barbeques so they need to be in stock early. BG likes to end the month with enough inventory to satisfy 80% of the next month's sales estimate. In practice, they are not always exact on this. On March 31, they had 240 units in inventory at an average cost of $950.

Because BG carries so much inventory, it helps that they can delay payment to the wholesaler. Typically, BG pays 30% of the invoice cost in the month of purchase and the balance in the following month. The actual purchases made in March was $246,106.

Most of the variable labour is used in moving and assembling inventory so the number of units purchased is the most accurate driver of variable labour costs. Variable labour averages @ $18 per unit purchased in the month of purchase. Fixed labour is estimated to be $37,500 for the quarter to cover management and office staff salaries. Total Labour expense in March was $17,144.

Payroll processing and reporting cutoffs mean that 50% of the labour is paid in the month it is earned and the rest is paid the next month.

General and Administration expenses are driven by unit sales so that is the driver used to forecast them. Variable G&A averages $95 per unit and fixed G&A is $15,000 each month. The fixed G&A value includes $4,500 of depreciation expense.

The balance sheet from March 31^st is given and it shows opening bank balance for the quarter. In addition to the cashflows already mentioned, the company plans to pay a $25,000 dividend in April and purchase $150,000 of new storage equipment in June. The equipment will not be used in June, so it will not affect the monthly depreciation.

The company has a $100,000 line of credit available to them and as of March 31^st, it is unused. BG has a terrific relationship with the bank, so the line is provided at a 0% interest rate as long as they only use it periodically. You can assume no interest. The company has no overdraft protection on the bank account, so they need to borrow from the line to keep the minimum balance of $0.

Below is the Balance Sheet as of March 31^st:

Cash	$100,000
Accounts Receivable	$84,757
Merchandise Inventory	$228,000
Fixed Assets	$1,000,000
Less: Depreciation	-$350,000
Total Assets	$1,062,757
Accounts payable	$171,574
Wages Payable	$8,572
Line of credit	$0
Total Liabilities	$180,146
Common Shares	$650,000
Retained Earnings	$232,611
Total Liabilities and Equity	$1,062,757

Required:

Using the template provided, complete all the budget schedules and finish the forecast with cashflow, 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. 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. If you type the value in a cell instead of linked formulas, it will be graded as though you submitted it blank.

Time management:

If you get everything working perfectly...

Your cashflow balances should agree with your March and June bank balances on your balance sheet.

Your net income and dividend values should explain the change in retained earnings between March and June.

Your balance sheet should balance.

...however, it is very typical for your balance sheet to not balance. If it doesn't, you won't get 100%, but you can still get 95% based on your work. It is very likely that your first attempt will not balance. It happens to all of us. I suggest you put it away for a day or two and then come back with fresh eyes to see if you can solve it. If you haven't figured it out in an hour, I suggest you submit it and move on with other course work. For some of you, not balancing will drive you crazy.

You have plenty of days to work on this. Do not leave it to the last day to start. It is not the kind of assignment you can do quickly. Late assignments will not be accepted so get it done early.

Student Name: Student D. In BBQ Galore Master Budget 7 or the Quarter ended June 20> 10 Sales Budget Actual Actual Forecast Forecast Forecast Forecast 11 February March April June Quarter Tota Jul 12 Sales (Units] 14 Selling Price 15 Sales (5) 16 17 18 Collection Budget Assumption Actual Actual Forecast Forecast Forecast 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 20 30 Merchandise Purchases Budget Assumption Forecast Forecast Forecast Forecast 31 Inputs April May June Quarter Total Jul 32 33 Sales (units) 34 Desired ending Inventory (units) 35 Total needs 36 Less: Beginning Inventory 37 Purchases required (units) 38 39 Unit Cost 40 Purchases ($ 41 42 43 44 Merchandise Payments Budget Assumption Actual Forecast Forecast Forecast 45 Inputs March April May June Quarter Total 46 47 Purchases ($1 4843 44 Merchandise Payments Budget Assumption Actual Forecast Forecast Forecast 45 Inputs March April May June Quarter Total 46 47 Purchases ($) 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 61 Variable Labour Expense 62 63 Fixed Labour 64 Total Labour Expense 65 GE 67 Labour paid during month earned 68 Labour paid in following month 69 Total cash impact of labour 70 71 Wages Payable at month and 72 73 74 75 General and Administration Budget Assumption Forecast Forecast Forecast 76 Inputs April May June Quarter Total 77 78 Sales (Units] 79 GSA per unit 80 Variable GEA Expense 82 Fixed GEA EB Total GEA Expense 84 85 Less: Depreciation 86 GSA Cash Impact12 Cash Budget Forecast Forecast Forecast April May June Quarter Total 95 Opening Balance 96 Add: Collections 97 Cach Bailable 98 Disbursements 100 Merchandise 101 Labour 102 General and Administration 103 Fixed Asset Purchase 104 Clvidends 105 Total Disbursements 106 107 Cach balance before financing 108 Borrowing 109 Repayment 110 Interest Experne 111 Ending Balance 112 113 Line of Credit Balance at Month-end 114 115 Ending Inventory / COGS Budget Forecast Forecast Forecast 116 April May June Quarter Total 117 118 Cost per unit 119 120 Sales (Units] 121 Cost of Goods Sold 122 123 Beginning Inventory (units) 124 Purchases (units 125 Sales (Units) 126 Ending Inventory [Units] 127 128 Value of Ending Inventory 120 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) 130 Total ExpensesA C E G H 130 Budgeted Income Statement Forecast Forecast Forecast 131 April May June Quarter Tota CET 133 Sales 134 Cost of Goods Sold 135 Gross Profit 136 137 Labour 138 General and Administration (incl Depreciation) 130 Total Expenses 140 141 Net Income before fam 142 143 144 Budgeted Balance Sheet 145 Actual Forecast Forecast Forecast 146 April April June 147 148 Cad $100,000 149 Accounts Receivable $84,757 150 Merchandise Inventory $228,000 151 Fixed Assets $1 000,000 152 Less: Depreciation 350.000 153 Total Assets $1 062,757 154 155 Accounts payable $171,574 156 Wages Payable $8,572 157 Line of credit $0 158 Total Liabilities $180,146 150 160 Common Shares $650,000 161 Retained Earnings $232,411 162 Total Uabilities and Equity $1 062,757 163 164 165 Dale Chack -10