Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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. OCCs 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 months 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 Receipts

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

9th edition

1-119-49356-3, 1119493633, 1119493560, 978-1119493631

More Books

Students also viewed these Accounting questions

Question

=+a) Fit a regression model with just Year as the predictor.

Answered: 1 week ago

Question

Keep your head straight on your shoulders

Answered: 1 week ago

Question

Be straight in the back without blowing out the chest

Answered: 1 week ago

Question

Wear as little as possible

Answered: 1 week ago