Question

In: Accounting

Collegiate Canvas Co. currently makes and sells two models of a backpack. Data applicable to the...

Collegiate Canvas Co. currently makes and sells two models of a backpack. Data applicable to the current operation are summarized in the following columns labeled Current Operation. Management is considering adding a Value model to its current Luxury and Economy models. Expected data if the new model is added are shown in the following columns labeled Proposed Expansion:

Current Operation Proposed Expansion
Luxury Economy Luxury Economy Value
Selling price per unit $ 23 $ 15 $ 23 $ 15 $ 15
Variable expenses per unit 9.2 7.5 9.2 7.5 8.5
Annual sales volume-units 10,500 20,500 6,500 18,500 8,000
Fixed expenses for year Total of $74,000 Total of $83,000

Required:

a. Calculate the company's current total contribution margin and the current average contribution margin ratio.

b. Calculate the company’s current amount of operating income.

c. Calculate the company's current break-even point in dollar sales. (Do not round intermediate calculations.)

d. State why the company might incur a loss, even if the sales amount calculated in part c was achieved and selling prices and costs didn't change.

Because sales mix might change.
Because of increase in tax sale.
Because fixed cost might exceed total contribution.

e. Calculate the company's total operating income under the proposed expansion.

f. Based on the proposed expansion data, would you recommend adding the Value model?

No
Yes

g. Would your answer to part f change if the Value model sales volume were to increase to 8,400 units annually and all other data remained the same?

No
Yes

Solutions

Expert Solution

a) Income Statement ;-

Particulars Luxury Economy Total
Sales Volume (a) 10500 20500
Selling Price Per Unit $23 $15
Less : Variable Cost Per Unit ($9.2) ($7.5)
Contribution Per Unit (b) $13.8 $7.5
Contribution Margin in Dollar (a*b) $144900 $153750 $298650
Less : Fixed Cost ($74000)
Operating Income $224650

Total Contribution Margin = $298650

Average Contribution Margin Ratio = $298650 / (($23*10500)+($15*20500))

= $298650 / $549000

= 54.4%

b) Operating Income = Contribution - Fixed Cost

= $298650 - $74000

= $224650

c) Break Even Point in Dollar Sales :-

= Fixed Cost / Comtibution Margin Ratio

= $74000 / 54.4%

= $136029

d) The Company might incur a loss, Because Sales Mix might Change.

e) Income Statement ;-

Particulars Luxury Economy Value Total
Sales (Selling Price * Sales Volume) $149500 $277500 $120000 $547000
Less : Variable Cost (Variable Cost * Sales Volume) $59800 $138750 $68000 ($266550)
Contribution Margin $89700 $138750 $52000 $280450
Less : Fixed Cost ($83000)
Operating Income $197450

f. No, Because Operating Income Reduce by $27200. ($224650-$197450)

g. No, Because Increase Operating Income by $2600 ($6.5*400). But Operating Income Reduce by $27200 after add Value Model.


Related Solutions

