File Edit View Insert Format Tools Data Window Help AutoSave Insert suso = EXCEL Problem on Operating... Q Design Layout Tell me Share 0 Comm Draw A e Font Paragraph Styles Dictate Sensitivity EXCEL Problem on Operating Budgets FG Required: Using the excel worksheet, prepare the following operating budgets for Wesley for the first quarter ) Wesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular items is a cordless power bandsaw. Each landisaw sells for $44. Wesley expects the following unit sales 1 bu January 2.000 tot 5 6 Dese Total February 2,200 March April 10 11 12 13 14 15 16 18 May 1.900 Wesley's ending finished goods inventory policy is 30 percent of the next month's sales Suppose each handsaw takes approximately 0.75 hours to manufacture, and Wesley prys an average labor wage of 18 per hour Each landisaw 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 feed overhead (based on production of 27000) and $1.20 per unit variable manufacturing overhead. Wesley's selling expenses we percent of sales dollars. administrative expenses are fixed at $18.000 per month an-Mar): 1. Sales budget 2. Production budget 3. Direct materials purchase budget for plastic housing 4. Direct Labor budget 5. Manufacturing Overheads budget Cost of goods sold (COG) budget remember to include materials other than hoito 7. Selling and Administrative expenses budget 8. Budgeted income statement for at product Sheet Focus av UN Page 1 of 1 73 words 10