Express your answers in an Excel document.

After experiencing such great success with their food cart, Nathan and Cody are considering purchasing a food truck to serve other communities. This would allow the Great Tamale, GT, to reach even more customers in different geographic locations. There would be an increase in the selling price per plate. There will also be an increase in the fixed costs of $30,000 for advertising to inform the public of this change (this amount is already included below under Food Truck data). The financial information is presented below for this alternative as well as the original data. Assume 31,125 plates are sold for the food cart and 45,625 plates are sold for the food truck.

	Food Cart	Food Truck
Sales	$ 217,875.00	$ 365,000.00
Variable cost	46,687.50	103,437.50
Contributuion margin	171,187.50	261,562.50
Fixed Cost	90,000.00	147,500.00
Income Before Taxes	81,187.50	114,062.50
Income Taxes (32% rate) Net income	25,980.00 $55,207.50	36,500.00 $77,562.50

4. If the company wishes each scenario, food cart and food truck, to generate target income of $250,000, what is the amount of sales that needs to be generated? How many plates will then need to be sold? Prepare a contribution margin statement for this step and verify that your income before taxes is $250,000 (after-tax net income in fact equals $170,000 at a tax rate of 32%) for both the food cart and food truck.

5. Assume that the company expects sales to decline by 20% next year. There will be no change in plate price. Prepare forecasted financial results for next year following the format of the contribution margin income statement as shown above with columns for each of the two types (assume a 32% tax rate, and that any loss before taxes yields a 32% tax savings).

6. Assume that the company expects sales to increase by 20% next year. There will be no change in plate price. Prepare forecasted financial results for next year following the format of the contribution margin income statement as shown above with columns for each of the two types (assume 32% tax rate, and that any loss before taxes yields a 32% tax savings).

7. Compute the Profit Margin and Return on Assets for each scenario assuming average total assets of $500,000. Industry averages are 20% and 10% respectively.