kindly do parts E, F,G,H for a thumbs up!!
Rolan Corporation is preparing budgets for the upcoming quarter ending December 31. Budgeted sales (in units) for the next five months are: October 20.000 November 60,000 December 50,000 January 34,000 February 35.000 Below is additional information that may be relevant in preparing the bodgets. The company produces Indles that sell for $21.00 per unit. To guard against inventory stockouts, the company has a policy of maintaining an ending inventory of 15 percent of the following months budgeted sales. At the beginning of October, Rolan had 10,000 units in inventory Each unit of output requires 4 kilogram of direct material. To guard against stockouts of raw materials, the company has a policy of maintaining araw materials inventory of 20 percent of the following month's production. At the beginning of October, Rolan has 26.000 kilograms of direct materials on hand. Each kilogram of direct material costs $0.50 Each unit of output requires 0.2 hour (12 minutes of direct labour and employees we paid a standard rate of Sis per hour Rolan applies overhead using a variable rate of Si2 per direct labour hour. The fixed overhead is $71.000 per month of the mount, $20,000 are non-cash cost sich depreciation on Rolands both fixed and variable components to the selling and the expert Accountants at Rolan estimate that the variable ting and Idministrative expemasaresto per unit sold. Fixed selling and administrative expenses are $140,000 per month, $20,000 are non cash costs, such a depreciation on sets. Fifty percent of sales are made in cash. The remaining 50% of sales are made on account. The company collects 60% of sales made on account in the month of the sale, 20% in the month following the sale, and 15% in the second month following the sale. Rolan Company had total sales of 5672,000 in August and $588,000 in September Rolan pays $0.50 per kilogram of direct materials. The company pays of half of its purchases in the month of the purchase and the remaining half in the month following the purchase. At the beginning of the quarter, Rolan owed its creditors $24,000 for purchases of direct materials Required: (A) Prepare a sales budget for the months of October, November, and December, and for the quarter (B) Prepare a production budget for the months of October, November and December, and for the quarter-end. (Note: you might want to compute the production needs for January since you will need that information for subsection (C) (C) Prepare the direct materials purchases budget for the months of October, November and December, and for the quarter-end (D) Prepare the direct labour budget for the month of October, November and December, and for the quarter-end (E). Prepare the overhead budget for the month of October, November and December, and for the quartet-end ) Prepare the ending finished goods inventory budget for the quarter ending December 31 (G) Prepare the accounts receivable collections schedule for the month of October November and December (1) Prepare the cash payments on counts payable schedule for the months of October, November, and December A. Sales Budget- Decor Quarter 4 50.000 130 000 S 2200 2400 22:30 21:00 Total Sales $ 200 SL.0 $1,050,000 $2,750,000 3. Production Budget Production et Beber Guter 20.000 90.000 100 Ade Indian Inventor 2.500 5200 5.100 500 98100 2100 Beginning tentory 10.000 Production 7.00 1.5.100 C. Direct Material Purchase- Direct Material ber December Guate Production 500 00 1100 Each Unt of Production 4 Tatal Production Required 230 500.00 Ade to the Total Neede 207.720 Lebegning a Watend Total Raw Materade 12 SOLO Cost of Raw Material 5 0505 as 050 Total Cost of Raw Materials .00 132,00 S RO 250M D. Direct Labour Budget- O December 1600 Quarter 12100 Production Luchun gure Total Time Red Cost of Labour EL 5 S OS 50 21.00 12.00 12.00 Total Cost of the 500 52.005 LMOS MO Working Notes - FERRELSCREEN Rolan Corporation is preparing budgets for the upcoming quarter ending December 31. Budgeted sales (in units) for the next five months are: October 20.000 November 60,000 December 50,000 January 34,000 February 35.000 Below is additional information that may be relevant in preparing the bodgets. The company produces Indles that sell for $21.00 per unit. To guard against inventory stockouts, the company has a policy of maintaining an ending inventory of 15 percent of the following months budgeted sales. At the beginning of October, Rolan had 10,000 units in inventory Each unit of output requires 4 kilogram of direct material. To guard against stockouts of raw materials, the company has a policy of maintaining araw materials inventory of 20 percent of the following month's production. At the beginning of October, Rolan has 26.000 kilograms of direct materials on hand. Each kilogram of direct material costs $0.50 Each unit of output requires 0.2 hour (12 minutes of direct labour and employees we paid a standard rate of Sis per hour Rolan applies overhead using a variable rate of Si2 per direct labour hour. The fixed overhead is $71.000 per month of the mount, $20,000 are non-cash cost sich depreciation on Rolands both fixed and variable components to the selling and the expert Accountants at Rolan estimate that the variable ting and Idministrative expemasaresto per unit sold. Fixed selling and administrative expenses are $140,000 per month, $20,000 are non cash costs, such a depreciation on sets. Fifty percent of sales are made in cash. The remaining 50% of sales are made on account. The company collects 60% of sales made on account in the month of the sale, 20% in the month following the sale, and 15% in the second month following the sale. Rolan Company had total sales of 5672,000 in August and $588,000 in September Rolan pays $0.50 per kilogram of direct materials. The company pays of half of its purchases in the month of the purchase and the remaining half in the month following the purchase. At the beginning of the quarter, Rolan owed its creditors $24,000 for purchases of direct materials Required: (A) Prepare a sales budget for the months of October, November, and December, and for the quarter (B) Prepare a production budget for the months of October, November and December, and for the quarter-end. (Note: you might want to compute the production needs for January since you will need that information for subsection (C) (C) Prepare the direct materials purchases budget for the months of October, November and December, and for the quarter-end (D) Prepare the direct labour budget for the month of October, November and December, and for the quarter-end (E). Prepare the overhead budget for the month of October, November and December, and for the quartet-end ) Prepare the ending finished goods inventory budget for the quarter ending December 31 (G) Prepare the accounts receivable collections schedule for the month of October November and December (1) Prepare the cash payments on counts payable schedule for the months of October, November, and December A. Sales Budget- Decor Quarter 4 50.000 130 000 S 2200 2400 22:30 21:00 Total Sales $ 200 SL.0 $1,050,000 $2,750,000 3. Production Budget Production et Beber Guter 20.000 90.000 100 Ade Indian Inventor 2.500 5200 5.100 500 98100 2100 Beginning tentory 10.000 Production 7.00 1.5.100 C. Direct Material Purchase- Direct Material ber December Guate Production 500 00 1100 Each Unt of Production 4 Tatal Production Required 230 500.00 Ade to the Total Neede 207.720 Lebegning a Watend Total Raw Materade 12 SOLO Cost of Raw Material 5 0505 as 050 Total Cost of Raw Materials .00 132,00 S RO 250M D. Direct Labour Budget- O December 1600 Quarter 12100 Production Luchun gure Total Time Red Cost of Labour EL 5 S OS 50 21.00 12.00 12.00 Total Cost of the 500 52.005 LMOS MO Working Notes - FERRELSCREEN