Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Cost Accounting A Managerial Emphasis

Authors: Srikant M. Datar, Madhav V. Rajan

17th Edition

0135628474, 9780135628478

More Books

Students also viewed these Accounting questions

Question

6. What are the problems with all-in-one document control systems?

Answered: 1 week ago

Question

What are the objectives of job evaluation ?

Answered: 1 week ago

Question

Write a note on job design.

Answered: 1 week ago

Question

Compute the derivative of f(x)cos(-4/5x)

Answered: 1 week ago

Question

Discuss the process involved in selection.

Answered: 1 week ago