The purpose of this assignment is to calculate asset ratios, analyze them, and compare them between two competitors in the same industry.
Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories.
Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel:
Inventory turnover
Average days in inventory
In a Word file, include the following:
Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio.
Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet.
Submit the Excel file that contains your ratios and the Word file memo to your instructor.?????ructor.
Required: 1. For financial accounting purposes, what is the total amount of product costs incurred to make 31,000 units? 2. For financial accounting purposes, what is the total amount of period costs incurred to sell 31,000 units? 3. For financial accounting purposes, what is the total amount of product costs incurred to make 33,000 units? 4. For financial accounting purposes, what is the total amount of period costs incurred to sell 29,000 units? (For all requirements, do not round intermediate calculations.) 1 Total amount of product costs 2. Total amount of period costs incurred 3 Total amount of product costs Total amount of period costsKubin Company's relevant range of production is 28,000 to 31,500 units. When it produces and sells 29,750 unit its average costs per unit are as follows: Average Cost per Unit Direct materials 8. 80 Direct labor $ 5.80 Variable manufacturing overhead 3.30 Fixed manufacturing overhead $ 6.80 Fixed selling expense $ 5.30 Fixed administrative expense S 4.30 Sales commissions 2. 80 Variable administrative 2. 30 expense Required: 1. For financial accounting purposes, what is the total amount of product costs incurred to make 29,750 units?" 2. For financial accounting purposes, what is the total amount of period costs incurred to sell 29,750 units? 3. For financial accounting purposes, what is the total amount of product costs incurred to make 31,500 units? 4. For financial accounting purposes, what is the total amount of period costs incurred to sell 28,000 units? (For all requirements, do not round intermediate calculations.)9. A difference between Pearson correlation and Spearman correlation is that Pearson correlation a. has assumptions the data should meet b. requires larger sample size C. operates on ranks of the data d. produces unreliable results e. is amenable to multiple comparisons f. is more mathematically rigorous g. makes many passes through the data h. none of the above 10. Suppose a correlation is calculated when only a limited range of the possible values on the y variable, is present in the x, y data set. Therefore the correlation result cannot be extended to apply to the entire range of x, y values that might exist among the subjects (the statistical population)- a, optimal experimental design This situation is called b. restriction of range c. sample size too large d. x,y subgroup merger e. clusters of outliers f. rarefaction g. random sampling effect h. none of the above 11. In correlation it's wise to consider statistical power for which of the following reasons? a. to examine relations among sample size, effect size, sidedness, alpha, power b, to understand why results that are not significant may still be important C. to determine the number of subjects to use in an experiment d, to make sense of biological findings in the scientific literature e. all of the above 12. In a two-sided correlation test, p = 0.06 In a one-sided correlation test on the same x, y data, p a. 0.001 b. 0,05 C. 0.03 d. 0.002 e. 0.10 f. none of the above 13. When there's no statistically significant correlation, the computed correlation coefficient is around a. zero b. - 0.9 C. + 0.8 d. + 1.0 e. - 1.0QUESTION 1 Last week, Ali found Zidane's bag which contained some very important documents. Ali returned the bag to Zidane yesterday. Zidane was so grateful that he promised to pay Ali RM5000. Zidane changes his mind today and decides not to pay Ali. a) Can Zidane claim that there was no consideration for the promise as Ali had already found the bag before the promise was made? Give a reason to your answer. (5 Marks) b) List the all FIVE (5) factors that could vitiate a contract