[The following information applies to the questions displayed below.]

Donnie Hilfiger has two classes of stock authorized: $1 par preferred and $0.01 par value common. As of the beginning of 2018, 300 shares of preferred stock and 4,000 shares of common stock have been issued. The following transactions affect stockholders’ equity during 2018:

March 1 Issue 1,100 shares of common stock for $42 per share.
May 15 purchase 400 shares of treasury stock for $35 per share.
July 10 Reissue 200 shares of treasury stock purchased on May 15 for $40 per share.
October 15 Issue 200 shares of preferred stock for $45 per share.
December 1 Declare a cash dividend on both common and preferred stock of $0.50 per share to all stockholders of record on December 15. (Hint: Dividends are not paid on treasury stock.)
December 31 Pay the cash dividends declared on December 1.

Donnie Hilfiger has the following beginning balances in its stockholders’ equity accounts on January 1, 2018: Preferred Stock, $300; Common Stock, $40; Additional Paid-in Capital, $76,000; and Retained Earnings, $30,500. Net income for the year ended December 31, 2018, is $10,800.

Taking into consideration the beginning balances on January 1, 2018 and all the transactions during 2018, respond to the following for Donnie Hilfiger:

1. Prepare the stockholders’ equity section of the balance sheet as of December 31, 2018.

2. Prepare the statement of stockholders’ equity for the year ended December 31, 2018. (Amounts to be deducted should be indicated by a minus sign.)

Problem 4 (Allocation of Cash Dividends to Preference and Ordinary Shareholders)

The Company has the same capital structure (except for retained earnings) for the past five year, see details below:

6% Preference Share Capital, 80,000 shares issued and outstanding, P 50 par                       P4,000,000

Ordinary Share Capital, 200,000 shares issued and outstanding, P 30 par                                     6,000,000

Retained Earnings                                                                                                                                                              5,000,000

No dividends were paid prior to 2020 for two years. On December 10, 2020, the Company declared P 1,500,000 as cash dividends to shareholders of record of December 21, 2020, payable on January 5, 2021.

Requirements:

1. Prepare all the necessary journal entries to record the dividend transactions.
2. Allocate the dividends between ordinary shareholders and preference shareholders if:

                  Case A. Preference share capital is NON-CUMULATIVE and NON-PARTICIPATING

                  Case B. Preference share capital is CUMULATIVE and NON-PARTICIPATING

                  Case C. Preference share capital is NON-CUMULATIVE and FULLY PARTICIPATING

                  Case D. Preference share capital is NON-CUMULATIVE and PARTICIPATING UP TO ADDITIONAL 5%

3. Assuming the dividend declared is P 1,000,000 what will be the allocation of dividends if in case the preference share is CUMULATIVE and FULLY PARTICIPATING

ACCOUNTING INFORMATION SYSTEMS; DATABASE DESIGN

Premium Garden Products (PGP) supplies gardening enthusiasts and commercial garden centers throughout the northeast with a wide range of gardening equipment and products. Their wide range of inventory includes such items as tank sprayers, wheelbarrows, fertilizers, plants, and insecticides. Sales to commercial customers (garden centers) are on credit, whereas consumer sales are cash transactions (bank credit/debit cards). Sales orders are received via e-mail or phone at the Scranton, Pennsylvania, home office. In the case of commercial customers’ sales, the PGP sales clerk verifies customer credit worthiness by checking their available credit in the Customer table. The clerk then checks the availability of the product from the Inventory table and creates a record in the Sales Invoice table to record the sale. The clerk then sends a stock release notice to the distribution center nearest to the customer’s location, from where the product is shipped. Shipments are made from two distribution centers: one in Scranton and one in Maryland. Commercial customers are given net 30 terms. They make payment by check, and the open Sales Invoice is then marked paid by placing the customers check number in the “payment” field of the invoice. Sales to consumer customers are processed similarly except no credit check is per- formed and the Sales Invoice record is marked paid at the time of sale by placing the last four digits of the customer’s credit card number in the payment field.

PGP obtains its inventories from over 100 nurseries and producers of garden products throughout the United States. When inventory levels fall to their pre-determined reorder points, the computer system automatically creates a record in the Purchase Order table and sends a hard copy PO to the supplier. When products arrive at the distribution centers, the receiving clerks log onto the main office computer and create a record in the Receiving Report table. Suppliers send their invoices to the AP clerk who adds a record to the Supplier Invoice table. On the due date, the cash disbursement clerk writes a check in payment of the AP and marks the supplier invoice paid by placing the check number in the “paid” field.

REQUIRED: Design a partial relational database needed to support those aspects of PGP’s process that are outlined in the problem. Label the database tables and assign meaningful attributes to each. Assign primary keys and foreign keys as needed. Assume that invoices, purchase orders, and receiving reports may contain many items.

5) CHART - Create a 3-D pie chart showing the breakdown of total Hours Worked into total Overtime Hours and the NonOvertime hours located at the bottom of the database listing, row 37 columns E, F, G. The pie chart should show the values, the legend should indicate Overtime Hours and NonOvertime, and the chart title should be Total Daily Hours. Place this chart so that it will fill cells K1:R16. (Hint: When selecting the data for this chart remember that pie charts show parts of a whole so there’s no reason to include a total if you are displaying the parts making up that total.) [In spreadsheets, does it make sense to put totals at the bottom of the database?] 6) DATA TABLE - Create a Data Table that shows the average Daily Pay by gender for each department number. Start the criteria in cell E40 and the data table in cell E44. 7) SUBTOTALS - Create a Subtotal showing the total hours worked by department and the total overtime hours worked by gender within each department. Change to Outline View 3. [Which department works the most hours and do you see something odd about the overtime hours?] Copy the subtotal information to Sheet 2 using Copy/Paste Special Values (previously undisplayed/hidden data will appear when copied to Sheet 2). Remove the Subtotaling on Sheet 1 using the Remove All button before continuing. 8) GOAL SEEK - In cell E7, place a formula that will multiply the Overtime Rate (B3) by the Total Number of Overtime Hours. Perform a Goal Seek to determine the overtime rate necessary to achieve $400 in total overtime pay. Leave the goal seek in place so that it can be graded. 9) EXTRACT (Advanced Filter) - Sort the database by the employees' names in ascending order. Extract just the name and the department number (Dept. No.) of those who worked more than 8 hours. Start the criteria in cell A40 and the extract output in cell A44. 10) DATA TABLE – on SHEET 3 create a One-Variable Data Table that will take the ODD numbers from 1 to 55 and will show each of the following independent calculations: multiply by $6.64; divide by 3.245; add $8.23 to each number; subtract 4 from each number.

1. Data Flow Diagram

The TOPCAR taxi company is developing a new computer system to be used to support taxi booking and corporate client credit accounts. This computer system aims to automate some manual processes and cut down on labour costs as TOPCAR has many customers from large corporate companies, e.g. CEO, and managers often need taxi trips to the airport. The following describes the activities that must be processed by the computer system:

A client company must first register and open a credit account with TOPCAR at TOPCAR’s website, in which case certain credit checks are made such as checking credit history of client company’s debt level. If the client company has no bad debt history, a credit account for the client company is set up.

At least 24 hours after successful account registration, authorized persons from such client company can request a taxi booking form TOPCAR’s website. When this happens, the availability of a taxi at the requested date and time is checked, as is the credit status of the client company checked. (Note that credit status in finance means a measure of a lender’s willingness to lend money to a particular person or organization, depending on their ability to repay).

If these two checks are successful, a booking is made, and a written confirmation is sent via SMS and emailed to client company. After the customer from the client company has used the taxi, the driver sends in a record of the work, including the cost, and this is added to client company’s account. (Note that driver is an outsourced worker from TOPCAR’s point of view.) At the end of each month, taxi bills are sent via SMS and emailed to client companies for settlement.

From the above description, draw a data flow diagram showing the flow of input information (and/or data) and output information (and/or data) to and from processes and database stores within this computer system and any external environmental elements that interact with this computer system. In this diagram, you must identify the following:

1. processes inside this computer system,                      
2. database stores, external environmental elements that interact with any of the processes identified

in (a)                                                 (5.5 marks)

3. input and output information (or data) to and from each of the processes, database stores, and external environmental elements identified in (a) and (b)        (7.5 marks)

(Hint: there are two environmental elements that interact with this computer system, and six main processes in this computer system)

A client is 36 weeks’ gestation. The doctor has ordered a non-stress test to be performed. Her obstetrician provided her with no information about the test. The client is anxious and concerned about the test. How will you explain the test to her? Draw and label a reactive and draw a non-reactive NST strip.

In today’s complex business environment, organizations must deliver more than profits and value to their shareholders. Another key focus is non-financial performance. Investing in human and financial resources to develop sustainability strategies is as important. How do companies report on their non-financial performance? Is it as important as the financial metrics?

Different states and counties are in the process of relaxing non-pharmaceutical interventions (i.e. social distancing) for the COVID-19 response. Please explain how you would setup a natural experiment to measure the effectiveness of different non-pharmaceutical interventions. Please write a hypothesis and how you would test the hypothesis.

• Choose three non-current assets. Describe at least two options which could be used to allow the business to utilise them. What are the advantages and disadvantages of each option you described?

• Discuss whether businesses should buy their non-current assets outright in

answer each question sperately