Business Analytics (2nd Edition)
2nd Edition
ISBN: 9780321997821
Author: James R. Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 11PE
Suppose that a company offers quantity discounts. If up to 1000 units are purchased, the unitl price is $10; if more than 1000 and up to 5000 units are purchased, the unit price is $9; and if more than 5000 units are purchased, the unit price is $7.50. Develop a spreadsheet using the VLOOKUP
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
a. Predict the sales resulting from a $15,000 investment in inventory and an advertising budget of $10,000.
The following table shows the expenses and income for a local college student. Assume that amounts shown for salaries and wages are after taxes and that 1 month = 4 weeks.
Income
Expenses
Part-time Job: $1100/month
Rent: $550/month
Student Loans: $8400/year
Groceries: $50/week
Scholarship: $5700/year
Tuition and Fees: $7500/year
Health Insurance: $40/month
Entertainment: $40/week
Phone: $65/month
a) What is the student's monthly income?
b) What is the student's monthly expenses?
c) What is the student's net monthly cash flow?
The percentage of employees who cease their employment during a year is referred to as employee turnover, and it is a serious issue for businesses. The following table shows the cost, in millions of dollars, to a certain company for a given employee turnover percentage in a year.
Chapter 2 Solutions
Business Analytics (2nd Edition)
Ch. 2 - The Excel file Presidents Inn Guest Database...Ch. 2 - The worksheet Base Data in the Excel file Credit...Ch. 2 - A manager needs to identify some information from...Ch. 2 - Example 1.4 in Chapter 1 described a scenario for...Ch. 2 - Example 1.8 in Chapter 1 provided data from an...Ch. 2 - The following exercises use the Purchase Orders...Ch. 2 - Use INDEX and MATCH functions to fill in a table...Ch. 2 - Suppose that a company offers quantity discounts....
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
- Suppose one canoe rents for 40,and2 is taken off the price for each additional canoe rented by a ground. What size group gives the most income? Assume that there are 20 canoes available.arrow_forwardAssume that the company produces 100 pound sacks of 35-25-15 fertilizer for lawns and 100 pound sacks of 13-15-15 fertilizer for gardens, where the numbers are the percentage by weight of nitrate, phosphate, and potash, respectively, in each sack. Assume also that the company has on hand 13 tons of nitrate, 11 tons of phosphate, and 10 tons of potash. Assume also that the profit on each sack of lawn fertilizer is $15.00 and the profit on each sack of garden fertilizer is $7.00. How many sacks of each type of fertilizer should the company make in order maximize its profit?arrow_forwardGiovanni Food Products produces and sells frozen pizzas to public schools throughout the eastern United States. Using a very aggressive marketing strategy they have been able to increase their annual revenue by approximately $10 million over the past 10 years. But increased competition has slowed their growth rate in the past few years. The annual revenue, in millions of dollars, for the previous 10 years is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.arrow_forward
- The expenses and income of an individual are given in table form to the right. Find the Income net monthly cash flow (it could be positive or negative). Assume salaries and wages are after taxes. When you need to convert between weeks and months assume that Part-time job: $600 / month 1 month = 4 weeks Expenses Rent: $500 / month College fund from grandparents: $450 / month Groceries: $50 / week Scholarship: $5400 / year Tuition and fees: $2400 twice a year Incidentals: $60 / week The net monthly cash flow is $arrow_forwardThe table to the right shows expenses and income for an individual. Find the net monthly cash flow (it could be negative Income or positive). ASsume that salaries and wages are after taxes, and assume 1 month = 4 weeks. |Expenses Salary: $2400 / month Rent: $890 /month Groceries: $90/week Utilities: $110/ month Health insurance: $380 semiannually Car insurance: $530 semiannually Gasoline: $35/week Miscellaneous: $410/month Phone: $75/month The net monthly cash flow is $ (Round to the nearest dollar as needed.)arrow_forwardThe 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? *arrow_forward
- The expenses and income of an individual are given in table form to the right. Find the net monthly cash flow (it may be negative or positive). Assume that amounts shown for salaries and wages are after taxes and that 1 month= 4 weeks. Income Part-time job: $1400/month Student loans: $6600/year Scholarship: $5500/year The net monthly cash flow is $ (Round to the nearest dollar as needed.) Expenses Rent: $550/month Groceries: $40/week Tuition and fees: $7500/year Health insurance: $40/month Entertainment: $300/month Phone: $70/month CINCIarrow_forwardCalculate the cost of acquisition of the second lot.arrow_forwardFind the total revenue functionarrow_forward
- Bruno Fruscalzo decided to start a small production facility in Sydney to sell gelato to the local restaurants. His local milk supplier charges $0.5 per kg of milk plus a $15 delivery fee (that is independent of the amount ordered). Bruno's holding cost is $0.03 per kg per month. He needs 9250 kgs of milk per month. a. Suppose Bruno orders 9750 kgs each time. What is his average inventory (kgs)? (Round your answer to 1 decimal place.) b. Suppose Bruno orders 6250 kgs each time. How many orders does he place with his supplier each year? C. How many kgs should Bruno order from his supplier with each order to minimize the sum of ordering and holding costs? (Do not round intermediate calculations. Round your answer to 2 decimal places.) If Bruno's storage vessel can hold only 2000 kgs of milk, what would be Bruno's annual ordering and holding costs? (Do not round intermediate calculations. Round your answer to 2 decimal places.) If Bruno's storage vessel can hold only 5750 kgs of milk,…arrow_forwardAn employer pays $3,000 monthly rent for office space and $1,000 to 12 employees, plus a bonus of $10 for each unit of work completed by the employee during the month. In addition, the employer has a profit of $18 per unit of work per employee.• Suppose an employee completes 300 units in a month. Let's also assume that all employees completed 300 units. Calculate the employer's income.arrow_forwardThe prices have increased/changed from the last question please read carefullyarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
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