Hardin Fabrications is preparing its cash budget for the third quarter. Cash balance on July 1...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Hardin Fabrications is preparing its cash budget for the third quarter. Cash balance on July 1 $ 5 5 Sales collected in cash 7 Sales collected on credit 3 A/R balance on July 1 9 22 23 24 Unit Sales 25 Price per Unit 26 Total Sales 27 116,500 10 % of credit sales collected in the month of sale 11% of credit sales collected in the following month 12 13 All expenses are paid for as they occur, with the exception of Direct Materials, which is all paid for with a revolving line of credit. 14 $ 40% 60% S S 89,000 15 Accounts Payable balance on July 1 16 17 % of Accounts Payable paid in the month of purchase 18 % of Accounts Payable paid in the following month 19 20 Amount of monthly overhead that is depreciation and amortization $ 21 20% 80% 95,000 Sales Budget July 2,250 220.00 S 495,000 $ 30% 70% 15,000 August 2,100 220.00 $ 462,000 $ September 1,650 220.00 $ 363,000 $ Total 6,000 220.00 1,320,000 Total Production Direct Materials per Unit Materials Required for Production Add: Desired Ending Inventory Total Material Needs Less: Beginning Inventory Total Purchases Cost per Steel Ingot Total Cost of Direct Materials Total Production Direct Labor Hours Per Unit Total Direct Labor Hours Needed for Production 5 Cost per Direct Labor Hour 5 Total Cost of Direct Labor 7 3) 9 Direct Materials Purchases Budget 0 Total Production 1 Variable Overhead per Unit Produced -2 Total Variable Overhead $ $ $ $ July 2,380 3.50 8,330 1,719.38 10,049.38 $ 1,000 9,049 Direct Labor Budget July $ 17.00 $ 153,839 $ 2,380 $ 1.50 3,570 17.00 $ 60,690 $ Manufacturing Overhead Budget July 2,380 40 $ August 95,200 1,965 3.50 6,878 1,850.63. 8,728.131 1,719.38 7,009 17.00 $ 119,149 $ August 1,965 $ 1.50 2,948 17.00 $ 50,108 $ August 1,965 40 $ 78,600 September 2,115 3.50 7,403 2,327.50 9,730.00 1,850.63 7,879 + 17.00 $ 133,949 $ September 2,115 $ 1.50 3,173 17.00 $ 53,933 $1 September 2,115 40 S 84,600 Total 22,610 2,327.50 24,937.50 6,460 3.50 1,000 23,938 17.00 406,938 Total 6,460 1.50 9,690 17.00 164,730 Total 6,460 40 258,400 Total Production. Variable Overhead per Unit Produced Total Variable Overhead Fixed Overhead per Unit. Total Fixed Overhead Total Overhead Manufacturing Overhead Budget July Sales Units Variable Selling Expense per Unit Total Variable Selling Expense Fixed Administrative Expense (for the month) Total Selling and Administrative Expense B 5 Required: 5 Prepare a Schedule of Cash Collections. 2 Prepare a Schedule of Cash Disbursements. 3 Prepare a Cash Budget. $ S 2,380 $ $ $ $ $ 40 $ 95,200 3.84 S 9,139 104,339 $ August 2,250 $ 18 $ 40,500 $ 10,417 $ 50,917 $ 1,965 Selling and Administrative Expense Budget July August 40 $ 78,600 3.84 $ 7,546 86,146 $ 2,100 $ 18 S 37,800 $ 10,417 $ 48,217 $ September 2,115 → 40 $ 84,600 3.84 $ 8,122 92,722 $ September 1,650 $ 18 $ 29,700 $ 10,417 $ 40,117 $ Total 6,460 40 258,400 3.84 24,806 283,206 Total 6,000 18 108,000 31,250 139,250 Hardin Fabrications is preparing its cash budget for the third quarter. Cash balance on July 1 $ 5 5 Sales collected in cash 7 Sales collected on credit 3 A/R balance on July 1 9 22 23 24 Unit Sales 25 Price per Unit 26 Total Sales 27 116,500 10 % of credit sales collected in the month of sale 11% of credit sales collected in the following month 12 13 All expenses are paid for as they occur, with the exception of Direct Materials, which is all paid for with a revolving line of credit. 14 $ 40% 60% S S 89,000 15 Accounts Payable balance on July 1 16 17 % of Accounts Payable paid in the month of purchase 18 % of Accounts Payable paid in the following month 19 20 Amount of monthly overhead that is depreciation and amortization $ 21 20% 80% 95,000 Sales Budget July 2,250 220.00 S 495,000 $ 30% 70% 15,000 August 2,100 220.00 $ 462,000 $ September 1,650 220.00 $ 363,000 $ Total 6,000 220.00 1,320,000 Total Production Direct Materials per Unit Materials Required for Production Add: Desired Ending Inventory Total Material Needs Less: Beginning Inventory Total Purchases Cost per Steel Ingot Total Cost of Direct Materials Total Production Direct Labor Hours Per Unit Total Direct Labor Hours Needed for Production 5 Cost per Direct Labor Hour 5 Total Cost of Direct Labor 7 3) 9 Direct Materials Purchases Budget 0 Total Production 1 Variable Overhead per Unit Produced -2 Total Variable Overhead $ $ $ $ July 2,380 3.50 8,330 1,719.38 10,049.38 $ 1,000 9,049 Direct Labor Budget July $ 17.00 $ 153,839 $ 2,380 $ 1.50 3,570 17.00 $ 60,690 $ Manufacturing Overhead Budget July 2,380 40 $ August 95,200 1,965 3.50 6,878 1,850.63. 8,728.131 1,719.38 7,009 17.00 $ 119,149 $ August 1,965 $ 1.50 2,948 17.00 $ 50,108 $ August 1,965 40 $ 78,600 September 2,115 3.50 7,403 2,327.50 9,730.00 1,850.63 7,879 + 17.00 $ 133,949 $ September 2,115 $ 1.50 3,173 17.00 $ 53,933 $1 September 2,115 40 S 84,600 Total 22,610 2,327.50 24,937.50 6,460 3.50 1,000 23,938 17.00 406,938 Total 6,460 1.50 9,690 17.00 164,730 Total 6,460 40 258,400 Total Production. Variable Overhead per Unit Produced Total Variable Overhead Fixed Overhead per Unit. Total Fixed Overhead Total Overhead Manufacturing Overhead Budget July Sales Units Variable Selling Expense per Unit Total Variable Selling Expense Fixed Administrative Expense (for the month) Total Selling and Administrative Expense B 5 Required: 5 Prepare a Schedule of Cash Collections. 2 Prepare a Schedule of Cash Disbursements. 3 Prepare a Cash Budget. $ S 2,380 $ $ $ $ $ 40 $ 95,200 3.84 S 9,139 104,339 $ August 2,250 $ 18 $ 40,500 $ 10,417 $ 50,917 $ 1,965 Selling and Administrative Expense Budget July August 40 $ 78,600 3.84 $ 7,546 86,146 $ 2,100 $ 18 S 37,800 $ 10,417 $ 48,217 $ September 2,115 → 40 $ 84,600 3.84 $ 8,122 92,722 $ September 1,650 $ 18 $ 29,700 $ 10,417 $ 40,117 $ Total 6,460 40 258,400 3.84 24,806 283,206 Total 6,000 18 108,000 31,250 139,250
Expert Answer:
Answer rating: 100% (QA)
1 Schedule of cash collection July August September Total Budgeted Sales 495000 462000 363000 132000... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The first payroll in October covered the two workweeks that ended on September 26 and October 3. This payroll transaction has been entered for you in the payroll register, the employees' earnings...
-
Damon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Damon Manufacturing's operations: Current Assets as of December 31 (prior...
-
Let y be a variable that takes 0 or 1 value. Write an inequality to describe if y = 0, then x can take value from 0 to 5 and if y = 1, then x can take value 0. We are given 3 options. We are allowed...
-
Let us consider how we might translate a set of STRIPS schemata into the successor-state axioms of situation calculus. Consider the schema for Fly (p, from. to). Write a logical definition for the...
-
In 2023-24, a landlord receives a premium of 12,000 when granting a lease to a tenant. Compute the amount of this premium which is chargeable to income tax if the length of the lease is: (a) 60 years...
-
Sherry Taft and I.aura Sims are opening Bank Compliance Consultants. The area is growing, and no competitors are located nearby. Their basic decision is how to organize the business. Taft thinks the...
-
On January 1, 2015, Weaver Corporation purchased a patent for $ 237,000. The remaining legal life is 20 years, but the company estimates the patent will be useful for only six more years. In January...
-
why the use of judgment in cost measurement can lead to markedly different results even within the same firm. Would you not think that, at least within their own organization, management could...
-
This and similar cases in later chapters focus on the financial statements of a real company: The Coca-Cola Company and Subsidiaries (NYSE: KO), a total beverage company whose products are sold in...
-
b. Consider the following statement: "When computing the FCF, taxes are estimated in a way that financing decisions are considered". Do you agree? Explain your answer. [10 marks]
-
2. Show that F = (sin y + z)i+(xcos y z)j+(x y)k is a conservative field and calculate the value of its line integral from the origin to the point (3,/6, 2) along any path.
-
How do conversational maxims, as proposed by Grice, serve as guiding principles for effective communication, and to what extent do violations of these maxims impact the coherence and perceived...
-
Consider the function f(x, y) = x +2y2, and the constraint x+y2=4. Use the method of Lagrange multipliers to find the location of the maximum and minimun values of f(x, y), Subject to the given...
-
A company sold 5,600 units of its only product and reported the following contribution margin income statement for this year. Contribution Margin Income Statement For Year Ended December 31 Sales...
-
How can educational institutions and corporate entities cultivate inclusive learning and working environments that value and affirm the diverse identities and experiences of all individuals, and what...
-
Question 2: Given the following dataset: ID 1. 2. 3. 4. 5. 6. 7. Age '40-49 '50-59 '50-59 40-49 '40-49 '50-59 '50-59 8. 9. '40-49 10. '40-49 11. '50-59 12. '60-69 13. '50-59 14. '50-59 40-49 15. 16....
-
How can a promoter avoid personal liability for pre-incorporation contracts?
-
Refer to E8- 38B. Global Systems needs 80,000 optical switches next year (assume same relevant range). By outsourcing them, Global Systems can use its idle facilities to manufacture another product...
-
Hang Ten produces sports socks. The company has fixed expenses of $ 80,000 and variable expenses of $ 0.80 per package. Each package sells for $ 1.60. Requirements 1. Compute the contribution margin...
-
Meyer Company, which uses the high- low method to analyze cost behavior, has determined that machine hours best predict the companys total utilities cost. The companys cost and machine hour usage...
-
Explain the difference between the Expenses tab and the Items tab in the Write Checks window.
-
How should you account for advanced deposits received on customer orders?
-
Are time sheets required for QuickBooks Accountant to process payroll?
Study smarter with the SolutionInn App