Required information Problem 9-31 Production and Direct-Labor Budgets, Activity-

Question

Required information Problem 9-31 Production and Direct-Labor Budgets, Activity-Based Overhead Budget (LO 9-3, 9-4, 9-5, 9- 6) [The following information applies to the questions displayed belowj Spiffy Shades Corporation manufactures artistic frames for sunglasses. Talia Demarest, controller, is responsible for preparing the company's master budget. In compiling the budget data for 20x1, Demarest has learned that new automated production equipment will be installed on March 1. This will reduce the direct labor per frame from 4.0 hours to 3.75 hours Labor-related costs include pension contributions of $1.30 per hour, workers' compensation insurance of $1.00 per hour employee medical insurance of $4 per hour, and employer contributions to Social Security equal to 700 percent of direct labor wages. The cost of employee benefits paid by the company on its employees is treated as a direct-labor cost. Spiffy Shades Corporation has a labor contract that calls for a wage increase to $1700 per hour on April 1, 20x1. Management expects to have 21,800 frames on hand at December 31, 20x0, and has a policy of carrying an end-of-month inventory of 100 percent of the following month's sales plus 40 percent of the second following month's sales These and other data compiled by Demarest are summarized in the following table anuaryFebruary 4.0 April 3.75 March May Direct-labor hours per unit Wage per direct-labor hour Estimated unit sales Sales price per unit Production overhead 4.0 3.75 3.75 $15.00 15.0 15.00 $ 17.00 17.00 13,000 $68.00 65.50 65.50 $ 65.50 65.50 15,000 17,000 14,000 14,000 Shipping and handling (per unit sold) Purchasing, material handling, and inspection $ 3.00 3.00 3.00 $ 3.00 3.00 (per unit produced) $.4.00 $. 4.00 $ 7.00 7.00 4.00 $. 4.00 $. 4.00 7.00 $ 7.00 7.00 Other production overhead (per direct-labor hour Problem 9-31 Part 1 Required 1. Prepare a production budget and a direct-labor budget for Spiffy Shades Corporation by month and for the first quarter of 20x1 Round "Direct-labor hours per unit" to 2 decimal places.)

Explanation / Answer

Month January february march Quarter Sales (Units) 15000 17000 13000 45000 Add: Closing Stock 22200 18600 19600 19600 17000+(40%*13000) 13000+(40%*14000) 14000+(40%*14000) Total needs 37200 35600 32600 64600 less: opening Stock 21800 22200 18600 21800 Units To be produced 15400 13400 14000 42800 Direct labour Hours per Unit 4 4 3.75 Total Hours of Dirct labour time needed 61600 53600 52500 167700 15400*4 13400*4 14000*3.75 Direct Labour Costs Total Direct Labour hours 61600 53600 52500 167700 Wages $15 per hour $                 9,24,000.00 $               8,04,000.00 $                   7,87,500.00 $ 25,15,500.00 61600*15 53600*15 52500*15 pension Contribution $1.3 per hour $                    80,080.00 $                   69,680.00 $                      68,250.00 $    2,18,010.00 61600*1.3 53600*1.3 52500*1.3 Workers compensation insurance $1.0 per hour $                    61,600.00 $                   53,600.00 $                      52,500.00 $    1,67,700.00 61600*1 53600*1 52500*1 Employee medical insurance $4 per hour $                 2,46,400.00 $               2,14,400.00 $                   2,10,000.00 $    6,70,800.00 61600*4 53600*4 52500*4 Employers Social Security 7% Wages $                    64,680.00 $                   56,280.00 $                      55,125.00 $    1,76,085.00 924000*7% 804000*7% 787500*7% Total Direct labour cost $              13,76,760.00 $             11,97,960.00 $                11,73,375.00 $ 37,48,095.00

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.