Search here for Tutorials

If the Data is different in your question, please send your questions to homeworksolutionsnow@gmail.com. The questions will be answered at the same price.

ACC560 Week 5 Homework -- E7-3 E7-7 E7-11 P7-3A E8-2 E8-6 E8-9 P8-5A

ACC560 Week 5 Homework 

E7-3 Moonbeam Company
E7-7 Riggs Company
E7-11 Chen Minerals processes
P7-3A Thompson Industrial Products Inc
E8-2 Eckert Company
E8-6 Alma’s Recording Studio
E8-9 Rey Custom Electronics
P8-5A Gutierrez Company


E7-3 Moonbeam Company manufactures toasters. For the first 8 months of 2017, the company reported the following operating results while operating at 75% of plant capacity: 

Sales (350,000 units)                                                   $4,375,000
Cost of goods sold                                                       2,600,000
Gross profit                                                                 1,775,000
Operating expenses                                                         840,000
Net income                                                                  $ 935,000 

Cost of goods sold was 70% variable and 30% fixed; operating expenses were 80% variable and 20% fixed.

In September, Moonbeam Company receives a special order for 15,000 toasters at $7.60 each from Luna Company of Ciudad Juarez. Acceptance of the order would result in an additional $3,000 of shipping costs but no increase in fixed operating expenses.

Instructions
(a) Prepare an incremental analysis for the special order.
(b) Should Moonbeam Company accept the special order? Why or why not?

E7-7 Riggs Company purchases sails and produces sailboats. It currently produces 1,200 sailboats per year, operating at normal capacity, which is about 80% of full capacity. Riggs purchases sails at $250 each, but the company is considering using the excess capacity to manufacture the sails instead. The manufacturing cost per sail would be $100 for direct materials, $80 for direct labor, and $90 for overhead. The $90 overhead is based on $78,000 of annual fixed overhead that is allocated using normal capacity.
The president of Gibbs has come to you for advice. “It would cost me $270 to make the sails,” she says, “but only $250 to buy them. Should I continue buying them, or have I missed something?”

Instructions
(a) Prepare a per unit analysis of the differential costs. Briefly explain whether Riggs should make or buy the sails.
(b) If Riggs suddenly finds an opportunity to rent out the unused capacity of its factory for $77,000 per year, would your answer to part (a) change? Briefly explain.
(c) Identify three qualitative factors that should be considered by Riggs in this make-or-buy decision.                                                                                                             (CGA adapted)

E7-11 Chen Minerals processes materials extracted from mines. The most common raw material that it processes results in three joint products: Spock, Uhura, and Sulu. Each of these products can be sold as is, or each can be processed further and sold for a higher price. The company incurs joint costs of $180,000 to process one batch of the raw material that produces the three joint products. The following cost and sales information is available for one batch of each product.

 
Sales Value at Split-Off Point
Allocated
Joint Costs
Cost to Process Further
Sales Value of Processed Product
Spock
$200,000
$40,000
$110,000
$300,000
Uhura
   300,000
60,000
    85,000
400,000
Sulu
455,000
  80,000
  250,000
800,000

Instructions
Determine whether each of the three joint products should be sold as is, or processed further.

P7-3A Thompson Industrial Products Inc. (TIPI) is a diversified industrial-cleaner processing company. The company’s Dargan plant produces two products: a table cleaner and a floor cleaner from a common set of chemical inputs (CDG). Each week 900,000 ounces of chemical input are processed at a cost of $210,000 into 600,000 ounces of floor cleaner and 300,000 ounces of table cleaner. The floor cleaner has no market value until it is converted into a polish with the trade name Floor Shine. The additional processing costs for this conversion amount to $240,000.

FloorShine sells at $20 per 30-ounce bottle. The table cleaner can be sold for $17 per 25-ounce bottle. However, the table cleaner can be converted into two other products by adding 300,000 ounces of another compound (TCP) to the 300,000 ounces of table cleaner.

This joint process will yield 300,000 ounces each of table stain remover (TSR) and table polish (TP). The additional processing costs for this process amount to $100,000. Both table products can be sold for $14 per 25-ounce bottle.

The company decided not to process the table cleaner into TSR and TP based on the following analysis.
Process Further
Table Stain
Table               Remover          Table Polish
Cleaner            (TSR)               (TP)                             Total
Production in ounces               300,000           300,000           300,000
Revenue                                  $204,000         $168,000         $168,000                     $336,000
Costs:
CDG costs                                  70,000*        52,500                         52,500                         105,000**
TCP costs                                             0          50,000                         50,000                         100,000
Total costs                                  70,000          102,500           102,500                       205,000
Weekly gross profit                 $134,000         $ 65,500          $ 65,500                      $131,000
*If table cleaner is not processed further, it is allocated 1/3 of the $210,000 of CDG cost, which is equal to 1/3 of the total physical output.
**If table cleaner is processed further, total physical output is 1,200,000 ounces. TSR and TP combined account for 50% of the total physical output and are each allocated 25% of the CDG cost.

