The question is 7-4B. Manufacturing. It starts with the management of Nabar Manufacturing prepared the following estimated balance sheet for June, 2015...I've enclosed 3 pictures which include the problem in it's entirety starting with budget picture #1. Picture 3 has a check answer thing; to confirm if you are right though - out the problem on the left in pink. I have also included (uploaded) in an excel document my progress so far.I have completed 8/10 Budgets required.

What I could use help with.

1. The check (5) in the total overhead cost for august does not match the amount I have for my document. Could you please help locate the mistake.

2. Help completing the Cash budget. The check (8) Ending cash balance for July I cannot reach. (Difficulty figuring out the Payment for raw materials - July.)

3. Help with requirement #9. Budgeted income statement for the entire quarter (not for each month separately)

4. Help with requirement #10. Budgeted balance sheet as of September 30, 2015.

The best help would be an answer using an excel document from the above "help needed" questions. (#1, #2, #3, #4).

Please resend the completed excel document back; that is uploaded back with corrections.

Any help is GREATLY appreciated. Thank you and have a great day.

NABAR MANUFACTURING Sales Budget July Expected Unit Sales Sales Price Total Sales $ $ August September 21,000 19,000 20,000 17.00 ### $ 17.00 357,000.00 $ 323,000.00 $ 340,000.00 NABAR MANUFACTURING Production Budget For the 3rd Quarter July August September Expected unit sales 21,000 19,000 20,000 Add: desired ending finished goods 13300 14000 16800 Total needs Less: beginning finished goods units 34,300 16,800 33,000 13300 30800 14000 Required units to produce 17500 19700 16800 NABAR MANUFACTURING Raw Matierals Budget 3rd Quarter July Units to be produced X Direct materials per unit Direct materials for production Add: ending direct materials Total Cost of material needed Less: beginning direct materials Direct materials to be purchased x Cost per unit of direct materials Direct materials cost budget August September 17,500 0.5 8750 1970 10720 4375 $ $ 19,700 0.5 9850 2000 11850 1970 6,345.00 8.00 50,760.00 $ 9,880.00 ### $ 79,040.00 $ 20,000 0.5 10000 1980 11980 2000 13,980.00 8.00 111,840.00 Budgeted production units Labor hours required per unit Total labor hours needed Cost per labor hour (Labor rate) Total cost of direct labor NABAR MANUFACTURING Direct Labor Budget For 3rd Quarter July August 21,000 0.5 10500 16 168000 19,000 0.5 9500 September 20,000 0.5 10000 16 152000 16 160000 NABAR MANUFACTURING Factory overhead budget 3rd Quarter July August September Labor hours needed 10500 9500 10000 Variable factory overhead rate 2.7 2.7 2.7 Budgeted variable overhead 28350 25650 27000 Budgeted fixed overhead 20000 20000 20000 Total overhead costs budget 48350 45650 47000 NABAR MANUFACTURING Selling expense budget 3rd Quarter Budgeted sales Sales commission percent Sales commissions Sales salaries July August September $ 357,000.00 $ 323,000.00 $ 340,000.00 10.00% 10.00% 10.00% $ 35,700.00 $ 32,300.00 $ 34,000.00 $ 3,500.00 $ 3,500.00 $ 3,500.00 Total selling expenses $ 39,200.00 $ 35,800.00 $ 37,500.00 NABAR MANUFACTURING General and Administrative Expense Budget 3rd Quarter July Salaries Interest on long-term note Total expenses August September 9000 2700 9000 2700 9000 2700 11700 11700 11700 Total budgeted sales Cash sales Sales on credit July $ $ $ August 357,000.00 $ 107,100.00 $ 249,900.00 $ September 323,000.00 $ 340,000.00 96,900.00 $ 102,000.00 226,100.00 $ 238,000.00 Current month's cash sales Collection of receivables Total cash receipts July $ $ $ August 107,100.00 $ 249,900.00 $ 357,000.00 $ September 96,900.00 $ 102,000.00 226,100.00 $ 238,000.00 323,000.00 $ 340,000.00 NABAR MANUFACTURING Cash Budget 3rd Quarter July Beginning cash balance Cash receipts from customers Total cash available Cash disbursements: Payment for raw materials Payment for direct labor General & administrative salaries Dividends Purchases of equipment Taxes paid Payment for variable overhead Sales commissions Loan interest Long-term note interest Sales salaries Total cash disbursements Preliminary cash balance Additional loan (loan repayment) Ending cash balance $ $ $ $ August September 40000 357,000.00 $ 397,000.00 $ 323,000.00 $ 323,000.00 $ 340,000.00 340,000.00 168,000.00 $ 9,000.00 $ $ 152,000.00 $ 9,000.00 $ 20,000.00 160,000.00 9,000.00 100000 $ $ 28,350.00 $ 35,700.00 $ 25,650.00 $ 32,300.00 $ 27,000.00 34,000.00 $ $ $ $ 2,700.00 $ 3,500.00 $ 247,250.00 149,750.00 2,700.00 $ 3,500.00 $ 2,700.00 3,500.00 Loan balance July Loan balance - Beginning of month Additional loan (loan repayment) Loan balance - End of month August September NABAR Manufacturing Budgeted income statement 3rd Quarter Sales Cost of goods sold Gross profit Operating expenses General administrative salaries Interest expense Sales salaries Long-term note interest Sales commissions Total operating expenses