Livanos, Inc. records all its sales as credit sales and pays cash operating costs in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Livanos, Inc. records all its sales as credit sales and pays cash operating costs in the month incurred. Amounts for 2017 are given in the table that follows. Additional assumptions are: 1) Amounts due from customers are collected 40% in the month of sale and 60% in the following month; 2) The ratio of Cost of goods sold to Sales is 65%; 3) Livanos pays for inventory purchases 20% in the month of the purchase and 80% in the following month; 4) Monthly operating expenses are: Salaries, $60,000; Depreciation, $25,000; Rent, $20,000; and Utilities, $3,0003; 5) Accounts payable is only used for inventory acquisitions. Use the following worksheet to determine the ending cash balance in May, assuming the beginning cash balance in April is $180, 000. March April May June July Budgeted sales $400,000 $300,000 $280,000 $250,000 $500,000 Budgeted purchases $120,000 $112,000 $100,000 $200,000 $240,000 Cash Account April May Budget Debit Credit Debit Credit Sales March 400,000 Cash Collections are April 2$ 300,000 Debits to the Cash May $ 280,000 account June 250,000 July $ 500,000 Purchases Cash Disbursements March $ 120,000 are Credits to the April $ 112,000 Cash account May $ 100,000 June $ 200,000 July $ 240,000 Salaries $ 60,000 Rent $ 20,000 Depreciation $ 25,000 Utilities $ 30,000 Totals Net Increase (decrease) Opening Cash Balance 180,000 Ending Cash Balance %24 %24 Livanos, Inc. records all its sales as credit sales and pays cash operating costs in the month incurred. Amounts for 2017 are given in the table that follows. Additional assumptions are: 1) Amounts due from customers are collected 40% in the month of sale and 60% in the following month; 2) The ratio of Cost of goods sold to Sales is 65%; 3) Livanos pays for inventory purchases 20% in the month of the purchase and 80% in the following month; 4) Monthly operating expenses are: Salaries, $60,000; Depreciation, $25,000; Rent, $20,000; and Utilities, $3,0003; 5) Accounts payable is only used for inventory acquisitions. Use the following worksheet to determine the ending cash balance in May, assuming the beginning cash balance in April is $180, 000. March April May June July Budgeted sales $400,000 $300,000 $280,000 $250,000 $500,000 Budgeted purchases $120,000 $112,000 $100,000 $200,000 $240,000 Cash Account April May Budget Debit Credit Debit Credit Sales March 400,000 Cash Collections are April 2$ 300,000 Debits to the Cash May $ 280,000 account June 250,000 July $ 500,000 Purchases Cash Disbursements March $ 120,000 are Credits to the April $ 112,000 Cash account May $ 100,000 June $ 200,000 July $ 240,000 Salaries $ 60,000 Rent $ 20,000 Depreciation $ 25,000 Utilities $ 30,000 Totals Net Increase (decrease) Opening Cash Balance 180,000 Ending Cash Balance %24 %24
Expert Answer:
Answer rating: 100% (QA)
Cash Account April May Budget Debit Credit Debit Credit S... View the full answer
Related Book For
Government and Not for Profit Accounting Concepts and Practices
ISBN: 978-1118983270
7th edition
Authors: Michael Granof, Saleha Khumawala, Thad Calabrese, Daniel Smith
Posted Date:
Students also viewed these accounting questions
-
April 2017 May 2017 Revenues $12,600,000 $18,900,000 Variable costs: Beginning inventory $0 $1,575,000 Variable manufacturing costs 6,300,000 5,775,000 Cost of goods available for sale 6,300,000...
-
The actual selling expenses incurred in March 2017 by Fallon Company are as follows. Instructions (a) Prepare a flexible budget performance report for March using the budget data in E24-5, assuming...
-
Use the following June actual ending balances and July 31, 2016, budgeted amounts for Ollies to prepare a budgeted balance sheet for July 31, 2016. a. June 30 Merchandise Inventory balance, $17,760...
-
Suppose that the owner of the restaurant in Problem 2.91 also wants to study the demand for dessert during the same time period. She decides that in addition to studying whether a dessert was...
-
Read the article Security Controls that Work by Dwayne Melancon in the 2007 Issue, Volume 4 of the Information Systems Control Journal (available www.isaca.org/Journal/Past-Issues/2007/Volume-4...
-
Data for Wizard Health Care for January are provided in Problems 3-1A and 3-2A. Instructions Prepare an income statement, retained earnings statement, and a classified balance sheet for January. The...
-
The following e-mail with an authentic looking e-mail address and logo was received by the controller of a small business: Required a. What should Justin do about these e-mails? b. What should Big...
-
Information on Hanleys direct labor costs for January 2013 is as follows: Actual direct labor rate ........... $ 7.50 Standard direct labor hours allowed ...... 9,000 Actual direct labor hours...
-
Radio Shack, which just declared bankruptcy and is closing all of its stores, still has millions of dollars of inventory in its warehouses. What would you do to move that merchandise in a profitable...
-
1. What is your assessment of the financial performance of Nelson Nurseries? 2. Do you agree with Christine Barton?s accounts-payable policy? 3. What explains the erosion of the cash balance? 4. What...
-
Organization is Qualfon Guyana Inc, Issue being addressed is Staff Retention. What organizational actions have been taken to address the issue? What recommendations do you have to addressing this...
-
Question 12 Wifty Corporation has gathered the following information for one model of its hiking boots: 2.5 pts Variable manufacturing costs $46000 Variable selling and administrative costs Fixed...
-
A company had 10,000 partially completed units in beginning work-in- process inventory. This period, after the 10,000 beginning inventory units were completed, another 50,000 units were started. At...
-
what financial assistance providing by Asian Development Bank they provides to export and import?
-
_ _ _ _ _ _ is a corporate banking product that aids firms in collecting funds on checks received. a . EDTb.Wire transferc.Concentration system d . Lockboxa. Retail
-
Denver and Jason are brothers and have always had a close bond with each other until the death of their father Peter. Peter was a wealthy businessman and had declared in his will and last testament...
-
Question 23 Match each layer of TCP/IP model to its main function: Physical Layer Data Link Layer Network Layer Transport Layer A. (Logical Addressing) B. (Signaling) c. (Error Detection) D. (Error...
-
Beginning with a country that has a trade deficit, demonstrate graphically what will happen to a countrys potential output with globalization if that countrys costs of production fall. Explain your...
-
What are the general criteria that audit organizations use in selecting programs and activities for performance audits?
-
The following schedule shows the amounts related to general purpose supplies that a city debited and credited to the indicated accounts during a year (not necessarily the yearend balances), excluding...
-
The financial statements that follow were adapted from those of the University of Arizona. Both the statement of changes in fund balances and the notes to the statements have been omitted. Moreover,...
-
A town post office has \(\$ 800,000\) available for the purchase of delivery vehicles. There are two models, a Jeep style and a van style, under consideration. Each Jeep costs \(\$ 8000\) and each...
-
Find the solution set of the problem: minimize: 2x1 + x2 X2 X1 + 2x2 2x2 subject to: 2.01 + x2 X1, X2 IV IV IV IA -1x1 +1 4 6 0
-
Find the optimal solution, if it exists, of the problem: \[ \begin{aligned} & \text { maximize: } f=x_{1}-x_{2} \\ & -x_{1}+2 x_{2} \leq 3 \\ & x_{1}+x_{2} \geq 1 \\ & \text { subject to: }...
Study smarter with the SolutionInn App