Question

In: Accounting

Financial Information: TV tables dining Tables Chairs Selling Price per unit SAR 1,000 SAR 5,000 SAR...

Financial Information:

TV tables

dining Tables

Chairs

Selling Price per unit

SAR 1,000

SAR 5,000

SAR 700

Direct Materials cost per 1 Kg of wood timber

SAR 50

SAR 50

SAR 50

Kg of wood timber required per unit

10

35

5

Direct Labour hour cost

SAR 30

SAR 30

SAR 30

Sales commission per item sold

SAR 10

SAR 15

SAR 5

Variable manufacturing overhead per unit

SAR 20

SAR 24

SAR 18

Number of labour hours per unit

3

4

2

Budgeted sales in units

300

200

450

Additional Information:

Other costs:

Production manager annual salary SAR 60,000

Annual marketing costs SAR 10,000- related to TV tables

General Expenses SAR 5,000

Annual Fixed manufacturing overhead (excluding depreciation) SAR10,000 (20% relates to TV tables)

Annual equipment depreciation SAR 10,000

The company had 8 TV tables and 100 kg of wood timber in stock at the end of September.

Company policy is to maintain 20% of the following months sales level as closing inventory for finished goods.

Company policy to maintain 25% of next months’ production needs as closing inventory for direct materials.

Budgeted sales of TV tables for the next six months are as follows:

October

November

December

January

February

40

35

20

20

20

Cash collections on sales are as follows:

30% in the month of sale

70% in the month following sale

Receivables at the end of September were SAR 22,000

Cash payments on purchases are as follows:

60% in the month of purchase

40% in the following month

Payables at the end of September were SAR 6,000

The closing cash balance in September 2018 was SAR 40,000 and it is company policy to maintain cash at this level at the end of each month.

The company have access to a 4% bank loan of SAR 70,000

The company paid a dividend of SAR 40,000 in November

Cash of SAR 50,000 was invested in the company by a private investor in December.

Using the information above, calculate the following:

Which product is performing the best?

Solutions

Expert Solution

The question asked here is about the best product performer. Hence we will be making a comparison of the contribution from each product category. A business objective is to maximise the profit and hence the product with the maximum contribution will be considered as best performer. A tabular statement is hown below which says that the best performer is the dining table.

Please note that this computatikn is made with the assumption that there is no bottleneck resource.

N.B. Fixed common costs are irrelevant for this computation. Alao the collection information is not relevant

Formula Particulars Unit TV Table Dining Table Chairs
A SP SAR 1000 5000 700
B Direct material/KG SAR 50 50 50
C Wook in KG required per unit KG 10 35 5
D = B*C Direct material cost per unit SAR 500 1750 250
E Direct Labour hour cost SAR 30 30 30
F Labour hours per unit HR 3 4 2
G=E*F Direct Labour cost per unit SAR 90 120 60
H Variable manufacturing overhead per unit SAR 20 24 18
I Selling Commission per unit SAR 10 15 5
J Budgeted Sales units 300 200 450
K= D+G+H+I Variable cost per unit SAR 620 1909 333
L = A-K Contribution per unit SAR 380 3091 367
M = L*J Total contribution SAR 114000 618200 165150
N Specific fixed costs SAR 10000
O=M-N Contribution net of specific fixed cost SAR 104000 618200 165150

Related Solutions

