PA8-5 Preparing Operating Budget Components [LO 8-3f, g, h] Wesley Power Tools m
ID: 2508577 • Letter: P
Question
PA8-5 Preparing Operating Budget Components [LO 8-3f, g, h] Wesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular items is a cordless power handisaw. Each handisaw sells for S60. Wesley expects the following unit sales: January February March April 2,100 2,900 2.600 2,000 Wesley's ending finished goods inventory policy is 35 percent of the next month's sales. Suppose each handisaw takes approximately 65 hours to manufacture, and Wesley pays an average labar wage of $15.50 per hour Each handisaw requires a plastic housing that Wesley purchases from a supplier at a cost of $5.00 each. The company has an ending raw materials inventory policy of 10 percent of the following month's production requirements. Materials other than the housing unit total $4.50 per handisaw. are 5 percent of sales dollars, and administrative expenses are fixed at $17,000 per month Required 1. Compute the budgeted cost of goods sold for the first quarter. (Round direct material, direct labor and overhead costs per unit to 2 decimal places. Round final answers to the nearest dollar amount.) 2.Compute the budgeted selling and administrative expenses. 3. Complete the budgeted income statement for the handisaw product for the first quarter. (Round direct material, direct labor and overhead costs per unit to 2 decimal places. Round final answers to the nearest dollar amount.)Explanation / Answer
Solution:
Part 1 – Budgeted Cost of Goods Sold
We need to first calculate the Unit product cost.
Quantity/Hours required per unit
Rate
Unit Cost
Direct materials
1
Plastic Housing
$5
each
$5.00
Other Material
$4.50
Direct Labor
0.65
hours
$15.50
per hour
$10.08
Variable Manufacturing Overhead
$1.00
Applied Manufacturing Overhead per unit ($66000/ 21,000 Units)
$3.14
Unit Product Cost
$23.72
Budgeted Cost of Goods Sold
January
February
March
1st Quarter Total
Expected Sales Unit (A)
2100
2600
2900
7600
Unit Product Cost (B)
$23.72
$23.72
$23.72
$23.72
Budgeted Cost of Goods Sold (A*B)
$49,812
$61,672
$68,788
$180,272
Part 2 --- Budgeted Selling and Administrative Expenses
January
February
March
1st Quarter Total
Expected Sales Unit
2100
2600
2900
7600
Unit Selling Price
$60
$60
$60
$60
Budgeted Sales Revenue
$126,000
$156,000
$174,000
$456,000
Budgeted Selling and Administrative Expenses
January
February
March
1st Quarter Total
Selling Expense (5% of Sales Revenue)
$6,300
$7,800
$8,700
$22,800
Administrative Expenses
$17,000
$17,000
$17,000
$51,000
Total Budgeted Selling and Administrative Expenses
$23,300
$24,800
$25,700
$73,800
Part 3 – Budgeted Income Statement
January
February
March
1st Quarter Total
Budgeted Sales Revenue
$126,000
$156,000
$174,000
$456,000
Cost of Goods Sold
$49,812
$61,672
$68,788
$180,272
Gross Profit (Sales - COGS)
$76,188
$94,328
$105,212
$275,728
Selling and administrative expenses
$23,300
$24,800
$25,700
$73,800
Budgeted Operating Income
$52,888
$69,528
$79,512
$201,928
Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you
Quantity/Hours required per unit
Rate
Unit Cost
Direct materials
1
Plastic Housing
$5
each
$5.00
Other Material
$4.50
Direct Labor
0.65
hours
$15.50
per hour
$10.08
Variable Manufacturing Overhead
$1.00
Applied Manufacturing Overhead per unit ($66000/ 21,000 Units)
$3.14
Unit Product Cost
$23.72
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.