Question

Problem 1: Sales Budget Locksafe Company manufactures burglar-resistant commercial door locks. Recently the company began selling locks on the Web, and the company expects sales to increase dramatically compared with the prior year. For the past year, 2017, unit sales were: First quarter 23,000 units Second quarter 28,000 units Third quarter 27,000 units Fourth quarter 32,000 units Assume that total unit sales for each quarter in 2018 will be 30 percent higher than in 2017 and that the selling price per lock is $15. Prepare a sales budget (in units and dollars) by quarter for 2018. Problem 2: Production Budget Using the sales budget you prepared above for Locksafe, prepare a production budget (in units) by quarter for 2018. There are 1,300 burglar-resistant commercial door locks on hand at the start of the first quarter, and Locksafe Company desires to maintain quarterly ending inventory equal to 15 percent of next quarter's expected sales. The first quarter of 2019 has expected quarterly sales of 35,000 Problem 3: Direct Materials Purchases Budget Using the production budget you prepared above, prepare a direct materials purchases budget by quarter in 2018. Finished units of production require 6 ounces of raw material per unit. The raw material cost is $7 per ounce. There is $283,500 of raw material on hand at the beginning of the first quarter, 2018. Locksafe desires to have 15 percent of next quarter's material requirements on hand at the end of each quarter. Locksafe's production budget for the first quarter of 2019 is 15,000 units

Answer 1

1) Sales Budget of Locksafe Company for 2018

Quarters 2018	Units	Selling Price per unit	Sales Amount
First Quarter	29,900 (23,000*1.3)	$15	$448,500
Second Quarter	36,400 (28,000*1.3)	$15	546,000
Third Quarter	35,100 (27,000*1.3)	$15	526,500
Fourth Quarter	41,600 (32,000*1.3)	$15	624,000
	143,000 units	$15	$2,145,000

2) Production Budget of Locksafe Company for 2018 (In Units)

	Quarter 1	Quarter 2	Quarter 3	Quarter 4
Closing Inventory Required (15% of Next Quarter Expected Sales)	5,460	5,265	6,240	5,250
Add : Expected Sales	29,900	36,400	35,100	41,600
Less: Opening Inventory	1,300	5,460	5,265	6,240
Required Units to be Produced	34,060	36,205	36,075	40,610

3) Direct Material Purchases Budget for 2018 (in $)

	Quarter 1	Quarter 2	Quarter 3	Quarter 4
Direct Material Required for Production (Units*6 ounces *$7)	$1,430,520	1,520,610	1,515,150	1,705,620
Add :Closing Material Required (15% of Next Quarter Requirement)	228,091.5	227,272.5	255,843	94,500
Less: Opening Material	283,500	228,091.5	227,272.5	255,843
Material to be Purchased	$1,375,111.5	$1,519,791	1,543,720.5	1,544,277

Working notes :

1) Closing Material Required for Quarter 4 = 15% of  Expected Sales of Quarter 1 in 2019 *6 ounces *$ 7 per ounce

= 0.15 * (15,000 units * 6 ounces *$7)

= 0.15* $630,000 = $94,500

2) Closing Material or Inventory of Last quarter becomes the Opening Material or Inventory of Next Quarter.