Question
In: Finance
We will use the following information to create the profit model. Based on the data in...
We will use the following information to create the profit
model. Based on the data in the tables below, create the profit
model for Donuts to Go and Muffins to Go.
Profit = Total revenue X num. of units – Variable Expenses X
num. of units – Fixed Expenses
(what are the values for Total Revenue, Variable Expenses and
Fixed Expenses?)
Assume that each customer will buy one donut(or muffin) and
one cup of coffee.
Come to class with both Profit Models written on a sheet of
paper to hand in at the beginning of class. It will be part of your
In-class activity grade for the day.
Donuts to Go
Time period
Revenue: Cup of Coffee
$4.00
Revenue: Donut
$3.50
Donut ingredients per donunt)
per donut
$0.60
paper products: napkins, plates etc
Insurance
month
$200.00
Maintenance & Repairs to equipment
month
$0.00
Marketing & Promotion: Advertising
month
$50.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
$1,000.00
Donut and Coffee equipment rent
month
$500.00
Professional Fees: Accounting
month
$50.00
Professional Fees: Legal
month
$25.00
Powdered and Liquid Beverages
$0.00
Rent
month
$1,000.00
Previous research expense for Donuts advancements
$1,500.00
Supplies: Office
month
$25.00
Utilities
month
$200.00
Muffins to Go
Time period
Revenue: Cup of Coffee
$4.00
Revenue: Muffin
$5.50
Muffin ingredients (per muffin)
per donut
$1.20
paper products: napkins, plates etc
Insurance
month
$500.00
Maintenance & Repairs to equipment
month
$0.00
Marketing & Promotion: Advertising
month
$250.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
$1,000.00
Muffin and Coffee equipment rent
month
$2,500.00
Professional Fees: Accounting
month
$50.00
Professional Fees: Legal
month
$25.00
Powdered and Liquid Beverages
$0.00
Rent
month
$2,000.00
Previous research expense for Muffin advancements
$2,000.00
Supplies: Office
month
$25.00
Utilities
month
$500.00
Solutions
Expert Solution
Let's Assume for the above we have 1500 customer Per Month for both the products.
I have compute Profit Model for Donuts and Muffins both by taking 1500 Customers reached to us.
| Donuts | |||
| Unit price | Unit | Total | |
| Cup of Coffee | 4.00 | 1,500 | 6,000 |
| Donuts | 3.50 | 1,500 | 5,250 |
| Revenue | 11,250 | ||
| Donuts ingredient | 0.60 | 1,500 | 900 |
| Coffee | 0.25 | 1,500 | 375 |
| Coffee cups | 0.10 | 1,500 | 150 |
| Variable Cost | 1,425 | ||
| Gross Profit | 9,825 | ||
| Insurance | 200 | ||
| Maintenance & Repairs to equipment | - | ||
| Marketing & Promotion: Advertising | 50 | ||
| Payroll: Wages (Owner/ Manager) | 2,500 | ||
| Payroll: Wages (per Employees) | 1,000 | ||
| Donut and Coffee equipment rent | 500 | ||
| Professional Fees: Accounting | 50 | ||
| Professional Fees: Legal | 25 | ||
| Powdered and Liquid Beverages | - | ||
| Rent | 1,000 | ||
| Previous research expense for Donuts advancements | 1,500 | ||
| Supplies: Office | 25 | ||
| Utilities | 200 | ||
| Fixed Cost | 7,050 | ||
| Profit Before Tax | 2,775 | ||
| Muffins | |||
| Unit price | Unit | Total | |
| Cup of Coffee | 4.00 | 1,500 | 6,000 |
| Muffins | 5.50 | 1,500 | 8,250 |
| Revenue | 14,250 | ||
| Muffin ingredient | 1.20 | 1,500 | 1,800 |
| Coffee | 0.25 | 1,500 | 375 |
| Coffee cups | 0.10 | 1,500 | 150 |
| Variable Cost | 2,325 | ||
| Gross Profit | 11,925 | ||
| Insurance | 500 | ||
| Maintenance & Repairs to equipment | - | ||
| Marketing & Promotion: Advertising | 250 | ||
| Payroll: Wages (Owner/ Manager) | 2,500 | ||
| Payroll: Wages (per Employees) | 1,000 | ||
| Donut and Coffee equipment rent | 2,500 | ||
| Professional Fees: Accounting | 50 | ||
| Professional Fees: Legal | 25 | ||
| Powdered and Liquid Beverages | - | ||
| Rent | 2,000 | ||
| Previous research expense for Donuts advancements | 2,000 | ||
| Supplies: Office | 25 | ||
| Utilities | 500 | ||
| Fixed Cost | 11,350 | ||
| Profit Before Tax | 575 | ||
After Comparing both Profit Models we can say its better to go for Donuts Business instead of Muffins.
jeff jeffy answered 1 year agoRelated Solutions
Use the following information for questions 28-31: Suppose we run a model to determine the test...
Use the following information for questions 28-31:
Suppose we run a model to determine the test score of a student
based in their IQ and time spent studying. The model can be written
as:
Score = B0 + B1 IQ + B2
Sleep Hours + B3 Study Hours + e
Where:
Score = student's score on the test (out of 100)
IQ = student's IQ score (representing intelligence in this
model)
SleepHours = number of hours slept the night before...
Create a business model based on the information below: Lyly coffee and bakery shop expects to...
Create a business model based on the information below:
Lyly coffee and bakery shop expects to raise $100,000 of
capital, $50,000 stake, $50,000 as a 5 years loan.
Based on the following information for project X, should we undertake the venture? (Use NPV technique)....
Based on the following information for project X, should we
undertake the venture? (Use NPV technique). Project X involves a
new type of design. We think we can sell 6,000 units per year at a
price of 1 € each. Variable costs will run about 0.4 € per unit,
and the product should have a four-year life. Fixed costs for the
project will run 450 € per year. Further, we will need to invest a
total of 4000 € in...
Use the following information to create SQL commands to retrieve data from Henry Books database :...
Use the following information to create SQL commands to retrieve
data from Henry Books database :
For each book, list the book code, book title, publisher code,
and publisher name. Order the results by publisher name.
For each book published by Plume, list the book code, book title,
and price.
List the book title, book code, and price of each book published by
Plume that has a book price of at least $14.
List the book code, book title, and...
Develop a simulation model for a 3-year financial analysis of total profit based on the following...
Develop a simulation model for a 3-year financial analysis of
total profit based on the following data and information.
Sales volume in the first year is estimated to be 100,000 units
and is projected to grow at a rate that is normally distributed
with a mean of 7% per year and a standard deviation of 4%. The
selling price is $10, and the price increase is normally
distributed with a mean of $0.50 and standard deviation of $0.05
each year....
Develop a simulation model for a three-year financial analysis of total profit based on the following...
Develop a simulation model for a three-year financial analysis
of total profit based on the following data and information. Sales
volume in the first year is estimated to be 100,000 units and is
projected to grow at a rate that is normally distributed with a
mean of 7% per year and a standard deviation of 4%. The selling
price is $10, and the price increase is normally distributed with a
mean of $0.50 and standard deviation of $0.05 each year....
MATLAB based problem: Create a motoring model for the engine with the following specifications, and plot...
MATLAB based problem: Create a motoring model for the engine
with the following specifications, and plot the in-cylinder
pressure against (i) cylinder volume and (ii) crank angle degrees
(20 points)  Bore = 107mm, stroke = 124mm, compression ratio =
17.3, Length of connecting rod = 192mm. Assume the ratio of
specific heats is 1.4 (constant), atmospheric pressure is 1 bar and
ambient temperature is 298 K.
For the data below graph and determine the fit you should use based on the information...
For the data below graph and determine the fit you should use
based on the information available. Also try to think about any
natural system that might use this type of fit (use
SciDavis). Let the horizontal axis represent time
in seconds. Choose a physical quantity for y data.
Paste graph below and list the values of fitting parameters,
along with their uncertainties. Watch significant figures and don’t
forget the units for each parameter.
X
Y
1
1.82
2
2.36...
Generate a simulated data set with 100 observations based on the following model. Each data point...
Generate a simulated data set with 100 observations based on the
following model. Each data point is a vector Z= (X, Y) where X
describes the age of a machine New, FiveYearsOld, and TenYearsOld
and Y describes whether the quality of output from the machine
Normal or Abnormal. The probabilities of a machine being in the
three states are
P(X = New) = 1/4
P(X = FiveYearsOld) = 1/3
P(X = TenYearsOld) = 5/12
The probabilities of Normal output conditioned...
Compare and contrast for-profit and not-for-profit corporate structures based on the information available from a balance...
Compare and contrast for-profit and not-for-profit corporate
structures based on the information available from a balance sheet
and an income statement? Fundamentally, what are the
differences?
This is a list of the questions that needed to be answered but
needed help with the one above
Why are balance sheets important to healthcare organization
finance and what area of the balance sheet would you consider the
most critical?
Comparing organizational costs, which costs does nursing
administration have little control over and...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
ADVERTISEMENT