Exercise 2 Student Revised (1).xlsx - Donut Information Based on the below data create the profit model for Donuts to Go Assume that each customer will

Exercise 2 Student Revised (1).xlsx - Donut Information...

This preview shows page 1 - 4 out of 4 pages.

Donut Information Assume that each customer will buy one donut and one cup of coffee Sales estimate range from 200-1000 per week Time period Revenue: Cup of Coffee $4.00 Revenue: Donut $3.50 Donut ingredients per donunt) per donut $0.75 paper products: napkins, plates etc Insurance month $50.00 Maintenance & Repairs to equipment month $0.00 Marketing & Promotion: Advertising month $25.00 Coffee per cup $0.25 Coffee cups per cup $0.10 Payroll: Wages (Owner/ Manager) month $2,500.00 Payroll: Wages (per Employees) month $750.00 Donut and Coffee equipment rent month $200.00 Professional Fees: Accounting month $50.00 Professional Fees: Legal month $25.00 Powdered and Liquid Beverages $0.00 Rent month $1,000.00 $1,500.00 Supplies: Office month $25.00 Utilities month $200.00 Muffin Financial Information Revenue per unit is Time period Revenue: Cup of Coffee $4.00 Revenue: Muffin $4.50 Muffin ingredients (per muffin) per donut $1.10 paper products: napkins, plates etc Insurance month $50.00 Maintenance & Repairs to equipment month $0.00 Marketing & Promotion: Advertising month $25.00 Coffee per cup $0.25 Based on the below data, create the profit model for
Image of page 1
Image of page 2
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture