Answer 1 | ||
Ending inventory for December | 51,600 | gallons |
Ending inventory for January | 66,000 | gallons |
Ending inventory for February | 72,000 | gallons |
Beginning inventory for January | 51,600 | gallons |
Calculated as
Gallons required for units produced | |||||
Per Drum Required | Production | ||||
January | 6 | x | 43000 | = | 258000 |
February | 6 | x | 55000 | = | 330000 |
March | 6 | x | 60000 | = | 360000 |
Ending Inventory of Chemicals in gallons | |||||
December | 20% | x | 258,000 | = | 51,600 |
January | 20% | x | 330,000 | = | 66,000 |
February | 20% | x | 360,000 | = | 72,000 |
Answer 2 Direct Material Purchase Budget of Chemicals in Gallons
Patrick Inc. | ||
Direct Materials Purchase Budget-Chemicals in Gallons | ||
For the Months of January and February | ||
January | February | |
Production in units | 43000 | 55000 |
Gallons per unit | 6 | 6 |
Gallons for production | 258000 | 330000 |
Desired ending inventory | 66000 | 72000 |
Needed | 324000 | 402000 |
Less: Beginning inventory | 51600 | 66000 |
Purchases | 272400 | 336000 |
price per gallon | $ 2 | $ 2 |
Dollar Purchases | $ 544,800 | $ 672,000 |
Answer 3 | ||
Ending inventory for December | 8600 | Units |
Ending inventory for January | 11000 | Units |
Ending inventory for February | 12000 | Units |
Calculated as
Ending Inventory of Drums | |||||
December | 20% | x | 43000 | = | 8600 |
January | 20% | x | 55000 | = | 11000 |
February | 20% | x | 60000 | = | 12000 |
Answer 4
Patrick Inc. | ||
Direct Materials Purchase Budget-Drums | ||
For the Months of January and February | ||
January | February | |
Production in units | 43000 | 55000 |
Drums per unit | 1 | 1 |
Gallons for production | 43000 | 55000 |
Desired ending inventory | 11000 | 12000 |
Needed | 54000 | 67000 |
Less: Beginning inventory | 8600 | 11000 |
Purchases | 45400 | 56000 |
price per gallon | $ 1.60 | $ 1.60 |
Dollar Purchases | $ 72,640 | $ 89,600 |
Feel free to ask any clarification, if required. Kindly
provide feedback by thumbs up, if satisfied. It will be highly
appreciated.
Thank you.
please answer all Preparing a Diect Materials Prchases Budget Patrick Inc, makes industral solvents sold in...
Preparing a Direct Materials Purchases Budget Patrick Inc. makes industrial solvents sold in 5-gallon drum containers. Planned production in units for the first 3 months of the coming year is: January 45,000 February 50,000 March 60,000 Each drum requires 6 gallons of chemicals and one plastic drum container. Company policy requires that ending inventories of raw materials for each month be 20% of the next month's production needs. That policy was met for the ending inventory of December in the...
Part 1 Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following units to be sold in the first 3 months of the coming year: January 41,000 February 38,000 March 50,000 The average price for a drum is $43. Required: Prepare a sales budget for the first 3 months of the coming year, showing units and sales revenue by month and in total for the quarter. Do not include a multiplication symbol as part of your answer. Patrick...
Preparing a Production Budget Patrick Inc, makes industrial solvents. In the first months of the coming year Patrick expects the following unit sales: January 41.000 February 38.000 March 50.000 April $1,000 Patrick's policy is to have 23% of next months sales in ending inventory On January 1it is expected that there will be 4.550 drums April Patride's policy is to have 23 of next month's sales in ending inventory. On January 1, it is expected that there will be 4,550...
Preparing a Sales Budget Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following units to be sold in the first 3 months of the coming year: 41,000 January February 38,000 50,000 March The average price for a drum is $42. Required: Prepare a sales budget for the first 3 months of the coming year, showing units and sales revenue by month and in total for the quarter. Do not include a multiplication symbol as part of your...
Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales: January 41,000 February 38,000 March 50,000 April 51,000 Patrick's policy is to have 20% of next month's sales in ending inventory. On January 1, it is expected that there will be 4,700 drums of solvent on hand. Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should be produced each month...
Preparing a Direct Labor Budget Patrick Inc. makes industrial solvents. Planned production in units for the first three months of the coming year is: January 45,000 February 55,000 March 65,000 Each drum of industrial solvent takes 0.3 direct labor hours. The average wage is $17.50 per hour. Required: Prepare a direct labor budget for the months of January, February, and March, as well as the total for the first quarter. Do not include a multiplication symbol as part of your...
Production Budget and Direct Materials Purchases Budgets Peanut Land Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget for the first four months of the year is as follows: Unit Sales Dollar Sales ($) January 40,000 72,000 February 45,000 81,000 March 60,000 108,000 April 42,000 75,600 Company policy requires that ending inventories for each month be 20% of next month's sales. At the beginning of January, the inventory of peanut butter is...
Production Budget and Direct Materials Purchases Budgets Peanut-Fresh Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget for the first four months of the year is as follows: Unit Sales Dollar Sales ($) January 48,000 100,800 February 46,000 96,600 March 55,000 121,000 April 58,000 125,200 Company policy requires that ending inventories for each month be 20% of next month's sales. At the beginning of January, the inventory of peanut butter is 14,500...
reparing a Direct Labor Budget atrick Inc. makes industrial solvents. Planned production in units for the first three months of the coming year is: Banuary 45,000 February 50,000 March 60,000 Each drum of industrial solvent takes 0.3 direct labor hours. The average wWage is $17.80 per hour Required Prepare a direct labor budget for the months of January, February, and March, as well as the total for the first quarter. Do not include a mutiplication symbol as part of your...
Direct Materials Purchases Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick’s best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 43,000 $8.85 6,300 $17.20 February 60,000 $8.85 7,800 $17.20...