I need help solving #4

Complete a production budget from the given information: #2 July 60,000 August 40,000 September 70,000 Sales in units Total 170,000 7-f The company desires an ending inventory balance of 20 % of the following month's budgeted sales. The beginning inventory balance at the start of July was 12,000 units. Budgeted sales for Budgeted October is 50,000 units July August Horooo September 70,0.. Budgeted Sales +Desired ending inv. a total needs -Beginning inv. =Total Production Total 54p00 Yoroo 14,000 20200 12e0 , '92 Complete a manufacturing overhead budget-from the giveninformation: # 3 July 2,000 August 5,000 The company's variable overhead rate is $4 per machine hour (MH). Total expected fixed overhead costs are $12,000 per month. Total non-cash fixed overhead expenses are $3,000 per September Total Budgeted MHs 7,000 14,000 month. July September Total August Budgeted MHs VMOH rate 14,000 56s00 VMOH costs 12O00 4/000 3 000 12,e00 FMOH costs l2,00 Total MOH costs 3,000 Less: non-cash 83,000 Cash disbursements for MOH Lo00 921000 -$6.57/M# Mooe Complete a cash budget from the given information: #4 September $375,000 Loo $185,000 $95,000 August $425,000 5S000 $205,000 $115,000 $105,000 July $500,000 Cash Receipts Cash Disbursements: $250,000 $100,000 $200,000 For materials For selling & admin For equipment The company started July with $40,000 in cash account. The company desires to keep a minimum cash balance of $50,000 at all times. The company can borrow at 12% interest (annual rate). Borrowing happens at the beginning of a month and repayments happen at the $0 end of a month. July August Total September S, 275 o20 42.5,000 Beginning Cash bal. +Cash receipts 101000 ,300,000 1440r000 Cash Available Less: Cash Disburse. 205,000 3, 105,006 425,000 250,000 lo9000 C401000 For materials 1SS,00 95,000 For S&A 31,000 305,0. 1,255,0 200,000 For equipment =Total cash disburse.552ede Excess/(Deficiency) Borrowing Repayment 2 9o,p00 Interest Ending Cash bal. Chanter 9