Input Data (USD) Budgeted sales April (units) May (units) June (units) 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 Fixed S&A cost Other cash outflows Cash dividends paid each month Equipment purchases May Equipment purchases June Desired ending inventory Finished Goods Expected 3,500 Yellow-use only cell references Blue-may type numbers here Budgeted Sales (units): 4,500 Selling Price per unit: 3,000 Total Sales: 2,000 2,500 $ 130.00 Raw Materials Cash ($) Beginning account balances - March 31 Cash ($) Accounts Receivable ($) Finished Goods inventory FG cost per unit FG inventory (units) Raw Materials inventory Raw Materials (lb) Accounts Payable ($) Land Buildings and equipment Accumulated Depreciation Common stock Retained earnings $ $ $ $ $ $ Little Annin Flagmakers April Sales Budget (USD) May June Quarter April (units) June Quarter Accounts Receivable Beginning Balance Little Annin Flagmakers Schedule of Expected Cash Collections (USD) April May April Sales May Sales June Sales Total Cash Collections: Accounts Receivable, June 30: Budgeted Sales Add: Desired ending inventory Total Needs Less: Beginning inventory Required Production Required Production in units Raw Materials per unit (lbs.) Production Needs (lbs) Add: Desired ending inventory Total Needs Less: Beginning inventory Raw Materials to be purchased Cost of Raw Materials: Total Cost of Raw Materials Accounts Payable Beginning Balance April Little Annin Flagmakers Production Budget May June Quarter July August Little Annin Flagmakers Direct Materials Budget (USD) April May June Quarter Little Annin Flagmakers Schedule of Expected Cash Disbursements for Material (USD) April May June April Purchases May Purchases June Purchases Total Cash Disbursements For Materials Accounts Payable, June 30: Units to be produced DL hours per unit Total DL hours needed DL cost per hour Total direct labor cost Quarter Little Annin Flagmakers Direct Labor Budget (USD) April May June Quarter