Financial Information: TV tables dining Tables Chairs Selling Price per unit SAR 1,000 SAR 5,000 SAR...
Financial Information: TV tables dining Tables Chairs Selling Price per unit SAR 1,000 SAR 5,000 SAR 700 Direct Materials cost per 1 Kg of wood timber SAR 50 SAR 50 SAR 50 Kg of wood timber required per unit 10 35 5 Direct Labour hour cost SAR 30 SAR 30 SAR 30 Sales commission per item sold SAR 10 SAR 15 SAR 5 Variable manufacturing overhead per unit SAR 20 SAR 24 SAR 18 Number of labour hours per unit...
Fulcrum Industries manufactures dining chairs and tables. The following information is available:
Problem 2. Fulcrum Industries manufactures dining chairs and tables. The following information is available:Dining ChairsTablesTotal CostMachine setups200600$48,000Inspections250470$72,000Labor hours2,6002,400Fulcrum is considering switching from one overhead rate based on labor hours to activity-based costing. Instructions Perform the following analyses for these two components of overhead: a. Compute total machine setups and inspection costs assigned to each product, using a single overhead rate. b. Compute total machine setups and inspection costs assigned to each product, using activity-based costing. c. Comment on your findings.
Q 2?Rafique Inc. makes product A and sells at selling price of SAR 45 per unit....
Q 2?Rafique Inc. makes product A and sells at selling price of SAR 45 per unit. Badr Inc. wants to buy 5,000 units at SAR 27 per unit. Rafique Inc. has a normal capacity of 101,000 units and projected sales to regular customers this year is 92,000 units. Per unit costs traceable to the product (based on normal capacity of 92,000 units) are listed below? Direct Materials??8.1 Direct Labour?`??6.0 Variable Mfg. Overhead?6.2 Fixed mfg. overhead??4.8 Fixed administrative costs?0.8 Fixed Selling...
Q 2?Rafique Inc. makes product A and sells at selling price of SAR 45 per unit....
Q 2?Rafique Inc. makes product A and sells at selling price of SAR 45 per unit. Badr Inc. wants to buy 5,000 units at SAR 27 per unit. Rafique Inc. has a normal capacity of 101,000 units and projected sales to regular customers this year is 92,000 units. Per unit costs traceable to the product (based on normal capacity of 92,000 units) are listed below? Direct Materials??8.1 Direct Labour?`??6.0 Variable Mfg. Overhead?6.2 Fixed mfg. overhead??4.8 Fixed administrative costs?0.8 Fixed Selling...
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%.
Given: the following information Variable cost per unit = $1.25 Selling price per unit = $1.00...
Given: the following information Variable cost per unit = $1.25 Selling price per unit = $1.00 Fixed Cost/Month     = $40,000 Solve for: A.) How many units per month must be produced to break-even (Q)? Given: The following information: Variable cost per unit = $1.25 Q = Breakeven quantity units per month solved in part a . Fixed Cost/Month     = $40,000 New selling price = ?? (Solve for) Solve for: B.) What should the new selling price must be in order to make...
In 2017, X Company had the following selling price and per-unit variable cost information: Selling price...
In 2017, X Company had the following selling price and per-unit variable cost information: Selling price $172 Variable manufacuting costs 85 Variable selling and administrative costs 22 In 2017, total fixed costs were $643,000. In 2018, there are only two expected changes. Direct material costs are expected to decrease by $8 per unit, and fixed selling and administrative costs are expected to increase by $10,000. What must unit sales be in order for X Company to break even in 2018?
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs:...
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs: $200,000 Required Each of these are separate situations: What is the break-even point in total sales in dollars? How many units need to be sold to make a profit of $20,000? How many units need to be sold to make a profit of $20,000 if fixed costs increase from $200,000 to $250,000? How many units would they need to sell if they wanted to...
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs:...
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs: $200,000 Required Each of these are separate situations: What is the break-even point in total sales in dollars? How many units need to be sold to make a profit of $20,000? How many units need to be sold to make a profit of $20,000 if fixed costs increase from $200,000 to $250,000? How many units would they need to sell if they wanted to...
If the price of bananas rises from 5 SAR per kg to 15 SAR per kg,...
If the price of bananas rises from 5 SAR per kg to 15 SAR per kg, the quantity demanded decreases from 500 boxes to 450 boxes. Calculate the price elasticity of demand over this price range. Is the demand for bananas elastic or inelastic? SOLVE THE QUESTION STEP BY STEP
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT