Transitioning from employee to manager has been exciting for Jason! He enjoys having the responsibility and authority to make decisions, and it is rewarding to join the management team, sharing insights to make better decisions.
One of his first responsibilities is to address the DM purchases budget. The company has a strong relationship with its current supplier, but the quality of the supplier's DM has declined. Knowing this, Jason has already reached out to
a different vendor to see what kind of a deal it might offer. The DM information for Jason's division and for each vendor just described is as follows.
\begin{itemize}
\item DM on hand as of July 1 slightly exceeds expectations at 1,400 linear board feet.
\item Each unit requires 4 linear board feet; Jason is most comfortable if the company has 20% of the following month's production needs on hand.
\item The cost per linear foot is $5.50 with the current supplier; it's $6.00 with the new vendor.
\item Planned production for July is 1,700 units; for August is 2,400 units; for September is 2,000 units; and for October is 1,700 units.
\item The A/P balance related to June DM purchases is $34,125 on July 1.
\end{itemize}
Prepare the DM purchases budget for the third quarter, assuming Jason stays with the current supplier. Specify amounts for each month and for the quarter overall. (Round DM cost per linear foot to 2 decimal places, eg. 15.25.)
Budgeted Units to be Produced
Linear Feet of DM per Unit
Total Production Needs (Linear Feet)
Add \quad Target Ending DM Inventory (Linear Feet)
Total DM Inventory Needs (Linear Feet)
Less: Beginning DM Inventory (Linear Feet)
Budgeted DM Quantity to be Purchased (Linear Feet)
DM Cost per Linear Foot
Total Budgeted Cost of DM Purchases
July
August
September
$
$
$
$
$
$
$
$
Quarter