Instructions
(a) Determine if management made the correct decision to not process the table cleaner further by doing the following.
(1) Calculate the company’s total weekly gross profit assuming the table cleaner is not processed further.
(2) Calculate the company’s total weekly gross profit assuming the table cleaner is processed further.
(3) Compare the resulting net incomes and comment on management’s decision.

(b) Using incremental analysis, determine if the table cleaner should be processed further.

(CMA adapted)
(2) Gross Profit $186,000

E8-2 Eckert Company is involved in producing and selling high-end golf equipment. The company has recently been involved in developing various types of laser guns to measure yardages on the golf course. One small laser gun, called LittleLaser, appears to have a very large potential market. Because of competition, Eckert does not believe that it can charge more than $90 for LittleLaser. At this price, Eckert believes it can sell 100,000 of these laser guns. Eckert will require an investment of $8,000,000 to manufacture, and the company wants an ROI of 20%.
Instructions
Determine the target cost for one LittleLaser.

E8-6 Alma’s Recording Studio rents studio time to musicians in 2-hour blocks. Each session includes the use of the studio facilities, a digital recording of the performance, and a professional music producer/mixer. Anticipated annual volume is 1,000 sessions. The company has invested $2,352,000 in the studio and expects a return on investment (ROI) of 20%. Budgeted costs for the coming year are as follows.
                                                                                                            Per Session                  Total
Direct materials (tapes, CDs, etc)                                                         $ 20
Direct labor                                                                                          $400
Variable overhead                                                                               $ 50
Fixed overhead                                                                                                                            $950,000
Variable selling and administrative expenses                                       $ 40
Fixed selling and administrative expenses                                                                       $500,000

Instructions
(a) Determine the total cost per session.
(b) Determine the desired ROI per session.
(c) Calculate the markup percentage on the total cost per session.
(d) Calculate the target price per session.


E8-9 Rey Custom Electronics (RCE) sells and installs complete security, computer, audio, and video systems for homes. On newly constructed homes it provides bids using time-and-material pricing. The following budgeted cost data are available.
                                                                                                            Material
                                                                                    Time                Loading
                                                                                    Charges            Charges
Technicians’ wages and benefits                                 $150,000             
Parts manager’s salary and benefits                                                $34,000
Office employee’s salary and benefits                        30,000             15,000
Other overhead                                                            15,000             42,000
Total budgeted costs                                                    $193,000         $91,000

The company has budgeted for 6,250 hours of technician time during the coming year. It desires a $38 profit margin per hour of labor and a 80% profit on parts. It estimates the total invoice cost of parts and materials in 2017 will be $700,000.
Instructions
(a) Compute the rate charged per hour of labor.
(b) Compute the material loading percentage.

(c) RCE has just received a request for a bid from Buil Builders on a $1,200,000 new home. The company estimates that it would require 80 hours of labor and $40,000 of parts. Compute the total estimated bill.

 
P8-5A Gutierrez Company makes various electronic products. The company is divided into a number of autonomous divisions that can either sell to internal units or sell externally. All divisions are located in buildings on the same piece of property. The Board Division has offered the Chip Division $21 per unit to supply it with chips for 40,000 boards. It has been purchasing these chips for $22 per unit from outside suppliers. The Chip Division receives $22.50 per unit for sales made to outside customers on this type of chip. The variable cost of chips sold externally by the Chip Division is $14.50. It estimates that it will save $4.50 per chip of selling expenses on units sold internally to the Board Division. The Chip Division has no excess capacity.

Instructions
(a) Calculate the minimum transfer price that the Chip Division should accept. Discuss whether it is in the Chip Division’s best interest to accept the offer.
(b) Suppose that the Chip Division decides to reject the offer. What are the financial implications for each division, and for the company as a whole, of this decision?
Total loss to company $160,000


TUTORIAL PREVIEW
(a)
 
 
 
Net Income
Increase
 
Make Sails
Buy Sails
(Decrease)
Direct material            
$100
$ 0
$ 100
Direct labor
80
0
80
Variable overhead
35
   0
35


File name: ACC560 Week 5 Homework.docx File type: .docx PRICE: $50

ACC280 week7 Checkpoint

ACC280 week7 Checkpoint 

CheckPoint
Ratio, Vertical, and Horizontal Analyses

The calculations you perform for this Check Point form the basis of your analysis of your capstone project.

Write in 100 to 200 words an explanation of the three tools of financial statement analysis and the function of each.

Examine PepsiCo, Inc.’s Consolidated Balance Sheet on p. A6 in Appendix A of Financial Accounting, especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004.

Calculate the following for PepsiCo, Inc. and show your work:

The Current Ratio for 2005
The Current Ratio for 2004

Two measures of vertical analysis—for example, compute the current assets divided by total assets for each year, and express your result as a percentage

Two measures of horizontal analysis—for example, compute the total change in assets by percentage, by dividing current assets in 2005 by current assets in 2004. Compute a similar percentage for current liabilities

