1.
Prepare
1.
Explanation of Solution
Cash Budget:
Cash budget is a financial budget. It is prepared to assess inflows and outflows of cash to manage cash balance and timing related issues. Closing cash balance is computed by adding cash receipts and subtracting cash payments from the expected cash available in the beginning.
Cash budget is presented as follows:
Particulars | Amount ($) |
Opening cash | 0 |
Add: Cash receipts 1 | 21,360 |
Less: Cash payments 2 | 23,964 |
Closing cash |
Table (1)
Working Notes:
1. Computation of Cash receipts:
Particulars | Amount ($) |
Fillings |
4,500 |
Crowns |
5,700 |
Root canals |
1,360 |
Bridges |
3,500 |
Extractions |
1,350 |
Cleaning |
2,700 |
X-Rays |
2,250 |
Total receipts | 21,360 |
Table (2)
2. Computation of Cash payments:
Particulars | Amount ($) |
Salary to dental assistants | 1,900 |
Receptionist salary | 1,500 |
Hygienist salary | 1,800 |
Public relations management | 1,000 |
Personal salary | 6,500 |
Benefits | 1,344 |
Building lease | 1,500 |
Dental supplies | 1,200 |
Janitorial | 300 |
Utilities | 400 |
Phone | 150 |
Office supplies | 100 |
Lab fees | 5,000 |
Loan payments | 570 |
Interest payments | 500 |
Miscellaneous | 200 |
Total | 23,964 |
Table (3)
2.
Explain steps that can be taken to solve financial problems of the company. Present a cash budget reflecting the steps taken. Also, explain whether these steps would likely be followed. Further, explain whether the behavioral principals relating to budgets and plans, have a role in the given situation.
2.
Explanation of Solution
Steps that could be taken to solve financial problems are listed as follows:
- Elimination of public relation personnel’s salary.
- Increase in working hours of the premise up to 40 hours a week.
- Timings should be adjusted to suit office timings of the patients.
- Lease rent paid to self should be eliminated.
Role of budgets and planning in the current set up:
- Working lesser hours than required while the company is incurring negative cash flows and outstanding debts indicate lack of planning.
- Maintaining public relations is although a good practice; however, this should be done by owners without charging cost considering the present situation of the company.
- Timings do not suit people who go to office and may want to visit dentist after office hours or on weekends. This indicates lack of analysis of demand for services.
It is likely that the suggestions would be followed; since, the internal revenue service is threatening to impound business and sell its assets. Company has incurred debt which is difficult to repay and is having negative cash flows.
Cash budget after incorporating above suggestions is presented as follows:
Particulars | Amount ($) |
Opening cash | 0 |
Add: Cash receipts 3 | 26,700 |
Less: Cash payments 4 | 21,202 |
Closing cash | 5,498 |
Table (4)
Working Notes:
3. Computation of Cash receipts:
Particulars | Amount ($) |
Total receipts (Sub Part-1) | 21,360 |
Current hours |
128 |
Proposed hours |
160 |
Total receipts expected |
26,700 |
Table (5)
4. Computation of Cash payments:
Particulars | Working ($) | Amount ($) |
Salary to dental assistants | 1,900 | |
Receptionist salary | 1,875 | |
Hygienist salary | 2,250 | |
Public relations management | 0 | |
Personal salary | 4,875 | |
Benefits | 1,344 | |
Building lease | 0 | |
Dental supplies | 1,500 | |
Janitorial | 375 | |
Utilities | 500 | |
Phone | 188 | |
Office supplies | 125 | |
Lab fees | 5,000 | |
Loan payments | 570 | |
Interest payments | 500 | |
Miscellaneous | 200 | |
Total | 21,202 |
Table (6)
Salary of dental assistants are not increased since, they are not fully utilized.
Variable costs are increased with increase in the working hours of the company.
Want to see more full solutions like this?
Chapter 9 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
- The controller of Arrowroot Company wishes to improve the company’s control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2021: June 30, 2021, cash balance $ 122,000 Dividends were declared on June 15* 40,000 Cash expenditures to be paid in July for operating expenses 81,600 Depreciation expense 12,200 Cash collections to be received 194,000 Merchandise purchases to be paid in cash 120,400 Equipment to be purchased for cash 45,800 Arrowroot Company wishes to maintain a minimum cash balance of 62,000 *Dividends are payable to shareholders of record on declaration date, 30 days after declaration. Required: 1. Prepare a cash budget for the month ended July 31, 2021, indicating how much, if anything, Arrowroot will need to borrow to meet its minimum cash requirement. Leave no cells blank - be certain to enter "0" wherever requiredarrow_forwardQuestion 3 Mischa Furniture Stores (“MFS”) is a company that specialises in office furniture based in Windhoek. Due to the effects of Covid-19, it has become very imperative for the company to manage its cash flows effectively. The owner of MFS knows of your skills in management accounting and has requested your service in the preparation of the forth coming quarter’s cash budget. Upon interviews with different departments at MFS, you have ascertained the following information: Budget information for January, February and March 2023 is as follows: January February March N$ N$ N$ Sales 590 000 650 000 750 000 Production costs 300 000 350 000 420 000 Sales and Administration costs 150 000 170 000 200 000 Purchase of non-current assets…arrow_forwardEastern Enterprises is preparing a cash budget for June. Eastern has $12,000 cash at the beginning of June and anticipates $30,000 in cash receipts and $34,500 in cash disbursements during June. Eastern Enterprises has an agreement with its bank to maintain a cash balance of at least $10,000. As of May 31, Eastern owes $15,000 to the bank. To maintain the $10,000 required balance, during June Eastern must: Group of answer choices: 1)Borrow $10,000. 2)Borrow $ 2,500. 3)Repay $ 2,500. 4)Borrow $ 4,500. 5)Repay $ 7,500.arrow_forward
- Cash balanceThe following budgeted May cash information is available for Salado Corp.: Net after-tax income $201,600 Depreciation expense 33,720 Accrued income tax expense 49,200 Increase in Accounts Receivable for month 4,800 Decrease in Accounts Payable for month 4,200 Estimated bad debts expense 2,460 Dividends declared in May 21,000 Dividends paid in May 28,200 If Salado’s May 1 cash balance is $13,800, what is the company’s budgeted May 31 cash balance? $Answerarrow_forwardCash Budget—Financing Effects You are a relatively recent hire to Hartz & Co., a local manufacturer of plumbing supply products. You have been asked to prepare a condensed statement ofcash flows for the months of November and December of the current year for presentation to thecompany’s management.Assume the cash balance at November 1 will be $75,000. It is the company’s policy to maintaina minimum cash balance of $50,000 at the end of each month. Cash receipts (from cash salesand collection of accounts receivable) are projected to be $525,000 for November and $450,000for December. Cash disbursements (sales commissions, advertising, delivery expense, wages,utilities, etc.) prior to financing activity are scheduled to be $450,500 in November and $550,000in December.Short-term borrowing, when needed, is done at the beginning of the month in increments of$1,000. The annual interest rate on any such loans is estimated to be 12%. Interest on any outstanding short-term loans is paid in…arrow_forwardBudgetary Slack with Ethical Considerations Norton Company, a manufacturer of infant furniture and carriages, is in the initial stages of preparing the annual budget for next year. Scott Ford recently joined Norton’s accounting staff and is interested to learn as much as possible about the company’s budgeting process. During a recent lunch with Marge Atkins, sales manager, and Pete Granger, production manager, Ford initiated the following conversation: Ford: Since I’m new around here and am going to be involved with the preparation of the annual budget, I’d be interested to learn how the two of you estimate sales and production numbers. Atkins: We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending. Then we add that usual dose of intuition to come up with the best forecast we can. Granger: I usually take the sales projections as the basis for my projections. Of course,…arrow_forward
- Question 1Ming Chung Limited is applying for additional bank overdraft finance to enable thecompany to make the plant and machinery purchase described below. The directorshave has asked you to draw up a cash budget for the 6 months to 30 June 2020 toprove to the bank that that overdraft finance will be repaid by 30 June 2020. Thecompany provides you with the following financial information:Month Sales Purchases Wages Overheads£ £ £ £November 2019 (actual) 45,800 18,400 9,600 6,000December 2019 (actual) 34,600 13,900 9,800 14,000January 2020 (budgeted) 42,200 16,800 10,500 7,000February 2020 (budgeted) 44,000 17,600 11,200 7,500March 2020 (budgeted) 54,000 21,600 13,500 18,800April 2020 (budgeted) 57,600 23,000 14,400 8,000May 2020 (budgeted) 61,800 24,700 15,300 9,200June 2020 (budgeted) 63,700 25,500 15,900 9,800Notes♦ The bank balance at 1 January 2020 is expected to be £25,000.♦ 60% of sales are for cash with the other 40% being on credit. 70% of creditsales pay in the month…arrow_forwardCompleting a comprehensive budgeting problem—merchandising company Belton Printing Company of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for the month of April 2018 and a balance sheet at April 30, 2018. The March 31, 2018a balance sheet follows: As Belton Printings controller, you have assembled the following additional information: April dividends of $7,000 were declared and paid. April capital expenditures of $17,000 budgeted for cash purchase of equipment. April depreciation expense, $800. Cost of goods sold, 55% of sales. Desired ending inventory For April is $24,800. April selling and administrative expenses includes salaries of $29,000, 20% of which Will be paid in cash and the remainder paid next month. Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April. April budgeted sales, $86,000, 80% collected in April and 20% in May. April cash payments of March 31…arrow_forwardAlmost all of the sales revenues of the oxygen equipment are credit card sales; cash sales are negligible. The credit card company deposits 97% of the revenues recorded each day into HealthMart’s account overnight. For the servicing of home oxygen equipment, 60% of oxygen services billed each month is collected in the month of the service, and 40% is collected in the month following the service. Q. Why do HealthMart’s managers prepare a cash budget in addition to the revenue, expenses, and operating income budget? Has preparing the cash budget been helpful? Explain briefly.arrow_forward
- Preparing the financial budget——cash budget Hoppy Company requires a minimum cash balance of $3,500. When the company expects a cash deficiency, it borrows the exact amount required on the first of the month. Expected excess cash is used to repay any amounts owed. Interest owed from the previous month’s principal balance is paid on the first of the month at 14% per year. The company has already completed the budgeting process for the first quarter for cash receipts and cash payments for all expenses except interest. Hoppy does not have any outstanding debt on January l. Complete the cash budget for the first quarter for Hoppy Company. Round interest expense to the nearest whole dollar.arrow_forwardCompleting a comprehensive budgeting problem—merchandising Company Alliance Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2018 and a balance sheet at April 30, 2018. The March 31, 2018, balance sheet follows: As Alliance Printing Supply’s controller, you have assembled the following additional information: April dividends of $7,000 were declared and paid. April capital expenditures of $16,300 budgeted for cash purchase of equipment. April depreciation expense, $1,000. Cost of goods sold, 40% of sales. Desired ending inventory for April is $22,400. April selling and administrative expenses include salaries of $37,000, 30% of which will be paid in cash and the remainder paid next month. Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April. April budgeted sales, $89,000, 80% collected in April and 20°/0 in May. April cash payments of March 31…arrow_forwardThe controller of Optimum wishes to improve the company’s control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2021: June 30, 2021, cash balance $ 130,000 Dividends were declared on June 15* 44,000 Cash expenditures to be paid in July for operating expenses 83,600 Depreciation expense 13,000 Cash collections to be received 198,000 Merchandise purchases to be paid in cash 122,400 Equipment to be purchased for cash 47,000 Optimum wishes to maintain a minimum cash balance of 70,000 *Dividends are payable to shareholders of record on declaration date, 30 days after declaration. Required: 1. Prepare a cash budget for the month ending July 31, 2021, indicating how much, if anything, Optimum will need to borrow to meet its minimum cash requirement. (Leave no cells blank - enter "0" wherever required). The controller of Optimum wishes to improve the company’s control…arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPFIN (with PFIN Online, 1 term (6 months) Printed...FinanceISBN:9781337117005Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning