Reference no: EM131129595
Assignment 1: LASA 2-Cash Management and Budgeting
The new owner of Bob's Boats, Bob, just purchased the business and discovered that the prior owner did not have a plan for managing the current assets of the company. Bob has decided that the place to start is with a cash budget, using the template he used in his prior position.
Bob has requested that you to complete the cash budget given the data that he has already retrieved from the company's records and from his own analysis.
Table-1:
|
Sales Forecast for the next 9 Months
|
|
Month
|
Sales
|
|
January
|
$ 162,000.00
|
|
February
|
$ 168,000.00
|
|
March
|
$ 324,000.00
|
|
April
|
$ 485,000.00
|
|
May
|
$ 648,000.00
|
|
June
|
$ 325,000.00
|
|
July
|
$ 325,000.00
|
|
August
|
$ 80,000.00
|
|
September
|
$ 162,000.00
|
Collections on receivables have historically been collected as follows and this pattern is expected to continue:
• 12% in the Month of Sale
• 60% in the month following the Sale
• 28% in the Second Month after the Sale
Bob pays for the labor and materials in the month after they are incurred. Bob has also compiled the following information on expenses for the upcoming nine month period:
Table-2:
|
Month
|
Labor and Materials Expense
|
Administrative Salaries
|
Depreciation Charges
|
Income Taxes
|
Lease Payments
|
Miscellaneous Expenses
|
|
January
|
$ 80,000.00
|
$ 25,000.00
|
$ 34,500.00
|
-
|
$ 8,500.00
|
$ 3,000.00
|
|
February
|
$ 80,000.00
|
$ 25,000.00
|
$ 34,500.00
|
-
|
$ 8,500.00
|
$ 3,000.00
|
|
March
|
$ 114,000.00
|
$ 25,000.00
|
$ 34,500.00
|
-
|
$ 8,500.00
|
$ 3,000.00
|
|
April
|
$ 794,000.00
|
$ 25,000.00
|
$ 34,500.00
|
-
|
$ 8,500.00
|
$ 3,000.00
|
|
May
|
$ 275,000.00
|
$ 25,000.00
|
$ 34,500.00
|
$ 58,500.00
|
$ 8,500.00
|
$ 3,000.00
|
|
June
|
$ 210,500.00
|
$ 25,000.00
|
$ 34,500.00
|
-
|
$ 8,500.00
|
$ 3,000.00
|
|
July
|
$ 146,000.00
|
$ 25,000.00
|
$ 34,500.00
|
-
|
$ 8,500.00
|
$ 3,000.00
|
|
August
|
$ 80,000.00
|
$ 25,000.00
|
$ 34,500.00
|
$ 58,500.00
|
$ 8,500.00
|
$ 3,000.00
|
|
September
|
$ 81,000.00
|
$ 25,000.00
|
$ 34,500.00
|
-
|
$ 8,500.00
|
$ 3,000.00
|
Bob has also identified a cash payment of $175,000 upon completion of a new boat dock in July. As of March 1st, the company now has $125,000 in cash on hand and would like to maintain a minimum cash balance of $85,000 at all times.
Required:
1. Prepare a Schedule of Collections and Payments for the six month period beginning in March, using the template provided and the data above.
2. Prepare a Schedule of Cash Gains and Losses by month for the six month period beginning in March, using the template provided and the data above.
3. Prepare a Schedule of Cash Surplus or Shortages by month for the six month period beginning in March, using the template provided and the data above.
4. Prepare a schedule of Net Cash Flow by month for the six month period beginning in March, using the template provided and the data above indicating the timing and amounts that must be borrowed or the amounts that can be re-invested or used in the firm.
5. Based on the information in the reports you constructed above would you recommend any changes in the credit policy of the firm? If so, what would they be? Explain your answers.
|
What consumers primarily look for in products
: Jason is a marketing researcher working for a client who believes that social class will be an important segmenting device. Jason decides to find social class categories by simply asking respondents to pick their own category. Which of the followi..
|
|
Draw a block diagram of the realization with an integrator
: A student has computed det C = 2.3 × 10 -7 and claims that the system is uncontrollable. Is the student right or wrong? Why?
|
|
Answer the questions about self employment tax
: 27. Self-Employment Tax George has $71,300 in salary from his full-time position and $43,000 in net income in 2010 from his sole proprietorship. What must he pay for self-employment tax? What portion of this can he deduct?
|
|
A rectangular system of coordinates with its origin
: A sharpshooter is aiming at a circular target with radius 1. If we draw a rectangular system of coordinates with its origin at the center of the target, the coordinates of the point of impact, (X, Y), are random variables having the joint probabi..
|
|
Prepare a schedule of net cash flow for the six month
: Prepare a schedule of Net Cash Flow by month for the six month period beginning in March, using the template provided and the data above indicating the timing and amounts that must be borrowed or the amounts that can be re-invested or used in the ..
|
|
Approximated closely with the joint probability density
: Suppose that P, the price of a certain commodity (in dollars), and S, its total sales (in 10,000 units), are random variables whose joint probability distribution can be approximated closely with the joint probability density
|
|
Find the transfer function of the system
: This problem is intended to give you more insight into controllability and observability. Consider the circuit in Fig. 7.92, with an input voltage source u(t) and an output current y(t).
|
|
Glassware violated which of the following provision of act
: Glassware does not offer this discount to any of its other customers. Windoze accepts the offer, and as a result, a substantial number of small glass producers start exiting the market. Glassware violated which of the following provision(s) of the Cl..
|
|
What is the largest possible volume of a rectangular parcel
: According to postal regulations, the girth plus the length of a parcel may not exceed 108 in. What is the largest possible volume of a rectangular parcel with two square sides that can be sent
|