Question

In: Accounting

Quantitative Reasoning Problem 3 ACC 121 Assignment is to be completed as a Word Document, PDF,...

Quantitative Reasoning Problem 3

ACC 121

Assignment is to be completed as a Word Document, PDF, or on notebook paper and submitted through Moodle


Assume a company maintains an inventory level of $30,000, meaning the average balance in the inventory records is $30,000. Also assume it’s annual cost of good sold (COGS) is $120,000.

The management is proposing to reduce inventory levels to $15,000 with no impact on cost of goods sold. To do so they propose working with suppliers to get quicker deliveries and to make smaller, more frequent orders.

Required:

Compute the company’s inventory turnover and its days sales in inventory under both current conditions and proposed conditions.








Evaluate and comment on the merits of their proposal given your analysis for part 1. Identify any concerns you might have about the proposal.

Solutions

Expert Solution

ANSWER) INVENTORY TURNOVER = COST OF GOODS SOLD / AVERAGE INVENTORY

DAYS SALES UNDER INVENTORY= NO.OF DAYS / INVENTORY TURNOVER

PARTICULARS INVENTORY TURNOVER DAY SALES INVENTORY

PRESENT CONDITION 120000/30000=4 365/4=91.25 DAYS

PROPOSED CONDITION 120000/15000=8 365/8=45.625 DAYS

COMMENTS: IN PRESENT CASE CASH CONVERSION CYCLE HAVING 3 COMPONENTS THEY ARE FIRST CASH INTO INVENTORY SECOND INVENTORY INTO SALES THIRD ONE SALES INTO RECIVED CASH . THE THREE PERIODS ARE IMPORTENT BECAUSE ANY BUSINESS WE REQUIRE SUFFICINT CASH TO MOBILISE FUNDS AND REPAY DEBTS INTIME REPAY DIVIDENDS INTIME ETC. FOR THIS PURPOSE THE PRESENT CONDITION HAVING 91.25 INVENTORY DAY SALES THE PROPSED CONDITION HAVING 45.625 DAYS SALES PRESENT CONDITION HAVING 45.625 MORE CASH CYCLE TIME THAN PROPSED CONDITION. SO THAT COMPANY CAN USE PROPSED CONDITION FOR REDUCTION IN CASH CYCLE TME. THE PROPSED CONDITION IS BETTER THEN THE PRESENT CONDITION.


Related Solutions

Quantitative Reasoning Problem 3 ACC 122 Assignment is to be completed as a Word Document, PDF,...
Quantitative Reasoning Problem 3 ACC 122 Assignment is to be completed as a Word Document, PDF, or on notebook paper and submitted through Moodle Compare two alternatives for financing - Issuance of common stock vs. Issuance of bonds. Northeast Airlines is considering two alternatives for the financing of the purchase of a fleet of airplanes. These two alternatives are: Issue 60000 shares of common stock at $45 per share. (Cash dividends have not been paid nor is the payment of...
Quantitative Reasoning Problem 2 ACC 122 Assignment is to be completed as a Word Document, PDF,...
Quantitative Reasoning Problem 2 ACC 122 Assignment is to be completed as a Word Document, PDF, or on notebook paper and submitted through Moodle The table below contains letters a, b, c, d. 2018 2017 Average common stockholder equity $1,800,000 $1,900,000 Dividends paid to common shareholders 90,000 70,000 Dividends paid to preferred shareholders 20,000 20,000 Net Income 290,000 248,000 Market Price of common stock $20 $25 Weighted average number of shares common stock outstanding 150,000 180,000 Earnings per share (a)...
This assignment must be completed on a Word Document and submitted. All questions related to the...
This assignment must be completed on a Word Document and submitted. All questions related to the case study must be answered completely in order to receive full credit. This case study assesses SLO #2: "On completion of this course, student will describe steps taken to prevent and manage medical emergencies in the dental office." You have just seated your patient to have a tooth prepared for a crown. It has already been a hectic morning and the dentist has urged...
Please upload your calculations (e.g., an Excel spreadsheet, a Word document, a PDF file, or a...
Please upload your calculations (e.g., an Excel spreadsheet, a Word document, a PDF file, or a picture of your work) for Q21. Q21. Consider a 2-year bond. The coupon rate of the bond is 10%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 8.0% annually, or 4.0% semi-annually. (a) What is the duration of the bond measured in half-years and in years? (10 points) (b) If the semi-annually yield changes from 4.0%...
VBA In this assignment you will create a Word Macro-Enabled Document. The document will contain procedures...
VBA In this assignment you will create a Word Macro-Enabled Document. The document will contain procedures with the following declarations: • Sub Main() • Sub GetGrades(grades() As Integer, total As Integer) • Sub CreateOutput(className As String, grades() As Integer, total As Integer) The Main sub-procedure will be the macro that initializes the task. In this procedure you will declare all necessary variables, prompt the user to enter the name of the class and the number of students, resize the grades...
This assignment has three parts that should all be completed on one document. For this assignment...
This assignment has three parts that should all be completed on one document. For this assignment you will explore the cost-effectiveness of informatics interventions in healthcare. In your role as director of health informatics you are tasked with putting together an executive report that outlines and EHR adoption the effectiveness of EHR. The detailed assignment requirements are below. Part I Summary of laws and mandates requiring EHR adoption EHR & treatment effectiveness and efficiency Be sure to discuss how PHR...
For Assignment 2, submit a word or pdf file with the SQL queries along with screenshots...
For Assignment 2, submit a word or pdf file with the SQL queries along with screenshots of the outputs. (It is ok if the whole problem cannot be answered, if possible, I just would like an idea of how to begin, thanks in advance!) 9. Write a query to count the number of invoices. 10. Write a query to count the number of customers with a balance of more than $500. 11. Generate a listing of all purchases made by...
Assignment Requirements Please complete all parts in a Microsoft Word document. The body of your document...
Assignment Requirements Please complete all parts in a Microsoft Word document. The body of your document should be at least 900 words in length. Quoting should be less than 10% of the entire paper. Paraphrasing is necessary. Students must cite and reference at least 4 credible sources from the Library. Instructions Imagine that you are an administrator for a large hospital. As part of your role within healthcare leadership, you are involved in several committees for the organization. For this...
Submitting your assignment   1. Please collate your assignment as a single document in a Microsoft Word...
Submitting your assignment   1. Please collate your assignment as a single document in a Microsoft Word format. 2. Save the assignment as your candidate ID number, e.g. CON-000123456. 3. All marking is anonymous, which means your name should not appear on your work. 4. You must state which region/jurisdiction you are from in the header of each page. 5. You must ensure that all your work is properly referenced. 6. Penalties will be applied to those candidates who submit their...
research the Caesar Cipher, and document your research in 2-3 pages in a Word document with...
research the Caesar Cipher, and document your research in 2-3 pages in a Word document with illustrations in your document and provide an example of how the Caesar Cipher works while encrypting and decrypting a sample message. Also, add its history and its internal workings. Summary of the areas to complete: - Research the Caesar Cipher. - Show its Encryption Method in details. - Show its Decryption Method in details. - Describe its History and what it was used for....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT