Budget Comprehensive Full - ET Pods.xlsx

Total budgeted payment for inventory requirement d

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

Total Budgeted Payment for Inventory $ - $ - Requirement D Total Cost of Direct material Used Beginning Inventory $ 874 Add: Purchase $ 13,800 Less: Ending 400*4.46 $ 1,784 Cost of Direct Material used $ 12,890 Requirement E Cost of ending Direct Material ending Units 400 Pounds Per Pound Rate 4.46 Cost of Ending Inventory 1784 Requirement F Direct Labor Cost Budget Catillac Dogerati Budgeted Production Units 600 225 Budgeted Hours Need for per unit of output 3.00 5.00 Total Hours Needed 1,800 1,125 Per Hour Cost $ 14 $ 14 Budgeted Direct Labor Cost $ 25,200 $ 15,750 Requirement E Manufacturing overhead budget Catillac Dogerati Variable Overhead $ 3 Per lt $ 1,800 $ 675 Fixed Manufacturing Overhead: Depreciation $ 6,000 $ 6,000 Other Cost $ 10,860 $ 10,860 Total Manufacturing Overhead $ 18,660 $ 17,535 Less Non Cash-Dep $ 6,000 $ 6,000 Cash Disbursment for Manu Ovh $ 12,660 $ 11,535 Budgeted Direct Labor Hours Overheaed Rate per Labor Hour Requirement F Selling and Administrative Budget Catillac Dogerati Supplies 2% of Sale $ 2,030 $ 1,320 Salaries $ 8,000 $ 8,000 Rent $ 4,800 $ 4,800 Insurance $ 1,950 $ 1,950 Depreciation $ 2,000 $ 2,000
Image of page 2

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

Total Selling and Admin Expense $ 18,780 $ 18,070 Less: Non Cash $ 2,000 $ 2,000 Cash disbursment for Selling and Admin $ 16,780 $ 16,070 Requirement G Cash Budget Catillac Dogerati
Image of page 3
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.
  • Fall '18
  • Soni
  • Balance Sheet, raw material, Total Budgeted Sale

{[ 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