JC Floor Design makes ceramic tiles

December sales were:

The Marketing Department, projects sales to:

increase by 5% in January     

February sales will be 15,000 units less than January

March sales will be 3% higher than February sales

April sales will be the 5,300 units less than march

The price is not expected to increase

JC inventory policy is to maintain an ending inventory equals to 30% of next month sales. Actual inventory is 168,000 units                         

Clay the material to make the tiles cost $.50 per pound and each tile requires .6 pound. Actual clay inventory is 60,000 pounds and the inventory policy is to maintain an inventory equal to 25% of next month production requirement.

April production is expected to be 525,000 units. The cost of direct materials purchased in December was $150,000                                

Each tile requires .10 hours and the labor hourly rate is $8.00 per hour       

Variable overhead rate is 20% of labor and fixed overhead is 25,000 monthly

Selling and administrative expenses are expected to be

70% of sales are cash sales and the remaining are collected in the next month

Material are paid 60% cash and the remaining the next month

The company has the following obligations:

100,000 in dividends will be paid in February

A new machine will be acquired in January with a cost of 250,000

A short-term loan with an outstanding balance of $150,000 is used to manage the cash position. Interest on the short-term loan are 1% monthly

Taxes of last quarter were $240,000 and will be paid in March. The company tax rate is 35%. and taxes are paid in the next quarter.

1. Compute Accounts Receivables in Balance Sheet

2. Compute Accounts Payable in the Balance Sheet

3. Compute Cost of goods sold

4. Compute Finished goods inventory in Balance Sheet

The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:

The gross margin is 25% of sales.

Actual and budgeted sales data:

Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales.

Each month’s ending inventory should equal 80% of the following month’s budgeted cost of goods sold.

One-half of a month’s inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory.

Monthly expenses are as follows: commissions, 12% of sales; rent, $2,500 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $972 per month (includes depreciation on new assets).

Equipment costing $1,700 will be purchased for cash in April.

Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.

Required:

Using the preceding data:

1. Complete the following schedule:

2. Complete the following:

3. Complete the following cash budget:

4. Prepare an absorption costing income statement for the quarter ended June 30.

5. Prepare a balance sheet as of June 30.

JC Floor Design makes ceramic tiles

December sales were:

The Marketing Department, projects sales to:

increase by 5% in January     

February sales will be 15,000 units less than January

March sales will be 3% higher than February sales

April sales will be the 5,300 units less than march

The price is not expected to increase

JC inventory policy is to maintain an ending inventory equals to 30% of next month sales. Actual inventory is 168,000 units                         

Clay the material to make the tiles cost $.50 per pound and each tile requires .6 pound. Actual clay inventory is 60,000 pounds and the inventory policy is to maintain an inventory equal to 25% of next month production requirement.

April production is expected to be 525,000 units. The cost of direct materials purchased in December was $150,000                                

Each tile requires .10 hours and the labor hourly rate is $8.00 per hour       

Variable overhead rate is 20% of labor and fixed overhead is 25,000 monthly

Selling and administrative expenses are expected to be

70% of sales are cash sales and the remaining are collected in the next month

Material are paid 60% cash and the remaining the next month

The company has the following obligations:

100,000 in dividends will be paid in February

A new machine will be acquired in January with a cost of 250,000

A short-term loan with an outstanding balance of $150,000 is used to manage the cash position. Interest on the short-term loan are 1% monthly

Taxes of last quarter were $240,000 and will be paid in March. The company tax rate is 35%. and taxes are paid in the next quarter.

REQUIRED:

Compute total interest paid, Accounts Receivables in Balance Sheet, Accounts Payable in the Balance Sheet, Cost of goods sold, Finished goods inventory in Balance Sheet, Gross Profit, and the after tax income

JC Floor Design makes ceramic tiles

December sales were:

The Marketing Department, projects sales to:

increase by 5% in January     

February sales will be 15,000 units less than January

March sales will be 3% higher than February sales

April sales will be the 5,300 units less than march

The price is not expected to increase

JC inventory policy is to maintain an ending inventory equals to 30% of next month sales. Actual inventory is 168,000 units                         

Clay the material to make the tiles cost $.50 per pound and each tile requires .6 pound. Actual clay inventory is 60,000 pounds and the inventory policy is to maintain an inventory equal to 25% of next month production requirement.

April production is expected to be 525,000 units. The cost of direct materials purchased in December was $150,000                                

Each tile requires .10 hours and the labor hourly rate is $8.00 per hour       

