Bruner Inc. has requested a cash budget for July. The following information was provided: 1. Cash...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Bruner Inc. has requested a cash budget for July. The following information was provided: 1. Cash balance on July 1 is $2,800. 2. Actual sales for May, June, and July are as follows: May June July Cash sales $21,000 $16,000 $22,000 Credit sales 20,000 26,000 30,000 Total Sales $41,000 $42.000 $52.000 3. Credit sales are collected as follows: 45 percent in the month of sale, 35 percent in the second month, and 10 percent in the third month. The remaining sales are uncollectible. 4. Inventory purchases are 70 percent of total monthly sales. Purchases are paid 62 percent in the month of purchase and the remaining 38 percent are paid in the following month. 5. Operating expenses for the month are $8,300, including $1,400 for depreciation. 6. Monthly salaries and owner's withdrawals $3,800. 7. Monthly rent $2,400. Required: Prepare a cash collections and cash payment schedule as well as a cash budget for the month of July. Total cash sales and collections on account for the month are $ 5: 6: Required: Prepare a cash collections and cash payment schedule as well as a cash budget for the month of July. Total cash sales and collections on account for the month are $ Total cash available for the month is $ A/ Payments for purchases during the month are $. A/ Payments for other expenses during the month are $ The ending cash balance for the month is $. Bruner Inc. has requested a cash budget for July. The following information was provided: 1. Cash balance on July 1 is $2,800. 2. Actual sales for May, June, and July are as follows: May June July Cash sales $21,000 $16,000 $22,000 Credit sales 20,000 26,000 30,000 Total Sales $41,000 $42.000 $52.000 3. Credit sales are collected as follows: 45 percent in the month of sale, 35 percent in the second month, and 10 percent in the third month. The remaining sales are uncollectible. 4. Inventory purchases are 70 percent of total monthly sales. Purchases are paid 62 percent in the month of purchase and the remaining 38 percent are paid in the following month. 5. Operating expenses for the month are $8,300, including $1,400 for depreciation. 6. Monthly salaries and owner's withdrawals $3,800. 7. Monthly rent $2,400. Required: Prepare a cash collections and cash payment schedule as well as a cash budget for the month of July. Total cash sales and collections on account for the month are $ 5: 6: Required: Prepare a cash collections and cash payment schedule as well as a cash budget for the month of July. Total cash sales and collections on account for the month are $ Total cash available for the month is $ A/ Payments for purchases during the month are $. A/ Payments for other expenses during the month are $ The ending cash balance for the month is $.
Expert Answer:
Answer rating: 100% (QA)
Schedule of Cash Collections For The Month of July Cash collections From May sales 2000010 F... View the full answer
Related Book For
Accounting Principles
ISBN: 978-1119048503
7th Canadian Edition Volume 1
Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Warren, Lori Novak
Posted Date:
Students also viewed these accounting questions
-
Fraud investigators must frequently present their findings in PowerPoint format to CEOs, board members, prosecutors, industry groups, etc. This is a critical skill and one that must be mastered in...
-
Meesha Novelty had a beginning inventory balance on July 1 of 400 units at a cost of $3 each. During the month, the following inventory transactions took place: Instructions (a) Calculate the cost of...
-
1. The cash balance on 31 January 2021 is expected to have a debit balance of R10 000. 2. Total sales are expected to be as follows: January 2021 R600 000 R500 000 February 2021 March 2021 R560 000...
-
Suppose the total cost in dollars of manufacturing q units is C(q) = 3q 2 + q + 500. a. Use marginal analysis to estimate the cost of manufacturing the 41st unit. b. Compute the actual cost of...
-
Derive formulas for average fixed cost, average variable cost, average total cost, and marginal cost for the following cost function: TC = 100 + 10Q
-
You are the administrative assistant for a division chief in a large holding company that owns several hotels and theme parks. You and the division chief have just come from the CEO's ofce, where you...
-
Formally show that \[ D_{i}=\frac{r_{i}}{p} \frac{h_{i i}}{1-h_{i i}} \]
-
Calculate the profitability index for Problem 3. For Problem 4.
-
How do ethical leaders demonstrate authenticity and ethical authenticity, aligning personal values with organizational goals, and modeling ethical behavior to cultivate ethical awareness and...
-
This Mini Practice Set will help you review all the key concepts of the account- ing cycle for a merchandising company along with the integration of payroll. Betty Loeb took over the business now...
-
Use an appropriate definite integral to evaluate the following limit: lim in 6n+2k+2 817 n k=1
-
Why is the expected loss to a bank from a default on a swap with a counterparty less than the expected loss from the default on a loan to the counterparty when the loan and swap have the same...
-
The five-year swap rate when cash flows are exchanged semiannually is 4%. A company wants a swap where it receives payments at 4.2% per annum on a principal of $10 million. The OIS zero curve is flat...
-
Assume that a bank can borrow or lend money at the same interest rate in the LIBOR market. The 90-day rate is 10% per annum, and the 180-day rate is 10.2% per annum, both expressed with continuous...
-
Suppose that the term structure of risk-free interest rates is flat in the United States and Australia. The USD interest rate is 7% per annum and the AUD rate is 9% per annum. The current value of...
-
The price of gold is currently $1,200 per ounce. Forward contracts are available to buy or sell gold at $1,400 per ounce for delivery in one year. An arbitrageur can borrow money at 5% per annum....
-
A monthly description, reimagining restaurant discovery". That's what Offline promises, according to their WeFunder page (https://wefunder.com/offline). You are going to dissect their marketing...
-
Why is disclosure of depreciation or amortization methods and rates so important?
-
Judy Cumby is the sole owner of Deer Park, a public camping ground near Gros Morne National Park. Judy has gathered the following financial information for the year ended March 31, 2017: Instructions...
-
The components in the income statements of companies A, B, C, and D follow. Determine the missing amounts. Cost of Goods Sold s (a) 367,500 315,000 346,500 Gross Profit ExpensesProfit/(Loss) Sales...
-
Refer to the data for Xpert Snowboards in E6-15. Assume that all of Xpert's sales are for cash and all of its purchases are on account. Instructions (a) Record the purchase on October 10 and sale on...
-
A diver leaps from a high platform, speeds up as she falls, and then slows to a stop in the water. How do you define the system so that the energy changes are all transformations internal to an...
-
When your hands are cold, you can rub them together to warm them. Explain the energy transformations that make this possible.
-
Figure Q10.24 shows a potential-energy diagram for a particle. The particle is at rest at point A and is then given a slight nudge to the right. Describe the subsequent motion. FIGURE Q10.24 Energy...
Study smarter with the SolutionInn App