Chapter 9 Assignment (i Saved Problem 9-14 Production and Direct Materials Purchases Budgets (LO2] Franklin Products Limited manufactures and distributes a number of products to retailers. One of these products, SuperStick, requires four kilograms of material D236 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter-July, August, and September. Peak sales of SuperStick occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: points Skipped a. The finished goods inventory on hand at the end of each month must be equal to 8,500 units plus 20% of the next month's sales. The finished goods inventory on June 30 is budgeted to be 22,600 units. b. The raw materials inventory on hand at the end of each month must be equal to 40% of the following month's production needs for raw materials. The raw materials inventory on June 30 for material D236 is budgeted to be 131,000 kilograms. c. The company maintains no work in process inventories. eBook Ask A sales budget for SuperStick for the last six months of the year follows: Print Budgeted Sales in Units July 61,000 August 75,500 September 106,000 October 53,500 November 30,500 December 15,200 Required: 1. Prepare a production budget for Super Stick for July, August, September, and October. July August September October Budgeted sales (units) points Required: 1. Prepare a production budget for Super Stick for July, August, September, and October. Skipped July August September October eBook Budgeted sales (units) Ask Print Total needs 0 0 0 0 Required production 0 0 0 0 Chapter 9 Assignment (i Saved 2. Not available in Connect. 10 points 3. Prepare a direct materials purchases budget showing the quantity of material D236 to be purchased for July, August, and September and for the quarter in total. Skipped July August September Third Quarter eBook Ask Required production (units) Material D236 needed per unit (kgs.) Production needs (kgs.) Print Total Material D236 needs 0 0 Material D236 purchases (kgs.) Chapter 9 Assignment i Saved Help Problem 9-16 Direct Labour and Manufacturing Overhead Budgets [LO2] The Bakery Department of Culbert Dessert Corporation has submitted the following forecast of fruit pies to be produced by quarter for the upcoming fiscal year. 10 points First Quarter 8,600 Second Quarter 11,600 Third Quarter 9,600 Fourth Quarter 13,600 Units to be produced Skipped eBook Each unit requires 0.50 direct labour-hours, and direct labour-hour workers are paid $10.00 per hour. In addition, the variable manufacturing overhead rate is $1.50 per direct labour-hour. The fixed manufacturing overhead is $24,500 per quarter. The only non-cash element of manufacturing overhead is depreciation, which is $7,300 per quarter. Ask Print Required: 1. Prepare the company's direct labour budget for the upcoming fiscal year, assuming that the direct labour workforce is adjusted each quarter to match the number of hours required to produce the forecast number of units produced. Culbert Dessert Corporation Direct Labour Budget First Second Third Quarter Quarter Quarter Fourth Quarter Year Units to be produced Direct labour time per unit (hours) Total direct labour-hours needed Direct labour cost per hour Total direct labour cost 10 points Skipped 2. Prepare the company's manufacturing overhead budget. As per Schedule 5, your manufacturing overhead budget should also include the budgeted cash disbursements for overhead. eBook Ask Culbert Dessert Corporation Manufacturing Overhead Budget First Second Quarter Quarter Third Quarter Fourth Quarter Year Print Budgeted direct labour-hours Variable overhead rate Variable manufacturing overhead Fixed manufacturing overhead Total manufacturing overhead $ 0 $ 0 $ 0 $ 0 $ 0 0 0 0 0 0 Cash disbursements for manufacturing overhead $ 0 % 0 % 0 % 0 % 0