Question: please answer all the questions part 1 and part 2 Part I (Similar to Class Example - Problem 8-28) Required: Prepare: 1. Prepare a sales



please answer all the questions part 1 and part 2
Part I (Similar to Class Example - Problem 8-28) Required: Prepare: 1. Prepare a sales budget, by month and in total, for the Third quarter. (3 marks) 2. Prepare a schedule of expected cash collections, by month and in total, for the Third quarter. (15 marks) 3. Prepare a production budget for each of the months July, August, September and October. (10 marks) 4. Prepare a direct materials budget, by month and in total, for the Third quarter (12 marks) 5. Prepare a schedule of expected cash disbursements, by month and in total, for the Third quarter. (15 marks) Total of Part I (55 marks) Part 2 (Similar to Class Example - Problem 8-25) Question One Sunrise Inc. is a wholesale distributor of beach umbrellas. Peak sales occur in May of alyear as shown in the company's sales budget below for the second quarter: April May June Budgeted Sales (all on account) $600,000 $800,000 $550,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 $400,000 and March sales totaled $500,000. Required: Prepare a Schedule of Expected Cash Collections from the sales for each month (April, May adJune). (15 marks) Question Two Investec Company is planning its cash needs for the fourth quarter. The following information has been assembled to assist in preparing a cash budget for the quarter: a. The Total cash collections and disbursement for purchases are as follows (All amounts are in dollars): Oct. Nov. Dec. Total Cash collections 49,760 59,600 46,500 36,000 Total Cash disbursement for purchases 36,750 30,375 b. Selling and administrative expenses will be incurred and paid as follows: Selling expenses 7,200 11,700 8,000 Administrative expenses 5,600 7,200 6,100 c. Land costing $4,500 will be purchased in October. d. Dividends of $1,000 will be declared and paid in November. e. The cash balance on October 1st is $10,000. f. The company must maintain a cash balance of at least $15,000 at the end of each month. g. The interest rate on the loans is 12% per year. The company's policy is torepay the loan plus accumulated interest at the end of the quarter. (Use rounding off when it is needed) Prepare A cash budget (20 marks) Required to Prepare: 1. A schedule of expected cash collections 2. A cash budget (15 marks) (20 marks) Total of Part 2 (35 marks) The data below pertains to the third quarter of Beval Company which manufactures men's wallets. Below is the estimated sales (in units): July August September October November December 25,000 55,000 75,000 35,000 10,000 15,000 a. The selling price of the wallet is $10 per unit. b. All sales are on account. Based on past experience, sales are collected in the following pattern: Month of sale Month following sale Uncollectible 25% 70% 5% c. Sales for June totaled $400,000. e. d. The company maintains finished goods inventories equal to 20% of the following month's sales. This requirement will be met at the end of June. Each wallet requires 3 pounds of raw materials. f. The company requires that the ending inventory of raw materials be equal to 10% of the following month's production needs. g. The raw material costs $1.50 per pound. h. 40% of a month's purchases of raw materials is paid for in the month of the purchase; the remainder is paid for in the following month. i. The Accounts Payable on June 30 will be $80,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
