Preparing a Direct Materials Purchases Budget Patrick Inc. makes industrial solvents sold in 5-gallon drums. Planned production in units for the first 3 months of the coming year is: Month Units January 42,600 February 39,800 March 48,000 Each drum requires 5.5 gallons of chemicals and one plastic drum. 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 prior year. The cost of one gallon of chemicals is $1.90. The cost of one drum is $1.50.

table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl23 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; background:white; mso-pattern:black none;} .xl31 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0;} .xl43 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none;} .xl44 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; background:white; mso-pattern:black none;} .xl47 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; background:#D9E1F2; mso-pattern:black none;} .xl49 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:#D9E1F2; mso-pattern:black none;} .xl50 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; vertical-align:top; background:#D9E1F2; mso-pattern:black none; white-space:normal;} .xl51 {color:#575757; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; background:#D9E1F2; mso-pattern:black none; white-space:normal;} .xl52 {color:#575757; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; vertical-align:top; background:#D9E1F2; mso-pattern:black none; white-space:normal;} .xl53 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:#D9E1F2; mso-pattern:black none;} .xl54 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:top; background:#D9E1F2; mso-pattern:black none; white-space:normal;} .xl55 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:top; background:#D9E1F2; mso-pattern:black none;} .xl56 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; background:#D9E1F2; mso-pattern:black none;} .xl57 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; vertical-align:top; background:#D9E1F2; mso-pattern:black none; white-space:normal;} .xl59 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; background:#D9E1F2; mso-pattern:black none; white-space:normal;} .xl60 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; vertical-align:top; background:#D9E1F2; mso-pattern:black none; white-space:normal;} .xl62 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; vertical-align:middle; background:#D9E1F2; mso-pattern:black none; white-space:normal;} .xl63 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:#D9E1F2; mso-pattern:black none;} .xl64 {color:#575757; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; vertical-align:middle; background:#D9E1F2; mso-pattern:black none; white-space:normal;} .xl65 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; white-space:normal;} .xl116 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl117 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#D9E1F2; mso-pattern:black none;} .xl118 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:#D9E1F2; mso-pattern:black none; white-space:normal;}

Preparing a Direct Materials Purchases Budget
Patrick Inc. makes industrial solvents sold in 5-gallon drums. Planned production in units for the first 3 months of the coming year is:
DATA
January	42,600
February	39,800
March	48,000
Direct materials needed per unit:
Chemicals (in gallons)	5.5
Plastic drums	1
Direct materials cost:
Chemicals (per gallon)	$1.90
Plastic drums (per unit)	$1.50
Ending inventory requirements	20%	of next month's production needs of raw materials
That ending inventory policy was met for the ending inventory of December in the prior year.

the nearest whole gallon. your answer. Patrick Inc. Patrick Inc. Direct Materials Purchases Budget - Chemicals in Gallons For the Months of January and February 4. Prepare a direct materials purchases budget for drums for the months of January and February. Do not round intermediate calculations. Round dollar purchases to the nearest dollar. Round price per drum to the nearest cent. Round all the other values to the nearest whole unit. Do not include a multiplication symbol as part of your