Question

In: Accounting

Q3) Level of Activity = 1,040,000 units Selling Price = PKR 20 per unit Raw Material...

Q3)

  • Level of Activity = 1,040,000 units
  • Selling Price = PKR 20 per unit
  • Raw Material Cost = PKR 8 per unit
  • Labor Cost = PKR 3 per unit
  • Overhead Cost = PKR 6 per unit
  • Raw Material in Stock = 4 weeks
  • Processing Time = 2 weeks
  • Finished Goods in stock = 3 weeks
  • Credit received from customer is 8 weeks
  • Credit received from supplier is 6 weeks
  • Delay in payment of wages is 4 weeks
  • Delay in payment of overheads is 5 weeks
  • Prepaid Expenses = PKR 20,000
  • Outstanding Expenses = PKR 50,000
  • Contingency is 5% of Gross Working Capital
  • Calculate Gross working capital , Net working capital and length of the Working Capital Cycle?

Solutions

Expert Solution

1] Estimated current assets:
Receivables = 1040000*20*8/52 = $ 32,00,000
Raw materials = 1040000*8*4/52 = $   6,40,000
WIP = 1040000*(8+3+6*50%)*2/52 = $   5,60,000
[Assumed that OH is incurred uniformly over
the processing period; hence taken at 50%]
Finished goods = 1040000*(8+3+6)*3/52 = $ 10,20,000
Prepaid expenses $ 20,000
Total current assets $ 54,40,000
Contingency 5% $   2,72,000
Gross working capital $ 57,12,000
Current liabilities:
Accounts payable = 1040000*8*6/52 = $   9,60,000
Wages payable = 1040000*3*4/52 = $   2,40,000
Overheads payable = 1040000*6*5/52 = $   6,00,000
Outstanding expenses $ 50,000
Total current liabilities $ 18,50,000
2] Net working capital [5712000-1850000] $ 38,62,000
3] Length of working capital cycle = 4+2+3+8-6 = 11 weeks

Related Solutions

Monthly Budget Data Selling price per Unit $79 per unit Raw Materials Cost $27 per unit...
Monthly Budget Data Selling price per Unit $79 per unit Raw Materials Cost $27 per unit Packaging Costs $15 per unit Electricity $4 per unit Waste and Other Costs $6 per unit Salary and Wages Costs $560,000 per month Fringe Benefits 50% of salaries Rent Costs $750,000 per month Insurance Costs $50,000 per month Depreciation Costs $370,000 per month Actual Data January February Production (Units) 245000 187000 Revenue $ 19,345,000.00 $ 14,888,000.00 Raw Materials $    6,545,000.00 $    4,996,000.00 Package Materials...
Stick Collapsible Units Sold 60,000 3,000 Selling Price $12.50 $14.00 Direct Material Cost Per Unit $3.00...
Stick Collapsible Units Sold 60,000 3,000 Selling Price $12.50 $14.00 Direct Material Cost Per Unit $3.00 $3.10 Direct Labor Cost Per Hour $7.50 $8.00 Variable MO $0.40 $0.40 Variable Selling Costs $1.10 $1.10 Labor Hours Per Unit 0.2 0.2 Sales Orders 120 1 Purchase Orders 50 3 Production Runs 45 6 Material Moves 86 10 Machine Setups 130 6 Machine Hours 525 32 Inspections 200 10 Shipments 60 3 Activity Information from Instructions Activity Activity Cost Activity Cost Driver Order...
Selling price per unit (package of 2 CDs)...................................... $20.00 Variable costs per unit: Direct material............................................................................................................... $4.00...
Selling price per unit (package of 2 CDs)...................................... $20.00 Variable costs per unit: Direct material............................................................................................................... $4.00 Direct labor...................................................................................................................... $5.00 Artist's royalties.............................................................................................................. $3.50 Manufacturing overhead.......................................................................................... $3.00 Selling expenses............................................................................................................ $1.00 Total variable costs per unit............................................................ $16.50 Annual fixed costs: Manufacturing overhead.......................................................................................... $180,000 Selling and administrative....................................................................................... $220,000 Total fixed costs................................................................................ $400,000 Forecasted annual sales volume (120,000 units)......................... $2,400,000 If the company's direct-labor costs do increase by 8%, what selling price per unit of product must it charge to maintain the same contribution margin...
CVP Analysis Data Unit sales     20,000 units Selling price per unit $60 per unit Variable...
CVP Analysis Data Unit sales     20,000 units Selling price per unit $60 per unit Variable expenses per unit $45 per unit Fixed expenses $240,000 Enter a formula into each of the cells marked with a ? below Review Problem: CVP Relationships Compute the CM ratio and variable expense ratio Selling price per unit ? per unit Variable expenses per unit ? per unit Contribution margin per unit ? per unit CM ratio ? Variable expense ratio ? Compute the...
QUESTION 11 What is the breakeven point in units with a selling price per unit of...
QUESTION 11 What is the breakeven point in units with a selling price per unit of $100, total fixed expenses of $250,000, and variable expense per unit of $50? a. 2500 units b. 7500 units c. 10,000 units d. 5000 units ---------- What inputs are used to calculate the flexible budget? a. Actual quantity X standard price b. Standard quantity allowed for actual output X Standard price c. Actual quantity X Actual price d. standard quantity X actual price -------------------...
Data 4 Unit sales 30,000 units 5 Selling price per unit $60 per unit 6 Variable...
Data 4 Unit sales 30,000 units 5 Selling price per unit $60 per unit 6 Variable expenses per unit $30 per unit 7 Fixed expenses $810,000 What is the break-even in dollar sales?        (b) What is the margin of safety percentage?        (c) What is the degree of operating leverage? (Round your answer to 2 decimal places.)        3. Using the degree of operating leverage and without changing anything in your worksheet, calculate the percentage change in net operating...
Sales per period 1,000 units Selling price $40 per unit Variable manufacturing cost $12 per unit...
Sales per period 1,000 units Selling price $40 per unit Variable manufacturing cost $12 per unit Selling expenses $5,100 plus 5% of selling price Administrative expenses $3,000 plus 20% of selling price note Note that some costs have variable components such as commissions on sales and shipping costs. The contribution margin ratio would be: A) 70%. B) 45%. C) 75%. D) 55%.
Sales (in units) 60,000 Selling price per unit $25 Manufacturing costs per unit:   Materials 5   Direct...
Sales (in units) 60,000 Selling price per unit $25 Manufacturing costs per unit:   Materials 5   Direct labor 4   Overhead         Variable 4          Fixed 6     Total $19 Gross margin 6 Selling and admin. Expenses per unit 2 Operating income $4 A company in a foreign market offer to buy and the offer specifies the following data units to be sold 10,000 price per unit $12 The incremental profit should be
Easy Breeze company produced 100,000 units, sold 90,000 units at a selling price per unit of...
Easy Breeze company produced 100,000 units, sold 90,000 units at a selling price per unit of $450, and incurred the following manufacturing costs: Direct Materials = $40 per unit Direct Labor = $18 per unit Factory overhead costs: Variable Factory Overhead = $23 per unit Fixed Factory overhead = $250,000 Semi-variable Factory overhead cost is $70,000. The company utilized 14,000 machine hours during this period. The following additional information is provided semi-variable factory overhead into variable and fixed factory overhead...
Easy Breeze company produced 100,000 units, sold 90,000 units at a selling price per unit of...
Easy Breeze company produced 100,000 units, sold 90,000 units at a selling price per unit of $450, and incurred the following manufacturing costs: Direct Materials = $40 per unit Direct Labor = $18 per unit Factory overhead costs: Variable Factory Overhead = $23 per unit Fixed Factory overhead = $250,000 Semi-variable Factory overhead cost is $70,000. The company utilized 14,000 machine hours during this period. The following additional information is provided semi-variable factory overhead into variable and fixed factory overhead...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT