Help with this Cost Accounting Project? I need help with filling out this assignment. If you can help me fill out the first sections like (formula 1, 2, 3 and so on) with giving me your explanation of how you got it. I can fill out the spreadsheet that fills it into the excel sheet. I need to fill out the Monthly sales budget, production budget, purchases budget, direct labor budget, factory overhead budget, cash budget, cost of goods sold budget, forecasted income statement for the quarter, and a forecasted June 30 balance sheet. Need to fill in Formulas with how we get our answers. Check figure: is that total assets at June 30 (cell D193) should be $227,842

Master Budget for Manufacturer
Balance Sheet, March 31, 2001
Cash	$9,000
Accounts receivable	85,210
Raw material inventory	8,408
Finished goods inventory	11,450
Equipment (net)	125,000
Total assets	$239,068
Accounts payable	$8,520
Common stock	150,000
Retained earnings	80,548
Total liabilities & equity	$239,068
Actual and Budgeted Unit Sales, 2001	Paddles	Seats
January	1,900	1,300
February	2,000	1,400
March	2,700	1,300
April	2,400	1,100
May	2,600	1,300
June	2,300	1,000
July	2,900	900
August	3,000	1,000
Manufacturing Standards
		Paddles	Seats
Materials:	Cost	Quantity	Quantity
Resin A	$0.45	2	3
Hardner Q	0.70	5	2
Labor:
Dept. 1	$7.00	0.30	0.20
Dept. 2	8.00	0.20	0.20
Factory Overhead:
Dept. 1	$5.00	0.30	0.20
Dept. 2	11.00	0.20	0.20
Other Data
Selling price:
Paddles			$20
Seats			$14
Beginning inventories:
Paddles (units)			720
Seats (units)			330
Resin A (liters)			5,040
Hardner Q (liters)			8,772
Desired ending inventories (% of next month's sales):
Finished goods inventory (units)			30%
Raw material inventory (units)			60%
Collections from customers:
% Collected month of sale			15%
% Collected month after sale			45%
% Collected two months after sale			40%
Cash payments to suppliers:
% Paid in month of purchase			40%
% Paid in following month			60%
Selling and administrative expenses:
Variable (% of total sales)			7%
Fixed: Cash			$24,000
Depreciation			$1,000
Factory overhead depreciation rate (per hour)			$1
Answer Section
Sales Budget
	April	May	June
Canoe paddles	FORMULA1	$0	$0
Toilet seats	FORMULA2	0	0
Total	$0	$0	$0
Production Budget (Units)
Canoe Paddles	April	May	June
Desired ending inventory	FORMULA3	0	0
This month's sales	FORMULA4	0	0
Total needed	FORMULA5	0	0
Beginning inventory	FORMULA6	0	0
Production required (units)	FORMULA7	0	0
Toilet Seats
Desired ending inventory	0	0	0
This month's sales	0	0	0
Total needed	0	0	0
Beginning inventory	0	0	0
Production required (units)	0	0	0
Purchases Budget
Resin A	April	May	June
Desired ending inventory	FORMULA8	0	0
Required for production	FORMULA9	0	0
Total needed	FORMULA10	0	0
Beginning inventory	FORMULA11	0	0
Purchases required (units)	FORMULA12	0	0
Purchases required (dollars)	FORMULA13	$0	$0
Hardner Q
Desired ending inventory	0	0	0
Required for production	0	0	0
Total needed	0	0	0
Beginning inventory	0	0	0
Purchases required (units)	0	0	0
Purchases required (dollars)	$0	$0	$0
Total purchases budgeted (dollars)	$0	$0	$0
Direct Labor Budget
	April	May	June
Labor hours needed for production:
Department 1	FORMULA14	0	0
Department 2	FORMULA15	0	0
Total	0	0	0
Cost of direct labor:
Department 1	FORMULA16	$0	$0
Department 2	FORMULA17	0	0
Total	$0	$0	$0
Factory Overhead Budget
	April	May	June
Department 1	FORMULA18	$0	$0
Department 2	FORMULA19	0	0
Total	$0	$0	$0
Projected Cost of Goods Sold
Unit cost of canoe paddles		FORMULA20
Unit cost of toilet seats		FORMULA21
	April	May	June
Canoe paddles	FORMULA22	$0	$0
Toilet seats	FORMULA23	0	0
Total cost of goods sold	$0	$0	$0
Cash Budget
	April	May	June
Cash balance, beginning	$9,000	$0	$0
Cash receipts:
Collections from customers:
From February sales	FORMULA24
From March sales	FORMULA25	0
From April sales	FORMULA26	0	0
From May sales		0	0
From June sales			0
Total cash available	$0	$0	$0
Cash disbursements:
Raw material acquisitions:
From March purchases	FORMULA27
From April purchases	FORMULA28	0
From May purchases		0	0
From June purchases			0
Direct labor	FORMULA29	0	0
Factory overhead	FORMULA30	0	0
Selling and administrative	FORMULA31	0	0
Interest paid	0	0	0
Total disbursements	$0	$0	$0
Cash balance before financing	$0	$0	$0
Less desired ending balance	0	0	0
Excess (deficit) of cash over needs	$0	$0	$0
Line of Credit:
Borrowing	$0	$0	$0
Repayment	0	0	0
Total effects of financing	$0	$0	$0
Cash balance, ending	$0	$0	$0
Forecasted Income Statement
For Quarter Ended June 30, 2001
Sales			FORMULA32
Cost of goods sold			FORMULA33
Gross profit			$0
Expenses:
Selling and administrative			FORMULA34
Interest expense			0
Total expenses			$0
Net income			$0
Forecasted Balance Sheet
June 30, 2001
Assets
Cash			FORMULA35
Accounts receivable			FORMULA36
Raw material inventory			FORMULA37
Finished goods inventory			FORMULA38
Equipment (net)			FORMULA39
Total assets			$0
Liabilities and Equity
Accounts payable			FORMULA40
Line of credit payable			0
Common stock			0
Retained earnings			FORMULA41
Total liabilities & equity			$0