Business Analytics
3rd Edition
ISBN: 9780135231678
Author: Evans, James R. (james Robert)
Publisher: PEARSON EDUCATION (COLLEGE)
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 35PE
A college graduate who is living in Cincinnati expects to earn an annual salary of $55,000. The Excel file Cost of Living Adjustments shows the comparative salaries in other cities and percentage adjustments for living expenses. Develop an Excel template that allows the user to enter current annual expenses (in Cincinnati) for groceries, housing, utilities, transportation, and health care and compute the corresponding expenses for any selected city and the net salary surplus for both Cincinnati and the selected city. An example of what the output should look like is provided next:
Use a list box form control to select the city and sliders to input current annual expenses.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
how do we estimate direct and indirect costs .
explain in detail.
The estimated demand and supply
curve for apples is displayed below. If
the current price is $100/ton, is there
currently a surplus or shortage in the
market for apples? By how much? *
The director of a nonprofit ballet company in a medium-sized city in a certain country is planning its next fundraising campaign. In recent years, the program has
found the percentages of donors and gift levels given in the accompanying table. Develop a spreadsheet model to calculate the total amount donated based on
this information if the company contacts 900 potential donors to donate at the $100 level or below
E Click the icon to view the percentages of donors and gift levels.
C.....
3 Philanthropist
$5,000
11
=B3*C3
4 Producer's Circle
$1,000
25
=B4*C4
5 Director's Circle
$500
49
=B5 C5
6 Principal
$100
8%
=B6*C6*$B$9
7 Soloist
$50
14% =B7*C7*SB$9
8.
9 Solicitations
900
10 Total Donations
=SUM(D2:D7)
Enter the values in the model.
(Type integers or decimals. Do not round.)
B
D
Average Number
of Gifts
1 Gift Level
Amount
Donations
2 Benefactor
$10,000
3 Philanthropist
$5,000
11
4 Producer's Circle
$1,000
25
5 Director's Circle
$500
49
6 Principal
$100
8%
ns?
7 Soloist
$50
14%
8.
9…
Chapter 2 Solutions
Business Analytics
Ch. 2 - Explain the difference between a data set and a...Ch. 2 - For the Monthly Product Sales Excel file, use the...Ch. 2 - For the Monthly Product Sales Excel file, use the...Ch. 2 - What does the term filtering mean in the context...Ch. 2 - Convert the Credit Risk database to an Excel...Ch. 2 - Sort the data in the purchase orders database from...Ch. 2 - Prob. 2.4CYUCh. 2 - Prob. 3.1CYUCh. 2 - Prob. 3.2CYUCh. 2 - Prob. 3.3CYU
Ch. 2 - Prob. 4.1CYUCh. 2 - In the Purchase Orders database, what will =...Ch. 2 - Prob. 4.3CYUCh. 2 - Prob. 5.1CYUCh. 2 - Prob. 5.2CYUCh. 2 - Prob. 5.3CYUCh. 2 - Prob. 5.4CYUCh. 2 - Prob. 6.1CYUCh. 2 - Prob. 6.2CYUCh. 2 - Prob. 6.3CYUCh. 2 - The Excel file MBA Motivation and Salary...Ch. 2 - Prob. 2PECh. 2 - The Budget Forecasting database shows estimated...Ch. 2 - Convert the Store and Regional Sales database to...Ch. 2 - Convert the Purchase Orders database to an Excel...Ch. 2 - Prob. 6PECh. 2 - The Excel file Corporate Default Database...Ch. 2 - Open the Excel file Store and Regional Sales...Ch. 2 - In the Excel file Automobile Quality, search for...Ch. 2 - In the Purchase Orders database, conduct a Pareto...Ch. 2 - Conduct a Pareto analysis for the number of...Ch. 2 - Prob. 12PECh. 2 - In the Sales Transactions database, use Excels...Ch. 2 - Filter the data in the Bicycle Inventory database...Ch. 2 - Use the Excel file Credit Risk Data that was...Ch. 2 - Apply the Advanced Filter to the Credit Risk Data...Ch. 2 - Prob. 17PECh. 2 - Prob. 18PECh. 2 - Modify the data in the Base Data worksheet in the...Ch. 2 - Prob. 20PECh. 2 - Figure 2.41 shows the 2016 U.S. federal income tax...Ch. 2 - For the Bicycle Inventory database, write a...Ch. 2 - Prob. 23PECh. 2 - A manager needs to identify some information from...Ch. 2 - The Excel file SP 500 provides open, high, low,...Ch. 2 - Enhance the Sales Transactions database file to...Ch. 2 - Prob. 27PECh. 2 - For this exercise, use the Purchase Orders...Ch. 2 - Use INDEX and MATCH functions to fill in a table...Ch. 2 - Prob. 30PECh. 2 - Prob. 31PECh. 2 - Prob. 32PECh. 2 - Prob. 33PECh. 2 - Prob. 34PECh. 2 - A college graduate who is living in Cincinnati...Ch. 2 - The Excel file Payroll Data provides hourly...Ch. 2 - Construct PivotTables showing the counts of gender...Ch. 2 - Prob. 38PECh. 2 - Prob. 39PECh. 2 - Prob. 40PECh. 2 - Prob. 2.1C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Median household income sharply increased in 2015 by 5.2% but only grew by 1.8% in 2017 to $61,372. What was the median income in 2016? What is the total difference in growth (5.2% to 1.8%) from 2015 to 2017? A census report said that 28.5 million people, or 8.8% of the population, lacked health insurance for all of 2017. Use this information to compute the total population.arrow_forwardAnnual forecasts of demand for this site ranges from 13,000 to 26,000 per year. Calculate the net profit/loss of the site in each of the following situations. Round your answers to the nearest dollar. If your answer is zero, enter "0". Use a minus sign to enter loss, if any.arrow_forwardComplete the chase production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here. Click the icon to view the costs table. Click the icon to view the forecasted sales. Fill in the production plan table below (enter your responses as whole numbers). More Info Totals Costs Cost of plan Month March Planning values Starting inventory Starting and ending workforce Hours worked per month per worker Hours per unit Hiring cost per worker Layoff cost per worker Monthly per-unit holding cost Print Forecasted sales 1,917 Sales in to meet worker sales hours average = 253 Layoff 256 $256,000 Done Hiring Inventory 256 18,000 $18,000 $1,024,000 $1,298,000 1,500 209 315 35 $4,000 $1,000 $1 Actual workers 209 Actual production Layoffs Hiring More Info Ending inventory 1,500 Month March April May June July August September October…arrow_forward
- The marketing manager of "ABC Tapes" wants to assess the competitiveness of the company's product in the market. Table 1 represents the prices and quantities of blank cassette tapes sold in January 2016 and January 2020. TABLE 1 2016 2020 Length of tapes Price Quantity Price Quantity 30 minutes R 4.00 32 R 5.60 40 60 minutes R 4 30 150 R 6.15 190 90 minutes R 4.60 100 R 7.40 130 Using 2016 as base and calculate for 2020 the following: Determine the Laspeyres price index: a) 149.492 Ob) 149.367 Oc) 66.949 d) 66.893arrow_forwardWhich among the following cost do not increase or decrease according to the volume of production? a. Total costs b. Fixed cost c. Semi-variable costs d. Variable costarrow_forwardIn 2012 the nominal value for household spending on clothing and shoes was equal to $5013m and in 2021 it was $7036m. Using the most appropriate price index from the list below, calculate the percentage change in real household spending on clothing and shoes from 2012 to 2021 and answers the questions below. 2012 2021CPI (Clothing) 961 1057CPI (All groups) 949 1068PPI (Outputs - Clothing and textiles) 1031 1171Import price index (Clothing and textiles) 1436 1306 The percentage change in nominal household spending on clothing and shoes is equal to ______?arrow_forward
- If there was a baby boom of Oompa Loompas ready to work for free, what will happen to the Willy Wonka chocolate market? A few things to think about: Has this affected supply or demand of Willy Wonka Chocolate? What has happened to the price of Willy Wonka chocolate? Please justify your answer by graphing the change in either supply or demand, as well as the change in price.arrow_forwardplease include steps and explaination .arrow_forwardChoose the best model for revenue and then write a total cost function for fertilizer. Use graphs on your calculator to find where cost equals revenue.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Use of ALGEBRA in REAL LIFE; Author: Fast and Easy Maths !;https://www.youtube.com/watch?v=9_PbWFpvkDc;License: Standard YouTube License, CC-BY
Compound Interest Formula Explained, Investment, Monthly & Continuously, Word Problems, Algebra; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=P182Abv3fOk;License: Standard YouTube License, CC-BY
Applications of Algebra (Digit, Age, Work, Clock, Mixture and Rate Problems); Author: EngineerProf PH;https://www.youtube.com/watch?v=Y8aJ_wYCS2g;License: Standard YouTube License, CC-BY