Chat with us, powered by LiveChat ISDS351 Julia Juice Bar Interest Rate and Amount of Loan Paper | All Paper
+1(978)310-4246 credencewriters@gmail.com
Select Page

Assignment 3M.S. Excel 2013 or 2016 Julia’s Juice Bar Learning Objectives Goal SeekWhat-if sensitivity analysisCharting 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. 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.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.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. 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!
instructions_for_assignment_3.docx

lastnamefirstname_a3.xlsx

Unformatted Attachment Preview

1
Prof. M. Krishnamurthi
ISDS 351.
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
Create a pdf of the entire workbook and upload it in the link provided by the
due date posted.
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)