Question

In: Accounting

JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...

JC Floor Design makes ceramic tiles

December sales were:

500,000 units

Selling price $2 per unit

1,000,000 total sales

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

Administrative salaries

$15,000 per month

Sales salaries

$12,000 per month

Sales commissions

10% of sales

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 the materials to be purchased in March

Solutions

Expert Solution

Given information

December sales in units = 500,000 units

Selling price per unit = $2 per unit

January sales in units = increased by 5% = 500,000 x 105% = 525,000 units

February sales in units = 15,000 units less than January = 525,000 - 15,000 = 510,000 units

March sales in units = 3% higher than February sales units = 510,000 x 103% = 525,300 units

April sales in units = 5,300 units less than March sales units = 525,300 - 5,300 = 520,000 units

Ending inventory of finished goods = 30% of next month's sales

Ending inventory of raw materials = 25% of next month production requirement.

1. Statement showing the production budget for January, February, March and April:

January February March April
a. Budgeted unit sales 525,000 510,000 525,300 520,000
b. Desired Ending Finished Good Inventory 153,000 (510,000 x 30%) 157,590 (525,300 x 30%) 156,000 (520,000 x 30%) 161,000
c. Total Needs (a + b) 678,000 667,590 681,300 681,000
d. Beginning Finished Good Inventory 168,000 153,000 157,590 156,000
e. Required Production in units (c - d) 510,000 514,590 523,710 525,000


2. Statement of Raw material Purchase Budget:

January February March April
a. Required Production in units 510,000 514,590 523,710 525,000
b. Raw material required to produce one unit (pounds) 0.60 0.60 0.60 0.60
c. Production needs (pounds) (a x b) 306,000 308,754 314,226 315,000
d. Desired Ending inventory of raw material (pounds) 77,189 78,557 78,750
(308,754 x 25%) (314,226 x 25%) (315,000 x 25%)
e. Total needs (pounds) (c + d) 383,189 387,311 392,976
f. Beginning inventory of raw material (pounds) 60,000 77,189 78,557
g. Raw materials to be purchased (pounds) (e - f) 323,189 310,122 314,420
h. Cost of raw materials per pound ($) $0.50 $0.50 $0.50
i. Cost of raw materials to be purchased ($) (g x h) $161,594 $155,061 $157,210

Computation of the materials to be purchased in March:

Materials to be purchased in March (in pounds) = 314,420 pounds (See statement 2g above)

Materials to be purchased in March (in dollar) = 314,420 x $0.50 = $157,210


Related Solutions

JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales 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...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales 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...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales 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...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales 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...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales 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...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales 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...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales 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...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales 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...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales 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...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT