Problem 7-17A (Algo) Preparing a sales budget and schedule of cash receipts LO 7-2 Thornton Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Thornton expects sales in January year 1 to total $400,000 and to increase 20 percent per month in February and March. All sales are on account. Thornton expects to collect 66 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 10 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Thornton will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Prepare a sales budget for the first quarter of year 1.

Problem 7-17A (Algo) Preparing a sales budget and schedule of cash receipts LO 7-2 Thornton Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Thornton expects sales in January year 1 to total $400,000 and to increase 20 percent per month in February and March. All sales are on account. Thornton expects to collect 66 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 10 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Thornton will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Prepare a sales budget for the first quarter of year 1.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

3. Question Content Area Cash Budget Khloe Company imports gift items from overseas and sells them to gift shops and department stores throughout the United States. Khloe Company provided the following information: The October 31 balance in the cash account is $54,115. All sales are on account. Sales in September were $980,000 and in October were $1,260,000. November sales are expected to be $2,175,000. In Khloe’s experience, 70 percent of sales are collected in the month of sale and 26 percent are collected in the month following sale. The remaining credit sales are uncollectible. Khloe purchases all merchandise on account. Purchases in September were $730,000 and in October were $950,000. November purchases are expected to be $2,030,000 as Khloe prepares for the Christmas buying season. Fifteen percent of purchases are paid in the month of purchase, while the remainder is paid in the month following the purchase month. Khloe Company has nine employees who are paid a total of…
A-2
Problem 1 As treasurer of a manufacturing company, you are preparing a cash budget for September of the next fiscal year. The information for September you have, at your disposal to complete this task is as follows: (а) Next year's sales forecast follows: July August September October $350,000 $240,000 $300,000 $360,000 (b) The sales price is $60. (c) Each month, 20% of the sales are for cash and 80% are on credit. (d) The AR collection pattern for credit sales is: 20% is received in 0-30 days 50% is received in 31-60 days 30% is received in 60-90 days (e) The cash in bank at the beginning of September is $15,400 (f) The per unit production cost data is: Direct material $20 Direct labor 1 direct labor hour per unit; $15 direct labor rate The company monthly beginning FG inventory policy is to maintain a minimum of 25% of the current month's sales. (g) (h) The AP pattern for credit purchases is: 30% is paid in 0-30 days 70% is paid in 31-60 days (i) There is a income tax payment of…
Domestic Don't upload image please
Question 1 The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases August $85,000 $640,000 $420,000 September $70,000 $550,000 $550,000 October $88,550 $600,000 $500,000 November $77,160 $800,000 $600,000 December $174,870 $500,000 $450,000 - An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 50% in the month of sale 30% in the first month following the sale 20% in the second month following the sale -Expected purchases include monthly cash purchases of 5%. All other purchases are on Accounts payable are settled as follows,…
Please dont give image based answers... thank you
Problem 01:4 ZYX has total sales for June and July of $30,000 and $25,000, respectively. Cash sales are normally 40% of total sales. Of the credit sales, 40% are collected in the same month as the sale, 50% are collected during the first month after the sale, and the remaining 10% are collected in the second month. Determine the amount of accounts receivable reported on the company's budgeted balance sheet as of July 31.
Problem 6 Tomtom store seeks your assistance to develop cash and other budget information for May, June, and July 2009. On April 30, 2009, the company had cash balance of Php5,500. The budget is based on the following assumptions: A. Sales 1. Each month's sales are billed on the last day of the month 2. Customers are allowed 3% discount if payment is made within 10 days after the billing date. Accounts receivable are booked gross. 3. Sixty percent of the billings are collected within the discount period, 25% are collected by the end of the month where discount period is allowed, 9% are collected by the end of the end second month, and 6% prove uncollectible. B. Purchases 1. 54% of all purchases of materials and selling, general and administrative expenses are paid at the month purchased and the remainder in the following month. 2. Each month's unit of ending inventory is equal to 130% of the month's units of sales. 3. The cost of each unit of inventory is P20. 4. Selling, general and…
Question 2 A. The Rilex and Chill Coffee Shop has requested a cash budget for August. After examining the records of the company, you find the following: 1. Cash balance on 1 August is RM43,280. 2. Actual sales for June and July are as follows: June RM Cash sales Credit sales Total sales 10,200 26,100 36,300 July RM 14,700 33,900 48,600 3. Credit sales are collected over three months: 30% in the month of sales, 40% in the second month, and 25% in the third month. The customers who paid in the month of sales are qualified for 3% discounts on the amount owed. While the sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. 4. Inventory purchases average 80% of a month's total sales. Of those purchases, 60% are paid for in the month of purchase. The remaining 40% is paid for in the following month. 5. Salaries and wages total RM13,800 per month. 6. The company received interest…
Complete g cash budget table please and thank you
Question 9
Exercise 7-3A (Algo) Preparing a schedule of cash receipts LO 7-2 The budget director of Heather's Florist has prepared the following sales budget. The company had $132,600 in accounts receivable on July 1. Heather's Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required a. Complete the schedule of cash receipts by filling in the missing amounts. b. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet. Complete this question by entering your answers in the tabs below. Required A Required B Complete the schedule of cash receipts by filling in the missing amounts. Sales Budget Cash sales Sales on account Total budgeted sales Schedule of Cash Receipts Current cash sales Plus: Collections from accounts receivable $ July 70,000 $ 97,000 $ 167,000 $ $ August 70,000 $ + September 82,000 $ 116,000 198,000 82,000 78,000 132,600 $ 210,600 $ 78,000