ABC Company forecasts sales in units for January to May as follows: Jan Feb Mar Apr May Units 2,000 2,200 2,500 2,800 3,000 Moreover, ABC Company would like to maintain 100 units in its ending inventory at the end of eachmonth Beginning inventory at the start of January amounts to 50units. How many units should ABC Company produce in order to fulfill the expected sales of the company?

ABC Company forecasts sales in units for January to May as follows: Jan Feb Mar Apr May Units 2,000 2,200 2,500 2,800 3,000 Moreover, ABC Company would like to maintain 100 units in its ending inventory at the end of eachmonth Beginning inventory at the start of January amounts to 50units. How many units should ABC Company produce in order to fulfill the expected sales of the company?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...

See similar textbooks

Similar questions

1. ABM Company forecasts sales in units for January to May as follows: January 2,500, February 2,700, March 3,500, April 3,700 and May 3,500 2. ABM Company would like to maintain 100 units in its ending inventory at the end of each month. 3. Beginning inventory at the start of January is S0 units. 4. How many units should ABM Company produce in order to fulfill the expected sales of the company? MONTH JAN FEB MARCH APRIL MAY TOTAL Projected Sales Target level of ending Inventories Total Less: beginning inventories Required production 5. assume selling price is PHP200/unit. 6, Sales for each month are expected to be collected as follows: • Month of sales : 20% A month after sales: 50% - 2 months after sales: 30%6 Note • On January Abm Company collected from previous month sales amounted to P100,000 MONTH JAN FEB MARCH APRIL MAY TOTAL Units Sales in Pesos Collection from current months sales Collection from previous months sales Collection from two months prior sales Total Collections…
MNO Company forecast sales in units for July to November as follows: Units JULY - 4000 aUGUST - 4300 SEPTEMBER - 4500 OCTOBER - 4700 NOVEMBER - 5000 MNO Company would like to maintain 200 units in its ending inventory at the end of each month starting July. Ending inventory for the month of June is 150 units. Beginning inventory at the start of January amounts to 100 units. 1. How many units should MNO Company produce for the month of July to fulfill the expected sales of the company?
1. ABM Company forecasts sales in units for January to May as follows: January 2,500, February 2,700, March 3,500, April 3,700 and May 3,500 2. ABM Company would like to maintain 100 units in its ending inventory at the end of each month. 3. Beginning inventory at the start of January is 50 units. 4. How many units should ABM Company produce in order to fulfill the expected sales of the company? MONTH FEB MARCH APRIL MAY TOTAL JAN Projected Sales Target level of ending inventories Total Less: beginning inventories Required production 5. assume selling price is PHP200/unit. 6. Sales for each month are expected to be collected as follows: • Month of sales : 20% A month after sales: 50% - 2 months after sales: 30% Note · On January Abm Company collected from previous month sales amounted to P100,000 MONTH FEB MARCH APRIL JAN MAY TOTAL Units Sales in Pesos Collection from current months sales Collection from previous months sales Collection from two months prior sales Total Collections…
Ecology Co. sells a biodegradable product called Dissol and has predicted the following sales for the first four months of the current year: Sales in units O 3,010 O 3,100 O 3,190 O 2,830 O 3,700 Jan. 2,500 Ending inventory for each month should be 15% of the next month's sales, and the December 31 inventory is consistent with that policy. How many units should be purchased in February? Question 8 Feb. 3,100 March. 3,700 April. 2,800 F6 F7 F8
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
1. ABM Company forecasts sales in units for January to May as follows: January 2,500, February 2,700, March 3,500, April 3,700 and May 3,500 2. ABM Company would like to maintain 100 units in its ending inventory at the end of each month. 3. Beginning inventory at the start of January is 50 units. 4. How many units should ABM Company produce in order to fulfill the expected sales of the company? MONTH MARCH APRIL MAY TOTAL JAN FEB Projected Sales Target level of ending inventories Total Less: beginning inventories Required production 5. assume selling price is PHP200/unit. 6. Sales for each month are expected to be collected as follows: • Month of sales: 20% A month after sales: 50% - 2 months after sales: 30% Note · On January Abm Company collected from previous month sales amounted to P100,000
Jarash, Inc. anticipates sales of 121758 units, 150 000 units, and 160.000 units in July. August, and September, respectively. Company policy is to maintain an ending finished-goods inventory equal to 40% of the following month's sales. On the basis of this information, how many units would the company plan to produce in July? 181758 units
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…
In October, November, and December, CVM Inc. expect to sell 50,000, 48,000, and 51,000 units respectively. The company's policy is to keep an end-of-month finished-goods inventory equal to 40% of the following month's sales. On the basis of this information, how many units would the company plan to produce in November?
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?
Wildhorse Ltd. estimates sales for the second quarter of 2022 will be as follows. Month April May June Units March 31 April 30 May 31 June 30 3,090 3,190 2,960 The target ending inventory of finished products is as follows. 2,440 2,620 2,600 2,900 Two units of materials are required for each unit of finished product. Production for July is estimated at 3,210 units to start building inventory for the fall sales period. Wildhorse's policy is to have an inventory of raw materials at the end of each month equal to 50% of the following month's production requirements. Raw materials are expected to cost $4 per unit throughout the period. Calculate the May raw materials purchases in dollars. Raw material purchases cost
Ecology Co. sells a biodegradable product called Dissol and has predicted the following sales for the first four months of the current year: Sales in units O 3,010 O 3,100 O 3,190 O 2,830 O 3,700 Ending inventory for each month should be 15% of the next month's sales, and the December 31 inventory is consistent with that policy. How many units should be purchased in February? F2 -0- (@ Jan. 2 2,500 F3 0+ Feb. 3 3,100 March. April. 3,700 F4 2,800 F5 F6 % 5 F7 6 2 F8 7