What is the accounts receivable balance at the end of July?
If 113,000 pounds of raw materials are needed to meet production in August, what is the estimated cost of raw materials purchases for July?
Credit sales of July = Sales units * Selling price = 26000 * 60 | 1560000 |
Accounts receivables balance at the end of July = Credit sales of July * 60% = 1560000 * 60% | 936000 |
Production budget | ||||
June | July | August | September | |
Budgeted unit sales | 9500 | 26000 | 28000 | 29000 |
(+) Desired ending inventory ( 25% of following month's unit sales ) | 6500 | 7000 | 7250 | |
Total units required | 16000 | 33000 | 35250 | |
(-) Beginning inventory | 2375 | 6500 | 7000 | |
Budgeted unit production | 13625 | 26500 | 28250 |
Note : Beginning inventory for June = Ending inventory of May = 25% * June's unit sales = 25% * 9500 | 2375 |
Raw materials purchase budget | |||
June | July | August | |
Budgeted unit production | 13625 | 26500 | 28250 |
(*) Raw materials required per unit (pounds) | 4 | 4 | 4 |
Raw materials production needs (pounds) | 54500 | 106000 | 113000 |
(+) Desired ending inventory ( 15% of following month's production needs ) | 15900 | 16950 | |
Total raw materials needed | 70400 | 122950 | |
(-) Desired Beginning inventory | 8175 | 15900 | |
Raw materials purchases | 62225 | 107050 | |
(*) Cost per pound of raw materials | 2.40 | 2.40 | |
Estimated cost of raw materials purchase | 149340 | 256920 |
Note : Beginning inventory for June = Ending inventory of May = 15% * June's raw materials production needs = 15% * 54500 | 8175 |
Estimated cost of raw materials purchase for July | 256920 |
What is the accounts receivable balance at the end of July? If 113,000 pounds of raw...
Morganton Company makes one product and it provided the following information to help prepare the master budget:The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 8,400, 10,000, 12,000, and 13,000 units, respectively. All sales are on credit.Forty percent of credit sales are collected in the month of the sale and 60% in the following month.The ending finished goods inventory equals 20% of the following month’s unit sales.The ending raw materials inventory...
Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 8,700, 18,000, 20,000, and 21,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 30% of the following month’s unit sales. The...
Morganton Company makes one product and it provided the following information to help prepare the master budget:The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 8,400, 10,000, 12,000, and 13,000 units, respectively. All sales are on credit.Forty percent of credit sales are collected in the month of the sale and 60% in the following month.The ending finished goods inventory equals 20% of the following month’s unit sales.The ending raw materials inventory...
can you fill this out? thank you!
Required information The Foundational 15 [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, LO8-10] [The following information applies to the questions displayed below.) Morganton Company makes one product and it provided the following information to help prepare the master budget: a. The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 8,400, 10,000, 12,000, and 13,000 units, respectively. All sales are on credit. b. Forty percent of...
Selling price $75.00 June 8000 July 9000 August 10000 September 12000 Credit Sales Collected in the month of the sale 40% Following month 60% Ending finished goods inventory of the following month's unit sales 20% Ending raw materials inventory of the following month's raw materials production needs 10% Raw materials purchases are paid for in the month of purchase 30% Following month 70% Pounds of raw materials required for each unit of finished goods 5 Raw materials cost per pound...
Morganton Company makes one product and it provided the following information to help prepare the master budget: A) The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August and Septmeber are 8,400, 15,000, 17,000 and 18,000 units, respectively. All sales are on credit. B) 30% of credit sales are collected in the month of the sale and 70% in the following month. C) The ending finished goods inventory equals 30% of the following month’s unit...
Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 8,400, 10,000, 12,000, and 13,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month’s unit sales. The...
Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 9,100, 22,000, 24,000, and 25,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month’s unit sales. The...
Required information [The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 8,800, 19,000, 21,000, and 22,000 units, respectively. All sales are on credit. Thirty percent of credit sales are collected in the month of the sale and 70% in the following month. The ending finished...
[The following information applies to the questions displayed below.]Morganton Company makes one product and it provided the following information to help prepare the master budget:The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 8,800, 19,000, 21,000, and 22,000 units, respectively. All sales are on credit.Thirty percent of credit sales are collected in the month of the sale and 70% in the following month.The ending finished goods inventory equals 20% of the...