Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me in Req 4, i have chosen the wording I don't know if its correct but please help! The Vang Batting Company manufactures
Please help me in Req 4,
i have chosen the wording I don't know if its correct but please help!
The Vang Batting Company manufactures wood baseball bats. Vang's two primary products are a youth bat, designed for children and young teens, and an adult bat, designed for high school and college-aged players. Vang sells the bats to sporting goods stores and all sales are on account. The youth bat sells for $35; the adult bat sells for $60. Vang's highest sales volume is in the first three months of the year as retailers prepare for the spring baseball season. Vang's balance sheet for December 31, 2014, follows: Data Table $ Vang Batting Company Balance Sheet December 31, 2014 Assets Current Assets: Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Total Current Assets Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation 32,000 21,600 15,000 20,140 $ 88,740 135,000 (25,000) $ 110,000 198,740 $ 8,000 Total Assets Liabilities Current Liabilities: Accounts Payable Stockholders' Equity Common Stock $ Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 150,000 40,740 190,740 $ 198,740 Print Done More Info a. Budgeted sales are 1,900 youth bats and 2,700 adult bats. b. Finished Goods Inventory on December 31 consists of 500 youth bats at $19 each and 560 adult bats at $19 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 $13 per youth bat and $11 per adult bat. e. Desired ending Raw Materials Inventory is $15,000 indirect materials are insignificant and not considered for budgeting purposes). f. Each bat requires 0.2 hours of direct labor, direct labor costs average $15 per hour. g. Variable manufacturing overhead is $0.40 per bat. h. Fixed manufacturing overhead includes $800 per quarter in depreciation and $6,064 per quarter for other costs, such as insurance and property taxes. i. Fixed selling and administrative expenses include $10,000 per quarter for salaries; $2,500 per quarter for rent; $1,400 per quarter for insurance; and $450 per quarter for depreciation. j. Variable selling and administrative expenses include supplies at 5% of sales. Print Done Vang Batting Company Sales Budget For the Quarter Ended March 31, 2015 Youth Adult Bats Bats Total Budgeted bats to be sold 2,700 4,600 1,900 35$ $ Sales price per unit 60 $ 66,500 $ 162.000 s 228,500 Total sales Requirement 2. Prepare Vang's production budget for the first quarter of 2015. Vang Batting Company Production Budget For the Quarter Ended March 31, 2015 Youth Adult Bats Bats Total Budgeted bats to be sold 1,900 2,700 4,600 300 Desired bats in ending inventory 450 Plus: 750 Total bats needed 2,200 3,150 5.350 500 560 Less: Bats in beginning inventory 1,080 1.700 2,590 4,290 Budgeted bats to be produced Requirement 3. Prepare Vang's direct materials budget direct labor budget, and manufacturing overhead budget for the first quarter of 2015. Round the predetermined overhead allocation rate to two decimal places. Begin by preparing the direct materials budget Total 4,290 Vang Batting Company Direct Materials Budget For the Quarter Ended March 31, 2015 Youth Adult Bats Bats Budgeted bats to be produced 1,700 2.590 S 11 13 | $ Direct materials cost per unit Direct materials needed for production S 22,100 S 28,490 Plus: Desired direct materials in ending inventory Total direct materials needed Less: Direct materials in beginning inventory $ 50,590 15,000 85,590 15,000 Requirement 3. Prepare Vang's direct materials budget, direct labor budget, and manufacturing overhead budget for the first quarter of 2015. Round the predetermined overhead allocation rate to two decimal places. Begin by preparing the direct materials budget Vang Batting Company Direct Materials Budget For the Quarter Ended March 31, 2015 Youth Adult Bats Total Bats 1,700 2,590 4,290 S 11 13 | $ 22,100 S S 28,490 | $ 50,500 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 15,000 65,590 15,000 s 50 590 Budgeted purchases of direct materials Prepare the direct labor budget. (Enter any hours per unit amounts to two decimal places, X.XX.) Review the production budget you prepared above. Vang Batting Company Direct Labor Budget For the Quarter Ended March 31, 2015 , Youth Adult Bats Bats Total Budgeted bats to be produced 1,700 2,590 4,290 Direct labor hours per unit 0.20 0.20 0.20 Direct labor hours needed for production 340 518 858 Direct labor cost per hour S 15 | $ 15 s 15 $ 5,100 $ 7.770 Budgeted direct labor cost 12,870 Total Vang Tire Company Manufacturing Overhead Budget For the Quarter Ended March 31, 2015 Youth Adult Bats Bats Budgeted bats to be produced 1,700 2,590 S VOH cost per bat 0.40 $ 0.40 $ Budgeted VOH $ 680$ 1,0365 Budgeted FOH Depreciation 4,290 0.40 1,716 800 6.064 Insurance and property taxes Total budgeted FOH 6.884 $ 8,580 Budgeted manufacturing overhead costs 340 5 518 858 Direct labor hours Budgeted manufacturing overhead costs S 8,580 10.00 s Predetermined overhead allocation rate Requirement 4. Prepare Vang's cost of goods sold budget for the first quarter of 2015 Before preparing the cost of goods sold budget, calculate the projected manufacturing cost per bat for 2015. (Round all amounts to the nearest cent.) Youth Bats 13 15 Adult Bats 11 Direct materials cost per bat Direct labor cost per bat 15 Manufacturing overhead cost per bat LOOT 28 Total projected manufacturing cost per bat for 2015
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