Assume actual cash receipts and disbursements will follow the pattern below: (Note: Receivables and Payables of...

Transcribed Image Text:

Assume actual cash receipts and disbursements will follow the pattern below: (Note: Receivables and Payables of 12/31/x1 will have a cash impact in 20x2.) 1. 21.00% of sales for the year are made in November and December. Since our customers have 60 day terms those funds will be collected be collected in January and February. 2. 81.00% of material purchases will be paid during the year, the remaining portion will be paid in Januay or February. 3. All other manufacturing and operating costs are paid for when incurred. 4. The budgeted depreciation expense is equal to 0.6% of the fixed manufacturing, selling and administrative expenses. 5. Minimum Cash Balance needed for 20x2, $150,000. I See The Light Projected Cash Budget For the Year Ending December 31, 20x2 Beginning Cash Balance Cash Inflows: Sales Collections: Account Receivable (Sales last year not collected) Sales made and collected in 20x2 Cash Available Cash Outflows: Purchases Accounts Payable (Purchases last year) Material purchases made and paid for in 20x2 Other Manufacturing Costs Direct Labor Total Manufacturing Overhead Selling and Administrative Less: Depreciation Total Cash Outflows Budgeted Cash Balance before financing Needed Minimum Balance Amount to be borrowed (if any) Budgeted Cash Balance Round dollars to two places, $##.## {10.02} {10.03} {10.04} {10.05} {10.06} {10.07} {10.08} {10.09} {10.10} 9 Variable Cost of making one unit next year - used to calculate the Ending Inventory of Finished Goods Material cost per unit Labor Cost Per Lamp Variable Factory overhead per unit Total variable manufacturing cost of one unit 20x2 Cost Rounded to 7 Decimal Places {11.01} 10 Budgeted Operating Income Using Variable (Direct) Costing Sales Variable Cost of Goods Sold Assume FIFO (First-In, First-Out) - Beginning Inventory, Finished Goods (Variable Costing) Production Costs: Materials: Figurines: Electrical Parts Lamp Shades: Labor: Variable Overhead: 20x2 Cost Rounded to 2 Decimal Places {11.02} Total Variable Production Costs {11.03} Cost of Goods Available For Sale Less: Ending Inventory, Finished Goods (Variable Costing) {11.04} Variable Cost of Goods Sold Variable Selling (Round to two places, $##.##) {11.05} Variable Administrative (Round to two places, $##.##) {11.06} Total Variable Costs |{11.07} Contribution Margin Fixed Costs: Fixed Manufacturing Overhead Fixed Selling Fixed Administrative Total Fixed Operating Income, Variable Costing Operating Income, Absorption Operating Income, Variable Costing Excess (Absorption Costing Operating Income - Variable Costing Operating Income) Budgeted Fixed Overhead Budgeted Number of Units to be Produced Budgeted Fixed Cost Per Unit (Round to 7 decimals #.####***) {11.08} {11.09} {11.10} |{11.11} Fixed Manufacturing Overhead in the Ending Inventory {11.12} Fixed Manufacturing Overhead in the Beginning Inventory {11.13} Increase (Fixed Manufacturing Overhead in the Ending Inventory-Fixed Manufacturing Overhead in the Beginning Inventory) |{11.14} Assume actual cash receipts and disbursements will follow the pattern below: (Note: Receivables and Payables of 12/31/x1 will have a cash impact in 20x2.) 1. 21.00% of sales for the year are made in November and December. Since our customers have 60 day terms those funds will be collected be collected in January and February. 2. 81.00% of material purchases will be paid during the year, the remaining portion will be paid in Januay or February. 3. All other manufacturing and operating costs are paid for when incurred. 4. The budgeted depreciation expense is equal to 0.6% of the fixed manufacturing, selling and administrative expenses. 5. Minimum Cash Balance needed for 20x2, $150,000. I See The Light Projected Cash Budget For the Year Ending December 31, 20x2 Beginning Cash Balance Cash Inflows: Sales Collections: Account Receivable (Sales last year not collected) Sales made and collected in 20x2 Cash Available Cash Outflows: Purchases Accounts Payable (Purchases last year) Material purchases made and paid for in 20x2 Other Manufacturing Costs Direct Labor Total Manufacturing Overhead Selling and Administrative Less: Depreciation Total Cash Outflows Budgeted Cash Balance before financing Needed Minimum Balance Amount to be borrowed (if any) Budgeted Cash Balance Round dollars to two places, $##.## {10.02} {10.03} {10.04} {10.05} {10.06} {10.07} {10.08} {10.09} {10.10} 9 Variable Cost of making one unit next year - used to calculate the Ending Inventory of Finished Goods Material cost per unit Labor Cost Per Lamp Variable Factory overhead per unit Total variable manufacturing cost of one unit 20x2 Cost Rounded to 7 Decimal Places {11.01} 10 Budgeted Operating Income Using Variable (Direct) Costing Sales Variable Cost of Goods Sold Assume FIFO (First-In, First-Out) - Beginning Inventory, Finished Goods (Variable Costing) Production Costs: Materials: Figurines: Electrical Parts Lamp Shades: Labor: Variable Overhead: 20x2 Cost Rounded to 2 Decimal Places {11.02} Total Variable Production Costs {11.03} Cost of Goods Available For Sale Less: Ending Inventory, Finished Goods (Variable Costing) {11.04} Variable Cost of Goods Sold Variable Selling (Round to two places, $##.##) {11.05} Variable Administrative (Round to two places, $##.##) {11.06} Total Variable Costs |{11.07} Contribution Margin Fixed Costs: Fixed Manufacturing Overhead Fixed Selling Fixed Administrative Total Fixed Operating Income, Variable Costing Operating Income, Absorption Operating Income, Variable Costing Excess (Absorption Costing Operating Income - Variable Costing Operating Income) Budgeted Fixed Overhead Budgeted Number of Units to be Produced Budgeted Fixed Cost Per Unit (Round to 7 decimals #.####***) {11.08} {11.09} {11.10} |{11.11} Fixed Manufacturing Overhead in the Ending Inventory {11.12} Fixed Manufacturing Overhead in the Beginning Inventory {11.13} Increase (Fixed Manufacturing Overhead in the Ending Inventory-Fixed Manufacturing Overhead in the Beginning Inventory) |{11.14}