Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Using the data and sales mix provided for 2019 answer the following questions: a. How many total cases would Alex need to sell in

1. Using the data and sales mix provided for 2019 answer the following questions:

a. How many total cases would Alex need to sell in order to earn $75,000 operating income?

b. What is the percentage increase in the total cases over the 2019 data if the desired operating income is $75,000?

c. How many of these cases would be Nastro Blue Pilsner (assume that sales mix remains the same)?

image text in transcribedimage text in transcribed

Perone Pale Nastro Blue Menabrea Ale Moretti Bock Pilsner Stout $ 20.00 $ 23.50 $ 22.75 $ 25.50 Total Sales Price per case Direct Materials per case Direct Labor per case Other Variable Costs per case Total Variable costs per case Contribution Margin per Case $ $ $ 2.50 $ 3.45 $ 5.75 $ 11.70 8.30 $ 2.40 $ 3.45 $ 5.68 $ 11.53 2.65 $ 3.00 $ 5.80 $ 11.45 3.25 4.95 6.34 14.54 $ 11.97 $ 11.30 $ 10.96 Number of cases sold 12,695 7,220 6,950 4,185 31,050 0.23 0.23 0.20 0.33 Direct Labor Hours (DLH) per case Total DLH 2,919.85 1,660.60 1,390.00 1,381.05 7,351.50 0.38 Machine Hours (MH) per case Total MH 0.19 2,412.05 0.24 1,668.00 0.29 1,213.65 2,743.60 8,037.30 Contribution Margin Income Statement: Total Sales Revenue Total Variable Costs Contribution Margin Direct Fixed Costs Segment Margin Common Fixed Costs Perone Pale Nastro Blue Menabrea Ale Moretti Bock Pilsner Stout Total $ 253,900.00 $ 169,670.00 $ 158,112.50 $ 106,717.50 $ 688,400.00 148,531.50 83,246.60 79,577.50 60,849.90 372,205.50 105,368.50 86,423.40 78,535.00 45,867.60 316,194.50 10,329.62 8,392.91 6,017.39 9,893.92 34,633.84 $ 95,038.88 $ 78,030.49 $ 72,517.61 $ 35,973.68 $ 281,560.66 $ 245,389.44 $ 36,171.22 Operating Income Perone Pale Nastro Blue Menabrea Ale Moretti Bock Pilsner Stout $ 20.00 $ 23.50 $ 22.75 $ 25.50 Total Sales Price per case Direct Materials per case Direct Labor per case Other Variable Costs per case Total Variable costs per case Contribution Margin per Case $ $ $ 2.50 $ 3.45 $ 5.75 $ 11.70 8.30 $ 2.40 $ 3.45 $ 5.68 $ 11.53 2.65 $ 3.00 $ 5.80 $ 11.45 3.25 4.95 6.34 14.54 $ 11.97 $ 11.30 $ 10.96 Number of cases sold 12,695 7,220 6,950 4,185 31,050 0.23 0.23 0.20 0.33 Direct Labor Hours (DLH) per case Total DLH 2,919.85 1,660.60 1,390.00 1,381.05 7,351.50 0.38 Machine Hours (MH) per case Total MH 0.19 2,412.05 0.24 1,668.00 0.29 1,213.65 2,743.60 8,037.30 Contribution Margin Income Statement: Total Sales Revenue Total Variable Costs Contribution Margin Direct Fixed Costs Segment Margin Common Fixed Costs Perone Pale Nastro Blue Menabrea Ale Moretti Bock Pilsner Stout Total $ 253,900.00 $ 169,670.00 $ 158,112.50 $ 106,717.50 $ 688,400.00 148,531.50 83,246.60 79,577.50 60,849.90 372,205.50 105,368.50 86,423.40 78,535.00 45,867.60 316,194.50 10,329.62 8,392.91 6,017.39 9,893.92 34,633.84 $ 95,038.88 $ 78,030.49 $ 72,517.61 $ 35,973.68 $ 281,560.66 $ 245,389.44 $ 36,171.22 Operating Income

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Stability Economic Growth And The Role Of Law

Authors: Douglas W. Arner

1st Edition

0521690560, 978-0521690560

More Books

Students also viewed these Finance questions