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...
-
A corrugated container company is testing whether a computer decision model will improve the uptime of its box production line. Currently, knives used in the production process are checked manually...
-
On April 1, Adventures Travel Agency, Inc. began operations. The following transactions were completed during the month. 1. Issued common stock for $24,000 cash. 2. Obtained a bank loan for $7,000 by...
-
When is OT&E performed during the System Development Phase?
-
You are provided with the following transactions that took place during a recent fiscal year. Instructions Complete the table indicating whether each item (1) affects operating (O) activities,...
-
Research: What is a sovereign nation, how many sovereign nations are recognized as members by the United Nations and how many sovereign nations are recognized by the US State Department. Compare the...
-
Develop MRP records for the items in Figure 7.16, Table 7.21, and Table 7.22. In figure 7.16 The lead time to complete item A is 2 weeks, and the lead time to complete item H is 1 week. D (2) F C2) G...
-
A broker performed a competitive market analysis and determined that the comparable homes are in better overall condition than the sellers property what adjustments should be made?
-
Compare the quality standards that may be used in a school cafeteria with those that may be used in a fine - dining restaurant for one standard portion of roast turkey with dressing. Would the...
-
When computing the amount of interest cost to be capitalized, the concept of avoidable interest' refers to a. the total interest cost actually incurred b. a cost of capital charge for stockholders...
-
A firm utilizes a strategy of capital rationing, which is currently $250,000 and is considering the following 2 projects: Project A has a cost of $150,000 and the following cash flows: year 1...
-
One of Mr. Bajaj, his wife, their son and Mr. Bajaj's mother is an Engineer and another is a Doctor. * If the Doctor is a male, then the Engineer is a male. * If the Engineer is younger than the...
-
The average length of an eel from a population of short-finned eels is unknown, A random sample from the population mple mean of x-1.9 feet. Assume the sampling distribution of the mean has a...
-
Paint Mixers Inc manufactures and sells a range of paints, including a high performance green paint that will attach to any surface without flaking or peeling. The purchasing manager is responsible...
-
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...
-
The \(T d S\) equation \(T d S=C_{P} d T-T\left(\frac{\partial V}{\partial T} ight)_{P} d P\) is valid where entropy is a function of (a) \(T\) and \(P\) (b) \(P\) and \(V\) (c) \(T\) and \(V\) (d)...
-
The inversion temperature of hydrogen is (a) \(315 \mathrm{~K}\) (b) \(202 \mathrm{~K}\) (c) \(275 \mathrm{~K}\) (d) \(345 \mathrm{~K}\).
-
The inversion temperature of helium is (a) \(460 \mathrm{~K}\) (b) \(40 \mathrm{~K}\) (c) \(620 \mathrm{~K}\) (d) \(823 \mathrm{~K}\).
Study smarter with the SolutionInn App