this is the budgeting assumptions split in two photos

o un Aw Perky Turkey Jerky, LLC Balance Sheet March 31, 2018 Assets 22,000.00 9,000.00 2,750.00 14,300.00 6 Current Assets Cash 8 Accounts Receivable 9 Raw Materials Inventory 10 Finished Goods Inventory 11 Total Current Assets 12 Plant and Equipment 13 Equipment 14 Accumulated Depreciation 15 Plant and Equipment, Net 16 Total Assets 48,050.00 960,000.00 (63,000.00) 897,000.00 945,050.00 17 7,500.00 100,000.00 Liabilities and Stockholders' Equity 19 Liabilities 20 Accounts Payable 21 Bonds Payable 22 Stockholders' Equity 23 Common Stock 800,000.00 24 Retained Earnings 37,550.00 25 Total Stockholders' Equity 26 Total Liabilities and Stockholders'Equity 837,550.00 945,050.00 D Month April June 15,000 Sales Budget Budgeted Sales In units Selling PricePerUnit Percentage of Sales collected in the month of the sale Percentage of Sales collected in the month after the sale 10,000 $9.00 90% 10% 12.000 $9.00 90% 15,000 $9.00 SON 20% 10% Production Budget Percentage of next month's sales in ending finished goods invento 20% 25% 30 2.000 units are carried over from March $2.50 $2.50 $2.50 Direct Material Budget Meat per pound Pounds of meat per unit Percentage of next months production needs in ending Inventory Percentage of purchases paid in the month purchased Percentage of purchases paid in the month after purchase 5% 5% 75% 1,100 pounds are carried over from March 1.400 pounds should be carried over to July 75% 25% 25 Direct Labor Budget Direct labor hours required per unit (20 units per labor hour)1111 Cost per direct labor hour 10.05 $18.00 0.05 $18.00 0.05 $18.00 Manufacturing Overhead Budget Variable manufacturing overhead per direct labor hour Feed manufacturing overhead Manufacturing Depreciation $5.00 $15.000 $10.000 $5.00 $15,000 $10,000 $5.00 $15.000 $10,000 $0.10 $0.10 $0.10 Variable Selling and Administrative Expense Budget Sales Commissions Fixed selling and administrative expenses Advertising Manager Salaries Insurance Depreciation on Office Equipment Totalfred selling and administrative expenses $2.500 $5,000 $2.000 $500 $10,000 $2,500 $5,000 $2,000 $500 $10,000 $2,500 $5,000 $2,000 $500 $10,000 Depreciation from purchases during the period are already included $30,000 $30,000 Cash Budget Minimum cash balance Equipment Purchases Dividends Simple annual interest rate $30,000 $12.000 53,000 Must borrow in $10,000 increments 10 year asset administrative $3,000 $3,000 Perky Turkey Jerky, LLC Direct Materials Budget For the Quarter Ending June 30, 2018 Month May Quarter Total April June Required production (in units) Pounds of raw materials per unit Pounds of raw materials needed for production Add: Desired Raw Materials ending inventory Total pounds of Raw Materials needed Less: Beginning Raw Materials inventory Pounds of Raw Materials to be purchased Cost of Raw Materials per pound Cost of Raw Materials to be purchased Schedule of Expected Cash Disbursements for the Purchase of Materials Beginning Accounts Payable April purchases May purchases June purchases Perky Turkey Jerky, LLC Manufacturing Overhead Budget For the Quarter Ending June 30, 2018 Month May Quarter Total April 8 Budgeted direct labor hours Variable Manufacturing Overhead rate O Variable Manufacturing Overhead 1 Fixed Manufacturing Overhead 2 Total Manufactuing Overhead 23 Less: Depreciation 14 Cash disbursments for manufacturing overhead 17 Total Manufacturing Overhead 18 Total budgeted Direct Labor hours 19 Predetermined overhead rate for the quarter 993 x x E E F G C D Perky Turkey Jerky, LLC Ending Finished Goods Inventory Budget For the Quarter Ending June 30, 2018 Total Prodcution Cost Per Case Direct Material Direct Labor Manufacturing Overhead Unit Product Cost Quantity pounds hours hours $2.50 $18 $0.00 Cost per pound per hour per DL hour Budgeted ending finished goods inventory Ending finished goods inventory (in units) Unit product cost Dollar value of ending inventory Cost of Goods Sold Units sold Beginning Inventory Produced during the period Cost of Goods Sold Perky Turkey Jerky, LLC Cash Budget For the Quarter Ending June 30, 2018 Schedule Reference Month Quarte Beginning blance shed Beginning Cash balance 9 Add: Cash receipts 10 Cash received from customers 11 Total Cash available 12 Less: Cash disbursements 13 Direct Materials Direct Labor 15 Manufacturing Overhead 16 Selling and administrative expenses 17 Equipment purchases 18 Dividends 19 Total Cash disbursements 20 Cash remaining after disbursements 21 Financing 22 Borrowings 23 Repayments 24 Interest 25 Total financing 26 Ending Cash balance Direct Materials Direct Labor Monufacuting Overhead Selling and Admin Assumptions Assumptions - Mely enter $ % 9 -9 Conditional Format Formatting as Table Cell Style Manufacturing Overhead Budget Variable manufacturing overhead per direct labor hour Fixed manufacturing overhead Manufacturing Depreciation $5.00 $15,000 $10,000 $5.00 $15,000 $10,000 $5.00 $15,000 $10,000 $0.10 $0.10 $0.10 Variable Selling and Administrative Expense Budget Sales Commissions Fixed selling and administrative expenses Advertising Manager Salaries Insurance Depreciation on Office Equipment Total fixed selling and administrative expenses $2,500 $5,000 $2,000 $500 $10,000 $2,500 $5,000 $2,000 $500 $10,000 $2,500 $5,000 $2,000 $500 $10,000 Depreciation from purchases during the period are already included $30,000 $30,000 Cash Budget Minimum cash balance Equipment Purchases Dividends Simple annual interest rate $30,000 $12,000 $3,000 2% Must borrow in $10,000 increments 10 year asset, administrative $3,000 2% $3,000 2% Beginning Balance Sheet Budgeting Assumptions Sales Production Direct Materials Direct Labor Manufacturing Overhead Finis Ready VAADA