please help with scheduling 1-3
O. 2. Y. Exam Take-Home Porton.is 160% Searc A Home Layout Tablas Charts SmartArt Formulas Data Review Format Cat FIL Calibri (Body) 11 AA- aby Wrap Text Numbe Percentage S Percent Pasta Cle B U Merge Conditional Formatting Insert B13 X CX 20% D E F 1 2 3 4 B Hampton Freeze, Inc. Budgeting Assumptions For the Year Ended December 31, 2017 AN 4 Quarters 1 10,000 Quarter 2 30,000 3 40,000 4 20,000 $ 20.00 70% 30% 20% 2,000 5 6 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 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 3,000 $ 15 0.20 10% 21,000 22,500 SOX SOX 25 26 Direct Labor Budget LLLL Budgeting Assumptions Schedule Scheduschedule Schedule Schedule Schedule Schedule Schedule Schedule Schedule 10 150% SmartArt Sea Data Allgman FI Nu 11 abc CA wrap Text Percentage Format Percent Merge % 99 EI Cardinal Formatting B13 LE Delete Insert B 50% D E F 0.40 $ 15.00 Home Layout Tables Charts Formulas Font Calibri (Hody A A Paste Clear B U 20% A 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 43 44 Cash Budget 45 Minimum cash balance 46 Equipment purchases 47 Dividends Must borrow in increments of: 49 Simple interest rate per quarter 50 $ 4.00 $ 60,600 $ 15,000 $ 1.80 $ 20,000 $ 55,000 $ 10,000 $ 4,000 $ 10,000 S 30,000 $ 50,000 $ 40.000 $ 20.000 $ 20,000 $ 8,000 $ 10,000 3% 51 Budgeting Assumptions Schedule 1 Schedule Schedule Schedule Schedule Schedule Schedule Schedulehele 10 Sum 20 Home Tables Charts SmartArt Formula Data Review Cel FI Cal Body 11 HA-A- Weit General Normal abc BIG Pasta BU Merge Cercitional Fating Format Themes A 14 X B C D E F 1 Hampton Freeze, Inc. 2 Sales Budget 3 For the Year Ended December 31, 2017 4 5 Quarter 6 1 2 3 4 Year 7 Budgeted unit sales in cases) 10,000 30,000 40,000 20,000 100,000 8 Selling price per unit $20.00 $20.00 $20.00 $20.00 $20.00 9 Total sales $200,000.00 $600,000.00 $800,000.00 $400,000.00 $2,000,000.00 10 11 12 Schedule of Expected Cash Collections 13 Beginning accounts receivable 90,000 14 First-quarter sales 15 Second-quarter sales 16 Third-quarter sales 17 fourth-quarter sales 18 Total cash collections 19 20 Diding Amin Schedule Schedule Schedule Schedule Schedule Schedue Schedule Schedule Schedule Schedule 10 Ready 14 Nale Sumo Merge % 09 X 00 Conditional Formatting D F H Hampton Freemine. Production Budget For the Year ended December 31, 2017 (in cases) Quarter 2 30,000 3 Year Bugeted unit sales (Sales Budget) Add desired units of ending finished goods inventory Total needs Lass units of beginning finished goods inventory Required production in cases 1 10,000 6,000 16,000 Number FgI TH FL Calibrl Body 11 abc Wrap Ted General Normal Paste U B Merge 9%) F3 Conditional Formatting Bad Ins A22 4 C D E F ef Second-quarter purchases B Direct Materials Budget For the Year Ended December 31, 2017 2 3 4 5 6 Quarter 2 3 Year 8 9 7 Required production in cases (Production Budget) Units of raw material needed per case Units of raw material needed to meet production 10 Add desired units of ending raw materials inventory 11 Total units of material needed 12 Less units of beginning raw materials inventory 13 Units of raw material to be purchased 14 Cost of raw materials per pound 15 cost of raw materials to be purchased 16 17 18 Schedule of Expected Cash Disbursements for Puchases of Materials 19 20 Beginning accounts payable 21 First-quarter purchases 22 Second-quarter purchases 23 Third-quarter purchases 24 Fourth-quarter purchases 25 Total cash disbursement for materials 26 27 Budgeting Assumptions Schedule 1 Schedule 2 Schedule Schedule Schedule Schedule 6 Schedule Schedule Normal View Ready Sumo Schedule 9 Schedule 10 Hampton Freeze, Inc. Balance Sheet on 12/31/2016 Assets Current Assets Cash $ 42,500 Accounts Receivable 90,000 Raw Materials Inventory (21,000 pounds) 4,200 Finished Goods Inventory (2,000 cases) 26,000 Total Current Assets $ 162,700 Property, Plant, and Equipment Land 80,000 Building and Equipment 700,000 Accumulated Depreciation (292,000) Property, Plant, and Equigment, net 488,000 Total Assets $ 650.700 Liabilities and Stockholders' Equity Current Liabilities Accounts Payable S 25,800 Stockholders' Equity Common Stock $ 175,000 Retained Earning 449,900 Total Stockholders' Equity 624,900 Total Liabilities and Stockholders' Equity $ 650.700
