You have been given the following information to prepare the budgets for all 4 Quarters, 2018 for the Bullwinkle, Inc. The product is kayaks. The company is preparing the budget for budget analysis for 2018. Requirements: Prepare the following budgets for 4 Quarters, 2018: 1) 2) 3) 4) Sales budget Production budget Materials budget Labor budget Manufacturing Overhead budget Selling and Administrative budget Expected collections 5) 6) 7) 8) 9) Expected payments Cash budget Discuss why the company should prepare flexible budgets rather than static budgets Discuss the importance of a responsibility report. 11) Sales isce 250 35o 1,100 rue Expected units sales for quarter ending 03-31-2018 Expected units sales for quarter ending 06-30-2018 Expected units sales for quarter ending 09-30-2018 1,000 units 1,500 units 750 units Expected units sales for quarter ending 12-31-2018 Expected unit sales for quarter ending 03-31-2019 Expected units sales for quarter ending 06-30-2019 750 units -1,100 units -1,500 units Unit sales price $ 275.00 Sales are on account with 85% of the accounts receivable collected in the quarter of sale, and 15% are collected in the quarter after sale. Accounts Receivable on December 31, 2017 totaled $194,750.00 collected in the 1st Qtr, 2018. 50% of materials are paid in the quarter of purchase, and 50% are paid in the quarter after purchase. Accounts Payable on December 31, 2017 totaled $120,595.00, paid 100% in 1st Qtr, 2018. $ 145,000.00 Sales of Common Stock 1st Qtr, 2018: Sale of Preferred Stock 2nd Qtr, 2018: $ 294,650.00 3rd Qtr, 2018 $ 310,500.00 The company policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's expected sales. Ending finished goods inventory at December 31, 2017 will be 200 kayaks. Production of each kayak requires 20 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). The ending inventory of pewder should be 25% of the amount needed for production in the next quarter. Assume that the ending inventory of powder on December 31, 2017 is 19,400 pounds. The finishing kits can be assembled as they are needed. The powder used in the kayaks costs $1.50 per pound, and the finishing kits cost $5.00 each. Production of a single kayak requires 2 hours of time by more experienced, typel employees, and 3 hours of finishing time by type Il employees. The type l employees are paid $15 per hour, and the type Il employees are paid $12 per hour. > Dor ta bah Manufacturing Overhead information: Indirect Materials 0.30 Per DL hour for Skilled employees Indirect Labor 0.50 Per DL hour for Skilled employees Utilities 0.45 Per DL hour for Skilled empioyees Maintenance 0.25 Per DL hour for Skilled employees $ 8,500.00 Per month $ 3,900.00 Per month Salaries Depreciation You do not need to classify manufacturing overhead costs by variable and fixed. Information for the Selling and Administrative Budget: $ 3,475.00 per month $ 1,500.00 per month $ 10,800.00 per month $ 2,500.00 per month $ 3,500.00 per month Advertising Insurance Salaries Depreciation Other fixed costs You do not need to classify selling and administrative costs by variable and fixed. The cash balance on December 31, 2017 totaled $100,500. Management has decided to maintain a cash balance of at least $200,000 at the end of each quarter, 2018. Dividends are paid each quarter at the rate of $2.50 per share for 5,000 shares outstanding. The company has an open line of credit (LOC) with the bank. The terms of agreement requires borrowing to be in $1,000 increments at 8% interest. The funds borrowed, if necessary, at the end of each quarter are paid back the following quarter. A $475,000.00 equipment purchase is planned for the 2nd quarter, 2018, and a $370,000.00 equipment purchase is planned for the 3rd quarter, 2018.