Cost Management 6th Edition by Edward Blocher,David Stout ,Paul Juras,Gary Cokins

تمرين 45

Comprehensive Profit Plan Spring Manufacturing Company makes two components identified as C12 and D57. Selected budgetary data for 2013 follow:

The firm expects the average wage rate to be $25 per hour in 2013. Spring Manufacturing uses direct labor-hours to apply overhead. Each year the firm determines the overhead application rate for the year based on the budgeted output for the year. The firm maintains negligible work-in-process inventory and expects the cost per unit for both beginning and ending finished products inventories to be identical.

The effective income tax rate for the company is 40%.
Required Prepare an Excel spreadsheet that contains the following schedules or statements for 2013:
1. Sales budget
2. Production budget
3. Direct materials purchases budget (units and dollars)
4. Direct labor budget
5. Factory overhead budget
6. Cost of goods sold and ending finished goods inventory budgets
7. Selling and administrative expense budget
8. Budgeted income statement