Need help on problem 5 6 and 7. Use template if necessary. ATTACHMENT PREVIEW Download attachment Problem 3 template.xls KENSIC COMPANY April Units Sales price per unit Total Sales 20,000 April Sales in Units Desired units of ending inventory 20,000 SALES BUDGET May June 45,000 Total July August 50,000 35,000 105,000 June PRODUCTION BUDGET May July 50000 35,000 Total 105,000 45,000 30,000 Quarter July 4 Desired Total Units Less: desired units of beginning inventory Total production units DIRECT MATERIALS BUDGET (No. 208) April May June Units to be produced x 4 lbs. Total material needs 4 4 4 4 $5.00 $5.00 $5.00 $5.00 Add: desired end. Inv. Less: Beginning Inventory Total materals to be purchased x $5.00 Total cost of purchases DIRECT MATERIALS BUDGET (No. 311) April May June Units to be produced x 9 feet Total material needs Quarter July 9 9 9 9 $2.00 $2.00 $2.00 $2.00 Add: Desired end. Inv. Subtotal Less: Beginning Inventory Total materials to be purchased x $2.00 Total cost of purchased SCHEDULE OF CASH PAYMENTS FOR DIRECT MATERIALS April May June Quarter Accounts Payable 3/31 April May June Total DIRECT LABOR BUDGET April May Units to be produced x .25 (Shaping) Hrs. Shaping Dept. x $18.00 Labor cost Shaping dept. June Quarter 0.25 0.25 0.25 0.25 $18.00 $18.00 $18.00 $18.00 9 x .70 (Assembly) 0.7 0.7 0.7 0.7 Hrs. Assembly Dept. x $16.00 $16.00 $16.00 $16.00 $16.00 x .10 (Finishing) 0.1 0.1 0.1 0.1 Hrs. Finishing Dept. x $20.00 $20.00 $20.00 $20.00 $20.00 Labor cost for Assembly dept. Labor cost Finishing dept. Total Labor Cost MANUFACTURING OVERHEAD BUDGET April May June Quarter April CASH BUDGET May Quarter February SALES BUDGET March Variable Overhead: Utilities Indirect Labor Supplies Other Total Variable Overhead Fixed Overhead Total Overhead less: depreciation Total Overhead paid in cash June Total Cash Receipts Cash Payments: Material Purchases Direct Labor Overhead Fixed Sell. & Admin. Variable Sell. & Admin. Total Cash Payments Excess (deficiency) of cash Beg. Balance of cash Endng Balance of cash Units Sales price per unit Total Sales 10,000 $75.00 $750,000.00 14,000 $75.00 $1,050,000.00 (Repeated) April 20000 $0.00 SCHEDULE OF EXPECTED CASH COLLECTIONS April May June February (.10) March (.20; .10) April (.70;.20;.10) May (.70;.20) June (.70) Totals May June 35,000 50,000 $0.00 Quarter $0.00 Quarter 105000 $0.00