Golden Wolves Statue Company Master Budgeting (Assignment #5) 50 points Business started off great the first year that the Golden Wolves Statues started production. Corey realized, however, that the business was seasonal and had peak sales in the fall, during the third quarter, when the students started college and continued through the beginning of the football season. The following information concerns operations for Year 2, the coming year, and for the first two quarters of Year 3. A. Golden Wolves Statue Company is now making only the forward-facing statue with the Alvemia University t-shirt and sells the product for $150funit. Budgeted unit sales for the next six quarters are as follows (all sales are on credit). Year 2 iiuarter Year 3 iiuarter Budgeted unit sales 400 600 1000 500 550 680 B. Sales are collected in the following pattern: 75% in the quarter the sales are made, and the remaining 25% in the following quarter. On January 1, Year 2, the company's balance sheet shows $6,500 in accounts receivable, all of which will be collected in the rst quarter of the year. Bad debts are negligible and can be ignored. C. The company desires an ending nished goods inventory at the end of each quarter equal to 30% of budgeted unit sales for the next quarter. On December 31, Year 1, the company had 400 units on hand. D. As you know 'om the cost table, 2 pounds of resin, 1 t-shirt, and a box are required to complete one unit of the product. As stated above, the company has sufficient t-shirts and boxes to last through Year 3 due to a gift. The company requires ending raw materials inventory at the end of each quarter equal to 10% of the following quarter's production needs. On December 31, Year 1, the company had 230 pounds of resin on hand. E. The price of the resin and the t-shirts stayed the same as presented in the cost table - $4.00 per pound of resin (2 lbs per statue), $0.25 per t-shirt and $0.40 per box. Raw material purchases are paid for in the following pattern: 60% paid in the quarter the purchases are made, and the remaining 40% paid in the following quarter. Golden Wolves Statues was given a gift of enough t-shirts and boxes at the end of Year 1 to last through Year 3. On January 1, Year 2, the company's balance sheet showed $366 in accounts payable for the total of resin raw material, all of which will be paid for in the first quarter of the year. Assignment: Prepare the following budgets and schedules for the Year 2, showing both quarterly and total figures: 1. A sales budget and a schedule of expected cash collections 2. A production budget 3. A direct material budget and a schedule of expected cash payments for purchases of materials. Use the charts below for your answers: 1. The sales budget: Year 2 Quarter 1 2 3 4 Year 2 Budgeted unit sales Selling price per unit Total Sales Based on the budgeted sales above, the schedule of expected cash collections is prepared as follows (Leave any box blank which does not need to be filled in): Year 2 Quarter 1 2 3 4 Year 2 Budgeted unit sales 400 600 1000 500 550 Beginning accounts receivable N/A N/A N/A First quarter sales ($60,000 x N/A N/A 75% in quarter 1, 25% in quarter 2) Second quarter sales (sales N/A N/A ($90,000 x 75% in quarter 2, 25% in quarter 3) Third quarter sales sales N/A N/A ($150,000 x 75% in quarter 3, 25% in quarter 4) Fourth quarter sales sales N/A N/A N/A ($75,000 x 75% in quarter 4) Total cash collections N/A N/A N/A N/A2. Based on the sales budget in units, the production budget is prepared as follows: Year 2 Quarter Year 3 Quarter 1 2 3 4 Year 2 2 Budgeted unit sales Add desired ending N/A finished goods inventory* Total needs N/A Less beginning finished N/A goods inventory Required production N/A *30% of the following quarter's budgeted unit sales 3. Based on the production budget, resin raw materials will need to be purchased during the year as follows: Year 2 Year 3 Quarter Quarter 2 3 4 Year 2 Required production in units of finished goods Units of resin raw materials needed per unit of finished goods Units of raw materials needed to meet production Add desired units of ending N/A raw materials inventory * Total units of raw materials N/A needed Less units of beginning raw N/A materials inventory Units of raw materials to be N/A purchases Unit cost of raw materials N/A Cost of raw materials to be N/A purchased *10% of the following quarter's production needs in poundsBased on the raw material purchases above, expected cash payments are computed as follows (leave any box blank which does not need to be filled in): Year 2 Quarter 2 3 4 Year 2 Beginning accounts payable N/A N/A N/A First quarter purchases N/A N/A ($1,096 x 60% in quarter 1 and x 40% in quarter 2) Second quarter purchases N/A N/A ($5,864 x 60% in quarter 2 and x 40% in quarter 3) Third quarter purchases N/A N/A ($6,532 x 60% in quarter 3 and x 40% in quarter 4) Fourth quarter purchases N/A N/A N/A ($4,420 x 60% in quarter 4) Total cash disbursements