I need help on where the data goes in the excel chart and to answer the two questions below!!!!!!

Enter data into following excel sheet and answer questions.

1. Is the company's cash outlook good or bad for the year? Why or why not?

2. What two specific financial recommendations would you make to improve the cash outlook for the year?

I posted requirements at top

Startup Costs - Year 1 Amount Coffee Roaster $1500 Espresso Machine $3500 Coffee Brewing Equipment $500 Initial Green Coffee Order $2000 $600 Initial Drink Packaging Order Initial Branding, Website & Marketing Package $1000 Employee Training $1250 Upfits to the Space $2000 Total Startup Costs $12,350 Monthly Overhead Costs - Year 1 Amount Rent $800 Utilities $100 Salaries $5000 Insurance $250 Marketing $50 Professional Fees $50 Loan Payments $180 Miscellaneous $150 Total Overhead Costs $6580 Units of Sale As mentioned previously, GOOD COFFEE CO. will serve brewed coffee as well as specialty espresso drinks. They will also sell their own branded bags of coffee beans for people to brew at home. The price points for each of these units as well as their variable costs are outlined below. Cup of Coffee - $2.00 Variable Costs Coffee Beans $0.31 Cream, Sweeteners etc. (Average) $0.05 Packaging: cup, lid, sleeve $0.20 Total $0.56 Specialty/Espresso Drink - $4.50 Variable Costs Coffee Beans $0.37 Milk & Other Specialty Ingredients (Average) $0.70 I Cup and Sleeve $0.20 Total $1.27 Pound of Coffee Beans - $14 Variable Costs Coffee Beans $5.50 Packaging: bag and label $1.25 Total $6.75 Multi-Unit Break-even Point Ramona and Kareem predict that regular cups of coffee will make up 30% of total sales, specialty drinks will make up 45% of sales, and retail coffee beans will make up the remaining 25% of sales. They use this information to calculate a multi-unit break-even point by taking those percentages of their monthly overhead budget for their calculation. Their calculations are below. 1. $6580 x .3 = $1974 / ($2 - $0.56) = 1371 cups of coffee per month 2. $6580 x 45 = $2961/($4.50 - $1.27) = 917 specialty drinks per month (rounded up) I 3. $6580 x 25 = $1645 / ($14 - $6.75) = 227 bags of coffee beans per month (rounded up) These break-even points help to guide their sales projections for the year. Sales Projection Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1. 800 1000 1200 1400 1200 1000 1000 1200 1400 1500 1400 1400 2. 600 800 1000 1200 1000 800 800 1000 1200 1400 1200 1200 3. 180 200 220 250 220 200 200 220 250 300 250 350 Since they are starting during a slow time of year they expect it will take them a few months to work up to their break-even point. They also expect the summer to be a slower time since most of their target market will be gone. However, they hope an increase in tourist traffic may help offset some of that loss of business. They expect a boost in coffee bean sales around the holidays at the end of the year. 2014 VC Feb-21 Mart May 21 MH Sep 21 E-DO Nov 21 Dec 21 TOTAL UNITS SOLD CASH IN Sa 111 III O One med AI BOERE CAN CASH OUT Vw Com C005 COGS COS COGS VCD Moe Costa Owie ant U MUS Verpes DEL HINDI OD ULL WS ! M Employee PS Wheep Adrano Other www Towed ALCANO Chow EROW Cathan Hand Startup Costs - Year 1 Amount Coffee Roaster $1500 Espresso Machine $3500 Coffee Brewing Equipment $500 Initial Green Coffee Order $2000 $600 Initial Drink Packaging Order Initial Branding, Website & Marketing Package $1000 Employee Training $1250 Upfits to the Space $2000 Total Startup Costs $12,350 Monthly Overhead Costs - Year 1 Amount Rent $800 Utilities $100 Salaries $5000 Insurance $250 Marketing $50 Professional Fees $50 Loan Payments $180 Miscellaneous $150 Total Overhead Costs $6580 Units of Sale As mentioned previously, GOOD COFFEE CO. will serve brewed coffee as well as specialty espresso drinks. They will also sell their own branded bags of coffee beans for people to brew at home. The price points for each of these units as well as their variable costs are outlined below. Cup of Coffee - $2.00 Variable Costs Coffee Beans $0.31 Cream, Sweeteners etc. (Average) $0.05 Packaging: cup, lid, sleeve $0.20 Total $0.56 Specialty/Espresso Drink - $4.50 Variable Costs Coffee Beans $0.37 Milk & Other Specialty Ingredients (Average) $0.70 I Cup and Sleeve $0.20 Total $1.27 Pound of Coffee Beans - $14 Variable Costs Coffee Beans $5.50 Packaging: bag and label $1.25 Total $6.75 Multi-Unit Break-even Point Ramona and Kareem predict that regular cups of coffee will make up 30% of total sales, specialty drinks will make up 45% of sales, and retail coffee beans will make up the remaining 25% of sales. They use this information to calculate a multi-unit break-even point by taking those percentages of their monthly overhead budget for their calculation. Their calculations are below. 1. $6580 x .3 = $1974 / ($2 - $0.56) = 1371 cups of coffee per month 2. $6580 x 45 = $2961/($4.50 - $1.27) = 917 specialty drinks per month (rounded up) I 3. $6580 x 25 = $1645 / ($14 - $6.75) = 227 bags of coffee beans per month (rounded up) These break-even points help to guide their sales projections for the year. Sales Projection Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1. 800 1000 1200 1400 1200 1000 1000 1200 1400 1500 1400 1400 2. 600 800 1000 1200 1000 800 800 1000 1200 1400 1200 1200 3. 180 200 220 250 220 200 200 220 250 300 250 350 Since they are starting during a slow time of year they expect it will take them a few months to work up to their break-even point. They also expect the summer to be a slower time since most of their target market will be gone. However, they hope an increase in tourist traffic may help offset some of that loss of business. They expect a boost in coffee bean sales around the holidays at the end of the year. 2014 VC Feb-21 Mart May 21 MH Sep 21 E-DO Nov 21 Dec 21 TOTAL UNITS SOLD CASH IN Sa 111 III O One med AI BOERE CAN CASH OUT Vw Com C005 COGS COS COGS VCD Moe Costa Owie ant U MUS Verpes DEL HINDI OD ULL WS ! M Employee PS Wheep Adrano Other www Towed ALCANO Chow EROW Cathan Hand