Reference no: EM13862936
This assignment will require you to prepare the cash budget and determine the cash surplus and shortage each month.
The management estimates total sales for the period January through July based on actual sales from the immediate past quarter. The following assumptions are made:
Sales: Past and Expected
|
Historical
|
Forecast
|
|
October
|
$300,000
|
January
|
$150,000
|
|
November
|
$350,000
|
February
|
$200,000
|
|
December
|
$400,000
|
March
|
$200,000
|
|
|
|
April
|
$300,000
|
|
|
|
May
|
$250,000
|
|
|
|
June
|
$200,000
|
|
|
|
July
|
$300,000
|
a. Sales are 75% on credit basis and 25% on cash basis. 60% of credit sales are collection one month after sale, 30% in the second month, and 10% in the third month. Bad debts are insignificant.
b. Purchases are 80% of sales and are paid as follows: 50% of sales are paid in the same month and the remaining 50% are paid in the following month.
c. Wages and salaries are as follows:
|
January
|
$30,000
|
|
February
|
$40,000
|
|
March
|
$50,000
|
|
April
|
$50,000
|
|
May
|
$40,000
|
|
June
|
$35,000
|
d. Rent is $2,000 per month
e. Interest on $500,000 of 16% bonds is due on the calendar quarter.
f. A tax prepayment of $50,000 is due in April.
g. A capital addition of $30,000 is planned in June.
h. The company has a cash balance of $100,000 on January 1st, which is the minimum balance maintained each month.
1. Prepare cash budget for Jan to June.
2. Determine the cash surplus and shortages for each month.
|
Estimate the average daily pollution in lake erie
: Suppose that we wish to estimate the average daily pollution in Lake Erie. The daily yield, recorded for n = 50 days, produced a mean and standard deviation equal to y = 871 tons and s = 21 tons, respectively.
|
|
Define the following predicate p(x,y,z) for naturals x and y
: Define the following predicate P(x,y,z) for naturals x and y and positive naturals z. If x = z, then P(x,y,z) is false.
|
|
Evaluate the various persuasive forms of leadership
: Evaluate the various persuasive forms of leadership.
|
|
How tall is the flag pole to the nearest foot
: You place a mirror on the ground 100ft away from a flag pole, You then back up from the mirror until you see the top of the flag pole in the mirror. If the distance from your eyes to the ground is 5 ft and you are standing 14ft from the mirror, how t..
|
|
Prepare cash budget for jan to june
: Prepare cash budget for Jan to June - determine the cash surplus and shortages for each month and the company has a cash balance of $100,000 on January 1st, which is the minimum balance maintained each month.
|
|
What type of anemia does ms a most likely have
: Considering the circumstances and the preliminary workup, what type of anemia does Ms. A most likely have? In an essay of 500-750 words, explain your answer and include rationale.
|
|
About state government levy tariffs on imports
: State Government Levy Tariffs on Imports
|
|
Amount of dissolved oxygen
: Industrial wastes and sewage dumped into our rivers and streams absorb oxygen and thereby reduce the amount of dissolved oxygen available for fish and other forms of aquatic life.
|
|
Write paper about topic the dance and still life with dance
: Write a three page term paper analyzing the topic "The Dance" and "Still Life with Dance" by Henri Matisse. Your paper must be written to the thesis proposed.
|