Questions
The following information was taken from Lamberson Company's accounting records: Account Balances Account Titles January 1,...

The following information was taken from Lamberson Company's accounting records:

Account Balances
Account Titles January 1,
2016
December 31,
2016
Debits
Cash $ 1,400 $ 2,400
Accounts Receivable (net) 2,800 2,690
Marketable Securities (at cost) 1,700 3,000
Allowance for Change in Value 500 800
Inventories 8,100 7,910
Prepaid Items 1,300 1,710
Investments (long-term) 7,000 5,400
Land 15,000 15,000
Buildings and Equipment 32,000 46,200
Discount on Bonds Payable 290
$69,800 $85,400
Credits
Accumulated Depreciation $16,000 $16,400
Accounts Payable 3,800 4,150
Income Taxes Payable 2,400 2,504
Wages Payable 1,100 650
Interest Payable 400
Note Payable (long-term) 3,500
12% Bonds Payable 10,000
Deferred Taxes Payable 800 1,196
Convertible Preferred Stock, $100 par 9,000
Common Stock, $10 par 14,000 21,500
Additional Paid-in Capital 8,700 13,700
Unrealized Increase in Value of Marketable Securities 500 800
Retained Earnings 10,000 14,100
$69,800 $85,400

Additional information for the year:

  1. Sales $ 39,930
    Cost of goods sold (19,890)
    Depreciation expense (2,100)
    Wages expense (11,000)
    Other operating expenses (1,000)
    Bond interest expense (410)
    Dividend revenue 820
    Gain on sale of investments 700
    Loss on sale of equipment (200)
    Income tax expense (2,050)
    Net income $ 4,800
  2. Dividends declared and paid totaled $700.
  3. On January 1, 2016, convertible preferred stock that had originally been issued at par value were converted into 500 shares of common stock. The book value method was used to account for the conversion.
  4. Long-term nonmarketable investments that cost $1,600 were sold for $2,300.
  5. The long-term note payable was paid by issuing 250 shares of common stock at the beginning of the year.
  6. Equipment with a cost of $2,000 and a book value of $300 was sold for $100. The company uses one Accumulated Depreciation account for all depreciable assets.
  7. Equipment was purchased at a cost of $16,200.
  8. The 12% bonds payable were issued on August 31, 2016, at 97. They mature on August 31, 2026. The company uses the straight-line method to amortize the discount.
  9. Taxable income was less than pretax accounting income, resulting in a $396 increase in deferred taxes payable.
  10. Short-term marketable securities were purchased at a cost of $1,300. The portfolio was increased by $300 to a $3,800 fair value at year-end by adjusting the related allowance account.

Required

  1. Prepare a spreadsheet to support Lamberson Company's 2016 statement of cash flows. Use the minus sign to indicate cash outflows, a decrease in cash or cash payments.
    LAMBERSON COMPANY
    Cash Flows Worksheet
    For Year Ended December 31, 2016
    Balances Worksheet Entries
    Account Titles 01/01/2016 12/31/2016 Change Debit Credit
    Debits
    Cash 1,400 2,400
    Noncash Accounts:
    Accounts Receivable 2,800 2,690
    Marketable Securities 1,700 3,000
    Allow for Change in Value 500 800
    Inventories 8,100 7,910
    Prepaid Items 1,300 1,710
    Investments (long-term) 7,000 5,400
    Land 15,000 15,000
    Buildings and Equipment 32,000 46,200
    Discount on Bonds Payable 290
    Totals 69,800 85,400
    Credits
    Accumulated Depreciation 16,000 16,400
    Accounts Payable 3,800 4,150
    Income taxes Payable 2,400 2,504
    Wages Payable 1,100 650
    Interest Payable 400
    Notes Payable (long-term) 3,500
    12% Bonds Payable 10,000
    Deferred Income Taxes 800 1,196
    Convertible Preferred Stock 9,000
    Common Stock, $10 par 14,000 21,500
    Additional Paid-in Capital 8,700 13,700
    Unrealized Increase in Value of Marketable Securities 500 800
    Retained Earnings 10,000 14,100
    Totals 69,800 85,400
    Worksheet Entries
    Debit Credit
    Cash Flows from Operating Activities:
    Net income
    Add: Depreciation expense
    Add: Loss from sale of building
    Cash Flows from Investing Activities:
    Cash Flows from Financing Activities:
    Investing and Financing Activities Not Affecting Cash:
    Totals
  2. Prepare the statement of cash flows.

    LAMBERSON COMPANY
    Statement of Cash Flows
    For Year Ended December 31, 2016
    Operating Activities:
    Adjustment for noncash income items:
    Adjustments for cash flow effects from working capital items:
    Net cash provided by operating activities
    Investing Activities:
    Net cash used for investing activities
    Financing Activities:
    Net cash provided by financing activities
    Cash, January 1, 2016
    Cash, December 31, 2016
  3. Compute the cash flow from operations to sales ratio and the profit margin ratio for 2016. Round your answers to one decimal place.
    1. Cash flows from operations ratio :
    2. Profit margin:

In: Accounting

having trouble with loop, when I added saving and loading to my code, when adding new...

having trouble with loop, when I added saving and loading to my code, when adding new player, it continues to ask for new player

class TeamClass:
    name = ""
    jersey = ""
    number = ""

    def __init__(self, name, jersey, number):
        self.name = name
        self.number = number
        self.jersey = jersey

    def set_name(self, name):
        self.name = name

    def set_jersey(self, jersey):
        self.jersey = jersey

    def set_number(self, number):
        self.number = number

    def get_name(self, name):
        return self.name

    def get_jersey(self, jersey):
        return self.jersey

    def get_number(self, number):
        return self.number

    def display_team_roster(self):
        print("Player")
        print("Name: ", self.name)
        print("Jersey: ", self.jersey)
        print("Phone Number: ", self.number)
        print("-------------")


def menu():
    print("-----Roster Menu----")
    print("1. Display Team Roster")
    print('2. New Player')
    print("3. Remove player")
    print("4. Edit Player")
    print("5. Save Roster Menu")
    print("6. Load Roster Menu")
    print("7. Exit Roster Menu")
    print("")
    selection = int(input("Enter an option or 7 to exit: "))
    return selection


def display_roster(roster):
    if len(roster) > 0:
        for x in roster.keys():
            roster[x].display_team_roster()
    else:
        print("Roster is empty")


def add_member(roster):
    new_member = input("Enter new Player: ")
    new_jersey = input("Enter jersey#: ")
    new_number = input("Enter phone number: ")
    roster[new_member] = TeamClass(new_member, new_jersey, new_number)


def del_member(roster):
    del_member = input("Which player would you like to remove?: ")
    if del_member in roster:
        del roster[del_member]
        print(del_member, "has been removed")
    else:
        print(del_member, "was not found")
    return roster


def edit_member(roster):
    existing_member = input("Which player would you like to edit? ")
    if existing_member in roster:
        new_member = input("Enter new players name: ")
        new_jersey = input("Enter new jersey#: ")
        new_number = input("Enter new phone number: ")
        roster[existing_member] = TeamClass(new_member, new_jersey, new_number)
        print(existing_member, "has been changed to", new_jersey, new_number)
    else:
        print(existing_member, "was not found")
    return roster


def save_member(roster):
    filename = input("week1.py\teamroster.txt:")
    print("Saving Roster")
    outfile = open(teamroster.txt,"wt")
    for x in roster.keys():
        name = roster[x].get_name()
        jersey = roster[x].get_jersey()
        number = roster[x].get_number()
        outfile.write(name+", "+jersey+", "+number+"\n")
    print("Roster saved")
    outfile.close()


def load_member():
    roster = {}
    filename = input("week1.py\teamroster.txt:")
    inFile = open(teamroster.txt,"rt")
    print("Loading Roster ")
    while True:
        inLine = inFile.readline()
        if not inLine:
            break
        inLine = inLine[:-1]
        name, jersey, number = inLine.split(",")
        roster[name] = TeamClass(name,jersey,number)
    print("Data Loaded Successfully.")
    inFile.close()
    return roster


print("")
roster = {}
menu_selection = menu()

while menu_selection != 7:
    if menu_selection == 1:
        display_roster(roster)
    elif menu_selection == 2:
        add_member(roster)
    elif menu_selection == 3:
        roster = del_member(roster)
    elif menu_selection == 4:
        roster = edit_member(roster)
    elif menu_selection == 5:
        roster = save_member(roster)
    elif menu_selection == 6:
        roster = load_member(roster)
menu_selection = menu()
print("Good Bye")

  

In: Computer Science

PLEASE READ ALL OF THESE INSTRUCTIONS BEFORE BEGINNING THIS ASSIGNMENT. For this assignment, you need to...

PLEASE READ ALL OF THESE INSTRUCTIONS BEFORE BEGINNING THIS ASSIGNMENT. For this assignment, you need to analyze the information below from BOTH the management AND the employee perspective. This information pertains to a labor union in a simulated/made up/not real firm in Glen Ellyn. The first part of your information relates to Management – the second part relates to the Labor Union employees. I have provided you with information from the last union negotiations at the plant in 2016. It is now time to begin preparing for negotiations for 2020 and beyond. The third part of this assignment is your analyzing what you have gained from this assignment.

Your assignment needs to include the following information:

  • Part One:
    • Considerations for Management as they begin to prepare for negotiations
    • Beginning offer to the plant workers - This means if you were management for this firm, what would your initial/first offer be to the labor union employees in each of the categories below.
  • Part Two:
    • Considerations for Labor Union employees as they begin to prepare for negotiations
    • Beginning offer to management - This means if you were the employees in the union, what would your initial/first offer be to the management of the firm in each of the categories below.
  • Part Three:
    • Analysis of what you have gained from this assignment and insights you now have into labor union negotiations. Understand that negotiations go on and on sometimes for years. But each set of contract negotiations has to begin somewhere - and this is what I'm having you look at in this assignment. First offers don't include what you really want - it's your starting point.

Format this assignment using the section headings noted as you see below with “Management” and the “CPFac Workers Labor Union”. Be very clear about the information required above.

Management –

Put yourself in the role of President and Owner of Cooper Plastics Corp. located in Glen Ellyn, Illinois. Cooper manufactures plastic cups, plates, silverware, bowls, etc.

There is a union, CPFacWorkers, representing the 95 factory workers at Cooper Plastics.

It is time for the management team at Cooper to once again negotiate with the CPFacWorkers.

Your negotiations document needs to include the following for BOTH Management and the Union - you must include these categories for both offers:

  • Length of the next contract in years - Labor contracts are frequently 2-4 years in length
  • Base pay
  • Annual pay increases for each year of your labor contract
  • Shift pay differential
  • Overtime pay
  • Number of workers per shift
  • Benefits percentage of salaries
  • Annual paid sick days
  • Annual paid holidays
  • Total increased costs - calculate how much your increases are going to cost you - you need to provide me a total of costs and how you arrived at that number
  • Source of money for increased costs - where is the money coming from for these increased costs - this is obviously an assumption based on the information you have

Data from Current Contract, which expires in September 2020:

  • Contract began in March 2016
  • CPFacWorkers conceded to 20 layoffs when negotiating the 2016-2020 contract
  • Remaining workers agreed to a 10% pay cut to help the company continue to recover from the recent US recession
  • Sick days were reduced from 10 to 6
  • Holidays reduced from 10 to 6
  • Shift differential pay (The dates show you the increases/decreases throughout the contract)

/hour

  • 7am-3pm shift – 50 workers - $1,040,000
  • 3pm-11pm shift – 30 workers - $624,000
  • 11pm-7am shift – 15 workers - $312,000
  • Managers – 10 @$30K, 2 @ $40K, 1@$50K, Pres/Owner $75K
  • Overtime – time and a half; 2017-2019 no OT has been worked

Sales:                                                              Profits:

  • 2016 $4,000,000                                          2016 $1,040,000
  • 2017 $5,250,000                                          2016 $2,392,000
  • 2018 $6,000,000                                          2018 $3,300,000
  • 2019 $6,200,000 2019 $3,400,000

CPFacWorkers Labor Union –

Now, put yourself in the role of the negotiating team representing the CPFacWorkers labor union at Cooper Plastics in Glen Ellyn, Illinois. Cooper manufactures plastic cups, plates, silverware, bowls, etc. There are a total of 95 factory workers in the bargaining unit of your union.

It is time to negotiate with the Cooper Plastics management team.

Your negotiations document needs to include the following - you must include these categories in both offers:

  • Length of contract in years
  • Base pay
  • Annual increases
  • Shift pay differential
  • Overtime pay
  • Number of workers per shift
  • Benefits percentage of salaries
  • Annual paid sick days
  • Annual paid holidays
  • Total increased costs
  • Source of money for increased costs

Data from Current Contract, which expired in September 2020:

  • Contract began in March 2016
  • CPFacWorkers conceded to 20 layoffs when negotiating the 2016-2020 contract
  • Remaining workers agreed to a 10% pay cut to help the company recover from the recent US recession
  • Sick days were reduced from 10 to 6
  • Holidays reduced from 10 to 6
  • Shift differential pay:
    • 3pm-11pm   $0.50 3/15-3/16 $.25 3/17-3/19
    • 11pm-7am    $1.00 3/15-3/16 $.35 3/17-3/19
  • Benefits are 28% of salaries

Current Salaries based on 2080 hours per year, base pay $10/hour

  • 7am-3pm shift – 50 workers - $1,040,000
  • 3pm-11pm shift – 30 workers - $624,000
  • 11pm-7am shift – 15 workers - $312,000
  • Managers – 10 @$30K, 2 @ $40K, 1@$50K, Pres/Owner $75K
  • Overtime – time and a half; 2017-2019 no OT has been worked

Sales:                                                              Profits:

  • 2016 $4,000,000                                          2016 $1,040,000
  • 2017 $5,250,000                                          2017 $2,392,000
  • 2018 $6,000,000                                          2018 $3,300,000
  • 2019 $6,200,000 2019 $3,400,000

Other Considerations:

  • The United States appears to have come out of its 2008-2010 recession, though there are those who are beginning to say it will return in 2020 as recent stock market fluctuations may confirm.
  • Cooper has new products scheduled to be coming out in mid-2020 which may help stimulate growth in the firm’s revenues and profitability.
  • Management at Cooper does all hiring, scheduling, firing, and promotions.
  • It has become increasingly difficult to get employees to work the 3-11pm and 11pm-7am shifts. Absenteeism is high on these shifts and productivity on both of these shifts are lower than on the 7am-3pm shift.

When complete, click on the assignment name link to submit the assignment for grading.

In: Operations Management

Draw valid Lewis structure of the flowing molecules showing all lone pairs of electrons and overall...

Draw valid Lewis structure of the flowing molecules showing all lone pairs of electrons and overall charges. Draw the Lewis structure and name the electronic arrangement. Draw and name the molecular structure.

Molecules: FCO2-, BrF2+

In: Chemistry

A) In calculus what is the name of the slope of the line drawn tangent to...

A) In calculus what is the name of the slope of the line drawn tangent to curve (when the curve is a graph of given function) B) What is the name of the physical quantity given to the slope of a line tangent to a Distance vs Time curve?

In: Physics

Discuss the pros and cons of a US based domestic company aggressively investing in emerging economies....

Discuss the pros and cons of a US based domestic company aggressively investing in emerging economies. You may use a particular company (by name) and a particular emerging economy (by name) to provide your examples. (International Management

In: Economics

3. (a) (b) Name the two main forms of the known rhabdovirus disease and effective strategy...

3. (a)
(b) Name the two main forms of the known rhabdovirus disease and effective
strategy in preventing it in humans
(c) Schistosoma mansoni is found in which part of the body?
(d) Name the two main species of the genus

In: Nursing

What are the different characteristics between a febrile seizure, and generalized seizure and an absence seizure?...

  1. What are the different characteristics between a febrile seizure, and generalized seizure and an absence seizure?

  2. Name the three different causes of seizures, in children. Give an example of each.

  3. Name two common anticonvulsive medications and their side effects.

In: Nursing

Name the specialized periarticular tissues of the hip. What is the role of each of these...

Name the specialized periarticular tissues of the hip. What is the role of each of these tissues? (menisci, labrum, ligaments, etc)

Name the specialized periarticular tissues of the knee. What is the role of each of these tissues? (menisci, labrum, ligaments, etc)

In: Anatomy and Physiology

Write an Algorithm that asks the user to enter an address and print each part of...

Write an Algorithm that asks the user to enter an address and print each part of the address on a separate line.

Example:

Input

344 Rose Dr, Raeford, NC 28376

Output

Street No.: 344

Street Name: Rose Dr

City: Raeford

State: North Carolina

Zip Code: 28376

Hints:

Deal with the address as a string. The address must contain two commas. The text before first comma contains the street number and street name separated by one or more white spaces. The text after the second comma contains the state code and the zip code separated by one or more white spaces. The text between the two commas is the city name. The algorithm must print the state name instead of the state code.

In: Computer Science