Please describe the circumstances of the following case study and recommend a course of action. Explain your approach to the problem, perform relevant per unit calculations and analysis, and formulate a recommendation. Ensure your work and recommendation are thoroughly supported.
Case Study:
Papaya Partners is a distributor of papayas. They purchase papayas from individual growers and package them in 10-pound cartons for delivery to their various customers, generally supermarkets. Last month, they budgeted to sell $500,000 worth of cartons at a price of $25 each. Actual sales met a budget of $500,000 at $25 per carton.
Management has received cost information based on actual performance and needs to understand the drivers of the overall variance from the budget. They have asked you, as an analyst in their management accounting department, to calculate and explain the variances. The following data has been provided:
| Budget | |
|---|---|
| Cost of fruit @ 10 pounds per carton | $ 200,000 |
| Cost of packaging @ 1 pound per carton | $ 10,000 |
| Labor costs @ .5 hourse per carton | $ 90,000 |
| Total Cost | $ 300,000 |
| Actual | |
| Cost of fruit @ 10 pounds per carton | $ 244,200 |
| Cost of packaging @ .55 pound per carton | $ 11,000 |
| Labor costs @ .75 hourse per carton | $ 150,000 |
| Total Cost | $ 405,200 |
| Unfavorable variance | $105,200.00 |
Specifically, management needs to know the:
Standard cost per unit (carton)
Actual cost per unit
Direct materials price variances
Direct materials usage variances
Direct labor rate variance
Direct labor efficiency variance
In addition, they would like to understand how the variances are calculated and what caused them. They would also like a recommendation on what might be done to improve the variances.
For this assignment, compute all required amounts and explain how the computations were performed. Describe whom you would work with to determine the causes of the variances and hypothesize on what caused the variances. Based on your analysis, recommend actions that management could take to improve the variances.
Superior papers will:
Perform all per unit calculations correctly.
Articulate how the calculations were performed.
Assess the variances computed and evaluate the operational results (i.e., is performance better or worse than budgeted?).
Explain with whom you would work to identify the root causes of the variances.
Propose well-thought-out causes for each variance.
Conclude on which variances require management’s attention and recommend courses of action.
I am solving 4 sub parts of the question:
1. Standard cost per unit = Standard cost is the estimated cost per unit including material, overheads and labor.
Here standard cost for 5,00,000 cartons is $3,00,000
So standard cost per unit = Total budget cost / budgeted number of cartons = $ 3,00,000 / 5,00,000 = $ 0.60 per carton
2. Actual cost per unit = Total actual cost / actual number of cartons = $ 4,05,200 / 5,00,000 = $ 0.8104 per carton
3. Direct material price variance = It is the difference between actual amount spent on direct material and the amount that would have been spent if the material had been purchased at standard price
So direct material price variance = ($ 244200+$ 11000) - ($ 200000+$ 10000) = $ 45,200 (Unfavorable)
4. Direct material usage variance - It is the difference between actual quantity of material utilized during a period and the standard consumption of material for the level of output achieved
Direct material price variance = (Actual quantity - standard quantity) X Standard price
| Actual quantity | Standard Quantity | ||
| Fruits | |||
| Total cost | 244200 | 200000 | |
| per carton cost | 10 | 10 | |
| Quantity | 24420 | 20000 | |
| Packaging | |||
| Total cost | 11000 | 10000 | |
| per carton cost | 0.55 | 1 | |
| Quantity | 20000 | 10000 | |
| Direct material price variance | |||
| Fruit | (24420 - 20000) * 10 = $ 44200 (U) | ||
| Packaging | (20000 - 10000) *1 = $ 10000 (U) | ||
Papaya Partners is a distributor of papayas. They purchase papayas from individual growers and package them in 10-pound cartons for delivery to their various customers, generally supermarkets. Last month, they budgeted to sell $500,000 worth of cartons at a price of $25 each. Actual sales met a budget of $500,000 at $25 per carton. Management has received cost information based on actual performance and needs to understand the drivers of the overall variance from the budget. They have asked you,...
Elsworth Inc. manufactures and sells two fruit drinks: Kostor and Limba. Budgeted and actual results for 2017 are as follows: (Click the icon to view the budgeted and actual results.) Read the requirements Requirement 1. Compute the total sales volume variance, the total sales-mix variance, and the total sales-quantity variance (Calculate all variances in terms of contribution margin.) Show results for each product in your computations, Begin by completing the following table to determine the budgeted contribution margin per unit,...
A variance analysis question for cost
accounting that I am struggling with. I have parts of it completed,
but there are some parts that I did not really understand. Could
you please take a look and help me? I really appreciate it! Thank
you very much! You may need to zoom in to see the numbers and
information for this question
Part 1: Calculate direct materials price and efficiency variances. Actual Costs Incurred Flexible Budget Budgeted Input Qt. Alloved for...
Direct Material Variances Goldman, Inc. is a manufacturer of lead crystal glasses. The standard direct materials quantity is 0.7 pounds per glass at the cost of $0.35 per pound. The actual result for one month’s production of 6,950 glasses was 1.3 pounds per glass, at the cost of $0.45 per pound. Calculate the direct materials cost variance and the direct materials efficiency variance. Direct Labour Variances Goldman, Inc. manufactures lead crystal glasses. The standard direct labor time is 0.5 hours...
Practice Exam 3 Cost Accounting XYZ Company manufactures and sells patio chairs. For the year 2016, XYZ prepared its master budget on the basis of 4,000 units produced and sold. However, in 2016, because of acute competition in the industry, XYZ was only able to produce and sell 3,000 units. Table 1 provides XYZ Company's static budget and actual results using a contribution margin income statement. Table 1 Flexible-Budget Variances (2) (1)-(3) Sales Volume Variances (4)=(3)-(5) Flexible Budget (3) Actual...
During June, Danby Company’s material purchases amounted to 8,000 pounds at a price of $6.20 per pound. Actual costs incurred in the production of 2,500 units were as follows: Direct labor: $ 121,506 ($15.40 per hour) Direct material: $ 32,798 ($6.20 per pound) The standards for one unit of Danby Company’s product are as follows: Direct Labor: Direct Material: Quantity, 3 hours per unit Quantity, 2 pounds per unit Rate, $15.00 per hour Price, $5.90 per pound Required: Fill...
The following describes production activities of Mercer Manufacturing for the year. Actual direct materials used 22,000 lbs. at $4.35 per lb. Actual direct labor used 6,575 hours for a total of $128,870 Actual units produced 36,000 Budgeted standards for each unit produced are 0.50 pound of direct material at $4.30 per pound and 10 minutes of direct labor at $20.60 per hour. AH = Actual Hours SH = Standard Hours AR = Actual Rate SR = Standard Rate AQ =...
Ceramics Etc. is a manufacturer of large flower pots for urban
settings. The company has these standards:
i Standard Price and Volume Direct materials (resin) 12 pounds per pot at a cost of $3.00 per pound 2.0 hours at a cost of $15.00 per hour Direct labor Standard variable manufacturing overhead rate $3.00 per direct labor hour Budgeted fixed manufacturing overhead $27,400 $8.00 per direct labor hour (DLH) Standard fixed MOH rate - X Actual Results Ceramics Etc. allocated fixed...
The following describes production activities of Mercer Manufacturing for the year. Actual direct materials used Actual direct labor used Actual units produced 31,000 lbs. at $5.80 per lb. 10,600 hours for a total of $217,300 63,000 1,600 hour. 29.9 5. IS DE $217,300 Budgeted standards for each unit produced are 0.50 pound of direct material at $5.75 per pound and 10 minutes of direct labor at $21.50 per hour. AH = Actual Hours SH = Standard Hours AR = Actual...
Highland Company produces a lightweight backpack that is popular with college students. Standard variable costs relating to a single backpack are given below: Standard Quantity or HoursStandard Price or RateStandard CostDirect materials?$ 8.00per yard$ ?Direct labor???Variable manufacturing overhead?$ 2per direct labor-hour?Total standard cost per unit$ ? Overhead is applied to production on the basis of direct labor-hours. During March, 600 backpacks were manufactured and sold. Selected information relating to the month’s production is given below: Materials UsedDirect LaborVariable Manufacturing OverheadTotal standard cost allowed*$...