Input Data (USD) Quarter S Quarter Budgeted sales April (units) May (umits) June (unit) July (units) August (units) Selling Price unit Cash collection pattern Month of sale Following month Uncollectible Cash payments for materials Month of purchase Following month Production requirements Raw material per unit (lb) Raw mat. cost per lb Direct labor hours per unit Direct labor rate per hour Variable MOHD per DL hour Fixed MOHD per month Depreciation in Fixed MOHD Selling & administrative costs Variable S&A cost per unit sold Fixed S&A cost per month Depreciation in Fisted S&A cost Quarter July August Quarter Other cash outflows Cash dividends paid each month Equipment purchases May Equipment purchases June Desired ending inventory Finished Goods (% of next month sales) Raw Materials (% of next month production Minimum cash required (5) Beginning account balances - March 31 Cash (5) $ Accounts Receivable (5) $ Finished Goods inventory $ FG cost per unit FG inventory (units) Raw Materials inventory $ Raw Materials (lb) Accounts Payable (5) S Land Buildings and equipment Accumulated Depreciation Common stock Retained earnings Yellow-use only cell references Little Annin Flagnakers Blue-may type numbers here Sales Budget (USD) Expected April May June 3.000 Budgeted Sales (units): 3,500 Selling Price per unit 4,000 Total Sales 5,000 2,000 Little Annin Flagmakers 120.00 Schedule of Expected Cash Collections (USD) April May June Accounts Receivable 50% Beginning Balance $ 132,000 45% 3% April Sales May Sales 6096 40% June Sales Total Cash Collections: 10 56.00 Accounts Receivable, June 30: 0.4 $25.00 Little Annin Flagmakers S15 Production Budget $50,000 April May June $25,000 Budgeted Sales Add Desired ending inventory Total Needs $1.50 Less: Beginning inventory $60,000 Required Production $30,000 Little Annin Flagmakers Direct Materials Budget (USD) $30,000 April May June $20,000 Required Production in uits $10,000 Raw Materials per unit (lbs.) Production Needs (lbs) Add: Desired ending inventory 25% Total Needs 40% Less: Beginning inventory $30,000 Raw Materials to be purchased Cost of Raw Materials Total Cost of Raw Materials 37,695 132.000 35,000 Little Annin Flagmakers $70.00 Schedule of Expected Cash Disbursements for Material (USD) 500 April May June 22,250 Accounts Payable 4.500 Beginning Balance 85,000 $500,000 April Purchases $1,800,000 ($750,000) May Purchases $500,000 $1.191.945 June Purchases Total Cash Disbursements For Materials Accounts Payable, June 30: Little Annin Flagmakers Direct Labor Budget (USD) April May June Units to be produced DL hours per unit Total DL hours needed DL cost per hour Total direct labor cost Little Annin Flagmakers Manufacturing Overhead Budget (USD) April May June Quarter Quarter Quarter DL hours per mit Total DL hours needed DL cost per hour Total direct labor cost Little Aunin Flagmakers Manufacturing Overhead Budget (USD) April May June Quarter Budgeted DL hours Variable MOHD rate Total Variable MOHD Fixed MOHD Expense Total MOHD Expertise Less Depreciation Cash disbursements for MOHD M-OHD rate DLH Little Annie Flagmakers Unit Product Cost (USD) Quantity Cost Costunit Absorption cost per unit Direct Materials Direct Labor Manufacturing Overhead Unit Product Cost Little Annin Flagmakers Cost of Goods Sold Budget (USD) Units Costumit Total Cost Cost of Goods Sold (FIFO) Beg FG inventory Add: Cost of Goods Med Good Available for Sale Less Ending FG inventary Cost of Good Sold Little Angin Flagmakers Selling and Administrative Expense Budget (USD) April Nay June Quarter Budgeted sales in units Variable S&A permit Total Variable S&A Total Fixed S&A Total S&A Expense Less: Depreciation Cash Disbursements for S&A Little Aunin Flagmakers Cash Budget (USD) April Ngay June Quarter Cash Balance Beginning AddReceipts Cash Collections Total Cash Available Less Disbursements Direct Materials Direct Labor Manufacturing Overhead Selling and Administrative Dividends Equipment Purchases Total Disbursements Excess (deficiency) of cash available Financing Borrowing Repayments Interest Cash Balance, ending Little Annie Flagmakers Budgeted Income Statement (USD) Quarter Ending: June 30 Net Sales Less: Cost of Goods Sold Gross Margin Less S&A Expenses Net Operating Income Less Interest Expense Net Income *Computation of Net Sales Sales: Less uncollectible amounts Net Sales Little Annin Flagmakers Budgeted Balance Sheet (USD) Ending March 31st Ending June 30th Current Assets: Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Plant and Equipment: Land Buildings and Equipment Accumulated Depreciation Total Assets: Liabilities: Accounts Payable Debt Outstanding Stockholder's Equity: Common Stock Retained Earnings Total Liabilities and stockholder's equity