screenshot20240516at12
.pdf
keyboard_arrow_up
School
NED University of Engineering & Technology, Karachi *
*We aren’t endorsed by this school
Course
AUDITING
Subject
Finance
Date
May 18, 2024
Type
Pages
2
Uploaded by DukeBaboonMaster1046 on coursehero.com
Prompt Create a series of charts in an Excel spreadsheet and a memo that compares the financial benefits of options A and B. The charts in your spreadsheet should include a comparison of financial forecasts from both innovation options (discontinuous and incremental). You should create the charts using the data in this Sales Forecast. Make sure to add titles to all your charts so you can clearly reference them in your memo. Consider the following points: 1. Create a chart for sales forecast data. a. Graph sales forecast data for total sales for options A and B on a three-dimensional stacked column chart. e Each column should show traditional sales on the bottom and connected sales on the top. e Both options may appear on the same three-dimensional chart, or you can make a separate chart for each option. 2. Create a chart for gross margin forecast data. a. Graph gross margin forecast data for total sales for options A and B on a three-dimensional stacked column chart. e Each column should show traditional sales on the bottom and connected sales on the top. e Both options may appear on the same three-dimensional chart, or you can make a separate chart for each option. 3. Create a chart for gross margin less R&D and capital costs calculations. a. Calculate gross margin less R&D and capital costs for options A and B. b. Graph total gross margin less R&D and capital costs forecasts to compare options A and B on a line chart. e Both options should appear on the same chart. 4. Explain any conclusions you can draw from your data visualizations. a. Review the charts and discuss any conclusions you can make from those data visualizations. b. Explain whether option A or option B will provide your company the most financial benefit. You should reference your data visualizations to justify your explanation and conclusions.
What to Submit e Submit an Excel document with all your charts. e Submit a %- to 1-page Word document with 12-point Times New Roman font, double spacing, and one-inch margins. If you include references, they should be cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this
question. I will grade this question on the accuracy of your () spreadsheet model (decision variables, objective, and constraints), (i) Solver
parameters, (i optimal solution. Partial credit is available.
The personnel-planning problem of Lexington Bank. The main branch of Lexington Bank is open for retail business from 8:00 AM to
4:00 PM on weekdays. The staffing requires from 8 to 15 tellers on duty depending on the time of day, as indicated in the following table.
Time Period
Minimum No. of Tellers
8:00 AM - 10:00 AM
10:00 AM - 12:00 PM
12:00 PM - 2:00 PM
10
15
2:00 PM - 4:00 PM
12
Full-time tellers work 8 consecutive hours (from 8:00 AM to 4:00 PM) at $15 per hour. Part-time workers work 4 consecutive hours at $8
per hour starting at 8:00 AM, 10:00 AM, or 12:00 noon. Assume workers never take breaks. Union regulations require that all…
arrow_forward
Write a paragraph on each of the following topics: liquidity, asset management, debt management and profitability. Be sure to label these separately. Analyze each topic using the answers from your ratios to support your analysis by deciphering what they are telling you. Create a text box (Insert Menu, click on the “Text” button on the right side of the menu bar, and choose, “Text box”. Then click and drag a box to write in.
arrow_forward
What are the steps to create a new estimate in QuickBooks Online?
Projects > All Sales > New Transaction > Estimate
Sales > Customers > New Customer
Sales > All Sales > New Transaction > Estimate
Gear icon > Estimate
arrow_forward
I need help with question 6 on how to create the customer pivot table as given. Also, can you provide the steps of how to do that in Excel? Also, please provide the steps in order to solve the problem for Finance.
arrow_forward
using the chart, how much should the call option worth. please show how to solve this in excel and the formulas
arrow_forward
Find the following values, using the equations, and then work the problems using a financial calculator to check your answers. Disregard rounding differences. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent.
An initial $400 compounded for 1 year at 9.5%.
$
An initial $400 compounded for 2 years at 9.5%.
$
The present value of $400 due in 1 year at a discount rate of 9.5%.
$
The present value of $400 due in 2 years at a discount rate of 9.5%.
$
arrow_forward
Questions
1. How reliable is your Sales Forecast? Explain your answer.
2. What are some ways you could potentially improve the accuracy of your forecast?
arrow_forward
which of the following tabs in PORT allow you to view your portfolio's overall current performance using real time data?
arrow_forward
I need help to do question 9 from A to D and please include the formulas on how to solve using Excel and the answer for the Finance homework.
arrow_forward
Use both the TVM equations and a financial calculator to find the following values. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent.
An initial $400 compounded for 10 years at 5%.
An initial $400 compounded for 10 years at 10%.
The present value of $400 due in 10 years at a 5% discount rate.
The present value of $400 due in 10 years at a 10% discount rate.
arrow_forward
please fix my excel worksheet and answer this questions as well please as soon as possible:
In addition possibly answer this too if possible:
c-2. If your recommendation in part (c-1) is followed, what would be the company’s overall profit?
arrow_forward
Consider the following two investment proposals and their returns under different economic scenarios.
Answer step by step. Do all calculation. Answer must be correct. Use word file for answer. Answer follow image
arrow_forward
Kindly research about Efficient Market Hypothesis and provide a brief summary about it.
long question Atleast 2 pages
arrow_forward
What are the primary benefits of using Excel portfolio optimization analysis? How would you optimize your portfolio using Excel?
arrow_forward
Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Actual demand and the two
sets of forecasts are as follows:
TTT
PREDICTED DEMAND
Period
Demand
F1
F2
1
68
63
66
75
70
67
3
70
75
70
4
74
69
69
70
73
6.
72
68
7
80
70
77
8.
78
74
84
Click here for the Excel Data File
a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2
decimal places.)
MAD F1
MAD F2
rON m574
O N N NNN
arrow_forward
What are the Microsoft Excel formulaues used to input these? Is there a way to show each formula for how you came up with these. Not just the ratios but what you would input into excel that would automatically calculate the correct answers?
arrow_forward
Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update within excel.
Please choose one of the data sets below and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided.
Data set #1
Data Section:
Actual and Budgeted Unit Sales:
April 1,500
May 1,000
June 1,600
July 1,400
August 1,500
September 1,200
Balance Sheet, May 31, 19X5
Cash $8,000
Accounts Receivable 107,800
Merchandise Inventory 52,800
Fixed Assets (net) 130,000
Total assets $298,600
Accounts Payable (merchandise) $74,800
Owner's equity 223,800
Total liabilities & equity $298,600
Average selling price $98
Average purchase cost per unit $55
Desired ending inventory (% of next…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
Related Questions
- Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this question. I will grade this question on the accuracy of your () spreadsheet model (decision variables, objective, and constraints), (i) Solver parameters, (i optimal solution. Partial credit is available. The personnel-planning problem of Lexington Bank. The main branch of Lexington Bank is open for retail business from 8:00 AM to 4:00 PM on weekdays. The staffing requires from 8 to 15 tellers on duty depending on the time of day, as indicated in the following table. Time Period Minimum No. of Tellers 8:00 AM - 10:00 AM 10:00 AM - 12:00 PM 12:00 PM - 2:00 PM 10 15 2:00 PM - 4:00 PM 12 Full-time tellers work 8 consecutive hours (from 8:00 AM to 4:00 PM) at $15 per hour. Part-time workers work 4 consecutive hours at $8 per hour starting at 8:00 AM, 10:00 AM, or 12:00 noon. Assume workers never take breaks. Union regulations require that all…arrow_forwardWrite a paragraph on each of the following topics: liquidity, asset management, debt management and profitability. Be sure to label these separately. Analyze each topic using the answers from your ratios to support your analysis by deciphering what they are telling you. Create a text box (Insert Menu, click on the “Text” button on the right side of the menu bar, and choose, “Text box”. Then click and drag a box to write in.arrow_forwardWhat are the steps to create a new estimate in QuickBooks Online? Projects > All Sales > New Transaction > Estimate Sales > Customers > New Customer Sales > All Sales > New Transaction > Estimate Gear icon > Estimatearrow_forward
- I need help with question 6 on how to create the customer pivot table as given. Also, can you provide the steps of how to do that in Excel? Also, please provide the steps in order to solve the problem for Finance.arrow_forwardusing the chart, how much should the call option worth. please show how to solve this in excel and the formulasarrow_forwardFind the following values, using the equations, and then work the problems using a financial calculator to check your answers. Disregard rounding differences. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. An initial $400 compounded for 1 year at 9.5%. $ An initial $400 compounded for 2 years at 9.5%. $ The present value of $400 due in 1 year at a discount rate of 9.5%. $ The present value of $400 due in 2 years at a discount rate of 9.5%. $arrow_forward
- Questions 1. How reliable is your Sales Forecast? Explain your answer. 2. What are some ways you could potentially improve the accuracy of your forecast?arrow_forwardwhich of the following tabs in PORT allow you to view your portfolio's overall current performance using real time data?arrow_forwardI need help to do question 9 from A to D and please include the formulas on how to solve using Excel and the answer for the Finance homework.arrow_forward
- Use both the TVM equations and a financial calculator to find the following values. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. An initial $400 compounded for 10 years at 5%. An initial $400 compounded for 10 years at 10%. The present value of $400 due in 10 years at a 5% discount rate. The present value of $400 due in 10 years at a 10% discount rate.arrow_forwardplease fix my excel worksheet and answer this questions as well please as soon as possible: In addition possibly answer this too if possible: c-2. If your recommendation in part (c-1) is followed, what would be the company’s overall profit?arrow_forwardConsider the following two investment proposals and their returns under different economic scenarios. Answer step by step. Do all calculation. Answer must be correct. Use word file for answer. Answer follow imagearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,