Reference no: EM13948510
The owner of a small mining supply company has requested a cash budget for June. After examining the records of the company, you find the following:
a. Cash balance on June 1 is $345.
b. Actual sales for April and May are
| |
April
|
May
|
|
Cash sales
|
$ 10,000
|
$15,000
|
|
Credit sales
|
25,000
|
25,000
|
|
Total sales
|
$35,000
|
$40,000
|
c. Credit sales are collected over a three-month period: 50 percent in the month of sale, 30 percent in the second month, and 15 percent in the third month. The sales collected in the third month are subject to a 1.5 percent late fee, but only half of the affected customers pay the late fee, and the owner does not think it is worth his while to try to collect from the other half. The remaining sales are uncollectible.
d. Inventory purchases average 60 percent of a month's total sales. Of those purchases, 40 percent are paid for in the month of purchase. The remaining 60 per- cent are paid for in the following month.
e. Salaries and wages total $8,700 a month, including a $4,500 salary paid to the owner.
f. Rent is $1,200 per month.
g. Taxes to be paid in June are $5,500.
The owner also tells you that he expects cash sales of $20,000 and credit sales of $30,000 for June. There is no minimum cash balance required. The owner of the company does not have access to short-term loans.
Required
1. Prepare a cash budget for June. Include supporting schedules for cash collections and cash payments.
2. Did the business show a negative cash balance for June? Assuming that the owner has no hope of establishing a line of credit for the business, what recommendations would you give the owner for dealing with a negative cash balance?
|
Income statement for last month
: Ark Corporation's contribution format income statement for last month
|
|
Prepare all journal entries
: Prepare all journal entries, consistent with GAAP, including budgetary and encumbrance entries that the department should make in 2015.
|
|
Describe the problem and present the data
: The financial team has assembled to review labor data for a new engine. Designed for efficiency, the new engine's power to weight ratio and low drag geometry promised great things. Dashiell kicked off the meeting. "Folks, this is radical. For the ..
|
|
Convenient way to document a system events
: A use case is a convenient way to document a system's events. It serves as a kind of table of contents for the business events and activities that must be supported by the system. It will be used to identify how the system will be used and which a..
|
|
Did the business show a negative cash balance for june
: Did the business show a negative cash balance for June? Assuming that the owner has no hope of establishing a line of credit for the business, what recommendations would you give the owner for dealing with a negative cash balance?
|
|
Determine the speed and direction of the wind
: A car is traveling north along a straight road at 50 km>h. An instrument in the car indicates that the wind is coming from the east. If the car's speed is 80 km>h, the instrument indicates that the wind is coming from the northeast. Determine the..
|
|
Difference between the 2 graphics
: It is the business that has the knowledge about their entities (things of importance) and what kind of unique information that separate them (invoice numbers, customer IDs, and so on).
|
|
Determine velocity and acceleration of end of cord
: The cord is attached to the pin at C and passes over the two pulleys at A and D. The pulley at A is attached to the smooth collar that travels along the vertical rod. Determine the velocity and acceleration of the end of the cord at B if at the ins..
|
|
What is the population mean you are trying to estimate
: Suppose you are trying to estimate the average miles per gallon for a new brand of car. You take a random sample of 40 cars, and, for this sample, the average miles per gallon is 32 and the standard deviation for this sample is 2.2. Answer the fol..
|