Required information [The following information applies to the questions displayed below.] Built-Tight is preparing its master...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Required information [The following information applies to the questions displayed below.] Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: Budgeted sales Budgeted cash payments for Direct materials Direct labor Factory overhead July August $77,500 $61,500 16,660 13,940 4,540 3,860 20,700 17,300 September $ 50,500 14,260 3,940 17,700 Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $45,500 in accounts receivable; $5,000 in accounts payable; and a $5,500 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,500 per month), and rent ($7,000 per month). (2) Prepare a cash budget for each of the months of July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Enter your final answers in whole dollars.) Total cash payments Preliminary cash balance. Ending cash balance Loan balance Beginning of month Additional loan (loan repayment) Loan balance - End of month Loan balance July 0 0 August 0 0 September 0 0 Beginning cash balance Total cash available Cash payments for: Total cash payments Preliminary cash balance BUILT-TIGHT Cash Budget For July, August, and September July $ 15,000 $ 0 August 15,000 September 0 Required information [The following information applies to the questions displayed below.] Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: Budgeted sales Budgeted cash payments for Direct materials Direct labor Factory overhead July August $77,500 $61,500 16,660 13,940 4,540 3,860 20,700 17,300 September $ 50,500 14,260 3,940 17,700 Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $45,500 in accounts receivable; $5,000 in accounts payable; and a $5,500 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,500 per month), and rent ($7,000 per month). (2) Prepare a cash budget for each of the months of July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Enter your final answers in whole dollars.) Total cash payments Preliminary cash balance. Ending cash balance Loan balance Beginning of month Additional loan (loan repayment) Loan balance - End of month Loan balance July 0 0 August 0 0 September 0 0 Beginning cash balance Total cash available Cash payments for: Total cash payments Preliminary cash balance BUILT-TIGHT Cash Budget For July, August, and September July $ 15,000 $ 0 August 15,000 September 0
Expert Answer:
Answer rating: 100% (QA)
The detailed answer for the above question is provided below Answer Step by Step Ex... View the full answer
Related Book For
Fundamental Accounting Principles
ISBN: 978-0077862275
22nd edition
Authors: John Wild, Ken Shaw, Barbara Chiappetta
Posted Date:
Students also viewed these accounting questions
-
Built-Tight is preparing its master budget for the quarter ended September 30, 2015. Budgeted sales and cash payments for product costs for the quarter follow: Sales are 20% cash and 80% on credit....
-
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: Sales are 20% cash and 80% on credit....
-
Kool-Ray is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow: Sales are 20% cash and 80% on credit....
-
In a survey of 106 college students, data were gathered on the number of piercings each student had and the number of classes they had skipped in the past 3 weeks. We want to determine whether there...
-
Below are a series of statements regarding topics discussed in this chapter. Indicate whether each statement is true (T) or false (F). 1. Increases in non-cash current assets are added to net income...
-
The mirror shown is attached to the wall by an arm that can extend away from the wall. In the figure, points P, Q, R, and S are the vertices of a parallelogram. This parallelogram is one of several...
-
When heat is transferred from one particle of hot body to another by actual motion of the heated particles, it is referred at as heat transfer by: (a) Conduction (b) Convection (c) Radiation (d) None...
-
The Paymor Rental Car Agency rents cars in a small town. It wants to determine how many rental cars it should maintain. Based on market projections and historical data, the manager has determined...
-
Level 2 - Calculating Travel Costs at America Travels As a new sales associate at America Travels travel agency, you assist travel agents in finding the best fares for corporate customers. As a...
-
A dilute aqueous slurry of viscosity 0.001 N-s/m 2 and density 1,000 kg/m 3 is to be separated from the solid particles, which have a density of 3,000 kg/m 3 , by centrifugal sedimentation....
-
3 Sam's Super Sandwiches offers four sandwiches on its menu: an applewood smoked chicken sandwich, a roast beef sandwich, a grilled cheese sandwich, and a portabella mushroom sandwich. Sam prefers to...
-
How can diversifying credit types, such as having a mix of credit cards, loans, and a mortgage, positively impact one's credit score and overall credit management?
-
If $55 per share was good enough for Van Gorkom, who held 75,000 shares, why was it not good enough for the rest of the shareholders? Did Van Gorkom's interests or goals differ from those of a...
-
Ace Industries borrowed $230,000 amortized over 10 years at a rate of j12=6% with monthly payments (rounded up to the next cent). Calculate their final payment.
-
How would a professional option seller utilize the various option greeks to manage their underlying risk exposure?
-
Performance reviews are an integral part of which component of internal control? Multiple Choice Risk assessment. Control environment. Monitoring. Control activities
-
A firm anticipates cash receipts for February of $20,000 and for March of $30,000. Cash payments are expected to be $5,000 in February and $7,000 in March. The cash balance at the beginning of...
-
In Problem use geometric formulas to find the unsigned area between the graph of y = f(x) and the x axis over the indicated interval. f(x) = x + 5; [0, 4]
-
Refer to Apples financial statements in Appendix A. Compute its profit margin for the years ended September 28, 2013, and September 29, 2012.
-
Refer to the information in QS and assume the periodic inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the FIFO method. (Round per unit...
-
On September 11, 2014, Home Store sells a mower for $500 with a one-year warranty that covers parts. Warranty expense is estimated at 8% of sales. On July 24, 2015, the mower is brought in for...
-
True or False: When multiple independent, divisible investments are available, form the investment portfolio so that the internal rate of return is maximized.
-
Polaris Industries has \(\$ 1,250,000\) available for additional innovations on the Victory Vision motorcycle. These include the five indivisible, equal-lived alternatives, each of which guarantees...
-
Consider a capital budgeting formulation where the binary variables \(x_{1}\) and \(x_{2}\) are used to represent the acceptance \(\left(x_{i}=1 ight)\) or rejection \(\left(x_{i}=0 ight)\) of each...
Study smarter with the SolutionInn App