In: Accounting
Frontleg Chocolate Company manufactures and sells a premium chocolate called PremiumChoco. The following | ||||||
data are available for preparing budgets for PremiumChoco for June through August of 2020. | ||||||
1. Sales: June , 30,000 pounds; July, 56,000 pounds, August 58,000 pounds. | ||||||
2. Direct materials: each pound of PremiumChoco requires 5 pounds of cacao seeds at a cost of $2.95 per | ||||||
pound and 4 pounds of cane sugar at $.50 per pound. | ||||||
3. Desired inventory levels: | ||||||
Type of Inventory | May 1 | June 1 | July 1 | August 1 | ||
PremiumChoco (pounds) | 7,000 | 8,000 | 15,000 | 18,000 | ||
cacao seeds (pounds) | 6,000 | 9,000 | 10,000 | 13,000 | ||
cane sugar (pounds) | 5,000 | 14,000 | 20,000 | 25,000 | ||
4. Direct labor: direct labor time is 30 minutes per pound at an hourly rate of $20 per hour. | ||||||
5. Selling and administrative expenses are expected to be .05 cents per unit sold plus $82,000 per month. | ||||||
6. Your assistant has prepared two budgets: (1) The manufacturing overhead budget shows expected | ||||||
costs to be 150% of direct labor cost (all variable costs). | ||||||
7. The company uses a 30% markup percentage on total cost | ||||||
8. Interest Expense is $150,000. | ||||||
9. Income taxes are expected to be 21% of income before income taxes. |
10a) Compute the operating leverage. The image is not cropped, I copied it exactly as it is.
10a | Operating leverage | |
Sales revenue | ||
Variable expenses | ||
Contribution margin | ||
Operating leverage = |
Please refer working note no. 1 & 2 for numbers used in calculation:
Operating Leverage = (Sales Revenue - Variable Cost) / Profits Before Tax
= ($6,272,760 - $4,579,200) / $1,297,560
= 1.305
Hence, operating levarage is 1.305
Sales Revenue = $6,272,760 (please refer working note no. 1 & 2)
Direct Variable Expenses = Direct Material + Direct Labour + Mfg. / Direct Variable Overheads
= $2,412,000 + $1,440,000 + $720,000
= $4,572,000
Hence, Direct Variable Expenses are $4,572,000
Total Variable Expenses = Direct Material + Direct Labour + Variable Overheads + Variable Admin, Selling & Marketing Expenses
= $2,412,000 + $1,440,000 + $720,000 + $7,200
= $4,579,200
Hence, Total Variable Expenses are $4,579,200
Contribution Margin = Sales Revenue - Variable Costs or say Total Variable Expenses
= $6,272,760 - $4,579,200
= $1,693,560
Hence, Contribution Marig is $1,693,560
Working Note 1:
Particulars | Formula | June | July | August | Total | ||
Direct Material Cost | CACAO Material Cost + Cane Sugar Material Cost | 502,500 | 938,000 | 971,500 | 2,412,000 | ||
CACAO Seeds Per Pound | 5 | 5 | 5 | 5 | |||
Total Qty. | Sales Qty. * CACAO Seeds Per Pound | 150,000 | 280,000 | 290,000 | 720,000 | ||
Price Per Pound | 3 | 3 | 3 | 3 | |||
CACAO Material Cost | Total Qty. * Price Per Pound | 442,500 | 826,000 | 855,500 | 2,124,000 | ||
Cane Sugar Per Pound | 4 | 4 | 4 | 4 | |||
Total Qty. | Sales Qty. * Cane Sugar Per Pound | 120,000 | 224,000 | 232,000 | 576,000 | ||
Price Per Pound | 0.50 | 0.50 | 0.50 | 0.50 | |||
Cane Sugar Material Cost | Total Qty. * Price Per Pound | 60,000 | 112,000 | 116,000 | 288,000 | ||
Direct Labour Cost | Total Labour Cost | 300,000 | 560,000 | 580,000 | 1,440,000 | ||
Per Pound Time Consumption | 0.50 | 0.50 | 0.50 | 0.50 | |||
Total Hours | Sales Qty. * Per Pound Time Consumption | 15,000 | 28,000 | 29,000 | 72,000 | ||
Price Per Hour | 20 | 20 | 20 | 20 | |||
Total Labour Cost | Total Hours * Price Per Hour | 300,000 | 560,000 | 580,000 | 1,440,000 | ||
Manufacturing Variable Cost | 50% of Direct Labour Cost | 150,000 | 280,000 | 290,000 | 720,000 | ||
Total Direct Expenses | Direct Material + Direct Labour + Mfg. Variable Cost | 952,500 | 1,778,000 | 1,841,500 | 4,572,000 | ||
Variable Sellling & Admin Expenses | 1,500 | 2,800 | 2,900 | 7,200 | |||
Per Unit Cost | 0.05 | 0.05 | 0.05 | 0.05 | |||
Total Variable Cost | Total Direct Expenses + Variable Selling & Admin | 954,000 | 1,780,800 | 1,844,400 | 4,579,200 | ||
Fixed Selling & Admin Expenses | Monthly | 82,000 | 82,000 | 82,000 | 246,000 | ||
Total Cost | Total Variable + Fixed Selling & Admin | 1,036,000 | 1,862,800 | 1,926,400 | 4,825,200 | ||
Mark up | 30% | 310,800 | 558,840 | 577,920 | 1,447,560 | ||
Sales Revenue | Total Cost + Markup | 1,346,800 | 2,421,640 | 2,504,320 | 6,272,760 | ||
Working Note: 2
Particulars | Formula | Amount | ||
Sales Revenue | Total Cost + Markup | 6,272,760 |
Related SolutionsFrontleg Chocolate Company manufactures and sells premium chocolate called PremiumChoco. The following data are available for...Frontleg Chocolate Company manufactures and sells premium
chocolate called PremiumChoco. The following data are available for
preparing budgets for PremiumChoco for June through August of
2020.
1. Sales: June, 30,000 pounds; July, 56,000 pounds, August
58,000 pounds.
2. Direct materials: each pound of PremiumChoco requires 5
pounds of cacao seeds at a cost of $2.95 per pound and 4 pounds of
cane sugar at $.50 per pound.
3. Desired inventory levels:
Type of Inventory
May 1
June 1
July 1...
Frontleg Chocolate Company manufactures and sells a premium chocolate called PremiumChoco. The following data are available...
Frontleg Chocolate Company manufactures and sells a premium
chocolate called PremiumChoco. The following
data are available for preparing budgets for PremiumChoco for June
through August of 2020.
1. Sales: June , 30,000 pounds; July, 56,000 pounds, August 58,000
pounds.
2. Direct materials: each pound of PremiumChoco requires 5 pounds
of cacao seeds at a cost of $2.95 per
pound and 4 pounds of cane sugar at $.50
per pound.
3. Desired inventory levels:
Type of Inventory
May 1
June...
Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available...Cook Farm Supply Company manufactures and sells a pesticide
called Snare. The following data are available for preparing
budgets for Snare for the first 2 quarters of 2020.
1.
Sales: quarter 1, 28,600 bags; quarter 2, 42,800 bags. Selling
price is $61 per bag.
2.
Direct materials: each bag of Snare requires 5 pounds of Gumm
at a cost of $3.80 per pound and 6 pounds of Tarr at $1.50 per
pound.
3.
Desired inventory levels:
Type of Inventory
January...
Tilger Farm Supply Company manufactures and sells a fertilizer called Snare. The following data are available...Tilger Farm Supply Company manufactures and sells a fertilizer
called Snare. The following data are available for preparing
budgets for Snare for the first two quarters of 2020.
1.
Sales: Quarter 1, 29,000 bags; quarter 2, 44,000 bags. Selling
price is $60 per bag.
2.
Direct materials: Each bag of Snare requires 4 kg of Gumm at $4
per kilogram and 6 kg of Tarr at $1.50 per kilogram.
3.
Desired inventory levels:
Type of Inventory
January 1
April 1...
Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available...Cook Farm Supply Company manufactures and sells a pesticide
called Snare. The following data are available for preparing
budgets for Snare for the first 2 quarters of 2020.
1.
Sales: quarter 1, 28,000 bags; quarter 2, 43,000 bags. Selling
price is $61 per bag.
2.
Direct materials: each bag of Snare requires 5 pounds of Gumm
at a cost of $3.80 per pound and 6 pounds of Tarr at $1.75 per
pound.
3.
Desired inventory levels:
Type of Inventory
January...
Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available...Cook Farm Supply Company manufactures and sells a pesticide
called Snare. The following data are available for preparing
budgets for Snare for the first 2 quarters of 2020.
1.
Sales: quarter 1, 28,600 bags; quarter 2, 42,600 bags. Selling
price is $62 per bag.
2.
Direct materials: each bag of Snare requires 4 pounds of Gumm
at a cost of $3.80 per pound and 6 pounds of Tarr at $1.50 per
pound.
3.
Desired inventory levels:
Type of Inventory
January...
Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available...Cook Farm Supply Company manufactures and sells a pesticide
called Snare. The following data are available for preparing
budgets for Snare for the first 2 quarters of 2020. 1. Sales:
quarter 1, 29,200 bags; quarter 2, 43,200 bags. Selling price is $
61 per bag. 2. Direct materials: each bag of Snare requires 5
pounds of Gumm at a cost of $ 3.80 per pound and 6 pounds of Tarr
at $ 1.50 per pound. 3. Desired inventory levels: Type...
Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available...Cook Farm Supply Company manufactures and sells a pesticide
called Snare. The following data are available for preparing
budgets for Snare for the first 2 quarters of 2020. 1. Sales:
quarter 1, 29,200 bags; quarter 2, 43,200 bags. Selling price is $
61 per bag. 2. Direct materials: each bag of Snare requires 5
pounds of Gumm at a cost of $ 3.80 per pound and 6 pounds of Tarr
at $ 1.50 per pound. 3. Desired inventory levels: Type...
Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available...Cook Farm Supply Company manufactures and sells a pesticide
called Snare. The following data are available for preparing
budgets for Snare for the first 2 quarters of 2020.
1.
Sales: quarter 1, 28,200 bags; quarter 2, 43,600 bags. Selling
price is $63 per bag.
2.
Direct materials: each bag of Snare requires 5 pounds of Gumm
at a cost of $3.80 per pound and 6 pounds of Tarr at $1.75 per
pound.
3.
Desired inventory levels:
Type of Inventory
January...
Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available...Cook Farm Supply Company manufactures and sells a pesticide
called Snare. The following data are available for preparing
budgets for Snare for the first 2 quarters of 2017.
1.
Sales: quarter 1, 28,400 bags; quarter 2, 44,000 bags. Selling
price is $62 per bag.
2.
Direct materials: each bag of Snare requires 4 pounds of Gumm
at a cost of $3.8 per pound and 6 pounds of Tarr at $1.50 per
pound.
3.
Desired inventory levels:
Type of Inventory
January...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|