**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