Premium Essay

Case Study 3, Acct 504

In: Business and Management

Submitted By jpshepard1234
Words 555
Pages 3
CASE STUDY 3—Cash Budget Template | | | | | | | | | | | | | | | | | | SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS May | June | 65,800 | | 26,850 | 62,650 | | 22,500 | 92,650 | 85,150 | | | | | | | May | June | 117,000 | | 54,000 | 81,000 | | 25,200 | 171,000 | 106,200 | | | | | | | | | | | May | June | $20,000 | $20,000 | | | 92,650 | 85,150 | 33,000 | | | 50,000 | 75,000 | 57,000 | 200,650 | 192,150 | 220,650 | 212,150 | | | 171,000 | 106,200 | 15,000 | 15,000 | 10,150 | 10,150 | 35,000 | | | 20,000 | 231,150 | 151,350 | (10,500) | 60,800 | | | | | 30,500 | | | (31,008) | $20,000 | 29,792 | | |
To see all the figures look above | | | Credit Sales | | | May | June | (94000 x70%) | | 65,800 | | May(89500 x 30%), Jun (89500 x 70%) | | 26,850 | 62,650 | (75000 x 30%) | | | 22,500 | Total Cash Collections | | 92,650 | 85,150 | | | | | | | | | | | SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY | | | Inventory purchases | | May | June | April(195000 x60%) | | 117,000 | | (135000 x 40%), Jun (135000 x 60%) | | 54,000 | 81,000 | (63000 x 40%) | | | 25,200 | Total Payments for Inventory Purchases | 171,000 | 106,200 | | | | | | LBJ Company | | | | | Cash Budget | | | | | | | | For the Two Months of May and June | | | | | | | May | June | Cash balance | | | $20,000 | $20,000 | Add: Receipts | | | | | Collections from customers | 92,650 | 85,150 |…...

Similar Documents

Premium Essay

Case Study 2 Acct 504

...Case Study 2- Internal Control Improving LJB Company Internal Control ACCT 504 Felix M. Fair October 6, 2012 Table Of Contents: 1. Introduction pg. 3 2. Proper Development of Internal Control pg. 3 3. Effective LJB Practices pg. 3-4 4. Areas for Improvement pg. 4 5. Conclusion pg. 5 6. References pg. 6 Improving LJB Company Internal Control Introduction This paper is an academic work that will define, identify, and explain the use of Internal Control within a company, as well as applying the principles of internal control activities. These principles will be reflected in the use of new requirements, comprehensive feedback of where LJB is currently and where they can be with improvement of Internal Control and the application of its principles. Proper Development of Internal Control What is Internal Control? Internal control makes up all methods that are adopted within an organization to safeguard assets, enhance the reliability of accounting records, increase operational efficiency, and ensure compliance with laws and regulations. [Kimmel (). Financial Accounting [6] (VitalSource Bookshelf), Retrieved from......

Words: 998 - Pages: 4

Free Essay

Acct 504 Case Study 2

...ACCT 504 Case Study 2 Keller Graduate School DeVry University ABSTRACT There are several internal control requirements that need to be put into place if the company decides to go public. Those principals are establishment of responsibility, segregation of duties, physical controls, independent internal verification, documentation procedures and human resource controls. Establishment of responsibility is making sure that only designated personnel has the authority to handle certain financial responsibilities. Segregation of duties is ensuring that different individuals have different responsibilities. A physical control is having the proper items that need to be secure in a place that has limited access. Independent internal verification is having individuals confirm the information that is received by various departments to make sure there is accuracy in the documents and reports that are being reported. Documentation procedures is using proper documentation to keep records accurate and having supporting evidence for the transactions that had taken place to make sure that fraud has not occurred. Human resource is handling personnel issues such vacations, conducting background checks and issuing bond personnel for the individuals who handle cash. All of these internal control principals are important to protect the company’s assets, increase the effectiveness of the operations and ensure compliance with laws and regulations. These controls also heighten the...

Words: 1591 - Pages: 7

Premium Essay

Acct 504 Case Study 2

...about the internal control requirements for such action. To become publicly listed, LJB must follow the Sarbanes-Oxley Act of 2002 (SOX), which requires all US publicly traded companies to maintain an adequate system of internal control. Under SOX Section 404, a company must report on internal controls over financial reporting in its annual report. Four key elements must be included in this report (Smith, Ledyard;): 1. Statement of responsibility by the company management (CEO and CFO) for establishing and maintaining an adequate internal control structure and procedure for financial reporting. 2. Statement identifying the framework used by management to evaluate the effectiveness of the company’s internal control over financial reporting. 3. Management’s assessment of the effectiveness of internal controls over financial reporting. 4. Attestation by the company’s external auditor on management’s assessment of the effectiveness of the company’s internal controls and procedures for financial reporting. As the president of LJB, he and other executives and board of directors must ensure that the internal controls are reliable and effective. In addition, he must hire independent outside auditors to attest to the adequacy of the internal control system. LJB’s Proper Internal Controls To become publicly listed, LJB must ensure and maintain an adequate and effective internal control system. After evaluating LJB’s current internal controls, I have found several positive acts.......

Words: 1398 - Pages: 6

Free Essay

Acct 504 Case Study 2

...LBJ Company: Internal Control Evaluation Accounting 504: Managerial Use & Analysis Case Study 2 Written by: 8/10/13 This evaluation is being presented as an assessment of the preparedness of the LJB Company to go public at a future date. By researching current regulations regarding publicly traded firms we hope to prepare for a smooth transition into the trading market. The Sarbanes-Oxley Act of 2002 (SOX) has established the following guidelines for publicly traded corporations and require adherence for internal controls and procedures for financial reporting. Senior management and executives will be responsible for ensuring that controls are effective and reliable. Outside auditors must periodically verify the accuracy of and adherence to the internal controls. As part of the annual Exchange Act report, an internal control report will generated along with the information recorded during each fiscal year. It is recommended that the LJB Company adopt the framework set forth by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) and remain in compliance with the SOX Act. This framework will follow six principles of internal control. 1) Establishment of Responsibility 2) Segregation of Duties 3) Documentation of Procedures 4) Physical Controls 5) Independent Internal Verification 6) Human Resource Controls Bruce Bulmer Consultations has completed its preliminary assessment of the current......

Words: 617 - Pages: 3

Free Essay

Acct 504 Case Study 2

...Case Study 2—Internal Control Due by Sunday of Week 5, 11:59 p.m., Mountain time LJB Company, a local distributor, has asked your accounting firm to evaluate their system of internal controls because they are planning to go public in the future. The president wants to be aware of any new regulations required of his company if they go public, so he met with a colleague of yours at a local restaurant. The president of the company explained the current system of internal controls to your colleague. Your colleague has since been promoted to a tax position so she has passed on the information below so you can generate recommendations for the partner at your accounting firm to share with the president of LJB Company. Since LJB Company is a relatively lean organization, they have a lot of faith in their long-term employees. They have one accountant who serves as treasurer and controller, which streamlines many of their processes. In this dual role, he purchases all of the supplies and pays for these purchases. He also receives the checks and completes the monthly bank reconciliation. The accountant also interviews and approves of all the new hires. The accountant is so busy that the company handles petty cash a bit differently. All employees have access to the petty cash in a desk drawer and are asked to only place a note if they use any of the cash. The accountant has recently started using pre-numbered invoices and wants to buy an indelible ink machine to print their......

Words: 912 - Pages: 4

Premium Essay

Acct 504 Case Study 2

...Prepared For ACCT405: Financial Accounting Instructor Tim Vantuyl 6/8/2014 Case Study 2: LBJ Company Internal Control Assessment By Brian Tucker Student ID D40318643 Table of Contents Preface …..3-5 Body of Report Page …..6 Objectives of Internal Control …..6 Components of Internal Control …..6 Strengths …..7-8 Weaknesses Summary and Conclusion Preface With its introduction in 2002 the Sarbanes Oxley Act was meant to slow and detour the accounting infractions and criminal acts of recent companies like Enron, Arthur Anderson, World Com. SOX has changed the landscape of regulations as it relates to the role of corporate governance in overseeing and verifying the internal function and financial practice of reporting for publicly traded companies. The U.S. Securities and Exchange Commission to mean “controls that pertain to the preparation of financial statements for external purposes that are fairly presented in conformity with generally accepted accounting principles as addressed by the Codification of Statements on Auditing Standards §319 or any superseding definition or other literature that is issued or adopted by the Public Company Accounting Oversight Board” (http://www.sec.gov/rules/final/33-8238.htm). In reviewing the major changes by select sections, leadership and management of the firms should note the following as significant: Section 302 requires officer of the company to review and certify financial reports that the firm generates.......

Words: 1985 - Pages: 8

Premium Essay

Acct 504 Case Study 2

...Devry University LJB Company Internal Controls Eddie Daniel Velez ACCT 504 Professor Ramiro Serrano August 10, 2014 Table of Contents Introduction………………………………………………………………………………………..3 Public Trading……………………………………………………………………………………..4 Internal Controls…………………………………………………………………………………..5 Current Concerns………………………………………………………………………………….6 Summary…………………………………………………………………………………………..8 Works Cited……………………………………………………………………………………….9 Introduction: This report is used for the purpose of evaluating internal controls with the company stated: LJB Company Inc. LJB plans on going public in the near future and has enlisted the help of Serrano Accounting Services (SAS) to prepare a formal document discussing changes that need to be made in the company before going public is plausible. This report will discuss some of the current procedures at LJB with the proper recommendations to help streamline the process of becoming a public company along with any concerns the President might have and wishes to have addressed. Public Trading: LJB wishes to move forward and become a publicly traded company. First of all I want to thank for choosing SAS with all of your accounting needs. We are honored to help with this report and hopefully future endeavors. First we will review any regulations regarding private companies converting to public entities. One of the many added benefits of going public is it shows consumers, and investors a strong corporate governance. Under......

Words: 1155 - Pages: 5

Premium Essay

Acct 504 Case 3 Study - Cash Budget

...CASE STUDY 3 - Cash Budget Template SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS: Credit Sales July August September Total Cash Collections August 12,000 14,400 26,400 SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY Inventory purchases July August September Total Payments for Inventory Purchases August 32,500 22,500 55,000 Oxford Company Cash Budget For the Two Months of August and September Cash balance Add: Receipts Collections from customers Sale of plant assets Sale of new common stock Cash sales Total receipts Total Available Cash Less: Disbursements Purchases of inventory Operating expenses Selling and administrative expenses Dividends Equipment purchase Total disbursements Excess (deficiency of available cash over disbursements) Financing Borrowings Repayments Ending cash balance Please answer the 3 qualitative questions on the next tab called Qualitative Questions. August $10,000 26,400 12,350 51,000 89,750 99,750 55,000 6,750 12,500 19,000 93,250 6,500 3,500 $10,000 September 9,600 10,800 20,400 September 22,500 10,500 33,000 September $10,000 20,400 16,850 39,000 76,250 86,250 33,000 6,750 12,500 6,000 58,250 28,000 (3,570) 24,430 1) 2) 3) What are the three sections of a Cash Budget, and what is included in each section? Cash receipts section: This section includes cash that is expected to be recieved from company activity and customer payments. This includes money coming in from the sale of Cash......

Words: 550 - Pages: 3

Premium Essay

Acct 504 Case Study 2

...LJB Company’s Table of contents: Introduction………………………………………………………………………………3 New Internal Control Requirements……………………………………………………4 Positives & Negatives…………………………………………………………………….4 Recommendation on Ink Machine………………………………………………………5 Summery & Conclusion.………………………………………………………………….5 Work Cited………………………………………………………………………………..6 Introduction The purpose of this report is to show the importance of internal controls for LJB Company if it’s decided that the company will go public. Through out the document three major topics will be address. The first being, a reviewing of new internal control requirement before the company goes public. Secondly, an overlook of the positive & negative policies that affects internal control and its procedures, along with recommendations for the negatives. Finally, an advisement on whether or not the company should buy the indelible ink machine. New Internal Control Requirements New requirements have been placed since 2002 for all publically traded US companies and their internal controls, as stated by Walter T. Harrison, Charles T. Horngren, and C. William Thomas in their book Financial Accounting, VitalSource for DeVry University (p. 236). Congress passed the Sarbanes-Oxley Act (SOX) to address and ease the concerns of the public ever since the scandal of Enron and WorldCom. In order to comply with the SOX act the following requirements must be followed: * Public companies must have an internal control report......

Words: 687 - Pages: 3

Premium Essay

Acct 504 Case Study 2

...reliable picture of the company. The companies need to present its financials accurately. The act focused on the accuracy of the financial reporting and made the management of the firm personally responsible for the accuracy of the financial system. This act helped in safeguarding the interests of the investors who invests in the stocks of the company. Before going public it is important for the company needs to undergo the external auditors test control so as to assure that the financial statements or reports presented by the company are true and correct. The financial reporting needs to be in the accordance to GAAP or IFRS and should fulfill the SOX law. Informing the president of what the company is doing right: As per the case we can see that the turnover ratio of the employees in the organization is quite low, which depicts the employees are satisfied with the working environment of the company. As employees are the biggest asset for the company, this will help in strengthening the company as well as the growth of the company, the managers of the company has the capability to have a strong control internally. The company’s indelible ink machine is likely to have future benefit to the company which will help in the growth of the organization. The company has to keep a check on its checks, the paychecks of the company should be kept in the safe-box and only one person should have the authority to open the safe, the company need to focus on the......

Words: 1030 - Pages: 5

Free Essay

Acct 504 Case Study 2

...Running Head: INTERNAL CONTROL Internal Control Ashley Pognant Keller Graduate School of Management Professor Hope August 10, 2014 Table of Contents Abstract 3 Internal Control 4 Internal Control Requirements 4 What the Company is Doing Right 5 What the Company Needs to Improve 6 Conclusion 7 References 9 Abstract The purpose of this case study is to analyze a company’s system of internal control. We will discuss if there are any new requirements in regards to internal control should the company decide to go public. The President of the company will be advised on what they are doing right and what controls need improvement. We will also discuss the reasons why and what internal control principle applies to the situation. Internal Control The President of LJB company has asked my accounting firm to evaluate their system of internal controls because they intend on going public here in the near future. The company has a lot of faith in their long term employees. Their accountant is responsible for purchasing supplies, paying for these purchases, receiving checks, completing monthly bank reconciliations and is in charge of not only interviewing but hiring new employees. The company leaves their petty cash in a desk drawer for all their employees to have access to. All the company requests in that the employee leaves a note should they use any of the cash. The accountant has recently started......

Words: 1372 - Pages: 6

Free Essay

Acct 504 Case Study 2

...Control Evaluation Acct: 504 Case Study 2 Prepared by: Lennard Razor Prepared for: LJB Company 11/29/2014 LJB, 1 Table Of Contents Introduction: LJB Company Assessment 2 LJB Company: The Transition 3 Summary 5 Works Cited 6 LJB, 2 Introduction: LJB Company Assessment The overall purpose of this document is to assess the current state of the LJB Company. This assessment will thoroughly diagnose all of the components, both good and bad, used by LJB Company to help determine the company’s readiness to go public. Upon assessing all of the components and regulations currently utilized by LJB Company, I will also make recommendations for the improvement and future success of this company moving into the public market. In order to properly perform an assessment of the LBJ Company, there first had to be some set of standards or regulations that outline the internal controls and proper procedures for companies and businesses to adhere to for financial reporting. As it turns out internal control is a key component of Foreign Corrupt Practices Act(FCPA) of 1977 and the Sarbanes-Oxley Act(SOX) of 2002 which required companies to follow this set of internal controls. This list of internal controls is as follows: 1). Conduct its business in an orderly and efficient manner, 2). Safeguard its assets and resources, 3). Deter and defect......

Words: 939 - Pages: 4

Premium Essay

Acct 504 Week 3 Case Study 1 Flower Landscaping Corporation

...ACCT 504 WEEK 3 CASE STUDY 1 FLOWER LANDSCAPING CORPORATION A+ Graded Tutorial Available At: http://hwsoloutions.com/?product=week-3-case-study-1-flower-landscaping-corporation Visit Our website: http://hwsoloutions.com/ Product Description ACCT 504 Week 3 Case Study 1 Flower Landscaping Corporation, JOURNAL Entries July 19 Made payment on account to Lakeside Company, $400. July 31 Received cash for landscaping revenue for the last half of July, $2,620. July 31 Declared and paid cash dividend of $1,600. Prepare journal entries to record the July transactions in the General Journal below. Use the following account names for journal entries. General Journal Chart of Accounts: Account Title (Normal Balance) Date Description(Account Name) Debit Credit 1-Jul Assets Cash 24,000 Cash (Debit) Common Stock 24,000 Prepaid Insurance (Debit) Landscaping Supplies (Debit) 1-Jul Prepaid Insurance 2,400 Landscaping Equipment (Debit) Cash 2,400 Accum Depr -Equipment (Credit) 1-Jul Rent Expense 2,080 Liabilities Cash 2,080 Accounts Payable (Credit) Income Tax Payable (Credit) 3-Jul Landscaping Equipment 8,800 Cash 1,200 Stockholders Equity Accounts Payable 7,600 Common Stock (Credit) Retained Earnings (Credit) 8-Jul Landscaping Supplies 780 Dividends (Debit) Accounts Payable 780 Revenue 12-Jul Utility Expense 308 Landscaping Revenue (Credit) Cash 308 Expenses 16-Jul Cash 2,724 Rent Expense (Debit) Landscaping Revenue 2,724 Utility Expense......

Words: 514 - Pages: 3

Premium Essay

Acct 504 Week 6 Case Study 3 – Cash Budgeting – Lbj Company

...ACCT 504 WEEK 6 CASE STUDY 3 – CASH BUDGETING – LBJ COMPANY A+ Graded Tutorial Available At: http://hwsoloutions.com/?product=week-6-case-study-3-cash-budgeting-lbj-company Visit Our website: http://hwsoloutions.com/ Product Description ACCT 504 Week 6 Case Study 3 – Cash Budgeting – LBJ Company, What are the three sections of a Cash Budget, and what is included in each section? 1. The cash receipts section includes expected receipts from the company’s principal source(s) of cash. It also shows anticipated receipts 0f intersest and dividends, and proceeds from planned sales of investments, plant assets, and the company’s capital stock. 2. The cash disbursements section shows expected payments for inventory, labor, overhead, and selling and administative expenses. This section also includes projected payments for income taxes, dividends, investments, and plant assets. 3. The financing section shows expected borrowings and the repayment of the borrowed funds plus interest. The financing entry when there is a deficiency or when the cash balance balance is less than management’s minum required balance. ACCT 504 Week 6 Case Study 3 – Cash Budgeting – LBJ Company, What are the three sections of a Cash Budget, and what is included in each section? 1. The cash receipts section includes expected receipts from the company’s principal source(s) of cash. It also shows anticipated receipts 0f intersest and dividends, and proceeds from planned sales of investments, plant...

Words: 306 - Pages: 2

Free Essay

Acct 504 Case Study 2

...Y’Lonn James Yolanda Serrano ACCT504-10563 Case Study #2 02/05/2016 Situation a. Missing Internal Controls: Monitoring control is the missing internal control weakness. This monitoring provides “eyes and ears”, so that no one person or group of persons can process a transaction completely without being seen and checked by another person or group.  This control involves understanding how companies monitors its control and how effective the monitoring is. The clerk should not be the only person who maintains the entire inventory. Segregation of duties is also missing. Segregation of duties is one of the steps that decrease the likelihood of theft. Segregation of duties prevents a breakdown in a key element of controls, such as improper segregation of duties and/or improper access to assets. Or it might result from a weak control environment. In the absence of the segregation of duties, the clerk has opportunity to steal. Problems: Can record inaccurate information since nobody is there to double check Theft Solution: Put a supervisor in place to for oversight until the cashier is adequate. Implement check and balances by preventing one person from processing transactions. Situation b. Missing Internal Controls: Adequate records, bookkeeping, and Authorization: Nicole is a part of a successful growing business, but does not book keep and provide any reports for the sales team. Problem: Not being able to accurately account for what......

Words: 406 - Pages: 2