Question

In: Accounting

Problem 3-38 (Part Level Submission) Ivanhoe Company produces a molded briefcase that is distributed to luggage...

Problem 3-38 (Part Level Submission) Ivanhoe Company produces a molded briefcase that is distributed to luggage stores. The following operating data for the current year has been accumulated for planning purposes. Sales price $42.00 Variable cost of goods sold 14.00 Variable selling expenses 12.60 Variable administrative expenses 5.00 Annual fixed expenses Overhead $28,844,400 Selling expenses 5,731,900 Administrative expenses 12,018,500 Ivanhoe can produce 5,547,000 cases a year. The projected net income for the coming year is expected to be $6,656,400. Ivanhoe is subject to a 40% income tax rate. During the planning sessions, Ivanhoe’s managers have been reviewing costs and expenses. They estimate that the company’s variable cost of goods sold will increase 15% in the coming year and that fixed administrative expenses will increase by $554,700. All other costs and expenses are expected to remain the same. Ivanhoe Company’s managers are considering expanding the product line by introducing a leather briefcase. The new briefcase is expected to sell for $92.00; variable costs would amount to $38.00 per briefcase. If Ivanhoe introduces the leather briefcase, the company will incur an additional $1,109,400 per year in advertising costs. Ivanhoe’s marketing department has estimated that one new leather briefcase would be sold for every four molded briefcases. After additional research, Ivanhoe’s marketing manager believes that if the price of the new leather briefcase drops to $68.00, it will be more attractive to potential customers. She also believes that at that price, the additional advertising cost could be cut to $656,765. These changes would result in sales of one molded briefcase for every three leather briefcases. Based on these circumstances, how many units of each briefcase would be required to break even in the coming year? (For computational purposes round contribution margin per unit to 2 decimal places, e.g. 0.38. Round answers to 0 decimal places, e.g. 25,000.)

Solutions

Expert Solution

Assume if we go with Ivanhoe's Marketing Manager suggestion (i.e.) New leather briefcase at $ 68 per unit at the ratio of 1:3 (Molded vs Leather) briefcase: here's the workings and BEP(Break Even Point) Sales would be 2,000,000 units

Description Ref Molded Briefcase Leather Briefcase Total
Sales Ratio A 1 3 4
Selling Price B                          42.00                          68.00
Variable Cost C                          33.70                          38.00
Contribution Margin (D) = (B)- ( C)                             8.30                          30.00
Weighted Average ( E) = (D) * (A)                             8.30                          90.00                     98.30
Weighted Average / Sales Ratio (F) = ( E) / (A)                     24.58
Fixed Cost (G)          47,806,265
Break Even Point Sales (BEP) (Rounded off) (G)/(F)            2,000,000
Apply sales ratio to BEP                      500,000                 1,500,000

If we go by Marketing Department suggestion (i..e) $ 92 per unit with the ratio of 4:1, here's the workings and BEP Sales would be 3,000,000 units

Description Ref Molded Briefcase Leather Briefcase Total
Sales Ratio A 4 1 5
Selling Price B                          42.00                          92.00
Variable Cost C                          33.70                          38.00
Contribution Margin (D) = (B)- ( C)                             8.30                          54.00
Weighted Average ( E) = (D) * (A)                          33.20                          54.00                 87.20
Weighted Average / Sales Ratio (F) = ( E) / (A)                 17.44
Fixed Cost (G)      48,258,900
Break Even Point Sales (BEP) (Rounded off) (G)/(F)        3,000,000
Apply sales ratio to BEP                  2,400,000                     600,000

Related Solutions

