15 points Scholastic Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company's Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division's sales manager. April May June 10,000 desk-and-chair sets 12,000 desk-and-chair sets 15,000 desk-and-chair sets. eBook 14 Print References Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of direct labor. Each set sells for $50. Pine planks cost $0.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next month's production requirements. The division incurs a cost of $20 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finished-goods inventory to cover 20 percent of the next month's sales. Required: Complete the following budget schedules. 1. Sales budget. 2. Production budget (in sets). 3. Raw-material purchases. 4. Direct-labor budget. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Production budget (in sets):: Sales Add: Desired ending inventory Total requirements Less: Projected beginning inventory Planned production April May June 10,000 2,400 3,000 12,400 0 3,000 2,000 10,400 0 3,000 < Required 1 Required 3> Scholastic Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company's Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division's sales manager. April May June 10,000 desk-and-chair sets 12,000 desk-and-chair sets 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of direct labor. Each set sells for $50. Pine planks cost $0.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next month's production requirements. The division incurs a cost of $20 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finished-goods inventory to cover 20 percent of the next month's sales. Required: Complete the following budget schedules. 1. Sales budget. 2. Production budget (in sets). 3. Raw-material purchases. 4. Direct-labor budget. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Requid 3 Required 41 Raw-material purchases: (Round "Cost per board foot" to 2 decimal places.) Planned production (sets) April May June 10,400 Raw material required per set (board feet) 10 Raw material required for production (board feet) 104,000 Add: Desired ending inventory of raw material, in board feet (10% of next month's requirement) 12,600 16.000 Total requirements 116,600 16,000 Less: Projected beginning inventory of raw material, in board feet (10% of current month's requirement) 10,400 Planned purchases of raw material (board feet). 106,200 0 16,000 Cost per board foot Planned purchases of raw material (dollars) $ 0.50 $ 53,100 $ 0 $ 0 Scholastic Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company's Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division's sales manager. April May June 10,000 desk-and-chair sets 12,000 desk-and-chair sets 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of direct labor. Each set sells for $50. Pine planks cost $0.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next month's production requirements. The division incurs a cost of $20 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finished-goods inventory to cover 20 percent of the next month's sales. Required: Complete the following budget schedules. 1. Sales budget. 2. Production budget (in sets). 3. Raw-material purchases. 4. Direct-labor budget. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Direct-labor budget: (Round "Direct labor hours per set" to 1 decimal place.) April May June Planned production (sets) 10,400 Direct-labor hours per set 1.5 Direct-labor hours required 15,600 0 0 Cost per hour $ 20 Planned direct-labor cost $ 312,000 $ 0 $ 0