Prepare a cash budget for the three-month period ending

Assignment Help Accounting Basics
Reference no: EM13966359

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)              20000
August (actual)          26000
September (actual)     40,000        
October (budget)        70000
November (budget)     110000
December (budget)     60000
January (budget)        30000
February (budget)       28000
March (budget)           25000

The concentration of sales in the fourth quarter is due to the Christmas holiday. Sufficient inventory should be on hand at the end of each month to supply 40% of the bracelets sold in the following month.

Suppliers are paid $4 for each bracelet. Fifty-percent of a month's purchases is paid for in the month of purchase; the other 50% is paid for in the following month. All sales are on credit with no discounts. The company has found, however, that only 20% of a month's sales are collected in the month of sale. An additional 70% is collected in the following month, and the remaining 10% is collected in the second month following sale. Bad debts have been negligible.

Monthly operating expenses for the company are given below:

Variable expenses:
Sales commissions                             4% of sales
Fixed expenses:
Advertising                                       $220,000
Rent                                               $20,000
Salaries                                           $110,000
Utilities                                           $10,000
Insurance                                         $5,000
Depreciation                                     $18,000

Insurance is paid on an annual basis, in January of each year.

The company plans to purchase $22,000 in new equipment during October and $50,000 in new equipment during November; both purchases will be for cash. The company declares dividends of $20,000 each quarter, payable in the first month of the following quarter.

Other relevant data is given below:

Cash balance as of September 30                    $74,000
Inventory balance as of September 30             $112,000
Merchandise purchases for September            $200,000

The company maintains a minimum cash balance of at least $50,000 at the end of each month. All borrowing is done at the beginning of a month; any repayments are made at the end of a month.

The company has an agreement with a bank that allows the company to borrow the exact amount needed at the beginning of each month.

The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company will pay the bank all of the accrued interest on the loan and as much of the loan as possible while still retaining at least $50,000 in cash.

Required:

Prepare a cash budget for the three-month period ending December 31. 

1 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. 

Reference no: EM13966359

Questions Cloud

Define locus of control, self-efficacy, and self-esteem : Define locus of control, self-efficacy, and self-esteem. Explain how a manager might deal with each of these personality traits at work. Describe how you would rate yourself on each of these dimensions, and explain why.
What is post traumatic stress disorder : What is post traumatic stress disorder (PTSD)? How does this affect individuals and families? What kinds of treatments and services are available to help war veterans suffering from PTSD? Are these treatments helpful?
What is meant by the term racial profiling : What is meant by the term racial profiling? How has the US war on terrorism influenced the practice of racial profiling? What arguments are there in favor of and against racial profiling?
What are the characteristics of a transformational leader : What are the characteristics of a transformational leader. How do they transform their followers? Select someone that you believe to be a transformational leader, and illustrate your points.
Prepare a cash budget for the three-month period ending : Prepare a cash budget for the three-month period ending December 31. Include the following detailed budgets: A sales budget, by month and in total. A schedule of expected cash collections from sales, by month and in total. A merchandise purchases bud..
Which stand should the company produce : What would be the incremental benefit of obtaining 15 additional labor hours Which stand(s) should the company produce?
Construct a stem-and-leaf display of the data : a. Construct a stem-and-leaf display of the data. b. What is a typical, or representative, ow rate? c. Does the display appear to be highly concentrated or spread out?
Describe the stages of group development : Describe the stages of group development. For each, discuss what questions the individual asks at that stage, and what the leader should do to facilitate it.
Business manager for a medium-sized firm : If you were a business manager for a medium-sized firm, how would you decide where to purchase your indirect inputs – from an e-distributor or an e-procurement Net marketplace?

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  Your portfolio is invested 30 each in a and c and 40 in b

1.state of economynbspis nbspboom probability of state of econmy is.15 nbsprate of return if state occurrs for stock

  What is a relevant cost are variable costs always relevant

what is a relevant cost? are variable costs always relevant costs? choose a company that interests you and identify

  Differences between horizontal, vertical-conglomerate merger

Discuss the differences between horizontal, vertical and conglomerate mergers and how those differ from a joint venture. Prepare a 350- to 1,050- word paper detailing the findings of your discussion.

  Prepare a purchases budget in pounds for july august and

lubriderm corporation has the following budgeted sales for the next six-month period month unit sales june 90000 july

  Journal entries for each transaction of elite electronics

Prepare journal entries for each transaction. a. On August 31, a customer balance for $ 300 from a prior year was determined to be uncollectible and was written off. b. On December 15, the customer balance for $ 300 written off on August 31 was colle..

  Vintage cellars manufactures a 1000-bottle wine storage

evaluating decision-making scenarios using linear profit and cost modelingvintage cellars manufactures a 1000-bottle

  Find the cost per equivalent unit of the transferred units

Find the cost per equivalent unit of the transferred units. Calculate the equivalent units for the Forming Department for the month of August

  Understanding andanalyzing financial statement

understanding andanalyzing financial statement relationships merchandising organization garys tv had the following

  Analysis and research of data security risks

Read the synopsis of the scenario you viewed at the beginning of this module: There is a breach in security and some data has become suspect. All systems need to be evaluated and made secure.

  Explain the rationale for recognizing costs as expenses at

an accountant must be familiar with the concepts involved in determining earnings of a company. the amount of earnings

  What is the break-even point in dollars

Innova Discs has two divisions-Standard and Premium. Each division has hundreds of different types of golf discs and disc golf products. The following information is available:

  What is a capital budget

What is a capital budget? Why should it be prepared for a period greater than one year?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd