Part 1 Lynbrook, Inc. manufactures and distributes polpen. Cachepen requires unes of liquid GSCO to manufacture each unten. The gel pensare a popular school supply and as a result, the third quarter is the quarter in which perak les occur. As the production manager stynbrook, you are responsible for planning materials and for the company. With the winter production and was coming to a clow, it latime to begin planning for third quarter production and you have been using the following inventory requirements to you in planning and controlling inventary need The finished goods inventory anhand at the end of each month must be equal to 4.000 pas plus 25% of the next month. The finished goods limentary online 20s budapted to be 14.000 unit. The raw materiale inventory an tand at the end of each month must be equal to one half of the following month's production needs for raw material. The raw material Inventory on lure budgeted to be 50,000 GS The company maintains to work in process inventarie Aules budget for store the month of the year follow wy Apa September ber Anquired I Prepare a production budget for the pens for the monthly August, and September, and for the quarter. 2. Prepare a direct material budget showing the quantity of liquide LG Sony to be purchased for July August, and September, and for the quarter in total Part 2 As the Control of Lynbroek in one of your pobl sa papare the cash budget. You were ceny she following information to prepare the December cah budget for broek The illowing information is available about the company's operations 1. The cash balance on December 200 2. Actus afar saber and November and acted as for December aas ollows: October November December Cash sales 20.000 75,000 87,000 Sales on Account S.000 $32,000 610,000 Sales on accountan collected over three-month period follows:25% collected in the month at leX.colected in the month following and collected in the second month following Purchase at inventary will total $250,000 for December. Thirty percent of a month's Inventory purchases are paid during the month of purchase. The accounts payable remaining from November's inventory purchastotal $175.000, all of which will be paid in December Selling and administraties are budgeted at $10,000 for December. Of this amount. $0.000 is for depreciation A new Webserver for the Marketing Department conting,000 will be purchased for cash during December, and dividends totaling $15.000 will be paid during the month d. The company maintains a minimum catholice of $20,000. An speline of credits available from the company's bank to bolster the cat position as needed. However, mounts barowed are required to be increments at 1,000. Aequired L Prepare a schedule of expected ch collections for December 2. Prepare a schedule at pacted cah disbursements for marchandise purchases for December 2. Prepare a cash but for December. Indicate any bonowing that will be ended during the month. Asume that any interest will not be paiel und the following month Part 1 Lynbrook, Inc. manufactures and distributes polpen. Cachepen requires unes of liquid GSCO to manufacture each unten. The gel pensare a popular school supply and as a result, the third quarter is the quarter in which perak les occur. As the production manager stynbrook, you are responsible for planning materials and for the company. With the winter production and was coming to a clow, it latime to begin planning for third quarter production and you have been using the following inventory requirements to you in planning and controlling inventary need The finished goods inventory anhand at the end of each month must be equal to 4.000 pas plus 25% of the next month. The finished goods limentary online 20s budapted to be 14.000 unit. The raw materiale inventory an tand at the end of each month must be equal to one half of the following month's production needs for raw material. The raw material Inventory on lure budgeted to be 50,000 GS The company maintains to work in process inventarie Aules budget for store the month of the year follow wy Apa September ber Anquired I Prepare a production budget for the pens for the monthly August, and September, and for the quarter. 2. Prepare a direct material budget showing the quantity of liquide LG Sony to be purchased for July August, and September, and for the quarter in total Part 2 As the Control of Lynbroek in one of your pobl sa papare the cash budget. You were ceny she following information to prepare the December cah budget for broek The illowing information is available about the company's operations 1. The cash balance on December 200 2. Actus afar saber and November and acted as for December aas ollows: October November December Cash sales 20.000 75,000 87,000 Sales on Account S.000 $32,000 610,000 Sales on accountan collected over three-month period follows:25% collected in the month at leX.colected in the month following and collected in the second month following Purchase at inventary will total $250,000 for December. Thirty percent of a month's Inventory purchases are paid during the month of purchase. The accounts payable remaining from November's inventory purchastotal $175.000, all of which will be paid in December Selling and administraties are budgeted at $10,000 for December. Of this amount. $0.000 is for depreciation A new Webserver for the Marketing Department conting,000 will be purchased for cash during December, and dividends totaling $15.000 will be paid during the month d. The company maintains a minimum catholice of $20,000. An speline of credits available from the company's bank to bolster the cat position as needed. However, mounts barowed are required to be increments at 1,000. Aequired L Prepare a schedule of expected ch collections for December 2. Prepare a schedule at pacted cah disbursements for marchandise purchases for December 2. Prepare a cash but for December. Indicate any bonowing that will be ended during the month. Asume that any interest will not be paiel und the following month