Wesley Power Tools manufactures a wide variety of tools and accessories. One of
ID: 2558011 • Letter: W
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 $70. 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 .65 hours to manufacture, and Wesley pays an average labor wage of $12.50 per hour.
Each handisaw requires a plastic housing that Wesley purchases from a supplier at a cost of $6.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 24,000 units) and $1.00 per unit variable manufacturing overhead. Wesley’s selling expenses are 6 percent of sales dollars, and administrative expenses are fixed at $15,000 per month.
Explanation / Answer
1) Budgeted Cost of goods sold Jan Feb Mar Q1 Total Labor cost $ 18,688 $ 19,500 $ 24,375 $ 62,563 Material-Housing $ 13,800 $ 14,400 $ 18,000 $ 46,200 Material-Others $ 8,050 $ 8,400 $ 10,500 $ 26,950 Fixed overhead $ 6,038 $ 6,300 $ 7,875 $ 20,213 Variable overhead $ 2,300 $ 2,400 $ 3,000 $ 7,700 Total $ 48,875 $ 51,000 $ 63,750 $ 163,625 2) Budgeted S&A Expenses Jan Feb Mar Q1 Total Selling expenses $ 9,660 $ 10,080 $ 12,600 $ 32,340 Admin. Expenses $ 15,000 $ 15,000 $ 15,000 $ 45,000 Total $ 24,660 $ 25,080 $ 27,600 $ 77,340 3) Budgeted Income statement Jan Feb Mar Q1 Total Sales - 70* sales units $ 161,000 $ 168,000 $ 210,000 $ 539,000 Less: cost of goods sold $ 48,875 $ 51,000 $ 63,750 $ 163,625 Gross profit $ 112,125 $ 117,000 $ 146,250 $ 375,375 Less: S&A expenses $ 24,660 $ 25,080 $ 27,600 $ 77,340 Budgeted net operating income $ 87,465 $ 91,920 $ 118,650 $ 298,035
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.