Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Miele Resort has just hired you to work in the accounting department, a popular year-round family oriented vacation destination. One of your first tasks is

image text in transcribed
Miele Resort has just hired you to work in the accounting department, a popular year-round family oriented vacation destination. One of your first tasks is to prepare a cash budget for Coffee Comer (CC) for the month of July. CC is a specialty coffee shop for vacationers at the resort. You have been told that CC requires a minimum cash balance of $5,000 at the beginning of each month. You have also been given the following information to help with your budget. a) CC has an agreement with the bank that allows it to borrow short-term operating funds in increments of $1,000 at an interest rate of 8% per year. Borrowing occurs on the first day of the month and repayment in $1,000 increments, along with any interest on the funds repaid, occurs on the last day of the month. No other cash transactions occur on these days. b) June sales were $130,000. July sales are budgeted to be $120,000. 15% of sales are cash; the remainder is on account. 70% of credit sales are typically received in the month of the sale, with 26% received in the following month. The rest is uncollectible and must be written off in the month following the sale. c) Food purchases for CC were $98,000 in June and are expected to be $83,000 in July. All purchases are on account. CC pays 25% in the month of purchase and 75% in the following month. d) Most of the CC work is done by Mrs. Roaster, who typically withdraws a monthly salary of $8,000 from the business. Various part-time staff who work in the CC are paid a total of $14,400 per month. All part-time workers are paid weekly, with 90% of their wages paid in the month incurred and the remaining 10% paid in the following month. e) The monthly cash payment for utilities is $5,200 and for supplies is $3,600. Monthly depreciation on the building is $2,000. () Insurance of $300 per month is paid quarterly; the next payment is due on July 15. g) Although May had ended with a deficit of $4,500, by the June 30 CC had a positive cash balance of $5,680. Required: Prepare a cash budget in good form for the month of July. If the August 31 cash balance was $35,000, would there be any August transactions with the bank related to borrowing? If so, please provide details of any amounts. If not, please explain why

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

Accounting What The Numbers Mean

Authors: David Marshall, Wayne McManus, Daniel Viele

10th Edition

77729870, 9780077729875

More Books

Students also viewed these Accounting questions

Question

What is phishing?

Answered: 1 week ago

Question

Briefly describe the three major measures of the price level.

Answered: 1 week ago

Question

The number of people commenting on the statement

Answered: 1 week ago

Question

Peoples understanding of what is being said

Answered: 1 week ago