please show excel formulas for the bottom charts :)
Lexie's Wool Sweaters Projected Budgeting Data Sales & Collections December October 2020 30,000 November 2020 3 4,000 2020 January 2021 47,000 February 2021 32,000 Sales in Units (Sweaters) 55,000 Selling Price per Sweater $ 100.00 Cash Sales Collected in the Month of Sole Credit Sales Collected in the Month of Sale Credit Soles Collected in the following Month Inventory Policy Ending FG Inventory Requirement Ending FG Inventory, September 30, 2020 2 # 1,500 - Product Input Expenses Direct Materials Ending RM Inventory, September 30, 2020 Yords of Wool Required per Sweater Raw Materials Cost per Yord of Wool Ending RM Inventory Requirement 8265.60 yards 4 yards per sweater 3.50 per yord 7% of next month weater production needs 26 Wool Purchases Paid for in the Month of Purchase 27 Wool Purchases Paid for in the Month following the Pur 15% 2 workers 0.5 hours 15.00 per hour 29 Direct Labor 30 Number of Workers Required for the Making of each Sweater 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 Noncosh Fixed Manufacturing Overhead (Included in above) 5 5 11.75 per sweater 30,200.00 per month (Oct.) 10.250.00 per month (Oct.) $ S 30,750.00 per month 15.750.00 per month (Nox & beyond 39 Selling & Administrative Expenses SUM O AVERAGE MIN MAX COUNTA 11 5 Selling & Administrative Expenses Variable S&A Fixed S&A Noncash Fixed S&A (included in above) $ $ 7 .37 per unit sold 23,900.00 per month 10,750.00 per month Factory Update & Cash Flow Factory Update (PP&E $ 400,500.00 paid on October 31, 2020 Principle Borrowed on October 1, 2020 Principle Repaid on November 30, 2020 Interest Payment on Borrowings in October & November $ $ 300,000.00 300,000.00 4,500.00 per month (paid in following month) Lexie's Wool Sweaters Balance Sheet As of September 30, 2020, ASSETS BERSALIAALMES & EQUMES Cash $ 150,000.00 Accounts Payable $ 14,500.00 Accounts Receivable $ 75,000.00 Notes Payable Raw Materials Inventory Interest Payable Finished Goods Invertory $ 61,125.00 TOTAL LIAALMES $ 14,500.00 PP&E, net $ 487,000.00 Retaired Eamings $ 787,554.60 TOTAL ASSETS $ 802,054.60 TOTAL LIAALMES & EQUITY $ 802,054.60 File Edit Insert Table Organise Format Arrange View Share Window Help ACCT 285 - Excel Project Template - Spring 2020 - Edited YB TYD Common insert Tao Sales Budget orun Text Shape Media pected Cash Collections 5. Balance Sheet FO Inventory Cost per Unit Production Budget Schedule of Expected Cash Collections 2020 December QUARTE Cosh from Current Month Cash Sales Cash from Current Month Credit Sales Carch from Prior Month Credo Sales TOTAL CASH COLLECTIONS Production Budget December Soles in Units Plus Desired Unime Ending Inventory Total Unit Requirements Let Unii Begge PRODUCTION IN UNITS Freeze Headers Columns + - Rows to
