Input Data (USD) Yellow-use only cell references Little Annin Flagmakers y type numbers here Sales Budgct (USD) Budgeted sales April (units) May (units) June (units) uly (units) August (units) Expected Budgeted Sales (units) Selling Price per unit: Total Sales: 11,500 $120 S300,000 $720,000S360,000 S 1,380,000 April 2,500 $120 Junc 3,000 $120 6,000 $120 3,000 2,000 120.00 Little Annin Flagmakers Schedule of Expected Cash Collections (USD) Selling Price/unit April June Cash collection pattern Month of sale Following month Uncollectible Accounts Receivable 40% Beginning Balance April Sales May Sales 5% Cash payments for materials Month of purchase Following month June Sales Production requirements Raw material per unit (Ib) Raw mat. cost pcr lb Direct labor hours per unit Direct labor rate per hour Variable MOHD per DL hour Fixed MOHD per month Depreciation in Fixed MOHD Total Cash Collections: $7.00 0.5 $40.00 S10 $57,950 $20,000 Accounts Reccivable, June 30: Little Annin Flagmakers Production Budget April Junc JulyAugust Budgeted Sales Add: Desired ending inventory Direct labor rate per hour Variable MOHD per DL hour Fixed MOHD per month Depreciation in Fixed MOHD $40.00 $10 S57,950 S20,000 Little Annin Flagmakers Production Budget April May Quarter ulyAugust Selling & administrative costs Variable S&A cost per unit sold Fixed S&A cost per month Depreciation in Fixed S&A cost Budgeted Sales Add: Desired endin Total Needs Less: Be Required Production $1.25 S63,000 $10,000 Little Annin Flagmakers Direct Materials Budget (USD) April Other cash outlows Cash dividends paid each month Equipment purchases May Equipment purchases June S15,000 S47,820 $154,600 May Quarter 1 Required Production in units Raw Materials per unit Production Needs (Ibs) Add: Desired endin Total Needs Less: Be Raw Materials to be purchased Cost of Raw Materials: Total Cost of Raw Materials Desired ending inventory Finished Goods Raw Materials Cash (S) S30,000 Beginning account balances- March 31 Cash (S) Accounts Reccivable (S) Finished Goods invent S37,745 $132,000 $30,750 410 $32,200 4,600 $55,000 Little Annin Flagmakers Schedulc of Expected Cash Disbursements for Material (USD FG inventory (units) Raw Materials i May Quarter Raw Materials (Ib) Accounts Payable Beginning Balance Accounts Payable (S) S520,000 $1,800,000 April Purchases Buildings and equipment Finished Goods inven S30,750 410 S32,200 4,600 S55,000 Little Annin Flagmakers Schedule of Expected Cash Disbursements for Material (USD FG inventory (units) Raw Materials i April May June Quarter Raw Materials (Ib) Accounts Payable ( Accounts Payable S520,000 $1,800,000 ($750,000) S500,000 S1,247,69:5 Beginning Balance April Purchases May Purchases Land Buildings and equipment Common stock Retained carnings June Purchascs Total Cash Disbursements For Materials Accounts Payable, June 30: Little Annin Flagmakers Direct Labor Budget (USD) April May Junc Quarter Units to be produced DL hours per unit Total DL hours necded DL cost per hour Total direct labor cost Little Annin Flagmakers Manufacturing Overhead Budget (USD) April May June Quarter Budgcted DL hours Variable MOHD rate