Variable overhead rate is 20% of labor and fixed overhead is 25,000 monthly

Selling and administrative expenses are expected to be

70% of sales are cash sales and the remaining are collected in the next month

Material are paid 60% cash and the remaining the next month

The company has the following obligations:

100,000 in dividends will be paid in February

A new machine will be acquired in January with a cost of 250,000

A short-term loan with an outstanding balance of $150,000 is used to manage the cash position. Interest on the short-term loan are 1% monthly

Taxes of last quarter were $240,000 and will be paid in March. The company tax rate is 35%. and taxes are paid in the next quarter.

REQUIRED:

Compute Accounts Payable in th Balance Sheet
Compute Cost of goods sold
Compute Finished goods inventory in Balance Sheet
Compute Gross Profit
Compute after tax income

The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:

The gross margin is 25% of sales.

Actual and budgeted sales data:

Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales.

Each month’s ending inventory should equal 80% of the following month’s budgeted cost of goods sold.

One-half of a month’s inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory.

Monthly expenses are as follows: commissions, 12% of sales; rent, $2,500 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $972 per month (includes depreciation on new assets).

Equipment costing $1,700 will be purchased for cash in April.

Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.

Required:

Using the preceding data:

1. Complete the following schedule of expected cash collections

2. Complete the following: Merchandise Purchases Budget

3. Complete the following cash budget:

4. Prepare an absorption costing income statement for the quarter ended June 30.

5. Prepare a balance sheet as of June 30.

The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:

The gross margin is 25% of sales.

Actual and budgeted sales data:

Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales.

Each month’s ending inventory should equal 80% of the following month’s budgeted cost of goods sold.

One-half of a month’s inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory.

Monthly expenses are as follows: commissions, 12% of sales; rent, $2,300 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $954 per month (includes depreciation on new assets).

Equipment costing $1,500 will be purchased for cash in April.

Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.

Required:

Using the preceding data:

1. Complete the following schedule:

2. Complete the following:

3. Complete the following cash budget:

4. Prepare an absorption costing income statement for the quarter ended June 30.

5. Prepare a balance sheet as of June 30.

The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:

Current assets as of March 31:

Cash

$

7300

Accounts receivable

$

19200

Inventory

$

38400

Building and equipment, net

$

124800

Accounts payable

$

22800

Capital stock

$

150,000

Retained earnings

$

16900

The gross margin is 25% of sales.

Actual and budgeted sales data:

March (actual)

$

48000

April

$

64000

May

$

69000

June

$

94000

July

$

45000

C. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales.

D. Each month’s ending inventory should equal 80% of the following month’s budgeted cost of goods sold.

E. One-half of a month’s inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory.

F. Monthly expenses are as follows: commissions, 12% of sales; rent, $2,100 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $936 per month (includes depreciation on new assets).

G. Equipment costing $1,300 will be purchased for cash in April.

H. Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.

Required:

Using the data above:

1. Complete the following schedule.

Complete the following

3. complete the following cash budget

4. prepare an absorption costing income statement for the quarter ended June 30

5. Prepare a balance sheet as of June 30

The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:

The gross margin is 25% of sales.

Actual and budgeted sales data:

Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales.

Each month’s ending inventory should equal 80% of the following month’s budgeted cost of goods sold.

One-half of a month’s inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory.

Monthly expenses are as follows: commissions, 12% of sales; rent, $4,000 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $783 per month (includes depreciation on new assets).

Equipment costing $3,200 will be purchased for cash in April.

Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.

Required:

Using the preceding data:

1. Complete the following schedule:

2. Complete the following:

3. Complete the following cash budget:

4. Prepare an absorption costing income statement for the quarter ended June 30.

5. Prepare a balance sheet as of June 30.

The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:

The gross margin is 25% of sales.

Actual and budgeted sales data:

Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales.

Each month’s ending inventory should equal 80% of the following month’s budgeted cost of goods sold.

One-half of a month’s inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory.

Monthly expenses are as follows: commissions, 12% of sales; rent, $3,200 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $927 per month (includes depreciation on new assets).

Equipment costing $2,400 will be purchased for cash in April.

Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.

Required:

Using the preceding data:

1. Complete the following schedule: schedule of expected cash collections

2. Complete the following: merchandise purchases budget

3. Complete the following cash budget:

4. Prepare an absorption costing income statement for the quarter ended June 30.

5. Prepare a balance sheet as of June 30.