For january february and march prepare a schedule of

Reference no: EM13614232

Juan's Taco Company has restaurants in five collegetowns. Juan wants to expand into Austin and College Stationand needs a bank loan to do this. Mr. Bryan, the banker, willfinance construction if Juan can present an acceptable three-monthfinancial plan for January through March. The following are actualand forecasted sales figures:

Actual	Forecast	AdditionalInformation
November $120,000	January $190,000	Aprilforecast $230,000
December 140,000	February 210,000
	March 230,000

Of Juan's sales, 30 percent are for cash and the remaining70 percent are on credit. Of credit sales, 40 percent are paid inthe month after sale and 60 percent are paid in the second monthafter the sale. Materials cost 20 percent of sales and are paid forin cash. Labor expense is 50 percent of sales and it'spaid in the month of sales. Selling and administrative expense is 5percent of sales and is also paid in the month of sale. Overheadexpense is $12,000 in cash per month; depreciation expense is$25,000 per month. Taxes of $20,000 and dividends of $16,000 willbe paid in March. Cash at the beginning of January is $70,000 andthe minimum desired cash balance is $65,000.

For January, February, and March, prepare a schedule of monthly cash receipts, monthly cash payments, and a complete monthly cashbudget with borrowings and repayments.

Reference no: EM13614232

Questions Cloud

A potential control for managing the risk of employee fraud : a potential control for managing the risk of employee fraud is to send employees on mandatory vacations. explain the

Assume the area of skin on the workers palm that would : the relatively high resistivity of dry skin about 1 x 106 ohms - m can safely limit the flow of current into deeper

Assume all temperatures to be exact and neglect significant : assume all temperatures to be exact and neglect significant figures for small changes in dimension. what volume is

When one experiences a lack of control in ones life does : when one experiences a lack of control in ones life does one compensate by seeking structure elsewhere? assign 36

For january february and march prepare a schedule of : juans taco company has restaurants in five collegetowns. juan wants to expand into austin and college stationand needs

A person throws an object upward with an initial velocity : a person throws an object upward with an initial velocity of 20 ms. assuming that the object has an initial height of

What is the difference between measures and reperated : what is the difference between measures and reperated measures studies. how did we deal with theae differently

Suppose you have described a null hypothesis and set the : suppose you have described a null hypothesis and set the significance value at n.describe what happens to the null

Wally whacko claims to have invented a heat engine that : wally whacko claims to have invented a heat engine that will revolutionize industry. it runs between a hot source at

User Account

All Pages