Use the Data Given Below to Answer the Following Questions)

question 46

Multiple Choice

Use the data given below to answer the following questions)
Below is the spreadsheet for demand prediction of a company that sells chocolates. $$\begin{array} { | l | l | l | l | } \hline & \text { A } & \text { B } & C \\\hline 1 & \text { Demand Predictim } & & \\& \text { Models } & & \\\hline 2 & & & \\\hline 3 & \text { Linear Model } & & \\\hline 4 & \text { A } & 10,000 & \\\hline 5 & B & 10 & \\\hline 6 & & & \\\hline 7 & \text { Price } & \text { Demand } & \\\hline 8 & \$ 50 & 9,500 & \\\hline 9 & \$ 55 & 9,450 & \\\hline 10 & \$ 45 & 9,550 & \\\hline 11 & & & \\\hline\end{array}$$
-If, in the spreadsheet, cells B9 and B10 were empty, which of the following formulas should be entered in B8 so that the formula can be dragged to B9 and B10 to obtain their correct values?

• A) B4-B5*A8
• B) B4-B5*$A8
• C) $B4-B5*$A8
• D) $B$4-$B$5*$A8

---

Definitions:

Equity Theory

A theory in social psychology and organizational behavior that explains how individuals perceive fairness in distribution of resources within interpersonal relationships, leading to feelings of satisfaction or dissatisfaction.

Input to Outcome

The relationship or correlation between contributed resources or efforts (inputs) and the results or achievements (outcomes).

Fairness of Rewards

The perceived equity and justice of the distribution of outcomes and rewards among individuals or groups, influencing their satisfaction and motivation.

Perceived Inequity

The feeling of being unfairly treated when comparing one's own effort-reward ratio to the effort-reward ratio of others.