Budgeted sales	Expected
April (units)	2,500
May (units)	6,000
June (units)	3,000
July (units)	2,500
August (units)	2,000
Selling Price/unit	$120.00
Cash collection pattern
Month of sale	40%
Following month	55%
Uncollectible	5%
Cash payments for materials
Month of purchase	40%
Following month	60%
Production requirements
Raw material per unit (lb)	5
Raw mat. cost per lb	$7.00
Direct labor hours per unit	0.5
Direct labor rate per hour	$40.00
Variable MOHD per DL hour	$10
Fixed MOHD per month	$57,950
Depreciation in Fixed MOHD	$20,000
Selling & administrative costs
Variable S&A cost per unit sold	$1.25
Fixed S&A cost per month	$63,000
Depreciation in Fixed S&A cost	$10,000
Other cash outflows
Cash dividends paid each month	$15,000
Equipment purchases May	$47,820
Equipment purchases June	$154,600
Desired ending inventory
Finished Goods	20%
Raw Materials	40%
Cash ($)	$30,000
Beginning account balances - March 31
Cash ($)	$37,745
Accounts Receivable ($)	$132,000
Finished Goods inventory	$30,750
FG inventory (units)	410
Raw Materials inventory	$32,200
Raw Materials (lb)	4,600
Accounts Payable ($)	$55,000
Land	$520,000
Buildings and equipment	$1,800,000
Accumulated Depreciation	($750,000)
Common stock	$500,000
Retained earnings	$1,247,695

Little Annin Flagmakers Selling and Administrative Expense Budget (USD) April May June Quarter Budgeted sales in units Variable S&A per unit Total Variable S&A Total Fixed S&A Total S&A Expense Less: Depreciation Cash Disbursements for S&A Little Annin Flagmakers Cash Budget (USD) April May June Quarter Cash Balance, Beginning: Add: Receipts Cash Collection:s Total Cash Available Less Disbursements: Direct Materials Direct Labor Manufacturing Overhead Selling and Administrative Dividends Equipment Purchases Total Disbursements