Schedule of Expected Cash Collections (USD) April May June Quarter Accounts Receivable Beginning Balance S 132,000 April Sales May Sales June Sales Total Cash Collections: Accounts Receivable, June 30: Little Annin Flagmakers Production Budget April May 3,000 3,500 June 4,000 Quarter 10,500 July 5,000 August 2,000 Budgeted Sales Add: Desired ending inventory Total Needs Less: Beginning inventory Required Production Little Annin Flagmakers Direct Materials Budget (USD) April May June Quarter 10 10 10 10 Required Production in units Raw Materials per unit (lbs. Production Needs (lbs Add: Desired ending inventory Total Needs Less: Beginning inventor Raw Materials to be purchased Cost of Raw Materials: Total Cost of Raw Materials $6.00 $6.00 56.00 $6.00 Little Annin Flagmakers 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 0.4 0.4 0.4 0:4 Units to be produced DL hours per unit Total DL hours needed DL cost per hour Total direct labor cost $25.00 $25.00 $25.00 S25.00 Little Annin Flagmakers Manufacturing Overhead Budget (USD) April May : June Quarter Budgeted DL hours Variable MOHD rate Total Variable MOHD Fixed MOHD Expense Total MOHD Expense Less Depreciation Cash disbursements for NIOHD MOHD rata DLH 4 E1 D F H Little Annin Flagmakers Unit Product Cost (USD) Quantity Cost Cost/unit Absorption cost per unit Direct Materials Direct Labor Manufacturing Overhead Unit Product Cost Little Annin Flagmakers Cost of Goods Sold Budget (USD) Units Costunit Total Cost Cost of Goods Sold (FIFO) Beg, FG inventory Add: Cost of Goods Mfg'd Good Available for Sale Less: Ending FG inventory Cost of Good Sold Quarter Little Annin Flagmakers Selling and Administrative Expense Budget (USD) April May June Budgeted sales in units Variable S&A per unit Total Variable S&A Total Fixed S&A Total S&A Expense Less: Depreciation Cash Disbursements for S&A Little Annin Flagmakers Cash Budget (USD) April May June Quarter Cash Balance, Beginning: Add: Receipts 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 Annin Flagmakers Budgeted Income Statement (USD) Quarter Ending June 30 Net Sales Len: Cost of Goods Sold Gross Margus Less: S&A Expenses Net Operating Income Len Interest Expense Nes income Computation of Net Sales D E G H 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 Eamines Total Liabilities and stockholder's equity: 229 Input Data (USD) 2 Budgeted sales April (unuts) May (units) June (units) July (mits) Aurust (units) Espected 3,000 3,500 4,000 5,000 2,000 Selling Price/unit $ 120.00 Cash collection pattern Month of sale Follouing month Uncollectible 50% 4594 59 Cash payments for materials Month of purchase Following meth 604 404 Production requirements Rais material per tunity Raw mat cost per 15 Direct labor hours per unit Direct labor rate per hour Variable MOHD pe DL hour Fixed MOHD per month Depreciation Fusced IOHD 10 $6.00 04 $25.00 SIS 550.000 $25.000 Selling & administrative costs arable S&cost perisit told ESL cost petit Detection S&R 11 SIE S000 Sco Other cash outfion Cu dich Eesti But 500 S2010 Sitio Dediedesigners PA be here to search E29 - A B 20 21 ma 24 25 26 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 10 $6,00 0.4 $25 00 $15 $50,000 $25,000 22 20 21 20 Selling & administrative costs Variable S&A cost per unit sold 22 Fixed S&A cost per month Depreciation in Fixed S&A cost $1.50 $60,000 $30.000 34 24 19 26 27 28 $30,000 $20,000 $10,000 20 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 product Minimum cash required (5) THE 25. 40% $30,000 Beginning account balances - March 31 Cain (5) S 37.693 Accounts Receivable (5) $132.000 Fished Goods story $ 35.000 FG cost per un $10.00 FG intents 500 Sheralstory SO Raw Material 0 Accounts Payable S 85000 Lan 5300.000 Building met SLO Aceamed Deprecia 5250.000 Comm. 530000 Recetas 58119 Tre here to search