Examine TheCoca-Cola Company’s Consolidated Balance sheet on p. B2 in Appendix B of Financial Accounting, especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004.
Calculate the following for Coca-Cola and show your work:

The Current Ratio for 2005
The Current Ratio for 2004

Two measures of vertical analysis—for example, compute the current assets divided by total assets for each year, and express your result as a percentage

Two measures of horizontal analysis—for example, compute the total change in assets by percentage, by dividing current assets in 2005 by current assets in 2004. Compute a similar percentage for current liabilities

TUTORIAL PREVIEW
Two measures of vertical analysis—for example, compute the current assets divided by total assets for each year, and express your result as a percentage 

PepsiCo, Inc
Vertical Analysis
Item
2005
2004
Amount
%
Amount
%
Current Assets
10,454
32.94%
8,639
30.87%

File name: ACC280 week7 Checkpoint.docx File type: .docx PRICE: $20

Consider the following condensed financial statements of Secure Life, Inc. The company’s target rate of return is 12% and its WACC is 9%:

P24-23B Using ROI, RI, and EVA to evaluate investment centers

Consider the following condensed financial statements of Secure Life, Inc. The company’s target rate of return is 12% and its WACC is 9%: 

SECIRE LIFE INC.
Comparative Balance Sheet
As for December 31, 2013 and 2012
Assets                                                             2013                2012
Cash                                                                $82,000                       $50,000
Accounts receivable                                        $4,000             20,500
Supplies                                                           1,000               500
Property, Plant and equipment, net                  275,000                       180,000
Patents, net                                                      138,000                       99,000
Total assets                                                      $550,000         $350,000
Liabilities and Stockholder’s Equity
Accounts payable                                            $40,000                       $32,000
Short term notes payable                                 135,000                       45,000
Long-term notes payable                                 170,000                       125,000
Common stock, nopar                                     150,000                       130,000
Retained earnings                                            55,000             18,000
Total liabilities and stockholders’ equity                      $550,000         $350,000 

SECURE LIFE,INC
Income Statement
For the Year Ended December 31, 2013
Sales revenue                                                   $6,750,000
COGS                                                              3,200,000
Gross profit                                                     $3,550,000
Operating expenses                                          1,525,000
Operating income                                            $2,025,000
Other: Interest Expense                                                (17,000)
Income before income tax expense                 $2,008,000
Income tax expense                                         (702,800)
Net income                                                      $1,305,200 

Requirements
1. Calculate the company’s profit margin. Interpret your results.
2. Calculate the company’s asset turnover. Interpret your results.
3. Use the expanded ROI formula to confirm your results from Requirement 1.Interpret your results.
4. Calculate the company’s RI. Interpret your results.
5. Calculate the company’s EVA. Interpret your results.

P 24-23B 
TUTORIAL PREVIEW
Req. 1

Profit margin
=
Operating income
Sales

The profit margin for Secure Life is 30%.
       ($2,025,000 ÷ $6,750,000 = 0.3)

File name: Secure Life Inc.docx File type: .docx PRICE: $10

Hampton Company: The production department has been investigating possible ways to trim total production costs.

Capital Budgeting Decision

Here is Project 2:

Hampton Company: The production department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the cans instead of purchasing them. The equipment needed would cost $1,000,000, with a disposal value of $200,000, and would be able to produce 27,500,000 cans over the life of the machinery. The production department estimates that approximately 5,500,000 cans would be needed for each of the next 5 years.

The company would hire six new employees. These six individuals would be full-time employees working 2,000 hours per year and earning $15.00 per hour. They would also receive the same benefits as other production employees, 15% of wages in addition to $2,000 of health benefits.

It is estimated that the raw materials will cost 30¢ per can and that other variable costs would be 10¢ per can. Because there is currently unused space in the factory, no additional fixed costs would be incurred if this proposal is accepted.

It is expected that cans would cost 50¢ each if purchased from the current supplier. The company's minimum rate of return (hurdle rate) has been determined to be 11% for all new projects, and the current tax rate of 35% is anticipated to remain unchanged. The pricing for the company’s products as well as number of units sold will not be affected by this decision. The unit-of-production depreciation method would be used if the new equipment is purchased.

Required
1. Based on the above information and using Excel, calculate the following items for this proposed equipment purchase.
Annual cash flows over the expected life of the equipment
Payback period
Simple rate of return
Net present value
Internal rate of return
The check figure for the total annual after-tax cash flows is $271,150.

2. Would you recommend the acceptance of this proposal? Why or why not? Prepare a short, double-spaced paper in MS Word elaborating on and supporting your answer.

TUTORIAL PREVIEW
Hampton Company
Cost of new equipment
 $1,000,000
Expected life of equipment in years
5
Disposal value in 5 years
 $200,000
Life production - number of cans
27,500,000

 File name: Hampton Company.xlsx File type: .xlsx PRICE: $20