Input Data (USD) Budgeted sales April (units) May (units) June (units) July (units) August (units) Expected 3,000 3,500 4,000 5,000 2.000 Selling Price unit s 120.00 50% 45% 59 60% 40% 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 1b Direct labor hours per unit Direct labor rate per hour Variable MOHD per DL hour Fixed MOHD per month Depreciation in Fixed MOHD 10 $6.00 0.4 $25.00 515 550.000 $25,000 Selling & administrative costs Variable S&A cost per unit sold Fixed S&A cost per month Depreciation in Fixed S&A cost $1.50 560,000 $30.000 Other cash outflows Cash dividends paid each month Equipment purchases May Equipment purchases June $30,000 $20,000 $10,000 Desired ending inventory Finished Goods (% of next month sales) Raw Materials (% of next month production Minimum cash required (5) 25% 40% $30,000 37.695 132,000 S S 35,000 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) $70.00 500 s 22.250 s Land Buildings and equipment Accumulated Depreciation Common stock Retained earnings 4,500 85.000 $500,000 $1,800,000 (5750,000) $500.000 $1,191.945 Schedule of Expected Cash Disbursements for Material (USD) April May June Quarter Accounts Payable Beginning Balance April Purchases May Purchases June Purchases Total Cash Disbursements For Materials Accounts Payable, June 30: Little Annin Flagmakers Direct Labor Budget (USD) April May June Quarter 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 Budgeted DL hours Variable MOHD rate Total Variable MOHD Fixed MOHD Expanse Total MOHD Expense Less: Depreciation Cash disbursements for MOHD M-OHD rate DLH Little Annin Flagmakers Unit Product Cost (USD) Quantity Cost Costunit Absorption cost per unit Direct Materials Direct Labor Manufacturing Overhead Unit Product Cost