Question

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, prepare the master budget for TV tables only for the quarter ending 31th December 2018.

You are required to prepare the master budget for TV tables only, hence any costs that are shared with the other products should be ignored.

Homework Answers

Answer #1

Answer: - From the given information, master budget for TV tables only for the quarter ending 31st December 2018 is as follows: If sales commission is removed, contribution will be increased as 3000 + 3000 + 2250 = 8250. Breakeven point (BEP) = Fixed cost + 40,000 (Increase in salaries) / combined p/v ratio = 24545. BEP will reduce and so overall profit will increase. (2) Contribution per unit = 8,97,350 / 960 = 944.50. Breakeven point = Fixed cost / contribution percent = 60,000 + 10,000 + 500 + 10,000 + 10,000 / 944.50 = 95000 / 944.50 = 100.58 units.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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...
Rafique Inc. makes product A and sells at selling price of SAR 45 per unit. Badr...
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...
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...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales The Marketing Department, projects sales to: increase by 5% in January      February sales will be 15,000 units less than January March sales will be 3% higher than February sales April sales will be the 5,300 units less than march The price is not expected to increase JC inventory policy is to maintain an ending inventory equals to 30% of next month...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales The Marketing Department, projects sales to: increase by 5% in January      February sales will be 15,000 units less than January March sales will be 3% higher than February sales April sales will be the 5,300 units less than march The price is not expected to increase JC inventory policy is to maintain an ending inventory equals to 30% of next month...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit...
JC Floor Design makes ceramic tiles December sales were: 500,000 units Selling price $2 per unit 1,000,000 total sales The Marketing Department, projects sales to: increase by 5% in January      February sales will be 15,000 units less than January March sales will be 3% higher than February sales April sales will be the 5,300 units less than march The price is not expected to increase JC inventory policy is to maintain an ending inventory equals to 30% of next month...
You were recently hired as an assistant controller at Just Tables (JT).  JT sells one product, dining...
You were recently hired as an assistant controller at Just Tables (JT).  JT sells one product, dining room tables made out of red cedar.  You have been charged with preparing a cash budget for the second quarter (April to June) so that management can be aware of any financing requirements.  You have collected the following information to assist you in preparation of the quarterly budget: Recent and forecasted sales in units are as follows: January (actual)                                           140 February (actual)                                         220 March (actual)                                             200 April                                                           220 May                                                            400 June                                                           360...
Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells...
Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells a single product for $20 a unit.  Sales are 25% cash and 75% credit.  The credit sales are collected 30% in the month of the sale and the remaining 70% is collected in the next month.  No credit sales occurred in December 2008. The December 31 inventory of finished goods is 15,000 units and projected sales are 20,000, 55000, 65,000, 75,000, and 85,000 units for the first  months...
The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and...
The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 8,900, 20,000, 22,000, and 23,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month’s unit sales. The ending raw materials inventory equals 10% of the following month’s raw materials production needs. Each unit of...
The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and...
The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 8,900, 20,000, 22,000, and 23,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month’s unit sales. The ending raw materials inventory equals 10% of the following month’s raw materials production needs. Each unit of...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT