Schedule of cash payment budget for purchases same 50

Info icon This preview shows pages 2–4. Sign up to view the full content.

Schedule of Cash Payment Budget for Purchases: Same 50% Next 50% Jul Aug Accounts Payable, December 2018 $ 16,000 Q1 Pur $ 1,884,000 $ 1,884,000 Q2 Pur $ 1,854,000 Q3 Pur Q4 Pur Total Budgeted Payment for Inventory $ 1,900,000 $ 3,738,000 Requirement D Direct Labor Cost Budget Jul Aug Budgeted Production Units 132,000 198,000 Budgeted Hours Need for per unit of output 0.30 0.30 Total Hours Needed 39,600 59,400 Per Hour Cost $ 20 $ 20 Budgeted Direct Labor Cost $ 792,000 $ 1,188,000 Requirement E Manufacturing overhead budget Jul Aug Variable Overhead $ 3 Per lt $ 396,000 $ 594,000 Fixed Manufacturing Overhead: Depreciation $ 6,000 $ 6,000 Other Cost $ 10,860 $ 10,860 Total Manufacturing Overhead $ 412,860 $ 610,860 Less Non Cash-Dep $ 6,000 $ 6,000 Cash Disbursment for Manu Ovh $ 406,860 $ 604,860 Budgeted Direct Labor Hours Overheaed Rate per Labor Hour Requirement F Selling and Administrative Budget Jul Aug Supplies 2% of Sale $ 24,000 $ 42,000 Salaries $ 8,000 $ 8,000 Rent $ 4,800 $ 4,800 Insurance $ 1,950 $ 1,950 Depreciation $ 2,000 $ 2,000 Total Selling and Admin Expense $ 40,750 $ 58,750
Image of page 2

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Less: Non Cash $ 2,000 $ 2,000 Cash disbursment for Selling and Admin $ 38,750 $ 56,750 Requirement G Cash Budget Jul Aug Beginning Cash Balance $ 20,000 $ -2,229,110 Add: Cash Receipts $ 909,000 $ 1,821,750 Cash Available $ 929,000 $ -407,360 Cash Payment for: Inventory Purchase $ 1,900,000 $ 3,738,000 Direct Labor $ 792,000 $ 1,188,000 Manufacturing Overhead $ 406,860 $ 604,860 Selling and Admin Expense $ 38,750 $ 56,750 Equipment Purchase $ 25,000
Image of page 3
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern