In Crane Corporation's first year of operations, inadequate budgeting led to significant cost overruns in multiple production areas. Direct materials needed to be express-delivered, and laborers needed to be paid overtime because reasonable budgets weren't in place, nor were managers properly trained on how to use them. If adequate budgeting had been done, the company might have achieved its objectives that year. As year one comes to a close, all managers are now committed to creating and using accurate budgets for next year so they can properly plan for the resources to support production. The following information is in place to assist the management team in budgeting for year 2. Budgeted sales volume Q1 5,600 Year 2 Q2 Q3 Q4 6,000 5,500 5,900 Year 3 Q1 5,600 Q2 6,900 Additional information: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Budgeted selling price is $78/unit. Desired ending FG Inventory is 25% of the following quarter's sales volume. Beginning FG Inventory on January 1 of Year 2 is expected to be just 770 units. Each unit requires 3 pounds of DM at an estimated cost of $4/pound. Desired ending DM Inventory is 20% of the following quarter's production needs. Each unit requires 1.2 DL hours at an estimated cost of $14/hour. Variable MOH is applied to units at a budgeted rate of $15/unit produced. Quarterly Fixed-MOH costs are expected as follows: depreciation on plant assets of $10,800, supervisors' salaries of $21,700, and property taxes and insurance of $4,600. Variable SG&A expenses are budgeted at a rate of $3/unit sold. Quarterly fixed SG&A expenses are expected as follows: sales salaries of $15,400, advertising of $2,500, and executive and administrative salaries of $37,800. Prepare the quarterly sales budget for Crane for its second year of operations. Present budgeted amounts for each quarter and for the year overall. Budgeted Sales Volume Budgeted Selling Price Budgeted Sales Revenue V $ $ Q1 5600 78 436800 $ $ Q2 6000 78 468000 $ Q3 5500 78 429000 $ $ Q4 5900 78 460200 $ $ Year 2 23000 78 1794000 Prepare the quarterly production budget for Crane for its second year of operations. Present budgeted amounts for each quarter and for the year overall. Q1 Q2 Q3 Q4 Year 2