Classique Household Furnishings & Appliances is a family-owned furniture store. You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending September 30, 2018. Your data collection has yielded the following: month  Cash Sales Sales on Account Purchases on Account May $50,000 $480,000 $390,000 June $65,000 $600,000 $360,000 July $43,400 $720,000 $450,000 August $52,800 $640,000 $400,000 September $56,750 $800,000 $500,000 ii) An analysis of the records shows that trade receivables (accounts receivable) for sales on account are settled according to the following credit pattern, in accordance with the credit terms 5/30, n90: 50% in the month of sale 35% in the first month following the sale 15% in the second month following the sale iii) Accounts payable are settled as follows, in accordance with the credit terms – 4/30, n60: 70% in the month in which the inventory is purchased 30% in the following month iv) Monthly rental is received from a tenant for storage space rented to him by Classique Household Furnishings & Appliances. The rental is $840,000 per annum and is received quarterly in advance. Rental relating to the quarter under review becomes due on July 1. v) Computer equipment, which is estimated to cost $350,000, will be acquired for cash in August. The manager has made arrangements with the seller to make a cash deposit of 50% of the amount upon signing of the agreementin August, with the balance to be settled in four equal monthly instalments, starting in September 2018. vi) An investment instrument purchased by the company with a face value of $480,000 will mature on July 20, 2018 and will be liquidated on that date. At the same time, quarterly interest computed at arate of 8⅓ % per annum will also be collected.   vii) Fixed operating expenses, which accrue evenly throughout the year, are estimated to be $1,920,000 per annum [including depreciation on non-current assets of $42,000 per month] and are settled monthly. viii) Wages and salaries are expected to be $2,304,000 per annum and will be paid monthly. ix) Other operating expenses are expected to be $144,000 per quarter and are settled monthly. x) In the month of August, furniture & fixtures, which cost $455,000, will be sold to an employee at a loss of $20,000. Accumulated depreciation on the furniture & fixtures at that time is expected to be $305,000. The employee will be allowed to pay a deposit equal to 60% of the selling price inAugust with the balance settled in two equal amounts in September & October. xi) As part of its investing activities, the management of Classique Household Furnishings & Appliances is in the process of completing a major addition to the business property which is estimated to cost $1,200,000, and which is being funded by external borrowing. $460,000 of the principal, along with interest of $18,000 is due to be paid on July 15, 2018. xii) The cash balance on September 30, 2018 is expected to be an overdraft of $264,000. Required: (a) The business needs to have a sense of its future cashflows and therefore requires the preparation of the following: - A cash budget, with a total column, for the quarter ending September 30, 2018, showing the expected cash receipts and payments for each month and the ending cash balance for each of the months, given that no financing activity took place.

Question

Classique Household Furnishings & Appliances is a family-owned furniture store. You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending September 30, 2018. Your data collection has yielded the following:

month  Cash Sales Sales on Account Purchases on Account
May $50,000 $480,000 $390,000
June $65,000 $600,000 $360,000
July $43,400 $720,000 $450,000
August $52,800 $640,000 $400,000
September $56,750 $800,000 $500,000

ii) An analysis of the records shows that trade receivables (accounts receivable) for sales on account
are settled according to the following credit pattern, in accordance with the credit terms 5/30, n90:
50% in the month of sale
35% in the first month following the sale
15% in the second month following the sale


iii) Accounts payable are settled as follows, in accordance with the credit terms – 4/30, n60:
70% in the month in which the inventory is purchased
30% in the following month


iv) Monthly rental is received from a tenant for storage space rented to him by Classique Household
Furnishings & Appliances. The rental is $840,000 per annum and is received quarterly in advance.
Rental relating to the quarter under review becomes due on July 1.


v) Computer equipment, which is estimated to cost $350,000, will be acquired for cash in August.
The manager has made arrangements with the seller to make a cash deposit of 50% of the amount upon signing of the agreementin August, with the balance to be settled in four equal monthly instalments, starting in September 2018.


vi) An investment instrument purchased by the company with a face value of $480,000 will mature on July 20, 2018 and will be liquidated on that date. At the same time, quarterly interest computed at arate of 8⅓ % per annum will also be collected.

 

vii) Fixed operating expenses, which accrue evenly throughout the year, are estimated to be $1,920,000
per annum [including depreciation on non-current assets of $42,000 per month] and are settled monthly.


viii) Wages and salaries are expected to be $2,304,000 per annum and will be paid monthly.


ix) Other operating expenses are expected to be $144,000 per quarter and are settled monthly.


x) In the month of August, furniture & fixtures, which cost $455,000, will be sold to an employee at a
loss of $20,000. Accumulated depreciation on the furniture & fixtures at that time is expected to be $305,000.
The employee will be allowed to pay a deposit equal to 60% of the selling price inAugust with the balance settled in two equal amounts in September & October.

xi) As part of its investing activities, the management of Classique Household Furnishings & Appliances
is in the process of completing a major addition to the business property which is estimated to cost
$1,200,000, and which is being funded by external borrowing. $460,000 of the principal, along with
interest of $18,000 is due to be paid on July 15, 2018.
xii) The cash balance on September 30, 2018 is expected to be an overdraft of $264,000.


Required:
(a) The business needs to have a sense of its future cashflows and therefore requires the preparation of
the following:
- A cash budget, with a total column, for the quarter ending September 30, 2018, showing the expected cash receipts and payments for each month and the ending cash balance for each of the months, given that no financing activity took place. 

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Accounting

Cost Accounting

Related Accounting Q&A

Find answers to questions asked by students like you.

Q: 1. Started business with OMR 45,000 2. Purchase goods from Mr. Ahmed OMR 9,000 3. Bought machine for...

A: Click to see the answer

Q: Explain the difference between static and flexible budgets.

A:  

Q: Samantha Manufacturing Company manufactures and sells musical gadgets. The business earned Operating...

A: Break-even point is the point wherein revenues equals expenses or contribution equals fixed costs. I...

Q: Calculating breakeven point in units, contribution margin given Mackler, Inc. sells a product with a...

A: Breakeven point in units = Fixed costs / Contribution margin  per unit

Q: The Best Appliances had the following revenue over the past five Wars, To predict revenues for 2018,...

A: Definition:   Margin of safety: The number of units sold or the income earned in excess of the break...

Q: Summarized transactions for January 2016 were as follows Repair services performed during January: ...

A: Journal entries are the record of all financial transactions entered by a business.

Q: Mr. Bailey asks that you prepare Divisional Income Statements showing what 20Y1 results would have b...

A: Income statement: The financial statement which reports revenues and expenses from business operatio...

Q: Following is the unadjusted trial balance for Sun Energy Co. on December 31, 2017. Sun Energy Co. Un...

A:  Income statement is a statement prepared to calculate the net income of a company after deducting e...

Q: What is the burden of the tax? Explain the key factors that determine the incidence of the tax.

A: Click to see the answer

Q: Having issue with this problem. Thank you

A: Workings: Declared dividend of $ 49000. Payment date is May 31

Q: Hard Bodies Co. is a fitness chain that has just completed its second year of operations. At the beg...

A: Click to see the answer

Q: Analyzing CVP relationships Crandall Company sells flags with team logos. Crandall has fixed costs o...

A: 1) Calculation of Number of flags must sell in a year to break even: Break even number of flags = ( ...

Q: What are the two components that can affect contribution margin? Why is it important to investigate ...

A: Contribution Margin is the left over sales revenue after reducing all variable costs from sales reve...

Q: Foxx Corporation acquired all of Greenburg Company’s outstanding stock on January 1, 2016, for $600,...

A: Hey, since there are multiple requirements posted, we will answer the first requirement. If you want...

Q: Little Book LTD has total assets of $860,000. There are 75,000 shares of stock outstanding, total bo...

A:  

Q: Assuming that these activity levels are within the relevant range, the maj was:

A: Manufacturing overhead:   Manufacturing overhead refers to indirect costs that are incurred in the f...

Q: During the current year, Alanna Co. had the following transactions pertaining to its new office buil...

A: Particulars Amount Purchase price of the land $130,000 Add: legal fees paid for contract to purc...

Q: Computing breakeven sales and sales needed to earn a target profit graphing CVP relationships, perfo...

A: Click to see the answer

Q: Preparing an operating budget—sales budget; inventory, purchases and COGS budget and S&A expense...

A: Calculation of sales budget for April and May 2018:   Sales in April = $ 160000 Sales in May = Sales...

Q: Adjusting entries always include A. only income statement accounts B.only balance sheet accounts C.t...

A: Adjusting entries are made to balance the debit and credit of the balances. Adjusting entries are do...

Q: Risk in capital budgeting implies that the decision maker knows _ of the cash flows. Fill in the bla...

A: In capital budgeting the decision maker will have an idea after analysing risks about the cash flows...

Q: Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the samesta...

A: a) In order to choose between the projects we need to consider which project has better discounted c...

Q: Suppose Iron City manufactures cast iron skillets. One model is a 10-inch skillet that sells for $20...

A: Desired ending inventory = Net month's sale x 20%                                           = 500*20...

Q: Accepting Business at a Special Price. Can you please help!

A: While determining the lowest bidding prices, it is to be noted that the company has to recover all v...

