In: Accounting
Preparing a Direct Materials Purchases Budget
Tulum Inc. makes a Mexican chocolate mix sold in 4-pound boxes. Planned production in units for the first 3 months of the coming year is:
| January | 24,700 | 
| February | 22,000 | 
| March | 30,200 | 
Each box requires 4.2 pounds of chocolate mix and one box. Company policy requires that ending inventories of raw materials for each month be 10% of the next month’s production needs. That policy was met for the ending inventory of December in the prior year. The cost of 1 pound of chocolate mix is $1.50. The cost of one box is $0.10.
Required:
1. Calculate the ending inventory of chocolate mix in pounds for December of the prior year and for January and February. What is the beginning inventory of chocolate mix for January?
| Ending inventory for December | fill in the blank 1791c200405a046_1 pounds | 
| Ending inventory for January | fill in the blank 1791c200405a046_2 pounds | 
| Ending inventory for February | fill in the blank 1791c200405a046_3 pounds | 
| Beginning inventory for January | fill in the blank 1791c200405a046_4 pounds | 
2. Prepare a direct materials purchases budget for chocolate mix for the months of January and February.
| Tulum Inc. | ||
| Direct Materials Purchases Budget - Chocolate mix in Pounds: | ||
| For the Months of January and February | ||
| January | February | |
| Production in units | fill in the blank f5189304407200e_1 | fill in the blank f5189304407200e_2 | 
| Pounds per unit | fill in the blank f5189304407200e_3 | fill in the blank f5189304407200e_4 | 
| Pounds for production | fill in the blank f5189304407200e_5 | fill in the blank f5189304407200e_6 | 
| Desired ending inventory | fill in the blank f5189304407200e_7 | fill in the blank f5189304407200e_8 | 
| Needed | fill in the blank f5189304407200e_9 | fill in the blank f5189304407200e_10 | 
| Less: Beginning inventory | fill in the blank f5189304407200e_11 | fill in the blank f5189304407200e_12 | 
| Purchases | fill in the blank f5189304407200e_13 | fill in the blank f5189304407200e_14 | 
| Price per pounds | $fill in the blank f5189304407200e_15 | $fill in the blank f5189304407200e_16 | 
| Dollar purchases | $fill in the blank f5189304407200e_17 | $fill in the blank f5189304407200e_18 | 
3. Calculate the ending inventory of boxes for December of the prior year and for January and February. Round your answers to the nearest whole unit.
| Ending inventory for December | fill in the blank feb385003fcbfb9_1 units | 
| Ending inventory for January | fill in the blank feb385003fcbfb9_2 units | 
| Ending inventory for February | fill in the blank feb385003fcbfb9_3 units | 
4. Prepare a direct materials purchases budget for boxes for the months of January and February.
| Tulum Inc. | ||
| Direct Materials Purchases Budget - Boxes | ||
| For the Months of January and February | ||
| January | February | |
| Production in units | fill in the blank 1d53d301c01306a_1 | fill in the blank 1d53d301c01306a_2 | 
| Boxes per unit | fill in the blank 1d53d301c01306a_3 | fill in the blank 1d53d301c01306a_4 | 
| Boxes for production | fill in the blank 1d53d301c01306a_5 | fill in the blank 1d53d301c01306a_6 | 
| Desired ending inventory | fill in the blank 1d53d301c01306a_7 | fill in the blank 1d53d301c01306a_8 | 
| Needed | fill in the blank 1d53d301c01306a_9 | fill in the blank 1d53d301c01306a_10 | 
| Less: Beginning inventory | fill in the blank 1d53d301c01306a_11 | fill in the blank 1d53d301c01306a_12 | 
| Purchases | fill in the blank 1d53d301c01306a_13 | fill in the blank 1d53d301c01306a_14 | 
| Price per box | $fill in the blank 1d53d301c01306a_15 | $fill in the blank 1d53d301c01306a_16 | 
| Dollar purchases | $fill in the blank 1d53d301c01306a_17 | $fill in the blank 1d53d301c01306a_18 | 
1.
| Particulars | Dec Last Year | Jan | Feb | 
| Ending Inventory | 10374 | 9240 | 12600 | 
| Beginning Inventory | 10374 | 
2
| Direct Material Purchase Budget - Chocolate Mix | ||||
| Particulars | Dec Last Year | Jan | Feb | Mar | 
| Production in Units | 0 | 24700 | 22000 | 30000 | 
| Pounds per Unit | 4.2 | 4.2 | 4.2 | 4.2 | 
| Pounds for Production | 0 | 103740 | 92400 | 126000 | 
| Desired Ending inventory needed | 10374 | 9240 | 12600 | 0 | 
| Less Beginning Inventory | 0 | 10374 | 9240 | 12600 | 
| Purchases | 10374 | 102606 | 95760 | 113400 | 
| Price in Pounds | $1.50 | $1.50 | $1.50 | $1.50 | 
| Dollars Purchase | $15,561 | $1,53,909 | $1,43,640 | $1,70,100 | 
3.
| Particulars | Dec Last Year | Jan | Feb | 
| Ending Inventory | 2470 | 2200 | 3000 | 
4.
| Direct Material Purchase Budget - Box | ||||
| Particulars | Dec Last Year | Jan | Feb | Mar | 
| Production in Units | 0 | 24700 | 22000 | 30000 | 
| Boxes per unit | 1 | 1 | 1 | 1 | 
| Boxes for production | 0 | 24700 | 22000 | 30000 | 
| Desired Ending inventory needed | 2470 | 2200 | 3000 | 0 | 
| Less Beginning Inventory | 0 | 2470 | 2200 | 3000 | 
| Purchases | 2470 | 24430 | 22800 | 27000 | 
| Price per box | $0.10 | $0.10 | $0.10 | $0.10 | 
| Dollars Purchase | $247 | $2,443 | $2,280 | $2,700 |