Prepare Bates & Hill's direct materials purchases budget for the first quarter. (Enter price per pound to 2 decimal places, e.g. 52.75.)
Marcy Jones, Bates & Hill Fabricators' purchasing manager, has just received the company's production budget for the first quarter.
January
|
February
|
March
|
Quarter
|
||||||
---|---|---|---|---|---|---|---|---|---|
Budgeted unit sales
|
25,000 | 28,000 | 32,000 | 85,000 | |||||
+ Budgeted ending inventory
|
5,600 |
|
6,400 |
|
6,800 |
|
6,800 | ||
Total units required
|
30,600 | 34,400 | 38,800 | 91,800 | |||||
- Beginning inventory
|
3,200 | 5,600 | 6,400 | 3,200 | |||||
Budgeted production
|
27,400 |
|
28,800 |
|
32,400 |
|
88,600 |
Budgeted sales for April is 34,000 units and for May is 26,000 units.
Each brick requires 6 pounds of clay, and Marcy expects to pay $1.50 per pound of clay in the coming year. Company policy requires an ending direct materials inventory each month that will meet 10% of the following month's production needs. Company policy requires an ending finished goods inventory each month that will meet 20% of the following month’s sales volume. Marcy expects to have 15,000 pounds of clay at a cost of $22,500 in inventory at the beginning of the year.
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- Please help me with correct answer thankuarrow_forwardWeather Change, Co. reports the following information from its sales budget: Budgeted sales (units) July 18,000 August 19,200 September 20,400 October 21,800 November 24,100 December 25,900 The budgeted sales price per unit is $72. The company desires each month’s ending finished goods inventory to equal 15% of the following month’s sales, and the company desires each month’s ending raw materials inventory to equal 25% of the following month’s budgeted production needs. Each unit of output requires 8 grams of materials and each gram of material costs $2.00. The firm budgets that each unit will take 2.5 hours to complete and the labor rate is $14.00 per DL hour. Variable factory overhead is estimated to be $3.00 per DL hour. There is no fixed factory OH. The budgeted variable selling, general, and administrative expenses are $2.00 per unit sold and the budgeted fixed selling, general, and administrative expenses are $89,450 total per…arrow_forwardHow do I prepare the selling and administrative expense budget for the quarter ended March 31, 20X1?arrow_forward
- Atlantic Surf manufactures surfboards. The company's budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods inventory equal (in units) to 40% of the next month's unit sales. As of June 30, the company has 1,760 finished surfboards in inventory. Budgeted sales units July 4,400 August 5,500 September 3,300 Prepare the production budget for the months of July and August. ATLANTIC SURF Production Budget Budgeted sales units Add: Desired ending inventory Desired ending inventory units Total required units Units to be produced July 0 August 0arrow_forwardAtlantic Surf manufactures surfboards. The company’s budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods inventory equal (in units) to 50% of the next month’s unit sales. As of June 30, the company has 1,950 finished surfboards in inventory. July August September Budgeted sales units 3,900 7,400 4,500 Prepare the production budget for the months of July and August.arrow_forwardQuetzaltenango Candle Inc. projected sales of 41,000 candles for March. The estimated March 1 inventory is 2,100 units, and the desired March 31 inventory is 5,000 units. Prepare a production budget report in units for Quetzaltenango Candle Inc. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Quetzaltenango Candle Inc. Production Budget For the Month Ending March 31 Line Item Description Units Sales 41,000 Estimated beginning inventory, March 1 2,100 X Total units available 43,100 X Expected units to be sold x -5,000 X Total units to be produced in March 38,100 Xarrow_forward
- Down Under Products' sales budget for the next four months is as follows: April May June July Unit Sales 76,000 85,000 116,000 93,000 The company wants its ending inventory levels to equal 15% of the following month's unit sales. The inventory at the end of March was 11,400 units. Required: Prepare a production budget, by month and in total, for the second quarter. Budgeted unit sales Total needs Required production in units Down Under Products, Limited Production Budget April 77,350 77,350 77,350 May 89,650 89,650 89,650 June 112,550 112,550 112,550 Quarter 0 0arrow_forwardAtlantic Surf manufactures surfboards. The company's budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods Inventory equal (in units) to 40% of the next month's unit sales. As of June 30, the company has 1,600 finished surfboards In Inventory. Budgeted sales units July 4,000 August 5,500 September 4,200 Prepare the production budget for the months of July and August. ATLANTIC SURF Production Budget Desired ending inventory units Total required units Units to be produced July Augustarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education