Total estimated cash receipts preparing an inventory

This preview shows page 2 - 4 out of 4 pages.

Total estimated cash receipts Preparing an inventory purchases budget & cash payment schedule Exercise 14-7 Naftel Company sells lamps and light fixtures. The purchasing department manager prepares the following inventory purchases budget. The goal is to maintain an ending inventory budget equal to 10% of the following months COGS. April is budgeted to have COGS of $75,000 January February March 14-2
Image of page 2

Subscribe to view the full document.

Chapter 14 - Planning for Profit and Cost Control Budgeted COGS 50,000 54,000 60,000 Plus desired ending inventory 5,400 60,000*.1 = 6,000 7,500 Inventory needed 55,400 60,000 67,500 Less Beginning inventory 5,000 5,400 6,000 Required purchases 50,400 55,600 61,500 Preparing the cash payments schedule for inventory purchases: Assume from above that 80% of purchases are made in the month of purchase and 20% are made the following month. Figure out February cash payments 55,600*.80 + 50,400*.20 = 54,560 cash payments in february Preparing a selling and administrative budget These are the facts that we currently know. Sales for January are estimated at $400,000 Salary Expense (Fixed) $24,000 Sales Commissions 5% of Sales Supplies Expense 2% of Sales Utilities (Fixed) $ 1,400 Depreciation on Center Equipment (Fixed)* $ 750 Rent (Fixed) $ 3,600 Miscellaneous (Fixed) $ 900 24,000 + (.05*400,000) + (.02*400,000) + 1,400 + 750 + 3,600 + 900 = 58,650 Preparing a cash budget Cash budget has 3 main sections: 1. Cash receipts 2. Cash payments (disbursements) 3. Financing section (Do I need to borrow money!) Exercise 14-13 14-3
Image of page 3
Chapter 14 - Planning for Profit and Cost Control The accountant for Teresa's Dress Shop prepared the following cash budget. Teresa's desires to maintain a cash cushion of $14,000 at the end of each month. Funds are as-
Image of page 4
You've reached the end of this preview.
  • Fall '12
  • Cohen
  • Cash Budget, budgeting process, cash Budget Cash

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