Q: Hanny, Pammy and Sunny are partners sharing profits in the ratio of 3 : 2 : 1.Goodwill is appearing ...

A: 1. Pammy’s share of current value of goodwill 1/3 of Rs. 84,000 = 84,000*1/3 = Rs. 28,000 2. Gaining...

Q: Elijah James is in his early 30s and is thinking about opening an IRA. He can't decide whether to op...

A: An IRA is a short form of an Individual Retirement Account. It is a contribution scheme which allows...

Q: What are the three sections of the cash budget?

A: Budget:   It is a statement of estimated revenues and expenditures prepared by the company relating ...

Q: Accounting Question

A: A deferred tax asset is an item on the balance sheet that results from an overpayment or advance pay...

Q: Sampson Company operates a manufacturing facility where several products are made. Each product is c...

A: Since the student has posted multiple requirements, we will answer the first three alone. Thank You.

Q: Massi pharmacies, Inc. started operations on January 1 2X11. The company used the average cost metho...

A: Click to see the answer

Q: The worksheet of the MAHA Company as follows. MAHA COMPANY Worksheet (partial) for the year ended D...

A: Journalize the closing entries at December 31,2018 as follows:

Q: KMC Manufacturing Company makes garden and lawn equipment. The company operates through three divisi...

A: Contribution margin:   Contribution margin refers to the process or theory that is used to judge the...

Q: Of the three approaches to calculate sales required to achieve the breakeven point, which one(s) cal...

A:  

Q: Computing breakeven sales and sales needed to earn a target profit; performing sensitivity analysis ...

A: Since the student has posted multiple requirements, we shall answer the first three alone alone.

Q: When are companies required to file consolidated financials? How is it recorded?

A: Consolidated financial statements are required when one entity has effective control over another en...

Q: Q2 You are required to prove the accounting equation after each of the transactions by preparing the...

A: Accounting Equation: An accounting equation shows the relationship between assets and liabilities or...

Q: Sole Purpose Shoe Company is owned and operated by Sarah Charles. The company manufactures casual sh...

A: Variance analysis is an analysis used to recognize the difference between actual behavior and planne...

Q: Paul and Donna Kelsch are planning a Mediterranean cruise in 5 years and will need $9,500 for the tr...

A: Calculations: Future value of Annuity. Formula = P{ ( 1+r) N - 1 / R } P = quarterly payments. R = I...

Q: Name five common major classes of operating cash receipts or operating cash payments presented on th...

A: Statement of cash flows: It is one of the financial statement that shows the cash and cash equivalen...

Q: The following financial ratios have been calculated for Nova Ltd for the year ended 30 June 2008:Act...

A: Accounting ratios are calculated to measure the liquidity, solvency, and profitability of the busine...

Q: windaer Lomparry buyan speratiuma un Jeruary 1, 2018. and uaa the everupe-coat muthud of pris ng ime...

A: Under average cost method, Inventory is valued at average cost. Under FIFO method, inventory is cons...

Q: The conflicts in project ranking in capital budgeting as per NPV and IRR may arise because of:  A...

A: Time value of money:   It is a concept that states the money worth we have at present will be more t...

Q: How does Probability Proportionate to Size (PPS) sampling compare to Classic Variables sampling?

A: Probability Proportionate to Size ( PPS):  This is a form of variable sampling. It does not use stan...

Q: Sammie’s Pizza sells an average of 150 pizzas per week, of which 20% are single-topping pizzas and 8...

A: Definition:   Cost-volume profit analysis: CVP analysis is a tool of cost accounting that measures t...

Q: A profit center manager has the responsibility and authority for making decisions that affect revenu...

A: Investment turnover: This ratio gauges the operating efficiency by quantifying the amount of sales g...

Q: Use the following information for Exercises E21-14 and E21-15. Concord, Inc. has collected the follo...

A: 1. Particulars Amount Direct material $64 Direct Labor $68 Variable manufacturing overhead ...

Q: Perdue Company purchased equipment on April 1 for $100,170. The equipment was expected to have a use...

A: A) Straight line method Cost of equipment = $100170 Residual value = $2970 Useful life = 3 years Ann...

Q: A manager of Varden Sporting Goods Company is considering accepting an order from an overseas custom...

A: Special orders are to evaluated based on Relevant costs. Relevant costs are those costs which change...

Q: Ehrlich Co. began business on January 2, 20Y8. Salaries were paid to employees on the last day of ea...

A: Payroll: The total payment that a company is required to pay to its employee for the services receiv...

Q: On January 2, 2019, Whistler Company purchased land for $450,000, from which it is estimated that 35...

A: 1) Calculation of Depletion cost  per Ton: