please provide excel formulas:)

Effects Ares Area Tales Scale 100% Scale to Print Print Sheet Options 5 Forward Backward - Pane Themes Page Setup TE 2020 November ber December QUARTER October $ 150,000.00 $2,475,000.00 $ 2,625,000.00 $ 14,500.00 Beginning Cash Balance Cash Collections Available Cash Balance Cash Disbursements: Direct Material Prior Direct Material Current Direct Labor Overhead S&A Factory Update Total Cash Disbursements Borrowings Interest Repayments EMININA RACUDAR ACP Cash Budget Income Statement Balance Sheet Goal Seek Tale Area Page Setup Theses Scale: 100% Scale tot Forward Backward s Print Print Shert Options 89 $ 2,625,000.00 $ 14,500.00 6 Available Cash Balance 7 Cash Disbursements: 8 Direct Material Prior 9 Direct Material Current 10 Direct Labor 11 Overhead 12 S&A 13 Factory Update 14 Total Cash Disbursements 15 Borrowings 16 Interest 17 Repayments 18 ENDING CASH BALANCE de Cash Budget Income Statement Balance Sheet Goal Seek File Aa Home Colors A Fonts - Effects Insert Page Layout Formulas Data Review IN E Margins Orientation Size Print Breaks Background Print Area - Titles Page Setup Themes View Help Width Page Il Height 1 page Scale 65% Scale to fit Gridines Headings View View - Send Backward Al Bring Print PrintForward Sheet Options 5 Themes Selection Pare Arrange 5 E36 - X 30750 D G H K October 2020 30,000 February LF December January 2020 2021 55,000 47,000 November 2020 34,000 7 Sales in Units (Sweaters) 2021 32,000 9 Selling Price per Sweater 100.00 11 Cash Sales Collected in the Month of Sale 12 Credit Sales Collected in the Month of Sale 13 Credit Sales Collected in the following Month 30% 50% 20% 15 Inventory Policy 16 Ending FG Inventory Requirement 17 Ending FG Inventory, September 30, 2020 3% of next months unit sweater sales 1,500 sweaters 19 Product Input Expenses 20 Direct Materials 21 Ending RM Inventory, September 30, 2020 22 Yards of Wool Required per Sweater 23 Raw Materials Cost per Yard of Wool 24 Ending RM Inventory Requirement 8265.60 yards 4 yards per sweater 3.50 per yard 7% of next months sweater production needs 26 Wool Purchases Paid for in the Month of Purchase 27 Wool Purchases Paid for in the Month following the Purchase 85% 1596 28 INPUTS INPUTS - Balance Sheet FG Inventory Cost per Unit Sales Budget Expected Cash Co ... LA Theme A Fonts - Effects EFF Margins Orientation Size Print Breaks Background Print Titles Page Setup 5 X 30750 Width 1 page 1 Height 1 page Scale Scale to Fit Gridlines Headings View View Print Print Sheet Options Themes Bring Forward Send Bachowed Selection AL Pane - Arrange E36 - 29 Direct Labor 30 Number of Workers Required for the Making of Each 31 Labor Hours Required per Worker per Unit of FG (Sweater) 32 Labor Cost per Hour 33 34 Manufacturing Overhead 35 Variable Manufacturing Overhead 36 Fixed Manufacturing Overhead 37 Noncash Fixed Manufacturing Overhead (included in above) 2 workers 0.5 hours 15.00 per hour $ $ 1175 per sweater 30,200.00 per month (Oct.) 10,250,00 per month (Oc) $ $ 30,750.00 per month (Nov. & beyond) 15,750.00 per month (Now & beyond) 39 Selling & Administrative Expenses 40 Variable S&A 41 Fixed S&A 42 Noncosh Fixed S&A (included in above) $ $ 7.37 per unit sold 23,900.00 per month (10,750.00) per month 44 Factory Update & Cash Flow 45 Factory Update (PP&E) $ 400,500,00 paid on October 31, 2020 47 Principle Borrowed on October 1, 2020 48 Principle Repaid on November 30, 2020 49 Interest Payment on Borrowings in October & November 50 $ 300,000.00 $ 300,000.00 $ 9,000.00 per month paid in following month) Themes E36 29 Direc 30 Numi 31 Labo 32 Labo 34 Man 35 Varie 36 Fixed 37 Nond 39 Selling H0 Vario 11 Fixed 2 Nong 3rd Quarter Balance Sheet Lexie's Wool Sweaters Balance Sheet As of September 30, 2020 ASSETS LIABILITIES & EQUITIES Cash $ 150,000.00 Accounts Payable Accounts Receivable $ 75,000.00 Notes Payable Raw Materials Inventory $ 28,929.60 Interest Payable Finished Goods Inventory $ 61,125.00 TOTAL LIABILITIES $ 14,500.00 PP&E, net $ 487,000.00 Retained Earnings $ 787,554.60 TOTAL ASSETS $ 802,054.60 TOTAL LIABILITIES & EQUITY'S 802,054.60 $ 14,50010 4 Facto 5 Facto Princi Princi Intere . . . . . . . . . .................... Page 2 of 5 1293 words Inc