Unit 5 DB: Understanding What-If Analysis (CIS250 Advanced Excel) Make sure to review Chapter 6 before posting your discussion. The two worksheets, DeliScenario.xlsx o
Unit 5 DB: Understanding What-If Analysis (CIS250 Advanced Excel)
Make sure to review Chapter 6 before posting your discussion. The two worksheets, DeliScenario.xlsx or OutageCosts.xlsx, are using one of the What-If Analysis tools: Deli worksheet is using the Scenario Manager. The Outage worksheet is using a One Variable Data Table.
OutageCosts.xlsx DeliScenario.xlsx
- Choose one of the worksheets and open it up.
- Explain:
· Which What If Analysis tool is the worksheet using?
· Provide a description of the What If Analysis tool and why it was used in the worksheet.
· Interpret what the data means.
· Discuss what it means for the business.
Unit 5 DB: Convince us of your conflict (ENG130 Literature & Composition)
Initial Response: Jackson, Dick, and Atwood brilliantly incorporate the conflict of Man vs. Society, but which one does it better?
- In one to two paragraphs, argue which of the Unit 5 authors best portrays the conflict of Person vs. Society and HOW (you might like to do some more research on The Handmaid's Tale to write about Atwood). This is a great practice for your upcoming Position Paper.
- Share a modern-day piece of literature (new story, article, video, movie, novel, etc.) that supports your response and is a direct connection to the story you choose. Be sure to post the link to your modern piece of literature and explain how it connects to your chosen author/story.
- Finish your post by asking a question of your peers that promotes critical thinking on this subject.
Unit 5 Discussion: Impact of Risk-free Rates and Market Premiums (FIN201 Principles of Finance)
Please consider all that we have learned thus far regarding the impact of diversification, risk-free securities, and market premiums. With that in mind, please describe how adding a risk-free security to modern portfolio theory allows investors to do better than the efficient frontier. Additionally, explain how might the magnitude of the market risk premium impact people's desire to buy stocks?
Unit 5 DB: Vendor Transactions (ACC215 Spreadsheet & General Ledger Software)
What are the types of vendor transactions and discuss how QB can help manage this area?
Outage Analysis
| One-Variable Data Table: Cost | ||||
| Input Area | Outage Impact Analysis | |||
| Cost Per Hour | $1,500.00 | Duration (hr) | 4500.0 | |
| Outage Duration (hours) | 3 | 1 | $1,500.00 | |
| 1.5 | $2,250.00 | |||
| Output Area | 2 | $3,000.00 | ||
| Total Cost for Outage | $ 4,500.00 | 2.5 | $3,750.00 | |
| 3 | $4,500.00 | |||
| 3.5 | $5,250.00 | |||
| 4 | $6,000.00 | |||
| 4.5 | $6,750.00 | |||
| 5 | $7,500.00 | |||
Student Name &A &F
,
Scenario Summary
| Scenario Summary | |||||
| Current Conditions | Ideal Case | Increased Costs | Low Sales | ||
| Created by Exploring Series on 5/23/2021 | Created by Exploring Series on 5/23/2021 | Created by Exploring Series on 5/23/2021 | Created by Exploring Series on 5/23/2021 | ||
| Changing Cells: | |||||
| Units Sold | $C$4 | 1278 | 1500 | 700 | 500 |
| Sales Price | $C$6 | $ 4.25 | $ 4.25 | $ 4.50 | $ 4.00 |
| Result Cells: | |||||
| Net Profit | $F$13 | $ 3,500.00 | $ 4,246.25 | $ 1,735.25 | $ 763.75 |
Budget
| Burton's Sandwich Shop | |||||||||||
| Forecasts | Fixed Costs | Variable Costs | Income | ||||||||
| Sandwichs sold (units sold) | 1278 | Lease | $ 525.00 | Costs of goods sold | $ 958.30 | Income from cash | $ 271.52 | ||||
| Unit price | $ 0.75 | Utilities | $ 250.00 | Credit Card Processing Fees | $ 182.08 | Income from credit | $ 5,158.86 | ||||
| Sales price | $ 4.25 | Credit Card Equipment Fee | $ 15.00 | Total | $ 1,140.38 | Total income | $ 5,430.38 | ||||
| Percentage of credit card sales per month | 95% | Total | $ 790.00 | ||||||||
| Percentage of cash sales per month | 5% | ||||||||||
| Credit Card Swipes per Month | 1,214 | Totals | |||||||||
| Credit Card Cost per Swipe | $ 0.15 | Total Fixed Costs | $ 790.00 | ||||||||
| Total Variable Costs | $ 1,140.38 | ||||||||||
| Total Income | $ 5,430.38 | ||||||||||
| Net Profit | $ 3,500.00 | ||||||||||
Student Name &A &F
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
