Question

In: Accounting

The East Division of Kensic Company manufactures a vital component that is used in one of...

The East Division of Kensic Company manufactures a vital component that is used in one of Kensic’s major product lines. The East Division has been experiencing some difficulty in coordinating activities between its various departments, which has resulted in some shortages of the component at critical times. To overcome the shortages, the manager of East Division has decided to initiate a monthly budgeting system that is integrated between departments. The first budget is to be for the second quarter of the current year (April, May and June). To assist in developing the budget figures, the divisional controller has accumulated the following information.Sales: Sales through the first three months of the current year were 30,000 units. Actual sales in units for January, February, and March, and planned sales in units over the next five months, are given below: January (actual) 6,000 February (actual) 10,000 March (actual) 14,000 April (planned) 20,000 May (planned) 34,000 June (planned) 51,000 July (planned) 45,000 August (planned) 30,000 In total, the East Division expects to produce and sell 250,000 units during the current year. Direct Material: Two different materials are used in production of the component. Data regarding these materials are given below: Units of Direct Cost Direct Materials per per Inventory at Material Finished Component lb/ft March 31: No. 208 4 pounds $5.00 46,000 poundsNo. 311 9 feet 2.00 69,000 feetMaterial No. 208 is sometimes in short supply. Therefore, the East Division requires that enough of the material be on hand at the end of each month to provide for 50% of the following month’s production needs. Material No. 311 is easier to get, so only one-third of the following month’s production needs must be on hand at the end of each month. Direct Labor: The East Division has three department through which the components must past before they are completed. Information relating to direct labor in these departments is given below: Direct Labor-Hours Cost per Per Finished Direct Department Component Labor-HourShaping .25 $18.00 Assembly .70 16.00 Finishing .10 20.00 Direct labor is adjusted to the workload each month. Manufacturing Overhead: East Division manufactured 32,000 components during the first three months of the current year. The actual variable overhead costs incurred during this three-month period are shown below. Each Division’s controller believes that the variable overhead costs incurred during the last nine months of the year will be at the same rate per component as experienced during the first three months. Utilities $ 57,000 Indirect Labor 31,000 Supplies 16,000 Other 8,000 Total variable overhead $112,000. The East Division has planned fixed manufacturing overhead costs for the entire year as follows: Supervision $ 872,000 Property Taxes 143,000 Depreciation 2,910,000 Insurance 631,000 Other 72,000 Total fixed manufacturing Overhead $4,628,000 Finished Goods Inventory: The desired monthly ending inventory of completed components is 20% of the next month’s estimated sales. The East Division has 4,000 units in the finished goods inventory on March 31. Selling and Administrative Expenses: Selling and Administrative Expenses are budgeted at $400,000 per month plus 1% of total credit sales for the month. REQUIRED: 1. Prepare a production budget for the East Division for the second quarter ending June 30. Show computations by month and in total for the quarter.(5 pts.) _____ 2. Prepare a direct materials purchases budget in units and dollars for each type of material for the second quarter ending June 30. Again show computations by month and in total for the quarter.(5 pts.) _____ 3. Prepare a schedule of cash payments for direct materials for the second quarter. Assume that all direct materials are purchased on account and the East Division pays for ½ of the amount purchased in the month of purchase and the other ½ in the month following the purchase. The balance in the Accounts Payable account at 3/31 was $351,200. (5 pts.)____

Solutions

Expert Solution

PRODUCTION BUDGET( MONTH WISE)

ALL AMOUNT(IN $) QTR=APR+MAY+JUNE

PARTICULARS APRIL MAY JUNE
SALES(UNITS) 20,000 34000 51000
+ CLOSING INVENTORY 6800(20% *34000) 10,200(20%*51,000) 9000(45,000*20%)
- OPENING INVENTORY 4000 6800

10,200

TOTAL PRODUCTION= SALES+CLOSING INENTORY-OPENING INVENTORY

PRODUCTION BUDGET 22800 37400 49800 1,10,00( QTR)

DIRECT MATERIAL PRODUCTION BUDGET(208)

PARTICULARS APRIL MAY JUNE

TOTAL(QTR)

UNITS PRODUCED 22800 37400 49800 110000
MATERIAL REQUIRMENT(GIVEN) 4 4 4 4
TOTAL REQ 91200 149600 199200 440000
+ CLOSING(50% OF EST PROD) 74800 99600 83600 258000
-OPENING INV 45600 74800 99600 220000
TOTAL MAT REQD (A) 120400 174400 183200 478000

TOTAL COST OF DIRECT MATERIAL

(A)* 5

602000 872000 916000 2390000

DIRECT MATERIAL PRODUCTION BUDGET(311)

PARTICULARS APRIL MAY JUNE TOTAL(QTR)
UNITS PRODUCED 22800 37400 49800 110000
MAT REQUIREMENT(GIVEN) 9 9 9 9
TOTAL REQ. 205200 336600 448200 990000
+CLOSING STOCK(1/3 OF NEXT MONTH) 112200 149400 125400 387000
- OPENING STOCK 68400 112200 149400 330000
TOTAL MAT REQD 249000 373800 424200 1047000
PRICE 2 2 2 2
TOTAL COST 498000 747600 848400 2094000

