On January 1, 2016, Aspen Company acquired 80 percent of Birch Company's voting stock for $424,000. Birch reported a $425,000 book value and the fair value of the noncontrolling interest was $106,000 on that date. Then, on January 1, 2017, Birch acquired 80 percent of Cedar Company for $232,000 when Cedar had a $218,000 book value and the 20 percent noncontrolling interest was valued at $58,000. In each acquisition, the subsidiary's excess acquisition-date fair over book value was assigned to a trade name with a 30-year remaining life.

These companies report the following financial information. Investment income figures are not included.   

Assume that each of the following questions is independent:

If all companies use the equity method for internal reporting purposes, what is the December 31, 2017, balance in Aspen's Investment in Birch Company account?

What is the consolidated net income for this business combination for 2018?

What is the net income attributable to the noncontrolling interest in 2018?

Assume that Birch made intra-entity inventory transfers to Aspen that have resulted in the following intra-entity gross profits in inventory at the end of each year:

What is the accrual-based net income of Birch in 2017 and 2018, respectively?

On January 1, 2016, Aspen Company acquired 80 percent of Birch Company's voting stock for $460,000. Birch reported a $470,000 book value and the fair value of the noncontrolling interest was $115,000 on that date. Then, on January 1, 2017, Birch acquired 80 percent of Cedar Company for $164,000 when Cedar had a $124,000 book value and the 20 percent noncontrolling interest was valued at $41,000. In each acquisition, the subsidiary's excess acquisition-date fair over book value was assigned to a trade name with a 30-year remaining life.

These companies report the following financial information. Investment income figures are not included.   

Assume that each of the following questions is independent:

1. If all companies use the equity method for internal reporting purposes, what is the December 31, 2017, balance in Aspen's Investment in Birch Company account?

2. What is the consolidated net income for this business combination for 2018?

3. What is the net income attributable to the noncontrolling interest in 2018?

4. Assume that Birch made intra-entity inventory transfers to Aspen that have resulted in the following intra-entity gross profits in inventory at the end of each year:

What is the accrual-based net income of Birch in 2017 and 2018, respectively?

On January 1, 2016, Aspen Company acquired 80 percent of Birch Company’s voting stock for $288,000. Birch reported a $300,000 book value, and the fair value of the noncontrolling interest was $72,000 on that date. Then, on January 1, 2017, Birch acquired 80 percent of Cedar Company for $104,000 when Cedar had a $100,000 book value and the 20 percent noncontrolling interest was valued at $26,000. In each acquisition, the subsidiary’s excess acquisition-date fair over book value was assigned to a trade name with a 30-year remaining life.

These companies report the following financial information. Investment income figures are not included.

Assume that each of the following questions is independent:

If all companies use the equity method for internal reporting purposes, what is the December 31, 2017, balance in Aspen’s Investment in Birch Company account?

What is the consolidated net income for this business combination for 2018?

What is the net income attributable to the noncontrolling interest in 2018?

Assume that Birch made intra-entity inventory transfers to Aspen that have resulted in the following intra-entity gross profits in inventory at the end of each year:

What is the accrual-based net income of Birch in 2017 and 2018, respectively?

You are the CSCO for Swashbuckler Enterprises (SE). You CEO just left your office and she is not happy. She thinks all the SCM department does is spend, spend, spend and never creates value for the firm. Furthermore, she holds up the Marketing department as the primary source of revenue and hence, customer effectiveness. In order to exonerate the SCM department and ultimately, your own name, you have decided to run the numbers on your most recently concluded negotiation (Q4 of 2016) to show once and for all how SCM can create value. In this negotiation, you were able to get your supply base to reduce the COGS by 8%. Assignment: Using the numbers below in Table 1, answer the questions below. Table 1 Earnings and Expenses for Q4. 2016: Pre-negotiation Sales $9,250,000 Cost of Goods Sold $8,500,000 Profit $750,000 1. What is the new COGS after the 8% negotiated reduction? 2. What is the resulting new profit? 3. What is the difference between the old and new profit, both in terms of dollar amount and percentage? 4. What is the resulting new contribution to profit, per dollar of sales? 5. How much does the Marketing department need to increase sales in order to match the same increase in profit? NOTE: Round your answers up Your SCM department has been able to negotiate an additional 4% reduction in the COGS. Using the sales figure from Table 1 and your answers to questions 1-3, answer the following. 6. Using your answers to questions 1-3 as the base, what is the resulting new increase in profit because of the additional 4% reduction in COGS? 7. How much does the Marketing department need to increase sales in order to match the new increase in profit? Give step by step instructions.

Write a simple phonebook using c++ that read text file name list.txt and has:  first name, last name, and phone number as the example:

MIKEL BUETTNER 3545044
ENOCH BUGG 2856220
BRENDON LAVALLEY 433312
QUINTIN CREEK 5200413
JAMISON MILLETT 6243458
FLORENCIO PUMPHREY 3296862
DARRICK FREGOSO 6868442
TOBIAS GLASSMAN 6040564

and then ask the user to add a new contact first name, last name, and phone number and same the information into a file.

Use array and pointer

In Python, write a function called user_name that takes two arguments, first_name and last_name and creates a “user name” consisting of the first three letters of the first name concatenated with the first three letters of the last name.   You can assume ach name is at least three letters long.

Return the new user name.   

your results should yield something like these test cases.

>>> print(user_name("bob", "taft"))

bobtaf

>>>

>>> print(user_name("Ralph", "Waldo"))

RalWal

>>>

Add more methods to SmartPhone.

• hasPhoneNumber: return true if the phone number has been initialized
• getAreaCode: returns the area code of the phone number
• getPrefix: returns the prefix of the phone number
• getLineNumber: returns the line number of the phone number.

Given Files:

public class Phone
{
    protected String name;
    protected long number;

    public Phone() {
        this("None", -1);
    }

    public Phone(String name) {
        this(name, -1);
    }

    public Phone(String name, long number) {
        this.name = name;
        this.number = number;
    }

    public String getName() {
        return name;
    }

    public long getNumber() {
        return number;
    }
}

And:

public class Demo3 {

    public static void test(SmartPhone f)
    {
        System.out.print(f);
        if (f.hasPhoneNumber()) {
            System.out.println("Area code: " + f.getAreaCode());
            System.out.println("Prefix: " + f.getPrefix());
            System.out.println("Line number: " + f.getLineNumber());
        }
        System.out.println();
    }

    public static void main(String[] args) {
        SmartPhone test1 = new SmartPhone("Bret", "1234567890");
        SmartPhone test2 = new SmartPhone("Alice", "8059226966", "[email protected]");
        SmartPhone test3 = new SmartPhone();
        test(test1);
        test(test2);
        test(test3);
    }

}

And:

public class SmartPhone extends Phone
{
    private String email;
    private String phone;
    private String phone2;

    public SmartPhone()
    {
        super("None",-1);
        phone = "Not set";
        email = "None";
        phone2 = "Not set";
    }

    public SmartPhone(String name, String phone)
    {
        super(name, Long.parseLong(phone));
        this.phone = phone;
        this.email = "None";
    }

    public SmartPhone(String name, String phone, String email)
    {
        super(name, Long.parseLong(phone));
        this.email = email;
        this.phone = phone;
    }

    public String toString()
    {
        return "Name: " + name + "\n" +
                "Phone: " + phone + "\n" +
                "Email: " + email + "\n";
    }
}

////////////////////////////////////////// Output //////////////////////////////////////////

Name: Bret\n
Phone: 1234567890\n
Email: None\n
Area code: 123\n
Prefix: 456\n
Line number: 7890\n
\n
Name: Alice\n
Phone: 8059226966\n
Email: [email protected]\n
Area code: 805\n
Prefix: 922\n
Line number: 6966\n
\n
Name: None\n
Phone: Not set\n
Email: None\n
\n

Colonial Adventure Tours Case

• The owner of Colonial Adventure Tours knows that being able to run queries is one of the most important benefits of using a DBMS. In the following exercises, you will use the data in the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1. (If you use a computer to complete these exercises, use a copy of the Colonial Adventure Tours database so you will still have the original data when you complete Chapter 3 exercises.) In each step, use QBE to obtain the desired results. You can use the query feature in a DBMS to complete the exercises using a computer, or you can simply write a description of how you would complete the task. Check with your instructor if you are uncertain about which approach to take.
• Save the file on your computer with your last name in the file name. (Example: case_1-1 _Jones.doc)
• Click the Choose File button to find and select your saved document.

1. List the name of each trip that does not start in New Hampshire (NH).
2. List the name and start location for each trip that has the type Biking.
3. List the name of each trip that has the type Hiking and that has a distance greater than six miles.
4. List the name of each trip that has the type Paddling or that is located in Vermont (VT).
5. How many trips have a type of Hiking or Biking?
6. List the trip name, type, and maximum group size for all trips that have Susan Kiley as a guide.
7. List the trip name and state for each trip that occurs during the Summer season. Sort the results by trip name within state.
8. List the name of each trip that has the type Hiking and that is guided by Rita Boyers.
9. How many trips originate in each state?
10. How many reservations include a trip with a price that is greater than $20 but less than $75?
11. List the reservation ID, customer last name, and the trip name for all reservations where the number of persons included in the reservation is greater than four.
12. List the trip name, the guide’s first name, and the guide’s last name for all trips that originate in New Hampshire (NH). Sort the results by guide’s last name within trip name.
13. List the reservation ID, customer number, customer last name, and customer first name for all trips that occur in July 2018.
14. Colonial Adventure Tours calculates the total price of a trip by adding the trip price plus other fees and multiplying the result by the number of persons included in the reservation. List the reservation ID, trip name, customer’s last name, customer’s first name, and total cost for all trips where the number of persons is greater than four.
15. Create a new table named Hiking that includes all columns in the Reservation table where the trip type is Hiking.
16. Use an update query to change the OtherFees value in the Hiking table to $5.00 for all records on which the OtherFees value is $0.00.
17. Use a delete query to delete all trips in the Hiking table where the trip date is 6/12/2018.
18. One of the reservations agents at Colonial Adventure Tours created the query shown in Figure 2-49 to list each trip name and the last name and first name of each corresponding guide. The query results included 410 records, and he knows that this result is incorrect. Why did he get so many records? What should he change in the query design to get the correct query results?

C++ Question

4. Formulate the following conditions

• A last name starts with the letter H.

• A last name starts with the letters Mac.

• A last name comes before "Jones".

An auditor discovered an error while conducting Black Inc.'s 2016 audit. No errors were corrected during 2015.

A 2 year insurance policy was purchased on April 30, 2015. This policy resulted in $24,000 being debited to Prepaid Insurance [On April 30, 2015]. However, no adjustmnet was made on December 31, 2015 or on December 31, 2016.

Required:

Prepare the appropriate journal entries. Assume the 2016 books have not been closed but the tax entries have been completed. The tax rate for all years is 40%. Apply US GAAP.

Make sure to record the appropriate entries regarding taxes.