Answered step by step
Verified Expert Solution
Question
1 Approved Answer
AutoSave O OFF A A 9 9 . C ... Excel.xisx - 2 AutoSave O OFF A A 9 9 . C ... 3 Excel.xisx
AutoSave O OFF A A 9 9 . C ... Excel.xisx - 2 AutoSave O OFF A A 9 9 . C ... 3 Excel.xisx - 1 Home Insert Draw Page Layout Formulas Data Review 1 >> Tell me Comments Share Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Comments Share Conditional Formatting Calibri (Body) v 11 AA 27 V ab v General Insert v Format as Table v Ex Delete Cell Sort & nalyse Sensitivity Paste Font Find & Alignment Number Cells Editing Analyse Sensitivity Paste BIUVV VAV $ ~ % 9 Conditional Format Data Formatting as Table Styles Format DV Filter Select Cell Styles Data F20 4 X V . fx Aluminum F20 K L M N P A B C D E F G EXHIBIT 6. 9 PURCHASES BUDGET UID BUDGETED EXPENSES FOR THE FIRST SIX MONTHS 2021 10 Jan Feb March April May June Six M 2,856 1,836 510 6 January February March 11 Trailer production 2,652 1,284 4,692 7 789 Aluminum 832,320 $ 1,077,120 $ 905,760 12 Sheet metal needs per trailer 30.0 30.0 30.0 30.0 30.C 30.0 Other materials 55,080 269,280 226,440 13 Total production needs 79,560 128,520 140,760 85,680 55,080 15,300 6 00 Wages 636,480 1,028,160 1,126,080 14 Add: desired ending inventory 64,260 70,380 42,840 27,540 7,650 10 Heat, light, & power 132,600 198,900 224,400 15 Total materials need 143,820 198,900 183,600 113,220 62,730 15,300 11 Equipment rental 397,800 397,800 397,800 16 Less: beginning inventory 64,260 70,380 42,840 27,540 7,650 12 Equipment purchases 306,000 306,000 306,000 143,820 134,640 113,220 70,380 35,190 7,650 13 Depreciation 255,000 255,000 255,000 17 Total sheet metal purchases 8.16 $ 3.16 $ 3.16 $ 8.16 $ 8.16 $ 3.16 14 Selling & admin 408,000 408,000 408,000 18 Cost per square yard 19 Total cost 1,173,571 $ 1,098,662 $ 923,875 $ 574,301 $ 287,150 $ 62,424 15 16 April May June 20 17 Aluminum $ 563,040 $ 342,720 $ 244,800 21 CASH BUDGET 18 Other materials 140,760 35,680 91,800 22 Jan Feb March Apri May June Six M 19 Wages 685,440 440,640 244,800 23 Cash beginning balance $ 102,000 20 Heat, light, & power 137,700 112,200 112,200 24 Add: cash collections 21 Equipment rental 346,800 346,800 346,800 25 Month of sale 637,500 $ 1,020,000 $ 1,275,000 $ 765,000 561,000 $ 280,500 22 Equipment purchases 306,000 306,000 306,000 26 Month following sale 217,400 $ 255,000 $ 408,000 510,000 306,000 224,400 23 Depreciation 280,500 280,500 280,500 27 Second month following sale 380,800 S 1,304,400 $ 1,530,000 $ 2,448,000 $ 3,060,000 S 1,836,000 24 Selling & admin 408,000 408,000 408,000 28 Total cash collections 1,837,700 $ 2,579,400 $ 3,213,000 $ 3,723,000 $ 3,927,000 $ 2,340,900 25 26 29 Total cash available 27 EXHIBIT 7. 30 Less: cash disbursements 28 ACCOUNTS PAYABLE FOR ALUMINUM AND OTHER MATERIALS 31 Aluminum 714,000 $ 1,077,120 $ 905,760 $ 563,040 $ 342,720 $ 244,800 29 PURCHASED DURING DECEMBER 2020 32 Other materials 153,000 269,280 226,440 40,760 85,680 91,800 30 A/P: Aluminum 714,000 33 Wages 636,480 1,028,160 1,126,080 585,440 440,640 244,800 31 A/P: Other materials 153,000 34 Heat, light, & power 132,600 198,900 224,400 137,700 112,20 112,200 32 35 Equipment rental 397,800 397,800 397,800 346,800 346,800 346,800 33 36 Equipment purchases 306,000 306,000 306,000 306,000 306,00 306,000 34 EXHIBIT 8 37 Selling & admin 408,000 408,000 408,000 408,000 408,000 408,000 35 BANK LOAN DETAILS / MINIMUM CASH BALANCE REQUIRED 38 Total cash disbursements 2,747,880 $ 3,685,260 $ 3,594,480 $ 2,587,740 $ 2,042,040 $ 1,754,400 36 Requested loan amount $ 816,000 2,747,880 37 Loan duration (in days) 90 39 Excess (deficiency) 38 40 Financing: 39 Mininum cash balance required by directors 102,000 41 Borrowings: Original 867,000 40 42 Borrowings: Additional EXHIBITS BLANK BASED ON PROJECTIONS BASED ON PRODUCTION (3060) BASED O + EXHIBITS BLANK BASED ON PROJECTIONS BASED ON PRODUCTION (3060) BASED ON PRODUCTION (3570) + Cmd + left click: scroll to the last sheet. Ready 170% Right click: see all sheets. 190%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started