[msnique9504]

Zippy Company prepares monthly cash budgets. Relevant data from operating budgets for 2012 are:



January February
Sales $513,000 $513,000
Direct Material Purchases 141,000 111,000
Direct Labor 105,000 110,000
Manufacturing Overhead 63,000 72,000
Selling and Administrative Expenses 77,000 78,000

All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the month of sale, and 20% in the second month following the month of sale. Fifty percent (50%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the month of purchase. All other items above are paid in the month incurred. Depreciation has been omitted from manufacturing overhead and selling and administrative expenses.



Other data:


1.) Credit sales: November 2011, $220,000; December 2011, $275,000


2.) Purchases of direct material : December 2011, $90,000


3.) Other receipts: January - Collection of December 31, 2011 interest receivable $3,000
February - Proceeds from sale of securities $5,000

4.) Other disbursements: February - payment of $28,000 for land.


5.) The company's cash balance on January 1, 2012, is expected to be $60,000.


Instructions:
1.) Prepare schedules for (a) expected collections from customers and (b) expected payments for direct materials purchases.

[ma0641]

This is not help, this is homework. We will help you clarify but not do. How will you learn with just the answers?

[msnique9504]

This is not homework this is an example to attempt how will I know what to do if I never seen it worked out and the book doesn't show good exapmles to work it out

[kcomissiong]

How about this. Attempt the example and show your work. Post what you did and how you did it. We can't help you to understand the problem if we don't know where you are going wrong. Helping you to understand it isn't doing a problem out of the text and giving you the answer. Its seeing what you are missing and filling in your gaps in knowledge or correcting a step in your technique.

We aren't going to teach you how to do your work and give you examples. That is what your class is for and what your professor gets paid for. We are volunteers. We donate our time and expertise for free to this site, and we can't help you unless you abide by the rules of the site. That means SHOW your work and solutions, and let us know where in your work you need help. It also means not rating other members unhelpful because they are abiding by the terms of the site. If you would like help, please do what we have asked and SHOW your work, and someone can help you where you are going wrong.

[pready]

Start with the sales budget.