Using our Tools: Horizontal analysis, Vertical analysis, TrendIndex, and Trend Result Prepare a comparative haricomtal analysis of the change in cach current asset account from Last Year to This Year. Express cach change in dollars and the percentage each change represents Below is the Current Asset portion of a company's Balance Sheet Current Assets Last Year This Year Cash 12 392 14.580 Credit Card Receivable 2,700 3,460 Accounts receivable 530 150 Food inventories 4.280 4,366 Beverage inventories 1,850 1,702 1,400 1.610 Prepaid expenses Total Current Assets 23,652 25,868 Now using the same data use wertical analysis to see how the allocation of the assets changed year over year. That is, what is the "mi" of our assets and how did it change Prepare two separate PIE CHARTS for Last Year and This Year to see the proportion of assets graphically Which asset or assets had the biggest change on the pie chart - Look at the pieces did one piece get a lot bigger or smaller? Below is the Current Asset portion of a company's Balance Sheet Current Assets Last Year This Year Cash 12,892 14,580 Credit card Receivable 2,700 3,460 Accounts receivable 530 150 Food Inventories 4,280 4,366 Beverage inventories 1,850 1,702 1.400 1,610 Prepaid expenses Total Current Assets 23,652 25,868 This is a Weighted Average Problem (at least the first part is): A motel has 70 rooms it usually rents out, in the following proportions: 45% singles at: $60 per night 35% doubles at: $74 per night 20% triples at: $90 per night Use weighted average to compute the Average Room Rate per night The motel has annual fixed costs of $445,000 and variable costs averages $14 per room occupied. a. Calculate the motel's breakeven level and its occupancy percentage. b. Calculate the occupancy percentage that will provide operating income (before tax) of $65,000 a year. c. Calculate the occupancy percentage necessary to provide an operating income (before tax) of $65,000, if the average room rate were decreased by 20% Hint: you can recompute the weighted average based on ($60-$12 = 48, $74-14.80=59.20, and $90-$18=72). Or you can use a shortcut based on your knowledge of weighted average