Type or paste question here Kipmar Company produces a molded briefcase that is distributed to luggage...
Type or paste question here Kipmar Company produces a molded briefcase that is distributed to luggage stores. The following operating data for the current year has been accumulated for planning purposes. Sales price $                                   80.00 Variable cost of goods sold                                       24.00 Variable selling expenses                                       21.20 Variable administrative expenses                                         6.00 Annual fixed expenses Overhead $                           7,800,000 Selling expenses                               1,550,000 Administrative expenses                               3,250,000 Kipmar can produce 1.5 million cases a year. The projected net income for the...
Kipmar Company produces a molded briefcase that is distributed to luggage stores. The following operating data...
Kipmar Company produces a molded briefcase that is distributed to luggage stores. The following operating data for the current year has been accumulated for planning purposes. Sales price $40.00 Variable cost of goods sold 12.00 Variable selling expenses 10.60 Variable administrative expenses 3.00 Annual fixed expenses    Overhead $7,800,000    Selling expenses 1,550,000    Administrative expenses 3,250,000 Kipmar can produce 1,500,000 cases a year. The projected net income for the coming year is expected to be $1,800,000. Kipmar is subject to a 40%...
Crane Company produces a molded briefcase that is distributed to luggage stores. The following operating data...
Crane Company produces a molded briefcase that is distributed to luggage stores. The following operating data for the current year has been accumulated for planning purposes. Sales price$34 Variable cost of goods sold10 Variable selling expenses9.0 Variable administrative expenses3 Annual fixed expenses   Overhead$6,396,000    Selling expenses1,353,000   Administrative expenses2,583,000 Crane can produce 1,230,000 million cases a year. The projected net income for the coming year is expected to be $1,476,000 million. Crane is subject to a 40% income tax rate. During the...
Problem 7-5A (Part Level Submission) Ivanhoe Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer...
Problem 7-5A (Part Level Submission) Ivanhoe Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2017, the company’s Cash account per its general ledger showed a balance of $6,858.90. The bank statement from Emporia State Bank on that date showed the following balance. EMPORIA STATE BANK Checks and Debits Deposits and Credits Daily Balance XXX XXX 5-31 7,088.00 A comparison of the details on the bank statement with the details in the Cash...
Problem 3-3 (Part Level Submission) A review of the ledger of Windsor, Inc. at December 31...
Problem 3-3 (Part Level Submission) A review of the ledger of Windsor, Inc. at December 31 produces the following data for the preparation of annual adjusting entries: 1. Salaries and Wages Payable, $0. There are 9 salaried employees. 4 employees receive a salary of $1,230 each per week, and 5 employees earn $750 each per week. Employees do not work weekends. All employees worked two days after the last pay period and before December 31. 2. Unearned Rent Revenue, $376,020....
Problem 3-9 (Part Level Submission) Presented below is the trial balance of the Pearl Golf Club,...
Problem 3-9 (Part Level Submission) Presented below is the trial balance of the Pearl Golf Club, Inc. as of December 31. The books are closed annually on December 31. PEARL GOLF CLUB, INC. TRIAL BALANCE DECEMBER 31 Debit Credit Cash $15,320 Accounts Receivable 17,500 Allowance for Doubtful Accounts $1,100 Prepaid Insurance 9,180 Land 369,300 Buildings 150,000 Accumulated Depreciation-Buildings 48,000 Equipment 190,400 Accumulated Depreciation-Equipment 88,853 Common Stock 436,800 Retained Earnings 128,788 Dues Revenue 194,600 Green Fees Revenue 6,429 Rent Revenue 16,500...
Problem 7-3 (Part Level Submission) Pearl Corporation operates in an industry that has a high rate...
Problem 7-3 (Part Level Submission) Pearl Corporation operates in an industry that has a high rate of bad debts. Before any year-end adjustments, the balance in Pearl's Accounts Receivable account was $595,600 and Allowance for Doubtful Accounts had a credit balance of $40,350. The year-end balance reported in the balance sheet for Allowance for Doubtful Accounts will be based on the aging schedule shown below. Days Account Outstanding Amount Probability of Collection Less than 16 days $314,500 0.97 Between 16...
Can you solve B only Problem 20-3 (Part Level Submission) Kingbird Company sponsors a defined benefit...
Can you solve B only Problem 20-3 (Part Level Submission) Kingbird Company sponsors a defined benefit plan for its 100 employees. On January 1, 2017, the company’s actuary provided the following information. Accumulated other comprehensive loss (PSC)                    $149,300 Pension plan assets (fair value and market-related asset value)                 197,200 Accumulated benefit obligation                                255,900 Projected benefit obligation                       387,500 The average remaining service period for the participating employees is 10 years. All employees are expected to receive benefits under the plan. On December...
Problem 3-2A (Video) (Part Level Submission) Rosenthal Company manufactures bowling balls through two processes: Molding and...
Problem 3-2A (Video) (Part Level Submission) Rosenthal Company manufactures bowling balls through two processes: Molding and Packaging. In the Molding Department, the urethane, rubber, plastics, and other materials are molded into bowling balls. In the Packaging Department, the balls are placed in cartons and sent to the finished goods warehouse. All materials are entered at the beginning of each process. Labor and manufacturing overhead are incurred uniformly throughout each process. Production and cost data for the Molding Department during June...
Problem 10-39A (Part Level Submission) The controller of Harrington Company estimates sales and production for the...
Problem 10-39A (Part Level Submission) The controller of Harrington Company estimates sales and production for the first four months of 2016 as follows: January February March April Sales $33,000 $43,300 $53,200 $24,000 Production in units 1,050 1,560 2,180 2,620 Sales are 40% cash and 60% on account, and 60% of credit sales are collected in the month of the sale. In the month after the sale, 40% of credit sales are collected. It takes 4 kg of direct material to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT