This is what i have but need help with the next part. Problem 9 is what is givin

Question

This is what i have but need help with the next part.

Problem 9 is what is giving me trouble

I hope this can get done really fast cause im almost done

1. Sales Budget September 10000 25000 15000 50000 12500 Budgeted sales in units x Price per unit Projected sales revenue $140,000.00 $350,000.00 210,000.00 $700,000.00 $175,000.00 2. Production Budget ul September 10000 25000 Budgeted product sales in units +Desired product units in ending inventory - Total product units needed 13750 4000 9750 27250 3750 23500 15000 1875 16875 2250 14625 50000 1875 1875 4000 47875 Product units in beginning inventory Product units to produce 3. Material Purchases Budget Units to produce ul August September 9750 23500 14625 47875 x Material needed per unit 29250 14000 43250 8000 70500 8775 79275 14100 65175 43875 9000 52875 8775 44100 143625 9000 152625 8000 144625 Material needed for units to produce + Desired units of material in ending inventory Total units of material needed Units of material in beginning inventory Units of material to purchase 4. Cash Payments for Material Purchases September Material purchases (sheets) x Cost per unit -Total cost 35350 $2.00 $70,700.00 65175 $2.00 $130,350.00 44100 $2.00 $88,200.00 144625 $2.00 $289.250.00 $24,200.00 $45,955.00 Payables from June July purchases August purchases September purchases Total payments in month $24,200.00 $24,745.00 84,727.00 $45,622.50 $57,330.00 102.952.50 $45.622.50 $57,330.00 $282.580.00 Accounts Pavable $30,870.00 $98,903.00 $70,155.00 $109,472.50

Explanation / Answer

Solution 9:

Comprehensive Cash Budget Particulars July August September Total Beginning Cash Balance $140,000.00 $28,761.50 $20,000.00 $140,000.00 Cash Receipts $128,000.00 $288,000.00 $331,000.00 $747,000.00 Cash Available $268,000.00 $316,761.50 $351,000.00 $887,000.00 Cash Payments: Materials Budget $70,155.00 $109,472.50 $102,952.50 $282,580.00 Labor Budget $34,125.00 $82,250.00 $51,187.50 $167,562.50 Manufacturing OH Budget $29,625.00 $50,250.00 $36,937.50 $116,812.50 S&A Expense Budget $45,333.50 $45,333.50 $45,333.00 $136,000.00 Equipment Purchases $60,000.00 $0.00 $0.00 $60,000.00 Dividends $0.00 $20,000.00 $0.00 $20,000.00 Total Cash Payments $239,238.50 $307,306.00 $236,410.50 $782,955.00 Balance before financing $28,761.50 $9,455.50 $114,589.50 $104,045.00 Borrowings $0.00 $10,544.50 $0.00 $10,544.50 Principal repayments $0.00 $0.00 $10,544.50 $10,544.50 Interest $0.00 $0.00 $44.00 $44.00 Ending cash balance $28,761.50 $20,000.00 $104,001.00 $104,001.00

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.