Question

In: Accounting

Selling price   $75.00 June 8000 July 9000 August 10000 September 12000 Credit Sales Collected in the...

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

$2.00

Direct labor wage rate per hour

$15.00

Direct labor hours required for each unit of finished goods

2

Variable selling & administrative expense per unit sold

$1.80

fixed selling and administrative expense per month

$60,000.00

1. What are the budgeted sales for July?

2. What are the expected cash collections for July?

3. What is the accounts receivable balance at the end of July?

4. According to the production budget, how many units should be produced in July?

5. If 52,000 pounds of raw materials are needed to meet production in August, how many pounds of raw materials should be purchased in July?

6. What is the estimated cost of raw materials purchases for July?

7. If the cost of raw material purchases in June is $88,880, what are the estimated cash disbursements for raw materials purchases in July?

8. What is the estimated accounts payable balance at the end of July?

9. What is the estimated raw materials inventory balance at the end of July?

10.What is the total estimated direct labor cost for July assuming the direct labor workforce is adjusted to match the hours required to produce the forecasted number of units produced?

11.If the company always uses an estimated predetermined plantwide overhead rate of $10 per direct labor-hour, what is the estimated unit product cost?

12.What is the estimated finished goods inventory balance at the end of July?

13.What is the estimated cost of goods sold and gross margin for July?

14.What is the estimated total selling and administrative expense for July?

15.What is the estimated net operating income for July?

Assumptions to use for the budget:

1. the selling price is $75.00 per unit.

2. the beginning accounts receivable balance is $315,000

3. the beginning accounts payable balance is $49,000.

4. the beginning cash balance is $49,500

Other than the above all other information is as presented in the text.

Required:

Using the information above answer questions 1 through 15

Solutions

Expert Solution

Solution:

Part 1 –

Budgeted Sales for July = July Sales Units 9,000 x Unit Selling Price $75

= $675,000

Part 2 – Expected Cash Collection for July

Schedule of Expected Cash Collections

July

Total July month sales

$675,000

Cash Collection from Sales on Account:

July Sales (40% of $675,000 is collected in the same month i.e. July)

$270,000

June Sales (60% of June Sales 8,000 Units x $75 is collected in July Month i.e. Next following month)

$360,000

Total Cash Collections in July

$630,000

Part 3 – Accounts Receivable balance at the end of July

Accounts Receivable which will be collected in August is the 60% of July Credit Sales.

Hence, Accounts Receivable balance at the end of July = July Credit Sales $675,000 * 60% = $405,000

Part 4 –

Number of units to be produced in July = 9,200 Units

Working for calculation of July Production Units

Production Budget

June

July

August

September

Budgeted Units to be sold

8000

9000

10000

12000

Plus: Desired Finished Goods Ending Inventory (20% of following month's unit sales)

1800

2000

2400

Total units needed

9800

11000

12400

Less: Estimated Finished Goods Beginning Inventory (Ending inventory of previous month)

1600

1800

2000

Budgeted units to be produced

8200

9200

10400

Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you

Pls ask separate question for remaining parts


Related Solutions

Cruises, Inc. has budgeted sales revenues as follows:    June July   August September Credit sales ($)...
Cruises, Inc. has budgeted sales revenues as follows:    June July   August September Credit sales ($) 135,000 125,000 $ 90,000 120,000 Cash sales ($) 90,000 255,000 195,000 175,000 Total sales ($) 225,000 380,000 285,000 295,000 Purchases ($) 300,000 240,000 205,000 185,000    Past experience indicates that 60% of the credit sales will be collected in the month of sale and 20% will be collected in the following month and the remaining 20% after two months. Purchases of inventory are all...
The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and...
The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 8,900, 20,000, 22,000, and 23,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 equals 10% of the following month’s raw materials production needs. Each unit of...
Need answers 1-4! Projected unit sales: June sales 120,000, July sales 130,000, August 140,000, September 150,000...
Need answers 1-4! Projected unit sales: June sales 120,000, July sales 130,000, August 140,000, September 150,000 and October sales 170,000. Sales price per unit, $15.00 Units in ending inventory each month should equal 10% of next month sales. Raw material required per unit is 2 pounds; cost is $3.00 per lb. Ending inventory required at the end of each month is 5% of next month needs. Direct labor required to produce one units is .25 direct labor hour. The hourly...
Question 4: Rodie Company has budgeted sales revenues as follows: Particulars June July August Credit Sales...
Question 4: Rodie Company has budgeted sales revenues as follows: Particulars June July August Credit Sales $135,000 $145,000 $90,000 Cash Sales $90,000 $255,000 $195,000 Total Sales $225,000 $400,000 $285,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase....
Rodie Company has budgeted sales revenues as follows: Particulars June July August Credit sales $135,000 $145,000...
Rodie Company has budgeted sales revenues as follows: Particulars June July August Credit sales $135,000 $145,000 $ 90,000 Cash sales 90,000 255,000 195,000 Total sales $225,000 $400,000 $285,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. Budgeted...
2. Sushi House has budgeted sales revenue as follows: June July August Credit Sales $85,000 $80,000...
2. Sushi House has budgeted sales revenue as follows: June July August Credit Sales $85,000 $80,000 $72,000 Cash Sales 14,000 25,000 32,000 Total Sales $99,000 $105,000 $104,000 Past experience indicates that 70% of the credit sales will be collected in the month of sale and the remaining 30% will be collected in the following month. Purchases of inventory are all on credit and 60% is paid in the month of purchase and 40% in the month following purchase. Budgeted inventory...
Farley Company has budgeted sales revenues as follows: June July August Cash Sales 255,000 195,000 Credit...
Farley Company has budgeted sales revenues as follows: June July August Cash Sales 255,000 195,000 Credit Sales 135,000 145,000 90,000 Total Sales 135,000 400,000 285,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. Budgeted inventory purchases are:...
September october November December January sales (units) 8000 12000 13000 16000 15000 Direct manufacturing labours hour...
September october November December January sales (units) 8000 12000 13000 16000 15000 Direct manufacturing labours hour per unit 1.79 1.75 1.70 1.65 1.60 Direct manufacturing labour rate per unit $15.75 $16.00 $16.50 $17.50 $17.50 Ending inventory required is the next month sales , plus one half the following months sales The ending inventory in august was 15000 units Each employee is required to contributed to canada pension plan in the order of 4.9% of wages, this is matched by the...
Enterprises reported the following cash collections in July and August from credit sales: July August From...
Enterprises reported the following cash collections in July and August from credit sales: July August From June receivables $ 39,000 From July sales 126,000 $ 54,000 From August sales 168,000 The company sells a single product for $20, and all sales are collected over a two-month period. Required: Determine the number of units that were sold in July. Determine the percent of credit sales collected in the month of sale and the percent of sales collected in the month following...
Month May June July August September October November December January Sales 350 350 250 250 350...
Month May June July August September October November December January Sales 350 350 250 250 350 550 650 750 650 Collections month 0: 80%*95% month -1: 15% month -2: 5% Payments Purchase - 70% of next month sales Purchase payment - 50% of current month purchase Purchase payment - 50% of last month purchase Lease payment 10 10 10 10 10 10 construction 0 0 0 60 0 0 wages 30 30 40 50 70 80 other 5 5 5...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT