DeWitt Industries has adopted the following production budget for the first 4 months of 2017.
Month |
Units |
Month |
Units |
|||
---|---|---|---|---|---|---|
January | 10,430 | March | 5,130 | |||
February | 8,210 | April | 4,470 |
Each unit requires 3 pounds of raw materials costing $3 per pound.
On December 31, 2016, the ending raw materials inventory was 9,400
pounds. Management wants to have a raw materials inventory at the
end of the month equal to 20% of next month’s production
requirements.
Prepare a direct materials purchases budget by month for the first
quarter.
Continue | Eliminate | Net Income Increase (Decrease) |
|||||
---|---|---|---|---|---|---|---|
Sales | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | ||||
Variable costs | |||||||
Cost of goods sold | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
Operating expenses | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
Total variable | enter a total of the two previous amounts | enter a total of the two previous amounts | enter a total of the two previous amounts | ||||
Contribution margin | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
Fixed costs | |||||||
Cost of goods sold | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
Operating expenses | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
Total fixed | enter a total of the two previous amounts | enter a total of the two previous amounts | enter a total of the two previous amounts | ||||
Net income (loss) | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount |
Veronica is select an optionincorrectcorrect correctincorrect |
Raw Material Budget | |||||
January | February | March | April | Total | |
Budgeted Production (Units) | 10430 | 8210 | 5130 | 4470 | |
Raw Material per unit (Pounds) | 3 | 3 | 3 | 3 | |
Material for Production | 31290 | 24630 | 15390 | 13410 | |
Add : Desired Ending Inventory | 4926 | 3078 | 2682 | ||
Material Required | 36216 | 27708 | 18072 | ||
Less : Beginning Inventory | 9400 | 4926 | 3078 | ||
Material to be purchased (Pounds) | 26816 | 22782 | 14994 | 64592 | |
Cost per Pound | $ 3.00 | $ 3.00 | $ 3.00 | ||
Purchase cost | $ 80,448 | $ 68,346 | $ 44,982 | $ 193,776 |
Ending Inventory is 20% of next months production needs
January 20% of 24630, February 20% of 15390 and March 20% of
13410
DeWitt Industries has adopted the following production budget for the first 4 months of 2017. Month...
DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units 5,470 January 10,350 March February 8,230 April 4,210 Each unit requires 4 pounds of raw materials costing $2 per pound. On December 31, 2019, the ending raw materials inventory was 8,280 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month's production requirements. Prepare a direct materials purchases budget by...
DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units 5,490 10,470 March January 8,260 April 4,450 February Each unit requires 5 pounds of raw materials costing $2 per pound. On December 31, 2019, the ending raw materials inventory was 10,470 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month's production requirements. Prepare a direct materials purchases budget by...
DeWitt Industries has adopted the following production budget for the first 4 months of 2017. Month Units Month Units January 10,120 March 5,480 February 8,460 April 4,370 Each unit requires 5 pounds of raw materials costing $3 per pound. On December 31, 2016, the ending raw materials inventory was 9,240 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month’s production requirements. Prepare a direct materials purchases budget by...
DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units March 10,270 5,390 January 8,270 April February 4,290 Each unit requires 3 pounds of raw materials costing $3 per pound. On December 31, 2019, the ending raw materials inventory was 6,162 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month's production requirements. Prepare a direct materials purchases budget by...
DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units January February 10,440 March 8,240 April 5,190 4,120 Each unit requires 3 pounds of raw materials costing $2 per pound. On December 31, 2019, the ending raw materials inventory was 6,264 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month's production requirements. Prepare a direct materials purchases budget by...
DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units January 10,230 March 5,410 February 8,150 April 4,500 Each unit requires 3 pounds of raw materials costing $2 per pound. On December 31, 2019, the ending raw materials inventory was 6,138 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month’s production requirements. Prepare a direct materials purchases budget by...
DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units 10,340 March 5,440 February 8,480 April 4230 Each unit requires 3 pounds of raw materials costing $4 per pound On December 31, 2019, the ending raw materials imventory was 6,204 pounds Management wants to have a raw materials inventory at the end of the month equal to 20% of next month's production requirements Prepare a direct materials purchases budget by month...
Exercise 22-05 DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units January 10,470 March 5,440 February 8,470 April 4,340 Each unit requires 4 pounds of raw materials costing $4 per pound. On December 31, 2019, the ending raw materials inventory was 8,376 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month’s production requirements. Prepare a direct materials purchases...
Exercise 21-5 DeWitt Industries has adopted the following production budget for the first 4 months of 2017. Month Units January February Units Month 10,100 March 8,100 April 5,100 4,100 Each unit requires 3 pounds of raw materials costing $2 per pound. On December 31, 2016, the ending raw materials inventory was 9,100 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month's production requirements. Prepare a direct materials purchases...
Exercise 22-05 DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Units Month 10,130 March 5,250 January April February 8,110 4,260 Each unit requires 5 pounds of raw materials costing $4 per pound. On December 31, 2019, the ending raw materials inventory was 10,130 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month's production requirements. Prepare a direct materials purchases...