Question
Canadian Food Co. (CFC) is a large organization which has a number of divisions in the bakery and food fields. Their jam and marmalade division
Canadian Food Co. (CFC) is a large organization which has a number of divisions in the bakery and food fields. Their jam and marmalade division produce 5 types of sandwich spreads which it sells in jars. Their plan is to be the low cost provider of spreads in a competitive market. The price of the inputs are set by the commodity market and generally beyond the control of management. You are the management accountant assigned to this division. CFC’s year end is September 2020. Production equals sales so there are no inventories.
- The sales and cost figures for the month of August 2020 are as follows. Variable and fixed costs are all manufacturing costs. Selling, administrative, marketing and other costs are ignored. (10)
Budget | Selling Price | Variable Cost | Fixed Cost | Sales Volume |
Marmalade | $ 4.60 | $ 2.60 | $50,000 | 45,000 |
Apple | 5.00 | 2.70 | 19,000 | 25,000 |
Strawberry | 5.50 | 2.90 | 15,000 | 10,000 |
Raspberry | 6.00 | 3.40 | 6,900 | 5,000 |
Mixed | 6.60 | 3.90 | 22,000 | 15,000 |
100,000 | ||||
Actual | ||||
Selling Price | Variable Cost | Fixed Cost | Sales Volume | |
Marmalade | $ 4.60 | $ 2.71 | $50,000 | 57,600 |
Apple | 5.20 | 2.90 | 20,000 | 18,000 |
Strawberry | 5.70 | 3.00 | 15,000 | 9,600 |
Raspberry | 6.10 | 3.50 | 17,000 | 13,200 |
Mixed | 7.00 | 4.00 | 21,000 | 21,600 |
120,000 |
CFC uses the variable costing approach for its sales and cost analysis. As part of the management report you are required to calculate the following figures:
- Budget and actual break-even revenue for each type of spread
- Operating income in total and for each type of spread
- After considering the information identified as part of the sales analysis you note the lowest contribution margin is for marmalade. You decide to analyze the marmalade variable costs for August. The variable costs for marmalade are primarily determined by the direct cost of oranges. Other components such as sugar, filler and binding chemicals vary little. CFC purchases three types of oranges from California, Florida and Mexico. Each type of orange has its own flavour. The oranges from California are the most inexpensive but have the least flavour while the oranges from Mexico cost the most but have the most flavour. CFC calculates costs on a flexible budget basis. 6 kilograms of oranges are budgeted to result in one jar of product. (10)
Budgeted costs and inputs for a month to produce 45,000 jars:
135,000 kilograms from California @ $ 0.40 | $ 54,000 |
90,000 kilograms from Florida @ $0.45 | 40,500 |
45,000 kilograms from Mexico @ $ 0.50 | 22,500 |
$ 117,000 | |
Actual costs and inputs for August to produce 57,600 jars: | |
160,000 kilograms from California @ $ 0.45 | $ 72,000 |
115,200 kilograms from Florida @ $0.45 | 51,840 |
58,800 kilograms from Mexico @ $ 0.55 | 32,340 |
$ 156,180
As part of the management report you are required to calculate the following figures on a flexible budget basis for August:
- Direct materials price and efficiency variances
- Direct materials mix and yield variances
- Further review of the data indicates there has been a change in the market for strawberry and raspberry jam. The actual sales figures are very different then budgeted. So you decide to investigate the sales volume contribution margin variances implications. (10)
The expected sales volume for the entire strawberry and raspberry market was 75, 000 with 24,750 for raspberry units while the actual sales volume for the market was 76,000 units with 30,400 for strawberry.
- Calculate the sales-quantity CM variance
- Calculate the sales-mix CM variance
- Calculate the sales-volume CM variance
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Breakeven point Fixed Costs Selling Price Variable Costs CM Contribution Margin Budget Fixed Cost a Selling price b Variable Cost Budgeted CM Selling Price Variable Cost c Breakeven point units d ac B...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started