Question

The Caribbean Industrial Producers manufactures two products, “Zinc” and” “Ply”. The following sales forecast for 2016 was decided on by the budget committee and presented to you the management accountant.

                                                     Sales forecast

Details	Zinc/units	Ply /units
December 2015	6,000	3,700
January 2016	5,500	4,000
February 2016	6,200	4,500
March 2016	5,000	5,200
April 2016	4,900	5,400
May 2016	6,400	4,800

Notes:

(i) During 2016 the company sold one unit of Zinc for $1,200 while one unit of Ply was sold for $$1,500.

(ii) To make one unit of Zinc four units of raw material BZN980 are used, while two units of raw material CZN980 are used to produce one unit of Ply.                                          .

(iii) Raw materials stock in units at the end of each month is to be held at a level equal to twenty percent (20%) of the forecasted sales for the next month.

(iv) It was decided by management that at the end of each month there should be enough finished goods stock on hand to meet fifteen (15%) of the sales for the next month.

(v) During 2016, direct raw material charge per unit was budgeted at ten percent (10%) of the unit selling price of the finished products.

Required:

For the period, January 2016 to April 2016 do the following:

1. The company’s sale budget.                                                                                 
2. The production budget for both products.                                                          
3. The direct raw materials usage budget for both products.                                   
4. The direct raw materials purchases budget.                                                        
5. Outline four advantages that can be derived from proper budgeting practices within an organization.                                                                                                                    
6. Briefly explain, using two examples what is meant by a “limiting budget factor”

Answer 1

a. Company’s sales budget

Particulars	Jan-16	Feb-16	Mar-16	Apr-16	May-16
Zinc	Ply	Zinc	Ply	Zinc	Ply	Zinc	Ply	Zinc	Ply
Sales (Units)	5500	4000	6200	4500	5000	5200	4900	5400	6400	4800
Selling price	1200	1500	1200	1500	1200	1500	1200	1500	1200	1500
Sales value	66,00,000	60,00,000	74,40,000	67,50,000	60,00,000	78,00,000	58,80,000	81,00,000	76,80,000	72,00,000

b. Production budget:

Particulars	Dec-15	Jan-16	Feb-16	Mar-16	Apr-16	May-16
Zinc	Ply	Zinc	Ply	Zinc	Ply	Zinc	Ply	Zinc	Ply	Zinc	Ply
Demand Sales (Units)	6000	3700	5500	4000	6200	4500	5000	5200	4900	5400	6400	4800
Closing Inventory (15% of next month sales)			930	675	750	780	735	810	960	720
Opening inventory			825	600	930	675	750	780	735	810
Production (units) Sales + Clog inv - Opg inv			5605	4075	6020	4605	4985	5230	5125	5310

c & d. Direct raw materials usage budget and purchases budget

	Dec-15	Jan-16	Feb-16	Mar-16	Apr-16	May-16
	Zinc	Ply	Zinc	Ply	Zinc	Ply	Zinc	Ply	Zinc	Ply	Zinc	Ply
Demand Sales (Units)	6000	3700	5500	4000	6200	4500	5000	5200	4900	5400	6400	4800
Production			5605	4075	6020	4605	4985	5230	5125	5310
Raw material BZN980
-Required for production			22420		24080		19940		20500
-Closing inventory (20% of forecasted sales req)	4400		4960		4000		3920		5120
-Opening inventory			4400		4960		4000		3920
Raw material BZN980 requirement Budget (units) –Usage budget			22980		23120		19860		21700
Raw material BZN980 requirement Budget (value @10% of 1200 = @120 per unit) –Purchases budget			2757600		2774400		2383200		2604000
Raw material CZN980
-Required for production				8150		9210		10460		10620
-Closing inventory (20% of forecasted sales req)		1600 < ekkarill92 Next > < Previous Related Solutions Forecast Sales Volume and Sales Budget Guardian Framing Inc. prepared the following sales budget for 2016:... Forecast Sales Volume and Sales Budget Guardian Framing Inc. prepared the following sales budget for 2016: Guardian Framing Inc. Sales Budget For the Year Ending December 31, 2016 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East 18,800 $23 $432,400 Central 4,900 23 112,700 West 4,500 23 103,500 Total 28,200 $648,600 12" × 16" Frame: East 12,500 $24 $300,000 Central 2,900 24 69,600 West 1,900 24 45,600 Total 17,300 $415,200 Total revenue from... Forecast Sales Volume and Sales Budget Raphael Frame Company prepared the following sales budget for 2016:... Forecast Sales Volume and Sales Budget Raphael Frame Company prepared the following sales budget for 2016: Raphael Frame Company Sales Budget For the Year Ending December 31, 2016 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East 8,500 $16 $136,000 Central 6,200 16 99,200 West 12,600 16 201,600     Total 27,300 $436,800 12" × 16" Frame: East 3,800 $30 $114,000 Central 3,000 30 90,000 West 5,400 30 162,000     Total 12,200 $366,000 Total revenue from... You own a company that manufactures beef products to sell. Your company needs to forecast sales... You own a company that manufactures beef products to sell. Your company needs to forecast sales for the next year to purchase raw materials and plan production. You collect historical data on beef consumption, consumer income, and the prices of beef. A. Your data indicates that when the price of beef was $ 2.80 per pound that you sold 80,000 pounds of beef. When the price was $ 2.20 per pound, you sold 92,000 pounds of beef. Calculate the arc... The Jersey Chemical Company manufactures two industrial chemical products, called Zanide and Kreolite. Two machines are... The Jersey Chemical Company manufactures two industrial chemical products, called Zanide and Kreolite. Two machines are used in the process, and each machine has 24 hours of capacity per day. The following data are available: Zanide Kreolite Selling price per drum $36 $42 Variable cost per drum $28 $28 Hours required per drum on machine I 2 hours 2 hours Hours required per drum on machine II 1 hour 3 hours The company can produce and sell partially full drums... Paul & Griffon manufactures and markets many products you use every day. In 2016, sales for... Paul & Griffon manufactures and markets many products you use every day. In 2016, sales for the company were $85,500 (all amounts in millions). The annual report did not report the amount of credit sales, so we will assume that all sales were on credit. The average gross profit percentage was 49.7 percent. Account balances for the year follow: Beginning Ending Accounts receivable (net) $ 6,400 $ 6,800 Inventory 7,180 7,200 Required: Compute the following turnover ratios. By dividing 365... The Electrotech Corporation manufactures two industrial-sized devices: generators and alternators. Both of these products require wiring... The Electrotech Corporation manufactures two industrial-sized devices: generators and alternators. Both of these products require wiring and testing during the assembly process. Each generator requires 2 hours of wiring and 1 hour of testing and can be sold for $250 profit. Each alternator requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next production period... Valdosta Chemical Company manufactures two industrial chemical products in a joint process. In May, 10,000 gallons... Valdosta Chemical Company manufactures two industrial chemical products in a joint process. In May, 10,000 gallons of input costing $60,000 were processed at a cost of $150,000. The joint process resulted in 8,000 pounds of Resoline and 2,000 pounds of Krypto. Resoline sells for $25 per pound, and Krypto sells for $50 per pound. Management generally processes each of these chemicals further in separable processes to produce more refined chemical products. Resoline is processed separately at a cost of $5... A company manufactures two products, P and Q. Monthly data relating to production and sales are... A company manufactures two products, P and Q. Monthly data relating to production and sales are as follows. Product P Product Q Direct materisl cost per unit $40 $50 Direct labor hours per unit 2 hours 4 hours Direct labor cost per unit $50 $100 Sales demand 200 units 900 units Production overheads are $200,000 each month and are absorbed on a direct labor hour basis. There are five main areas of activity that can be said to consume overhead... Mattison manufactures two products: A and B. The company predicts a sales volume of 20,000 units... Mattison manufactures two products: A and B. The company predicts a sales volume of 20,000 units for product A and desired ending finished-goods inventory of 1,000 units. These numbers for product B are 25,000 and 3,000, respectively. Mattison currently has 7,000 units of A in inventory and 9,000 units of B. The unit selling price for A and B are $250 and $200 respectively. The following raw materials are required to manufacture these products: Raw Material Cost Per Pound Required... Mattison manufactures two products: A and B. The company predicts a sales volume of 20,000 units... Mattison manufactures two products: A and B. The company predicts a sales volume of 20,000 units for product A and desired ending finished-goods inventory of 1,000 units. These numbers for product B are 25,000 and 3,000, respectively. Mattison currently has 7,000 units of A in inventory and 9,000 units of B. The unit selling price for A and B are $250 and $200 respectively. The following raw materials are required to manufacture these products: Raw Material Cost Per Pound Required... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions If you wanted to store a birthday within code, what class would you use in Java?... Explain what is meant by the Theme Park internal and external business environment and use the... Description Write a program that prints out your name, the course ID of this class, what... A project has an initial cost of $65,475, expected net cash inflows of $12,000 per year... Make a program that lets the user enter a positive or negative integer as many times... using java, parse a text file to be able to list the word(s) with the highest... Consider the following linear programming problem: Maximize 10X + 8Y Subject to: 40X + 24Y <=... ADVERTISEMENT About @ 2020 WizEdu