Assignment: Managerial Accounting
Instructions:
Complete the following activities in good form. Use excel or word only. Provide all supporting calculations to show how you arrived at your numbers
Part I: Changes in Fixed and Variable Costs; Break-Even and Target
Profit Analysis Neptune Company produces toys and other items for use in beach and resort areas. A small, inflatable toy has come onto the market that the company is anxious to produce and sell. The new toy will sell for $2.80 per unit. Enough capacity exists in the company's plant to produce 30,300 units of the toy each month. Variable expenses to manufacture and sell one unit would be $1.78, and fixed expenses associated with the toy would total $45,859 per month.
The company's Marketing Department predicts that demand for the new toy will exceed the 30,300 units that the company is able to produce. Additional manufacturing space can be rented from another company at a fixed expense of $2,293 per month. Variable expenses in the rented facility would total $1.96 per unit, due to somewhat less efficient operations than in the main plant.
Required:
i. What is the monthly break-even point for the new toy in unit sales and dollar sales.
ii. How many units must be sold each month to attain a target profit of $10,752 per month?
iii. If the sales manager receives a bonus of 20 cents for each unit sold in excess of the break-even point, how many units must be sold each month to attain a target profit that equals a 24% return on the monthly investment in fixed expenses?
(For all requirements, Round "per unit" to 2 decimal places, intermediate and final answers to the nearest whole number.)
Part II: CVP Applications; Contribution Margin Ratio; Break-Even
Analysis; Cost Structure
Due to erratic sales of its sole product-a high-capacity battery for laptop computers-
PEM, Inc., has been experiencing financial difficulty for some time. The company's contribution format income statement for the most recent month is given below:
Sales (12,500 units × $30 per unit) $ 375,000
Variable expenses 187,500
Contribution margin 187,500
Fixed expenses 210,000
Net operating loss $ (22,500 )
Required:
i. Compute the company's CM ratio and its break-even point in unit sales and dollar sales.
ii. The president believes that a $6,700 increase in the monthly advertising budget, combined with an intensified effort by the sales staff, will result in an $85,000 increase in monthly sales. If the president is right, what will be the increase (decrease) in the company's monthly net operating income?
iii. Refer to the original data. The sales manager is convinced that a 10% reduction in the selling price, combined with an increase of $35,000 in the monthly advertising budget, will double unit sales. If the sales manager is right, what will be the revised net operating income (loss)?
iv. Refer to the original data. The Marketing Department thinks that a fancy new package for the laptop computer battery would grow sales. The new package would increase packaging costs by $0.60 per unit. Assuming no other changes, how many units would have to be sold each month to attain a target profit of $4,800?
v. Refer to the original data. By automating, the company could reduce variable expenses by $3 per unit. However, fixed expenses would increase by $53,000 each month.
o Compute the new CM ratio and the new break-even point in unit sales and dollar sales.
o Assume that the company expects to sell 20,300 units next month. Prepare two contribution format income statements, one assuming that operations are not automated and one assuming that they are. (Show data on a per unit and percentage basis, as well as in total, for each alternative.)
o Would you recommend that the company automate its operations (Assuming that the company expects to sell 20,300)?
Part III: Relevant Cost/Special Order Decisions
Polaski Company manufactures and sells a single product called a Ret. Operating at capacity, the company can produce and sell 30,000 Rets per year. Costs associated with this level of production and sales are given below:
Unit Total
Direct materials $ 15 $ 450,000
Direct labor 8 240,000
Variable manufacturing overhead 3 90,000
Fixed manufacturing overhead 9 270,000
Variable selling expense 4 120,000
Fixed selling expense 6 180,000
Total cost $ 45 $ 1,350,000
The Rets normally sell for $50 each. Fixed manufacturing overhead is $270,000 per year within the range of 25,000 through 30,000 Rets per year.
Required:
i. Assume that due to a recession, Polaski Company expects to sell only 25,000 Rets through regular channels next year. A large retail chain has offered to purchase 5,000 Rets if Polaski is willing to accept a 16% discount off the regular price. There would be no sales commissions on this order; thus, variable selling expenses would be slashed by 75%. However, Polaski Company would have to purchase a special machine to engrave the retail chain's name on the 5,000 units. This machine would cost $10,000.
Polaski Company has no assurance that the retail chain will purchase additional units in the future. What is the financial advantage (disadvantage) of accepting the special order?
ii. Refer to the original data. Assume again that Polaski Company expects to sell only 25,000 Rets through regular channels next year. The U.S. Army would like to make a one-time-only purchase of 5,000 Rets. The Army would pay a fixed fee of $1.80 per Ret, and it would reimburse Polaski Company for all costs of production (variable and fixed) associated with the units. Because the army would pick up the Rets with its own trucks, there would be no variable selling expenses associated with this order. What is the financial advantage (disadvantage) of accepting the U.S. Army's special order?
iii. Assume the same situation as described in (2) above, except that the company expects to sell 30,000 Rets through regular channels next year. Thus, accepting the U.S. Army's order would require giving up regular sales of 5,000 Rets. Given this new information, what is the financial advantage (disadvantage) of accepting the U.S. Army's special order?
Part IV: Relevant Cost/Make or Buy Decision
Silven Industries, which manufactures and sells a highly successful line of summer lotions and insect repellents, has decided to diversify in order to stabilize sales throughout the year. A natural area for the company to consider is the production of winter lotions and creams to prevent dry and chapped skin.
After considerable research, a winter products line has been developed. However, Silven's president has decided to introduce only one of the new products for this coming winter. If the product is a success, further expansion in future years will be initiated.
The product selected (called Chap-Off) is a lip balm that will be sold in a lipstick-type tube. The product will be sold to wholesalers in boxes of 24 tubes for $14 per box.
Because of excess capacity, no additional fixed manufacturing overhead costs will be incurred to produce the product. However, a $130,000 charge for fixed manufacturing overhead will be absorbed by the product under the company's absorption costing system.
Using the estimated sales and production of 130,000 boxes of Chap-Off, the Accounting
Department has developed the following manufacturing cost per box:
Direct material $ 5.80
Direct labor 4.20
Manufacturing overhead 2.50
Total cost $ 12.50
The costs above relate to making both the lip balm and the tube that contains it. As an alternative to making the tubes for Chap-Off, Silven has approached a supplier to discuss the possibility of buying the tubes. The purchase price of the supplier's empty tubes would be $1.95 per box of 24 tubes. If Silven Industries stops making the tubes and buys them from the outside supplier, its direct labor and variable manufacturing overhead costs per box of Chap-Off would be reduced by 10% and its direct materials costs would be reduced by 20%.
Required:
i. If Silven buys its tubes from the outside supplier, how much of its own Chap-Off manufacturing costs per box will it be able to avoid? (Hint: You need to separate the manufacturing overhead of $2.50 per box that is shown above into its variable and fixed components to derive the correct answer.)
ii. What is the financial advantage (disadvantage) per box of Chap-Off if Silven buys its tubes from the outside supplier?
iii. What is the financial advantage (disadvantage) in total (not per box) if Silven buys 130,000 boxes of tubes from the outside supplier?
iv. Should Silven Industries make or buy the tubes?
v. What is the maximum price that Silven should be willing to pay the outside supplier for a box of 24 tubes?
vi. Instead of sales of 130,000 boxes of tubes, revised estimates show a sales volume of 161,000 boxes of tubes. At this higher sales volume, Silven would need to rent extra equipment at a cost of $51,000 per year to make the additional 31,000 boxes of tubes.
Assuming that the outside supplier will not accept an order for less than 161,000 boxes of tubes, what is the financial advantage (disadvantage) in total (not per box) if Silven buys 161,000 boxes of tubes from the outside supplier? Given this new information, should Silven Industries make or buy the tubes?
vii. Refer to the data in above. Assume that the outside supplier will accept an order of any size for the tubes at a price of $1.95 per box. How many boxes of tubes should Silven make? How many boxes of tubes should it buy from the outside supplier?
Part V: Relevant Cost/Sell or Process Further
Come-Clean Corporation produces a variety of cleaning compounds and solutions for both industrial and household use. While most of its products are processed independently, a few are related, such as the company's Grit 337 and its Sparkle silver polish.
Grit 337 is a coarse cleaning powder with many industrial uses. It costs $1.60 a pound to make, and it has a selling price of $6.80 a pound. A small portion of the annual production of Grit 337 is retained in the factory for further processing. It is combined with several other ingredients to form a paste that is marketed as Sparkle silver polish.
The silver polish sells for $5.00 per jar.
This further processing requires one-fourth pound of Grit 337 per jar of silver polish. The additional direct variable costs involved in the processing of a jar of silver polish are:
Other ingredients $ 0.60
Direct labor 1.40
Total direct cost $ 2.00
Overhead costs associated with processing the silver polish are:
Variable manufacturing overhead cost 25 % of direct labor cost
Fixed manufacturing overhead cost (per month)
Production supervisor $ 3,200
Depreciation of mixing equipment $ 1,500
The production supervisor has no duties other than to oversee production of the silver polish. The mixing equipment is special-purpose equipment acquired specifically to produce the silver polish. It can produce up to 6,500 jars of polish per month. Its resale value is negligible and it does not wear out through use.
Advertising costs for the silver polish total $3,800 per month. Variable selling costs associated with the silver polish are 5% of sales.
Due to a recent decline in the demand for silver polish, the company is wondering whether its continued production is advisable. The sales manager feels that it would be more profitable to sell all of the Grit 337 as a cleaning powder.
Required:
i. How much incremental revenue does the company earn per jar of polish by further processing Grit 337 rather than selling it as a cleaning powder? (Round your answer to 2 decimal places.)
ii. How much incremental contribution margin does the company earn per jar of polish by further processing Grit 337 rather than selling it as a cleaning powder? (Round your intermediate calculations and final answer to 2 decimal places.)
iii. How many jars of silver polish must be sold each month to exactly offset the avoidable fixed costs incurred to produce and sell the polish? (Round your intermediate calculations to 2 decimal places.)
iv. If the company sells 8,700 jars of polish, what is the financial advantage (disadvantage) of choosing to further process Grit 337 rather than selling is as a cleaning powder? (Enter any "disadvantages" as a negative value. Round your intermediate calculations to 2 decimal places.)
v. If the company sells 10,900 jars of polish, what is the financial advantage (disadvantage) of choosing to further process Grit 337 rather than selling is as a cleaning powder? (Enter any "disadvantages" as a negative value. Round your intermediate calculations to 2 decimal places.)
Part VI: Relevant Cost/Shutting Down or Continuing to Operate a Plant
Birch Company normally produces and sells 43,000 units of RG-6 each month. The selling price is $20 per unit, variable costs are $10 per unit, fixed manufacturing overhead costs total $160,000 per month, and fixed selling costs total $38,000 per month.
Employment-contract strikes in the companies that purchase the bulk of the RG-6 units have caused Birch Company's sales to temporarily drop to only 9,000 units per month.
Birch Company estimates that the strikes will last for two months, after which time sales of RG-6 should return to normal. Due to the current low level of sales, Birch Company is thinking about closing down its own plant during the strike, which would reduce its fixed manufacturing overhead costs by $48,000 per month and its fixed selling costs by 10%.
Start-up costs at the end of the shutdown period would total $13,000. Because Birch
Company uses Lean Production methods, no inventories are on hand.
Required:
i. What is the financial advantage (disadvantage) if Birch closes its own plant for two months?
ii. Should Birch close the plant for two months?
iii. At what level of unit sales for the two-month period would Birch Company be indifferent between closing the plant or keeping it open?
Format your assignment according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.