View the step-by-step solution to:

""One-more Coffee Co. (OCC) is in the process of preparing the budget for the third quarter of 2012. The following data has been gathered:

""One-more Coffee Co. (OCC) is in the process of preparing the budget for the third quarter of 2012. The following data has been gathered:

 Account balances as of June 30

Cash $ 20,000
Accounts receivable 15,000
Inventory 47,250
Building and Equipment 200,000
Accounts payable -0-

 Recent and forecasted sales

May (actual sales) $ 75,000
June (actual sales) 80,000
July (budgeted sales) 82,000
August (budgeted) 90,000
September (budgeted) 100,000
October (budgeted) 112,000

 Sales are 75% cash and 25% on credit. Credit amounts are all collected within the month after sale.

 OCC’s gross margin averages 40% of revenues.

 Operating expenses – all are paid before the end of the month.

Salaries and wages $8,000 per month plus 5% of revenue as commissions
Rent and property taxes $1,000 per month
Other operating expenses 2% of revenues
Depreciation $1,000 per month

 OCC has no minimum inventory requirement. Their policy is to purchase on the 15th of each month the amount needed for the next month’s expected sales.

 OCC Is negotiating the purchase of new equipment that will cost $127,000 and be installed in September. Terms are 50% to be paid in August and the rest in September.

 The minimum cash balance required is $20,000. If needed, cash is borrowed as of the beginning of the month and all repayments are made when possible at the end of the month. The interest rate charged on these short-term borrowings is 12% per year, payable at the end of the month. Both borrowings and repayments are made in multiples of $1,000. Management does not want to borrow more cash than is necessary for operations.

a. Prepare the following schedules and budgets:
• Cash Budget (with budgeted financing)
Sign up to view the entire interaction

Top Answer

Dear Student Please find... View the full answer

Accounting-8095785.xls

Collections Sales
July
August
September
October 82,000
90,000
100,000
112,000 Gross Profit ost of sales
C
Purchases
32,800
36,000
40,000
44,800 49,200
54,000
60,000
67,200 Inventory
Beginning...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online