EBK USING MIS
EBK USING MIS
10th Edition
ISBN: 8220103633635
Author: KROENKE
Publisher: YUZU
Expert Solution & Answer
Book Icon
Chapter AE, Problem AE7.1

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:

Avg. of Forecast Sale (Avg of FS) =(ForecastSale(product1+...+product7))/7(Avg of FS) =AVERAGE(B5:H5)(Avg of FS) =10+20+5+12+20+5+34=>15.14

Compute Average Actual sale by using the below formula:

Avg. of Actual Sale (Avg of AS) =(ActualSale(product1+...+product7)/7)(Avg of AS)=AVERAGE(B6:H6)(Avg of AS)=12+21+5+12+21+5+36=>16.00

Compute monthly forecast sales total by using the below formula:

Monthly Forecast sale total=ForecastSale(product1+

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

Blurred answer
Students have asked these similar questions
D. S. Malik, Data Structures Using C++, 2nd Edition, 2010
Methods (Ch6) - Review 1. (The MyRoot method) Below is a manual implementation of the Math.sqrt() method in Java. There are two methods, method #1 which calculates the square root for positive integers, and method #2, which calculates the square root of positive doubles (also works for integers). public class SquareRoot { public static void main(String[] args) { } // implement a loop of your choice here // Method that calculates the square root of integer variables public static double myRoot(int number) { double root; root=number/2; double root old; do { root old root; root (root_old+number/root_old)/2; } while (Math.abs(root_old-root)>1.8E-6); return root; } // Method that calculates the square root of double variables public static double myRoot(double number) { double root; root number/2; double root_old; do { root old root; root (root_old+number/root_old)/2; while (Math.abs (root_old-root)>1.0E-6); return root; } } Program-it-Yourself: In the main method, create a program that…
I would like to know the main features about the following 3 key concepts:1. Backup Domain Controller (BDC)2. Access Control List (ACL)3. Dynamic Memory
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Microsoft Visual C#
Computer Science
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Cengage Learning,
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage