Question

In: Accounting

The company produces 2 types of plastic containers, type A and B. The products have following...

The company produces 2 types of plastic containers, type A and B. The products have following expenses on labor and material

Container A Container B

Direct material per 100 containers

Plastic X ($0.2 per kg) 30 kg 70 kg

Plastic Y ($0.1 per kg) 20 kg 30 kg

Direct labour per 100 containers (12$ per hour). 0.25 hour 0.5 hour

The following overheads are planned for the next period. The predetermined rate is based on production volume of 495,000 units of each product. Manufacturing overheads are applied on the bases of direct labor hours:

Indirect material USD 10,500

Indirect labor USD 50,000

Utilities USD 25,000

Property taxes USD 18,000

Insurance USD 16,000

Depreciation USD 29,000

Total USD 148,500

The following selling and administrative expenses are planned:

Salaries USD 75,000

Advertising USD 15,000

Management salaries. USD 90,000

Other expenses USD 30,000

Below is expected level of sales:

Container A500,000 units at price USD 90 per 100 containers

Container A500,000 units at price USD 130 per 100 containers

Information on finished goods and inventory is provided below:

Expected level on Jan 1 Desired level on Dec 31

Finished goods

Container A 10,000 units 5,000 units

Container B 20,000 units 15,000 units

Raw material

Plastic X 15,000 kg 5,000 kg

Plastic Y 5,000 kg 10,000 kg

Required: Prepare master budget for the next year including income statement.

Expert Solution

MASTER BUDGET
Particulars	Container A	Container B	Computaion of total value	Total value
Expected sales unit	500000	500000	(500000/10090)+(500000/100130)	1100000
Add:Desired closing stock on December 31	5000	15000
Total	505000	515000
Less:Opening stock on January 1	10000	20000
Production units	495000	495000	Total Sales (A)	1100000
Direct material&Labour requirement per 100 container
Plastic X( A 30 Kg/B 70 kg)	148500	346500	(148500+346500)*0.2 =99000
			Add:Closing stock (5000kg*0.2) = 1000
			100000
			Less :Opening stock(15000kg*0.2) =3000
				97000
Plastic Y (A 20kg /B 30 Kg)	99000	148500	(99000+148500)*0.1 =24750
			Add:Closing stock (10000kg*0.1) = 1000
			25750
			Less :Opening stock(5000kg*0.1) =500
				25250
Direct Labour Hour (A-0.25 Hr/B-0.5 Hr)	1237.5	2475	(1237.5+2475)*12	44550
			Total Direct Cost (B)	166800
Manufacturing overhead (Applied based on labour hrs)
Indirect material 10500	3500	7000	Indirect material	10500
Indirect labour 50000	16667	33333	Indirect labour	50000
Utilities 25000	8333	16667	Utilities	25000
			Total manufaturing cost (C )	85500
			Property taxes	18000
			Insurance	16000
			Depreciation	29000
			Total fixed cost (D)	63000
			Salaries	75000
			Advertising	15000
			Management salaries	90000
			Other expense	30000
			Total selling & administration expense(E)	210000
Operating profit A-(B+C+D+E)	574700

ekkarill92 answered 1 year ago

The company Apple produces 2 types of plastic containers, type A and B. The products have...

The company Apple produces 2 types of plastic containers, type A and B. The products have following expenses on labor and material Container A Container B Direct material per 100 containers Plastic X ($0.2 per kg) 30 kg 70 kg Plastic Y ($0.1 per kg) 20 kg 30 kg Direct labour per 100 containers (12$ per hour) 0.25 hour 0.5 hour The following overheads are planned for the next period. The predetermined rate is based on production volume of 495,000...

Plastic Products Ltd Plastic Products Ltd is a company that produces and markets plastic cups, teaspoons,...

