Calculate the light blue areas of this spreadsheet.
Location Analysis
Location Rent
Bus Stop $ 750
Post Office $ 1,000
Town Center $ 1,150
Calculate GM$/Bowl and Bowls needed to achieve GM$ target. Assume costs are $2.151/b
Price GM$ / Bowl
$ 5.00 $ 2.85
$ 6.00 $ 3.85
$ 5.50 $ 3.35
Marketing Research
Input Information
Marketing Channels Cost to Design Ad
Print Ads
Flyers on Doors (8 hrs delivery*$10/hr) $ 100.00
Pens (5 hrs at tradeshow*$10/hr) $ 25.00
Local Newspaper Ad (4x6inch) $ 100.00
Magazine Ad (4x6 inch) to target audience $ 150.00
Small Signs on corners ($8 ea*15 signs) $ 100.00
Billboard heading out of town $ 200.00
Direct Mail (Letters) to target audience $ 100.00
Electronic Media
Radio Ad (30 seconds) $ 300.00
Television Ad (30 seconds) $ 1,000.00
Emails $ 100.00
,Online Ads
Facebook Ads $ 150.00
YouTube Ads $ 1,000.00
Google Ads $ 150.00
Bing Ads $ 150.00
Social Media
Videos (video creation) $ 500.00
Instagram Posts $ 200.00
Influencer Recommendations to Target Audience $ 100.00
Innovation / New Product Analysis - Put this information into
Assum
Ingredient Qty
Chicken 1
Rice 20
Salt 1
Water 100
Secret Spices 100
Flour 20
Yeast 0.5
Honey 2.25
Vegetables 10
Beans 20
Spicy Sausage 1
Other Secret Spices 100
Beef 1
Beef Broth 2
Soft Drink Concentrate 20
Carbonation 378
Ice 10
Paper drink cups 100
Recopies and Labor for Each Product
Calculate COGS Mat and COGS Lab for each product.
Chicken & Rice Soup
, Ingredient Qty
Chicken 1
Salt 20
Secret Spices 18
Rice 450
Water 2.5
Total Cost
Bowls per batch 10
Laborer Time (minutes)
Cook per pot 30
Server / bowl 3
Dishwasher / bowl 1.5
Total Direct Labor
Italian Bread - 3 loaves
Ingredient Qty
Flour 750
Salt 6
Water 0.8
Yeast 15
Honey 75
Total Cost
2-Slice servings per batch 15
Laborer Time (minutes)
Cook per batch 20
Server / per serving 0
Dishwasher / per serving 0.5
Total Direct Labor
Spicy Sausage & Bean Soup
Ingredient Qty
Spicy Sausage 300
Salt 9
Vegetables 1,000
Water 1.5
Other Secret Spices 25
Location Analysis
Location Rent
Bus Stop $ 750
Post Office $ 1,000
Town Center $ 1,150
Calculate GM$/Bowl and Bowls needed to achieve GM$ target. Assume costs are $2.151/b
Price GM$ / Bowl
$ 5.00 $ 2.85
$ 6.00 $ 3.85
$ 5.50 $ 3.35
Marketing Research
Input Information
Marketing Channels Cost to Design Ad
Print Ads
Flyers on Doors (8 hrs delivery*$10/hr) $ 100.00
Pens (5 hrs at tradeshow*$10/hr) $ 25.00
Local Newspaper Ad (4x6inch) $ 100.00
Magazine Ad (4x6 inch) to target audience $ 150.00
Small Signs on corners ($8 ea*15 signs) $ 100.00
Billboard heading out of town $ 200.00
Direct Mail (Letters) to target audience $ 100.00
Electronic Media
Radio Ad (30 seconds) $ 300.00
Television Ad (30 seconds) $ 1,000.00
Emails $ 100.00
,Online Ads
Facebook Ads $ 150.00
YouTube Ads $ 1,000.00
Google Ads $ 150.00
Bing Ads $ 150.00
Social Media
Videos (video creation) $ 500.00
Instagram Posts $ 200.00
Influencer Recommendations to Target Audience $ 100.00
Innovation / New Product Analysis - Put this information into
Assum
Ingredient Qty
Chicken 1
Rice 20
Salt 1
Water 100
Secret Spices 100
Flour 20
Yeast 0.5
Honey 2.25
Vegetables 10
Beans 20
Spicy Sausage 1
Other Secret Spices 100
Beef 1
Beef Broth 2
Soft Drink Concentrate 20
Carbonation 378
Ice 10
Paper drink cups 100
Recopies and Labor for Each Product
Calculate COGS Mat and COGS Lab for each product.
Chicken & Rice Soup
, Ingredient Qty
Chicken 1
Salt 20
Secret Spices 18
Rice 450
Water 2.5
Total Cost
Bowls per batch 10
Laborer Time (minutes)
Cook per pot 30
Server / bowl 3
Dishwasher / bowl 1.5
Total Direct Labor
Italian Bread - 3 loaves
Ingredient Qty
Flour 750
Salt 6
Water 0.8
Yeast 15
Honey 75
Total Cost
2-Slice servings per batch 15
Laborer Time (minutes)
Cook per batch 20
Server / per serving 0
Dishwasher / per serving 0.5
Total Direct Labor
Spicy Sausage & Bean Soup
Ingredient Qty
Spicy Sausage 300
Salt 9
Vegetables 1,000
Water 1.5
Other Secret Spices 25
