Dynamic - Problem and answer changes with each attempt (consider an Excel solution) Farm Supply is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Dynamic - Problem and answer changes with each attempt (consider an Excel solution) Farm Supply is located in a small town on the coast of California. Data regarding the store's operations follow: Sales are budgeted at 310,508 for November, $ 332,240 for December, and $ 235,717 for January. Collections are expected to be 70% in the month of sale and 30% in the month following the sale. The cost of goods sold is 75% of sales. The company desires to have an ending merchandise inventory at the end of each month equal to 80% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. Other monthly expenses to be paid in cash are $22,400. Monthly depreciation is $27,500. Ignore taxes. Balance Sheet October 31 Assets Cash Accounts receivable Merchandise inventory Property, plant and equipment, net of $624,000 accumulated depreciation Total assets Liabilities and Stockholders' Equity $ 33,000 83,500 181,800 918,000 $ 1,216,300 Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $252,000 753,000 211,300 $ 1,216,300 Calculate the difference between cash receipts and cash disbursements for December. Hint: Range of answer is 45,000 to 60,000 Dynamic - Problem and answer changes with each attempt (consider an Excel solution) Farm Supply is located in a small town on the coast of California. Data regarding the store's operations follow: Sales are budgeted at 310,508 for November, $ 332,240 for December, and $ 235,717 for January. Collections are expected to be 70% in the month of sale and 30% in the month following the sale. The cost of goods sold is 75% of sales. The company desires to have an ending merchandise inventory at the end of each month equal to 80% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. Other monthly expenses to be paid in cash are $22,400. Monthly depreciation is $27,500. Ignore taxes. Balance Sheet October 31 Assets Cash Accounts receivable Merchandise inventory Property, plant and equipment, net of $624,000 accumulated depreciation Total assets Liabilities and Stockholders' Equity $ 33,000 83,500 181,800 918,000 $ 1,216,300 Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $252,000 753,000 211,300 $ 1,216,300 Calculate the difference between cash receipts and cash disbursements for December. Hint: Range of answer is 45,000 to 60,000
Expert Answer:
Related Book For
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley
Posted Date:
Students also viewed these accounting questions
-
6) There is a small hospital with only five free beds. On a given day, it will admit a mean of 2.1 patients. What is the probability it will run of beds today? 7) The braking distance for a used car...
-
The following table shows the aggregate demand and aggregate supply schedules for the economy of Queen's Island. The potential GDP is $1,600. Aggregate Quantity Demanded $2000 1800 1600 1400 1200...
-
Discuss what you see as the role of ethics as it pertains to management and managers. Does management, in your view, help shape the values and ethics of an organization? What about an organization's...
-
If r(t) = t i + t2 j + t3 k is the position vector for a moving particle at time t, find the tangential and normal components, aT and aN, of the acceleration vector at t = 1.
-
Before antibiotics were available, it wasnt uncommon for people in the United States (and elsewhere) to develop rheumatic fever. The infection can trigger an inflammation that ultimately damages...
-
Write the following in polar form, \(z=r e^{i \theta}\). a. \(i-1\). b. \(-2 i\). c. \(\sqrt{3}+3 i\).
-
For the past several years, Shane Banovich has operated a part-time consulting business from his home. As of October 1, 2012, Shene decided to move to rented quarters and to operate the business as...
-
The following data items are maintained in a company's database for each fixed asset item that it owns: fixed asset number, fixed asset description, fixed asset classification, location, responsible...
-
Given the bill of materials for the printer cartridge (A) shown below, a gross requirement to build 200 units of A, on-hand inventory levels for each item as shown in the table below, and assuming...
-
Pleaseshow all work and answer question fully. Thank you! 1.2 What is the difference between passive and active security threats? 7.3 What is the goal of a flooding attack. 7.1 In order to implement...
-
How might auditors be users of a data repository system? How might auditors' use of the data repository system give insight into the problems of other users?
-
Why is obtaining support from programmers and systems analysts for a data repository system sometimes difficult? Why is it important to obtain their support? How might their support be obtained?
-
Briefly explain how separation of duties can be used to increase control over the DA and the DBA.
-
There are two types of remedial measures that can be used to increase control over the DA and the DBA: (a) administrative controls, and (b) technical controls. Explain the nature of each set of...
-
Give three examples of tools that DAs and DBAs need to perform their functions but which can also be used to override database integrity.
-
Every student in COM 1 0 1 wishes there were no exams in the class, so there should not be exams in COM 1 0 1 " is an example of what type of logical fallacy? Explain
-
Is it a breach of fiduciary duty for a director of a real estate investment trust (REIT) negotiating a joint venture on behalf of the REIT with another director for the development of a portfolio of...
-
You are assessing internal control in the audit of the payroll and personnel cycle for Rogers Products Company, a manufacturing company specializing in assembling computer parts. Rogers employs...
-
The following (1 through 18) are the balance-related, transaction-related, and presentation and disclosure related audit objectives. Balance-Related Audit Objectives 1. Existence 2. Completeness 3....
-
Identify and explain factors that should keep the quality of audits high even though advertising and competitive bidding are allowed.
-
At the end of the accounting period, a journal entry is made to close variance accounts to_or________________________,and________________________,.
-
How does Porters competitive forces model help companies develop competitive strategies using information systems? Define Porters competitive forces model and explain how it works. Describe what...
-
True or false? Standard cost variances provide definitive evidence that costs are out of control and managers are not performing effectively.
Study smarter with the SolutionInn App