Plastic Products Ltd Plastic Products Ltd is a company that produces and markets plastic cups, teaspoons, knives and forks for the catering industry. The company was established in 1974 in response to the changes taking place in the catering industry. The growth of the fastfood sector of the market was seen as an opportunity to provide disposable eating utensils which would save on human resources and allow the speedy provision of utensils for fast customer flow. In addition, Plastic Products...

Sheldon Products produces plastic containers through a blow-molding process. The company uses process costing because its...

Sheldon Products produces plastic containers through a blow-molding process. The company uses process costing because its products are generally homogeneous and are produced in large batches. Mitchell Jackson is the controller at Sheldon Products. It is December 31, 2017, and Jackson is supervising a physical count of all the inventory on hand. He knows it will be a tough year because of a sharp decline in sales near the end of the year. In early December 2017, an earthquake struck...

Hefty Inc. produces plastic storage containers. The company makes two sizes of containers: regular (55 gallon)...

Hefty Inc. produces plastic storage containers. The company makes two sizes of containers: regular (55 gallon) and large (100 gallon). The company uses the same machinery to produce both sizes. The machinery can be run for only 2,500 hours per month. Hefty can produce 20 regular containers every hour, whereas it can only produce 8 large containers in the same amount of time. Fixed costs amount to $1,000,000 per month. Sales prices, variable costs, and monthly demand are as follows:...

Q / The National Dairy Company produces two types of milk (type A and type B),...

Q / The National Dairy Company produces two types of milk (type A and type B), each type needs three operations to complete its production (sterilization and packaging) required to design an engineering problem and complete the formulation of the question and the problem so that it includes all the required information: 1- Determine the time of manufacturing the type A product for the three manufacturing processes (sterilization, packing and packaging) so that the manufacturing time for this product is...

A company produces and sells three types of products A, B, and C. The table below...

A company produces and sells three types of products A, B, and C. The table below shows the selling price per unit and the total demand for each product type. $/unit Demand A 5 300 B 6 250 C 7 200 For this purpose, the company can commission any of 7 plants with varying costs. Furthermore, each plant has a fixed capacity (in units) regardless of the type of product made. Production costs and capacities for each of the six...

Command Company produces two types of electronic products, Product A and Product B. Electronic gaming products...

Command Company produces two types of electronic products, Product A and Product B. Electronic gaming products are hot products now and either product A or product b could be sold to keep the manufacturing facility operating a full capacity. The constraint is direct labour hours and it is insufficient to meet the combined demand for both. Both products are processed through the same production departments. The relevant information is as follows: Product A Product B Sales Price $ $250 $140...

2.) A company manufactures two types of products, A and B. The unit revenues are $2...

2.) A company manufactures two types of products, A and B. The unit revenues are $2 and $3, respectively. Two raw materials M1 and M2, used in the manufacture of the two products have daily availabilities of 4 and 6 units, respectively. One unit of A uses 1 unit of M1 and 1 unit of M2, and one unit of B uses 1 unit of M1 and 2 units of M2. a) Formulate a linear programming model and obtain the...

Plasticon manufactures plastic containers used to package a variety of liquid consumer products (such as fabric...

Plasticon manufactures plastic containers used to package a variety of liquid consumer products (such as fabric softener, cleaners, shampoo, hair spray, and liquid soap). Plasticon has received five proposals for capital investment projects. Your job is to evaluate these proposals and rank them in the order in which they should be funded. Begin your analysis by computing the average rate of return and cash payback period for each proposal. Any project that has an average rate of return of less...

THE Company produces three products, A, B, and C. The following information relates to THE Company...

THE Company produces three products, A, B, and C. The following information relates to THE Company and its three products for June: THE Company: Sales revenue .............. $700,000 Segment margin ............. $204,000 Net income ................. $169,000 Product A: Sales revenue .............. $200,000 Contribution margin ........ $104,000 Segment margin ............. $ 19,000 Product B: Variable costs ............. 30% of sales of Product B Product C: Variable costs ............. $181,000 Traceable fixed costs ...... $ 36,000 Contribution margin ........ 20% of sales...