Our products are sold in two (2) serving sizes: 12-ounce aluminum cans and 20-ou
ID: 462830 • Letter: O
Question
Our products are sold in two (2) serving sizes: 12-ounce aluminum cans and 20-ounce plastic bottles. Both stock keeping units (SKUs) are sold to customers in cases of 24 units. We produce only one flavor, “Konway Kola”. No diet products are produced. We pay delivery charges to our customers.
We employ 18 workers; 12 hourly and 6 salaried.
Average hourly pay = $10.80. Annual salaries average $34,500 per person.
Our business operations plan is based upon 240 days per year.
Each production shift is scheduled to operate 8 hours.
Annual Sales Forecast:
12-oz. cans = 960,000 cases of 24
20-oz. bottles = 576,000 cases of 24
Operating Budget:
Buildings = $1,200,000 purchase, ten (10) year depreciation
Equipment = $600,000 purchase, five (5) year depreciation
Maintenance = $60,000 per year
Energy = $2,000 per shift
Benefits = 40% of total wages and salaries combined
Marketing = $40,000 per year
Administration & General = $300,000 per year
Ingredient cost per case = $.72/12 oz.; $1.20/20 oz.
Packaging cost per case = $.72/12 oz.; $1.10/20 oz.
Warehousing = $180,000 per year
Delivery Charges = $0.325 per case of 12 ounce cans; $0.490 per case of 20 ounce bottles
Production Schedule:
12 ounce = 8,000 cases per shift
20 ounce = 4,800 cases per shift
Overhead includes: Building and equipment depreciation, employee benefits, marketing, administration & general, maintenance, energy, and warehousing (delivery cost is not included)
Production mix: We plan to pack only one (1) of the two (2) SKUs (either 12 ounce cans or 20 ounce bottles) per 8 hour shift. A total of 240 shifts are required to produce the annual requirements for both sizes combined.
Questions for you to answer:
1. How many shifts are required to produce the annual sales forecast for each SKU; 12 ounce and 20 ounce?
2. What is the total cost per case for each SKU? Break down costs into ingredients, packaging, overhead and labor. Work your answers out to three (3) places to the right of the decimal point.
3. What must the KKK selling price be per case (including delivery charges) for each of the SKUs in order to yield a 25% gross margin on sales dollars? Round up to next whole penny per case.
4. Assuming a 22% profit margin on the retailer’s selling prices, what will be the shelf price for one 12 ounce can and for one 20 ounce bottle? Round up to next whole penny per can or bottle.
5. How might we increase our production capacity?
6. How might we reduce our costs?
7. Do the retail prices per unit look attractive to you?
KKK selling price calculation for 25% profit margin:
Total production cost per case + delivery charges/ (1 - .25)
*** Round up to next highest penny
KKK selling price per case of 24 twelve ounce cans =
KKK selling price per case of 24 twenty ounce bottles =
Retail shelf price per unit calculation for 22% retailer profit margin:
KKK delivered price/ (1.00 - .22)/24 units
Calculate for both sizes
*** Round up to next highest penny
Retail price for one 12 oz. can =
Retail price for one 20 oz. bottle =
Explanation / Answer
1) Number of shifts required to produce annual sales forecast -
Annual forecast for 12 oz cans - 960,000 cases of 24
Annual forecast for 20 oz bottles - 576,000 cases of 24
12 ounce = 8000 cases per shift
20 ounce = 4800 cases per shift
Number of shifts for 12 oz cans = 960,000/8000 = 120 shifts
Number of shifts for 20 oz bottles = 576,000/4800 = 120 shifts
120 shifts means 120 days
2) Total cost per case
For 12 oz :
Ingredient cost per case = $.72
For all the cases = 960,000 x 0.72 = 691,200
packaging cost per case = $0.72
For all the cases = 960,000 x 0.72 = 691,200
For 20 oz
Ingredient cost per case = $1.20 = 576,000 x 1.20 = 691,200
Packing cost per case = $1.10 = 576,000 x 1.10 = 633,600
Overhead costs = Nill (Since 120 shifts are required each for making both the varients. It means 240 working days and total working days are 240)
Labor cost : on hourly basis = 8 x $10.80 = $86.4 per day
= for 240 days = $20,736 (per person)
= 20,736 x 12 = $248,832 (for 12 people)
salaried = 6 x 34,500 = $207,000 (for 6 people)
Total salaries = $455,832
For 12 oz - Total salaries + total ingredient cost + total packaging costs = $455,832 + 691,200 + 691,200
= $1,838,232
For 960,000 cases = 1,838,232 / 960,000 = $1.91
For 20oz - $455,832 + 691,200 + 633,600 = 1,780,632
for 576,000 cases = 1,780,632 / 576,000 = $3.09
3) with 25% gross margin on sales dollars including delivery charges
For 12 oz = 960,000 x 1.91 = 1,833,600
Delivery charges = 0.325 x 960,000 = 312,000
25% margin = 2,145,600 x 25% = $2.793 = $3 (rounded)
For 20 oz = 576,000 x 3.09 = 1,779,840
Delivery charges = 0.490 x 576,000 = 282,240
25% margin = 2,062,080 x 25% = $4.471 = $5 (rounded)
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.