In the accompanying Sales Transactions data, use Excel's filtering capability to extract a. all orders that used Paypal.b. all orders under $100.c. all orders that were over $100 and used a credit card. b. Complete the table to show the amounts of all orders under $100.BPaymentPaypalCreditCreditPaypalCredit12345678910111213141516171819لیاARegionEastWestNorthWestSouthWestWestWestSouthSouthEastNorthWestWestEastWestNorthWestPaypalCreditPaypalPaypalPaypalCreditPaypalCreditPaypalPaypalPaypalPaypalCreditSourceWebWebWebEmailWebEmailWebWebWebEmailWebWebWebWebWebWebEmailWebDAmountEProductBookBookDVDBookDVDDVDBookDVDDVDBookDVDDVDBookDVDDVDBookDVDBook Region PaymentEastPaypalWestCreditCreditPaypalCreditNorthWestSouthWestEastWestWestSouthSouthEastNorthEastWestWestEastWestNorthWestPaypalCreditCreditPaypalPaypalPaypalCreditPaypalCreditCreditPaypalPaypalPaypalPaypalCreditSourceWebWebWebEmailWebEmailWebWebWebWebEmailWebWebWebWebWebWebWebEmailWebAmount20.4817.3524.9824.6214.0117.49175.0422.1515.6925.5527.8520.0820.05150.9621.6222.4719.9221.4217.8117.84ProductBookBookDVDBookDVDDVDBookBookDVDDVDBookDVDDVDDVDBookDVDDVDBookDVDBook

We used Excel's filtering capabilities as follows to solve the problem with the given data for Sales…

In the accompanying Sales Transactions data, use Excel's filtering capability to extract a. all orders that used Paypal. b. all orders under $100. c. all orders that were over $100 and used a credit card.

In the accompanying Sales Transactions data, use Excel's filtering capability to extract a. all orders that used Paypal. b. all orders under $100. c. all orders that were over $100 and used a credit card.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter3: Introduction To Optimization Modeling

Section: Chapter Questions

Problem 1C

See similar textbooks

Similar questions

