please show excel formula for Raw materials purchases budget

A c Tw Cen MT 12 BIU-- Merge & Center - $ - % 53-88 Cut Copy - Format Painter Clipboard Conditional Format as Formatting Table lili Number Alignment Font E36 X o 30750 5 Sales & Collections October 2020 30,000 November 2020 34,000 December 2020 55,000 January 2021 47,000 February 2021 32,000 7 Sales in Units (Sweaters) 100.00 9 Selling Price per Sweater 10 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 0265.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 Noncosh Fixed Manufacturing Overhead (included in above) $ $ 11.75 per sweater 30,200.00 per month (O ) 10,250.00 per month (O+ S $ 30,750.00 per month (Now & beyond) 15,750.00 per month (Nov. & beyond) 19 Selling & Administrative Expenses 40 Variable SA 41 Fixed SRA Nonco xed SRA Included in above $ S 737 per un sold 23,900.00 per month (10,750.00 per month INPUTSN PUTS Balance Sheet FG inventory Cost per Unt Sales Budget Rea Expected Cash Collections Production Budget RM Budget 1,500 sweaters 17 Ending FG Inventory, September 30, 2020 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 05 hours 15.00 per hour 34 Manufacturing Overhead 35 Variable Manufacturing Overhead 35 Fixed Manufacturing Overhead 37 Noncosh Fixed Manufacturing Overhead (included in above) $ $ 11.75 per sweater 30,200.00 per month (Od) 10,250.00 per month (Od) $ $ 30,750.00 per month (Now & beyond) 15.750.00 per month (Now & beyond) 39 Selling & Administrative Expenses 40 Variable S&A 41 Fixed SEA 42 Noncash Fixed S&A (included in above) 737 per unit sold $ 23,900.00 per month $ (10.750.00) per month 44 Factory Update & Cash Flow 5 Factory Update (PPBE) $ 400,500.00 paid on October 31, 2020 47 Principle Borrowed on October 1, 2020 Principle Repaid on November 30, 2020 49 Interest Payment on Borrowing in October & November $ 300,000.00 $ 300,000.00 $ 9,000.00 per month paid in following month AutoSave A . ACCT 285 - Excel Project Template - Spring 2020 (1) - Excel L e Search Page Layout Formulas D ata Review View Help File Home Insert A Xcut Copy Format Painter - Genel Normal The Cen MT -11 - AA BIU-E -A- Wrap Text Merge & Center - $ % R p Conditional Formatas Calculati Formatting Table Clipboard Alignment EFG Lexie's Wool Sweaters Balance Sheet As of September 30, 2020 ASSETS LIABILITIES & EQUITIES 5 Cash $ 150,000.00 Accounts Payable $ 14,500.00 6 Accounts Receivable $ 75,000.00 Notes Payable 7 Raw Materials Inventory $ 28,929.60 Interest Payable 8 Finished Goods Inventory $ 61,125.00 TOTAL LIABILITIES $ 14,500.00 9 PP&E, net $ 487,000.00 Retained Earnings $787,554.60 10 TOTAL ASSETS $ 802,054.60 TOTAL LIABILITIES & EQUITY '$ 802,054.60 $ Page Layout AutoSave a Home Insert A Xu In Copy Format Painter ACCT 285 - Excel Project Template - Spring 2020 (1) - Excel Formulas Data Review View Help -12-AA == Wap Text O A . Merge Center To en MT Normal Callation Check BI Conditional Formata 1 Formatting Table Alignment 2021 QUARTER January Raw Materials Purchases Budget 2020 October November December 4 Units Sweaters) Produced 5 Total Yards of Wool Used in Production 6 Plus Desired Wool in Ending Inventory 7 Total Wool Required 8 Les Wool in Beginning Inventory 9 RAW MATERIALS PURCHASES (UNITS) 10 Cost per yord 11 RAW MATERIALS PURCHASES (COST)