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.

Transcribed Image Text:

Inventory Sales for the Cost of sales for year ended October 31, 2017 October 31,2018 October 31, 2018 October 31, 2018 Inventory balance orn balance orn year ended they Category Porcelain figurines$146,250 Toys Linens $159,500 126,250 147,500 $862,500 692,750 405,750 S345,000 415,750 202,875 168,750 102,500