Required:

Using the excel worksheet, prepare the following operating budgets for Wesley for the first quarter (Jan-Mar):

1. Sales budget
2. Production budget
3. Direct materials purchase budget for plastic housings
4. Direct Labor budget
5. Manufacturing Overheads budget
6. Cost of goods sold (COGS) budget (remember to include materials other than housing unit cost)
7. Selling and Administrative expenses budget
8. Budgeted income statement for handisaw product.

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 $44. Wesley expects the following unit sales: January 2,000 February 2,200 March 2,700 April 2,500 May 1,900 Wesley's ending finished goods inventory policy is 30 percent of the next month's sales. Suppose each handisaw takes approximately 0.75 hours to manufacture, and Wesley pays an average labor wage of $18 per hour. Each handisaw requires a plastic housing that Wesley purchases from a supplier at a cost of $7.00 each. The company has an ending direct materials inventory policy of 25 percent of the following month's production requirements. Materials other than the housing unit total $4.50 per handisaw. Manufacturing overhead for this product includes $72,900 annual fixed overhead (based on production of 27,000 units) and $1.20 per unit variable manufacturing overhead. Wesley's selling expenses are 7 percent of sales dollars, and administrative expenses are fixed at $18,000 per month