Della Valle Inc. is a company that manufactured footwear out of a factory in Kalamazoo, Michigan.

Della Valle has been in business since 2016 and sells three different types of sneakers to major retailers in the United States.

Della Valle reports its financial results on a divisional basis. Currently, the three brands of sneakers that Della Valle produces, and sells are the Smash Hit, the Air Max and the Hogan.

Della Valles financial team has been working on a cost budget modeling by division for 2019. Below is the most recent selling price and cost information for Della Valle as of the beginning of 2019.

In addition, you have been given the following information for year 2019:

• You do not have to factor in income taxes for Della Valle
• Units actually sold in 2019 by product are as follows:

Questions:

(Show all computations in Excel and write all written responses in Excel alongside the computations. You can use the Wrap Text feature at the top of your Excel menu ribbon to include your commentary):

1. For each product line in 2019:
   1. Calculate the contribution margin per unit.
   2. Calculate the contribution margin percentage.

2. Build a 2019 contribution income statement to operating income level for each of Della Valles products as well as the total company

Questions: .

1. . For each product line in 2019:
   1. Calculate the break-even (in units).
   2. Calculate the break-even (in dollars).
2. For each product line in 2019:
   1. Calculate the margin of safety (in dollars).
   2. Calculate the margin of safety in percentage for 2019.

3. What is the degree of operating leverage for each of the products for 2019?

questions:

1. Della Valle Inc. is doing financial planning for 2020:
   1. Based on the results they have calculated for 2019, how many units must Della Valle sell of each product if they want to achieve a target operating income as shown in the chart below. Calculate this for each product individually.

2. Do you think they can achieve this target profit goal on any or all of the product lines? Why or why not?

questions:

1. Based on your analysis above, should Della Valle eliminate any of its product lines in 2020?
   1. Answer from quantitative perspective using the calculations above.
   2. Answer from a qualitative perspective, what would be three things (internal or external to the company, positive or negative impacts) that could possibly be a reaction if any of the product lines were dropped.
   3. What could be done to resurrect any product line that you think should be eliminated? And if nothing can be done, why?

1. Gianfranco an engineer from MIT, approached the production managers of Della Valle Inc. and had some ideas on how to further automate the manufacturing process. Per Gianfranco if Della Valle Inc. automated its facilities with her suggestions, Della Valle would decrease the total variable costs by 20% for each product but would increase the total fixed costs of each product by 12%.
   1. If Della Valle decides to do this, what is the new break-even in units for each product? Use the 2019 historical numbers you generated for in Parts #1-5 and compare to those results (i.e., dont include the target profit into the equation).
   2. Do you recommend that Della Valle pursue this automation option with Gianfranco for any of the product lines? Where does it work and where does it seem less optimal?

1. In 2020 Della Valle Inc. has been contacted by a major retailer regarding a special order of 15,000 of the Smash hit and 5,000 of the Hogan models at a selling price of $55 for Smash Hit and $125 for Hogan.

In deciding whether or not to accept these special orders you need to consider the following:

• You can only accept an order in full you cannot take part orders of both.
• The forecast unit sales for 2020 is the following:

• Della Valle Footwear is operating at 80 percent of total capacity.
• The cost of the rubber sole is expected to increase by 20% per unit cost in 2020. The cost of Della Valle rent is expected to increase by $2 per unit cost in 2020. All the other costs are estimated to be at the same level of 2019.

Based on the above:

1. Perform an incremental analysis of each order.
2. Can Della Valle Footwear fulfill both orders as requested by the customer? Should Della Valle reject one of the orders?

Smash hit Air max Hogan $ 70.00 $ 130.00 $ 145.00 Selling price/unit Costs/unit Cloth insert Direct Labor Factory Equipment Depreciation Factory Insurance Factory Rent Glue for shoe Logos Rubber sole Shoe laces Shoe leather Shoe stiching Smash hit Air max Hogan $ 1.00 $ 5.00 $ 5.00 $ 20.00 $ 60.00 $ 50.00 $ 0.02 $ 0.04 $ 0.04 $ 0.03 $ 0.03 $ 0.03 $ 2.00 $ 2.00 $ 2.00 $ 0.01 $ 0.02 $ 0.03 $ 0.01 $ 0.03 $ 0.01 $ 5.00 $ 15.00 $ 20.00 $ 0.02 $ 0.03 $ 0.03 $ 10.00 $ 20.00 $ 30.00 $ 0.05 $ 0.15 $ 0.25 Other costs - total per MONTH: Advertising/Promotion Corporate office rent/utilities Selling General & Administrative Payroll Smash hit Air max Hogan 2,000 $ 5,000 $ 3,500 10,000 $ 10,000 $ 10,000 $ 30,000 $ 30,000 $ 30,000 Smash hit 40,000 Air max 25,000 Hogan 15,000 Total 80,000 Units sold 2019 Questions: 1 GB212 Course Project - Fall 2020 Della Valle Inc. (Show all computations in Excel and write all written responses in Excel alongside the computations. You can use the "Wrap Text feature at the top of your Excel menu ribbon to include your commentary): File Home Insert Page Layout Formulas Data Review View Tell me wha * Cut ED Copy Calibri 11 Wrap Text Paste BIU- . Merge & Center Format Painter Clipboard Font Alignment 6 Smash hit 1,500,000 $ Air max 800,000 $ Hogan 400,000 Target Profit $ Air max Smash hit 45,000 Hogan 17,000 Total 90,000 Units sales 28,000