XYZ Manufacturing makes two models of office chairs: regular and deluxe. Summary data for the two...
XYZ Manufacturing makes two models of office chairs: regular and deluxe. Summary data for the two products showed the following: Unit Costs                                                              Regular    Deluxe       Direct materials                                                        $65.00           $105.00       Direct labour ($20 per hour)                                      10.00                 20.00       Manufacturing overhead*                                           4.80                   9.60 * Under the company's current costing, manufacturing overhead is allocated on the basis of direct labour-hours. The overhead for the year follows:       Materials handling                                               $   300,000       Setups                                                                        400,000       General...
XYZ Manufacturing makes two models of beach chairs: regular and deluxe. Summary data for the two...
XYZ Manufacturing makes two models of beach chairs: regular and deluxe. Summary data for the two products showed the following: Unit Costs Regular Deluxe Direct Materials $65.00 $105.00 Direct Labor($20/hour) 10.00 20.00 Manufacturing Overhead* 4.80 9.60 * Under the company's current costing, manufacturing overhead is allocated on the basis of direct labour hours. The overhead for the year follows: Materials handling $ 300,000 Setups 400,000 General factory overhead 500,000 Total $1,200,000 The following table presents the activity levels that relate...
Norwegian Furniture Manufacturing makes two models of office chairs: regular and deluxe. Summary data for the...
Norwegian Furniture Manufacturing makes two models of office chairs: regular and deluxe. Summary data for the two products showed the following: Unit Costs                                                              Regular           Deluxe       Direct materials                                                        $65.00          $105.00       Direct labour ($20 per hour)                                     10.00                20.00       Manufacturing overhead*                                           4.80                  9.60 * Under the company's current costing, manufacturing overhead is allocated on the basis of direct labour-hours. The overhead for the year follows:       Materials handling                                                $   300,000       Setups                                                                        400,000      ...
Broadway Company produces and sells two models of calculators. The following monthly data are provided: Standard...
Broadway Company produces and sells two models of calculators. The following monthly data are provided: Standard Premium Unit selling price $ 100 $ 150 Unit variable manufacturing cost $ 60 $ 90 Unit variable selling and administrative cost $ 15 $ 30 Number of units produced and sold 3,000 1,000 Total monthly fixed costs are expected to be $15,000. What is the break-even point in sales dollars at the expected sales mix? (Do not round your intermediate calculations.) $19,231 $43,478...
Benson Company makes and sells lawn mowers for which it currently makes the engines. It has...
Benson Company makes and sells lawn mowers for which it currently makes the engines. It has an opportunity to purchase the engines from a reliable manufacturer. The annual costs of making the engines are shown here. Cost of materials (14,900 Units × $21) $ 312,900 Labor (14,900 Units × $23) 342,700 Depreciation on manufacturing equipment* 40,000 Salary of supervisor of engine production 65,000 Rental cost of equipment used to make engines 21,000 Allocated portion of corporate-level facility-sustaining costs 78,000 Total...
Wally’s Widget World is an online retailer that makes and sells widgets. There are three models...
Wally’s Widget World is an online retailer that makes and sells widgets. There are three models of widgets, each with its own cost of materials and labor. Model Percent of sales Materials cost Labor cost Selling price Econowidget – base-level widget for the budget-conscious widget user 35% $3.50 $1.50 $6.99 Superwidget – adds additional feature for the more demanding widget user 45% $4.00 $1.75 $8.99 Widget Supreme – for the more discerning and sophisticated widget user 20% $5.25 $2.00 $11.99...
A manufacturing business makes a product in two models. M1 and M2. Details of the two...
A manufacturing business makes a product in two models. M1 and M2. Details of the two products are as follows:                                                                                                              M1                           M2 Annual sales                                                                                  8,000 units               8,000 units Number of sales orders                                                                         60                           250 Sales price per unit                                                                              ₵54                          ₵73 Direct material cost per unit                                                                 ₵11                           ₵21 Direct labour hours per unit                                                                2.0 hours                2.5 units Direct labour rate per hour                                                                     ₵8                           ₵8 Special parts per unit                                                                              2                                8 Production batch size                                                                        2,000 units              100 units Set-ups per batch                                                                                   ...
A manufacturing business makes a product in two models. M1 and M2. Details of the two...
A manufacturing business makes a product in two models. M1 and M2. Details of the two products are as follows:                                                                                                              M1                           M2 Annual sales                                                                                  8,000 units               8,000 units Number of sales orders                                                                         60                           250 Sales price per unit                                                                              ₵54                          ₵73 Direct material cost per unit                                                                 ₵11                           ₵21 Direct labour hours per unit                                                                2.0 hours                2.5 units Direct labour rate per hour                                                                     ₵8                           ₵8 Special parts per unit                                                                              2                                8 Production batch size                                                                        2,000 units              100 units Set-ups per batch                                                                                   ...
The following is a summary of the May 2016 operations of Reagan Company that makes and sells airplane models.
  The following is a summary of the May 2016 operations of Reagan Company that makes and sells airplane models. Suppose that the company uses the FIFO method.   Physical Units Direct Materials Conversion Costs WIP, beginning inventory 28,000 $39,200 $30,800      Degree of completion for BI   100% 25% Started in May 60,000     Completed and transferred out in May 66,000     WIP, ending inventory 22,000          Degree of completion for EI   100% 50%...
Explain the differences among hierarchical, network, and relational data models. What makes the relational data model...
Explain the differences among hierarchical, network, and relational data models. What makes the relational data model the most popular data model in use today? (DQ 4-1)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT