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 Cash Receipts for January
We need at least 9 more requests to produce the answer.
1 / 10 have requested this problem solution
The more requests, the faster the answer.
Garver Industries has budgeted the following unit sales: 2020 January February March April May Units 10,000 8,000 9,000 11,000 15,000 The finished goods units on hand on December 31, 2019, was 2,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated sales. They also have...
High End Crockery Corp makes pottery bowls. The following information is available: Budgeted Selling Price $200 each Budgeted Unit Sales December 4,000 January 3,500 February 2,500 March 2,000 April 1,800 Desired ending finished goods inventory 15% of next month's sales Pounds of clay needed per bowl 4 Price per pound of clay $2.50 Desired ending inventory direct materials 30% of next month's production needs December purchases for direct materials $37,525 Direct labor hours per bowl...
High End Crockery Corp makes pottery bowls. The following information is available: Budgeted Selling Price $200 each Budgeted Unit Sales December 4,000 January 3,500 February 2,500 March 2,000 April 1,800 Desired ending finished goods inventory 15% of next month's sales Pounds of clay needed per bowl 4 Price per pound of clay $2.50 Desired ending inventory direct materials 30% of next month's production needs December purchases for direct materials $37,525 Direct labor hours per bowl...
Garver Industries has budgeted the following unit sales: 2020 January February March April May Units 10,000 8,000 9,000 11,000 15,000 The finished goods units on hand on December 31, 2019, was 2,000 units. E n it requires 3 pounds of raw materials that ar pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month! maintaining a raw materials inventory at the end of each month equal...
: 01:58 PM / Remaining: 45 min CALCULATOR PRINTER VERSION NEXT 2020 January February March April May Units 10,000 8,000 9,000 11,000 15,000 The finished goods units on hand on December 31, 2019, was 2,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated sales....
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 17,000 April 19,000 May 16,500 June 15,000 Wright maintains an ending inventory for each month in the amount of one times the expected sales in the following month. The ending inventory for February (March’s beginning inventory) reflects this policy. Materials cost $4 per unit and are paid for in the month after production. Labor cost is $8 per unit and is paid for in...
Trebblehorn Industries has adopted the following sales budget for the first 3 months of 2017. Month Units January 11,000 February 15,000 March 13,000 Management requires 30% of next month sales to be in ending inventory. Each unit requires 5 pounds of raw materials costing $3 per pound. Management wants to have a raw materials inventory at the end of the month equal to 35% of next month's production requirements. April's expected sales are 12,000 with a total of 13,500 required...
3. Garver Industries has budgeted the following unit sales: 2018 Units 12,000 8,500 10,000 January February March April 11,000 15,000 May The finished goods units on hand on December 31, 2017, was 3,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $5 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 25% of next month's anticipated sales. They also...
Near the end of 2017, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2017. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2017 Assets Cash $ 35,500 Accounts receivable 520,000 Inventory 105,000 Total current assets $ 660,500 Equipment 636,000 Less: accumulated depreciation 79,500 Equipment, net 556,500 Total assets $ 1,217,000 Liabilities and Equity Accounts payable $ 345,000 Bank loan payable 15,000 Taxes payable (due 3/15/2018) 89,000 Total liabilities $ 449,000...
provided Nove Budgeted 2020 Sales: Water bottles February 7,000 produce a cash budger for March January 8.000 8,000 April 10,000 Additional information for your budget preparation is as follows: a) Because of increased competition the average sales price per water bottle in 2020 is expected to drop to b) Wonderful Water bottles has a policy that each month's ending inventory of finished goods (water bottles) $15.00 per bottle should be 20% of the following month's sales in units. Ending inventory...