Cupcake shop in a high-traffic tourist area

Assignment Help Operation Management

Reference no: EM131468014

You are looking to open up a cupcake shop in a high-traffic tourist area. In order to get your business open you will need investors to provide you with $250,000 dollars. You are going to be making a pitch to a local bank for a portion of the money. The business environment you are looking to operate in is one in which there is a heavy amount of seasonal business. However there is not enough non-seasonal business to support long-term growth. Based on this information before you submit your business plan to the bank for consideration you will need to perform a simulation analysis to determine the optimal model for your business. You have made the follow assumptions: Your equipment will allow you to only produce 50 batches of cupcakes per day. You have determined that the daily demand will follow the distribution shown in the following table:

Daily Demand Probability

20 0.08

25 0.12

35 0.25

20 0.20

45 0.20

50 0.15

You will need $45,000 per month in order for your business to remain solvent. You are going to develop a business plan for the bank based on your top selling item – the bacon chocolate cupcake.

There are 12 cupcakes in every batch for a total of 600 cupcakes made per day. Each batch of bacon chocolate cupcakes costs $45 dollars to make and the entire batch can be sold for $100. You are able to sell any unsold batches for $25 the next day. As part of your analysis you will use Monte-Carlo simulation and Scenario Manager in MS-Excel to perform a simulation on your data. Refer to the examples in Ch. 10 pp. 454-462 for additional reference.

1. Based on your calculations will the business hit the revenue goal of $45,000 per month and be sustainable.

2. Which batch quantity would recommend and why?

Reference no: EM131468014

Questions Cloud

Large consulting company : McKinley, a large consulting company in UK, has a consulting staff consisting of 400 consultants at the rank of "associate".

What dilemma does the controller face : You are the Controller of a medium-sized oil exploration company in Texas. What dilemma does the controller face? What should the company do going forward?

How many customers on average are in the drive-through : A drive-through at a Fast Food serves 300 customers over 10-hour day. How many customers on average are "in" drive-through on a typical day?

Organization with problem with product or service : Posing as a representative of an organization with a problem with a product or service, invent reasonable details,

Cupcake shop in a high-traffic tourist area : You are looking to open up cupcake shop in high-traffic tourist area.

Describe factors affecting the work environment : Describe factors affecting the work environment of that business that must be considered in improving their existing work systems design.

Harm reduction is central part of strength : Harm Reduction is a central part of strength-based helping strategies. There is much debate regarding harm reduction programs in this US.

Strategies for developing a diversity sensitive organization : what would be some strategies for developing a diversity sensitive organization (DSO)?

Model and process for improving performance is taking shape : The model and process for improving performance is taking shape. Knowledge and change management are major challenges to most organizations.

User Account

All Pages