Question

Xena Inc. (Xena) is an importer of gift items from Europe and Asia. Xena classifies its inventory into three categories: porcelain figurines, toys, and linens. Over the years, Xena has found that the success of the three categories has tended to vary, sometimes quite significantly, although, fortunately for the company, poor performance of one category seems to be offset by success in another. On its balance sheet and income statement, Xena doesn't break down its inventory, sales, and cost of sales into the three categories.
For its years ended October 31, 2017 and 2018, Xena reported inventory of $417,500 and $433,250 respectively. For the fiscal year ended October 31, 2018, Xena reported sales of $1,961,000 and cost of sales of $963,625. However, the following breakdown of inventory, sales, and cost of sales has been made available to you:



Required:
a. Calculate the gross margin percentage, inventory turnover ratio, and the average number of days inventory on hand for the year ended October 31, 2018 using the aggregated amounts reported for inventory, sales, and cost of sales on Xena's balance sheet and income statement.
b. Calculate the gross margin, inventory turnover ratio, and the average number of days inventory on hand for the year ended October 31, 2018 for each category of inventory that Xena carries.
c. What are the implications of the results you obtained in parts (a) and (b) of the question?
d. How is your ability to analyze Xena affected by the aggregated information presented in the company's balance sheet and income statement versus the information that was made available to you? Explainfully.


$1.99
Sales0
Views65
Comments0
  • CreatedFebruary 26, 2015
  • Files Included
Post your question
5000