Business Data Management · Quiz 2 · Jan 2025

**1. Match a categorical variable to a chart:** A bar chart places categories on one axis and their counts or other comparable numerical values on the other. Separate bars allow direct comparison among categories. **2. Distinguish neighboring chart purposes:** A line chart is the usual first choice for a time trend; pie/stacked charts emphasize parts of a whole; a scatter plot emphasizes relationships between two quantitative variables. Thus the categorical frequency distribution is the clearest use among these options. **Answer: A — display the frequency distribution of categorical data.** A: **Correct:** Bar heights or lengths directly compare category frequencies. B: **Incorrect:** A line chart is typically better suited to a continuous time trend, though bars can also compare time periods. C: **Incorrect:** Part-to-whole displays are more specifically represented by pie or stacked charts. D: **Incorrect:** A scatter plot is the usual tool for inspecting a two-variable quantitative relationship.

**1. Identify government as a participant:** Government buys goods, services and labor, so it acts as a consumer. It also supplies public services and can produce goods through public enterprises, so it acts as a producer. **2. Identify government as a moderator:** Taxes, transfers, regulation and fiscal policy influence the flows among households, firms and other sectors. This gives it a coordinating/regulating role as well as direct economic participation. **3. Combine the roles:** Both descriptions in A and B apply; C is the most complete answer. **Answer: C — both producer/consumer and moderator/participant.** A: **Incorrect:** These are real roles, but this option omits the additional moderator/participant description. B: **Incorrect:** These are also real roles, but this option alone omits the producer/consumer description. C: **Correct:** This combines all the roles described in the preceding two options. D: **Incorrect:** Government participates in the circular flow and affects other participants, so “None” is false.

**1. Use the income-demand relationship:** An inferior good has lower quantity demanded when consumer income increases, holding prices and other relevant conditions constant. Its income elasticity of demand is negative: \(E_Y=(\%\Delta Q_d)/(\%\Delta Y)<0\). **2. Interpret the term correctly:** “Inferior” describes the economic income response, not a necessary judgment about physical quality. As purchasing power rises, consumers may substitute away from that good toward alternatives. **3. Contrast with normal/luxury goods:** Normal goods have positive income elasticity; luxury goods usually have income elasticity above one. Neither matches a decline in demand as income rises. **Answer: B — Inferior Good.** A: **Incorrect:** A superior/normal good does not have the negative income response asked about. B: **Correct:** Negative income elasticity is the defining feature of an inferior good. C: **Incorrect:** Luxury demand generally rises more than proportionately with income. D: **Incorrect:** Supply Good is not the standard category defined by this income-demand relationship.

**1. Apply both conditions to the same row:** The relevant columns are B for Exceeded Q1 quota and C for Exceeded Q2 quota. A person must have Yes in both columns, so the conditions are joined with AND. **2. Select the multi-condition counting function:** COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes") tests corresponding rows in the two equally sized ranges and counts rows satisfying both criteria. **3. Check the displayed people:** Kent is Yes/No and fails; Wayne is Yes/Yes and passes; Oliver is Yes/Yes and passes; Allen is No/Yes and fails. The result is 2 salespeople. **Answer: B — COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes"), returning 2.** A: **Incorrect:** COUNT counts numeric arguments/cells; it does not implement paired range-criteria conditions, and these ranges are mismatched. B: **Correct:** COUNTIFS evaluates both Yes criteria row by row and counts Wayne and Oliver. C: **Incorrect:** COUNTIF accepts one range and criterion, not the multiple pairs shown here. D: **Incorrect:** COUNTA counts nonempty values, not rows satisfying both quota tests; it also uses the wrong columns.

**1. Parse the four VLOOKUP arguments:** A1 is the lookup value, B1:C10 is the lookup table, 2 is col_index_num, and FALSE requests an exact match. **2. Locate the search and return columns:** VLOOKUP searches the first column of its table array, which is worksheet column B. A column index of 2 returns the value from the table’s second column, worksheet column C, in the matching row. **3. Avoid an absolute-column interpretation:** The index counts from the left edge of the specified table array; it is not the worksheet’s column number, a row number or a requested match count. **Answer: B — the column within the table array from which to return a value.** A: **Incorrect:** The search occurs in the table array’s first column regardless of this return-column index. B: **Correct:** 2 selects the second column of B1:C10, namely column C, for the returned value. C: **Incorrect:** VLOOKUP does not use this argument to request multiple matches. D: **Incorrect:** The argument identifies a return column rather than a starting row.

**1. Identify bin-based grouping:** A histogram divides a numerical variable’s range into intervals called bins, counts observations in each interval and displays those frequencies as adjacent bars. **2. Distinguish other displays:** Scatter and bubble plots use coordinates to show relationships between observations/variables. A box plot summarizes median, quartiles and potential outliers rather than displaying counts for consecutive bins. **Answer: C — Histogram.** A: **Incorrect:** A scatter plot does not group values into frequency bins. B: **Incorrect:** A bubble chart adds a size encoding to a coordinate plot rather than displaying a binned distribution. C: **Correct:** Binning and counting numerical observations is precisely a histogram’s purpose. D: **Incorrect:** A box plot summarizes quantiles and spread rather than bin frequencies.

**1. Expand the commercial term:** SOR means Sale or Return. Under such an arrangement, goods are supplied on terms allowing the receiving party to return unsold/unaccepted goods according to the agreed contract. **2. Connect the name to the arrangement:** The defining alternative is a completed sale or an allowed return, not a resource count or a routine-sales measure. **Answer: B — Sale or Return.** **Convention note:** Specific ownership, payment and return rights depend on the contract; this question asks only for the expansion of the abbreviation. A: **Incorrect:** Sales of Resource is not the standard expansion of SOR in this context. B: **Correct:** Sale or Return is the standard term for the stated commercial arrangement. C: **Incorrect:** Sales of Return is not the conventional term. D: **Incorrect:** Sales on Regular is not the standard expansion.

**1. Define the segmentation difference:** A niche market serves a narrow, identifiable customer segment with particular preferences or specialized needs. A mass market aims at a much broader audience with widely shared needs. **2. Separate targeting from price:** A niche offer need not always be expensive, and mass-market products need not always be cheap. The main distinction is the breadth and specificity of the target group. **3. Match the marketing implications:** Niche marketing often uses focused channels to reach the relevant segment. Broad campaigns are more characteristic of mass marketing, so the alternatives that reverse audience breadth and targeting are incorrect. **Answer: A — A — specialized narrow customer segment versus a broad general market.** A: **Correct:** This correctly contrasts a specialized narrow segment with a broad general audience. B: **Incorrect:** This reverses the audience breadth and incorrectly treats low/high pricing as the defining distinction. C: **Incorrect:** This reverses the usual relationship between broad campaigns and focused targeting. D: **Incorrect:** Standardized broad appeal is associated with mass marketing rather than the niche definition stated here.

**1. Calculate availability:** Planned time is 400 hours and lost time is 30 hours, so operating time is 370 hours. Availability is \(A=(400-30)/400=0.925\). **2. Calculate the supplied speed-performance ratio:** Actual assembly speed is 160 per hour and design speed is 180 per hour, so \(P=160/180=8/9\approx0.88889\). **3. Calculate quality:** Of 8000 assembled units, 320 are defective. Good units are 7680, giving \(Q=(8000-320)/8000=0.96\). **4. Multiply the three factors and round:** \[OEE=A\cdot P\cdot Q=0.925\cdot\frac{160}{180}\cdot0.96=0.789333\ldots.\] The requested two-decimal fraction is 0.79, equivalent to approximately 78.93%. **Answer: 0.79.** **Convention note:** This uses the separately supplied actual/design speed ratio as the performance factor. The total-unit count is not numerically consistent with sustaining 160 units/hour for all 370 operating hours. If total output were instead used to derive monthly performance, a different OEE would result; the supplied key follows the three explicit factor inputs above.

**1. Calculate expected usage during replenishment:** Daily use is 5 units and lead time is 10 days, so demand while waiting is \(5\cdot10=50\) units. **2. Add the safety buffer:** The reorder point is \(Daily\ Usage\times Lead\ Time+Safety\ Stock=50+20=70\) units. Ordering at 70 leaves 20 units after the expected 50-unit lead-time consumption. **Answer: A — reorder when inventory reaches 70 units.** A: **Correct:** 70 combines expected lead-time use of 50 with safety stock 20. B: **Incorrect:** 50 covers lead-time demand but omits the safety stock. C: **Incorrect:** 30 is the amount consumed before the reorder point is reached, not the reorder inventory level. D: **Incorrect:** 15 is below even the safety-stock buffer and is too late under these assumptions.

**1. Calculate expected usage during replenishment:** Daily use is 5 units and lead time is 10 days, so demand while waiting is \(5\cdot10=50\) units. **2. Add the safety buffer:** The reorder point is \(Daily\ Usage\times Lead\ Time+Safety\ Stock=50+20=70\) units. Ordering at 70 leaves 20 units after the expected 50-unit lead-time consumption. **3. Determine how long initial stock lasts before that trigger:** Starting inventory is 100, so \(100-70=30\) units are consumed before reordering. At 5 units per day this takes \(30/5=6\) days. **4. Check the projected replenishment moment:** The order placed after day 6 arrives 10 days later. Expected remaining stock is \(100-5(6+10)=20\), matching the safety-stock target. **Answer: 6.** **Convention note:** This assumes constant daily usage, fixed lead time, no earlier outstanding order and continuous monitoring. The trigger is after six complete days of the stated consumption.

**1. Estimate daily sales consistently:** Using the table’s average monthly unit sales and a common 30-day month, estimated days of inventory are \(Opening\ Stock/(Average\ Monthly\ Sales/30)\). A common month-length factor does not affect the ranking. **2. Calculate the four candidate coverages:** LAP002 gives \(250/105\cdot30\approx71.43\) days; LAP003 gives \(190/75\cdot30=76\) days; LAP006 gives \(50/22.5\cdot30\approx66.67\) days; LAP007 gives \(40/17.5\cdot30\approx68.57\) days. **3. Check the remaining SKUs if ranking the full table:** LAP001 is about 53.8 days, LAP004 about 62.73 days and LAP005 about 63.33 days. Therefore LAP003 has the highest estimated coverage in the complete table as well. **Answer: B — LAP003.** **Convention note:** This is an opening-stock coverage calculation using the supplied unit sales. A financial-accounting days-in-inventory ratio based on average inventory cost and COGS would require additional data not present in the table. A: **Incorrect:** About 71.43 days is below LAP003’s 76 days. B: **Correct:** 190 units at 75 monthly sales give the highest coverage, 76 days under a 30-day convention. C: **Incorrect:** Its coverage is approximately 66.67 days. D: **Incorrect:** Its coverage is approximately 68.57 days.

**1. Add LAP005’s six monthly unit sales:** The row gives 20,30,40,50,60,70 units, totaling \(20+30+40+50+60+70=270\) units. The average 45 is per month, not the total sold. **2. Calculate total sales revenue:** Unit selling price is 1499 in the table’s dollar units, so six-month revenue is \(270\cdot1499=404730\). **3. Apply the profit margin:** A 10% margin on sales gives \(Profit=0.10\cdot404730=40473\). No additional cost calculation is needed because profit margin is specified directly. **Answer: D — 40473.** **Convention note:** Margin is interpreted as profit divided by selling revenue, not a 10% markup on cost. The question’s answer choices omit currency symbols; the unit-price table uses dollars. A: **Incorrect:** This does not equal 10% of the actual LAP005 revenue. B: **Incorrect:** This does not follow from the 270 units and price 1499. C: **Incorrect:** This is not the result of the stated revenue-margin calculation. D: **Correct:** 270×1499×0.10 equals 40473 exactly.