Omar Inc manufactures an advanced swim fin for scurba divers Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget The marketing department has estimated sales in units as follows for the remainder of the year June 6,500 July 5,400 August 7,200 September 4,600 October 3,800 The selling price of the swim fins is $35 per pair All sales are on account Based on the experience, the company has learned that 40 of a months of sales are collected in the month of sale, another 50 are collected in the month following sale, and the remaining 10 are collected in the second month of sale May sales totaled $ 105,000 and June Sales $227,500 The finished goods inventory on hand at the end of each month must be equal to 15 of the next months sales The finished goods inventory on hand in June 30, is budgeted to be $810 Each pair of swim fins requires 3 pounds of geico compound The company would like the inventory of geico compound on hand at the end of each month to be equal to 20 of the following months production needs The inventory of geico compound on hand on June 30 is budgeted to be 3,402 pounds and inventory on hand on September 30 is budgeted to be 2,280 pounds Geico compound costs $0 40 per pound You are required to prepare the following budgets using the information given in the question below to answers the questions Budgeted sales in Dollars Schedule of Expected cash collection Production Budget Direct Material Budget You are required to add the following information What is the sale for the third quarter What is the amount of account receivables What is the total cash collection for the third quarter What is the ending inventory on September 30 What is the total required production for the third quarterr What is the total raw material purchese for the quarter What is the total cost of Raw material purches(gieco compound) for the third quarter

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 16, 2024

Omar Inc. manufactures an advanced swim fin for scurba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has

Omar Inc. manufactures an advanced swim fin for scurba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget.

The marketing department has estimated sales in units as follows for the remainder of the year.

June	6,500
July	5,400
August	7,200
September	4,600
October	3,800

The selling price of the swim fins is $35 per pair.

All sales are on account. Based on the experience, the company has learned that 40% of a months of sales are collected in the month of sale, another 50% are collected in the month following sale, and the remaining 10% are collected in the second month of sale. May sales totaled $ 105,000 and June Sales $227,500.

The finished goods inventory on hand at the end of each month must be equal to 15% of the next months sales. The finished goods inventory on hand in June 30, is budgeted to be $810.

Each pair of swim fins requires 3 pounds of geico compound. The company would like the inventory of geico compound on hand at the end of each month to be equal to 20% of the following months production needs. The inventory of geico compound on hand on June 30 is budgeted to be 3,402 pounds and inventory on hand on September 30 is budgeted to be 2,280 pounds.

Geico compound costs $0.40 per pound.

You are required to prepare the following budgets using the information given in the question below to answers the questions

Budgeted sales in Dollars
Schedule of Expected cash collection
Production Budget
Direct Material Budget

You are required to add the following information:

What is the sale for the third quarter?
What is the amount of account receivables?
What is the total cash collection for the third quarter?
What is the ending inventory on September 30?
What is the total required production for the third quarterr?
What is the total raw material purchese for the quarter?
What is the total cost of Raw material purches(gieco compound) for the third quarter?