The following information was taken from the accounting records of Pembroke Ltd. and Deep River Ltd. at
Question:
The following information was taken from the accounting records of Pembroke Ltd. and Deep River Ltd. at October 31, 2020. The two companies are competitors.
Required
a. Calculate the gross margin, gross margin ratio, and inventory turnover ratio at October 31, 2020, for:
i. Pembroke Ltd.
ii. Deep River Ltd.
b. During the December 31, 2020, inventory count at Deep River Ltd., $86,000 of inventory shrinkage was identified. It has not been recorded in the inventory account.
i. Prepare the entry to record the inventory shrinkage of $86,000.
ii. Recalculate Deep River’s gross margin, gross margin ratio, and inventory turnover ratio after the adjusting journal entry is made. You need to adjust the ending inventory balance for 2020 and the cost of goods sold.
iii. Describe what happened to Deep River’s gross margin ratio and inventory turnover ratio after adjusting for the inventory shrinkage.
c. Which company do you think is doing a better job in terms of managing inventory? Explain your answer.
Inventory Turnover Ratio Inventory Turnover RatioThe inventory turnover ratio is a ratio of cost of goods sold to its average inventory. It is measured in times with respect to the cost of goods sold in a year normally. Inventory Turnover Ratio FormulaWhere,...
Transcribed Image Text:
Deep River Ltd. $ 150,000 475,000 4,500,000 Pembroke Ltd. Ending inventory, Oct. 31, 2019 Ending inventory, Oct. 31, 2020 Cost of goods sold, 2020 Sales for 2020 $ 395,000 300,000 5,700,980 6,500,425 7,256,700
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 62% (8 reviews)
a i Pembroke Ltd ii Deep River Ltd Gross margin Sales revenue COGS 6500425 5700980 799445 7256700 4500000 2756700 Gross margin ratio Gross marginSales ...View the full answer
Answered By
Ashington Waweru
I am a lecturer, research writer and also a qualified financial analyst and accountant. I am qualified and articulate in many disciplines including English, Accounting, Finance, Quantitative spreadsheet analysis, Economics, and Statistics. I am an expert with sixteen years of experience in online industry-related work. I have a master's in business administration and a bachelor’s degree in education, accounting, and economics options.
I am a writer and proofreading expert with sixteen years of experience in online writing, proofreading, and text editing. I have vast knowledge and experience in writing techniques and styles such as APA, ASA, MLA, Chicago, Turabian, IEEE, and many others.
I am also an online blogger and research writer with sixteen years of writing and proofreading articles and reports. I have written many scripts and articles for blogs, and I also specialize in search engine
I have sixteen years of experience in Excel data entry, Excel data analysis, R-studio quantitative analysis, SPSS quantitative analysis, research writing, and proofreading articles and reports. I will deliver the highest quality online and offline Excel, R, SPSS, and other spreadsheet solutions within your operational deadlines. I have also compiled many original Excel quantitative and text spreadsheets which solve client’s problems in my research writing career.
I have extensive enterprise resource planning accounting, financial modeling, financial reporting, and company analysis: customer relationship management, enterprise resource planning, financial accounting projects, and corporate finance.
I am articulate in psychology, engineering, nursing, counseling, project management, accounting, finance, quantitative spreadsheet analysis, statistical and economic analysis, among many other industry fields and academic disciplines. I work to solve problems and provide accurate and credible solutions and research reports in all industries in the global economy.
I have taught and conducted masters and Ph.D. thesis research for specialists in Quantitative finance, Financial Accounting, Actuarial science, Macroeconomics, Microeconomics, Risk Management, Managerial Economics, Engineering Economics, Financial economics, Taxation and many other disciplines including water engineering, psychology, e-commerce, mechanical engineering, leadership and many others.
I have developed many courses on online websites like Teachable and Thinkific. I also developed an accounting reporting automation software project for Utafiti sacco located at ILRI Uthiru Kenya when I was working there in year 2001.
I am a mature, self-motivated worker who delivers high-quality, on-time reports which solve client’s problems accurately.
I have written many academic and professional industry research papers and tutored many clients from college to university undergraduate, master's and Ph.D. students, and corporate professionals. I anticipate your hiring me.
I know I will deliver the highest quality work you will find anywhere to award me your project work. Please note that I am looking for a long-term work relationship with you. I look forward to you delivering the best service to you.
Inventory turnover is a key metric that helps businesses evaluate the efficiency of their operations. A high turnover ratio is generally considered positive, indicating that the company is effectively selling its inventory and making efficient use of its resources. On the other hand, a low turnover ratio may indicate issues such as overstocking or slow sales and may require further examination to identify and address the underlying causes.
Businesses use this ratio to make decisions about inventory levels, production schedules, and pricing strategies. It also helps businesses to identify areas where they may need to make improvements, such as reducing lead times for production or optimizing sales and marketing efforts. Additionally, inventory turnover is used by investors and analysts as a key performance indicator to evaluate the financial health and growth potential of a company.