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,5002. 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?MONTHMARCHAPRILMAYTOTALJANFEBProjected SalesTarget level of endinginventoriesTotalLess: beginning inventoriesRequired production5. 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

Production budget is a schedule of number of units that should be produced to meet the targets of…

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 APRIL MARCH MAY TOTAL JAN FEB Projected Sales Target level of ending inventories Total Less: beginning inventories Required production

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 APRIL MARCH MAY TOTAL JAN FEB Projected Sales Target level of ending inventories Total Less: beginning inventories Required production

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

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…
(Production schedule) The projected sales, in units,for Einstein Inc. By month for the first four months were January 8,000 February 12,000 March 16,000 April 19,200 Inventory of finished goods on December 31 was 6,400 units. The company desired to have an ending inventory each month equal to one-half of next month's estimated sales. Determine the company's production requirements for each month of the first quarter
On January 1 the company had 330 widgets in finished good inventory. The company policy is to maintain an inventory of 15% of next montha sales. The company forecast the following sales: Jan. 2,200 Feb. 2,800 March 3,500 April 4,000 Determine the required production for January?
Garza Electronics expects to sell 500 units in January, 250 units in February, and 1,000 units in March. January's beginning inventory is 700 units. Expected sales for the whole year are 7,200 units. Garza has decided on a level monthly production schedule of 600 units (7,200 units/12 months = 600 units per month). What is the expected end- of-month inventory for January, February, and March?
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in units 240 280 300 240 Each month's ending Finished Goods Inventory should be 40% of the next month's sales. March 31 finished goods inventory is 96 units. A finished unit requires five pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 200 pounds of B. Each month's ending Raw Materials Inventory should be 30% of the following month's production needs. The budgeted production for May is: Select one: a. 288 units. b. 400 units. c. 232 units. d. 280 units. e. 168 units. Clear my choice
Furniture, Inc., estimates the following number of mattress sales for the first four months of 2024: Month Sales January 10,000 February 14,000 March 13,000 April 16,000 Finished goods inventory at the end of December is 3,000 units. Target ending finished goods inventory is 30% of the next month's sales. How many mattresses need to be produced in January 2024? A) 8,800 mattresses B) 11,200 mattresses C) 13,000 mattresses D) 14,200 mattresses
Croy Incorporated has the following projected sales for the next five months: Month April May June July August Sales in Units 3,530 3,815 4,530 4,120 3,990 Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct materials cost $2.80 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,673 pounds. Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of direct materials purchased for April and May. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Determine budgeted production for April, May, and June. Note: Do not round your intermediate calculations and round your final answers to the nearest whole number. June Budgeted Production (Units) April May
FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box Direct material required per 100 boxes: Paperboard ($0.30 per pound) Corrugating medium ($0.15 per pound). Direct labor required per 100 boxes ($18.00 per hour). Indirect material Indirect labor Utilities Property taxes Insurance Depreciation. Total C $12,150 95,850 31,500 21,000 16,000. 33,500 $210,000 Total 40 pounds 30 pounds 0.25 hour The following production-overhead costs are anticipated for the next year. The predetermined overhead rate is based on a production volume of 400,000 units for each type of box. Production overhead is applied on the basis of direct-labor hours. The following selling and administrative expenses are anticipated for the next year. Salaries and fringe benefits of sales personnel. Advertising $115,500 23,500…
Narai Co. has a desired ending inventory of 30% of the next months forecasted sales. In turn, their cost of goods sold is 60%, and their forecasted sales for the months of March, April, May, June, and July are as follows: $750,000, $880,000, $700,000, $800,000, and $900,000 respectively. Purchases for the months of February and March were $500,000 and $360,000 and their purchases are paid as follows: 10% during the month of the purchase 80% in the next month and the final 10% in the next month. Required: Prepare budget schedules for the months of April, May, and June for required purchases and also for disbursements for purchases.
Shadee Corporation expects to sell 590 sun shades in May and 360 in June. Each shades sells for $15. Shadee's beginning and ending finished goods inventories for May are 80 and 50 shades, respectively. Ending finished goods inventory for June will be 60 shades. It expects the following unit sales for the third quarter. July August September 545 450 430 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale. 40 percent is collected during the following month, and 8 percent is never collected. Required: Calculate Shadee's total cash receipts for August and September Note: Do not round your intermediate calculations. Round your answers to the nearest whole dollar. Total Cash Receipts August September
Shadee Corporation expects to sell 590 sun shades in May and 360 in June. Each shades sells for $15. Shadee's beginning and ending finished goods inventories for May are 60 and 45 shades, respectively. Ending finished goods inventory for June will be 55 shades. It expects the following unit sales for the third quarter: July August September 545 500 470 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale, 38 percent is collected during the following month, and 10 percent is never collected. Required: Calculate Shadee's total cash receipts for August and September. Note: Do not round your intermediate calculations. Round your answers to the nearest whole dollar. August September Total Cash Receipts
A June sales forecast projects that 8,000 units are going to be sold at a price of $11.00 per unit. The desired ending inventory of units is 12% higher than the beginning inventory of 900 units. Merchandise purchases for June are projected to include how many units? O 8,000 units O 8,108 units O 7,892 units O 9,008 units O 8,450 units