Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

using excel to show your work and can you explain your answer. Abigail is working on a plan of opening a muffin shop at a

using excel to show your work and can you explain your answer.

Abigail is working on a plan of opening a muffin shop at a shop in Romeoville downtown. She is planning to keep it open for all of a month. Her goal is to find out how many muffins should she sell per day. She is planning to sell a muffin for $1.75.

Her costs for the new business are:

Raw Materials $250 per day

Kitchen gas maintenance $25 per day

Fixed costs includes:

Local taxes $500 per month

Liability insurance $750 per month

Rental cost of the shop $1250 per month

Using breakeven formula, help Abigail arrive at the number of muffins she need to sell to break-even. Also, help Abigail by identifying the number of muffins she needs to sell to make a min. profit of $1500 per month. Mary also has an option of renting a different shop for $850 per month. How many muffins should she sell if she opts for this another shop that costs $850 per month?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions