Wesley Power Tools manufactures a wide variety of tools and accessories. One of

Question

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 $60. Wesley expects the following unit sales: Wesley's ending finished goods inventory policy is 25 percent of the next month's sales Suppose each handisaw takes approximately .25 hours to manufacture, and Wesley pays an average labor wage of $14.50 per hour, Each handisaw requires a plastic housing that Wesley purchases from a supplier at a cost of $4.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 $3.50 per handisaw Manufacturing overhead for this product includes $63,000 annual fixed overhead (based on production of 21,000 units) and $1.10 per unit variable manufacturing overhead. Wesley's selling expenses are 4 percent of sales dollars, and administrative expenses are fixed at $15,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.) Budgeted Cost of Geods Sold 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.) Budgeted Income Statement

Explanation / Answer

Calculation of budgeted cost of goods sold January February March Total Direct material $18,000 $21,000 $23,250 $62,250 Direct Labour $8,700 $10,150 $11,238 $30,088 Variable Manufacturing Overhead $2,640 $3,080 $3,410 $9,130 Fixed Manufacturing Overhead $7,200 $8,400 $9,300 $24,900 Budgeted Cost of goods sold $36,540 $42,630 $47,198 $126,368 Fixed Manufacturing Overhead [er unit = $63000 / 21000 units = $3 per unit Budgeted Selling and administrative expenses January February March Total Selling cost (6% of sales) $8,640 $10,080 $11,160 $29,880 Fixed administrative expense $15,000 $15,000 $15,000 $45,000 Budgeted Selling and administrative expenses $23,640 $25,080 $26,160 $74,880 Wesley Power Tools Budgeted Income Statement For the Quarter ending March January February March 1st Quarter total Budgeted Sales $144,000 $168,000 $186,000 $498,000 Less : Budgeted Cost of goods sold $36,540 $42,630 $47,198 $126,368 Budgeted Gross Margin $107,460 $125,370 $138,803 $371,633 Less : Budgeted Selling and administrative expenses $23,640 $25,080 $26,160 $74,880 Budgeted Net Operating Income $83,820 $100,290 $112,643 $296,753

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.