TABLE 21-1 Magnum Enterprises Six-Month Sales Report
Magnum Enterprise Six-Month Sale Report | ||||||||||||
January | February | March | April | May | June | |||||||
Standard | Deluse | Standard | Deluse | Standard | Deluse | Standard | Deluse | Standard | Deluse | Standard | Deluse | |
Northwest | $123.200 | $86,400 | $115.800 | $73.700 | $133.400 | $91.100 | $136.700 | $92,600 | $112.900 | $65.300 | $135.000 | $78,400 |
Northeast | $214,700 | $121.300 | $228,400 | $133,100 | $246,600 | $164,800 | $239,000 | $153,200 | $266,100 | $185,000 | $279,300 | $190,100 |
Southwest | $88,300 | $51,000 | $72,100 | $45,700 | $97,700 | $58,300 | $104,000 | $67,800 | $125,000 | $78,300 | $130,400 | $74,500 |
Southeast | $143,200 | $88,700 | $149,900 | $91,300 | $158,400 | $94,500 | $127,700 | $70,300 | $145,700 | $79,400 | $162,000 | $88,600 |
As the sales manager for Magnum Enterprises, you have been asked by the president to prepare the following charts for the shareholders' meeting next week. Use the six-month sales report. Table 21-1 on page 713, as the database for these charts. Calculate totals as required.
Single-line chart of the total company sales per month
Want to see the full answer?
Check out a sample textbook solutionChapter 21 Solutions
Contemporary Mathematics for Business and Consumers
Additional Math Textbook Solutions
A Survey of Mathematics with Applications (10th Edition) - Standalone book
Fundamentals of Differential Equations and Boundary Value Problems
Pathways to Math Literacy (Loose Leaf)
Calculus for Business, Economics, Life Sciences, and Social Sciences (14th Edition)
Excursions in Modern Mathematics (9th Edition)
Mathematics with Applications In the Management, Natural and Social Sciences (11th Edition)
- Nas corporation's manager in the stamping department have been studying the overhead cost and the relatioship machine hours. Data from the most recent 12 months Month Overhead Machine hours January 5,030 2,730 February 1,600 600 March 7,210 3,403 April 4,560 2,200 May 6,880 3,411 June 6,520 2,586 July 6,230 3,364 August 5,570 2,411…arrow_forwardConstruct simple aggregative price index from the following data : Commodities Prices in 2015 Prices in 2016 I 15.00 18.00 II 5.00 8.00 III 2.25 4.00 IV 6.00 7.00arrow_forwardExcel 3 - Activity 2 - Imbedded Pie Charts 1. Open the Excel 3 Activity 2 Weekly Sales Pie Chart file from the shared drive. 2. Save the file as 21 Activity Activity2 3. to your student drive in your Excel 3 folder. 4. Update the header and footer in class format. 5. Update your document properties. 6. Highlight the cells A3:A7 and using the CTRL key, highlight 13:17. 7. Insert a 3D ple chart from the Insert menu and move and resize it so it goes from the top of A10 to the bottom of 125. 8. Remove the legend by going to the Layout tab, click on the Legend button and choose none. 9. Add data labels to the outside of each pie plece, Band category names by a. Click on the Layout tab b. Click on Data Labels m Cumlish (United Chakr 50₂ Spread c. Choose More Data Label Options at the bottom of the menu. d. Click on Category Name e. Remove the check from Value f. Click on Percentage g. Leave the check on Leader Lines h. Click on Outside End in Label Position 1. Click on Close THAI HO 10.…arrow_forward
- 3.2 Section Exerc dndode ui uonsanb MalA se prices: The following table presents prices, in thousands of dollars, of single-family homes for some of the largest opolitan areas in the United States for the first quarter 2012 and the first quarter of 2013. Metro Area 2012 2013 Baltimore, MD 218.1 226.5 Boston, MA 311.5 332.2 157.2 159.4 112.5 Chicago, IL Cincinnati, OH 121.0 Cleveland, OH 84.9 101.0 Dallas, TX 148.2 160.4 Denver, CO 226.4 261.2 152.1 122.1 155.1 Houston, TX 163.7 Las Vegas, NV Miami, FL 182.0 219.9 Source: National Realtors Association Send data to Excel Part 1 of 2 (a) Find the population standard deviation for 2012. Round the answer to at least two decimal places. In 2012, the population standard deviation, in thousands of dollars, was Part 2 of 2 (b) Find the population standard deviation for 2013. Round the answer to at least two decimal places. In 2013, the population standard deviation, in thousands of dollars, wasarrow_forwardMonth January February March April May June July August September October November December Year 2016 2017 2018 $1,468 $1,386 $1,271 727 719 709 778 713 687 691 707 729 781 704 669 1,374 997 689 703 709 734 710 787 727 701 1,524 1,364 1,064 986 715 741 742 768 1,256 1,157 1,259 Click here for the Excel Data File 2019 $1,144 666 685 c. Which forecasting model is appropriate based on the data for the total U.S. bookstore sales? Appropriate model Regression analysis d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 4 decimal places.)arrow_forwardAssume that a company wants to separate a mixed cost into its variable and fixed elements for cost estimation purposes. It provided the following information: Uni ts Mixed Month Produced Cost $11, 045 $11, 870 $11, 560 January 1, 050 February 1, 150 March 1, 100 1, 250 $12, 100 $10, 800 $12, 210 $10, 970 $11, 005 April May 950 June 1, 280 July 990 August 1, 010 The regression equation used for estimating the total mixed cost for a given level of activity is closest to:arrow_forward
- Please answer C. and D. Palisades Eco-Park is a small ecological reserve that admits a relatively small number of visitors on any day, but provides both educational and entertaining lectures, exhibitions, and opportunities to observe nature. The company has collected the following data on labor costs and number of visitors to the park over the last 30 months. Month Labor Cost Visitors 1 $ 25,820 1,700 2 $ 36,290 2,592 3 $ 39,968 2,811 4 $ 31,648 2,222 5 $ 34,809 2,373 6 $ 32,672 2,181 7 $ 32,023 2,205 8 $ 38,334 2,676 9 $ 38,568 2,760 10 $ 46,933 3,572 11 $ 42,157 2,976 12 $ 39,030 2,804 13 $ 34,444 2,415 14 $ 33,173 2,336 15 $ 36,971 2,508 16 $ 26,500 2,099 17 $ 30,663 3,397 18 $ 29,961 2,786 19 $ 27,590 2,412 20 $ 30,003 2,972 21 $ 25,692 2,000 22 $ 24,655 1,794 23 $ 28,892 3,267 24 $ 30,153 3,817 25 $ 28,119 2,592 26 $ 31,690 3,274 27 $ 28,651 2,989 28 $ 29,927 3,050 29 $ 28,438 2,511 30 $ 27,874 2,075…arrow_forwardUse the most accurate method to forecast the revenues of licenses, permits, and fees in Years 9, 10, and 11. Use the Year 8 actual figure instead of the forecast figure (Year 8 was $23,210,218). Also, consider three incremental changes in forecasting.arrow_forwardSuppose the table below gives the average tuition and fees at 2-year and 4-year state schools in a particular state. Values are adjusted to 2019 dollars. Academic Year 4-year state school 2-year state school 2005-06 $5,904 $2,661 2006-07 $6,066 $2,539 2007-08 $6,289 $2,604 2008-09 $7,222 $2,901 2009-10 $7,738 $3,065 2010-11 $8,035 $3,117 2011-12 $8,154 $3,108 2012-13 $8,497 $3,075 2013-14 $8,578 $3,025 2014-15 $9,390 $3,326 2015-16 $10,004 $3,504 2016-17 $10,474 $3,663 2017-18 $10,789 $3,830 2018-19 $10,874 $3,859 2019-20 $10,900 $3,907 Here is a graph of the information from the table. a. What is the absolute change in tuition and fees at this state's four-year institutions from 2005-06 to 2019-20? b. What is the relative change in tuition and fees at this state's four-year institutions from 2005-06 to 2019-20? Round to the nearest whole percentage…arrow_forward
- The following data were taken from the annual reports of Big Bang Inc., a manufacturer of fireworks, and Orange Inc., a manufacturer of computers. Big Bang, Inc. Orange, Inc. Cost of goods sold $830,000 $11,540,000 Inventory, end of year 190,000 320,000 Inventory, beginning of year 240,000 290,000 What is the inventory turnover for Big Bang and Orange. a. Big Bang, Inc.: 3.86Orange, Inc.: 37.84 b. Big Bang, Inc.: 3.86Orange, Inc.: 9.65 c. Big Bang, Inc.: 94.55Orange, Inc.: 37.84 d. Big Bang, Inc.: 94.55Orange, Inc.: 9.65arrow_forwardBuilding Year of sale 1 2005 1 2005 2 2007 2007 2004 2007 2007 2008 2008 2008 ID Property # Area (ft.) Price 1030 11 Apartment 30 743.09 $ 246,172.68 1029 10 Apartment 29 756.21 $ 246,331.90 2002 7 Apartment 2 587.28 $ 209,280.91 2031 12 Apartment 31 1604.75 $ 452,667.01 1049 11 Apartment 49 1375.45 $ 467,083.31 3011 9 Apartment 11 675.19 $ 203,491.85 3026 9 Apartment 670.89 $ 212,520.83 3023 1 Apartment 720.81 $ 198,591.85 1031 6 Apartment $ 265,467.68 782.25 794.52 4023 3 Apartment $ 235,633.26 Customer Entity Name Surname Interval Gender Country State ID C0028 Individual Madalyn Mercer 19 18-25 F USA California Home C0027 Individual Lara Carrillo 22 18-25 F USA California Home C0112 Individual Donavan Flowers 22 18-25 M USA California Home C0160 Individual Darien Dorsey 22 18-25 M USA California Investment C0014 Individual Alessandra Perry 25 18-25 F USA California Home C0125 Individual Kaitlin Owen 26 26-35 F USA Virginia Investment C0125 Individual Kaitlin Owen 26 26-35 F USA…arrow_forwardSpring is a peak time for selling houses. Suppose the data below contains the selling price, number of bathrooms, square footage, and number of bedrooms of 26 homes sold in Ft. Thomas, Kentucky, in spring 2018. Selling Price Baths Sq Ft Selling Price 160,000 170,000 178,000 182,500 195,100 212,500 245,900 250,000 255,000 258,000 267,000 268,000 275,000 1.5 1,786 2 1,768 1 1,219 1 1,578 1.5 1,125 2 1,196 2 2,128 N W 3 2 1,280 1,596 3.5 2,374 2.5 2,439 2 1,470 2 1,688 Beds 3 3 3 2 3 2 3 3 3 4 3 4 4 295,000 325,000 325,000 328,400 331,000 344,500 365,000 385,000 395,000 399,000 430,000 430,000 454,000 Baths Sq Ft 2.5 1,860 3 2,056 3.5 2,776 2 1,408 1.5 1,972 2.5 1,736 2.5 1,990 2.5 3,640 2.5 1,928 2 2,108 2 2,462 2 2,615 3.5 3,700 Beds 3 4 4 4 3 3 4 4 4 3 4 4 4 Consider the estimated regression equation we developed that can be used to predict the selling price given the number of bathrooms, square footage, and number of bedrooms in the house. (x, denotes number of bathrooms, x₂ denotes…arrow_forward
- Discrete Mathematics and Its Applications ( 8th I...MathISBN:9781259676512Author:Kenneth H RosenPublisher:McGraw-Hill EducationMathematics for Elementary Teachers with Activiti...MathISBN:9780134392790Author:Beckmann, SybillaPublisher:PEARSON
- Thinking Mathematically (7th Edition)MathISBN:9780134683713Author:Robert F. BlitzerPublisher:PEARSONDiscrete Mathematics With ApplicationsMathISBN:9781337694193Author:EPP, Susanna S.Publisher:Cengage Learning,Pathways To Math Literacy (looseleaf)MathISBN:9781259985607Author:David Sobecki Professor, Brian A. MercerPublisher:McGraw-Hill Education