Empty Spaces Need To Be Filled. Many thanks!!

Input Data (USD Little Annin Flagmakers Yellow-1usc only cell reterences Sales Budget (USD) Blue-may lype numbers here Budgeted sales April (units) May (unils) unc units) luly (uits) August (units) May 6,000 $120 Expected 2,500 6,000 3,000 2,500 2,000 nTi Budgcted Sales (units): Sellin Price per uni Total Salcs: 3,000 $120 60,000 11.500 S120 1.380.000 2,500 $120 ,000 720,000 Little Annin Flagmakers Schedule ofExpeeled Cash Collections (USTD) Selng Prie unil $120.00 April May Quarter June Cash collection pattern Month of salc FollowiTTKh Uncollcctiblc Accounts Receivahle Bcpinning Balancc April Sales May Sales 40% Cash payments for materials Month of puchase Followinmh 40% 60 Tune Sales Production requirements Raw matcrial per unit (lb) Raw mal. uos pelb Direct labor hours per unit Direct labor rate per hour Variahle MOTTD ner DT. hour Hixed MOHD pe month Depreciati in Tixed MMOIID Total Cash Colleclions: $7.00 $40.00 $57,950 Accouits Receivable. June 30 Little Annin Flagmakers Producti BdL April May Quarter July August June $20,000 Budgeled Sales Add: Desirod cndine invcntory Direct labor rate per hour Variablc MOHD per DL hour $40.00 $10 $57,950 S20,000 Little Annin Flagmakers Production Budgct Mav une Quarter August per Trloi Dcpreciation in Fixcd MOHD Budgcted Salcs Add: Desired ending invenlory Total Needs Lcss: Bcginning inventory Required Production Selling & administrative costs Variable S&A cost pcr unit sold lFixed S&A cos per month Depreciation in tixed S&A cost $1.25 $63,000 S10,000 Little Annin Flagmakers Direct Malerials Budget (USD) Other cash outlows Cash dividends paid cach month Equipmenl purchases May Equipment purchases June S15,000 $47,820 S154,600 April May Quarter inc Required Produclion in units Raw Materials per unt (lbs.) Production Needs (lbs) Adl: Desired ending inventory Total Noeds ess: Beginninnventn Raw Materials to be purchased Cost of Raw Matcrials Total Cost ol Raw Malerials Desired ending inventory Finished Goods Raw Malerials Cash ($) 20% 10%, $30,000 Beginning account balances - March 31 Cash (S) Accounts Reccivable (S) liished (Ninveny $37,745 $132,000 $30,750 410 32,200 4,600 $ 55,000 L.ittle Anni lagmakers Schedule of Expccted Cash Disburscmcnts for Matcrial (USD) FG inventory (units) Raw Materialsinvenlo Raw Materials (Ib) Accounts Payable (S) May Quarler nTi Accounts l'ayable Beginning Balancc Finished Goods inventory $30,750 S32,200 S55,000 l.ittle Annin Flagmakers Schedule of kxpected Cash Disbursemcnts for Material (USD) Fi invenlory (units) Raw Malcrialsnventory 410 May Quarter April unc Raw Materials (Ib) Accounts Payable () 4,600 Accounts Payablc Beginning Balance l.and Buildings and equipment Accumulated Depreciation Common stock Retained earnings S520,000 $1,800,000 ($750,000) S500,000 $1,247,69:5 April Purchascs May Purchases June Purchases Total Cash Disbursements For Materials Accounts Pavable, 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 Direct Labor Budget (USD) April June Quarter av 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 June Quarter av Budgeted DL hours Variable MOHD rate Total Variable MOHD Fixed MOHD Expense Total MOHD Expense Less: Depreciatiorn Cash disbursements for MOHD M-OHD rate DLH 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) Cost of Goods Sold (FIFO) Beg. FG inventory Add: Cost of Goods Mfg'd Good Available for Sale Less: Ending FG inventor Cost of Good Sold Units Cost/unit Total Cost Little Annin Flagmakers Budgeted Income Statement (USD) Quarter Ending: June 30 Net Sales Less: Cost of Goods Sold UTOSS 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 Invento Plant and Equipment Land Buildings and Equipment Accumulated Depreciation Total Assets Liabilities Accounts Pavable Stockholder's Equity Common Stock Retained Earnings Total Liabilities and stockholder's equity