Standard Cost - Action Figure We make Harry Potter action figures. They go through Cutting, Moulding, Painting, Assembly and Packing. We buy sheets of plastic weighing 20 kg. Each finished action figure weighs 400 grams but uses 500 grams of plastic, as some is lost due to splintering, shaping and shaving. [There are 1000 grams in one kg.] [Hint: Calculate how many action figures you get from one sheet.] We buy a truckload of 100 sheets of plastic for $8,000. Delivery costs are $400. Delivery cost is part of the cost of materials. Labour rate is $20 per hour in all departments, except the Moulding Dept. is $30 per hour. Cutting: Moulding: Painting: Assembly: Packing: Each 20 kg. sheet takes 30 minutes. Figures cut from 5 sheets take 2 hours in Moulding. 100 figures can be spray painted in 1 hour. We assemble 200 figures per hour. We can pack 400 figures per hour. Overhead is applied as 80% of Direct Labour cost. REQUIRED: Compute the standard cost of one Harry Potter action figure. Question #2 PLANNING 150 Budgeted Sales (units) Shirts Pants Skirts Blouses JAN FEB MAR APR 100 200 300 80 90 140 190 150 200 300 350 200 250 350 500 Current Inventory: Jan.1 [Units] Shirts 120 Pants 100 Skirts 170 Blouses 150 Target Ending Inventory of Finished goods is to be 20% of next month's sales. Raw Material Current Inventory: Jan.1 [Kg] Wool 50 Cotton 70 Silk 20 Polyester 80 Target Ending Inventory (Kg): [each month] 50 100 50 100 Raw Material usage Per unit (in kg): Shirts Pants Skirts Blouses Wool .25 45 .20 0 Cotton 0 .10 .10 .30 Silk .30 0 0 .20 Polyester .40 .05 .25 0 Material cost per kg: Cotton Wool $4.00 Silk $12.00 Polyester $2.50 $7.00 All Materials are bought in 10 kg increments. Materials are paid for 70% in the current month, 30% in the following month. Note: Save Time! Not all the Finished Goods use Silk. REQUIRED: Compute the cash to be paid out for Silk in February. Question #3 Variance Assignment Standard Cost per Backpack: 4 strips of leather @ $0.75 $3.00 6 pieces of plastic @ $0.15 $0.90 0.5 hours of labour @ $12.00/hr. $6.00 Standard Cost $9.90 During the month we purchased 5,000 strips of leather for $3,900 and 7,500 pieces of plastic for $1,050. We used 4,900 strips of leather and 7,400 pieces of plastic in the production of 1,200 backpacks Labour cost for 580 hours was $7,076. Show 2 Material Price variances for each material. ... When material is purchased (on all units purchased). ... When material is used (on all units used). Required: Calculate material price and efficiency variances (for leather and plastic separately) and labour rate and efficiency variances. [Eight calculations] HINT: You MUST calculate the SQ of leather, plastic and hours that should be used! LEATHER: MPV (on all purchased) MPV (on amount used) MEV PLASTIC: MPV (on all purchased) MPV (on amount used) MEV BACKPACKS: LRV LEV Cash Budget Assignment Question #4 Quarter 3 Prev. Yr. 4 Prev. Yr. 1 2 3 4 Sales $50,000 $60,000 $80,000 $97,000 $172,000 $195,000 Purchases $87,000 $80,000 $98,000 $82,000 $40,000 $35.000 Other information: Also see below! Repay loans only when sufficient cash is available Borrow-Multiples of 1,000 Borrow -Beginning of Q Repay-End of Q Other Cash Expenses $20,000 $25,000 $38,000 $23,000 Minimum Cash Balance Beginning Cash Balance Annual Rate 10% $20,000 $24,000 Q1 Q2 Q3 04 Total Beginning Balance Cash Collected Cash Payments Excess (deficit) Expected Balance before financing FINANCING: Loan repaid Interest on loan Bank Loan Ending Balance Cash expenses (above) are paid in the Q incurred. Sales are collected: 20% same Q, 50% next Q, 30% 2nd Q after sale. Purchases are paid 25% same Q, 75% following