Explanation of Solution
a.
Creating worksheet for each sales region:
Step1: Open excel file.
Step2: Save the file into a particular location and name it as “workfile.xlsx”.
Step3: Rename “sheet1” as...
Explanation of Solution
b.
Importing word file:
Step1: Open the file “Ch07Ex01_U10e” and choose “Layout” option from the menu bar. Select “Convert to Text” option from it.
Screenshot of the “Ch07Ex01_U10e” file
Step2: A new pop up window will appear. In that, select “commas” option. Click “OK” button after selecting.
Screenshot of the “Ch07Ex01_U10e” file
Step3: Save the file as a text file with the name “Ch07Ex01_U10eR1”. Remove the contents other than “Region 1 2018 Sales Summary” data.
Step4: To import text file, open the file “workfile.xlsx”. Select “Data” from the menu bar. In that, select “From Text” option.
Screenshot of the excel file
Step5: Choose the text file and click “Import” button.
Screenshot of the excel file
Step6: A new dialog box appears. Click “Next” button.
Screenshot of the excel file
Explanation of Solution
c.
Computing discrepancies:
Step1: Add a column named “Average” in “Region 1” sheet. To compute average for every month for “Region 1”: Use the formula “((B7-B6)+(C7-C6)+(D7-D6)+(E7-E6)+(F7-F6)+(G7-G6)+(H7-H6))/7” to compute monthly average for “Jan-18”. Similarly calculate average for every month.
Screenshot of the excel file
Explanation of Solution
d.
Computing Adjusted forecast:
Step1:
In order to compute adjusted forecast, find the average of Forecast sales and Actual sales for every month, and total forecast sales for each month.
Compute Average Forecast sale by using the below formula:
Compute Average Actual sale by using the below formula:
Compute monthly forecast sales total by using the below formula:
Explanation of Solution
e.
Total sales projections:
Step 1: Take a fresh sheet and name it as “graph”. In that sheet, calculate total sales projections for every region. For region 1, the total projection sale is calculated by adding all the values from the column “Monthly Forecast Sale total”. Do this for the two other regions.
Screenshot of the excel file
Explanation of Solution
f.
Draw Bar graph:
Step 1: In the sheet “graph”, choose “Insert” option from the menu bar and select “Bar” option. A graph platform will appear. Place it in a position as shown below.
Screenshot of the excel file
Screenshot of the excel file
Step 2: Select data from Region 1 and paste it in the graph as shown below...
Want to see the full answer?
Check out a sample textbook solution
Chapter AE Solutions
EBK USING MIS
- Why does my pseudocode not perform what I asked? Don't know whats wrong with it.// This program asks the user to enter a value // between 1 and 10 and validates the input. Declare Integer value // Get a value from the user. Display "Enter a value between 1 and 10." Input value // Make sure the value is between 1 and 10. While value < 1 AND value > 10 Display "ERROR: The value must be between 1 and 10." Display "Enter a value between 1 and 10." Input value End Whilearrow_forwardWhat's wrong with my pseudocode? // The calcDiscountPrice function accepts an item’s price and // the discount percentage as arguments. It uses those // values to calculate and return the discounted price. Function Real calcDiscountPrice(Real price, Real percentage) // Calculate the discount. Declare Real discount = price * percentage // Subtract the discount from the price. Declare Real discountPrice = price – discount // Return the discount price. Return discount End Functionarrow_forwardNeed help converting my pseudocode to python, AND have a flowchart showing everything!The code: Function getScore() // Prompt the user to enter a test score Display "Enter a test score as a percentage (0-100): " Input score // Return the score entered by the user Return scoreEnd Function Function getGPAPoint(Integer score) // Determine GPA point based on the score If score >= 90 Then Return 4.0 Else If score >= 80 Then Return 3.0 Else If score >= 70 Then Return 2.0 Else If score >= 60 Then Return 1.0 Else Return 0.0 End IfEnd Function Function getAverage() // Initialize variables to store the sum of scores and GPA points totalScore = 0 totalGPA = 0.0 // Loop to collect 5 test scores For i = 1 to 5 Do score = getScore() // Call getScore function to get a test score totalScore = totalScore + score // Add score to totalScore gpaPoint = getGPAPoint(score) // Convert…arrow_forward
- Where did I make an error in my pseudocode module???Code:Module main() Call raiseToPower(2, 1.5) End main Module raiseToPower(Real value, Integer power) Declare Real result Set result = value ^ power Display result End raiseToPowerarrow_forwardI need help writing pseudocode for calculating class score average by putting in 5 test scores, and showing the average from all 5 inputs and the GPA score.Starting with 3 functions outside of a main module. The functions are getScore(), getGPAPoint(Integer score), and getAverage(). Function getscore is an input for a grade as a class percentage. Function getGPAPoint will calculate the score into a GPA point and return as a float (values of 90-100 as 4.0, 80-89 as 3.0, 70-79 as 2.0, 60-69 as 1.0, and anything below 60 as 0.) Function averageGPA will finally make a call to both previous functions when the user inputs numbers 5 times that then calculates the average (add up all the scores, divide by 5) and the average grade alongside displaying the average GPA. End result is a main module that makes a proper call to the averageGPA function and display its results. Need help with this!arrow_forwardPlease original work Why is integration between data collection and business analysis so important to success in an organization that uses business analytics? How can a company that is just starting to use business analytics set up its program for success right from the beginning? Please cite in text references and add weblinksarrow_forward
- How to make a 1 bit adder with CLA?arrow_forwardI need help writing pseudocode for this function. The following pseudocode statement calls a function named half, which returns a value that is half that of the argument. (Assume both the result and number variables are Real.) Set result = half(number)arrow_forwardNeed help converting my pseudocode to python, AND have a flowchart showing everything!The code:Main Module Call InputModuleEnd Main Module Module InputModule // This module gets input from the user Declare Principal, AnnualRate, Years as Float Output "Enter the Principal amount (P): " Input Principal Output "Enter the Annual Interest Rate (in percentage, e.g., 5 for 5%): " Input AnnualRate Output "Enter the number of Years to repay the loan: " Input Years Call DisplayPayment(Principal, AnnualRate, Years)End Module Module DisplayPayment(Principal, AnnualRate, Years) // This module calculates and displays the monthly payment Declare R, N as Float Declare MonthlyPayment as Float Declare PowerFactor as Float // second local variable // Calculate monthly interest rate R and number of months N Set R = (AnnualRate / 100) / 12 Set N = Years * 12 // Calculate PowerFactor = (1 + R)^N Set PowerFactor = (1 + R) ^ N // Calculate…arrow_forward
- Whats wrong with my pseudocode? Where did I make an error?Code: Module main() Declare Real mileage Call getMileage() Display “You’ve drive a total of “, mileage, “ miles End Module Module getMilage() Display “Enter your mileage: “ Input mileage End Modulearrow_forwardI need help!! Writing a long pseudocode for a modular program that will display the monthly payment on a mortgage. P=Principal amount borrowed (loan)R=Rate of interest computed for each monthN=Number of months to pay back the loan or mortgageThe help I need is creating a module that you can input the principle, rate of percentage, and years to repay the loan, and another module "displaypayment" that accepts the 3 values and calculates the monthly payment needed for the rates. Lastly 2 local variables needed!Equation:Monthly Payment=[(R*(1+R)^N)/((1+R)^N-1)]*Parrow_forwardTwo pseudocode questions I need help with: How do I design a module called findSum that will display the sum of two integer passed by parameter, and a module called findArea that will display the area of a rectangle when passed 2 real values for the length and width of the rectangle?arrow_forward
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Microsoft Visual C#Computer ScienceISBN:9781337102100Author:Joyce, Farrell.Publisher:Cengage Learning,
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningProgramming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage