Reference no: EM13962984
Cash flow exercise-
Joseph Pharmacy had sales of $25,000 in December and $30,000 in January. The company expects sales of $20,000 in February and $40,000 in both March and April, and $30,000 in May. The company has no other source of cash inflows. Half of the sales are paid for with cash. Twenty-five percent are paid for in each of the two months following the sale.
Joseph Pharmacy has the following expenses: (show all of your work)
· Monthly rent of $1,500
· Wages of $5,000 each month
· Purchases
50% of next month's sales
Cash Outlay
20% in month purchased
80% in following month
From the information provided:
1. Calculate the projected Cash Receipts for the three months of February, March, and April (Tables have been set up for you)
|
Sales forecast
|
December
|
January
|
February
|
March
|
April
|
|
Cash Sales
|
|
|
|
|
|
|
Collection of AR:
Lagged 1 Month
Lagged 2 Months
|
|
|
|
|
|
|
Other Cash Receipts
|
|
|
|
|
|
|
Total Cash Receipts
|
|
|
|
|
|
2. Calculate the projected Cash Disbursements for the same months
A Schedule of Projected Cash Disbursements for Joseph Pharmacy
|
Sales
|
December
|
January
|
February
|
March
|
April
|
|
Purchases
(50% of last month's sales)
|
|
|
|
|
|
|
Rent payments
|
|
|
|
|
|
|
Wages/Salaries
|
|
|
|
|
|
|
Total
|
|
|
|
|
|
3. Indicate what the total cash balance would be at the end of these three months if the cash balance at the beginning of February was $1,500.
|
February Cash balance
|
|
|
|
|
|
|
Total Cash Receipts
|
December
|
January
|
February
|
March
|
April
|
|
Cash Disbursements
|
|
|
|
|
|
|
Balance
|
|
|
|
|
|
|
Balance from Feb - April
|
|
|
|
|
|
4. Define cash inflows and cash outflows
5. If I have a budget where expected gross receipts are what is obtained in #1 and my expected cash disbursements are what is obtained in #2. What can you tell me about the cash balance (obtained in #3) if you were doing a variance analysis?
6. What is a cash budget, a flexible budget, CAPEX, and OPEX?
7. How often do you use some form of budgeting? Why?
8. If the business world is allowed to explain away their variances to budget, why is budgeting so important?
|
Maximize exposure of commericals
: How much morning, afternoon, and everning advertising time should Excelsior buy to maximize exposure of its commericals.
|
|
Does this induced current run clockwise or counterclockwise
: Give a counterexample to show that the following statement is false: "When the magnetic field through a loop changes, currents run in the loop in such a way as to make a new magnetic field in the opposite direction to the original one."
|
|
What is the maximum storage capacity
: He has only $66 to spend and the office has room for no more than 60 square feet of cabinets. (Find the Objective Function and the Constraints; Let Cabinet A be "x", and Cabinet B be "y") How many of each can be bought to maximize storage capacity..
|
|
Find the frequency f, of her scream
: While she is above him, he receives her scream as frequency fA, and after she passes him he receives frequency fB, which is 96 cy/sec less than fA. Exactly t= 3.6 seconds after she passes him he hears the sound of her arrival as she splashes into ..
|
|
Calculate the projected cash receipts for the three months
: Joseph Pharmacy had sales of $25,000 in December and $30,000 in January. The company expects sales of $20,000 in February and $40,000 in both March and April, and $30,000 in May. Calculate the projected Cash Receipts for the three months of F..
|
|
What are minimium frequencies heard by a stationary observer
: A Battery-operated toy emites a signal at 1800Hz. It moves in a circle of a radius 1.2 m at 2.4 revolutions per seconds. What are the minimium and maximum frequencies heard by a stationary observer some distance away in the plane of the circle?
|
|
Conduct a literature search of a recent article
: conduct a literature search of a recent article on breach and remedies. The article may be obtained from any source.
|
|
Number of regular and king size pills
: Determine the least number of regular and king size pills he should prescribe to meet those requirements.
|
|
Identifying feasible region and potential optimal solutions
: a) Formulate a linear program with objectives and constraints and clearly identify all variables and constraints. b) Graph this program identifying the feasible region and potential optimal solutions. c) What is the optimal combination of trucks that..
|