**PLEASE FOLLOW THE INSTRUCTIONS CAREFULLY**
instructions_for_assignment_3.docx
lastnamefirstname_a3.xlsx
Unformatted Attachment Preview
1
Assignment 3 M.S. Excel 2013 or 2016
Julia’s Juice Bar
Learning Objectives
1. Goal Seek
2. What-if sensitivity analysis
3. Charting
Use my instructional video Lesson 4ABC to complete the following:
A worksheet Lastnamefirstname_A4.xls has been started for you and you need to
complete it based on the following assumptions for a company called Julia’s Juice
Bar.
1. Julia’s juice bar is trying to trim down their annual maintenance expenses
to 10% of the total expenses. Use Goal Seek to calculate the new amount.
2. Julia would like to have a pie chart that would show the summary of annual
percentage of expenses. Create a 3D pie chart with the given data.
3. Julia is considering expanding her business and is planning on taking a loan
for $425,000.00 and is willing to pay no more than $9000 per month as
monthly payment.
4. Further, she wishes to repay the loan in 4 years and is therefore willing to
lower her budget if need be. You are to help her come up with the right
amount to borrow. What is your recommendation. Indicate this in the
space provided in the spreadsheet.
Create a pdf of the entire workbook and upload it in the link provided by the
due date posted.
Take the following options to create the pdf version of your file.
Go to backstage view, export, create pdf, options, in publish what section in the
dialog box, select entire work book, then select ok and publish.
Good Luck!
Julia’s Juice Bar
Projected Decrease in Expenses
Annual Total
Employee Salaries
Equipment
Produce
Marketing
Maintenance
Totals
$
$
$
$
$
2.678.512
2.904.123
1.345.689
3.456.123
3.412.902
Goal: Decrease Maintenance to 10%
Goal Amount
Percent of
Total
Costa Mesa Store Loan Options
Amount of Loan
Period (years)
Interest rate (per year)
Payment (per month)
$425.000
4,00
4%
Option #1 Reduce Loan Amount
Amount of Loan
Period (years)
Interest rate (per year)
Payment (per month)
Option #2 Increase Number of Years
Amount of Loan
Period (years)
Interest rate (per year)
Payment (per month)
enter Your recommendation here.
…
Our essay writing service fulfills every request with the highest level of urgency.
attachment
