Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Schedule of expected cash collections

10/11/2021 Client: muhammad11 Deadline: 2 Day

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 Disbursem

COURSE PROJECT 1 INSTRUCTIONS

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 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. Include the following detailed budgets:

1.

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.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Academic Tutor
Homework Tutor
Top Rated Expert
Math Exam Success
Accounting & Finance Master
George M.
Writer Writer Name Offer Chat
Top Academic Tutor

ONLINE

Top Academic Tutor

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$20 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$28 Chat With Writer
Top Rated Expert

ONLINE

Top Rated Expert

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$15 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$41 Chat With Writer
Accounting & Finance Master

ONLINE

Accounting & Finance Master

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$28 Chat With Writer
George M.

ONLINE

George M.

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$22 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Criminal Acts in Security - Www pearsonclinical com psychology products - Bus/475 - Australian journal of basic and applied sciences - Tcp ip failure eftpos - According to crittendon’s model, infants encode early experiences of care-giving in the form of - Turabian book review - What i have learned so far - Aida model was developed by - Splitting field of irreducible polynomial - Dalgety bay primary school - Reflection paper on self assessment - Logic models - Compound sentences about friendship - How many isomeric forms can chloroethylene c2h3cl have - Multiple constructor in a class in c++ - Caleffi backflow preventer 573 - White Collar, Political, and Organized Crime - Business law assignment 1 - human trafficking - Is the yellow wallpaper gothic - Aem boost gauge 30 4406 install - Due today...... 8 hours...... please read....... sociology 1-2 pages... - Components of equity theory - Data Mining - Arts - Thomas gordon 12 roadblocks - Job sites for teens - Leadership themes in the new testament - Leclerc loom tie up - Assignment on white collar crime - Cms intact medical terminology - Construction of galvanic cell - Each student will write a research paper on an organization of his or her choice (5-7 pages). The organizational analysis will utilize a minimum of five external, peer-reviewed academic sources and contain the following sections: - When the weather reflects the mood - Www purplemath com modules slope htm - Rachel carson a fable for tomorrow worksheet answers - Root word meaning cell - The art of public speaking chapter 4 - A crate is supported by three cables as shown - 3 Page Nursing APA Essay - 3 8 40 tap drill size - Hrm incident 1 i feel great - Apple company profile presentation - Argumentative essay about food - Single phase line reactor - Kraft australia case analysis answers - After hours doctor moonah - Liberal arts lenses chart - Clive peeters richmond store - Globalization discussion questions - Examples of professional development in nursing - Iprocrastinate app download mac - Justine petersen housing and reinvestment corporation - The other wes moore full text - SOCW 6111 - HA575 Unit 9 Discussion - I need 600 words case study in "Problem Statement and goal statement" - Project Observation Assignment: Cognitive Development - Review document and answer questions in detail, no plagiarism. - Science syllabus stage 5 - Alice dreger is anatomy destiny - Auxochrome in uv spectroscopy - Sarbanes oxley act powerpoint presentation - What effect does creativity have on society and culture - Catalase and hydrogen peroxide experiment surface area - Essentials of sociology george ritzer 2nd edition pdf - Letter of Intent - Heart of darkness quotations - Database redesign is fairly easy when ________ - Compatibility and segregation chart - Her scars creed fisher lyrics - 10.2 graphing square root functions answers - Gun lane medical centre - Blockchain technology - Qnt 561 week 1 practice problems - Telstra shared data sim - Kool aid concentration lab answers - Cation and anion formula - Pico questions for stroke patients - Billed customers for fees earned for managing rental property - Marketing - Sheffield hallam student record - On the loan worksheet in cell c9 - Week 10 Discussion - Cultural intelligence the essential intelligence for the 21st century - HSA5300-Deliverable 3 - Locating Data Sources and Sets for Population Health Management - Dr heng wee soon - Position paper environmental issues - Technopoly - Literature review class exercise - My Sister's Keeper: Ethics Paper - Characteristics of adulthood ppt - The donaldson company uses a job order costing system - Argumentative Essay Help - Afsl tier 1 products - Srs document example for airline reservation system - Peer response - Applied medical clip applier - Lake press distribution pty ltd