Copy of Excel Exercise 3 - Christian Tan.xlsx - Donut...

Donut Information
Assume that each customer will buy one donut and one cup of coffee
Sales estimate range from 200-5000 per week
Time period
Revenue: Cup of Coffee $4.00
Revenue: Donut $3.50
Donut ingredients per donunt) per donut $0.60
$5,550.00
paper products: napkins, plates etc
Insurance month $200.00
$7.50 total revenu
Maintenance & Repairs to equipment month $0.00
VC Coffee $0.35
Marketing & Promotion: Advertising month $50.00
VC Donut $0.60
Coffee per cup $0.25
total vc $0.95
Coffee cups per cup $0.10
Payroll: Wages (Owner/ Manager) month $2,500.00
fixed $5,550.00
Payroll: Wages (per Employees) month $1,000.00
Donut and Coffee equipment rent month $500.00
total cost $5,550.95
Professional Fees: Accounting month $50.00
Professional Fees: Legal month $25.00
profit -$5,543.45
Powdered and Liquid Beverages
$0.00
Rent month $1,000.00
$1,500.00
Supplies: Office month $25.00
Utilities month $200.00
Muffins to Go
Assume that each customer will buy one muffin and one cup of coffee
Sales estimate range from 200-5000 per week
Muffin Financial Information
Time period
Revenue: Cup of Coffee $4.00
fixed expenses $9,350.00
Revenue: Muffin $5.50
Muffin ingredients (per muffin) per donut