Question

1 Approved Answer

Posted on Sep 14, 2024

I only need help with the budgeted balance sheet please thank you. 47 Ax & fic C B D N 3 00 1 Hampton Freeze,

I only need help with the budgeted balance sheet please thank you. image text in transcribed

47 Ax & fic C B D N 3 00 1 Hampton Freeze, Inc. 2 Balance Sheet on 12/31/2016 4 5 Assets 6 7 Current Assets Cash 9 Accounts Receivable 10 Raw Materials Inventory (21,000 pounds) Finished Goods Inventory (2,000 cases) 12 Total Current Assets 13 Property, Plant, and Equipment 14 Land 15 Building and Equipment 16 Accumulated Depreciation 17 Property, Plant, and Equipment, net 18 Total Assets $ 42,500 90,000 4,200 26,000 $ 162,700 80,000 700,000 (292,000) 1 488,000 $ 650,700 19 20 Liabilities and Stockholders' Equity 21 Current Liabilities 22. Accounts Payable $ 25,800 23 Stockholders' Equity 24 Common Stock $ 175,000 2016 Balance Sheet Budgeting Assumptions Schedule 1 Schedule 2 Ready c $ 25,800 A B 20 Liabilities and Stockholders' Equity 21 Current Liabilities 22. Accounts Payable 23 Stockholders' Equity 24 Common Stock $ 175,000 Retained Earning 449,900 26 Total Stockholders' Equity 27 Total Liabilities and Stockholders' Equity 25 624,900 $ 650,700 2 00 29 30 Hampton Freeze, Inc. Budgeting Assumptions For the Year Ended December 31, 2017 All 4 Quarters 1 10,000 Quarter 2 30,000 3 40,000 20,000 $ 20.00 70% 30% 5 Sales Budget 7 Budgets sales in cases 8 Selling Price per case 9 Percentage of sales collected in the quarter of sale 10 Percentage of sales collected in the quarter after sale 11 12 Production Budget 13 Percentage of next quarter's sales in ending finished goods inventory 14 Beginning Finished Goods inventory for year 15 Assumed desired ending Finished Goods inventory for year 16 | 17 Direct Materials Budget 18 Pounds of sugar per case 19 Cost per pound of sugar 20 Percentage of next quarter's production needs in ending inventory 21 Beginning Raw Materials inventory for year 2015 Balance Sheet Budgeting Assumptions Schedule Schedule 2 20% 2,000 3,000 15 $ 0.20 10% 21,000 Schedule > Schedule Schedule 5 Schedule 8 Schedule Sche Read B wwwwwwwy 21,000 22,500 50% 50% 0.40 $ 15.00 21 Beginning Raw Materials inventory for year 22 Assumed desired units of Ending Raw Materials inventory for year 23 Percentage of purchases paid in the quarter purchased 24 Percentage of purchases paid in the quarter after purchase 25 26 Direct Labor Budget 27 Direct labor-hours required per case 28 Direct labor cost per hour 29 30 Manufacturing Overhead Budget 31 Varialbe manufacturing overhead per direct labor-hour 32 Fixed manufacturing overhead per quarter 33 Depreciation per quarter 34 35 Selling and Administration Budget 36 Variable selling and administration expense per case 37 Fixed selling and administration expense per quarter 38 Advertising 39 Executive Salaries 40 Insurance 41 Property Tax 42 Depreciation 2016 Balance Sheet Budgeting Assumptions Schedule 1 Schedule 2 $ 4.00 $ 60,600 $ 15,000 $ 1.80 $ 20,000 $ 55,000 $ 10,000 $ 4,000 $ 10,000 Schedule 3 Schedule 4 813 Xfx 20% D E A F B > 4,000 $ 10,000 $ 30,000 41 Property Tax 42 Depreciation 43 44 Cash Budget 45 Minimum cash balance 46 Equipment purchases 47 Dividends 48 Must borrow in increments of: 49 Simple interest rate per quarter 50 51 $ 50,000 $ 40,000 $ 20,000 $ 20,000 $ 8,000 $ 10,000 3% 1 Hampton Freeze, Inc. 2. Budgeted Balance Sheet 3 on 12/31/2017 4 Assets 5 6 Current Assets 7 Cash 8 Accounts Receivable 9 Raw Materials Inventory 10 Finished Goods Inventory 11 Total Current Assets 12 Property, Plant, and Equipment 13 Land 14 Building and Equipment 15 Accumulated Depreciation 16 Property, plant, and Equipment, net 17 Total Assets 18 Liabilities and Stockholders' Equity 19 Current Liabilities 20 Accounts Payable (raw materials) 21 Stockholders' Equity 22 Common Stock, no par 23 Retained Earning 24 Total Stockholders' Equity 25 Total Liabilities and Stockholders' Equity Budgeting Assumptions Schedule 1 Schedule 2 47 Ax & fic C B D N 3 00 1 Hampton Freeze, Inc. 2 Balance Sheet on 12/31/2016 4 5 Assets 6 7 Current Assets Cash 9 Accounts Receivable 10 Raw Materials Inventory (21,000 pounds) Finished Goods Inventory (2,000 cases) 12 Total Current Assets 13 Property, Plant, and Equipment 14 Land 15 Building and Equipment 16 Accumulated Depreciation 17 Property, Plant, and Equipment, net 18 Total Assets $ 42,500 90,000 4,200 26,000 $ 162,700 80,000 700,000 (292,000) 1 488,000 $ 650,700 19 20 Liabilities and Stockholders' Equity 21 Current Liabilities 22. Accounts Payable $ 25,800 23 Stockholders' Equity 24 Common Stock $ 175,000 2016 Balance Sheet Budgeting Assumptions Schedule 1 Schedule 2 Ready c $ 25,800 A B 20 Liabilities and Stockholders' Equity 21 Current Liabilities 22. Accounts Payable 23 Stockholders' Equity 24 Common Stock $ 175,000 Retained Earning 449,900 26 Total Stockholders' Equity 27 Total Liabilities and Stockholders' Equity 25 624,900 $ 650,700 2 00 29 30 Hampton Freeze, Inc. Budgeting Assumptions For the Year Ended December 31, 2017 All 4 Quarters 1 10,000 Quarter 2 30,000 3 40,000 20,000 $ 20.00 70% 30% 5 Sales Budget 7 Budgets sales in cases 8 Selling Price per case 9 Percentage of sales collected in the quarter of sale 10 Percentage of sales collected in the quarter after sale 11 12 Production Budget 13 Percentage of next quarter's sales in ending finished goods inventory 14 Beginning Finished Goods inventory for year 15 Assumed desired ending Finished Goods inventory for year 16 | 17 Direct Materials Budget 18 Pounds of sugar per case 19 Cost per pound of sugar 20 Percentage of next quarter's production needs in ending inventory 21 Beginning Raw Materials inventory for year 2015 Balance Sheet Budgeting Assumptions Schedule Schedule 2 20% 2,000 3,000 15 $ 0.20 10% 21,000 Schedule > Schedule Schedule 5 Schedule 8 Schedule Sche Read B wwwwwwwy 21,000 22,500 50% 50% 0.40 $ 15.00 21 Beginning Raw Materials inventory for year 22 Assumed desired units of Ending Raw Materials inventory for year 23 Percentage of purchases paid in the quarter purchased 24 Percentage of purchases paid in the quarter after purchase 25 26 Direct Labor Budget 27 Direct labor-hours required per case 28 Direct labor cost per hour 29 30 Manufacturing Overhead Budget 31 Varialbe manufacturing overhead per direct labor-hour 32 Fixed manufacturing overhead per quarter 33 Depreciation per quarter 34 35 Selling and Administration Budget 36 Variable selling and administration expense per case 37 Fixed selling and administration expense per quarter 38 Advertising 39 Executive Salaries 40 Insurance 41 Property Tax 42 Depreciation 2016 Balance Sheet Budgeting Assumptions Schedule 1 Schedule 2 $ 4.00 $ 60,600 $ 15,000 $ 1.80 $ 20,000 $ 55,000 $ 10,000 $ 4,000 $ 10,000 Schedule 3 Schedule 4 813 Xfx 20% D E A F B > 4,000 $ 10,000 $ 30,000 41 Property Tax 42 Depreciation 43 44 Cash Budget 45 Minimum cash balance 46 Equipment purchases 47 Dividends 48 Must borrow in increments of: 49 Simple interest rate per quarter 50 51 $ 50,000 $ 40,000 $ 20,000 $ 20,000 $ 8,000 $ 10,000 3% 1 Hampton Freeze, Inc. 2. Budgeted Balance Sheet 3 on 12/31/2017 4 Assets 5 6 Current Assets 7 Cash 8 Accounts Receivable 9 Raw Materials Inventory 10 Finished Goods Inventory 11 Total Current Assets 12 Property, Plant, and Equipment 13 Land 14 Building and Equipment 15 Accumulated Depreciation 16 Property, plant, and Equipment, net 17 Total Assets 18 Liabilities and Stockholders' Equity 19 Current Liabilities 20 Accounts Payable (raw materials) 21 Stockholders' Equity 22 Common Stock, no par 23 Retained Earning 24 Total Stockholders' Equity 25 Total Liabilities and Stockholders' Equity Budgeting Assumptions Schedule 1 Schedule 2