Questions
Waterways (9) Corporation is preparing its budget for the coming year. The first step is to...

Waterways (9) Corporation is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Waterways gathered the following information from the managers.

Sales:

Actual unit sates for November

113,500

Actual unit sales for December

103,100

Expected unit sales for January

114,000

Expected unit sales for February

113,500

Expected unit sales for March

116,000

Expected unit sales for April

126,000

Expected unit sales for May

138,500

Unit selling price

$12

Waterways wants to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31 totaled 183,780.

Direct Materials:

The product uses metal, plastic, and rubber. In total, each unit requires 2 pounds of material at an average cost of 0.75 per pound.

Waterways likes to keep 5% of the materials needed for the next month in its ending inventory. Payment for materials is made within 15 days. 50% is paid in the month of purchase and 50% is paid in the month after purchase. Accounts Payable on December totaled $120,595. Raw materials on December 31 totaled 11,295 pounds.

Direct Labor:

Labor requires 12 minutes per unit for completion and is paid at a rate of $18 per hour.

Manufacturing Overhead:

Indirect materials

30 cents per labor hour

Indirect labor

50 cents per labor hour

Utilities

45 cents per labor hour

Maintenance

25 cents per labor hour

Salaries

$52,000 per month

Depreciation

$16,800 per month

Property taxes

$2,675 per month

Insurance

$2,200 per month

Janitorial

$1,800 per month

Selling and Administrative Expenses:

Variable selling and administrative cost per unit is $2.40.

Advertising

$15,000 per month

Insurance

$1,400 per month

Salaries

$72,000 per month

Depreciation

$2,500 per month

Other fixed costs

$3,000 per month

Other Information:

The cash balance on December 31 totaled $220,500, but management has decided that it wants to maintain a cash balance of at least $750,000 beginning January 31. Dividends are paid each month at the rate of $2.50 per share for 5,000 shares outstanding. The company has an open line of credit with the First National Bank. The terms of the agreement requires borrowing to be in $1,000 increments at 8% interest. Waterways borrows on the first day of the month and repays on the last day of the month. Reserve repayment, if required, until Waterways can pay the entire amount. A $250,000 equipment purchase is planned for February.

Instructions (Do all parts):

Note: All budgets and schedules should be prepared by month for the first quarter (January, February, and March). Round all figures to the nearest dollar. For labor hours round to whole hours.

a. Prepare a sales budget.

b. Prepare a production budget.

c. Prepare a direct materials budget.

d. Prepare a direct labor budget.

e. Prepare a manufacturing overhead budget.

f. Prepare a selling and administrative budget.

g. Prepare a schedule for expected cash collections from customers.

h. Prepare a schedule for expected payments for materials purchases.

i. Prepare a cash budget.

In: Accounting

Midlands Inc. had a bad year in 2016. For the first time in its history, it...

Midlands Inc. had a bad year in 2016. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 77,000 units of product: net sales $2,310,000; total costs and expenses $2,180,000; and net loss $-130,000. Costs and expenses consisted of the following.

Total

Variable

Fixed

Cost of goods sold $1,505,000 $1,003,000 $502,000
Selling expenses 522,000 92,000 430,000
Administrative expenses 153,000 60,000 93,000
$2,180,000 $1,155,000 $1,025,000


Management is considering the following independent alternatives for 2017.

1. Increase unit selling price 20% with no change in costs and expenses.
2. Change the compensation of salespersons from fixed annual salaries totaling $201,000 to total salaries of $36,000 plus a 5% commission on net sales.
3. Purchase new high-tech factory machinery that will change the proportion between variable and fixed cost of goods sold to 50:50.


(a) Compute the break-even point in dollars for 2017. (Round contribution margin ratio to 2 decimal places e.g. 0.25 and final answer to 0 decimal places, e.g. 2,510.)

Break-even point $ 205000


(b) Compute the break-even point in dollars under each of the alternative courses of action. (Round contribution margin ratio to 4 decimal places e.g. 0.2512 and final answers to 0 decimal places, e.g. 2,510.)

Break-even point

1. Increase selling price $
2. Change compensation $
3. Purchase machinery $


Which course of action do you recommend?

Alternative 1

I do not know how to get the middle section of this question 1., 2.,3.

In: Accounting

At the beginning of its fiscal year 2019, an analyst made the following forecast for GM,...

At the beginning of its fiscal year 2019, an analyst made the following forecast for GM, Inc. (in millions of dollars):

2019

2020

2021

2022

Cash flow from operation

$1,035

$3,180

$3,155

$2,120

Cash investment

425

480

445

820

GM did not have any short-term and long-term debt at the beginning of 2019. Assume that free cash flow will grow at 5 percent per year in 2023 and 2024, after that this will grow at 4 percent per year. GM had 305 million shares outstanding at the beginning of 2019, trading at $73.25 per share. Using a required return of 10 percent, calculate the following for GM at the beginning of 2019:

  1. The enterprise value.                                                                                   [6 marks]
  2. Equity value.                                                                                               [1 marks]
  3. Equity value per share.                                                                                [2 marks]
  4. Based on your estimate, should investors buy the share of this company?      [1 marks]

In: Finance

This assignment is based on the 10-K for Yum Brands Inc. for the year ended December...

This assignment is based on the 10-K for Yum Brands Inc. for the year ended December 31, 2017. You can obtain Yum’s 10-K from the SEC’s Edgar data base of company

https://www.sec.gov/ix?doc=/Archives/edgar/data/1041061/000104106118000013/yum10k12312017.htm

A- In the Management and Discussion Analysis section, under the heading “Critical Accounting Policies and Estimates,” Yum discusses its accounting for income taxes. Summarize that discussion in your own words.

B- In aggregate, what journal entry did Yum make to accrue income taxes for the year ended December 31, 2017? Your approach here will need to differ from what was discussed in class. Here you have income tax expense and will need to back into income tax payable.

In: Accounting

Victor invests 300 into a bank account at the beginning of each year for 20 years....

Victor invests 300 into a bank account at the beginning of each year for 20 years. The account pays out interest at the end of every year at an annual effective interest rate of i% . The interest is reinvested at an annual effective rate of i / 2 %. The yield rate on the entire investment over the 20 year period, if he would only make deposits of 300 due is 8% annual effective. Determine i.

In: Finance

the interest rate in the united states are 2% per year while the interest rate in...

the interest rate in the united states are 2% per year while the interest rate in the united kingdom is 1% per year the spot rate and the forward rate between the us dollars ad the british pounds are as follows.

S(USD/GBP)   bid price is 1.3290 and the ask price is 1.3300

F6(USD/GBP) bid price is 1.3195 and the ask price is 1.3200

you can borrow usd 100,000 or gbp 100,000 in the united kingdom and your investment horizon is half a year

are you able to make a gauranteed profit through a covered interest arbitrage? if so explain clearly how you are able to take advantage of it and calculate the amount of profit you will be able to make show your calculations

In: Finance

Assume that you are considering the purchase of a 20-year, bond with an annual coupon rate...

Assume that you are considering the purchase of a 20-year, bond with an annual coupon rate of 9.5%. The bond has a face value of $1,000, and it makes semiannual interest payments. If you require an 9.7% nominal yield to maturity on this investment, what is the maximum price you should be willing to pay for the bond? (With excel formulas)

In: Finance

The current price of MB Industries stock is $20 per share. In the next year the...

The current price of MB Industries stock is $20 per share. In the next year the stock price will either go up to $24 per share or go down to $16 per share. MB pays no dividends. The one year risk-free rate is 5 percent and will remain constant. Using the one-step binomial pricing model, what is the price of a one-year CALL option on MB stock with a strike price of $20 (out to two decimal places)?

In: Finance

During the year, an enterprise fund had a number of transactions that affected the various net...

During the year, an enterprise fund had a number of transactions that affected the various net positions of the fund. You should analyze the transactions in the grid below, and the record the adjusting entries. The first transaction is analyzed for you as an example.

1.  Net income for the year was $250,000.

2. Depreciation expenses for the year totaled $93,000.

3. Equipment with a carrying amount of $324,000 was sold for $398,000.

4. Principal payments of $96,000 were made on debt incurred to acquire plant and equipment.

5. New equipment was purchased for $100,000 in cash and a note payable of $373,000.

6.  Bonds in the amount of $5,000,000 were issued to finance construction. At the end of the year, the project was incomplete, with costs incurred so far of $1,900,000.

Clearly show how you computed the amount of the adjustment.

Journal entry to adjust unrestricted net assets:

Journal entry to adjust net investment in capital assets:

Journal entry to adjust restricted net assets.

In: Accounting

$6746 is deposited into a savings account at 5% interest, coumpounded quarterly. to the nearest year,...

$6746 is deposited into a savings account at 5% interest, coumpounded quarterly. to the nearest year, how long will it take for the account balance to reach $1,000,000?

In: Accounting