Answered step by step
Verified Expert Solution
Question
1 Approved Answer
plz answer only the green questions Additional Information a. Budgeted sales are 1,500 youth bats and 3,000 adult bats. b. Finished Goods Inventory on December
plz answer only the green questions
Additional Information a. Budgeted sales are 1,500 youth bats and 3,000 adult bats. b. Finished Goods Inventory on December 31 consists of 500 youth bats at $15 each and 750 adult bats at $17 each. c. Desired ending Finished Goods Inventory is 300 youth bats and 450 adult bats, FIFO inventory costing method is used. d. Direct materials cost is $8 per youth bat and $10 per adult bat. e. Desired ending Raw Materials Inventory is $11,000 (indirect materials are insignificant and not considered for budgeting purposes). f. Each bat requires 0.25 hours of direct labor, direct labor costs average $20 per hour Variable manufacturing overhead is $0.75 per bat. h. Fixed manufacturing overhead includes $1,000 per quarter in depreciation and $2,000 per quarter for other costs, such as insurance and property taxes i. Fixed selling and administrative expenses include $10,000 per quarter for salaries: $3,000 per quarter for rent: $1,500 per quarter for insurance, and $300 per quarter for depreciation j. Variable selling and administrative expenses include supplies at 1% of sales Requirements 1. Prepare a sales budget for the first quarter of 2019. 2. Prepare a production budget for the first quarter of 2019. 3. Prepare a direct materials budget, direct labor budget, and manufacturing overhead budget for first quarter of 2019. Round the predetermined overhead allocation rate to two decimal places. 4. Prepare a cost of goods sold budget for first quarter of 2019. 5. Prepare a selling and administrative expense budget for first quarter of 2019. Requirement 1: Sales Budget Northwest Bat Company Sales Budget For the Quarter Ended March 31, 2019 Youth Bats Adult Bats Total 1,500 3,000 4.500 Budgeted bats to be sold Sales price per unit Total sales Additional Info item a. for #bats. Intro paragraph for sales price per unit. Note the format of Sales Budget $ 195,000 $ 247.500 Requirement 2: Production Budget Total From Sales Budget Northwest Bat Company Production Budget For the Quarter Ended March 31, 2019 Youth Adult Bats Bats Budgeted bats to be sold 1,500 3,000 Plus: Desired bats in ending inventory 450 Total bats needed 3,450 Less: Bats in beginning inventory 750 Budgeted bats to be produced 2,700 4,500 300 750 +Info item . 5.250 Info item b Requirement 3: Direct Material Budget Northwest Bat Company Direct Materials Budget For the Quarter Ended March 31. 2019 Youth Adult Bats Bats Total 4.000 From Production Budget 1.300 2.700 Info item d. $ 27,000 SL Budgeted bats to be produced Direct materials cost per unit Direct materials needed for production Plus: Desired direct materials in ending inventory Total direct materials needed Less: Direct materials in beginning inventory Budgeted purchases of direct materials Info item 48.400 11,000+ 37 400 From Balance Sheet Here is a comprehensive example. The Northwest Bat Company manufactures wood baseball bats. Northwest's two products are a youth bat, made for children and young teens, and an adult bat, designed for high school and college-age players. Bats are sold to sporting goods stores and all are on account. The youth bat sells for $35; the adult bat sells for $65. The highest sales volume is in the first three months of the year as retailers prepare for the spring baseball season. Northwest's balance sheet for December 31, 2018 is below. Northwest Bat Company Balance Sheet December 31, 2018 Assets $ 30,000 22,500 11,000 20,250 Current Assets: Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Total Current Assets Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation Total Assets $ 83.750 125,000 (50,000) 75,000 158,750 $ Liabilities Current Liabilities: $ 12,500 Accounts Payable Stockholders' Equity Common Stock $ Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 100,000 46.250 146.250 158,750 $ Requirement 3 continued Northwest Bat Company Direct Labor Budget For the Quarter Ended March 31, 2019 Youth Adult Bats Bats Budgeted bats to be produced 1,300 2,700 Direct labor hours per unit 0.25 0.25 Direct labor hours needed for production 325 675 Direct labor cost per hour 20 $ 20 Budgeted direct labor cost 6,500 $ 13,500 From Total Production Budget 4,000 0 25 1,000 1 Into Info item f. 20 $ 20,000 Requirement 3 continued Total From Production Budget Northwest Bat Company Manufacturing Overhead Budget For the Quarter Ended March 31, 2019 Youth Adult Bats Bats Budgeted bats to be produced 1,300 2,700 VOH cost per bat 0.75 $ 0.75 Budgeted VOH $ 975 $ 2,025 Budgeted FOH Depreciation Insurance and property taxes Total budgeted FOH Budgeted manufacturing overhead costs $ $ 4.000 0.75 3,000 Info items 1,000+ 2.000 Info item h. 3,000 VOH 3,000 + FOH 3,000 6,000 325 675 Direct Labor Budget Direct labor hours Budgeted manufacturing overhead costs Predetermined overhead allocation rate 1,000 6,000 6.00 From Overhead budget Requirement 4: Cost of Goods Sold Budget Calculate the projected manufacturing cost per bat for 2019 (will be useful in the CGS Budget) Youth Bats Adult Bats Direct materials cost per bat $ 8.00 $ Info item d. 10.00 + Direct labor cost per bat 5.00 5.00 + Info item f. (.25 x $20) Manufacturing overhead cost per bat 1.50 1.50 Total projected manufacturing cost per ba (6,000 O.H./4,000 bats (from production 2019 1450 $ 16.50 budget) Northwest Bat Company Cost of Goods Sold Budget For the Quarter Ended March 31, 2019 Youth Adult Bats Bats Beginning inventory 7,500 5 12,750 Bats produced and sold For Quarter ended Mar 31 14,500 37,125 Total budgeted cost of goods sold 22,000 $49.875 $ Info item b. Totat (500 x $15) 20,250 (750 x $17) 51.625 71.875 S 1,800 Youth Bats are needed (Prod. Budget) but 500 will come from Beg. Inventory, so 1,300 will be produced. Not all of 1,300 will be sold because the company will have 300 in ending inventory. So, 1,000 unit were produced and SOLD: CGS of those 1,000 1,000 x $14.50 cost per bat (from above) 3,450 Adult Bats are needed (Prod. Budget) but 750 will come from Beg. Inventory, so 2,700 will be produced. Not all of 2,700 will be sold because the company will have 450 in ending inventory. So, 2,250 units were produced and SOLD: CGS of those 2,250 = 2,250 x $16.50 cost per bat (from above) Requirement 5: Selling and Administrative Expense Budget Northwest Bat Company Selling and Administrative Expense Budget For the Quarter Ended March 31, 2019 Salaries Expense Rent Expense Insurance Expense Depreciation Expense Supplies Expense Total budgeted selling and administrative expense $ 3,000 Info item i. 1,500 300 Info item j. (budgeted sales x 1%) 17275 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