SCHEDULE OF CASH

PARTICULARS APRIL MAY JUNE TOTAL(QTR)
BALANCE 351200 725600 809800
APRIL 351200*1/2+1100000*1/2=725600

MAY

725600+1619600*1/2=1535400
JUNE
809800+1764400*1/2=1692000
TOTAL 725600 809800 882200

Related Solutions

The East Division of Kensic Company manufactures a vital component that is used in one of...
The East Division of Kensic Company manufactures a vital component that is used in one of Kensic’s major product lines. The East Division has been experiencing some difficulty in coordinating activities between its various departments, which has resulted in some shortages of the component at critical times. To overcome the shortages, the manager of East Division has decided to initiate a monthly budgeting system that is integrated between departments. The first budget is to be for the second quarter of...
The East Division of Kensic Company manufactures a vital component that is used in one of...
The East Division of Kensic Company manufactures a vital component that is used in one of Kensic’s major product lines. The East Division has been experiencing some difficulty in coordinating activities between its various departments, which has resulted in some shortages of the component at critical times. To overcome the shortages, the manager of East Division has decided to initiate a monthly budgeting system that is integrated between departments. The first budget is to be for the second quarter of...
The East Division of Kensic Company manufactures a vital component that is used in one of...
The East Division of Kensic Company manufactures a vital component that is used in one of Kensic's major product lines. The East Division has been experiencing some difficulty in coordinating activities between its various departments, which has resulted in some shortages of the component at critical times. To overcome the shortages, the manager of East Division has decided to initiate a monthly budgeting system that is integrated between departments. The first budget is to be for the second quarter of...
The East Division of Kensic Company manufactures a vital component that is used in one of...
The East Division of Kensic Company manufactures a vital component that is used in one of Kensic’s major product lines. The East Division has been experiencing some difficulty in coordinating activities between its various departments, which has resulted in some shortages of the component at critical times. To overcome the shortages, the manager of East Division has decided to initiate a monthly budgeting system that is integrated between departments. The first budget is to be for the second quarter of...
The East Division of K Company manufactures a component that is vital to the health care...
The East Division of K Company manufactures a component that is vital to the health care Industry. This Division has been experiencing some problems in coordinating activities between various departments which resulted in acute and embarrassing shortages in the industry in the past. The division‘s Manager in an effort to avoid future shortages has decided to reinforce the decision to have monthly budgets prepared to aid in the production process. To assist in preparing the second Quarter’s budgets, the Financial...
Problem 9-23 Integrated Operating Budgets [LO2] The Western Division of Keltic Company manufactures a vital component...
Problem 9-23 Integrated Operating Budgets [LO2] The Western Division of Keltic Company manufactures a vital component that is used in one of Keltic’s major product lines. The Western Division has been experiencing some difficulty in coordinating activities among its various departments, which has resulted in some shortages of the component at critical times. To overcome the shortages, the manager of the Western Division has decided to initiate a monthly budgeting system that is integrated among departments.      The first budget is...
Johnny C. has two divisions. East division sells a component (L689) to West division. West then...
Johnny C. has two divisions. East division sells a component (L689) to West division. West then assembles a product, CAGE, using L689 and sells it to customers. East division incurs $50 of variable cost per unit of L689 and allocates $80 of fixed cost to each unit. East’s factory has limited space, so every unit of L689 it produces means one less unit of L690 is made. While L689 is only sold to West division, East division sells L690 to...
The Molding Division of Cotwold Company manufactures a plastic casing used by the Assembly Division.
The Molding Division of Cotwold Company manufactures a plastic casing used by the Assembly Division. This casing is also sold to external customers for $29 per unit. Variable costs for the casing are $16 per unit and fixed cost is $4 per unit. Cotwold executives would like for the Molding Division to transfer 12,000 units to the Assembly Division at a price of $20 per unit. Assume that the Molding Division has enough excess capacity to accommodate the request.   Required:1. ...
Division S produces a component that is used by Division B. Division S’s costs of manufacturing...
Division S produces a component that is used by Division B. Division S’s costs of manufacturing the component is: Direct materials $30;Direct labor $8; Variable overhead $10; Fixed overhead $12 (based on a practical volume of 250,000 components). Division S also incurs these costs: fixed selling & administrative $1,200,000, and variable selling $4/unit. Division S expects to sell only 200,000 components next year. The variable selling expenses are avoidable if the component is sold internally. Division B has been buying...
DC Inc. has two production divisions. Division A produces Component X, which is used by Division...
DC Inc. has two production divisions. Division A produces Component X, which is used by Division B. To Division A, the cost of producing one unit of X consists of unit direct material cost of $100, unit direct labor cost of $130, unit variable overhead of $125, and unit fixed overhead of $48 at the current production volume. The current market price of X is $500 per unit. The company is now trying to determine the transfer price of X....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT