Our controller, Veronica Verrengia, is negotiating with our bamboo suppliers in
ID: 2575092 • Letter: O
Question
Our controller, Veronica Verrengia, is negotiating with our bamboo suppliers in China. We need the Softball Bat Division’s Master Budget for 2018 for our corporate strategic planning process, and we cannot wait for Veronica’s return from China. We would like you to prepare the Softball Bat Division’s Master Budget for 2018 The deliverables are as follows:
1. Sales budget, including a schedule of expected cash collections.
2. Production budget.
3. Direct materials budget, including a schedule of expected cash disbursements for materials.
4. Direct labor budget.
5. Manufacturing overhead budget, with a calculation of a pre-determined overhead rate.
6. Ending finished goods inventory budget calculating the expected value of the finished goods inventory as of December 31, 2018.*
7. Selling and administrative expense budget.
8. Cash budget.
9. Budgeted income statement for the year ended December 31, 2018.*
10. Budgeted balance sheet for December 31, 2018.*
11. Budgeted cashflow statement for the year ending December 31, 2018.* All the Master Budget schedules (except those marked with an asterisk) for the Softball Bat Division should include a column for each quarter and a total column for the fiscal year. We only need annual totals for the budgeted financial statements (schedules 9, 10, and 11) and we only need a year-end total for the value of finished goods inventory (schedule 6).
I’ve attached a brief description of the Softball Bat Division to the budget data Veronica gave me before she left for China. We eagerly await your results.
Bamboo Bat Company 3 Baseball bats have been traditionally made from hardwoods – primarily Northern White Ash, and more recently, Rock and Sugar Maple. These trees take 40-45 years to grow to the point where they can be harvested for lumber suitable for bats. Once established, bamboo is one of the fastest growing plants in the world. The chutes can be continually harvested without damaging the underlying root structure, which will keep sending up additional chutes. Bamboo can be grown on land not suitable for other crops, or as a natural fence with its roots holding the soil and preventing erosion. Thus bamboo is an environmentally friendly alternative to traditional hardwoods as a material source for baseball bats. Bamboo also has a tensile strength greater than steel. A bamboo bat delivers superior performance and resistance to breakage, while retaining the feel of a hardwood bat. Since bamboo chutes are hollow, bamboo bats are made by pressing bamboo "strips" into billets, and then turning these billets into bats. The Softball Bat Division specializes in making softball bats. All the softball bats have a two-tone finish with a clear lacquer handle and a colored barrel. Two examples are shown in the photos to the right. Lacquer is treated as an indirect material and included as part of variable overhead because the cost per bat is so small. Bamboo is the only direct material. During 2018, the selling price will be $82 per bat. The Softball Bat Division expects to sell the following number of bats during 2018. Quarter First Second Third Fourth Bats sales expected 71,000 84,000 76,000 80,000 The collection pattern for Accounts Receivable is as follows: o 65 percent of all sales are collected within the quarter in which they are sold o 35 percent of all sales are collected in the following quarter. o There are no bad debts/uncollectibles. Due to higher than expected demand this year the Softball Bat Division expects to have no finished bats in inventory. To avoid having that problem in the coming fiscal year, the Softball Bat Division would like to have the ending inventory of bats at the end of each quarter equal 25 percent of the budgeted sales for the next quarter. They would like to have 20,000 bats on hand at the end of 2018. Quarter First Second Third Fourth Ending FG inventory in bats as a percentage of the next quarter’s budgeted sales 25% 25% 25% ? Ending FG inventory in bats ? ? ? 20,000 Each bat requires 40 ounces of bamboo strips. The Softball Bat Division buys bamboo for $0.90 per ounce and expects the price to remain constant throughout the year. They expect to have to have 409,000 ounces of bamboo strips on hand at the beginning of 2018. At the end of each of the first three quarters, the Softball Bat Division would like to have their direct materials inventory Bamboo Bat Company 4 quantity to equal 10 percent of the amount required for the following quarter’s planned production. At the end of the year, Softball Bat Division would like to have 360,000 ounces of bamboo on hand. Quarter First Second Third Fourth Ending DM inventory as a % of the next quarter’s production requirement 10% 10% 10% ? Ending DM inventory in ounces ? ? ? 360,000 The Softball Bat Division buys its bamboo on account. It pays for 70% of its purchases of direct materials in the quarter in which they were purchased and 30% in the quarter after they were purchased. Each bat requires .90 hours (54 minutes) of direct labor. Employees engaged in direct labor will be paid an estimated $14.00 per labor hour. Wages and salaries are paid on the 15th and 30th of each month. Variable manufacturing overhead is estimated to be $13.50 per direct labor hour for the coming fiscal year. All variable manufacturing overhead expenses are paid for in the quarter incurred. Fixed manufacturing overhead is estimated to total $540,000 each quarter, with $360,000 of the total amount each quarter representing depreciation on machinery, equipment and the factory. All other fixed manufacturing overhead expenses are paid in cash in the quarter incurred. Display the pre-determined overhead rate to the nearest penny, but do not round the underlying calculation. Variable selling and administrative expenses are estimated to be $8.00 per bat sold. Fixed selling and administrative expenses are expected to total $280,000 each quarter, with $48,000 of the total amount each quarter representing depreciation on the office space, furniture and equipment. Other than depreciation, all selling and administrative expenses are paid for in the quarter incurred. At the end of the fourth quarter of 2018 the Softball Bat Division plans to buy new machinery and equipment for $1,400,000. The new machinery and equipment will be acquired at the very end of the year, so it will not be used in production and sales during the coming year and it will not be depreciated until the following year. The Softball Bat Division expects to pay 25% down and finance the remaining 75% of the equipment cost with a note payable. No interest payable will accrue on the note payable until after December 31, 2018. Softball Bat Division will pay quarterly dividends of $40,000 to its corporate parent, Bamboo Bat Company. Bamboo Bat Company would like the Division to maintain a minimum cash balance of $200,000. If after accounting for cash receipts and disbursements (including dividends) in the cash budget, the budgeted cash available cash will fall below $200,000 in any quarter, the Division will need to borrow additional cash. The Division has arranged a line of credit allowing it to borrow in $10,000 increments. Assume borrowing will take place at the beginning of any quarter in which the available cash would otherwise be below $200,000 so that at no time during the quarter will the cash balance fall below $200,000. The bank charges the Division interest at the rate of 1.25% per quarter (paid at the end of each quarter). The Division will also pay down the principal balance on the line of credit if they have sufficient cash to do so, at the end of each quarter. In addition to interest payments, the Division will make a partial repayment of principal in $10,000 increments until a further $10,000 increment would reduce their ending cash balance below $200,000. Bamboo Bat Company 5 The budgeted balance sheet for the Softball Bat Division on December 31, 2017 (which is the same as the budgeted balance sheet at the beginning of business January 1, 2018) is presented below. The Bamboo Bat Company owns 100% of the Capital Stock of the Softball Bat Division.
SOFTBALL BAT DIVISION – BAMBOO BAT COMPANY BUDGETED BALANCE SHEET
DECEMBER 31, 2017 ASSETS LIABILITIES & EQUITY
Cash $ 220,000
Accounts Payable $ 925,000
Accounts Receivable 1,400,000
Notes Payable 0
Raw Material
Inventory 368,100
Capital Stock 2,000,000
Plant and Equipment 1,700,000
Retained Earnings __763,100
TOTAL ASSETS $3,688,100 TTL LIAB. & SE $3,688,100
Explanation / Answer
Please note, per Chegg guidelines 4 sub-parts have been answered.
1 Softball Bat Division Sales Budget For the Year 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Budgeted sales in units 71000 84000 76000 80000 311000 Unit selling price $ 82 $ 82 $ 82 $ 82 $ 82 Total Sales $ 5822000 6888000 6232000 6560000 25502000 Schedule of Expected Cash Collections Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Sales $ 5822000 6888000 6232000 6560000 25502000 Collections for: Previous quarter (35%) 1400000 2037700 2410800 2181200 8029700 Current quarter (65%) 3784300 4477200 4050800 4264000 16576300 Total cash collections $ 5184300 6514900 6461600 6445200 24606000 2 Softball Bat Division Production Budget For the Year 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Next quarter's budgeted sales (units) 71000 84000 76000 80000 311000 Desired ending FG inventory as percent of next quarter's budgeted sales (units) 25% 25% 25% Budgeted ending inventory (units) 21000 19000 20000 20000 20000 Required production (units) 92000 103000 96000 100000 331000 Beginning inventory (units) 0 21000 19000 20000 0 Budgeted production in units 92000 82000 77000 80000 331000 3 Softball Bat Division Direct Materials Budget For the Year 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Budgeted production in units 92000 82000 77000 80000 331000 Material required per unit of production (ounces) 40 40 40 40 40 Materials needed for production (ounces) 3680000 3280000 3080000 3200000 13240000 Desired ending DM inventory as percent of next quarter's production requirements (ounces) 10% 10% 10% Budgeted ending inventory (units) 328000 308000 320000 360000 360000 Total DM required (ounces) 4008000 3588000 3400000 3560000 13600000 Beginning inventory (ounces) 409000 328000 308000 320000 409000 Materials to be purchased (ounces) 3599000 3260000 3092000 3240000 13191000 Material price per ounce $ 0.90 $ 0.90 $ 0.90 $ 0.90 $ 0.90 Total cost of direct material purchases $ 3239100 2934000 2782800 2916000 11871900 Schedule of Expected Cash Disbursements for Materials Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Direct material purchases $ 3239100 2934000 2782800 2916000 12104900 Disbursements for: Previous quarter (30%) 925000 971730 880200 834840 3611770 Current quarter (70%) 2267370 2053800 1947960 2041200 8310330 Total expected cash disbursements for materials $ 3192370 3025530 2828160 2876040 11922100 4 Softball Bat Division Direct Labor Budget For the Year 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Budgeted production in units 92000 82000 77000 80000 331000 Direct labor hours required per unit 0.9 0.9 0.9 0.9 0.9 Total labor hours needed 82800 73800 69300 72000 297900 Direct labor rate per hour $ 14 $ 14 $ 14 $ 14 $ 14 Direct labor cost $ 1159200 1033200 970200 1008000 4170600Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.