In case of a production company which produces 3 different products (RE1, RE2, RE3), we know the following information: Measuring Unit RE1 RE2 RE3 Quantity unit 3,000,000 4,000,000 5,000,000 Sales Price Euro/unit 2,500 3,000 3,500 Production Cost Euro/unit 1,500 1,500 1,500 Consumption Factor kg/unit 0.02 0.04 0.01 Tasks: a) Has a company scarce resource if the company has only 250 tons raw material? b) Calculate the optimal composition of products! c) Determine the estimated total sales!
An urn contains 10 red balls and 30 blue balls.a Suppose you draw 4 balls from the urn. Let Xi bethe number of red balls drawn on the ith ball (Xi 0 or1). After each ball is drawn, it is put back into the urn. Are the random variables X1, X2, X3, and X4 indepen-dent random variables? b Repeat part (a) for the case in which the balls are notput back in the urn after being drawn.
) Creative Sports Design (CSD) manufactures a standard-size racket and an oversize racket.The firm’s rackets are extremely light due to the use of a magnesium-graphite alloy that wasinvented by the firm’s founder. Each standard-size racket uses 0.125 kilograms of the alloy andeach oversize racket uses 0.4 kilograms; over the next two-week production period only 80kilograms of the alloy are available. Each standard-size racket uses 10 minutes of manufacturingtime and each oversize racket uses 12 minutes. The profit contributions are $10 for eachstandard-size racket and $15 for each oversize racket, and 40 hours of manufacturing time areavailable each week. Management specified that at least 20% of the total production must be thestandard-size racket. How many rackets of each type should CSD manufacture over the next twoweeks to maximize the total profit contribution? Assume that because of the unique nature oftheir products, CSD can sell as many rackets as they can produce.
You work for a small retail store. You must decide how many cases of kombucha to order. Twenty cases fit on a pallet and because of shipping costs, orders must be placed in multiples of 20. You can either order 20, 40, 60, 80 or 100 cases. Each case costs $15. If you order more than 1 pallet, you receive a discount of 5% per additional pallet ordered (2 pallets would be 5%, 3 would be 10%, etc). The cases can be sold for $25 each. Any that are left unsold can be sold to a discount store for $10. Your records suggest that the probability that you will sell 25 cases is 20%, 45 cases is 45%, 65 cases is 20% and 85 cases is 15%. a) Construct a payoff table to provide reflect the decisions and outcomes What would be your decision based on each of the following? Maximin Maximax Minimax regret Expected value Overall - what would you do? Why?
5. Meg Jones, the CEO of Ajax Computer Company, and Brad Smith, its Director of Operations, had been discussing how to increase the firm’s production of the company’s flagship XR58. The XR58 was particularly important because it sold 12,500 of them in the most recent year for $950, at a gross margin of 55%. After a lot of discussion, they decided to pursue an incentive system designed to increase production by 12% in the next year. After Brad discussed this possible incentive with the production team, the team determined that it could increase production by this amount without adding any more people or equipment. They believed they could accomplish this improvement primarily through process redesign. To incent them to do the hard work of process improvement, Brad told the team that it would receive 25% of the increased profits if it met the new production goal. For this team of 20 people, this would mean an additional compensation of _________ for each team member, on average, for…
Please do not give solution in image format thanku The Silly Nut Company makes two mixtures of nuts: Mixture A and Mixture B. A pound of Mixture A contains 12 oz of peanuts, 3 oz of almonds and 1 oz of cashews and sells for $4. A pound of Mixture B contains 12 oz of peanuts, 2 oz of almonds and 2 oz of cashews and sells for $5. The company has 1080 lb. of peanuts, 240 lb. of almonds, 160 lb. of cashews. How many pounds of each of mixtures A and B should the company make to maximize profit? (Hint: Use consistent units. Work the entire problem in pounds by converting all values given in ounces into fractions of pounds).
Use the two – phase simplex method Minimize Ζ = 3x1 + 2x2 + x3 Subject to x1 + 4x2 + 3x3 ≥ 50 2x1 + x2 + x3 ≥ 30 −3x1 − 2x2 – x3 ≤ −40 X1 , x2 , x3 ≥ 0
Prove the following using strong induction. Suppose you are gifted a collection of 3n pokéballs; all of the the pokéballs have the same size and weight except for one which is slightly heavier, and otherwiselook and feel exactly the same as the others. You are tasked with identifying theheavy pokéball and have at your disposal a set of balancing scales which can be usedto compare the weights of two collections of pokéballs. The scales can show whetherthe two collections have the same weight, or can show which collection is heavier if theweights are different. Prove using strong induction that you can identify the heavypokéball out of 3n pokéballs using n weighing operations.
The process of packing 3 16-ounce bottles of Hershey chocolate syrup in super-sized packages like those sold at Sam’s and Costco is an example of:
You are a Business Analyst working for the ABC Ball Bearing company. An hour ago, you sent an order of 74 boxes of your A1 ball bearings to a customer on your delivery truck. You have just found out that your truck is going to go over a bridge that has a weight limit of 11,500 lbs. You need to determine if your truck will safely make it over the bridge. If you determine that the truck cannot make it over the bridge, you will need to call the driver and have him/her turn back. The plant manager has told you that an empty delivery truck with the driver weights about 8500 lbs. You have 30 boxes of the A1 ball bearings in your plant. You immediately had them weighed. The weights of the boxes are: 40.1 41.1 39.5 40.1 39.1 41.2 37.6 39.1 41.6 40.8 43.2 38.9 38.1 43.5 36.9 39.1 40.5 41.2 37.6 44.0 38.0 39.8 42.1 38.6 41.3 43.7 36.9 43.6 38.1 40.2 1. Discuss what sampling bias is. Do you believe that using the 30 boxes in your warehouse caused sampling…
(Use output ranges of 2000, 4000, 6000, 8000 etc. and intervals of $50,000 on the Y axis. Output X Location A Location B Location B Location D 2 000 120 000 120 000 130 000 150 000 4 000 180 000 160 000 160 000 170 000 6 000 240 000 200 000 190 000 190 000 8 000 300 000 240 000 220 000 210 000 10 000 360,000 280 000 250 000 230 000 12 000 420 000 320 000 280 000 250 000 14 000 480,000 360 000 310,000 270 000 16 000 540 000 400 000 340 000 290 000 18 000 600 000 440 000 370 000 310 000 20 000 660 000 480 000 400 000 330 000 Over what range of output is location A the most preferred location? 2. Over what range of output is location B the most preferred location? 3.Over what range of output is location C the most preferred location?
Clippers Inc. (CI) manufactures two types of garden clippers. A light-duty model, called the “half-inch,”is intended for clipping branches and stems up to one-half inch thick. The “one-inch” model is designedfor heavier stems and branches. To boost sales, CI decided at the beginning of the current year to reducethe price of the half-inch model to better position its price relative to some key competitors. On the otherhand, CI felt that the one-inch model was technically superior to competitors’ models and decided that asmall price increase was appropriate. The data for the current and prior year are as follows:Current Year Prior YearSales units 7,200 6,500Sales mix for each productHalf-inch model 50% 30%One-inch model 50% 70%PriceHalf-inch model $12.00 $14.00One-inch model $36.00 $32.00Variable cost per unitHalf-inch model $6.00 $6.00One-inch model $8.00 $8.00Fixed cost $35,000 $35,000Required1. Prepare a comparative contribution income statement for CI for the current year that shows…