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 MANAGERIAL ACCT-CONNECT ACCESS
- II. Wongtien Electronics Corp. in Hong Kong, SAR, China, manufactures tablets, laptops and desktop PCs. Wongtien currently operates a standard absorption costing system. Budgeted information for next year is given below (currency in one thousand Hong Kong Dollars, HK$000): Desktop PCs 9,880 2,200 800 Products Sales revenue Tablets 3,640 800 300 Laptops 12,480 2,800 Total 26,000 5,800 2,300 Direct material Direct labor Fixed production overheads 1,456 1,084 4.992 3.488 3,952 2,928 10,400 7,500 Gross profit Fixed production overheads are currently absorbed based on a percentage of sales revenue. Wongtien is considering changing to an activity-based costing system. The main activities and their associated cost drivers and overhead cost have been identified as follows: Cost driver Production overhead cost Activity Manufacturing scheduling wNumber of orders Parts handling Assembly Software installation and testing Packaging 162 Number of parts Assembly time wNumber of software applications…arrow_forwardQUESTION 1 Kiwenkira & Son Ltd makes and sells a single product marketed under a brand name Kiwetonic for the West African sub region and has total production capacity of 30,000 units per month. The budget for January 2020 contained the following information: Normal capacity (Units) 27,000 Variable costs per unit: Production (GH¢) 110 Selling and distribution (GH¢) 25 Fixed overheads: Production (GH¢) 756,000 Selling and administration (GH¢) 504,000 The actual operating data for January 2020 is as follows: Production 24,000 units Sales at GH¢250 per unit 22,000 units Opening inventory of finished goods 2,000 units During the month of January 2020, the variable factory overheads exceeded the budget by GH¢120,000. Required: Prepare profit statement for the month of January using: Marginal costing: and Absorption costing techiques Reconcile…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
- Exercise 21.3 (Static) Incremental Analysis: Accepting a Special Order (LO21-1, LO21-2, LO21-3) Olson manufactures and sells 5,000 gun cabinets each month. A principal component part in each cabinet is a lock mechanism to keep them secure. Olson's plant currently has the monthly capacity to produce 8,000 lock mechanisms. The costs of manufacturing these mechanisms at full capacity are as follows. Variable costs per unit: Direct materials Direct labor Variable manufacturing overhead Fixed costs per month: Fixed manufacturing overhead 14 12 4 $ 10,000 Security Cases has offered to buy 3,000 lock mechanisms per month from Olson for use in its fireproof cases. Compute the following. a. The average unit cost of manufacturing each lock mechanism assuming that Olson manufactures only enough locks for its own gun cabinets. b. The incremental unit cost of producing one additional lock mechanism. c. The per-unit sales price that Olson should charge to earn $12,000 in monthly pretax profit on…arrow_forwardQuestion 5 rame Limited makes three products: A, B and C. The budget for the following three months was as follows: Sales units Sales price per unit Variable cost per unit 10 A B C 1,000 1,500 2,000 €31 €20 €10 €10 €8 €4 However, the machine which is used in the production of all three products has malfunctioned. A temporary repair job has been done, but the total machine hours available for the next three months (until the replacement machine arrives) has been reduced to 4,800 hours. Each unit of product A requires 3 machine hours, each unit of Product B requires 1 machine hour and each unit of Product C requires 0.75 hours. On this basis, for the next three months, the product that Frame Limited will prioritise in relation to production is Product Under the revised plan, the production and sales of Product A will be units.arrow_forwardExercise 8-10 (Algo) Production and Direct Materials Budgets [LO8-3, LO8-4] Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company’s products. The company is planning its raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements: The finished goods inventory on hand at the end of each month must equal 4,000 units of Supermix plus 25% of the next month’s sales. The finished goods inventory on June 30 is budgeted to be 18,250 units. The raw materials inventory on hand at the end of each month must equal one-half of the following month’s production needs for raw materials. The raw materials inventory on June 30 is budgeted to be 87,375 cc of solvent H300. The company maintains no work…arrow_forward
- QUESTION JTET Sdn Bhd is an automotive manufacturing company located at Hicom Industrial Park. Currently, the owner, Mr Arifin is considering to open a new branch that is located at Pontian, Johor. He has asked you to help him to prepare cash budget over the first three months of operation, starting October 2021. The following information is available: Octobe Novembe Decembe Sales Purchase Overhead 60,000 66,000 22,000 24,100 69,000 32,200 2,650 2,500 3,600 Additional Information: • Mr Arifin is expected to contribute RM 100,000 cash as capital in order to set up the new branch. • In October, Mr Airifin will need to pay a rental deposit of RM10,000 and monthly rental of RM5,000 for the factory building. • 1/3 of the sales are cash sales. Total credit sales are expected to be paid: • 40% in the month of sales • 60% one month after sales Overhead includes RM 650 depreciation per month and paid one month in arrears. All purchases payment to suppliers will be paid in two equal instalments.…arrow_forward02:06:01 Gold Star Rice, Limited, of Thailand exports Thai rice throughout Asia. The company grows three varieties of rice-White, Fragrant, and Loonzain. Budgeted sales by product and in total for the coming month are shown below. Produce Percentage of total sales Sales Variable expenses Contribution margin White 40% $.355,200 106,560 $ 246,640 Fragrant 20% 100% 30% 20% $29,600 140,000 118,400 Loonsain 32% 100% 80% $236.000 130,240 20% $106,560 Complete this question by entering your answers in the tabs below. Fixed expenses Net operating income Dollar sales to break-even - Fixed expenses/CM ratio-$232,440/0.52= $447,000 As shown by these data, net operating income is budgeted at $152,360 for the month and the estimated break-even sales is $447,000. Required: 1. Prepare a contribution format income statement for the month based on the actual sales data. 2. Compute the break-even point in dollar sales for the month based on your actual data. Dutal 100% 100% $ 240,000 55% 45% 355,200…arrow_forward6 Required information SB Exercise E8-5 to E8-10 [The following information applies to the questions displayed below.] Shadee Corporation expects to sell 600 sun shades in May and 350 in June. Each shade sells for $142. Shadee's beginning and ending finished goods inventories for May are 65 and 45 shades, respectively. Ending finished goods inventory for June will be 65 shades. E8-7 (Algo) Preparing Direct Labor and Manufacturing Overhead Budgets [LO 8-3d] Suppose that each shade takes three direct labor hour to produce and Shadee pays its workers $13 per hour. Additionally, Shadee's fixed manufacturing overhead is $11,000 per month, and variable manufacturing overhead is $14 per unit produced. Required: 1. Prepare Shadee's direct labor budget for May and June. ces 2. Prepare Shadee's manufacturing overhead budget for May and June. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare Shadee's direct labor budget for May and June. Note: Do not…arrow_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_forwardPROBLEM 7 (MAKE OR BUY) A company at present has been buying a component called X', used in its finished product. Purchasing cost of component X is Rs. 10 per unit. The company has a normal capacity of 40,000 machine hours, and the budgeted fixed cost for the period is Rs. 1,60,000. The sales price of finished product is Rs. 100 per unit. The detailed manufacturing cost of one unit of finished product at normal capacity is as under: Direct Material (Including Component x) Direct Labour (2 hrs. @ Rs. 8) Rs. 50.00 Rs. 16.00 Rs. 10.00 Rs. 76.00 Manufacturing Overhead Cost (1 Machine hr. @ Rs. 10) Total Direct material cost of the company includes cost of four units of component X used in the finished product. The company has been considering to manufacture its own component 'X'. The product designing department has prepared the following estimation of cost of producing one unit of component 'X'. Direct Material Rs.3.00 Direct Labour 0.25 DLH @ Rs. 8 Manufacturing Overhead 0.25 Machine…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
- 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