\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{4}{|c|}{ DM Purchases Budget } & \multicolumn{2}{|c|}{ April } & \multicolumn{2}{|c|}{ May } \\ \hline \multicolumn{2}{|c|}{ Budgeted Units to be Produced } & & & & 22,350 & & 25,730 \\ \hline \multicolumn{2}{|c|}{ Pounds of DM per Unit } & & & & 4 & & 4 \\ \hline \multicolumn{2}{|c|}{ Total Production Needs (Pounds) } & v & & & 89,400 & & 102,920 \\ \hline Add : & \multicolumn{3}{|c|}{ Target Ending DM Inventory (Pounds) } & & 20,584 & & 21,896 \\ \hline \multicolumn{2}{|c|}{ Total DM Inventory Needs (Pounds) } & v & & & 109,984 & & 124,816 \\ \hline Less : & Beginning DM Inventory (Po & ounds) & & & \begin{tabular}{l|l} 17,880 & i \end{tabular} & & 20,584 \\ \hline \multicolumn{3}{|c|}{ Budgeted Pounds of DM to be Purchased v} & & & 92,104 & & 104,232 \\ \hline \multicolumn{2}{|c|}{ DM Cost per Pound } & v & & $ & 0.40 & $ & 0.40 \\ \hline \multicolumn{3}{|c|}{ Total Budgeted Cost of DM Purchases } & & $ & 36,841.60 & $ & 41,692.80 \\ \hline \end{tabular} The accounting team at Kingbird Corp. plans to get a jump-start on its budget for the second quarter, since the first quarter is going well. Team members want to make sure to determine the cash effects of the company's sales as well as its biggest production-related cash expenditure, direct materials. The team has gathered the following information: 1. The budgeted selling price for the year is $4.00 per unit. Sales volumes are budgeted as follows for the last month of quarter 1 , for all of quarter 2 , and for part of quarter 3 . 2. Historically, 25% of Kingbird's sales are cash sales. Of the remaining credit sales, 40% are collected in the month of sale, while 56% are collected the following month. The remainder is deemed uncollectible. 3. Management sets its ending FG Inventory goal at 10% of the following month's sales volume. The accounting team expects this policy will be met at the beginning of the second quarter. 4. The target ending inventory for Kingbird's primary direct material is 20% of the following month's production needs, since it's not unusual for suppliers to stock out of this key resource. Each completed unit requires 4 pounds of DM at an expected cost of $0.40 per pound. 5. Kingbird pays for 35% of its purchases in the month of purchase and 65% the month after purchase. Total budgeted purchases in March are $16,300. For all quarterly budgets, report monthly amounts as well as the total for the quarter. \begin{tabular}{|c|c|} \hline June & Quarter \\ \hline 27,800 & 75,300 \\ \hline 2,350 & 2,350 \\ \hline 30,150 & 77,650 \\ \hline 2,780 & 2,200 \\ \hline 27,370 & 75,450 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{2}{|c|}{ June } & \multicolumn{2}{|c|}{ Quarter } \\ \hline & 27,370 & & 75,450 \\ \hline & 4 & & 4 \\ \hline & 109,480 & & 301,800 \\ \hline & 18,800 & & 18,800 \\ \hline & 128,280 & & 320,600 \\ \hline & 21,896 & & 17,880i \\ \hline & 106,384 & & 302,720 \\ \hline$ & 0.40 & $ & 0.40 \\ \hline$ & 42,553.60 & $ & 121,088.00 \\ \hline \end{tabular} Your answer is partially correct. Prepare Kingbird Corp.'s production budget and DM purchases budget for the second quarter. (Round DM cost per pound and total budgeted cost of DM purchases to 2 decimal places, e.g. 15.25.)