Concept explainers
Production and Direct Materials Budgets LO8—, L08—4
Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout Southeast Asia. Three cubic centimeters (cc) of solvent H300 arerequired to manufacture each unit of Supermix,one of the company’s products. The company now is planning raw materials needs for the third quarter, thequarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements:
a. The finished goods inventory on hand at the end of each month must equal 3,000 units of Supermix plus 20% of the next month’s sales. Thefinished goods inventory on June 30 is budgeted to be 10,000 units.
b. The raw materials inventory on hand at the end of each month must equal one-half of the following month’s production needs for rawmaterials. The raw materials inventory on June 30 is budgeted to be 54,000 cc of solvent H300.
c. The company maintains no work in process inventories.
A monthly sales budget for Supermix for the third and fourth quarters of the year follows.
Required:
1. Prepare a production budget for Supermix for the months July, August, September, and October.
2. Examine the production budget that you prepared in (1) above. Why will the company produce more units than it sells in July and August, and fewer unitsthan it sells in September and October?
3. Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, Aust. and September, and for the quarter in total.
To Examine:
Why will the company produce more units than it sells in July and August, and fewer units than it sells in September and October?
Answer to Problem 10E
Solution:
The sales are expected to be higher in September, thus, the company is planning to produce more in July and August for September and October sales. In the September and October, the production is less as it is expected to sell less units in the end months of the year.
Explanation of Solution
The above answer can be explained as the company is anticipating higher sales in September and October, so the company is planning in advance for these months’ sales. Thus, it has produced more finished goods in July and August so that the demand of September meets with the demand.
In October and September, the goods from next months will be produced, but there will not be much demand for the finished goods in the year end, thus less goods are produced in September and October.
Thus,the reasons for why will the company produce more units than it sells in July and August, and fewer units than it sells in September and October has been discussed.
Requirement 3
To prepare:
Direct Materials purchase budget for the solvent H300 for July, August, and September and in total.
Answer to Problem 10E
Solution:
Direct Material Purchase Budget | ||||
July | August | September | Total | |
Budgeted Production | 36,000 | 42,000 | 46,000 | 1,24,000 |
Per unit requirement | 3 | 3 | 3 | |
Total requirement for requirement | 108,000 | 126,000 | 138,000 | 372,000 |
Add: Ending desired raw material | 63000 | 69000 | 42000 | 174,000 |
Total requirements | 171,000 | 195,000 | 180,000 | 546,000 |
Less: Beginning Inventory | 54,000 | 63000 | 69000 | 186,000 |
Budgeted Purchases | 117,000 | 132,000 | 111,000 | 360,000 |
Explanation of Solution
The above direct materials purchase budget is prepared as under −
The direct material budgeted purchases are calculated as −
For July −
Given,
- Budgeted production = 36,000 units
- Per unit requirement = 3 CC per unit
- Total requirement for production = 108,000 CC (i.e. 36,000 units X 3 cc)
- Ending desired raw material −
- Beginning raw material = 54,000 cc
For August −
Given,
- Budgeted production = 42,000 units
- Per unit requirement = 3 CC per unit
- Total requirement for production = 126,000 CC (i.e. 42,000 units X 3 cc)
- Ending desired raw material −
- Beginning raw material = 63,000 cc
For September −
Given,
- Budgeted production = 46,000 units
- Per unit requirement = 3 CC per unit
- Total requirement for production = 138,000 CC (i.e. 46,000 units X 3 cc)
- Ending desired raw material −
- Beginning raw material = 69,000 cc
Thus, the direct Materials purchase budget for the solvent H300 for July, August, and September and in total has been prepared.
Want to see more full solutions like this?
Chapter 8 Solutions
INTRO.TO MANAG...(LL)-W/ACCESS >CUSTOM<
- AN: Q6 Q7 Q8 The budget director of Birds and Beyond, Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January 2021: Estimated sales for January: Birdhouse 7.500 units at $66 per unit Bird feeder 5,000 units at $82 per unit Estimated inventories at January 1: Direct Materials: Finished Products: Wood: 198 ft. Birdhouse: 500 units at $28 per unit. Plastic: 420 lbs. Bird feeder: 210 units at $40 per unit. Desired inventories at January 31: Direct Materials: Finished Products: Wood: 220 ft. Birdhouse: 400 units at $28 per unit. Plastic: 340 lbs. Bird feeder: 250 units at $40 per unit. Direct materials used in…arrow_forwardQ12 Gourmet Aroma Coffee House has an exclusive contract with Columbia exporters. Two brands of gourmet coffee are imported, Morning Thunder (MT) and Evening Tender (ET). The following data are provided for the current fiscal year: Budgeted Operating Results MT ET MT ET Price per pound $ 60 $ 90 $ 70 $ 85 Variable cost per pound 30 54 32 60 Sales (in pounds) 3,300 3,300 3,192 4,408 The total market was estimated to be 73,000 pounds at the time of budget. The actual total market for the year is 68,000 pounds. What is MT's contribution margin sales volume variance? Multiple Choice $3,240 unfavorable. $26,200 favorable. $3,480 unfavorable. $25,400 favorable. $26,440 favorable.arrow_forwardQUESTION2 A company manufactures a single product. Budget and Standard cost details for next year include: Selling Price per unit R24.00 Variable Production cost per unit R8.60 Fixed production costs R650 000 Fixed selling and distribution costs R230 400 Sales commission 5% of selling price Sales 90 000 units Required The marketing manager has suggested that the selling price per unit can be increased to R25.00.If the sales commission is increased to 8% percent of selling price and a further R10 000 is speny on advertising Calculate the revised breakeven point based on the marketing managers suggestionarrow_forward
- Q30 Gourmet Aroma Coffee House has an exclusive contract with Columbia exporters. Two brands of gourmet coffee are imported, Morning Thunder (MT) and Evening Tender (ET). The following data are provided for the current fiscal year: Budgeted Operating Results MT ET MT ET Price per pound $ 50 $ 70 $ 60 $ 65 Variable cost per pound 25 42 27 46 Sales (in pounds) 3,970 3,970 3,864 4,536 The total market was estimated to be 86,000 pounds at the time of budget. The actual total market for the year is 81,000 pounds. What is ET's sales mix variance? Multiple Choice $21,408 favorable. $7,968 favorable. $5,088 favorable. $4,128 favorable. $9,408 favorable.arrow_forwardE10.13 (LO 4, 5), AP Malea Industries produces a cleaning product that works for the peskiest stains. It’s pricey, but less expensive than hiring a professional cleaning service. The managers at Malea are conducting variance analysis at the end of January, the first month of the new fiscal year. Budgeted fixed-MOH costs for the year were $2,160,000. The company’s standards for one gallon of cleaning solution are as follows, along with actual information for the month. Standard Quantity per Unit Standard Price DM 0.5 gallons of solution $20.00 per gallon DL 0.3 DL hours $18.00 per DL hour Variable-MOH 2.0 machine hours $2.40 per machine hour Fixed-MOH 2.0 machine hours $4.00 per machine hour Actual results for January: 22,000 gallons were actually produced. Cost of DM purchased was $255,800 for 12,500 gallons of solution. DM used in production was 10,800 gallons. Cost of DL was $122,400 for 7,000 DL hours worked. Variable-MOH cost was $110,300 for 46,800 machine hours used.…arrow_forwardQ40 Gourmet Aroma Coffee House has an exclusive contract with Columbia exporters. Two brands of gourmet coffee are imported, Morning Thunder (MT) and Evening Tender (ET). The following data are provided for the current fiscal year: Budgeted Operating Results MT ET MT ET Price per pound $ 40 $ 70 $ 50 $ 65 Variable cost per pound 20 42 23 46 Sales (in pounds) 4,600 4,600 4,386 5,814 The total market was estimated to be 76,000 pounds at the time of budget. The actual total market for the year is 71,000 pounds. What is the firm's total sales mix variance? Multiple Choice $14,472 favorable. $2,530 unfavorable. $5,712 favorable. $6,072 unfavorable. $10,432 favorable.arrow_forward
- xercise 8-4 (Algo) Direct Labor Budget [LO8-5] The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 8,200 6,500 7,100 8,000 Each unit requires 0.25 direct labor-hours, and direct laborers are paid $12.00 per hour. Required: 1. Prepare the company’s direct labor budget for the upcoming fiscal year. Assume that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced. 2. Prepare the company’s direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is not adjusted each quarter. Instead, assume that the company’s direct labor workforce consists of permanent employees who are guaranteed to be paid for at least 1,800 hours of work each quarter. If the number of required direct labor-hours is less than this…arrow_forwardQ1; Waroad Company's sales budget projects unit sales of part CB78 of 10,000 units in January, 12,000 units in February, and 13,000 units in March. Each unit of part CB78 requires 3 pounds of materials, which cost $4 per pound. Warood Company desires its ending raw materials inventory to equal 30% of the next month's production requirements, and its ending finished goods inventory to equal 25% of the next month's expected unit sales. These goals were met at December 31, 2018. Instructions: (a) Prepare a production budget for January and February 2019. (b) Prepare a direct materials budget for January 2019. (c) What are the benefits of preparing a production and direct materials budget?arrow_forwardQUESTION2 A company manufactures a single product. Budget and Standard cost details for next year include: Selling Price per unit R24.00 Variable Production cost per unit R8.60 Fixed production costs R650 000 Fixed selling and distrivution costs R230 400 Sales commission 5% of selling price Sales 90 000 units Required 1. Calculate the break-even point in units 2. Calculate the breakeven point in rands 3. Calculate the percentage by which the budgeted sales can fall before The company begins to make a loss 4. The marketing manager has suggested that the selling price per unit can be increased to R25.00.If the sales…arrow_forward
- Q18 Wheat Incorporated has an exclusive contract with an exporter. Two brands of wheat are imported, labeled AB and CD. The following data are provided for the current fiscal year: Budgeted Actual Results AB CD AB CD Price per bushel $ 95 $ 15 $ 100 $ 17 Variable cost per bushel $ 90 $ 10 $ 90 $ 13 Sales (in bushels) 3,000 4,000 2,700 5,100 The total market was estimated to 70,000 bushels at the time of budget. The actual total market for the year is 39,000 bushels. What is the firm's market size variance? Multiple Choice $29,000 unfavorable. $12,250 unfavorable. $0. $17,500 unfavorable. $15,500 unfavorable.arrow_forward2.3 Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,780,000 Quarter 2 5,690,000 Quarter 3 630,000 Quarter 4 8,200,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,080,000 and for the fourth quarter of the current year are $7,220,000.arrow_forwardExercise 9-4 Direct Labor Budget [LO9-5] The production manager of Rordan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 10,800 8,000 8,400 10,700 Each unit requires 0.65 direct labor-hours, and direct laborers are paid $16 per hour. Required: 1. Complete the company’s direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced. (Round "Direct labor time per unit (hours)" answers to 2 decimal places.) 2. Complete the company’s direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is not adjusted each quarter. Instead, assume that the company’s direct labor workforce consists of permanent employees who are guaranteed to be paid for at least…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education