Explore BrainMass

# Application of Accounting Principles - Juan's Taco Company

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

I am stuck and need help with the following problem:
Problem P4-20 Chapter 4, Block & Hirt, Finance and Accounting 11th edition

Juan's Taco Company has restauraunts in five college towns. Juan wants to expand into Austin and College Station and needs a bank loan to do this. Mr. Bryan, the banker, will finance construction if Juan can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures:

Actual & Forecast
November \$120,000
December \$140,000
January \$190,000
Februry \$210,000
March \$230,000
April \$230,000

Of Juan's sales, 30% are cash and the remaining 70% are credit. Of credit sales, 40% are paid in the month after sale, and 60% are paid in the second month after the sale. Materials cost 20% of sales and are paid for in cash. Labor is 50% of sales and is also paid in the month of sales. Selling and administrative expense is 5% of sales and is also paid the month of sales. Overhead expense is \$12,000 and dividends of \$16,000 will be paid in March. Cash at the beginning of January is \$70,000 and the minimum desired cash balance is \$65,000.

For January, February and March, prepare a schedule of monthly cash reciepts, mothly cash payments, and a complete monthly cash budget with borrowings and repayments.

#### Solution Preview

January receipts:
60% of 70% of November's sales = .6*.7*120000=50400
40% of 70% of December's sales = .4*.7*140000=39200
30% of January sales = .3*190000 = 57000
Total = 146600
January payments:
materials = 20% of sales = .2*190000=38000
labor = 50% of sales = .5*190000=95000
selling&administrative = 5% of sales = ...

#### Solution Summary

This uses the example of a restaurant to present a three-month financial plan.

\$2.19