AutoSava OFF OE Budgeting Assignment Insert Draw Page Layout Formulas Data Review Home - View Tell me Share Comments X LE Arial > 10 ~ Al A a Wras Text v General Insert v 5x Delete Format Pagic B 1 1 Ay = = Merge & Center v $ Ideas Conditional Format Cell Formatting as Table Styles Sort Filter v Find & Select Sensitivity fx ASSUMPTIONS AREA A c D E F G H 1 K L M N BUDGET AREA Sales Budget 012021 4,500 01 2021 Q2 2021 20 2021 04 2021 Q1 2022 02 2022 Q2 2021 6,500 49.00 20 2021 9,800 51.00 5 024 2021 5,250 51.00 Q1 2022 02 2022 7,100 5,000 53.00 5 53.00 $ Unit sacs Saling prlo per uni Totalles $ Schedule of Expected Cash Collections 40.000 30% 2U'S 1 2021 92 2021 28 2021 24 2021 Year Accounts receivable, boginning balance First quarter sales Second-quarter les Third quarter sales Fourth quarter sales Total cash colectiona 1.800 40'S Production Budget 01 2021 Q2 2021 24 2021 24 2021 YARI 6,364 5. 20% 2.50 Q1 2022 Bucguled unil sales Adc desred finished goods inventory Total needs LASS haginning finished gaada intory Recured production funt 1 ASSUMPTIONS AREA 2 3 SALES 4 S Sales units 6 Selling pro ? & ACCOUNTS RECEIVABLE 9 Beginning counts receivable balance 10 Salus cash collection, quarter of sale 1: Sales cash collection, quarter after sale 12 13 FINISHED GOODS INVENTORY 14 Beginning finished goods inventory units 15 Cesred ending Inventory: 's of next quarter sales units 16 17 RAW MATERIALS INVENTORY 12 Beginning raw materials inventory in pounds 19 Pounda Acuired to use each unit 20 Desired eding inventory: % of next quarter production needs 21 Cost of raw material per pound 22 23 ACCOUNTS PAYABLE 24 Beginning Hours payable balance 25 raw materials cash payment, quarter of purchase 26 Fiaw material payment Guarter after purchase 27 28 29 30 3: 32 33 34 35 36 37 38 39 40 93 42 43 44 95 46 47 48 45 50 Instructions Budgeting Assignment $28.500 70%, 30% Raw Materials Purchases Budget 01 2021 02 2021 0 2021 24 2021 Yarn Q1 2022 Required production junts Raw materiais required to produce one unt Production needs pour de Ade dusred ending inventory of raw materials (pounds) Total needs (pounds) Lesa beginning inventory of raw materiala pounds) Raw materials to be purchased Cost of raw materals per pound Cost of raw materials to be purchased Schedule of Expected Cash Payments 01 2021 az 2021 03 2021 04 2021 Year Account aayable, beginning balance Fisuarter purchases Second quarter purchases Third-quarter purchases Fourth quarter purchase Totalcascisbursements + - + 100%