Please design a data warehouse using star schema or snowflake schema that solves a specific business intelligence task that you come up with. Only one fact table is needed. You will need to include 1) a problem statement (i. e. what is the purpose this warehouse is serving) 2) an ER diagram describing the designed schema 3) justification for your fact table and dimensions. You can include all components in a word document. Some tasks you can consider: analyzing sales, analyzing hospitalized patients, analyzing student performances, etc.

Dollywood corporation accumulates the following data concerning a mixed cost, using miles as the activity level. miles driven total cost january 10,000 $16,500 february 8,000 $14,500 march 9,000 $12,500 april 7,000 $12,000 compute the variable and fixed cost elements using the high-low method

Balance sheet the assets of dallas & associates consist entirely of current assets and net plant and equipment. the firm has total assets of $2 5 million and net plant and equipment equals $2 million. it has notes payable of $150,000, long-term debt of $750,000, and total common equity of $1 5 million. the firm does have accounts payable and accruals on its balance sheet. the firm only finances with debt and common equity, so it has no preferred stock on its balance sheet. a. what is the company's total debt? b. what is the amount of total liabilities and equity that appears on the firm's balance sheet? c. what is the balance of current assets on the firm's balance sheet? d. what is the balance of current liabilities on the firm's balance sheet? e. what is the amount of accounts payable and accruals on its balance sheet? [hint: consider this as a single line item on the firm's balance sheet.] f. what is the firm's net working capital? g. what is the firm's net operating working capital? h. what is the explanation for the difference in your answers to parts f and g?

Suppose that: 1. malaysia requires 1 hour of labor to produce 1 pound of rice and 2 hours of labor to produce 1 pencil; 2. indonesia requires 2 hours of labor to produce 1 pound of rice and 4 hours of labor to produce 1 pencil; 3. each country has 10,000 hours of labor to allocate between the production of rice and pencils; and 4. in autarky, malaysia consumes 5,000 pounds of rice and 2,500 pencils. which country has an absolute advantage in rice production? in pencil production? which country has a comparative advantage in rice production? in pencil production? will trade between the two countries be mutually beneficial?