The Austin, Texas plant of Computer Products produces disk units for personal and small business computers. Gerald Knox, the plant’s production planning director, is looking over next year’s sales forecasts for these products and will be developing an aggregate capacity plan for the plant. The quarterly sales forecasts for the disk units are as follows:
|
1st Quarter |
2nd Quarter |
3rd Quarter |
4th Quarter |
|
2,310 |
1,980 |
1,980 |
2,340 |
Ample machine capacity exists to produce the forecast. Each disk unit takes an average of 20 labor-hours. In addition, you have collected the following information:
Compare the following two sales and operations plans.
i) The company will use a matching (chasing) demand strategy for the first two quarters. For quarters three and four, it will use a level production strategy with no overtime, no shortages during these quarters and no inventory leftover at the end of the fourth quarter. What is the total cost of this option, excluding the material cost?
ii) The company will establish in quarter one and then maintain a workforce capable of producing 2,160 units in a quarter. If there are more workers in a quarter than required to produce the demand for that quarter, only the units required will be produced in that quarter and there will be underutilization. If demand is greater in a quarter than can be produced by the available workforce using straight time labor, the excess units will be outsourced. What is the total cost of this option, excluding the material cost?
In: Accounting
The Protek Company is a large manufacturer and distributor of electronic components. Because of some successful new products marketed to manufacturers of personal computers, the firm has recently undergone a period of explosive growth, more than doubling its revenues during the last two years. However, the growth has been accompanied by a marked decline in profitability and a precipitous drop in the company’s stock price.
You are a financial consultant who has been retained to analyze the company’s performance and find out what’s going wrong. Your investigative plan involves a series of in-depth interviews with management and doing some independent research on the industry. However, before starting, you want to focus your thinking to be sure you can ask the right questions. You’ll begin by analyzing the firm’s financials over the last three years, which are presented in the supplemental datasheet. Assume the company sold no property, plant, or equipment during the time periods presented. Also assume the company did not repay any long-term debt. The company’s normal credit terms extended to its customers is net 30.
Complete the following using Microsoft Excel and Word. All quantitative analysis should be done in Excel, while all qualitative analysis should be completed in Word. Construct horizontal analysis (year-over-year growth) on the financial statements for 2019 and 2020. Analyze the trend in each line; what does the trend analysis reveal? What are strengths, and areas for concern? Construct common size balance sheets for 2018 - 2020, respectively, and common size income statements for 2018 - 2020, respectively. Analyze the trend in each line. What appears to be happening? What are your significant findings? Construct Statements of Cash Flows for 2019 and 2020 using the indirect method. Also compute Free Cash Flow for each year. Where is the company’s cash going to and coming from? What are strengths, and areas for concern? Calculate all the financial ratios discussed in chapter 15 (use exhibit 15-6 as a guide) for 2019 and 2020. Analyze trends in each ratio. What can you infer from this information? Make specific statements about liquidity, asset management, debt management, profitability, and market performance. Do not simply say that ratios are higher or lower (or that they are going up or down); instead, think about what might be going on in the company and propose reasons why the ratios are acting as they are. Finally, based on all of your analysis, what two (or more) specific actionable items should the company do to improve its situation? Be specific in your response and discuss the implication of your recommendation.
| EXHIBITS: SUPPLEMENTAL DATA (for Protek Company) | |||
| All values, except stock price, are in millions ($000,000) | |||
| Table 1 Balance Sheets | 2018 | 2019 | 2020 |
| Assets | |||
| Cash | $30 | $40 | $62 |
| Accounts receivable | 175 | 351 | 590 |
| Inventory | 90 | 151 | 300 |
| Gross Property, Plant, & Equipment | 1,565 | 2,373 | 2,718 |
| Accumulated depreciation | -610 | -860 | -1,135 |
| Total assets | $1,250 | $2,055 | $2,535 |
| Liabilities and equity | |||
| Accounts payable | $56 | $81 | $134 |
| Accruals | 15 | 20 | 30 |
| Long-term debt | 630 | 1,260 | 1,600 |
| Total equity | 549 | 694 | 771 |
| Total liabilities and equity | $1,250 | $2,055 | $2,535 |
| Table 2 Income Statements | 2018 | 2019 | 2020 |
| Sales | $1,578 | $2,106 | $3,265 |
| Cost of goods sold | 631 | 906 | 1,502 |
| Operating expenses: | |||
| Depreciation | 200 | 250 | 275 |
| Administration | 126 | 179 | 294 |
| Research & Development | 158 | 211 | 327 |
| Sales and Marketing | 116 | 245 | 607 |
| Operating Income | 347 | 315 | 260 |
| Interest expense | 63 | 95 | 143 |
| Pre-tax Profit | $284 | $220 | $117 |
| Income Tax Expense (34% tax rate) | 97 | 75 | 40 |
| Net Income | $187 | $145 | $77 |
| Table 3 Other Information | 2018 | 2019 | 2020 |
| Dividends Paid | $0 | $0 | $0 |
| Stock Issuance | $0 | $0 | $0 |
| Stock price | $39.27 | $26.10 | $11.55 |
| Avg. Shares outstanding | 100 | 100 | 100 |
| Avg. Interest Rate on Long-term debt | 10.00% | 10.00% | 10.00% |
In: Accounting
[The following information applies to the questions displayed below.]
Tony and Suzie are ready to expand Great Adventures even further
in 2019. Tony believes that many groups in the community (for
example, Boy Scouts, church groups, civic groups, and local
businesses) would like to hold one-day outings for their members.
Groups would engage in outdoor activities such as rock climbing,
fishing, capture the flag, paintball, treasure hunts, scavenger
hunts, nature hikes, and so on. The purpose of these one-day events
would be for each member of the group to learn the importance of
TEAM (Together Everyone Achieves More).
Tony knows that most people are not familiar with these types of activities, so to encourage business he allows groups to participate in the event before paying. He offers a 6% quick-payment discount to those that pay within 10 days after the event. He also guarantees that at least eight hours of outdoor activities will be provided or the customer will receive a 20% discount. For the first six months of the year, the following activities occur for TEAM operations.
Jan. 24 Great Adventures purchases outdoor gear such
as ropes, helmets, harnesses, compasses, and other miscellaneous
equipment for $4,000 cash.
Feb. 25 Mr. Kendall’s Boy Scout troop participates in a
one-day TEAM adventure. Normally, Tony would charge a group of this
size $2,500, but he wants to encourage kids to exercise more and
enjoy the outdoors so he charges the group only $2,000. Great
Adventures provides these services on account.
Feb. 28 The Boy Scout troop pays the full amount owed,
less the 6% quick-payment discount.
Mar. 19 Reynold’s Management has its employees
participate in a one-day TEAM adventure. Great Adventures provides
services on account for $3,000, and Reynold’s agrees to pay within
30 days
Mar. 27 Reynold’s pays the full amount owed, less the
6% quick-payment discount.
Apr. 7 Several men from the Elks Lodge decide to
participate in a TEAM adventure. They pay $6,500, and the event is
scheduled for the following week.
Apr. 14 The TEAM adventure is held for members of the
Elks Lodge.
May. 9 Myers Manufacturing participates in a TEAM
adventure. Great Adventures provides services on account for
$5,000, and Myers agrees to pay within 30 days.
Jun. 1−30 Several MBA groups participate in TEAM
adventures during June. Great Adventures provides services on
account for $19,000 to these groups, with payment due in
July.
Jun. 30 Myers Manufacturing fails to pay the amount
owed within the specified period and agrees to sign a three-month,
9% note receivable to replace the existing account receivable.
Required:
1. Record TEAM adventure transactions occurring during the first six months of 2019. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)
2. As of June 30, 2019, Great Adventures finishes its first 12 months of operations. If Suzie wants to prepare financial statements, part of the process would involve allowing for uncollectible accounts receivable.
a. Suppose Suzie estimates uncollectible accounts to be 5% of accounts receivable (which does not include the $5,000 note receivable from Myers Manufacturing). Record the adjustment for uncollectible accounts on June 30, 2019. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)
b. Prepare a partial balance sheet showing the
net accounts receivable section. (Amounts to be deducted
should be indicated by a minus sign.)
In: Accounting
XYZ manufactures seats for helicopters. The company has the capacity to produce 100,000 seats per year, but is currently produces and sells 75,000 seats per year.
|
Selling price per unit |
$ 200 |
|
Variable costs per unit: |
|
|
Manufacturing |
$ 110 |
|
Operating |
$ 25 |
|
Fixed costs: |
|
|
Manufacturing |
$ 375,000 |
|
Operating |
$ 100,000 |
If a special sales order is accepted for 2,500 seats at a price of $ 160 per unit, fixed costs increase by $ 2,500, and variable marketing and administrative costs for that order are $12.50 per unit, how would operating income be affected?
I got answer of -($ 91,250) Please show the solution
In: Accounting
Part A In late 2017, the Nicklaus Corporation was formed. The corporate charter authorizes the issuance of 6,000,000 shares of common stock carrying a $1 par value, and 2,000,000 shares of $5 par value, noncumulative, nonparticipating preferred stock. On January 2, 2018, 4,000,000 shares of the common stock are issued in exchange for cash at an average price of $10 per share. Also on January 2, all 2,000,000 shares of preferred stock are issued at $25 per share. Required: 1. Prepare journal entries to record these transactions. 2. Prepare the shareholders' equity section of the Nicklaus balance sheet as of March 31, 2018. (Assume net income for the first quarter 2018 was $1,900,000.) Part B During 2018, the Nicklaus Corporation participated in three treasury stock transactions: On June 30, 2018, the corporation reacquires 280,000 shares for the treasury at a price of $12 per share. On July 31, 2018, 40,000 treasury shares are reissued at $15 per share. On September 30, 2018, 40,000 treasury shares are reissued at $10 per share. Required: 1. Prepare journal entries to record these transactions. 2. Prepare the Nicklaus Corporation shareholders' equity section as it would appear in a balance sheet prepared at September 30, 2018. (Assume net income for the second and third quarter was $3,400,000.) Part C On October 1, 2018, Nicklaus Corporation receives permission to replace its $1 par value common stock (6,000,000 shares authorized, 4,000,000 shares issued, and 3,800,000 shares outstanding) with a new common stock issue having a $.50 par value. Since the new par value is one-half the amount of the old, this represents a 2-for-1 stock split. That is, the shareholders will receive two shares of the $.50 par stock in exchange for each share of the $1 par stock they own. The $1 par stock will be collected and destroyed by the issuing corporation. On November 1, 2018, the Nicklaus Corporation declares a $0.21 per share cash dividend on common stock and a $0.38 per share cash dividend on preferred stock. Payment is scheduled for December 1, 2018, to shareholders of record on November 15, 2018. On December 2, 2018, the Nicklaus Corporation declares a 1% stock dividend payable on December 28, 2018, to shareholders of record on December 14. At the date of declaration, the common stock was selling in the open market at $10 per share. The dividend will result in 76,000 (0.01 × 7,600,000) additional shares being issued to shareholders. Required: 1. Prepare journal entries to record the declaration and payment of these stock and cash dividends. 2. Prepare the December 31, 2018, shareholders' equity section of the balance sheet for the Nicklaus Corporation. (Assume net income for the fourth quarter was $2,900,000.) 3. Prepare a statement of shareholders' equity for Nicklaus Corporation for 2018.
In: Accounting
On June 1, 2019, Whispering Company sold $2,940,000 in long-term bonds for $2,578,700. The bonds will mature in 10 years and have a stated interest rate of 8% and a yield rate of 10%. The bonds pay interest annually on May 31 of each year.
The bonds are to be accounted for under the effective-interest method.
1)Construct a bond amortization table for this problem to indicate the amount of interest expense and discount amortization at each May 31.
2)Assuming that interest and discount amortization are recorded each May 31, prepare the adjusting entry to be made on December 31, 2021. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)
In: Accounting
In: Accounting
Describe the accounting and reporting for re-acquisition of shares
In: Accounting
Scenario: Davis Skaros has recently been promoted to production manager. He has just started to receive various managerial reports, including the production cost report you prepared. It showed his department had 2,000 equivalent units in ending inventory. His department has had a history of not keeping enough inventory on hand to meet demand. He has come to you, very angry, and wants to know why you credited him with only 2,000 units when he knows he had at least twice that many on hand.
Prepare a maximum 700-word informal memo and explain to Mr. Skaros why his production cost report showed only 2,000 equivalent units in ending inventory. Using a professional tone, explain to him clearly why your report is accurate.
In: Accounting
What would be the account balance in the Cash account after the following transactions. Assume a zero beginning Cash balance.
|
Owner invested cash in the business |
$100,000 |
|
Purchase supplies with cash. |
$20,000 |
|
Received a bill for one month of rent owed to landlord |
$2,200 |
|
Paid wages earned in the month in cash |
$800 |
|
Billed a customer for services performed |
$1,250 |
| A. |
$124,250 |
|
| B. |
$80,400 |
|
| C. |
$77,800 |
|
| D. |
$79,200 |
|
| E. |
$80,000 |
What would the account balance in Accounts Receivable after the following transactions, assuming a zero beginning balance?
Performed services and left a bill with the customer $4,200
Performed services and collected immediately $3,500
Performed services and billed customer $2.200
Performed services on account $6,000
Received partial payment on account. $1,500
| A. |
$17,400 |
|
| B. |
$10,900 |
|
| C. |
$14,400 |
|
| D. |
$4,500 |
|
| E. |
$11,400 |
A partial trial balance of Ledger accounts at year-end had the following balances. If all the accounts have normal balances, what are the total debits on the Trial Balance?
|
Cash |
30,000 |
|
Account receivable |
32,000 |
|
Supplies |
5,000 |
|
Accounts payable |
20,000 |
|
Fees Earned |
65,000 |
|
Rent expense |
15,000 |
|
Insurance expense |
4,800 |
|
Common Stock |
5,000 |
|
Retained Earnings |
14,800 |
|
Dividends paid |
18,000 |
| A. |
$45,200 |
|
| B. |
$67,000 |
|
| C. |
$68,800 |
|
| D. |
$104,800 |
The following information is available for three competing toy companies. Which company earned the highest return on assets?
|
Company 1 |
Company 2 |
Company 3 |
|
|
Assets |
90,500 |
64,000 |
32,500 |
|
Liabilities |
11.765 |
46,720 |
26,650 |
|
Average Assets |
100,000 |
40,000 |
50,000 |
|
Net income |
20,000 |
3,800 |
650 |
A.
Company 1
B.
Company 2
C.
Company 3
D.
Cannot be calculated from the data provided.
In: Accounting
The Nelson Company has $1,261,000 in current assets and $485,000 in current liabilities. Its initial inventory level is $350,000, and it will raise funds as additional notes payable and use them to increase inventory. How much can Nelson's short-term debt (notes payable) increase without pushing its current ratio below 1.8? Do not round intermediate calculations. Round your answer to the nearest dollar. What will be the firm's quick ratio after Nelson has raised the maximum amount of short-term funds? Do not round intermediate calculations. Round your answer to two decimal places.
In: Accounting
On January 4 Crossway Co. sold merchandise to Mallard Company for $25,500, terms 2/10, n/60; shipping terms were FOB Destination. The merchandise had a cost of $14,000 to Crossway Co.
2. On January 6 Crossway paid freight costs of $500.
3. On January 8 Mallard returned $2,500 of the merchandise purchased on January 4 to Crossway and received credit. The merchandise had a cost of $1,400 to Crossway.
4. On January 9 Mallard paid the amount due to Crossway.
--Record the necessary journal entries for Crossway
Co. Omit explanations.
1. On January 4 Crossway Co. sold merchandise to Mallard Company for $25,500, terms 2/10, n/60; shipping terms were FOB Destination. The merchandise had a cost of $14,000 to Crossway Co.
2. On January 6 Crossway paid freight costs of $500.
3. On January 8 Mallard returned $2,500 of the merchandise purchased on January 4 to Crossway and received credit. The merchandise had a cost of $1,400 to Crossway.
4. On January 9 Mallard paid the amount due to Crossway.
--Record the necessary journal entries for Mallard
Company. Omit explanation
In: Accounting
At the beginning of 20X1, the accounting records of Friends
Corp. reported the following:
| Preferred shares, 6,800 shares outstanding, no-par | $ | 226,440 |
| Common shares, 181,000 shares outstanding, no-par | 530,330 | |
| Contributed capital on common share retirement | 110,900 | |
| Retained earnings | 554,500 | |
During the year, the company acquired and retired shares, while
other shares were issued:
| 15 March | 24,800 common shares bought and retired at $5 per share |
| 16 March | 4,000 preferred shares bought and retired at $36.20 per share |
| 20 May | 8,800 common shares bought and retired at $1 per share |
| 25 May | 1,500 preferred shares bought and retired at $21.70 per share |
| 30 May | 10,700 common shares issued at $13.70 per share |
| 15 Nov. | 4,900 common shares bought and retired at $28 per share |
2. Calculate the closing balance in each account in shareholders’
equity. (Round intermediate calculations to 2 decimal
places. Round your final answers to the nearest whole
dollar.)
|
|||||||||||||||
In: Accounting
You are a financial manager for Zoom Corp., which manufactures
bicycles. In the most recent fiscal year,
Zoom manufactured and sold 20,000 bicycles. Wheels, seats, and
brake calipers are three components of
the bicycles currently manufactured by Zoom. Three different
vendors have proposed to provide those
components to Zoom, and quoted prices (including shipping) for
their delivery. Your task is to determine
which, if any, of these proposals should be accepted.
Prepare a make vs. buy incremental analysis for each possible
course of action in an Excel worksheet. Your
grade will be based on the correctness of your answers, as well as
the use of Excel. That is, where possible,
you should use formulas to get your answers, rather than keyed-in
values. See your instructor for help with
Excel basics if you need it.
In a Word document, prepare a memo stating which of the
proposals you suggest accepting, as well as the
basis for your conclusions. Also identify any nonfinancial factors
you should consider before accepting any
of the outsourcing proposals.
Below is cost data for Zoom's production of wheels, seats, and
calipers. Outside suppliers have offered to
provide wheels for $6.90, seats for $9.39, and calipers for $2.14
per piece. Both wheels and seats are branded
with the Zoom logo, and that logo will need to be added at the Zoom
factory at a cost of $0.50 each for any
of these components that are outsourced. For all three components,
75% of the fixed costs are avoidable, and
will be eliminated if the component's production is outsourced. In
addition, seats and calipers are both
produced out of the same small factory space. If both seats and
calipers were outsourced, Zoom could lease
the space out and increase net income by $6,000 per year, while
eliminating all fixed costs for the two
components.
| Wheels | Seats | Calipers | |
| Cost category | |||
| Direct materials | $138,000 | $54,500 | $87,500 |
| Direct labor | 97,000 | 71,500 | 44,500 |
| Variable overhead | 21,000 | 14,000 | 16,000 |
| Fixed overhead | 60,400 | 36,600 | 31,400 |
| Total cost | $316,400 | $176,600 | $179,400 |
| Units produced | 40,000 | 20,000 | 80,000 |
| Cost per unit | $7.91 | $8.83 | $2.24 |
Hints: Prepare incremental analyses for each component
separately. Make wheels vs. buy wheels, etc. Since
there are additional implications to outsourcing both seats and
calipers, do a make vs. buy analysis assuming
both are outsourced. A correct solution, then, will likely have at
least four incremental analyses.
In: Accounting
The following items were selected from among the transactions completed by O’Donnel Co. during the current year:
| Jan. | 10. | Purchased merchandise on account from Laine Co., $240,000, terms n/30. |
| Feb. | 9. | Issued a 30-day, 4% note for $240,000 to Laine Co., on account. |
| Mar. | 11. | Paid Laine Co. the amount owed on the note of February 9. |
| May | 1. | Borrowed $160,000 from Tabata Bank, issuing a 45-day, 5% note. |
| June | 1. | Purchased tools by issuing a $180,000, 60-day note to Gibala Co., which discounted the note at the rate of 5%. |
| 15. | Paid Tabata Bank the interest due on the note of May 1 and renewed the loan by issuing a new 45-day, 7% note for $160,000. (Journalize both the debit and credit to the notes payable account.) | |
| July | 30. | Paid Tabata Bank the amount due on the note of June 15. |
| 30. | Paid Gibala Co. the amount due on the note of June 1. | |
| Dec. | 1. | Purchased office equipment from Warick Co. for $400,000, paying $100,000 and issuing a series of ten 5% notes for $30,000 each, coming due at 30-day intervals. |
| 15. | Settled a product liability lawsuit with a customer for $260,000, payable in January. O’Donnel accrued the loss in a litigation claims payable account. | |
| 31. | Paid the amount due Warick Co. on the first note in the series issued on December 1. |
| Required: | |||||
| 1. | Journalize the transactions. Refer to the Chart of Accounts for exact wording of account titles. Assume a 360-day year. | ||||
| 2. | Journalize the adjusting entry for each of the following
accrued expenses at the end of the current year (refer to the Chart
of Accounts for exact wording of account titles):
|
In: Accounting