Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed
People in every industry perform some type of what-if analysis to make educated decision. Microsoft Excel provides powerful what-if analysis tools. What-if 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 best-case scenario, worst-case scenario, and most likely scenario to compare outcomes. This exercise refreshes your skill of performing goal-seek 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 $3,500. You then use Scenario Manager to evaluate several possible situations in your business. Find the anount of cubcakes
\table[[My Bakery Budget,],[Forecasts,],[Cupcakes sold (units sold),],[Unit price,0.75],[Sales price,4.25],[Percentage of credit card sales per month,95%
image text in transcribed

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

Advanced Financial Accounting

Authors: Theodore E. Christensen, David M. Cottrell, Cassy JH Budd

11th edition

78025877, 978-0078025877

More Books

Students also viewed these Accounting questions