Pratt, Inc. roasts premium, organic coffee for high-end restaurants. They have t
ID: 2540305 • Letter: P
Question
Pratt, Inc. roasts premium, organic coffee for high-end restaurants. They have three major blends of coffee from the following origins; Ecuador, Peru, and Kenya. They sell the coffee in 10 pound bags and had the following sales prices and volume of sales last year:e Type of coffee Ecuador = Peru Kenya Sales price $23.00 / bag S 24.50 /bag S27.25 /bag Sales volume 60,000 bagse 100,000 bags 40,000 bags Each bag of coffee requires 12.5 pounds of green coffee beans (unroasted). The roasting process strips away additional moisture, leaving 10 pounds as the end product. Last year, Pratt paid the following prices for green (raw) coffee beans and required the following labor hours for roasting one 10 pound bag of coffee (Pratt pays $17/hour for roasting): Type of coffee Ecuador Peru Kenya Price of beans Roasting hours /bage S 0.75 / pound 0.5 hours S0.85 / pound 0.75 hour; S0.65/ pound0.75 hour # After roasting the beans, Pratt then packages each 10 pound bag in its signature paper bags, which cost $0.75 per bag. The packaging process is handled by a packaging machine which Pratt rents for S 55,000 per year. During the last year, Pratt also incurred the following expenses: Amount Comments S 85,000 Paid by salary Type of expense President's Salary Quality control personnelS 68,000 Paid by salary Utilities Insurance Facility rent Advertising S 29 500l See comments below ( S 12,000Paid annually $115,000 Paid annually 35.000 See contractual terms below () Utilities- Management ran a linear regression for the past five years of utilities expenses (dependent variable) regressed against sales dollars (independent variable). The adjusted R 0.05Explanation / Answer
Particulars
Unit
Ecuador
Peru
Kenya
Total
Quantity
Rate
Value ($)
Quantity
Rate
Value ($)
Quantity
Rate
Value ($)
Value ($)
Sales (A)
Bag
60,000
23.00
$ 13,80,000.00
1,00,000
24.50
$ 24,50,000.00
40,000
27.25
$ 10,90,000.00
$ 49,20,000.00
Sales Mix %
28%
50%
22%
Cost of Unroasted green coffee Beans (per bag X 12.5 pound) including normal loss during roasting period
Pound
7,50,000
0.75
$ 5,62,500.00
12,50,000
0.85
$ 10,62,500.00
5,00,000
0.65
$ 3,25,000.00
$ 19,50,000.00
Direct Labour for roasting activity
Hours (Note 1)
37,500
17.00
$ 6,37,500.00
93,750
17.00
$ 15,93,750.00
37,500
17.00
$ 6,37,500.00
$ 28,68,750.00
Packaging Material
Bags
60,000
0.75
$ 45,000.00
1,00,000
0.75
$ 75,000.00
40,000
0.75
$ 30,000.00
$ 1,50,000.00
Renting of Packing Machine (Allocated based on no of bags packed)
$ 16,500.00
$ 27,500.00
$ 11,000.00
$ 55,000.00
Cost of Goods Sold (B)
$ 12,61,500.00
$ 27,58,750.00
$ 10,03,500.00
$ 50,23,750.00
Contribution (C=A-B)
$ 1,18,500.00
-$ 3,08,750.00
$ 86,500.00
-$ 1,03,750.00
Contribution Marging %
9%
-13%
8%
-2%
Selling & General Overheads
President's Salary
$ 85,000.00
Quality Control Personnel
$ 68,000.00
Utilities
$ 29,500.00
Insurance
$ 12,000.00
Facilities Rent
$ 1,15,000.00
Advertising
$ 35,000.00
Total SG&A (D)
$ 3,44,500.00
Operating Profit (E=C-D)
-$ 4,48,250.00
Note 1. Labour Hour Calculation
Ecuador
Peru
Kenya
Unroasted Coffee (Pound)
7,50,000
12,50,000
5,00,000
Bags (Unroasted Coffee benas weight/10 pound)
75,000
1,25,000
50,000
Roasting Hours per bag
0.50
0.75
0.75
Total Hours Required
37,500
93,750
37,500
Pratt need to change sales mix to attain break-even and profit
Particulars
Unit
Ecuador
Peru
Kenya
Total
Quantity
Rate
Value ($)
Quantity
Rate
Value ($)
Quantity
Rate
Value ($)
Value ($)
Sales (A)
Bag
60,000
23.00
$ 13,80,000.00
1,00,000
24.50
$ 24,50,000.00
40,000
27.25
$ 10,90,000.00
$ 49,20,000.00
Sales Mix %
28%
50%
22%
Cost of Unroasted green coffee Beans (per bag X 12.5 pound) including normal loss during roasting period
Pound
7,50,000
0.75
$ 5,62,500.00
12,50,000
0.85
$ 10,62,500.00
5,00,000
0.65
$ 3,25,000.00
$ 19,50,000.00
Direct Labour for roasting activity
Hours (Note 1)
37,500
17.00
$ 6,37,500.00
93,750
17.00
$ 15,93,750.00
37,500
17.00
$ 6,37,500.00
$ 28,68,750.00
Packaging Material
Bags
60,000
0.75
$ 45,000.00
1,00,000
0.75
$ 75,000.00
40,000
0.75
$ 30,000.00
$ 1,50,000.00
Renting of Packing Machine (Allocated based on no of bags packed)
$ 16,500.00
$ 27,500.00
$ 11,000.00
$ 55,000.00
Cost of Goods Sold (B)
$ 12,61,500.00
$ 27,58,750.00
$ 10,03,500.00
$ 50,23,750.00
Contribution (C=A-B)
$ 1,18,500.00
-$ 3,08,750.00
$ 86,500.00
-$ 1,03,750.00
Contribution Marging %
9%
-13%
8%
-2%
Selling & General Overheads
President's Salary
$ 85,000.00
Quality Control Personnel
$ 68,000.00
Utilities
$ 29,500.00
Insurance
$ 12,000.00
Facilities Rent
$ 1,15,000.00
Advertising
$ 35,000.00
Total SG&A (D)
$ 3,44,500.00
Operating Profit (E=C-D)
-$ 4,48,250.00
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.