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

Part 1
Sales Budget
January February March Total
Sales (units) 50000 55000 40000 145000
Price per unit $200.00 $200.00 $200.00 $600.00
Sales (Amount) $1,00,00,000.00 $1,10,00,000.00 $80,00,000.00 $2,90,00,000.00
Part 2
Production Budget
January February March Total
Sales (units) 50000 55000 40000 145000
ADD : Closing Stock 16500 12000 9000 37500
LESS : Opening Stock 15000 16500 12000 43500
Production Budget 51500 50500 37000 139000
Part 3
Direct Material Purchase Budget
January February March Total
Production Budget 51500 50500 37000 139000
Material/unit 4 4 4 4
Raw material required 206000 202000 148000 556000
Add : Closing Stock 50500 37000 30000 117500
LESS : Opening Stock 51500 50500 37000 139000
RM Required 205000 188500 141000 534500
Cost/unit $5.00 $5.00 $5.00 $5.00
RM Purchased Budget $10,25,000.00 $9,42,500.00 $7,05,000.00 $26,72,500.00

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