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 Disbursements for Purchases
Sign up to view the entire interaction

Top Answer

Dear Student Please find... View the full answer

Accounting-8089869.xls

One-more Coffee Co.
If gross margin is 40% of revenues, the cost of goods is 60% of sales.
Cash disbursements for purchases - Schedule
July
Expected Sales
$82,000
Cost of goods (at 60%)
$49,200...

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