JUST NEED THE COST OF GOODS SOLD BUDGET FOR QUARTER

Polar Bear Sluggers manufactures wood baseball bats, Polar Bear Sluggers has two primary products, youth bats and adult bats. Polar Bear Sluegers sells all the bats to sporting goods stores and all sales are on accounts. The youth bats sell for $45.00 and the adult bats sell for $85.00. The highest sales volume is in the first three months of the year as retailers prepare for baseball starting in the spring. Polar Bear Slugeers balance sheet for December 31,2020 is as follows: The following information is also included: a. Budgeted sales are 1,460 youth bats and 2,970 adult bats. b. Finished Goods imventory on December 31 consists of 210 youth bats at $8.00 each and 680 adults bats at $13.00 each. c. Desired ending Finished Goods inventory is 180 youth bats and 300 adult bats. FFo inventory costing method is used. d. Oirect matenals cost is $13,00 per youth bat and $4,00 per adult bat. e. Desired ending Raw Materials inventory is $8,400 (indirect materials are insignificant and not considered for budgeting purposes). f. Each bat requires 0.3 hours of direct labor, direct labor costs average $12.00 per hour. g. Variable manufacturing overhead is $0.80 per bat. h. Fuxed manufacturing overhead includes $1,070 per quarter in depreciation and \$5,310 per quarter for other costs. L. Fxed selling and administrative expenses include $5,170 per quarter for salarles; $4,560 per quarter for rent, $900 per quarter for insurance; and $550 per quarter for depreciation. 1. Variable selling and administrative expenses include supplies at 1.00% of sales. Complete the following budgets: Polar Bear Sluggers Sales Budget For the Quarter Ended March 31, 2021 \begin{tabular}{|c|c|c|c|} \hline & fouth Bats & Adult Bats & Total \\ \hline Budgeted bats to be sold & 1460 & 2970 & \\ \hline Sales price per bat & 45 & 85 & \\ \hline Total Sales & 65700 & 252450 & 318150 \\ \hline \end{tabular} Polar Bear Sluggers Production Budget For the Quarter Ended March 31, 2021 \begin{tabular}{|c|c|c|c|} \hline & Youth Bats & Adult Bats & Total \\ \hline Bats to be sold & 1460 & 2970V & 4430 \\ \hline Plus: Desired Ending Inventory & 180 & 300 & 480 \\ \hline Total Bats needed & 1640 & 3270 & 4910 \\ \hline Less: Bats in Beginning Inventory & 210 & 680 & 890 \\ \hline Budgeted bats to be produced & 1430 & 2590 & 4020 \\ \hline \end{tabular} Polar Bear Sluggers Direct Materials Budget For the Quarter Ended March 31, 2021 \begin{tabular}{l} \hline \\ \hline Budgeted bats to be produced \end{tabular} Polar Bear Sluggers Direct Labor Budget For the Quarter Ended March 31, 2021 \begin{tabular}{|c|c|c|c|} \hline & Youth Bats & Adult Bats & Total \\ \hline Budgeted bats to be produced & 1430 & 2590 & 4020 \\ \hline Direct labor hours per bat: & 0.3 & 0.32 & 0.32 \\ \hline Direct labor hours needed for production & 429 & m7 & 1206 \\ \hline Direct labor cost per hours & 12 & 12 & 12 \\ \hline Direct labor cost per hours & 5148 & 9324 & 14472 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{\begin{tabular}{l} Polar Bear Sluggers \\ Manufacturing Overhead Budget \\ For the Quarter Ended March 31, 2021 \end{tabular}} \\ \hline & Youth Bats & Adult Bats & Total & \\ \hline Budgeted bats to be produced & 1430 & 2590 & & 4020 \\ \hline Variable overhead cost per bat & 0.80 & 0.80 & & 0.80 \\ \hline Budgeted variable overhead & 1144 & 2072 & & 3216V \\ \hline \multicolumn{5}{|l|}{ Budgeted fixed overhead } \\ \hline Depreciation & & & & 1070 \\ \hline insurance and property taxes & & & & 5310V \\ \hline Total fixed overhead budget & & & & 6380 \\ \hline Budgeted manufacturing overhead costs & & & & 95968 \\ \hline Direct Labour hours & & & & 1206 \\ \hline Predetermined overhead allocation rate & & & & 7962 \\ \hline \end{tabular}