2. (LO 2.3) Northwind Traders is a fictitious specialty foods company created by Microsoft, which has also created a fictitious database for the company. The Northwind database includes several tables, including Products, Suppliers, and Categories. Pictured below is a subset of the Products table, which details all the products that Northwind Traders sells. ProductName SupplierID CategoryID QuantityPerUnit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel Discontinued 10 boxes x 20 Chai Chang Aniseed Syrup Chef Anton's Cajun Seasoning 1 1 1 2 1 bags 24-12 oz 1 bottles 12 - 550 ml 2 bottles 2 48-6 oz jars 18 19 10 22 39 17 13 53 0 40 70 0 10 25 25 0 b. If you averaged everything in the SupplierID field, would you obtain a useful number? Explain. c. If you averaged UnitPrice, would you obtain a useful number? Explain. 0 0 0 0 a. Review each variable in the Products table. Which would be classified as numerical data-that is, data that would be interesting to add or average?

2. (LO 2.3) Northwind Traders is a fictitious specialty foods company created by Microsoft, which has also created a fictitious database for the company. The Northwind database includes several tables, including Products, Suppliers, and Categories. Pictured below is a subset of the Products table, which details all the products that Northwind Traders sells. ProductName SupplierID CategoryID QuantityPerUnit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel Discontinued 10 boxes x 20 Chai Chang Aniseed Syrup Chef Anton's Cajun Seasoning 1 1 1 2 1 bags 24-12 oz 1 bottles 12 - 550 ml 2 bottles 2 48-6 oz jars 18 19 10 22 39 17 13 53 0 40 70 0 10 25 25 0 b. If you averaged everything in the SupplierID field, would you obtain a useful number? Explain. c. If you averaged UnitPrice, would you obtain a useful number? Explain. 0 0 0 0 a. Review each variable in the Products table. Which would be classified as numerical data-that is, data that would be interesting to add or average?

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

Sub : EconomicsPls answer very fast.I ll upvote correct answer. Thank You
Hand written solutions are strictly prohibited
Make yourself CEO of this hypothetical company. Big Time Entertainment - Big Time Entertainment is a nationwide firm providing movies, arcades and other entertainment venues such as bowling and roller skating. Our operations have been heavily impacted during the Covid-19 pandemic. On reopening we have been faced with a host of regulations that have greatly increased our cost of operations. We also face uncertainty as to the potential for additional shutdowns. Customers are fearful plus the guidance on operating our facilities means we are operating far below our optimal number of patron to cover the higher cost for cleaning and other measure to protect the public and our employees. Price elasticity of demand is 1.6 and we are also faced with more competitors, online entertainment and gaming, that are not experiencing these cost pressures. Is the demand curve for your product relatively elastic, inelastic or unitary elastic? Demonstrate for your company's product, by how much the…
ABC Company is engaged in the production of processed meats like tocino, chicken longganisa, pork longganisa, and siomai both chicken and pork. Their famous product is pork longganisa and it sells like a hot potato before the pandemic came. They are selling their products in their stall in the public market of Lipa. Their products are also available in their residence located in Brgy. Marawoy, Lipa City. Both locations are accessible to their suki, basically one of the reasons why their business is doing well. But because of the pandemic the sales of ABC Company were affected and slow down. On the first 5 months of the pandemic, the business is still earning profits but on the succeeding months, slowly they experience losses. Aside from the covid 19 pandemic, another factors that influence in the loss of the company is the price of the raw materials like pork and chicken. They have a total of 10 employees who are in charge in the production and in the stall. What solution would you…
The American Baker's Association reports that annual sales of bakery goods last year rose 15 percent, driven by a 50 percent increase in the demand for bran muffins. Most of the increase was attributed to a report that diets rich in bran help prevent certain types of cancer. You are the manager of a bakery that produces and packages gourmet bran muffins, and you currently sell bran muffins in packages of three. However, as a result of this new report, a typical consumer's inverse demand for your bran muffins is now P=8 -050 If your cost of producing bran muffins is CQ)=2.5Q determine the optimal number of bran muffins to sell in a single package and the optimal package price. Instructions: Enter your response for the optimal package price rounded to two decimal places. Optimal package size: Optimal package price: $ units
Home Depot and Lowe's are in a price war on refrigerators. Refrigerators at Home Depot cost $1,000 with a price matching guarantee of a 10% rebate on the price difference with Lowe's, whose refrigerators cost $800. Is this price matching guarantee with a 10% rebate beneficial to the consumer? No, eventually both stores will offer the price matching with rebate and post the price of refrigerators at $1,000, the High Price. Yes, consumers will be able to buy their refrigerators at Home Depot for $780. No, both Lowe's and Home Depot will stop selling refrigerators. O Yes, consumers will be able to buy refrigerators at either store at the Low Price of $800, the lower posted price.
Pretend that you are working for Del Monte in the area of canned vegetables and that Del Monte has a system that uses data analytics. One of your major competitors is Green Giant vegetables. You are particularly interested in analyzing canned green beans. A portion of Del Monte’s data analytic system contains the following variables: Sales of various can sizes; prices of various sized cans; types of stores where green beans are sold; shelf locations of green beans in various types of stores; various promotions pertaining to green beans. Also assume that this analytic system also has this information for Green Giant beans. Explain for what types of decisions could this system be used concerning Del Monte’s Green Beans. Also address the possibility of competitive analyses pertaining to Green Giant Beans.
6. Complete the accompanying table and answer the accompanying questions. (LO1, L06, L07) a. At what level of the control variable are net benefits maximized? b. What is the relation between marginal benefit and marginal cost at this level of the variable? Control Variable Q 100 101 102 103 104 105 106 107 108 109 110 Total Benefits B(Q) 1200 1400 1590 1770 1940 2100 2250 2390 2520 2640 2750 Total Cost C(0) 950 SPONG Net Benefits N(Q) Marginal Benefit MB(0) 210 Marginal Cost MC(0) 60 70 80 90 100 110 120 130 140 150 160 Marginal Net Benefits MNB(0)
You are the manager of College Computers, a manufacturer of customized computers that meet the specifications required by the local university. Over 90 percent of your clientele consists of college students. College Computers is not the only firm that builds computers to meet this university's specifications; indeed, it competes with many manufacturers online and through traditional retail outlets. To attract its large student clientele, College Computers runs a weekly ad in the student paper advertising its "free service after the sale" policy in an attempt to differentiate itself from the competition. The weekly demand for computers produced by College Computers is given by Q = 1,400 - 4P, and its weekly cost of producing computers is C(Q) = 1,600 +2Q². If other firms in the industry sell PCs at $300, what quantity and price of computers should you produce to maximize your firm's profits? Instructions: Round your response to the nearest whole number. Quantity: [ computers…
Betty and Sue both have accounting practices that specialize in income tax preparation. If they both advertise their services each year before the income tax season begins, they will each earn $3 per return. If neither one of them advertises, they will each earn $10 per return. If one advertises and the other one doesn’t, the one who advertises will earn $150 per return and the one who doesn’t advertise will only earn $1 per return. What interest rate would make it so that both of them had the incentive to not advertise? A. 10% and below B. 5% and above C. 5% and below D. 10% and above E. none of the above
Suppose you come home from having earned your degree at CSUEB. Your parents own a localchain of fitness clubs that have a great reputation. Your father uses cost-plus pricing, and at themoment he is charging $200 for an annual membership, and is currently selling 800 memberships.Your parents are quite happy with their current markup above average costs You suspect that perhaps they could be doing better and be more profitable. After consulting with the club’s manager, you learn that the cost function for annual memberships is given by c(Q)=1000+20Q+(1/20)Q2 .Further, they tell you that the own price elasticity of demand is approximately -2.5 Are your parents choosing a membership price that is maximizing profit? If not, what would yousuggest – increase the price or reduce the price? Explain
You have been texting with your friends trying to make plans for this evening. Your best friend Jocelyn is not sure if she will finish her homework in time to come out, but if she does, she wants to go to a new restaurant on the north end of town that you've both been wanting to try. Another group of friends is going to a restaurant on the south end of town, but you've already been to this restaurant and it was only okay. Overall, you would prefer to go to the restaurant with Jocelyn. But if Jocelyn isn't coming out, you would rather hang out with your friends than stay home. No one is returning your calls, but you need to get on the subway and head into town if you want to do anything this evening. You have to decide whether to head north or south. What can we say about a potential dominant strategy in this game? Instructions: In order to receive full credit, you must make a selection for each option. For correct answer(s), click the option once to place a check mark. For incorrect…