Use the following information to prepare the July cash budget for Acco Company. Ignore the Loan...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the following information to prepare the July cash budget for Acco Company. Ignore the "Loan activity" section of the budget a. Beginning cash balance on July 1: $75,000. b. Budgeted cash receipts from sales: 20% is collected in the month of sale, 50% in the next month, and 30% in the second month after sale. Sales amounts are May (actual), $1,990,000; June (actual), $1,380,000; and July (budgeted), $1,500,000. c. Budgeted cash payments on merchandise purchases: 50% in the month of purchase and 50% in the month following purchase. Purchase amounts are June (actual), $550,000; and July (budgeted), $550,000. d. Budgeted cash payments for salaries in July: $200,000. e. Budgeted cash payments for sales commissions for July: $160,000. f. Budgeted cash payment for income taxes in July: $80,000. g. Budgeted cash payment for loan interest in July: $5,000. Complete this question by entering your answers in the tabs below. Calculation Cash Budget Calculate the budgeted cash receipts and cash payments. Calculation of Cash Receipts from Sales ---Collected in----------- July 31 Total Sales May June July Accounts Receivable Credit sales from: May $ 1,990,000 June 1,380,000 July 1,500,000 Totals $ 4,870,000 Calculation of Cash Payments for Merchandise Total Purchases June Purchases from: June $ 550,000 July 550,000 Totals $ 1,100,000 --Paid in---------- July Prepare the July cash budget for Acco Company. ACCO COMPANY Total cash available Less: Cash payments for: Total cash payments Cash Budget July July 31 Accounts payable Use the following information to prepare the July cash budget for Acco Company. Ignore the "Loan activity" section of the budget a. Beginning cash balance on July 1: $75,000. b. Budgeted cash receipts from sales: 20% is collected in the month of sale, 50% in the next month, and 30% in the second month after sale. Sales amounts are May (actual), $1,990,000; June (actual), $1,380,000; and July (budgeted), $1,500,000. c. Budgeted cash payments on merchandise purchases: 50% in the month of purchase and 50% in the month following purchase. Purchase amounts are June (actual), $550,000; and July (budgeted), $550,000. d. Budgeted cash payments for salaries in July: $200,000. e. Budgeted cash payments for sales commissions for July: $160,000. f. Budgeted cash payment for income taxes in July: $80,000. g. Budgeted cash payment for loan interest in July: $5,000. Complete this question by entering your answers in the tabs below. Calculation Cash Budget Calculate the budgeted cash receipts and cash payments. Calculation of Cash Receipts from Sales ---Collected in----------- July 31 Total Sales May June July Accounts Receivable Credit sales from: May $ 1,990,000 June 1,380,000 July 1,500,000 Totals $ 4,870,000 Calculation of Cash Payments for Merchandise Total Purchases June Purchases from: June $ 550,000 July 550,000 Totals $ 1,100,000 --Paid in---------- July Prepare the July cash budget for Acco Company. ACCO COMPANY Total cash available Less: Cash payments for: Total cash payments Cash Budget July July 31 Accounts payable
Expert Answer:
Answer rating: 100% (QA)
To prepare the July cash budget for Acco Company we need to calculate the budgeted cash receipts and ... View the full answer
Related Book For
Fundamental accounting principle
ISBN: 978-0078025587
21st edition
Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta
Posted Date:
Students also viewed these accounting questions
-
New members of a tennis club are admitted at the start of each year and pay an initiation fee of $5,000 immediately. Thereafter, members pay an annual membership fee of $600, which falls due at the...
-
Azam Products Co. has an inventory period of 53 days, an accounts payable period of 68 days, and an accounts receivable turnover rate of 18. What is the length of the operating cycle and cash cycle
-
Use the following information to prepare the July cash budget for Acco Co. It should show expected cash receipts and cash disbursements for the month and the cash balance expected on July 31. a....
-
A decline in the aggregate demand has led to a decline in output in the economy equal to $10 billion. Government wants to counter this recession by reducing income taxes. Assuming that the marginal...
-
Figure 13.9 illustrates the situation facing the publisher of the only newspaper containing local news in an isolated community. a. On the graph, mark the profit-maximizing quantity and price and the...
-
The guys on one floor of a college dorm all decide to get pizzas to share. They get 3 pepperoni pizzas, 2 bacon pizzas, 1 cheese pizza, 3 sausage pepperoni pizzas, and 3 meat lovers pizzas with...
-
The Pierce Company had the following data (in thousands) for a given period: There were no beginning or ending inventories. Compute the (1) manufacturing cost of goods sold, (2) gross profit, (3)...
-
PepsiCo recently decided to invest more than $300 million for expansion in Brazil. Brazil offers considerable potential because it has 150 million people and their demand for soft drinks is...
-
Select the terms that best complete the sentence. The average age of all employees of a business is 53 with a standard deviation of 12.5. If the age of 36 randomly sampled employees is obtained, the...
-
Restricted net position for a governmental college or university is commonly subclassified for designated net position. reserved net position. nonexpendable net position. net investment in capital...
-
ABC Corporation produces a product that requires 2.6 pounds of materials per unit. The hourly wage rate is $9.00 per hour, but a raise that will average $0.25 will go into effect soon. Payroll taxes...
-
Everland Caf is a cafe spread across various locations, where they are famous for their coffee and pastries. In carrying out its operational activities it is known that the fixed cost for the cafe is...
-
Reference: https://serialpodcast.org/season-one/1/the-alibi Think of someone in your life who you think would be a good criminal defense attorney or other member of a defense team. Please answer the...
-
Discuss the advantages and disadvantages of the standard costing system from the perspective of the accounting professional and from the perspective of the company's other internal users.
-
Consider the health care environment in which you currently work or plan to work, and select a specific health care organization within that setting to focus on for this assignment. Possible options...
-
CAC operates 3 eight hour shifts to produce 600 gallons of chemicals per day. It requires 12 minutes of labor to produce a gallon of the chemical . What is CAC's Takt time in minutes per gallon ?...
-
What types of questions can be answered by analyzing financial statements?
-
Bear Oil Incorporated has two unproved leases with the following capitalized costs: Bear Oil Incorporated negotiated a new lease on Lease C immediately following the end of the primary term. The...
-
Critic Oil Company purchased three leases as follows: All the leases are classified as individually significant. a. On December 31, 2014, Lease A is determined to be 25% impaired. Lease B and Lease C...
-
Ernest Oil Companys balance sheet, at 12/31/14, included account balances as follows: During 2015, the following events related to the above unproved properties occurred: a. Lease A is abandoned. b....
Study smarter with the SolutionInn App