Y Co's fiscal year begins on April 1. The following is an extract from a trial...

    

Transcribed Image Text:

Y Co's fiscal year begins on April 1. The following is an extract from a trial balance at May 31, 2020: DR CR Cash Accounts Receivable $54,400 Bad Debt Allowance Inventory Merchandise $32,000 Accounts Payable Merchandise$14,000 $7,000 $4.480 Data concerning company's purchase of merchandise inventory: Purchase price per unit $16 75% of any month's purchases ae payable in the month of purchase while the rest is due and paid for in the following month. At end of each month the company's policy is to have an inventory equal to 50% of the following month's unit sales. Sales Data: Selling price per unit April actual sales revenue May actual sales revenue June estimated sales $32 $64,000 $96,000 revenue $128,000 July estimated sales $112,000 $1,600,000 revenue Total sales expected in fiscal year 50% of billings are collected during the month of sale, 40% in the following month, 7% in the next following calendar month and 3% is uncollectable. Customers are allowed a 2% cash discount if payment is made by the end of the calendar month in which the sales took place. Selling and administrative expenses (exclusive of bad debt expenses): Total selling and admin expenses for fiscal year Total fixed selling & admin expenses for fiscal year (included in total) incurred evenly throughout the year $216,000 $48,000 Annual amortization expense (included in fixed selling and admin expense) $12,000 I Variable selling and administrative expenses vary with sales revenue. Selling and administrative expenses are paid as incurred. Required: a) Prepare a cash budget for Y Co for June 2020. b) What are the components of a master budget? Y Co's fiscal year begins on April 1. The following is an extract from a trial balance at May 31, 2020: DR CR Cash Accounts Receivable $54,400 Bad Debt Allowance Inventory Merchandise $32,000 Accounts Payable Merchandise$14,000 $7,000 $4.480 Data concerning company's purchase of merchandise inventory: Purchase price per unit $16 75% of any month's purchases ae payable in the month of purchase while the rest is due and paid for in the following month. At end of each month the company's policy is to have an inventory equal to 50% of the following month's unit sales. Sales Data: Selling price per unit April actual sales revenue May actual sales revenue June estimated sales $32 $64,000 $96,000 revenue $128,000 July estimated sales $112,000 $1,600,000 revenue Total sales expected in fiscal year 50% of billings are collected during the month of sale, 40% in the following month, 7% in the next following calendar month and 3% is uncollectable. Customers are allowed a 2% cash discount if payment is made by the end of the calendar month in which the sales took place. Selling and administrative expenses (exclusive of bad debt expenses): Total selling and admin expenses for fiscal year Total fixed selling & admin expenses for fiscal year (included in total) incurred evenly throughout the year $216,000 $48,000 Annual amortization expense (included in fixed selling and admin expense) $12,000 I Variable selling and administrative expenses vary with sales revenue. Selling and administrative expenses are paid as incurred. Required: a) Prepare a cash budget for Y Co for June 2020. b) What are the components of a master budget?