Question

In: Accounting

ABC Inc. has compiled the following data in order to put together their first quarter operating...

ABC Inc. has compiled the following data in order to put together their first quarter operating budget for 20XX:

January

February

March

April

Sales (units)

            50,000

            55,000

            40,000

            30,000

Additional information:

ABC sells each unit for $200.

Company policy is to have 30% of next month’s sales (in units) in ending finished goods inventory. This policy was met in December.

Company policy is to have 25% of next month’s production needs in ending raw materials inventory. The production needs for April is 120,000. This policy was met in December.

It takes four pounds of material to produce each unit and the cost is $5.00/pound.

Required:

1. Prepare a sales budget for the January, February and March and for the first quarter in total.

2. Prepare a production budget for January, February and March and for the first quarter in total.

3. Prepare a direct materials purchases budget for January, February and March and for the first quarter in total.

Solutions

Expert Solution

Sales Budget
January February March Quarter
Budgeted sales in units 50000 55000 40000 145000
Sales price $200 $200 $200 $200
Total sales $10,000,000 $11,000,000 $8,000,000 $29,000,000
Production Budget
January February March Quarter April
Budgeted sales in units 50000 55000 40000 145000 30000
Add Desired Finished Goods Inventory (30%*next month budgeted sales) 16500 12000 9000 9000
Total Needs 66500 67000 49000 154000
Less Beginning Inventory 15000 16500 12000 15000
(50000*30%)
Required Production 51500 50500 37000 139000
Purchase Budget January February March Quarter April
Required production (units) 51500 50500 37000 139000
Raw materials required to produce one unit 4 4 4 4
Production needs (pounds) P 206000 202000 148000 556000 120000
Add desired ending inventory of raw materials (pounds) (P*25%) 50500 37000 30000 30000
Total needs (pounds) 256500 239000 178000 586000
Less beginning inventory of raw materials (pounds) 59750 50500 37000 59750
Raw materials to be purchased 196750 188500 141000 526250
Cost of raw materials per pound $5 $5 $5 $5
Cost of raw materials to be purchased $983,750 $942,500 $705,000 $2,631,250
If any doubt please comment

Related Solutions

ABC Inc. has compiled the following data in order to put together their first quarter operating...
ABC Inc. has compiled the following data in order to put together their first quarter operating budget for 20XX: January February March April Sales (units)             50,000             55,000             40,000             30,000 Additional information: ABC sells each unit for $200. Company policy is to have 30% of next month’s sales (in units) in ending finished goods inventory. This policy was met in December. Company policy is to have 25% of next month’s production needs in ending raw materials inventory....
ABC Inc. has compiled the following data in order to put together their first quarter operating...
ABC Inc. has compiled the following data in order to put together their first quarter operating budget for 20XX: January February March April Sales (units)             50,000             55,000             40,000             30,000 Additional information: ABC sells each unit for $200. Company policy is to have 30% of next month’s sales (in units) in ending finished goods inventory. This policy was met in December. Company policy is to have 25% of next month’s production needs in ending raw materials inventory....
Problem 9-4 Karam Inc. has compiled the following data in order to put together their first...
Problem 9-4 Karam Inc. has compiled the following data in order to put together their first quarter operating budget for 2011: January February March April Sales (units) 35,000 31,000 38,000 29,000 Each unit requires three hours of direct labor. Additional information: Karam sells each unit for $95. Company policy is to have 30 percent of next month's sales (in units) in ending finished goods inventory. Company policy is to have 40 percent of next month's production needs in ending raw...
In the case, Jamie put together a total cost for the first order of specialty candles...
In the case, Jamie put together a total cost for the first order of specialty candles by adding up all of the direct material, direct labor, and allocated MOH; in other words, he used absorption costing. This is the method commonly discussed in textbooks because it is also the method required by GAAP for financial reporting purposes. However, there are several other methods for allocating costs to a product or order: Variable Manufacturing Cost. This method of tracking costs includes...
Company A is preparing its budget for the third quarter. The following information has been compiled:...
Company A is preparing its budget for the third quarter. The following information has been compiled: Cash collections $50,000 $40,000 $48,000 Cash payments Purchases of inventory 31,000 22,000 18,000 Operating expenses 12,000 9,000 11,600 Capital expenditures 13,000 25,000 0 The cash balance at the end of the second quarter is projected to be $4,000. The company is required to maintain cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls....
Chubbs Inc.’s manufacturing overhead budget for the first quarter of 2020 contained the following data. Variable...
Chubbs Inc.’s manufacturing overhead budget for the first quarter of 2020 contained the following data. Variable Costs Fixed Costs Indirect materials $11,100 Supervisory salaries $36,700 Indirect labor 11,000 Depreciation 6,100 Utilities 7,700 Property taxes and insurance 7,400 Maintenance 5,500 Maintenance 4,900 Actual variable costs were indirect materials $14,800, indirect labor $9,200, utilities $9,300, and maintenance $5,200. Actual fixed costs equaled budgeted costs except for property taxes and insurance, which were $8,400. The actual activity level equaled the budgeted level. All...
ABC Inc. has projected sales and production in units for the second quarter of the coming...
ABC Inc. has projected sales and production in units for the second quarter of the coming year as follows: April May June sales....... 50,000 40,000 60,000 production..... 60,000 50,000 50,000 cash related production costs are budgeted at $5 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $100,000 per month. The accounts payable balance on March 31...
Cummings Inc., has been accumulating operating data in order to prepare an annual budget.  They have determined...
Cummings Inc., has been accumulating operating data in order to prepare an annual budget.  They have determined that a minimum cash balance of $150,000 is required. Any required borrowings take place in increments of $1,000 with annual interest of 8%.  Repayment of borrowed funds is also made in increments of $1,000. Assume that borrowings are made on the first day of the month in which the cash is required, and the repayments are made on the last day of a month in...
McMillan Company uses the periodic inventory system. It has compiled the following information in order to...
McMillan Company uses the periodic inventory system. It has compiled the following information in order to prepare the financial statements at December 31, 2014: Gross sales during 2014 $2,000,000 Sales returns and allowances during 2014 50,000 Begining inventory, January 1, 2014 100,000 Ending inventory, December 31, 2014 120,000 Purchases during 2014 750,000 Required: Calculate each of the following: A. Cost of goods available for sale B. Cost of goods sold C. Gross profit
The following is the sales budget for Tesoro Azul, Inc., for the first quarter of 2016:...
The following is the sales budget for Tesoro Azul, Inc., for the first quarter of 2016:    January February March Sales budget $142,000 $159,000 $174,000    Credit sales are collected as follows:    70 percent in the month of the sale 25 percent in the month after the sale 5 percent in the second month after the sale    The accounts receivable balance at the end of the previous quarter was $70,150 ($61,200 of which was uncollected December sales).   ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT