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 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, 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:
In: Finance
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. 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 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 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 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 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
In: Accounting