Question
CatoIndustrial has estimated that production for the next five quarters will be: Production Information 1st quarter, 202045,000units 2nd quarter, 202040,800units 3rd quarter, 202049,200units 4th quarter,
CatoIndustrial has estimated that production for the next five quarters will be:
Production Information
1st quarter, 202045,000units
2nd quarter, 202040,800units
3rd quarter, 202049,200units
4th quarter, 202038,400units
1st quarter, 202146,600units
Finished units of production require6pounds of raw material per unit. The raw material cost is $7per pound. There is $283,500of raw material on hand at the beginning of the first quarter, 2020.Catodesires to have15percent of next quarter's material requirements on hand at the end of each quarter.
Prepare quarterly direct materials purchases budgets forCatoIndustrial for 2020.
CatoIndustrial
Direct Materials Purchases Budget
For the Year Ending December 31, 2020
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Year
select an opening direct materials purchases budget item
Units to be produced
Cost of raw material per unit
Desired ending inventory of raw material
Total material needed
Beginning inventory of raw material
Required raw material purchases
Cost of raw material needed for production
enter a number of units
enter a number of units
enter a number of units
enter a number of units
enter a number of units
selectanitem
Units to be produced
Cost of raw material per unit
Desired ending inventory of raw material
Total material needed
Beginning inventory of raw material
Required raw material purchases
Cost of raw material needed for production
$
enter a dollar amount
$
enter a dollar amount
$
enter a dollar amount
$
enter a dollar amount
$
enter a dollar amount
selectasummarizinglineforthefirstpart
Units to be produced
Cost of raw material per unit
Desired ending inventory of raw material
Total material needed
Beginning inventory of raw material
Required raw material purchases
Cost of raw material needed for production
enteratotaldollaramountforthefirstpart
enteratotaldollaramountforthefirstpart
enteratotaldollaramountforthefirstpart
enteratotaldollaramountforthefirstpart
enteratotaldollaramountforthefirstpart
selectbetweenadditionanddeduction
Add
Less
:
selectanitem
Units to be produced
Cost of raw material per unit
Desired ending inventory of raw material
Total material needed
Beginning inventory of raw material
Required raw material purchases
Cost of raw material needed for production
enter a dollar amount
enter a dollar amount
enter a dollar amount
enter a dollar amount
enter a dollar amount
selectasummarizinglineforthesecondpart
Units to be produced
Cost of raw material per unit
Desired ending inventory of raw material
Total material needed
Beginning inventory of raw material
Required raw material purchases
Cost of raw material needed for production
enteratotaldollaramountforthesecondpart
enteratotaldollaramountforthesecondpart
enteratotaldollaramountforthesecondpart
enteratotaldollaramountforthesecondpart
enteratotaldollaramountforthesecondpart
selectbetweenadditionanddeduction
Add
Less
:
selectanitem
Units to be produced
Cost of raw material per unit
Desired ending inventory of raw material
Total material needed
Beginning inventory of raw material
Required raw material purchases
Cost of raw material needed for production
enteradollaramount
enteradollaramount
enteradollaramount
enteradollaramount
enteradollaramount
select a closing direct materials purchases budget item
Units to be produced
Cost of raw material per unit
Desired ending inventory of raw material
Total material needed
Beginning inventory of raw material
Required raw material purchases
Cost of raw material needed for production
$
enter a total amount for the direct materials purchases budget
$
enter a total amount for the direct materials purchases budget
$
enter a total amount for the direct materials purchases budget
$
enter a total amount for the direct materials purchases budget
$
enter a total amount for the direct materials purchases budget
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started