Equipment 17000 Total Payments 162540 107778 100144 Financing Activities

Equipment 17000 total payments 162540 107778 100144

This preview shows page 5 - 10 out of 12 pages.

Equipment $17,000 Total Payments $162,540 $107,778 $100,144 Financing Activities: Surplus (Shortage) $31,260 $79,342 $68,908 Borrowing (repayment) $19,000 ($29,000) $0 Ending Balance $50,260 $50,342 $68,908 Debt 31-Dec 10,000 Borrowed Jan $19,000 Jan 31 Balance $29,000 Repaid Feb ($29,000) Feb 28 balance $0
Image of page 5

Subscribe to view the full document.

March 2,200 1,500 550 9,850 510 600 500 1,370 $14,880.00 $13,380.00
Image of page 6
Sales Forecast Batches January 10,000 February 12,000 March 9,000 April 8,000 May 10,000 June 11,000 Sales Price $12 What is the sales budget for each month of Qtr 1? January February March Total Budgeted Sales For Qtr Sales made in cash 65% Sales made store credit 35% Collections Current Month 15% Next Month 85% Sales Budget December 200,000 Cash Receipts January February March Cash Sales Cash Collections Current Month Previous Month Total Collections Forecast Units Unit Selling Price Budgeted Sales
Image of page 7

Subscribe to view the full document.

PRODUCTION BUDGET EXAMPLE Desired End Inv 20% January February March April Sales Desired Ending Inventory Total Needs Less Beginning Inventory Units to be Produced Purchase Budget Desired raw material ending inventory 10% of next months production needs Standards bags per batch 1 cost per bag $4.00 January February March April Units to be produced Material inputs required per output unit Material units needed for production January February March Material Units Needed for Production Desired ending material units Total needs Beginning material units Number of material units to be purchased Material unit purchase price Cost of material units to be purchased All purchases are on credit Current Month 30% paid Next Mondy 70% paid December's purchases $96,000 January February March Current Month Last Month Direct Labor Budget
Image of page 8
Std Hours 0.25 per batch Std Rate $8.00 per hour January February March Units to be produced Standart hours allowed Total hours allows Average wage rate Direct labor cost Direct Labor is paid as incurred. Create a Cash Payment Schedule January February March Current Month Overhead Budget The variable portion is based on DL hours January February Estimated DL Hours Value of Fixed Variable Depreciation 1500 0 Indirect Material 0 0.25 Indirect Labor 6000 1.75 Utilities 400 0.05 Property Tax 600 0 Insurance 500 0 Maintenance 600 0.35 Total Cost $9,600.00 $2.40 Total Cost Net of Depreciation All cost are paid as incurred Cash Payments January February March
Image of page 9

Subscribe to view the full document.

Image of page 10
  • Spring '16

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

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes