Rainbow Legacy Ltd Has the Following Balances at 31^st December

question 79

Multiple Choice

Rainbow Legacy Ltd has the following balances at 31^st December 2019: Cash $46,000; accounts receivable $34,000 ($10,000 from November and $24,000 from December) ; merchandise inventory $40,000; and accounts payable $20,000 (for merchandise purchases only) . Budgeted sales follow:
$$\begin{array} { l l } \text { January } & \$ 100,000 \\\text { February } & \$ 180,000 \\\text { March } & \$ 120,000 \\\text { April } & \$ 200,000\end{array}$$ Other data:
-Sales are 40% cash, 50% collected during the following month, and 10% collected during the second month after sale. A 3% cash discount is given on cash sales
-Cost of goods sold is 40% of sales
-Ending inventory must be 150% of the next month's cost of sales
-Purchases are paid 70% in month of purchase and 30% in the following month
-The selling and administrative cost function is: $6,000 + $0.2 × sales. This includes $1,000 for depreciation
-All costs are paid in the month incurred
-Minimum cash balance requirement is $6,000
Cash receipts for April will be:

• A) $77,600
• B) $77,800
• C) $155,600
• D) $78,000

---

Definitions:

Data Staging

The process of preparing and organizing data for further analysis or processing, often involving cleansing, transformation, and storage steps in a dedicated area or platform.

Expert System

A system that tries to replicate the decision-making processes of human experts in order to solve specific problems.

Data Mart

A subset of a data warehouse, focused on a specific business line or team, containing data relevant for a specific group of users.

Artificial Intelligence

The replication of human thought processes and behaviors in machines programmed to emulate human actions and thinking.