Question
Mary Jones is president of Jones Nurseries, Inc. This company has four locations and has been in business for six years. Each retail location offers
Mary Jones is president of Jones Nurseries, Inc. This company has four locations and has been in business for six years. Each retail location offers over 300 varieties of plants and trees. Sam Lilly, the controller, has been asked to prepare a cash budget for the first quarter.
Projected data supporting the budget are summarized below. Collection history for accounts receivable has shown that 30% of all credit sales are collected in the month of the sale, 60 percent in the month following the sale, and 8 percent in the second month following the sale. Two percent of the credit sales are noncollectable. Purchases are all paid for in the month following the purchase. As of December 31, the company had a cash balance of $9,600.
Jones Nurseries | ||||
Sales | Purchases | |||
November | 160,000.00 | |||
December | 200,000.00 | 86,800.00 | ||
January | 120,000.00 | 124,700.00 | ||
February | 160,000.00 | 99,440.00 | ||
March | 140,000.00 | 104,800.00 |
Salaries and wages are projected to be $25,200 in January, $33,200 in February, and $21,200 in March. Monthly costs are estimated to be; utilities $4,220, collection fees $1,700, rent $5,300, equipment depreciation $5,440, office supplies $2,480, shop supplies $3,140, and miscellaneous $1,900. Assume monthly costs are paid in the month in which they occurred.
Required:
- Prepare a cash budget for the first quarter.
- Should Jones anticipate taking out a loan during the first quarter? How much should be borrowed and when? Note that management maintains a minimum cash balance of $6,000 at all times.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started