Answered step by step
Verified Expert Solution
Question
1 Approved Answer
given the following information fill in the blanks given the following fill in the blanks posted the pictures twice due to the first set being
given the following information fill in the blanks
given the following fill in the blanks
posted the pictures twice due to the first set being unclear
ws 2. Based on the below data, create the profit model for Donuts to Go. 3 Assume that each customer will buy one donut and one cup of coffee 4 Sales estimate range from 200-5000 per week Time period 8 Revenue: Cup of Coffee 9 Revenue: Donut 10 Donut ingredients per donunt) 11 paper products: napkins, plates etc 12 Insurance $4.00 $3.50 $0.60 per donut VCC VCD VCT 0.35 $0.60 0.95 5,550.00 month $200.00 $0.00 $50.00 .000.00 14 Maintenance & Repairs to equipment month 15 Marketing & Promotion: Advertising month 16 Coffee per cup 17 Coffee cups per cup 18 Payroll: Wages (Owner Manager) month 19 Payroll Wages (per Employees) month 20 Donut and Coffee equipment rent month 21 Professional Fees: Accounting month 22 Professional Fees: Legal month 23 Powdered and Liquid Beverages 24 Rent month Previous research expense for 25 Donuts advancements 26 Supplies Office month 27 Us m onth $50.00 $25.00 $0.00 $1,000.00 $1,500.00 $25.00 29 Muffins to Go 30 Assume that each customer will buy one muffin and one cup of coffee 31 Sales estimate range from 200-5000 per week VCC VCM VCT 0.35 $1.20 1.55 9,350.00 34 Muffin Financial Information SA Time period 36 Revenue: Cup of Coffee $4.00 37 Revenue: Muffin $5,50 38 Muffin ingredients (per muffin) per donut $1 20 39 paper products: napkins, plates etc 40 Insurance month $500.00 41 42 Maintenance & Repairs to equipment month $0.00 43 Marketing & Promotion: Advertising month $250.00 44 Coffee per cup 50.25 45 Coffee cups . per cup $0.10 46 Payroll Wages (Owner/ Manager) month $2,500.00 47 Payroll Wages (per Employees) month $1,000.00 48 Muffin and Coffee equipment rent month $2,500.00 49 Professional Fees: Accounting month $50.00 50 Professional Fees: Legal month $25.00 51 Powdered and Liquid Beverages $0.00 52 Rent month $2,000.00 53 Previous research expense for Muffin advancemd $2,000.00 54 Supplies Office month $25.00 55 Utilities month $500.00 DTG Quantity sold 0 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 Revenue 0 coffee donut Total Revenue 0 0 2000 1750 3750 4000 3500 7500 6000 5250 11250 8000 7000 15000 10000 8750 18750 12000 10500 22500 14000 12250 26250 16000 14000 30000 18000 15750 33750 20000 17500 37500 Fixed Expenses Total Fixed Expense 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 Variable Expenses Coffee Variable expense 0.00 175.00 350.00 525.00 700.00 875.00 1,050.00 1,225.00 1,400.00 1,575.00 1,750.00 Donut Variable expense 0 300 600 900 1200 1500 1800 2100 2400 2700 3000 Total Variable Expenses 0.00 475.00 950.00 1,425.00 1,900.00 2,375.00 2,850.00 3,325.00 3,800.00 4,275.00 4,750.00 Total Expenses 5,550,00 6,025.00 6,500.00 6,975.00 7,450.00 7,925.00 8,400.00 8,875.00 9,350.00 9,825.00 Profit Donuts and Coffee N 1,000.00 4,275.00 7,550.00 mm MITG Quantity sold 0 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 Revenue 0 coffee Muffins Total Revenue 0 0 20004000 2750 5500 4750 9500 6000 8000 10000 82501100013750 14250 19000 23750 12000 16500 28500 14000 19250 33250 16000 18000 2200024750 38000 42750 20000 27500 47500 Fixed Expenses Total Fixed Expense 9,350,00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350,00 9,350.00 9,350.00 9,350.00 Variable Expenses Coffee Variable expense Muffin Variable expense 0.00 0 175.00 600 350.00 1200 525.00 1800 700.00 2400 875.00 1,050.00 1,225.00 1,400.00 1.575,00 1,750.00 3000 3600 4200 4800 5400 6000 Total VariableExpenses 0.00 775.00 1,550.00 2,325.00 3,100.00 3,875.00 4,650.00 5,425.00 6,200,00 6,975.00 7,750.00 Total Expenses 9.350.00 tot www www 9 Profit Muffin and Coffee a w o 2,575.00 6,550.00 RON 1 Donut Information 2 Based on the below data, create the profit model for Donuts to Go. Assume that each customer will buy one donut and one cup of coffee 4 Sales estimate range from 200-5000 per week VCC VCD VCT 0.35 $0.60 0.95 5,550.00 Time period 8 Revenue: Cup of Coffee $4.00 9 Revenue: Donut $3.50 10 Donut ingredients per donunt) per donut $0.60 11 paper products: napkins, plates etc 12 Insurance month $200.00 13 14 Maintenance & Repairs to equipment month $0.00 15 Marketing & Promotion: Advertising month $50.00 16 Coffee per cup $0.25 17 Coffee cups per cup $0.10 18 Payroll: Wages (Owner/ Manager) month $2,500.00 19 Payroll: Wages (per Employees) month $1,000.00 20 Donut and Coffee equipment rent month $500.00 21 Professional Fees: Accounting month $50.00 22 Professional Fees: Legal month $25.00 23 Powdered and Liquid Beverages $0.00 24 Rent month $1,000.00 Previous research expense for 25 Donuts advancements $1,500.00 26 Supplies: Office month $25.00 27 Utilities Imonth $200.00 29 Muins to Go 30 Assume that each customer will buy one muffin and one cup of coffee 31 Sales estimate range from 200-5000 per week VCC VCM VCT F 0.35 $1.20 1.55 9,350.00 34 Muffin Financial Information Time period 36 Revenue: Cup of Coffee $4.00 37 Revenue: Muffin $5.50 38 Muffin ingredients (per muffin) per donut $1.20 39 paper products: napkins, plates etc 40 Insurance month $500.00 41 42 Maintenance & Repairs to equipment month $0.00 43 Marketing & Promotion: Advertising month $250.00 44 Coffee per cup $0.25 45 Coffee cups per cup $0.10 46 Payroll: Wages (Owner/ Manager) month $2,500.00 47 Payroll: Wages (per Employees) $1,000.00 48 Muffin and Coffee equipment rent month $2,500.00 49 Professional Fees: Accounting month $50.00 50 Professional Fees: Legal month $25.00 51 Powdered and Liquid Beverages $0.00 52 Rent month $2,000.00 53 Previous research expense for Muffin advanceme $2,000.00 54 Supplies: Office month $25.00 55 Utilities month $500.00 CE Quantity sold 0 500 1000 1500 2000 2500 3000 3500 4000 4500 000 Revenue coffee donut Total Revenue 0 O 0 2000 1750 3750 4000 6000 3500 5250 750011250 8000 7000 15000 10000 8750 18750 12000 10500 22500 14000 12250 26250 16000 14000 30000 18000 15750 33750 20000 17500 37500 Fixed Expenses Total Fixed Expense 5,550.00 5,550.00 5,550.00 5,550.00 5,55000 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 Variable Expenses Coffee Variable expense 0.00 175.00 350.00 525.00 700.00 875.00 1,050.00 1,225.00 1,400.00 1,575.00 1,750.00 Donut Variable expense 0 300 600 900 1200 1500 1800 2100 2400 2700 3000 Total VariableExpenses 0.00 475.00 950.00 1,425.00 1,900.00 2,375.00 2,850.00 3,325.00 3,800.00 4,275.00 4,750.00 Total Expenses 5,550,00 6,025.00 6,500.00 6,975.00 7,450.00 7,925.00 8,400.00 8,875.00 9,350.00 9,825.00 Profit Donuts and Coffee W 1,000.00 4,275.00 7,550.00 1,000.00 4.275.00 7.550.00 - .. TTC 1000 1500 2000 2500 3000 3500 4000 4500 5000 Quantity sold 500 Revenue coffee S0 2000 Muffins 0 2750 Total Revenue 0 4750 4000 5500 9500 6000 8250 14250 8000 11000 19000 10000 13750 23750 12000 14000 16500 19250 2850033250 16000 22000 38000 18000 24750 42750 20000 27500 47500 Fixed Expenses Total Fixed Expense 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 Variable Expenses Coffee Variable expense Muffin Variable expense 0.00 0 175.00 600 350.00 1200 525.00 1800 700.00 2400 875.00 1,050.00 1,225.00 1,400.00 1,575.00 1,750.00 3000 3600 4200 4800 5400 6000 Total VariableExpenses 0.00 775.00 1,550.00 2,325.00 3,100.00 3,875.00 4,650.00 5,425.00 6,200.00 6,975.00 7,750.00 Total Expenses 9,350.00 #ana# # # ## ## # ### # # d ata Profit Muffin and Coffee # # # # # ## 2,575.00 6,550.00 # # # se na Profit Muffin and Coffee #****# 2,575.00 6,550.00 m m Muffins to Go: 1. What is the breakeven point for Donuts to Go (assume each customer buys one donut and one coffee)? 2. Using Goat seek, if you want to achieve profit of $2000, how many donuts and coffee do you need to sell? 3. What is the contribution margin of each sale of a Coffee and 4. What is the Profit at the break even? Solve by hand and by graph ws 2. Based on the below data, create the profit model for Donuts to Go. 3 Assume that each customer will buy one donut and one cup of coffee 4 Sales estimate range from 200-5000 per week Time period 8 Revenue: Cup of Coffee 9 Revenue: Donut 10 Donut ingredients per donunt) 11 paper products: napkins, plates etc 12 Insurance $4.00 $3.50 $0.60 per donut VCC VCD VCT 0.35 $0.60 0.95 5,550.00 month $200.00 $0.00 $50.00 .000.00 14 Maintenance & Repairs to equipment month 15 Marketing & Promotion: Advertising month 16 Coffee per cup 17 Coffee cups per cup 18 Payroll: Wages (Owner Manager) month 19 Payroll Wages (per Employees) month 20 Donut and Coffee equipment rent month 21 Professional Fees: Accounting month 22 Professional Fees: Legal month 23 Powdered and Liquid Beverages 24 Rent month Previous research expense for 25 Donuts advancements 26 Supplies Office month 27 Us m onth $50.00 $25.00 $0.00 $1,000.00 $1,500.00 $25.00 29 Muffins to Go 30 Assume that each customer will buy one muffin and one cup of coffee 31 Sales estimate range from 200-5000 per week VCC VCM VCT 0.35 $1.20 1.55 9,350.00 34 Muffin Financial Information SA Time period 36 Revenue: Cup of Coffee $4.00 37 Revenue: Muffin $5,50 38 Muffin ingredients (per muffin) per donut $1 20 39 paper products: napkins, plates etc 40 Insurance month $500.00 41 42 Maintenance & Repairs to equipment month $0.00 43 Marketing & Promotion: Advertising month $250.00 44 Coffee per cup 50.25 45 Coffee cups . per cup $0.10 46 Payroll Wages (Owner/ Manager) month $2,500.00 47 Payroll Wages (per Employees) month $1,000.00 48 Muffin and Coffee equipment rent month $2,500.00 49 Professional Fees: Accounting month $50.00 50 Professional Fees: Legal month $25.00 51 Powdered and Liquid Beverages $0.00 52 Rent month $2,000.00 53 Previous research expense for Muffin advancemd $2,000.00 54 Supplies Office month $25.00 55 Utilities month $500.00 DTG Quantity sold 0 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 Revenue 0 coffee donut Total Revenue 0 0 2000 1750 3750 4000 3500 7500 6000 5250 11250 8000 7000 15000 10000 8750 18750 12000 10500 22500 14000 12250 26250 16000 14000 30000 18000 15750 33750 20000 17500 37500 Fixed Expenses Total Fixed Expense 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 Variable Expenses Coffee Variable expense 0.00 175.00 350.00 525.00 700.00 875.00 1,050.00 1,225.00 1,400.00 1,575.00 1,750.00 Donut Variable expense 0 300 600 900 1200 1500 1800 2100 2400 2700 3000 Total Variable Expenses 0.00 475.00 950.00 1,425.00 1,900.00 2,375.00 2,850.00 3,325.00 3,800.00 4,275.00 4,750.00 Total Expenses 5,550,00 6,025.00 6,500.00 6,975.00 7,450.00 7,925.00 8,400.00 8,875.00 9,350.00 9,825.00 Profit Donuts and Coffee N 1,000.00 4,275.00 7,550.00 mm MITG Quantity sold 0 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 Revenue 0 coffee Muffins Total Revenue 0 0 20004000 2750 5500 4750 9500 6000 8000 10000 82501100013750 14250 19000 23750 12000 16500 28500 14000 19250 33250 16000 18000 2200024750 38000 42750 20000 27500 47500 Fixed Expenses Total Fixed Expense 9,350,00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350,00 9,350.00 9,350.00 9,350.00 Variable Expenses Coffee Variable expense Muffin Variable expense 0.00 0 175.00 600 350.00 1200 525.00 1800 700.00 2400 875.00 1,050.00 1,225.00 1,400.00 1.575,00 1,750.00 3000 3600 4200 4800 5400 6000 Total VariableExpenses 0.00 775.00 1,550.00 2,325.00 3,100.00 3,875.00 4,650.00 5,425.00 6,200,00 6,975.00 7,750.00 Total Expenses 9.350.00 tot www www 9 Profit Muffin and Coffee a w o 2,575.00 6,550.00 RON 1 Donut Information 2 Based on the below data, create the profit model for Donuts to Go. Assume that each customer will buy one donut and one cup of coffee 4 Sales estimate range from 200-5000 per week VCC VCD VCT 0.35 $0.60 0.95 5,550.00 Time period 8 Revenue: Cup of Coffee $4.00 9 Revenue: Donut $3.50 10 Donut ingredients per donunt) per donut $0.60 11 paper products: napkins, plates etc 12 Insurance month $200.00 13 14 Maintenance & Repairs to equipment month $0.00 15 Marketing & Promotion: Advertising month $50.00 16 Coffee per cup $0.25 17 Coffee cups per cup $0.10 18 Payroll: Wages (Owner/ Manager) month $2,500.00 19 Payroll: Wages (per Employees) month $1,000.00 20 Donut and Coffee equipment rent month $500.00 21 Professional Fees: Accounting month $50.00 22 Professional Fees: Legal month $25.00 23 Powdered and Liquid Beverages $0.00 24 Rent month $1,000.00 Previous research expense for 25 Donuts advancements $1,500.00 26 Supplies: Office month $25.00 27 Utilities Imonth $200.00 29 Muins to Go 30 Assume that each customer will buy one muffin and one cup of coffee 31 Sales estimate range from 200-5000 per week VCC VCM VCT F 0.35 $1.20 1.55 9,350.00 34 Muffin Financial Information Time period 36 Revenue: Cup of Coffee $4.00 37 Revenue: Muffin $5.50 38 Muffin ingredients (per muffin) per donut $1.20 39 paper products: napkins, plates etc 40 Insurance month $500.00 41 42 Maintenance & Repairs to equipment month $0.00 43 Marketing & Promotion: Advertising month $250.00 44 Coffee per cup $0.25 45 Coffee cups per cup $0.10 46 Payroll: Wages (Owner/ Manager) month $2,500.00 47 Payroll: Wages (per Employees) $1,000.00 48 Muffin and Coffee equipment rent month $2,500.00 49 Professional Fees: Accounting month $50.00 50 Professional Fees: Legal month $25.00 51 Powdered and Liquid Beverages $0.00 52 Rent month $2,000.00 53 Previous research expense for Muffin advanceme $2,000.00 54 Supplies: Office month $25.00 55 Utilities month $500.00 CE Quantity sold 0 500 1000 1500 2000 2500 3000 3500 4000 4500 000 Revenue coffee donut Total Revenue 0 O 0 2000 1750 3750 4000 6000 3500 5250 750011250 8000 7000 15000 10000 8750 18750 12000 10500 22500 14000 12250 26250 16000 14000 30000 18000 15750 33750 20000 17500 37500 Fixed Expenses Total Fixed Expense 5,550.00 5,550.00 5,550.00 5,550.00 5,55000 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 5,550.00 Variable Expenses Coffee Variable expense 0.00 175.00 350.00 525.00 700.00 875.00 1,050.00 1,225.00 1,400.00 1,575.00 1,750.00 Donut Variable expense 0 300 600 900 1200 1500 1800 2100 2400 2700 3000 Total VariableExpenses 0.00 475.00 950.00 1,425.00 1,900.00 2,375.00 2,850.00 3,325.00 3,800.00 4,275.00 4,750.00 Total Expenses 5,550,00 6,025.00 6,500.00 6,975.00 7,450.00 7,925.00 8,400.00 8,875.00 9,350.00 9,825.00 Profit Donuts and Coffee W 1,000.00 4,275.00 7,550.00 1,000.00 4.275.00 7.550.00 - .. TTC 1000 1500 2000 2500 3000 3500 4000 4500 5000 Quantity sold 500 Revenue coffee S0 2000 Muffins 0 2750 Total Revenue 0 4750 4000 5500 9500 6000 8250 14250 8000 11000 19000 10000 13750 23750 12000 14000 16500 19250 2850033250 16000 22000 38000 18000 24750 42750 20000 27500 47500 Fixed Expenses Total Fixed Expense 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 9,350.00 Variable Expenses Coffee Variable expense Muffin Variable expense 0.00 0 175.00 600 350.00 1200 525.00 1800 700.00 2400 875.00 1,050.00 1,225.00 1,400.00 1,575.00 1,750.00 3000 3600 4200 4800 5400 6000 Total VariableExpenses 0.00 775.00 1,550.00 2,325.00 3,100.00 3,875.00 4,650.00 5,425.00 6,200.00 6,975.00 7,750.00 Total Expenses 9,350.00 #ana# # # ## ## # ### # # d ata Profit Muffin and Coffee # # # # # ## 2,575.00 6,550.00 # # # se na Profit Muffin and Coffee #****# 2,575.00 6,550.00 m m Muffins to Go: 1. What is the breakeven point for Donuts to Go (assume each customer buys one donut and one coffee)? 2. Using Goat seek, if you want to achieve profit of $2000, how many donuts and coffee do you need to sell? 3. What is the contribution margin of each sale of a Coffee and 4. What is the Profit at the break even? Solve by hand and by graph Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started