Reference no: EM131164108
You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets to various retail outlets across the country. The company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash.
You have decided to prepare a cash budget for the upcoming fourth quarter in order to show management the benefits that can be gained from proper cash planning. You have worked with accounting and other areas to gather the information assembled below.
The company sells many styles of bracelets, but all are sold for the same $10 price. Actual sales of bracelets for the last three months and budgeted sales for the next six months follow:
July (actual)20,000
August (actual)26,000
September (actual) 40,000
October (budget) 70,000
November (budget) 110,000
December (budget) 60,000
January (budget) 30,000
February (budget) 28,000
March (budget) 25,000
The concentration of sales in the fourth quarter is due to the Christmas holiday. Sufficient inventory should be on hand at AND SO ON
REQUIRED:
1. Prepare a cash budget for the three-month period ending December 31. Include the following detailed budgets:
a. A sales budget, by month and in total.
b. A schedule of expected cash collections from sales, by month and in total.
c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total.
d. A schedule of expected cash disbursements for merchandise purchases, by month and in total.
2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $50,000.
|
Write equation of line that passes through the point
: Write the equation of the line that passes through the point (5,-5) and has a slope of m=-5. Write the equation in slope intercept form.
|
|
Use chain-weighted index to report inflation
: The Federal Reserve policymakers prefer to use a chain-weighted index to report inflation because: The money aggregate M1 includes each of the following, EXCEPT:
|
|
What is the 4th number in the sequence
: 1) A brick wall has 60 bricks in the bottom row but each row has 3 fewer bricks than the previous one. How many bricks are in the 12th row? 2) If you have an arithmetic sequence, the first number is 2 and the common difference is 4, what is the 4..
|
|
Calculate the aerodynamic drag
: Calculate the aerodynamic drag, the rolling resistance according to SAE equations and the road load horsepower at this conditions
|
|
Prepare cash budget for three-month period ending december
: Prepare a cash budget for the three-month period ending December 31. Include the detailed budgets: A sales budget, by month and in total. A schedule of expected cash collections from sales, by month and in total.
|
|
Geometric sequence that has four geometric
: Write the geometric sequence that has four geometric means between 1 and 7,776? Find the sum of the first 40 terms of the arithmetic series: -5, -4, -3, -2, -1, ?
|
|
Define production possibility frontier
: Define production possibility frontier; state the conditions require for its construction and show how it is constructed. State the basic properties.
|
|
Four arithmetic means
: Write the arithmetic sequence that has four arithmetic means between -20 and 20?
|
|
What is performance
: What is performance? - What factors influence an employee's level of performance?
|