Genuine Spice Inc. began operations on January 1 of the current year. The company produces 8-ounce bottles of hand and body lotion called Eternal Beauty. The lotion is sold wholesale in 12-bottle cases for $100 per case. There is a selling commission of $20 per case. The January direct materials, direct labor, and
DIRECT MATERIALS | ||||
Cost Behavior | Units per Case | Cost per Unit | Direct Materials Cost per Case | |
Cream base | Variable | 100 ozs. | $0.02 | $ 2.00 |
Natural oils | Variable | 30ozs. | 0.30 | 9.00 |
Bottle (8-OZ-) | Variable | 12 bottles | 0.50 | 6.00 $17.00 |
DIRECT LABOR | ||||
Department | Cost Behavior | Time per Case | Labor Rate per Hour | Direct Labor Cost per Case |
Mixing | Variable | 20 min. | $18.00 | $6.00 |
Filling | Variable | 5 | 14.40 | 1.2 |
25 min. | $7.20 |
FACTORY OVERHEAD | ||
Cost Behavior | Total Cost | |
Utilities | Mixed | $ 600 |
Facility lease | Fixed | 14,000 |
Equipment |
Fixed | 4,300 |
Supplies | Fixed | 660 |
$19,560 |
Part A—Break-Even Analysis
The management of Genuine Spice Inc. wishes to determine the number of cases required to break even per month. The utilities cost, which is part of factory overhead, is a mixed cost. The following information was gathered from the first six months of operation regarding this cost:
Month | Case Production | Utility Total Cost |
January | 500 | $600 |
February | 800 | 660 |
March | 1,200 | 740 |
April | 1,100 | 720 |
May | 950 | 690 |
June | 1,025 | 705 |
Instructions
- 1. Determine the fixed and variable portions of the utility cost using the high-low method.
- 2. Determine the contribution margin per ease.
- 3. Determine the fixed costs per month, including the utility fixed cost from part (1).
- 4. Determine the break-even number of cases per month.
Part B—August Budgets
During July of the current year, the management of Genuine Spice Inc. asked the controller to prepare August manufacturing and income statement budgets. Demand was expected to be 1,500 cases at $100 per case for August. Inventory planning information is provided as follows: Finished Goods Inventory:
Cases | Cost | |
Estimated finished goods inventory, August 1 | 300 | $12,000 |
Desired finished goods inventory, August 31 | 175 | 7,000 |
Materials Inventory:
Cream Base (ozs.) | Oils (ozs.) | Bottles (bottles) | |
Estimated materials inventory, August 1 | 250 | 290 | 600 |
Desired materials inventory, August 31 | 1,000 | 360 | 240 |
There was negligible work in process inventory assumed for either the beginning or end of the month; thus, none was assumed. In addition, there was no change in tile cost per unit or estimated units per case operating data from January.
Instructions
- 5. Prepare the August production budget.
- 6. Prepare the August direct materials purchases budget.
- 7. Prepare the August direct labor budget. Round the hours required for production to the nearest hour.
- 8. Prepare the August factory overhead budget.
- 9. Prepare the August
budgeted income statement , including selling expenses.
Part C—August
During September of the current year, the controller was asked to perform variance analyses for August. The January operating data provided the standard prices, rates, times, and quantities per case. There were 1,500 actual cases produced during August, which was 250 more cases than planned at the Beginning of the month. Actual data for August were as follows:
Actual Direct Materials Price per Unit | Actual Direct Materials Quantity per Case | |
Cream base | $0.016 per oz. | 102 ozs. |
Natural oils | $0.32 per oz. | 31 ozs. |
Bottle (8 oz.) | $0.42 per bottle | 12.5 bottles |
Actual Direct Labor Rate | Actual Direct Labor Time per Case | |
Mixing | $18.20 | 19.50 min. |
Filling | 14.00 | 5.60 min. |
Actual variable overhead | $305.00 | |
Normal volume | 1,600 cases |
The prices of the materials were different than .standard due to fluctuations in market prices. The standard quantity of materials used per case was an ideal standard. The Mixing Department used a higher grade labor classification during the month, thus causing the actual labor rale to exceed standard. The Filling Department used a lower grade labor classification during the month, thus causing the actual labor rate to be less titan standard.
Instructions
- 10. Determine and interpret the direct materials price and quantity variances for the three materials.
- 11. Determine and interpret the direct labor rate and time variances for the two departments. Round hours to the nearest hour.
- 12. Determine and interpret the factory overhead controllable variance.
- 13. Determine and interpret the factory overhead volume variance.
- 14. Why are the standard direct labor and direct materials costs in the calculations for parts (10) and (11) based on the actual 1,500-case production volume rather than the planned 1,250 cases of production used in the budgets for parts (6) and (7)?
Part–A
(1)
Direct material variances:
The difference between the actual material cost per unit and the standard material cost per unit for the direct material purchased is known as direct material cost variance. The direct material variance can be classified as follows:
- Direct materials price variance.
- Direct materials quantity variance.
Direct labor variances:
The difference between the actual labor cost in the production and the standard labor cost for actual production is known as direct labor cost variance. The direct labor variance can be classified as follows:
- Labor rate variance.
- Labor time variance.
Variable factory overhead controllable variances:
The difference between the actual variable overhead costs and the standard overhead for actual production is known as the variable factory overhead controllable variances. The variable factory overhead controllable variance is computed as follows:
Fixed factory overhead volume variances:
Factory overhead volume variances refers to the difference between the budgeted fixed overheads at 100% of normal capacity, and the standard fixed overheads for the actual units produced. The factory overhead volume variances can be calculated as follows:
To determine: The fixed and variable portion of the utility cost using the high-low method.
Explanation of Solution
The fixed, and variable portion of the utility cost using the high-low method is $500,and $240 in the high cost method, and $500,and $100 in the low cost method respectively.
Working Notes:
Calculate the variable cost per unit.
Calculate the fixed and variable portion of the utility cost using high method:
Calculate the fixed and variable portion of the utility cost using low method:
Hence, using the high method, the fixed and variable portion of the utility cost is $500, and $240. On the other hand, using the low method, the fixed and variable portion of the utility cost is $500, and $100 respectively.
Part–B
5.
To prepare: The August production budget.
Answer to Problem 5CPP
Incorporation GS Budgeted Income Statement For the month ended August 31 | |||
Sales (9) | $ 150,000 | ||
Finished goods inventory, August 1 | $ 12,000 | ||
Direct materials: | |||
Direct materials inventory, August 1 (10) | $ 392 | ||
Direct materials purchases (Table 4) | 23,231 | ||
Cost of direct materials available for use | $ 23,623 | ||
Less: Direct materials inventory, August 31 (11) | 248 | ||
Cost of direct materials used in production | $ 23,375 | ||
Direct labor (Table 5) | 9,900 | ||
Factory overhead (Table 6) | 19,735 | ||
Cost of goods manufactured | 53,010 | ||
Cost of finished goods available for sale | $ 65,010 | ||
Less: Finished goods inventory, August 31 | 7,000 | ||
Cost of goods sold | 58,010 | ||
Gross profit | $ 91,990 | ||
Less: Selling expenses | 30,000 | ||
Income from operations | $ 61,990 |
Table (7)
Explanation of Solution
Prepare the production budget for the month of August.
Incorporation GS | |
Production Budget | |
For the month ended August 31 | |
Particulars | Cases |
Expected cases to be sold | 1,500 |
Plus desired ending inventory | 175 |
Total units required | 1,675 |
Less: Estimated beginning inventory | 300 |
Total units to be produced | 1,375 |
Table (3)
Part–C
10.
To determine and interpret: The direct materials price and quantity variances for the three materials.
Explanation of Solution
Determine the direct materials price variances for the three materials.
Cream Base | Natural oils | Bottles | |
Actual price | $ 0.016 | $0.32 | $0.42 |
Less: Standard price | 0.020 | 0.30 | 0.50 |
Difference | $(0.004) | 0.02 | $(0.08) |
Multiply: Actual quantity | 153,000 (13) | 46,500 (14) | 18,750 (15) |
Direct materials price variance | $(612) Favorable |
$930 (Unfavorable) | $(1,500) Favorable |
Table (8)
Working Note:
Interpretation:
It can be understood from the above data that there is variances in the direct materials prices due to the fluctuations in the market prices. The actual price for natural oils got increased when compared to its standard price, whereas, the actual prices for the cream base, and bottles got decreased when compared to their respective standard prices.
Want to see more full solutions like this?
Chapter 22 Solutions
Bundle: Financial & Managerial Accounting, Loose-leaf Version, 14th + Working Papers For Warren/reeve/duchac's Corporate Financial Accounting, 14th + ... Financial & Managerial Accounting,
- Box Springs, Inc., makes two sizes of box springs: twin and double. The direct material for the twin is $25 per unit and $40 s used in direct labor, while the direct material for the double is $40 per unit, and the labor cost is $50 per unit. Box Springs estimates it will make 5,000 twins and 9,000 doubles in the next year. It estimates the overhead for each cost pool and cost driver activities as follows: How much does each unit cost to manufacture?arrow_forwardBox Springs. Inc., makes two sizes of box springs: queen and king. The direct material for the queen is $35 per unit and $55 is used in direct labor, while the direct material for the king is $55 per unit, and the labor cost is $70 per unit. Box Springs estimates it will make 4,300 queens and 3,000 kings in the next year. It estimates the overhead for each cost pool and cost driver activities as follows: How much does each unit cost to manufacture?arrow_forwardBobcat uses a traditional cost system and estimates next years overhead will be $800.000, as driven by the estimated 25,000 direct labor hours. It manufactures three products and estimates the following costs: If the labor rate is $30 per hour, what is the per-unit cost of each product?arrow_forward
- Krouse Company produces two products, forged putter heads and laminated putter heads, which are sold through specialty golf shops. The company is in the process of developing itsoperating budget for the coming year. Selected data regarding the companys two products areas follows: Manufacturing overhead is applied to units using direct labor hours. Variable manufacturing overhead Ls projected to be 25,000, and fixed manufacturing overhead is expected to be15,000. The estimated cost to produce one unit of the laminated putter head is: a. 42. b. 46. c. 52. d. 62.arrow_forwardColonels uses a traditional cost system and estimates next years overhead will be $480,000, with the estimated cost driver of 240,000 direct labor hours. It manufactures three products and estimates these costs: If the labor rate is $25 per hour, what is the per-unit cost of each product?arrow_forwardRemarkable Enterprises requires four units of part A for every unit of Al that it produces. Currently, part A is made by Remarkable, with these per-unit costs in a month when 4,000 units were produced: Variable manufacturing overhead is applied at $1.60 per unit. The other $0.50 of overhead consists of allocated fixed costs. Remarkable will need 8,000 units of part A for the next years production. Altoona Corporation has offered to supply 8,000 units of part A at a price of $8.00 per unit. If Remarkable accepts the offer, all of the variable costs and $2,000 of the fixed costs will be avoided. Should Remarkable accept the offer from Altoona Corporation?arrow_forward
- Business Specialty, Inc., manufactures two staplers: small and regular. The standard quantities of direct labor and direct materials per unit for the year are as follows: The standard price paid per pound of direct materials is 1.60. The standard rate for labor is 8.00. Overhead is applied on the basis of direct labor hours. A plantwide rate is used. Budgeted overhead for the year is as follows: The company expects to work 12,000 direct labor hours during the year; standard overhead rates are computed using this activity level. For every small stapler produced, the company produces two regular staplers. Actual operating data for the year are as follows: a. Units produced: small staplers, 35,000; regular staplers, 70,000. b. Direct materials purchased and used: 56,000 pounds at 1.5513,000 for the small stapler and 43,000 for the regular stapler. There were no beginning or ending direct materials inventories. c. Direct labor: 14,800 hours3,600 hours for the small stapler and 11,200 hours for the regular stapler. Total cost of direct labor: 114,700. d. Variable overhead: 607,500. e. Fixed overhead: 350,000. Required: 1. Prepare a standard cost sheet showing the unit cost for each product. 2. Compute the direct materials price and usage variances for each product. Prepare journal entries to record direct materials activity. 3. Compute the direct labor rate and efficiency variances for each product. Prepare journal entries to record direct labor activity. 4. Compute the variances for fixed and variable overhead. Prepare journal entries to record overhead activity. All variances are closed to Cost of Goods Sold. 5. Assume that you know only the total direct materials used for both products and the total direct labor hours used for both products. Can you compute the total direct materials and direct labor usage variances? Explain.arrow_forwardSalisbury Bottle Company manufactures plastic two-liter bottles for the beverage industry. The cost standards per 100 two-liter bottles are as follows: At the beginning of March, Salisburys management planned to produce 500,000 bottles. The actual number of bottles produced for March was 525,000 bottles. The actual costs for March of the current year were as follows: a. Prepare the March manufacturing standard cost budget (direct labor, direct materials, and factory overhead) for Salisbury, assuming planned production. b. Prepare a budget performance report for manufacturing costs, showing the total cost variances for direct materials, direct labor, and factory overhead for March. c. Interpret the budget performance report.arrow_forwardCozy, Inc., manufactures small and large blankets. It estimates $950,000 in overhead during the manufacturing of 360,000 small blankets and 120,000 large blankets. What is the predetermined overhead rate if a small blanket takes 2 hours of direct labor and a large blanket takes 3 hours of direct labor?arrow_forward
- Algers Company produces dry fertilizer. At the beginning of the year, Algers had the following standard cost sheet: Algers computes its overhead rates using practical volume, which is 54,000 units. The actual results for the year are as follows: a. Units produced: 53,000 b. Direct materials purchased: 274,000 pounds at 2.50 per pound c. Direct materials used: 270,300 pounds d. Direct labor: 40,100 hours at 17.95 per hour e. Fixed overhead: 161,700 f. Variable overhead: 122,000 Required: 1. Compute price and usage variances for direct materials. 2. Compute the direct labor rate and labor efficiency variances. 3. Compute the fixed overhead spending and volume variances. Interpret the volume variance. 4. Compute the variable overhead spending and efficiency variances. 5. Prepare journal entries for the following: a. The purchase of direct materials b. The issuance of direct materials to production (Work in Process) c. The addition of direct labor to Work in Process d. The addition of overhead to Work in Process e. The incurrence of actual overhead costs f. Closing out of variances to Cost of Goods Soldarrow_forwardFive Card Draw manufactures and sells 10,000 units of Aces, which retails for $200, and 8,000 units of Kings, which retails for $170. The direct materials cost is $20 per unit of Aces and $15 per unit of Kings. The labor rate is $30 per hour, and Five Card Draw estimated 64000 direct labor hours. It takes 4 direct labor hours to manufacture Aces and 3 hours for Kings. The total estimated overhead is $128,000. Five Card Draw uses the traditional allocation method based on direct labor hours. A. How much is the gross profit per unit for Aces and Kings? B. What is the total gross profit for the year?arrow_forwardLens & Shades sells sunglasses for $37 each and is estimating sales of 21,000 units in January and 19,000 in February. Each lens consist of 2.00 mm of plastic costing $2.50 per mm, 1.7 oz of dye costing $2.80 per ounce. and 0.50 hours direct labor at a labor rate of $18 per unit. Desired inventory levels are: Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget.arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning