1. Complete the SALES BUDGET
	Deck Corp
	Sales Budget
	For the 3 months ending March 31, 2013
	Dec	Jan	Feb	Mar	Total	Apr	May
Sales in Units	26,000	22,000	30,000	45,000	97,000	42,000	40,000
Selling Price/unit	9.50	9.50	9.50	9.50	9.50	9.50	9.50
Sales in $	247,000.00	209,000.00	285,000.00	427,500.00	921,500.00	399,000.00	380,000.00

2. Complete the CASH COLLECTIONS SCHEDULE
Deck Corp
Budgeted Cash Collections
For the 3 months ending March 31, 2013
	Jan	Feb	Mar	Total
Accounts Receivable Dec 31	172,900.00	146,300.00	199,500.00	518,700.00
From Jan sales	209,000.00			921,500.00
From Feb sales		285,000.00
From Mar sales			427,500.00
Less: Total cash collected each month	(235,600.00)	(231,800.00)	(327,750.00)	(795,150.00)
Budgeted Accounts Receivable Mar 31	146,300.00	199,500.00	299,250.00	645,050.00

3. Complete the PRODUCTION BUDGET
Deck Corp.
Production Budget
For the 3 months ending March 31, 2013
	Dec	Jan	Feb	Mar	Total	Apr	May
Sales in units	26,000	22,000	30,000	45,000	97,000	42,000	40,000
Add:Desired Ending Inventory (20% of the next month sales)	4,400	6,000	9,000	8,400	23,400	8,000	0
Total Needs	30,400	28,000	39,000	53,400	120,400	50,000	40,000
Less:Beginning Inventory	(8,000)	(4,400)	(6,000)	(9,000)	(19,400)	(8,400)	(8,000)
Production in Units	22,400	23,600	33,000	44,400	101,000	41,600	32,000

4. Complete the DIRECT MATERIALS BUDGET
Deck Corp.
Direct Materials Purchases Budget
For the 3 months ending March 31, 2013
	Dec	Jan	Feb	Mar	Total	Apr	May
Production in units	26,000	22,000	30,000	45,000	97,000	42,000	40,000
DM quantity per unit (kg)	0.35	0.35	0.35	0.35	0.35	0.35	0.35
DM quantity for production	9,100	7,700	10,500	15,750	33,950	14,700	14,000
Add:Desired Ending Balance	1,155	1,575	2,363	5,093	9,030	2,100	0
Total Needs	10,255	9,275	12,863	20,843	42,980	16,800	14,000
Less: Beginning Inventory	0	(1,155)	(1,575)	(2,363)	(5,093)	(5,093)	(2,100)
Kgs to be purchased	10,255	8,120	11,288	18,480	37,888	11,708	11,900
Unit Cost	$ 1.75	$ 1.75	$ 1.75	$ 1.75	$ 1.75	$ 1.75	$ 1.75
Purchases in dollars	$ 17,946	$ 14,210	$ 19,753	$ 32,340	$ 66,303	$ 20,488	$ 20,825

5. Complete the CASH DISBURSEMENTS SCHEDULE
Deck Corp.
Budgeted Cash Disbursements for Purchases
For the 3 months ending March 31, 2013
	Jan	Feb	Mar	Total
Accounts Payable Dec 31	$ 30,765	$ 24,360	$ 33,863	$ 88,988
From Jan purchases	40,600			40,600
From Feb purchases		56,438		56,438
From Mar purchases			92,400	92,400
Total cash disbursements each month	(47,005)	(46,935)	(70,823)	(164,763)
Budgeted Accounts Payable Mar 31	$ 24,360	$ 33,863	$ 55,440	$ 113,663

6. Complete the DIRECT LABOUR BUDGET
Deck Corp.
Direct Labour Budget
For the 3 months ending March 31, 2013
	Jan	Feb	Mar	Total
Production in Units	22,000	30,000	45,000	97,000
DL hours per unit	0.20	0.20	0.20	0.20
Total DLH	4,400	6,000	9,000	19,400
DL rate per hour	$ 3.00	$ 3.00	$ 3.00	$ 3.00
Direct Labour Budget	$ 13,200.00	$ 18,000.00	$ 27,000.00	$ 58,200.00

7. Complete the MANUFACTURING OVERHEAD BUDGET for JANUARY only (4 marks)
	January
Variable Overhead ($8.00 x 4,400 DLH)	$ 35,200.00
Fixed Overhead ($180,000-$24,000)	180,000.00
Total	215,200.00
Less:Non-cash items:
Depreciation	(24,000.00)
Cash Disbursements for Manufacturing Overhead	191,200.00

8. Complete the SELLING AND ADMINISTRATIVE BUDGET for JANUARY only (3 marks)
	January
Variable Selling & Administrative:	$ 4,180.00
Fixed Selling & Administrative	26,000.00
Total Selling and Administrative Expenses	30,180.00
Less:Non-cash Items:
Amortization	(6,000.00)
Cash Disbursements for Selling and Admin	$ 24,180.00

9. Complete the CASH BUDGET for JANUARY only (11 marks)
	January
Beginning cash balance	$ 76,153.00
Add: Cash collections	235,600.00
Total cash available	311,753.00
Cash Disbursements:
Payment of purchases	16,451.75
Direct labour	13,200.00
Manufacturing overhead	191,200.00
Selling & Admin	24,180.00
Total disbursements	245,031.75
Excess/Deficient Cash Balance	66,721.25
Financing:
Cash borrowed	0
Cash repaid	0
Interest	0
Total financing	0
Ending cash balance	$ 66,721.25