Contemporary Mathematics For Business & Consumers, Loose-leaf Version
8th Edition
ISBN: 9781305867185
Author: Robert Brechner, Geroge Bergeman
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 21.I, Problem 5RE
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.
Component bar chart of the standard and deluxe model sales as components of total mono sales in the Northeast territory
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
%24
%24
T
%24
3.
3.
2.
5
2.
2.
2.
R
%24
3.
23
316 Business &
PIC
Spreadsheet Assignment
2012 Value
2013 Value
2014 Value
1=North
Country
Region
2011 Value
and South
Canada
1.
$16,290.00
$15,395.00
$16,863.00
$17,064.00
America
$ 2,611.00
$ 2,606.00
$ 2,202.00
$ 2,875.00
2-Asia &
$ 741.00
2$
$10,790.00
$ 1,108.00 $ 1,053.00
$ 833.00
zea
Hong Kong
East
$ 8,109.00
$ 8,897.00
$ 9,310.00
3=Europe
Israel
$ 5,133.00
$ 4,469.00
$ 5,226.00
$ 6,367.00
$ 4,286.00
$ 2,482.00
$ 4,291.00
$ 2,520.00
China
$ 4,459.00
$ 5,033.00
2.
India
$ 2,748.00
$ 2,026.00
2.
United Arab Emirates
$ 1,517.00
$ 1,636.00
$ 2,013.00
$ 1,921.00
Japan
$ 2,519.00
$2,254.00
$ 2,089.00
$1,902.00
2.
Netherlands
$ 2,187.00
$ 1,505.00
$1,491.00
$ 1,279.00
2.
Taiwan
$ 1,248.00
763.00
844.00
744.00
905.00
24
761.00
846.00
Turkey
739.00
Thailand
24
502.00
467.00
517.00
Saudi Arabia
597.00
572.00
24
Australia
987.00
$ 1,017.00
2$
$ 6,498.00
932.00
Switzerland
$ 5,007.00
$10,042.00
$ 8,744.00
3.
United Kingdom
$ 6,514.00
$ 6,549.00…
Month
Number of
Tables Produced
EA 10. LO 2.3 This cost data from Hickory Furniture is for the year 2017.
Factory
Utility Expenses
January
550
$2,063
February
710
2,663
March
650
2,438
April
470
1,823
May
512
1,920
June
625
2,344
July
805
3,019
August
750
2,813
September
675
2,531
October
525
1,969
November
875
3,281
December
685
2,569
A. Using the high-low method, express the company's utility costs as an equation where X represents
number of tables produced.
B. Predict the utility costs if 800 tables are produced.
C. Predict the utility costs if 600 tables are produced.
D. Using Excel, create a scatter graph of the cost data and explain the relationship between number of
tables produced and utility expenses.
Munoz Manufacturing Company established the following standard price and cost data:
Sales price
Variable manufacturing cost
Fixed manufacturing cost
Fixed selling and administrative cost
$ 8.60 per unit
$ 3.50 per unit
$ 2,500 total
$ 1,000 total
Munoz planned to produce and sell 2,400 units. Actual production and sales amounted to 2,600 units.
Assume that the actual sales price is $8.40 per unit and that the actual variable cost is $3.70 per unit. The actual fixed manufacturing
cost is $2,000, and the actual selling and administrative costs are $1,030.
Required
a.&b. Determine the flexible budget variances and classify the effect of each variance by selecting favorable (F) or unfavorable (U).
Note: Select "None" if there is no effect (i.e., zero variance).
Flexible Budget
Variances
Sales
Variable manufacturing
Contribution margin
Fixed manufacturing
U
F
Fixed selling and administrative cost
U
Net income (loss)
U
Chapter 21 Solutions
Contemporary Mathematics For Business & Consumers, Loose-leaf Version
Ch. 21.I - Use Table 21-1 to answer the following questions...Ch. 21.I - Use Exhibits 21-1 and 21-2 to answer the following...Ch. 21.I - Prob. 3TIECh. 21.I - Prob. 4TIECh. 21.I - Prob. 5TIECh. 21.I - Prob. 6TIECh. 21.I - Prob. 7TIECh. 21.I - Prob. 8TIECh. 21.I - Prob. 9TIECh. 21.I - Prob. 10TIE
Ch. 21.I - Prob. 1RECh. 21.I - TABLE 21-1 Magnum Enterprises Six-Month Sales...Ch. 21.I - Prob. 3RECh. 21.I - Prob. 4RECh. 21.I - TABLE 21-1 Magnum Enterprises Six-Month Sales...Ch. 21.I - Prob. 6RECh. 21.I - Prob. 7RECh. 21.I - BUSINESS DECISION: CHOOSING A CHART
8. You have...Ch. 21.II - Prob. 11TIECh. 21.II - Prob. 12TIECh. 21.II - Prob. 13TIECh. 21.II - Prob. 14TIECh. 21.II - Prob. 15TIECh. 21.II - Prob. 1RECh. 21.II - Prob. 2RECh. 21.II - Prob. 3RECh. 21.II - Prob. 4RECh. 21.II - Prob. 5RECh. 21.II - Prob. 6RECh. 21.II - Prob. 7RECh. 21.II - Prob. 8RECh. 21.II - Prob. 9RECh. 21.II - Prob. 10RECh. 21.II - Determine the mode of the following sets of...Ch. 21.II - Prob. 12RECh. 21.II - Prob. 13RECh. 21.II - Prob. 14RECh. 21.II - Prob. 15RECh. 21.II - Prob. 16RECh. 21.II - Prob. 17RECh. 21.II - The following numbers represent the gallons of...Ch. 21.II - You are the owner of The Dependable Delivery...Ch. 21.II - Prob. 20RECh. 21.III - Prob. 17TIECh. 21.III - Prob. 18TIECh. 21.III - Prob. 1RECh. 21.III - You are the sales manager of the Esquire...Ch. 21.III - Prob. 3RECh. 21.III - BUSINESS DECISION: RELATIVE FREQUENCY...Ch. 21 - 1. The systematic process of collecting,...Ch. 21 - 2. Statistical procedures that deal with the...Ch. 21 - A collection of related data arranged for ease of...Ch. 21 - Prob. 4CRCh. 21 - 5. The horizontal axis of a line chart is known as...Ch. 21 - Prob. 6CRCh. 21 - To construct a pie chart, we multiply each...Ch. 21 - Prob. 8CRCh. 21 - 9. The _______ is the midpoint value of a set of...Ch. 21 - Prob. 10CRCh. 21 - Prob. 11CRCh. 21 - Prob. 12CRCh. 21 - Prob. 13CRCh. 21 - Prob. 14CRCh. 21 - 1. The following data represent the monthly sales...Ch. 21 - Prob. 2ATCh. 21 - Prob. 3ATCh. 21 - You have just been hired as the quality control...Ch. 21 - 5. You are the human resource director for Apollo...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.Similar questions
- 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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- 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
Discrete Mathematics and Its Applications ( 8th I...
Math
ISBN:9781259676512
Author:Kenneth H Rosen
Publisher:McGraw-Hill Education
Mathematics for Elementary Teachers with Activiti...
Math
ISBN:9780134392790
Author:Beckmann, Sybilla
Publisher:PEARSON
Thinking Mathematically (7th Edition)
Math
ISBN:9780134683713
Author:Robert F. Blitzer
Publisher:PEARSON
Discrete Mathematics With Applications
Math
ISBN:9781337694193
Author:EPP, Susanna S.
Publisher:Cengage Learning,
Pathways To Math Literacy (looseleaf)
Math
ISBN:9781259985607
Author:David Sobecki Professor, Brian A. Mercer
Publisher:McGraw-Hill Education
Hypothesis Testing using Confidence Interval Approach; Author: BUM2413 Applied Statistics UMP;https://www.youtube.com/watch?v=Hq1l3e9pLyY;License: Standard YouTube License, CC-BY
Hypothesis Testing - Difference of Two Means - Student's -Distribution & Normal Distribution; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=UcZwyzwWU7o;License: Standard Youtube License