CASE 1.1 TREND ANALYSIS. The Coffee Palace just had its third business anniversary. Alice Cornwell, the company's owner, has recently become concerned. Early in the year, she increased her prices to bring in more revenue, adding $0.25 per cup to the regular and decaffeinated coffees she sells and reducing the price of noyelty coffees to increase demand for them. Now she is busier than ever, but the sales volume of each category has changed, as suggested in the following table. Product Type Regular coffee Decaffeinated coffee Flavored coffees Cappuccino Mochaccino Iced Cappuccino Iced Mochaccino Regular Latte Flavored Latte Current Price in $ $175 $1.75 $2.00 $3.00 $3.00 $3.25 $3.25 $2.50 $2.75 Last Year's Price in $ $1.50 $1.50 $1.75 $3.25 $3.25 $3.50 $3.25 $2.75 $3.00 Current Volume 4.500 4,000 4.000 3,000 2,500 1,800 Last Year's Volume 8,080 5,800 6,000 2,000 1,800 1,200 2,600 3,000 2,100 3,500 4,500 3,000 Alice is worried because a lot more labor goes into making the novelty drinks than simply pouring a cup of regular coffee. Specifically, materials to make specialty coffees average $1.25 a cup, while the cost for materials for regular coffee (the cup, a lid, and the coffee itself) is only $0.50. Labor for the novelty drinks is three minutes at $10 per hour, while labor for regular coffee drinks is only one minute. Learning that you are taking a course at college that deals specifically with trends in costs and profits, Alice enlists your help in exchange for free coffee (regular) for the year. To help Alice, you do the following: a. Calculate the total direct costs (labor and materials) for each type of prod- uct Alice makes. Your table should look like: Product Type Materials (1) Labor Costs (2) Total Cost per Cup (1) + (2) b. Complete a table that determines the profit made per type of product sold by Alice. It should look like this: Price Direct Costs Product Type Profit per Cup (1)-(2) (1) (2) Do this for both years of data you have. You should end up with two tables. c. With profit per cup in hand, you can now calculate how much profit Alice makes for each different type of product by year. This table should look like: Profit per Cup Volume Sold Product Type Total Profit (1) x (2) (2) Once again, calculate these numbers for two years. d. Now do a trend analysis for profitability over the two years. Your table should look like this: Product Type Profit This Year (1) Profit Last Year (2) Change in Profit (3)=(1)-(2) Percentage Change (4) = (3)/(2) e. Now determine how much sales volume has changed. Your table should look like this: Product Type Volume This Year Volume Last Year (2) Change in Volume (3) = (1) - (2) Percentage Change (4)= (3)/(2) (1) f. Using all of this data, draft a one-to two-paragraph memo to Alice explain- ing what is happening and making recommendations to help her plan the next year. CASE 1.1 TREND ANALYSIS. The Coffee Palace just had its third business anniversary. Alice Cornwell, the company's owner, has recently become concerned. Early in the year, she increased her prices to bring in more revenue, adding $0.25 per cup to the regular and decaffeinated coffees she sells and reducing the price of noyelty coffees to increase demand for them. Now she is busier than ever, but the sales volume of each category has changed, as suggested in the following table. Product Type Regular coffee Decaffeinated coffee Flavored coffees Cappuccino Mochaccino Iced Cappuccino Iced Mochaccino Regular Latte Flavored Latte Current Price in $ $175 $1.75 $2.00 $3.00 $3.00 $3.25 $3.25 $2.50 $2.75 Last Year's Price in $ $1.50 $1.50 $1.75 $3.25 $3.25 $3.50 $3.25 $2.75 $3.00 Current Volume 4.500 4,000 4.000 3,000 2,500 1,800 Last Year's Volume 8,080 5,800 6,000 2,000 1,800 1,200 2,600 3,000 2,100 3,500 4,500 3,000 Alice is worried because a lot more labor goes into making the novelty drinks than simply pouring a cup of regular coffee. Specifically, materials to make specialty coffees average $1.25 a cup, while the cost for materials for regular coffee (the cup, a lid, and the coffee itself) is only $0.50. Labor for the novelty drinks is three minutes at $10 per hour, while labor for regular coffee drinks is only one minute. Learning that you are taking a course at college that deals specifically with trends in costs and profits, Alice enlists your help in exchange for free coffee (regular) for the year. To help Alice, you do the following: a. Calculate the total direct costs (labor and materials) for each type of prod- uct Alice makes. Your table should look like: Product Type Materials (1) Labor Costs (2) Total Cost per Cup (1) + (2) b. Complete a table that determines the profit made per type of product sold by Alice. It should look like this: Price Direct Costs Product Type Profit per Cup (1)-(2) (1) (2) Do this for both years of data you have. You should end up with two tables. c. With profit per cup in hand, you can now calculate how much profit Alice makes for each different type of product by year. This table should look like: Profit per Cup Volume Sold Product Type Total Profit (1) x (2) (2) Once again, calculate these numbers for two years. d. Now do a trend analysis for profitability over the two years. Your table should look like this: Product Type Profit This Year (1) Profit Last Year (2) Change in Profit (3)=(1)-(2) Percentage Change (4) = (3)/(2) e. Now determine how much sales volume has changed. Your table should look like this: Product Type Volume This Year Volume Last Year (2) Change in Volume (3) = (1) - (2) Percentage Change (4)= (3)/(2) (1) f. Using all of this data, draft a one-to two-paragraph memo to Alice explain- ing what is happening and making recommendations to help her plan the next year