Lunar Industry maintains ending inventory for each month at 40% of the next month’s sales. The company predicted the following sales for the first four months of the year: January February March April Sales (units) 1,560 1,820 1,950 1,560 How many units should be produced in February?

Lunar Industry maintains ending inventory for each month at 40% of the next month’s sales. The company predicted the following sales for the first four months of the year: January February March April Sales (units) 1,560 1,820 1,950 1,560 How many units should be produced in February?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterC: Cases

Section: Chapter Questions

Problem 1C

See similar textbooks

Similar questions

Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
Langstons purchased $3,100 of merchandise during the month, and its monthly income statement shows a cost of goods sold of $3,000. What was the beginning inventory if the ending inventory was $1,250?
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
Bookworm Corporation maintains ending inventory for each month at 5% of the following month's sales. It predicted the following sales (in units) for the first four months of the coming year: February 2,400 April 2,800 January March Sales (units) 2,000 3,000 How many units should be produced in March?
Truliant Co. sells a product called Withitall and has predicted the following sales for the first four months of the current year: January February March April Sales in units 17,000 1,900 2,100 1,600 Ending inventory for each month should be 20% of next month's sales. The number of units produced in February should be a.1,940 units b.1,900 units c.1,800 units d.1,850 units
Fi
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: 20,000 22,000 19,500 18,000 March April May June Wright maintains an ending inventory for each month in the amount of two 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 $7 per unit and are paid for in the month after production. Labor cost is $11 per unit and is paid for in the month incurred. Fixed overhead is $19,000 per month. Dividends of $21,400 are to be paid in May. The firm produced 19,000 units in February. Complete a production schedule and a summary of cash payments for March, April, and May. Remember that production in any one month is equal to sales plus desired ending inventory minus beginning inventory. Note: Input all amounts as positive values except Beginning inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank…
KCO, SRL anticipates the following sales in the given months: March 42,000 units April 59,000 units May 49,000 units June 55,000 units July 52,000 units Company policy is to maintain an ending finished goods inventory equal to 50% of the following month's sales. On the basis of this information, how many units would the company plan to produce in May?
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: ces March April May June 12,000 14,000 11,500 10,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 the month incurred. Fixed overhead is $15,000 per month. Dividends of $20,600 are to be paid in May. The firm produced 11,000 units in February. Complete a production schedule and a summary of cash payments for March, April, and May. Remember that production in any one month is equal to sales plus desired ending inventory minus beginning inventory. Note: Input all amounts as positive values except Beginning inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank be certain…
The Volt Battery Company has forecast its sales in units as follows: January February March April May June July 1,000 850 800 1,300 1,550 1,700 1,400 Volt Battery always keeps an ending inventory equal to 120 percent of the next month's expected sales. The ending inventory for December (January's beginning inventory) is 1,200 units, which is consistent with this policy. Materials cost $11 per unit and are paid for in the month after purchase. Labor cost is $4 per unit and is paid in the month the cost is incurred. Overhead costs are $7,000 per month. Interest of $8,200 is scheduled to be paid in March, and employee bonuses of $13,400 will be paid in June. a. Prepare a monthly production schedule for January through June. Note: Input all amounts as positive values except Beginning Inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank be certain to enter O wherever required. Projected unit sales Desired ending inventory Total units…