Use the Data Given Below to Answer the Following Questions)

question 21

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}$$
-Given that D = a-bP, where D, is demand, "a" and "b," are linear constants, and P, is price, from the below spreadsheet, how will the formula in B9 be represented in Excel using relative addressing?

• A) B4-B5*A9
• B) C5-C6*A10
• C) B4-B5*A10
• D) B5-B6*A10

---

Definitions:

Functional Specialization

The practice of organizing a workforce where each member or department focuses on a specific set of tasks or expertise, promoting efficiency.

Divisional Departmentation

An organizational structure where divisions are formed based on products, services, markets, or geographic locations.

Matrix Departmentation

Is a combination of functional and divisional patterns wherein an individual is assigned to more than one type of unit.

Total Quality Management

An ongoing process of improvement involving all members of an organization to enhance quality and meet or exceed customer expectations.