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

Assignment 6 - 8 Page Trans Paper Due On Oct 10th - The basic summary device of accounting is the - Qbcc net tangible assets - Cafe socrates fashion valley mall - Health promotion in nursing practice 4th edition - Examples of creating a caring community of learners - What are the three types of family resources - Stage 4 - What's my hawaiian name - Differential scanning calorimetry procedure - Similarities between phenomenological and ethnographic research - Pro rata allotment of shares calculation - The debit side of an accounts receivable account is - Types of database failures - Ob in action case study answers - Digestive system parts and functions quiz - Nurse as knowledge worker infographic - Anatomy - Leeds university conference gallery - Cruise ship management course - Below standard tirade is outrageous - Stephen dedalus name meaning - Shadow health abdominal assessment subjective - Database case study examples with solutions - Management - Web research design attachment - Database IT244 - 693 am radio melbourne - Individual success plan gcu - Http www youtube com watch v vdh7mngntni - Where are all the i's in wii sports resort - Penn foster written communication writing assignment - Dva physiotherapy fees 2021 - Marketing - Stt welding stainless steel - Need Help with Your Online Nursing Course? - Cjt 202 - Which describes a grizzly bear's habitat - What is withitness in education - Individuality map the giver - 18 hours - Wireless Security-2 - Glj scrap yard cwmcarn - HomeWork - Mesaure instruments - Risk management and assessment - 15th century painting of a market in the netherlands - Niosh lifting equation excel - Guy grip dead end - Dimplex heater timer instructions - Degree of Alignment - Biotic factors in the desert - Classic knitwear and guardian a perfect fit break even analysis - Spongebob scientific method worksheet - Complete moab inc s form 4797 for the year - Complete currency consulting ltd - How to make a cup of tea flowchart - How to use casio calculator for statistics - Cisco 2821 ios image download - En ac 46000 equivalent - Qualities of a good reader - Acme airlines - What does a patent examiner do - Rule based classifier example - Vce psychology units 3 and 4 study design - Kostrivas company has gathered the following information - For what values of p does the integral converge - Dyeing pine cones with red food coloring - Due tomorrow ...... please read....... - Tan inverse 2x tan inverse 3x pi 4 - Research_paper - Zajímavá hra - For don m banned poem analysis - Karate do game codes - Module 5 Discussion 2 - How to tell a true war story answers - Mechanical heat pump experiment lab report - Essay - Julian opie famous portraits - Liverpool john moores university distance learning - Critical thinkers can best be described as - Let there be light lamp shade company - Reaction between aniline and acetic anhydride - human trafficking - Nursing Theory and Conceptual Model Presentation - Do a Feasibility Study and Industry Analysis for your business idea? - Plant export operations manual - Miami Dade College PSY1515 - King solomon's mines analysis - Business strategy essay - Week4 ORG400 - The pressure in a constant volume gas thermometer - Gravitational force gizmo answer key - Assessment and rating questions - Compare and contrast leadership styles - Msf access campaign jobs - Which financial statement presents the results of operations - Rotter incomplete sentence blank - Table 1 part 1 chromatography data