Question

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 Selling and Administrative expenses for February

Homework Answers

Answer #1

December sales = 500,000 units

Sales will increase by 5% in January   

Increase in sales in January = 500,000 x 5%

= 25,000 units

January sales = 500,000 + 25,000

= 525,000 units  

February sales will be 15,000 units less than January

February sales = 525,000 - 15,000

= 510,000 units

Selling price = $2 per unit

February sales in dollars = February sales x Selling price

= 510,000 x 2

= $1,020,000

Sales commissions = 10% of sales

= 1,020,000 x 10%

= $102,000

Administrative salaries

$15,000

Sales salaries

$12,000

Sales commissions

$102,000

Total $129,000

Selling and Administrative expenses for February = $129,000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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...
The selling price per unit is $50.00 December of the previous year 20,000 January                            &nbsp
The selling price per unit is $50.00 December of the previous year 20,000 January                                     40,000 February                                   60,000 March                                       80,000 April                                         100,000                            Prepare a purchases budget and the schedule for Disbursements for Purchases for January through March and for the first quarter in total. Assume that the company only sells one product that can be purchased at $35.00 per unit. The market for this product is very competitive and customers highly value quality and on time delivery of the product. Also assume that currently...
1. Prepare a sales budget for January through May. The selling price per unit is $40.00....
1. Prepare a sales budget for January through May. The selling price per unit is $40.00. December of the previous year-40,000 January-90,000 February-80,000 March-70,000 April-40,000 2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only sells one product that can be purchased at $15.00 per unit. The market for this product is very competitive and customers highly value service such as quality and on time delivery of the product. Also...
Merline Manufacturing makes its product for $65 per unit and sells it for $137 per unit....
Merline Manufacturing makes its product for $65 per unit and sells it for $137 per unit. The sales staff receives a 10% commission on the sale of each unit. Its December income statement follows. MERLINE MANUFACTURING Income Statement For Month Ended December 31, 2017 Sales $ 1,370,000 Cost of goods sold 650,000 Gross profit 720,000 Operating expenses Sales commissions (10%) 137,000 Advertising 214,000 Store rent 24,700 Administrative salaries 43,500 Depreciation—Office equipment 53,500 Other expenses 12,700 Total expenses 485,400 Net income...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 13,000 April 15,000 May 12,500 June 11,000 Wright maintains an ending inventory for each month in the amount of one and one-half times the expected sales in the following month. The ending inventory for February (March’s beginning inventory) reflects this policy. Materials cost $5 per unit and are paid for in the month after production. Labor cost is $9 per unit and is paid...
The Ace Battery Company has forecast its sales in units as follows:   January 1,500 May 2,050...
The Ace Battery Company has forecast its sales in units as follows:   January 1,500 May 2,050   February 1,350 June 2,200   March 1,300 July 1,900   April 1,800 Ace always keeps an ending inventory equal to 130 percent of the next month's expected sales. The ending inventory for December (January's beginning inventory) is 1,950 units, which is consistent with this policy. Materials cost $10 per unit and are paid for in the month after production. Labour cost is $3 per unit and...
1. Teller Co. is planning to sell 900 boxes of ceramic tile, with production estimated at...
1. Teller Co. is planning to sell 900 boxes of ceramic tile, with production estimated at 870 boxes during May. Each box of tile requires 44 pounds of clay mix and a quarter hour of direct labor. Clay mix costs $0.40 per pound and employees of the company are paid $12.00 per hour. Manufacturing overhead is applied at a rate of 110% of direct labor costs. Teller has 3,900 pounds of clay mix in beginning inventory and wants to have...
1. Prepare a sales budget for January through May. The selling price per unit is $40.00....
1. Prepare a sales budget for January through May. The selling price per unit is $40.00. December of the previous year 40,000 January 90,000 February 80,000 March 70,000 April 40,000 2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only sells one product that can be purchased at $15.00 per unit. The market for this product is very competitive and customers highly value service such as quality and on time...
1. Prepare a sales budget for January through May. The selling price per unit is $40.00....
1. Prepare a sales budget for January through May. The selling price per unit is $40.00. December of the previous year-40,000 January-90,000 February-80,000 March-70,000 April-40,000 2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only sells one product that can be purchased at $15.00 per unit. The market for this product is very competitive and customers highly value service such as quality and on time delivery of the product. Also...