Question: Question 1 Using the data provided below that shows the sales by state by month State Jan Feb Mar Apr May Jun Jul Aug Sep

Question 1\ Using the data provided below that shows the sales by state by month\ State\ Jan\ Feb\ Mar\ Apr\ May\ Jun\ Jul\ Aug\ Sep\ Oct\ Nov\ Dec\ West\ California\ 1118\ 1960\ 1252\ 1271\ 1557\ 1679\ 1218\ 1746\ 1758\ 1784\ 1957\ 1813\ Washington\ 1247\ 1238\ 1028\ 1345\ 1784\ 1574\ 1551\ 1638\ 1950\ 1196\ 1876\ 1649\ Oregon\ 1460\ 1954\ 1726\ 1461\ 1764\ 1144\ 1293\ 1047\ 1446\ 1869\ 1027\ 1343\ Nevada\ 1345\ 1375\ 1075\ 1736\ 1555\ 1372\ 1778\ 1777\ 1112\ 1940\ 1190\ 1494\ East\ New York\ 1429\ 1316\ 1993\ 1832\ 1740\ 1191\ 1106\ 1669\ 1140\ 1619\ 1576\ 1094\ New Jersey\ 1735\ 1406\ 1224\ 1706\ 1320\ 1290\ 1585\ 1222\ 1244\ 1749\ 1286\ 1491\ Massachusetts\ 1099\ 1233\ 1110\ 1637\ 1512\ 1006\ 1459\ 1784\ 1639\ 1554\ 1890\ 1932\ Florida\ 1705\ 1792\ 1225\ 1946\ 1327\ 1357\ 1872\ 1981\ 1209\ 1710\ 1385\ 1639\ Central\ Kentucky\ 1109\ 1078\ 1155\ 1993\ 1082\ 1551\ 1099\ 1845\ 1362\ 1530\ 1729\ 1267\ Oklahoma\ 1309\ 1045\ 1641\ 1924\ 1499\ 1941\ 1529\ 1551\ 1258\ 1133\ 1408\ 1908\ Missouri\ 1511\ 1744\ 1414\ 1243\ 1493\ 1820\ 1228\ 1771\ 1204\ 1724\ 1079\ 1476\ Illinois\ 1539\ 1493\ 1211\ 1165\ 1013\ 1445\ 1833\ 1237\ 1819\ 1058\ 1693\ 1579\ Kansas\ 1973\ 1560\ 1243\ 1495\ 1125\ 1387\ 1357\ 1642\ 1323\ 1153\ 1617\ 1529\ a. Sum the sales by region (i.e. West, East and Central) and by quarter (e.g. Jan, Feb, Mar is quarter 1) using the subtotal method\ b. Provide Grand Totals by month, region and quarter\ c. Provide an outline by both row and column

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

A company manufactures and sells face masks. The owner has developed a spreadsheet to calculate the costs associated with the aggregate plan. She wants to find the plan that minimizes the total...

New-car sales of a dealer during the past year are shown in the following table, along with monthly seasonal relatives. Month Units Sold Seasonal Relative Jan 730 1.15 Feb 651 1.15 Mar 684 1.04 Apr...

The director of medical records conducts a monthly audit of 50 medical records to identify coding errors. The chapter 08.xls, Problem 08-02 tab records the data. National statistics indicate that...

The NSW RFS Reconstruction Task Force has been contracting local workers to carry out supportive tasks for different reconstruction tasks over the past eight years. The EXCEL spreadsheet Contracted...

The recent years of 2019 and 2020 saw dismal performance for air cargo handled in Singapore. In 2019, air cargo handled by Changi Airport (tonnage) fell 7.0% to 1.1 million tonnes (Singapore...

What is the monthly sales and average price for a) Feb 12, b) Dec 19, c) April 17 ? AutoSave OFF Home Insert Draw Page Layout Formulas of Calibri (Body) V 11 V ' ' Paste B I U V V ma V A B19 fx...

month uclms ez year y81 y82 y83 y84 y85 y86 y87 y88 luclms jan feb mar apr may jun jul aug sep oct nov dec time JAN 18369 0 1980 0 0 0 0 0 0 0 0 9.82 1 0 0 0 0 0 0 0 0 0 0 0 1 FEB 17661 0 1980 0 0 0...

CMIS 102 Hands-On Lab Week 8 Overview This hands-on lab allows you to follow and experiment with the critical steps of developing a program including the program description, analysis, test plan, and...

: Introduction YEAR 1 Design Room Ill Forecasting Room Production Room Procurement Suppliers Boardroom Scorecard Year: 1 Profit: $2,000,000 Votes: Decision History Production Room Yearly Planning...

Mean Absolute Deviation (MAD) Calculate the Mean Absolute Deviation (MAD) using the following data. (Refer to Slides 52, 53, and 54 in Chapter 02 -or- Pages 54 and 55 in the textbook) Month Forecast...

a. 1. Are inventories classified as a current asset? Comment. 2. Does it appear that inventories are a highly liquid asset? b. 1. Goodwill impairment'what does this imply? 2. Comment on the review of...

Describe the steps in your own words of plotting in Excel? (CLO 1, C2, PLO 1)

Marital Deduction: How can the unlimited marital deduction be used to defer estate taxes until the death of the surviving spouse? Charitable Deduction: How can the Thompsons structure their...

Special-Order Decision Smooth Move Company manufactures professional paperweights and has been approached by a new customer with an offer to purchase 15,000 units at a per-unit price of $10.00. The...

5. As the new HR Director of a company in the behavioral health industry, you have the responsibility to develop a performance management system. You need to present a business case to senior...

2. Suppose you are a supervisor. What errors might you make when preparing the performance appraisal on a clerical employee? How might you avoid those errors?

3. Ratings, rankings, and other approaches used to assess employees job performance are always subject to discussion and debate. Managers need to understand the current applications associated with...