Answered step by step
Verified Expert Solution
Question
1 Approved Answer
People in every industry perform some type of what - if analysis to make educated decision. Microsoft Excel provides powerful what - if analysis tools.
People in every industry perform some type of whatif analysis to make educated decision. Microsoft Excel provides powerful whatif analysis tools. Whatif analysis enables you to experiment with different variables or assumptions so that you can observe and compare how these changes affect a related outcome. A variable is an input value that can change to other values to affect the results of a situation. In business operation, you may want to determine exactly how much you change a variable to reach your goal Goal Seek Sometimes you may want to compare several variables and their combined effects on multiple calculated results. This type of analysis involves identifying and setting up scenarios, which are detailed sets of values that represent different possible situations. Business managers often create a bestcase scenario, worstcase scenario, and most likely scenario to compare outcomes. This exercise refreshes your skill of performing goalseek and scenario analysis using Excel. You have a bakery specializing in cupcakes. Your budget must account for fixed expenses, such as your facility lease, utilities, and credit card equipment fees. In addition, you account for variable costs including cost of goods, and credit card processing fees. You will use Goal Seek in Excel to determine how many cupcakes you must sell to earn a net profit of $ You then use Scenario Manager to evaluate several possible situations in your business. Find the anount of cubcakes
tableMy Bakery Budget,ForecastsCupcakes sold units soldUnit price,Sales price,Percentage of credit card sales per month,
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