Input Data (USD) Yellow use only cell references Bloc-may type numbers here- Little Annin Flagmakers Budgeted sales. April (units) May (units) June (units) July (units) Expected 3,500 Budgeted Sales (units) Sales Budget (USD) April May June Quarter April (units) 4,500 Selling Price per unit: 3,000 Total Sales: 2,000 August (units) 2,500 Little Annin Flagmakers Selling Price/unit 130.00 Schedule of Expected Cash Collections (USD) April May June Quarter Cash collection pattern Accounts Receivable Month of sale 45% Beginning Balance Following month 50% Uncollectible 5% April Sales Cash payments for materials May Sales Month of purchase 60% Following month 40% June Sales Production requirements. Total Cash Collections: Raw material per unit (lb) Raw mat, cost per lb $10.00 Accounts Receivable, June 30 Direct labor hours per unit 0.7 Direct labor rate per hour $36.00 Variable MOHD per DL hour $12 Fixed MOHD per month $58,000 April Little Annin Flagmakers Production Budget May June Quarter Depreciation in Fixed MOHD $25,000 Budgeted Sales Add: Desired ending inventory