Question 1 Jupiter Inc. is a wholesale distributor of Apple laptop bags. Thus, peak sales occur in May of each year as shown in the company's sales budget for the second quarter, given below: April May June Budgeted Sales (All on account) $ 87,000 $86,000 $92,000 From past experience, the company has learned that 30% of a month's sales are collected in the month of sale, 60% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. February sales totaled $85,000, and March sales totaled $88,000. Required: Prepare a schedule of expected cash collections from sales for each month (April, May, and June) and the quarter total.

Question 1 Jupiter Inc. is a wholesale distributor of Apple laptop bags. Thus, peak sales occur in May of each year as shown in the company's sales budget for the second quarter, given below: April May June Budgeted Sales (All on account) $ 87,000 $86,000 $92,000 From past experience, the company has learned that 30% of a month's sales are collected in the month of sale, 60% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. February sales totaled $85,000, and March sales totaled $88,000. Required: Prepare a schedule of expected cash collections from sales for each month (April, May, and June) and the quarter total.

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

Can you help me with the Budget Drill #1?
Ll.95.
Help me answer problem 10 TY
can u help
Ashvinn
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…
Please help me with show all calculation thanku
answer in text form please (without image)
Help me please
can u help me
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.
Budget for a merchandising company Nano,inc.is preparing its budget for the second quarter . The following sales data have been forecasted: April. May. June. June July U/sales. 640. 720. 780. 620. 660 Additional information follows: inventory on March 31: 192 units Desired ending inventory each month: 30% of next month's sales. How many units should be produced in April, May and June? How many units should be produced in the second quarter in total? You can Write your answers on this sheet as an excel table or a pasted word documentable.