please show excel formulas for the charts:)

X D Manufacturing Overhead Budget 2020 October November December QUARTER 4 Units Produced 5 Variable Overhead Rate per Unit 6 Total Variable Overhead Cost 7 Fixed Overhead 8 TOTAL OVERHEAD COST 9 Noncash Overhead Expenses 10 TOTAL OVERHEAD DISBURSEMENTS BX TW Cen MT -12- BIV-A AE ID - Number $ % 8-99 Paste Conditional Formatting Format as Table Cell Styles Styles Insert 33 Delete- Format 2 Editing L Ideas Sensitivity Clipboard Font Alignment Number Ces Ideas Sensitivity D Selling & Administrative Expense Budget 2020 October November December Q UARTER 4 Unit Sales 5 Variable S&A per Unit 6 Total Variable S&A Fixed S&A TOTAL S&A EXPENSE 9 Noncash S&A Expenses 10 TOTAL S&A DISBURSEMENTS 13 RM Budget DL Budget OH Budget S&A Budget Cas... I Ready Clipboard Font Paragraph Styles 3rd Quarter Balance Sheet Lexie's Wool Sweaters Balance Sheet As of September 30, 2020 ASSETS LIABILITIES & EQUITIES Cash $ 150,000.00 Accounts Payable $ 14,500.00 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 S 487,000.00 Retained Earnings $ 787,554.60 TOTAL ASSETS $ 802,054.60 TOTAL LIABILITIES & EQUITY S 802,054.60 . Page 3 of 1293 words D. Focus on - Paste Editing 2- A E 8 -98 Cell Styles Format Clipboard Alignment Cells E36 X 30750 Projected Budgeting Data 5 Sales & Collections January October 2020 30,000 November 2020 34,000 December 2020 55,000 2021 47,000 February 2021 32,000 7 Sales in Units (Sweaters) 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 Row Materials Cost per Yard of Wool 24 Ending RM Inventory Requirement 8265.60 yards 4 yords per sweater 3.50 per yord 796 of next month sweater production needs 26 Wool Purchases Paid for in the Month of Purchase 27 Wool Purchases Paid for in the Month following the Purchase 8596 15% 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 2 workers 0.5 hours 15.00 per hour 34 Manufacturing Overhead 35 Variable Manufacturing Overhead 35 Fixed Manufacturing Overhead 37 Noncosh Fixed Manufacturing Overhead (included in above) $ $ 1175 per sweater 30,200.00 per month (O) S 10.250.00 per month Oct 5 30750.00 per month Nov & beyond) 15750.00 per month (Now & beyond) 39 Selling & Administrative Expenses 40 Variable S&A 41 Fixed SEA 7.37 per un sold $ 23,900.00 per month 10750 FG Inventory Cost per un INPUTS INPUTS - Balance Sheet A 1:21 AM ware 06 - BIU - AA B $ - % . Paste Delete Format Editing Format as Table Cell Styles Styles Ideas Clipboard Font Alignment Number 5 Cells Ideas E36 : f 30750 LD 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% 15% 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 2 workers 0.5 hours 15.00 per hour 34 Manufacturing Overhead 35 Variable Manufacturing Overhead 36 Fixed Manufacturing Overhead 37 Noncash Fixed Manufacturing Overhead (included in above) $ $ 11.75 per sweater 30,200.00 per month (Oct.) 10,250.00 per month Oct) S $ 30.750.00 per month (Nov. & beyond) 15,750.00 per month (Nov. & beyond) 39 Selling & Administrative Expenses 40 Variable S&A 41 Fixed S&A 42 Noncash Fixed S&A included in above) 13 44 Factory Update & Cash Flow 45 Factory Update (PPE) $ $ 7 37 per unit sold 23,900.00 per month (10,750.00 per month $ 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 $ 300,000.00 $ 300,000.00 9,000.00 per month paid in following month SARAS INPUTS INPUTS - Balance Sheet FG inventory Cost per e